Questions and answers

Required fields

  • CSVI 6.0+
  • VirtueMart 3.0
  • Joomla 3.0+
  • PHP 5.4+
  •  It is possible in CSVI to combine fields and export them in one field.

    As a first step of combining fields on export. Create a 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.

    create product import template

     

    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 product import template

     

    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.

    create product import template

    The final setting of template field will look like

    Template fields with rule set

    Finally do the export to get the fields combined in csv file

    create product import template

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

    Last Updated: Friday, 03 February 2017 12:57

    My Member Software

    My Member Software

    My Member Software is the downloadable open source member administration program with which Associations, Clubs, Foundations and even companies can administrate their members and is integrated in the Joomla CMS.

    You can use CSV Improved to easily import your user data into My Member Software.

    Read all about My Member Software.