RO CSVI

28 July 2019 | RO CSVI

An import template has many tabs with various fields and functionalities. Here we explain the fields of the first tab, the details tab and the functionality of each field.

Read more ...

24 November 2021 | RO CSVI

Background information

An override is where you create your own routine and place it in a specific folder for RO CSVI to use. This way you can add or modify the behavior of RO CSVI when importing or exporting to suit your own needs. The system allows for great flexibility so you can write your own override import/export routines and not having to worry that by updating RO CSVI your changes are lost.

Read more ...

20 February 2020 | RO CSVI

To edit a template in CSVI you take the following steps:

1. Click on Components
2. Click on CSVI Pro
   
   
   
3. Click on Templates in the sidebar menu
4. Click on Template name you want to edit
5. Edit the options of Template by going to corresponding tabs.
6. Click on Save or Save and Close and save the template settings.

Read more ...

28 July 2019 | RO CSVI

File tab is a part of an import template and has very important settings needed for an import. Each setting of the file tab is explained.

Autodetect delimiters

is to tell RO CSVI to read the CSV file and identify the delimiters. If this option is set to No, RO CSVI gives an option to user to enter the needed delimiters.

Use file extnsion

Use file extension is to tell RO CSVI to find extension from the import file or to use specific extension. The options available are Use from file, CSV, XML, XLS and ODT.

I'm Mac

I'm Mac, the option to tell if you are working on Apple Macintosh computer. 

Use file for configuration

Use file for configuration option if set to Yes then RO CSVI to use the headers from the import file as template fields. If set to No, RO CSVI will use template fields added to the template. When a rule is applied to a template field, it is a must that this option should be set to No so that RO CSVI uses template fields and that is because RO CSVI cannot predict the column headers in users import file.

Add extra fields

Consider there are four column headers added to the import file. Use file for configuration is set to Yes. There are six template fields added to the template. To add the two extra fields to the import, we set Add extra fields option to Yes.

Skip first line

If RO CSVI need to skip the first line of the import file. This is to ignore the insertion of column headers in database.

Overwrite existing data

Overwrite existing data will update the values of records in database on import. When set to No, existing records in database will be skipped on import.

Skip new items

Skip new items if set to Yes will skip any new items found in the import file and not there in the database. New records will not be inserted with this option set to Yes.

Record name

When using XML file for import, RO CSVI needs to know the node name of the each record. This node name should be set in the Record name field. This field is used only for XML files. For example, for the XML content like below, record name will be product

<?xml version="1.0" encoding="UTF-8"?>
  <products>
   <product>
    <product_sku>NI091SH97UHYINDFAS</product_sku>
    <product_name>Nike Kaishi 2.0 Grey Sneakers</product_name>
   </product>
   <product>
    <product_sku>PU102SH00KOXINDFAS</product_sku>
    <product_name>Puma Sam Idp Navy Blue Flip Flops</product_name>
   </product>
  </products&gt

Read more ...

03 March 2024 | RO CSVI

When you uninstall RO CSVI via the Extension Manager only the files are removed but the database tables remain. The reason behind this is, if you want to update RO CSVI that you don't lose all your settings.

There may be circumstances where you need to delete the database tables as well. In that case there are 2 ways to do this:

1. Manually remove all the tables in your database that start with csvi_
2. Use the built-in option in RO CSVI to remove the tables.

Uninstall RO CSVI tables using Maintenance

The built-in option to remove the RO CSVI tables can be found in the Maintenance area.

1. Go to Components -> RO CSVI
2. Click on Maintenance
3. In the first dropdown select RO CSVI
4. In the second dropdown choose Remove CSVI tables
5. Click on Continue
6. All CSVI tables will now be removed and RO CSVI can be uninstalled via the Extension Manager

After RO CSVI has been uninstalled via the Extension Manager you will have a clean system and ready to install a fresh installation of RO CSVI.

Once the uninstallation is complete you can do an extra check to make sure the following folders are all removed:

• administrator/components/com_csvi
• components/com_csvi
• api/components/com_csvi
• plugins/csviaddon
• plugins/csviext
• plugins/csvirules

Read more ...