RO CSVI

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

28 July 2019 | RO CSVI

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

Read more ...

13 April 2020 | 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.

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.

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

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
13. Now go to template fields and apply the created rule on product_desc field by selecting the rule in Rules 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

Read more ...

28 July 2019 | 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 ...

28 July 2019 | 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 ...