RO CSVI

Replacement: remove last character

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

Settings not saved

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

Extra content at the end of the document

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

Conflict with plugins

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

MySQL server has gone away

| RO CSVI

The error MySQL server has gone away is a bad configuration setting on the server. The first work-around that can be tried is the following:

  1. Open the file administrator/components/com_csvi/csvi.php
  2. Find line 12 where the following code is:

    defined('_JEXEC') or die;

    // Access check.

  3. Change this to read:

    defined('_JEXEC') or die;

    ini_set('mysql.connect_timeout', 300);
    ini_set('default_socket_timeout', 300);

    // Access check.

  4. Save the file

A second work-around to try is the following (this is a Joomla core hack !):

  1. Open the file administrator/index.php
  2. Find line 14 where the following code is:

    // Set flag that this is a parent file
    define( '_JEXEC', 1 );

    define('JPATH_BASE', dirname(__FILE__) );

  3. Change this to read:

    // Set flag that this is a parent file
    define( '_JEXEC', 1 );

    ini_set('mysql.connect_timeout', 300);
    ini_set('default_socket_timeout', 300);

    define('JPATH_BASE', dirname(__FILE__) );

  4. Save the file
In case the error stays, contact your hosting provider to solve the issue.

Read more ...