RO CSVI
Combining multiple fields into one in RO CSVI export
| RO CSVI
It is possible in RO CSVI to combine fields and export them in one field.
As a first step of combining fields on export. Create an RO CSVI export template. This document explains on combining VirtueMart product fields product_sku, product_name and product_price. The same should be followed for other exports.
Say for example we need product_sku, product_name and product_price fields combined so the output looks like AB123-Product1-12.00 in product_name field. Add all these three fields to template fields.
Create a combine rule to export
No setup a combine rule to combine product_sku, product_name and product_price fields.
Give a name to the rule say Export combine rule
Select the operation as Export
The plugin to select is CSVI Field Combine
Source fields should be the fields we need to combine product_sku, product_name and product_price
Target field will be product_name as we need all these fields to be combined and exported to product_name field
Save the rule
Apply the rule on product_name field in template fields.
The final setting of template field will look like
Finally do the export to get the fields combined in csv file
VirtueMart Product import template Images tab
| RO CSVI
These options are used to import product images with various processing on them. Each one of the options are explained
Combining multiple fields into one in RO CSVI import
| RO CSVI
RO CSVI has a core available field combine which can be used as a template field so to combine more than two fields in to one.
The process is same as a normal import. First step is to create a import template in RO CSVI. The documentation talks about VirtueMart product import as example. The same should be followed for other imports.
Make sure that Use file for configuration option is set to No in import template settings on File tab. This setting will tell CSVI to not to use import file columns headers but follow the template fields added for the template. Don't forget to save the template.
Example data
"product_sku";"product_s_desc";"field1";"field2"
"AB123";"Product 1";" and some more 1";" more 2"
"CD456";"Product 2";" and some more 2";" more 3"
Please note that field1 and field2 are example names. It is not a must that column headers should have these names
Setting up the template fields
The next step is to add template fields. Say we are going to combine two fields with product short description field in VirtueMart. So add the template fields like explained
The fields which are to be combined has to be added in sequential order. The final template fields will look like below
Adding combine rule
Next step is that we add a combine rule to combine all the fields and set the rule on product_s_desc field in template fields.
Once rule is set on product_s_desc field, a wand image will be shown next to the field pointing that field has a rule.
Import process
Final process is to import the records. If everything is setup properly, import preview will show product_s_desc field combined with other two fields. If import preview fails to show product_s_desc field as expected then check the settings before continuing on import.
VirtueMart Product import template Options tab
| RO CSVI
The options tab in import template has extension specific filter field to be used on import. The list of fields and their functionality are explained.
RO CSVI Import template details tab
| RO CSVI
An import template has many tabs with various fields and functionalities. Here we explain the fields of the first tab, the details tab and the functionality of each field.