RO CSVI

Replacing line breaks in RO CSVI Exports

| RO CSVI

Often we get into a problem of having line breaks in export. This mostly happens in VirtueMart export and when exporting product_desc or product_s_desc field. It is possible to remove these line breaks RO CSVI multi replace plugin. This document explains on replacing line breaks in RO CSVI Exports.

At first, create a export template using the following steps.

  1. Go to Components -> CSVI Pro -> Templates
  2. Click New
  3. Give the template a name, say for example VirtueMart Product export
  4. Set Action to Export
  5. Set Component to VirtueMart
  6. Set Operation to Product
  7. Click Next: Select Destination
  8. Destination is set default to Download.
  9. Click Next: Select options
  10. The default values are OK, change if needed.
  11. Click Next: Select fields
  12. Add the fields to be exported
  13. Click Next: Finalize
  14. All done here
  15. Click Close to return to the list of templates or Edit if you want to fine-tune the template further.

 

Replacing line breaks in RO CSVI Exports - create export template

 

Add template fields for the export template, for our example we are exporting product_sku, product_name and product_desc fields.

Template fields can be added by following these steps:

  1. Go to Components -> CSVI Pro -> Templates
  2. Click on Template fields
  3. In the Search Tools select your template
  4. Click on New to add a single field or click on Quick Add to add multiple fields.

Quick Add

The Quick Add Option allows you to quickly add multiple fields to a template. It is not possible to set any settings per field here but that can be done after the fields have been added to the template.

Replacing line breaks in RO CSVI Exports - create export template fields

 Now say when you do the product export, product_desc field data is exported like below image when rule is not applied.

Replacing line breaks in RO CSVI Exports - create multi replace rule

 

Create a multi replace rule for replacing line breaks to space in Rules page and apply it on product_desc in template fields page.

  1. Go to Components -> CSVI Pro -> Templates
  2. Click on Rules
  3. Click New
  4. Give a name to the Rule
  5. Select Action as Export
  6. Select Plugin as Multireplace
  7. Click Load plugin button
  8. Save the rule before continuing further
  9. Since we are creating a find and replace for line breaks here, Select operation as Find and replace
  10. In the Filter part, in Find field set expression to be /\r\n/, Replace field should be a space or empty, Method to be Regular expression, Other fields can be left with default values.
  11. Save the rule
  12. Now go to template fields and apply the created rule on product_desc field by selecting the rule in Rules field.

Replacing line breaks in RO CSVI Exports - Add rule to template field 

Thats it. Run the export from CSVI export page and by selecting the export template. Your  product_desc or product_s_desc fields should be exported without line breaks like the image below

Replacing line breaks in RO CSVI Exports - result after export

Read more ...

RO CSVI import template limit tab

| RO CSVI

In some cases you may need to limit the number of records which are imported and to override some basic system limits to run the import instead of looking for the help from hosting provider. The server can and usually is setup to ignore these settings, on a dedicated server this usually can be used. The advice is not to use these settings unless you are sure they can be used on your server..

Read more ...

RO CSVI Import template fields tab

| RO CSVI

Fields tab will list all the fields added to import template from RO CSVI templates fields page. Edit template fields button will redirect to RO CSVI template fields page so to add more fields.

Read more ...

Combining multiple fields into one in CSVI export

| RO CSVI

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.

Read more ...

VirtueMart Product import template Images tab

| RO CSVI

These options are used to import product images with various processing on them. Each one of the options are explained

Read more ...