RO CSVI
Combining multiple fields into one in CSVI import
| RO CSVI
Required fields
- CSVI 6.0+
- VirtueMart 3.0
- Joomla 3.0+
- PHP 5.4+
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 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.
Please check Combining multiple fields into one in export to combine fields on export.
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.
Override import/export routines
| RO CSVI
Background information
An override is where you create your own routine and place it in a specific folder for RO CSVI to use. This way you can add or modify the behavior of RO CSVI when importing or exporting to suit your own needs. The system allows for great flexibility so you can write your own override import/export routines and not having to worry that by updating RO CSVI your changes are lost.
Edit a template
| RO CSVI
To edit a template in CSVI you take the following steps:
- Click on Components
- Click on CSVI Pro
- Click on Templates in the sidebar menu
- Click on Template name you want to edit
- Edit the options of Template by going to corresponding tabs.
- Click on Save or Save and Close and save the template settings.
