Import Tutorials

Combine plugin

02 May 2015
in Import

The combine plugin let's you combine multiple fields into a single field during import.

Source fields

The source fields are the fields that CSVI needs to combine. The names to fill in here come from the template fields page. The source fieldnames must be the names that are found in the Field name column on the template fields page. Unless the name in the Field name column is called combine. In that case you need to use the name found in the Your field column.

Target field

The result of the combination of the source fields will be put into this field. This must always be a name found in the Field name column.

Example

Combine with CSV import file

Say for example we have a CSV file with the following contents.

"product_sku";"product_name";"category_path";"subcategory1";"subcategory2"
"1001";"Product 1";""Shoes";"Women";"Flipflops"
"1002";"Product 2";""Shoes";"Men";"Runners"
"1003";"Product 3";""Shoes";"Kids";"Sneakers"

We need to combine sub categories into main category_path field then the below import explains on how to acheive this combine fields in import.

Here is a list of fields of a CSV file where we combine the fourth field. Since the combine is a special field it must have a name in the Your field column.

Template fields CSV file

An example of complete import using a CSV file is shown below

Template fields CSV file

Make sure that Use file for configuration setting in template settings on File tab is set to No so CSVI reads the template fields and not the column headers of the import file.

Combine with XML import file

We have a XML file to be imported with the below structure.


<?xml version="1.0" encoding="UTF-8"?>
<products>
      <product>
          <code>1001</code>
          <titlos>Product 1</titlos>
           <category>Shoes</category>
           <subcategory1>Women</subcategory1>
           <subcategory2>Flipflops</subcategory2>
     </product>
     <product>
          <code>1002</code>
          <titlos>Product 2</titlos>
          <category>Shoes</category>
          <subcategory1>Men</subcategory1>
          <subcategory2>Runners</subcategory2>
     </product>
      <product>
          <code>1003</code>
          <titlos>Product 3</titlos>
          <category>Shoes</category>
          <subcategory1>Kids</subcategory1>
          <subcategory2>Sneakers</subcategory2>
      </product>
</products>

 

Here is a list of fields of an XML file where we combine the fourth field. XML files require that the Your field is filled with the name in the XML file, all fields here have the Your field filled with the XML path.

Template fields XML file

An example for complete XML import using combine fields is explained below

Template fields XML file

In the combine plugin we set these fields up as shown in the image here:

Setup of the combine field

Looking at the Source fields, the category_path is a regular field, so we specify it as category_path. The subcategory field here is the combine field in the template list, as you can have multiple combine fields, CSVI would not know which combine field to use. That is why the Your field must be filled for the combine field. In the Source fields we use the Your field name.

The Target field is in this case the category_path but could also be another field, as long as it is a regular field and the name appears in the Field name column.

Have a look at Combining fields on Import and Export documentation to know more on combine rule plugin.

Last Updated: Monday, 06 February 2017 10:00

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.