RO CSVI

I want to import Joomla articles

| RO CSVI

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

Read more ...

Import XML with same node names

| 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.

vm import parent product create template

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.

vm parent product create templatefields

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

 vm import parent product run 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.

vm import child product create template

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.

vm import first child product create templatefields

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

 vm import child product run 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.

vm import second child product create template

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.

vm import second child product create templatefield

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

vm import second child product run import

More articles on this subject

Read more ...

List of Component and Operations

| 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 ...

Installation or updating of CSVI 6 Pro

| 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
Additional packages:

  • 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 ...

VirtueMart Calculation rule import Options tab

| RO CSVI

Each import has options which are specific for that import. VirtueMart Calculation rule has  its own few options.

Read more ...