RO CSVI

04 December 2013 | RO CSVI

Opening a CSV file with Excel correctly is somewhat of a hassle, here is a step by step instruction on how to do it correctly.

1. Open a new workbook

2. Choose From Text

3. Select the file to open and click Import

4. Start the Text Import Wizard and make sure the settings are the same as the screenshot and click Next

5. Set the delimiters to match the ones in your file and click Next

6. Check if your columns are OK and click Finish.

For columns not showing up correctly, set the column data format to Text. This is useful for SKUs that start with 0, this way the preceding 0 is not lost.

7. Click OK to insert the file into the workbook.

8. Now you are done and you can update your data.

Read more ...

12 February 2025 | RO CSVI

To drop the last character from a field you can use the Replacement feature of RO CSVI.

Remove last character

1. Go to Replacement
2. Make a new entry with the following settings
   • Select the field you want to apply the rule to
   • Find: /(.*)([0-9])$/
   • Replace: $1
   • Type: Regular expression
   • Click on the Add icon
3. Do an import of your template

Remove several characters from the end

To remove 3 characters from the end of your data you can use these steps:

1. Go to Replacement
2. Make a new entry with the following settings
   • Select the field you want to apply the rule to
   • Find: /(.*)([0-9]{3})$/
   • Replace: $1
   • Type: Regular expression
   • Click on the Add icon
3. Do an import of your template

Replace the value 3 between the curly brackets to any number to remove more or less characters

Read more ...

04 February 2012 | RO CSVI

Why?

The error message Settings not saved happens when the database tables are not correctly installed or not installed at all.

How to fix it?

1. Go to http://xx/administrator/index.php?option=com_csvivirtuemart&view=install (replace xx with your domain name)

2. Choose to do an upgrade

3. When there are no errors, you can save your Settings

Read more ...

04 February 2012 | RO CSVI

During the import of an XML file, CSVI VirtueMart can show a notice saying:

Warning: XMLReader::readInnerXml() [xmlreader.readinnerxml]: file:///myxml.xml:22: parser error : Extra content at the end of the document in \administrator\components\com_csvivirtuemart\helpers\file\import\xml.php on line 356

When this happens, it means that your XML file is not valid. Make sure that all opened tags have a closing tag.

Read more ...

27 May 2015 | RO CSVI

There are some plugins that break the functionality of CSVI.

Known plugins to break CSVI are:

• Jomsocial update
• Azrul System Mambot For Joomla
• XAJAX System Mambot For Joomla
• YT Framework plugin
• System - VM Affiliate Tracking Plugin
• shlib cache
• vmVendor

XAJAX

Here is a possible solution to fix the conflict between CSVI VirtueMart and xajax. You need to modify the xajax file following these steps:

1. Go to the folder /plugins/system/xajax.php
2. Open the file xajax.php
3. Find the line that says:
   

   $conflictingExtensions = array ();

4. Below this line add the following line:
   

   $conflictingExtensions [] = 'com_csvivirtuemart';

5. Save the file
6. CSVI VirtueMart should now work without a problem

Read more ...