RO CSVI
How to collect debug information?
| RO CSVI
Why?
Debug information is very valuable information. The information gives an in-depth look into what is happening inside the program. Troubleshooting problems is made a lot easier as the programmer can see step by step what the program is doing.
How to enable debug info?
- Go to Templates -> Templates
- Click on the name of your template to Edit the template
- Select the Details tab
- Set the Enable logging to Yes.
- After you ran an import or export, you will be shown the results page and here you can find the debug log options:
These options are also available if you click on Logs in the menu. - There are 3 options available:
- Show
This will show the debug log in a popup window - Open
This will open the debug log in a new window - Download
This will download the debug log in a zip file or if the debug log is too large, it will download as a text file
- Show
- Now you have a debug log.
Import crashes and no debug log
It can happen that the import crashes and no log details are stored, the debug log is still created but need to be retrieved from the server. The debug logs are stored in the folder logs/ for CSVI 6 and tmp/com_csvi/debug for CSVI 5. Find the last created file in this folder and that will be your debug log for your last import.
Debug information collects a lot of info, it is advised not to use it with large imports, rather use a small sample of a few records.
What to do with the debug output?
Once the debug output is generated it is ready for analysis and can be posted on the forum along with the description of the problem and a sample of the import file. Make sure the debug log is zipped otherwise it cannot be uploaded.
Limiting number of lines in Debug log
Starting from RO CSVI 7.7.0 version a new feature for limiting the lines in to the debug log has been added. This feature is very helpful in case of Imports with large number of records. Instead of generating a huge debug log with entries of all records and struggling to handling the large debug log file, you can now limit the number of lines in debug log so the generated debug log is small and easy to handle in forum as well as for checking on issues.
To add the number of lines to log file, go to RO CSVI Dashboard page, click on Options button on top right corner, on Site tab set Number of lines in log file field. By default it is 20.
Checking your PHP version in Joomla
| RO CSVI
PHP 7 is nowadays the default PHP version used by hosting providers. Unfortunately, many hosting providers use older PHP 7 versions. The recommended version is PHP 7.3 or higher but often older PHP versions are still being used. You can check the versions supported by the PHP project. RO CSVI requires a minimum of PHP 7.1. Checking your PHP version in Joomla is very easy.
Fill multiple fields with one value
| RO CSVI
Requirements
- CSVI 5.0+
- VirtueMart 2.0.2
- Joomla 2.5+
- PHP 5.2+
- An existing product import template
- Basic understanding of adding fields to templates
Objective
The objective is to import 1 field from the import file into multiple destination fields. In this example we will import the product name into the fields product name and product short description.
Example data
"product_sku";"product_name"
"AB123";"Product 1"
"CD456";"Product 2"
Setting up the fields
Follow these steps to setup the fields as above:
- Select the product_sku field and click on Add
- Select the product_name field and click on Add
- Select the product_s_desc field and click on Add
Now we have all the three fields as shown in this image:
Configuring the additional destination fields
Now we need to set up the product short description to take the value from the product name as shown below:
- On the Fields tab click on the product_s_desc field to open the edit screen as shown in the image above
- At File field name fill in the field name as set in the field you want to take the value from. In this example we take it from the product_name field. If this field is empty, add the same name as chosen at Template field name. As this field is empty in the product_name field, we add the full name product_name.
- At the Template field name select from which field the product short description should take its value. We want to take the value from the product_name field, so select the product_name field.
- Click on Submit
To make sure that the import uses these settings we just created the option Use column headers as configuration must be set to No. See the settings here:
The settings are done and the file options are set now and the template is ready for import.
Subscription questions for RO CSVI
| RO CSVI
What are the benefits of a subscription?
- Quicker releases with fixes and new features
- Access to upgrades
- Access to the support forum
- Support on-going development
Can I install RO CSVI on unlimited sites?
Yes, you can.
Where can I get support?
Support is given on the forum.
How much does a subscription cost?
A subscription costs €72.95 per year. If you are extending your current active subscription you will get a 10% automatic discount.
All prices are excluding tax. Tax will be charged when applicable.
How long is a subscription valid for?
The duration of a subscription is for 1 year after which it is automatically stopped. We will send you a reminder 4 weeks and a second reminder 2 weeks before the subscription expires to inform you. Finally a last notification is send to inform you the subscription has been cancelled. In case you renew your subscription, the remaining reminders are not send.
Are upgrades free?
Upgrades are provided free of charge if you have an active subscription.
Will the program stop working when the subscription ends?
The program will continue to work however you will no longer have access to upgrades and paid member areas of the site.
Where do I buy a subscription?
Does my CSV file look correct?
| RO CSVI
Here is a checklist to check if your CSV file looks correct. Only need to answer the following two checks with yes.
-
First row is column headers
-
Second and every row after is data to import
1. First row is column headers
The first row is only mandatory when the import template has the setting use "Use column headers as configuration" enabled. However having the first row in the CSV file helps knowing what data is in the file.
TIP: always use column headers
The column headers must exist in the availablefields list and have the exact same name. It is not possible to use any other name as this will result in the message "Unsupported fields found".
When using the fields assigned to the template as configuration, then the column header names are not important. Make sure when you use this to enable "skip first line" otherwise your column header row will be imported like a product.
2. Second and every row after is data to import
Ever row after the first row contains the data to be imported. This data must be formatted according to the usage described for each field in the availablefields list.
Important is to use the correct delimiters. The data must be separated with the same delimiters as specified in the template settings. This is explained in detail in the article How to CSVI?.
Example CSV file
If your CSV file does not look like this in a spreadsheet program, you will most likely have troubles importing.
| product_sku | product_name | category_path | product_desc | product_price |
|---|---|---|---|---|
| prodsku1 | Great product 1 | Hardware/Great products | This is the first great product | 10.50 |
| prodsku2 | Great product 2 | Hardware/Great products | This is the second great product | 18.29 |
| prodsku3 | Great product 3 | Software/Great products | This is the third great product | 58.47 |
| etc. | etc. | etc. | etc. | etc. |