RO CSVI

24 July 2017 | RO CSVI

 Are you seeing errors while importing your file and don't know what to do or how to find out whats wrong with the file? There is nothing to worry, CSVI has an amazing inbuilt tool to check the errors in import files and it is the best place to make you get aware of the problems you have with your import file. It works on both CSV and XML files.

 Analyser with CSV file

To analyse your csv file, Go to Analyser page from the side menu, select your csv file and set the number of lines to show. By default lines to show is 3, change it if needed. Click on Analyse button on top. CSVI will list out the errors if any in the Errors section else list out the records from import file. If there are no errors shown and your CSV content is displayed perfect in Analyser then your CSV file is a valid one for import. 

 Analyser with XML file

CSVI Analyser can also be used to check an XML file. To do that, Go to Analyser page from the CSVI side menu, select the XML file in File section and in the Record name set the node name of each item, say for example if its <product> node which has data of each product then set Record name as product. Change Lines to show as needed and click on Analyse button.

If in the analyser shows any non readable characters in your content as shown below then it means that your CSV file is not UTF-8 encoded and you need to convert your file to UTF-8 format. Have a look at the document Save CSV file as UTF-8 encoded to know on how save your import file as a UTF-8 encoded document.

 If the CSV file is not formatted properly and has messed up columns, the error shows up in error section

Inconsistent number of nodes in XML

If there are inconsistent number of nodes in XML file from one item to another then the Analyser would show empty columns for the missing nodes. The XML can still be imported just for the second product in this example the child fields are ignored.

More articles on this subject

Read more ...

23 March 2022 | RO CSVI

This document explains on how to import Joomla articles using RO CSVI.

Read more ...

24 July 2017 | RO CSVI

When it comes to XML file we remember nodes and it is possible that these XML files have same node names but with different node values. CSVI can read these XML files and the nodes values to import them in to the database. In this document we are going to explain with an example on how a parent product and child products defined in same node names are imported but with different values.

Consider the following XML example

<?xml version="1.0" encoding="UTF-8"?>
<products>
   <product id="1227654" product_sku="sku-23-012860">
    <description>
      <name><![CDATA[Sample product]]></name>
      <long_desc><![CDATA[Sample product description]]></long_desc>
   </description>
     <price gross="322.22" net="251.97" vat="33.0"/>
    <childs>
       <child id="3" size_name="S" product_mpn="1227654-1" weight="200">
          <stock id="1" quantity="10"/>
       </child>
       <child id="5" size_name="L"  product_sku="sku-17-C4-161" product_mpn="1227654-2" weight="600">
         <stock id="1" quantity="10"/>
      </child>
      <child id="6" size_name="XL" product_sku="sku-17-C1-161" product_mpn="1227654-3" weight="800">
         <stock id="1" quantity="15"/></child>
     </childs>
    </product>
   </products>

As per the above XML we have one parent product and two child products.  The first <child> node is for parent product details and the next two <child> nodes are for children. We need three different import templates with different template settings to import these products. Frst step is to import the parent product.

 Import parent product

1. Create an VirtueMart product import template for parent product. In the template settings, select the Component as VirtueMart, Operation as product and Action as import. Save the template. Also make sure that you set User file for configuration option on File tab to No, this option will use template fields instead of column headers in import file as fields.

2. Set the template fields according to the XML node and as shown below. Since we are going to use the first <child> node for parent we can ignore the rest of the child nodes.

3. Now go to Import page, select the parent product import template and run the import.

Import first child product

1. Create a new import template to import first child product. In the template settings, select the Component as VirtueMart, Operation as product and Action as import. Save the template. Note that the template settings are same as of parent product but the template field settings are going to be different.

2. Create template fields and set the XML nodes. We need to use the second <child> node for the first child product so we are going to set the first <child> to Skip field so CSVI ignores them during import.

3. Go to CSVI import page, select the template created for first child product and run the import.

Import second child product

1. Create VirtueMart product import template for second child product. As we did for parent and first child product in the template settings, select the Component as VirtueMart, Operation as product and Action as import. Save the template. The template field settings are going to be different from parent and first child product.

2. Create template fields so we skip the first two <child> nodes and use the third child note for the product. We are going to use Skip field for ignoring the first two child nodes and tell CSVI to use the third node.

3. Select the second child import template and Run the import from CSVI import page.

More articles on this subject

Read more ...

28 July 2019 | RO CSVI

The document lists the component and operation for each RO CSVI addons. These component and operations are needed when you create an import or export template.

Read more ...

17 December 2015 | RO CSVI

Packages

As of CSVI 6 Pro things are different because CSVI 6 is no longer focused on VirtueMart and all supported extensions are now installable plugins. Let's give an overview of how things are structured.

Main installation package contains:

• Component
  • CSVI Pro
• Plugins
  • Supported extensions
    • CSVI
    • Joomla! Categories
    • Joomla! Content
    • Joomla! Users
  • Rules
    • Combine field
    • Copy field
    • Margin calculation
    • Replacement

• Plugins
  • Supported extensions
    • Akeeba Subscriptions
    • AWO Coupon
    • Custom Filters Pro
    • EZ Realty
    • Fastseller
    • HikaShop
    • K2
    • Scroller With Tabs
    • VirtueMart
      • Related articles custom field
      • Custom Fields For All
      • Product Filter by Custom Fields

If you are using Joomla with VirtueMart you would download the Main package + VirtueMart package. In case you are using Joomla with K2, you would download the Main package + K2 package.

Update from CSVI 5

First of all, make a backup before you start.

To update CSVI 6 follow these steps:

1. Make sure you are using CSVI 5.21.2 Pro. If you are using a lower version, update to this version first. You can find your CSVI version by going to Extensions -> Extension Manager -> Manage and filter on CSVI.
2. Go to Extensions -> Extension Manager
3. Choose Manage in the sidebar menu
4. Filter the list on CSVI
5. Uninstall CSVI 5 Pro
6. Choose Install in the sidebar menu
7. Selec the tab Upload Package File
8. First install CSVI 6 Pro
9. Second install the additional packages

Installation / Update from CSVI 6

A clean installation can be done by downloading the needed packages and follow these steps:

• Login to the administrator section of your site
• Go to Extensions -> Extension Manager
• Choose the tab Upload Package File
• First install CSVI 6 Pro
• Second install the additional packages

Possible errors

• Unknown column 'csvi_setting_id'
  If you get this error something has gone wrong during the update. Now it is recommned to do a clean installation. See the Uninstall CSVI article on how to completely remove CSVI. After that is done, you can do a clean installation.
• Missing available fields
  If you are missing available fields it is best to do a clean up of the system
  
  1. Go to Components -> CSVI Pro
  2. Select Tasks from the Maintenance menu in CSVI
  3. Click on Reset and confirm that you are sure you want to reset the tasks
  4. Select Available Fields from the Maintenance menu in CSVI
  5. Click on Update
  6. Once the update has completed, CSVI has been cleaned up

Read more ...