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

    More products by RolandD

    RolandD Cyber Produksi

    RCP User helps you to maintain a clean userlist by automatically deleting stale user accounts. Never logged-in user accounts are deleted automatically, old user accounts are deleted after a give time, bounce handling, white-listing user accounts you never want deleted. Customize reminder emails that are send out to users. Connected to other extensions to not delete accounts that have a forum post or order placed on your site. RCP User runs automatically via cron-job.

    Go to RCP User