RO CSVI
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:
- Go to the folder /plugins/system/xajax.php
- Open the file xajax.php
- Find the line that says:
$conflictingExtensions = array ();
- Below this line add the following line:
$conflictingExtensions [] = 'com_csvivirtuemart';
- Save the file
- CSVI VirtueMart should now work without a problem
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:
- Open the file administrator/components/com_csvi/csvi.php
- Find line 12 where the following code is:
defined('_JEXEC') or die;
// Access check.
- Change this to read:
defined('_JEXEC') or die;
ini_set('mysql.connect_timeout', 300);
ini_set('default_socket_timeout', 300);
// Access check. - Save the file
A second work-around to try is the following (this is a Joomla core hack !):
- Open the file administrator/index.php
- Find line 14 where the following code is:
// Set flag that this is a parent file
define( '_JEXEC', 1 );define('JPATH_BASE', dirname(__FILE__) );
- 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__) );
- Save the file
Does CSVI upload pictures?
| RO CSVI
No, CSVI does not upload the pictures from your computer to the server. You will have to upload the pictures.
One exception is if you import a file where the full image is a URL and you have chosen in your template to save the images on the server.
Install RO CSVI in 5 steps
| RO CSVI
Step to be followed for installing RO CSVI automatically
- Go to the extension manager
- Select the file on your computer to install RO CSVI
- Complete the installation by clicking on the Upload & Install
- After finishing the installation you will see the message 'Installing component was successful'
- RO CSVI is now ready to be used
How to read a UTF-8 CSV file in Excel 2007?
| RO CSVI
To read a UTF-8 CSV file into Excel 2007, follow these steps:
- Download the exported CSV/XLS file from your website.
- Open Excel 2007
- Open a new file
- Click the Data Menu option
- Click "From Text" button
- Select the file you downloaded
- Make sure "Delimited" is selected and Press Next
- Select 65001: Unicode UTF8 and press Next
- Check the delimiter characters that you know are in your file like Comma or Tab or whatever is in your case. You can select more than one
- Proceed to Next Step and Finish
- Your excel file will be ready with all you data displayed correctly