Combining multiple fields into one in CSVI import

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.

    create product import template

    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.

    Use file for configuration setting

    Example data


    "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

    setting up combine fields

    The fields which are to be combined has to be added in sequential order. The final template fields will look like below

    Use file for configuration setting


    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.

    setting up combine rule

    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.

    Use file for configuration setting

    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.

    setting up combine rule

    Please check Combining multiple fields into one in export to combine fields on export.