RO CSVI
How to enable updates in RO CSVI?
| RO CSVI
Updating CSVI is easy using Joomla installer.
Getting the Download ID
The first thing to get is the download ID. You can get the Download ID by following these steps:
- Log in to the website https://rolandd.com
- After you have logged in, click the My Subscriptions link
- You will then find the Download ID for each subscription
Setting up the Download ID
With the Download ID, go to your website and follow these steps:
- Go to Components -> and click on RO CSVI
- You are now on the dashboard
- Click on the Options icon in the toolbar
- You can fill in the Download ID
- Click on Save & Close
- The Download ID is now set
Updating CSVI
You can now update CSVI using the Joomla updater. Go to Joomla Extensions Menu >> Manage. Click on update on the left sidebar. New versions of RO CSVI will be listed here if available.
Select the RO CSVI extension from the list and click on update button on top left corner.
If needed, click on the Find update Button to get the latest information.
After the update has finished you can return to RO CSVI.
Save a CSV file as UTF-8
| RO CSVI
Often it is almost impossible to know if your CSV file has been encoded as UTF-8. Programs cannot tell you for certain because there is no setting in the file that contains this information. The closest to come to determining a file's encoding is an educated guess or ask the person who created the file. Usually the person creating the file doesn't know either. All is lost then? Not really, you can create your own file and save it with a known encoding.
The choice of spreadsheet in this case is OpenOffice or LibreOffice. If you use Excel to do all your work in, you are out of luck as Excel has no option for enforcing an encoding when saving a file as CSV. This does not mean you can no longer use Excel but when saving the file for CSV open your Excel file with OpenOffice or LibreOffice.
Start OpenOffice/LibreOffice
In this example I will be using LibreOffice (the screens are the same for OpenOffice).
Open the file
Click on Open and select the file on your computer that you want to save as UTF-8 encoded file.
Save the file
We are not going to use CTRL-S to quickly save the file but we choose File -> Save As (CTRL-SHIFT-S) and then you get this screen:
There are a few things that are important:
- Give your file a name
- Save as type must be set to Text CSV (.csv)
- You must enable the Edit filter settings
After that is done click on Save.
Setting the filter settings
After you have clicked on Save, LibreOffice will ask you what settings you want to use for the file.
The character set must be set to Unicode (UTF-8) as this is what we want to achieve, a UTF-8 encoded file.
The field and text delimiter you can set as you wish or leave it as it is, all other settings can be left unchanged.
After that is done, click on OK.
You now have a UTF-8 encoded file.
Use of Group by and Sort by fields
| RO CSVI
Required fields
- CSVI Pro 6.0+
- Joomla 2.5 /3.x
When an export template is created, in the fields tab, there are two options Group by and Sort by fields that can be set. Here we will explain what is the use and how to use them
Group by Fields
Often when we do exporting data from database tables, there is always chance of seeing duplicate rows getting exported. By setting group by fields this can be avoided. Say for example, if we are exporting Virtuemart product and we need unique product name to be exported, simply by setting the product_name field in group by field will do the trick.
Also, grouping will be done in the order of fields added. In this example first grouping will be done using product_name and then with the retrieved result again grouping will be done with the second field, here it is category_id and so on.
Multiple fields can be added/deleted by clicking "+/-" next to each field. Dont forget to save the fields by clciking Save button.
Please note that in case you want to group on a field which you do not want to include in export, add the field to the template, set it to unpublished so the field is not included in export file. After that you can select the field here to group on that field.
Sort by Fields
Not only we can group by data but we can even sort them as required. Sort by will sort string type fields in alphabetical order and by default in number type fields in ascending order. It depends on type of field added for sorting.
For example, in Virtuemart product export template to sort by product_name and product_price simply add the fields as shown. Multiple fields can be added/deleted by clicking "+/-" next to each field
Same like groupby, sorting is also done based on the order of fields added. As per the example here Sorting is first done using product_name field and the result will be again sorted using product_price fields and so on.
Source tab option to Load from computer
| RO CSVI
The option to load import file from user computer. This option of selecting the import file can be seen after selecting the import template from RO CSVI Import page. The selected file content is then shown in Import preview page and thereafter used for import.
Install the example templates for RO CSVI addons
| RO CSVI
Follow these 3 steps to install the example templates for RO CSVI addons. This will give you all the example templates for installed addons. These example templates can be used to test your import and export routines. The example templates can also be used for starting to build your own templates.