RO CSVI

Margin plugin

| RO CSVI

The Margin plugin let's you set a margin to the product price (for example) and imports the new price according to the value set. 


From Components -> RO CSVI ->Templates tab -> Rules, Click New to add a new rule for margin plugin.



For example to create a rule to set 20% margin for product_price field of a virtuemart product.

  1. Give a Descriptive name for the rule in name field.
  2. Select Action as Import.
  3. Select Plugin as RO CSVI margin.
  4. Click on load plugin button.

You will now see three new fields appears

  1. Value type field to select how the margin is calculated either percentage or value.
  2. Margin field to set how much percentage or value to be added, For example here its 20.
  3. Operation type used to calculate the margin.

Example

Here is an example on how to create a rule using margin plugin for a product_price field in virtuemart.

Explanation on the fields

Value type

 Take the percentage of value or the value itself.

Margin

Value to be taken for percentage, with the example in the above screenshot, 20% is taken as margin.

Operation

The type of arithmetic operation to be used for calculating the margin. This example uses Multiplication. So for 100 as product_price, margin as 20% with the rule applied, final product_price would be 120 on import.

Comparison Operator

Compare product_price value before applying the margin.

Product price value

The value to compare product_price with. With the above settings in the screenshot, product_price is compared if it is greater than 100 before applying the margin.

Decimals

The number of decimals to be taken after the margin calculation. In this case 4 decimals are taken.

Now set this rule to template fields to use the margin plugin like below



When the fields are set with rules you can see a small fire icon next to the field name in Template fields tab.



Important Note :

  •  Make sure that  product_price (example used in this template) are added in template fields list.
  • Use file for configuration option in templates->template name->file tab set to No.

 

Now that all rules and fields are set, CSVI will automatically calculate the product_price according to the new margin set. Say here for an example the product_price in CSV file has been given as 100. While import CSVI will calculate the price and show as below.

Read more ...

Field copy plugin

| RO CSVI

The Field copy plugin let's you copy a field value to another without creating columns to repeat the values during import.

From Components -> CSVI pro ->Templates tab -> Rules, Click New to add a new rule using field copy plugin.

For example to create a rule to copy product_desc to product_s_desc field for a virtuemart product.

  1. Give a meaningful name for the rule in name field say "Virtuemart field copy product"
  2. Select Action as Import
  3. Select Plugin as CSVI field copy
  4. Click on load plugin button

You will now see two new fields appears

Source field

The source field is  the field that CSVI needs to copy from. 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. 

Target field

The target field is the one where CSVI needs to copy to. Same as the source field even this field has to come from the template fields page. This must always be a name found in the Field name column.

Example

Here is an example on how to create a rule for a field copy plugin.

Now set this rule to template fields to use the field copy plugin like below

When the fields are set with rules you can see a small fire icon next to the field name in Template fields tab.

Important Note :

  •  Make sure that both product_desc and product_s_desc (examples used in this template) are there in template fields list to use the field copy plugin.
  • Use file for configuration option in templates->template name->file tab set to No.

 

Now that all rules and fields are set, CSVI will automatically copy the value from product_desc (source field) to product_s_desc (target field).

Read more ...

Backup/Restore Templates

| RO CSVI

Backup and Restore templates

Requirements

  • CSVI 6.0+
  • Joomla 2.5+
  • PHP 5.2+

Backup Templates

CSVI provides an option of backing up your templates and restore them whenever needed. It can be done from maintainence tab, select the templates needs to be backedup and the folder path where file has to be stored, click on continue on top corner.

 

Once the Process is completed, CSVI would notify the message with the number of templates and the log information. The path and the name of the backup file name is also displayed with the message.

 

An example of backup file can be seen clicking here

Restore Templates

CSVI provides an option of restoring the templates using the file created on backup process. This helps in saving the time of creating templates again when needed. This can be accomplished using maintainence tab. Choose the XML file generated in backup process and click on continue on top corner

Once the process is complete, CSVI would notify the number of templates restored.

Read more ...

Troubleshooting export errors

| RO CSVI

Often when we export files we run into errors. Where to start looking for the cause of the issue and how to solve this?

Checkpoints

Follow these checkpoints to make sure that you have the basics right.

  1. Up-to-date Available Fields
    The list of available fields should be up-to-date before importing starts. If the field list is not up-to-date the import may fail due to missing fields. To update the list of available fields go to Maintenance -> Available Fields -> Click Update
  2. Template enabled
    If a template does not show up in the list of templates to export, the template is not enabled. Go to Templates -> Templates, find your template and click on the icon in the Enabled column or select the template and click Publish in the toolbar.
  3. Template fields enabled
    The export file is empty, this can happen when the template fields are not published. Go to Templates -> Template fields, find your template and check if the fields are enabled.
  4. Export folder writable
    CSVI writes the export data temporarily to a file on the server before it is further processed. The file is placed in the folder tmp/com_csvi/export. The webserver needs to have write access to this folder.
  5. Duplicates in the export file
    It can happen that the export file contains duplicates, this happens because of the selection that needs to be made to export all the requested fields. The solution to this is to group based on the duplicate fields. This can be done on the fields page of the template.

Read more ...

Getting started with RO CSVI

| RO CSVI

Before you start with RO CSVI it is good to know which goal you are trying to achieve. RO CSVI is a tool that has a multitude of possibilities but the basics are to import or export data.

Whether you are doing an import or an export the first step is to create a template. A template can be created in 2 different ways:

  1. Via Templates -> Templates
  2. Via Templates -> Field Mapper

Add-ons

RO CSVI can be used with a multitude of Joomla! extensions. Support for these extensions is shipped separately and as such need to be installed separately. The different add-ons can be downloaded from the Download page and then choose RO CSVI Extensions. You can download the extension you wish to use RO CSVI for from here and install it as a regular Joomla! extension.

Updating available fields

After RO CSVI and the necessary addons are installed it is a good idea to update the list of available fields. These fields are needed for making the import and export run, otherwise it might happen you end up with missing fields. Follow the steps in the Missing fields in CSVI document to make sure everything is up-to-date.

Steps to run an import or export

  1. Create a template
  2. Edit the options in the template
  3. Add the fields you wish to use to the template
  4. Run your import or export

Templates

How to create a template is explained in the Create a template tutorial.

Template fields

After a template is created fields will need to be added to the template so CSVI knows which fields to use for import/export. How to add template fields is explained in the Adding template fields tutorial.

Field Mapper

The field mapper is a tool to help you setup the basic template and the fields belonging to the template. The fieldmapper is explained in the CSVI Field Mapper tutorial.

Troubleshooting

If you have problems importing your file, have a look at the Troubleshooting import errors document.

If you have problems exporting your file, have a look at the Troubleshooting export errors document.

Read more ...

Subcategories