RO CSVI

29 January 2016 | RO CSVI

Requirements

• CSVI 6.0+
• Joomla 3.0+

This article will explain on how to set watermark for images during import. This option is available for Virtuemart product/media and Hikashop product imports.

While editing a import template, look for tab name Image in the edit template setting.

At the bottom of the page check for Watermark title. If you dont see this option, make sure that Process image is set to Yes in General options in the same Image tab.

Now setup information needed for watermarking.

• Set Watermark option to Yes
• Right and bottom margin as required
• Select image used for watermarking

Now save the import template and your watermark settings are saved for the import template.

Run the import and you can see the product and category images has been watermarked in the given path.

Read more ...

17 June 2019 | RO CSVI

A front-end template allows you to run an export from the menu or via a link.

Export via a menu item

To make a template show up in your menu, you can create a regular menu item and users can use this link to execute a template. First you will need to create an export template in CSVI, otherwise the menu won't know there is a template. How to create a template is explained in the Create a template tutorial.

The template settings need to look like this to be able to use it for a menu item:

These conditions apply to use a template for front-end export:

• The template must be enabled
• Enable front-end/cron must be enabled
• A secret key must be set

1. Go to Menus -> Manage
2. Click on New to create a new menu item
3. Enter a Menu Title
4. Select the Menu Item Type Export front-end by clicking on the Select button
   
5. Select the template you want to use for the menu item
   
6. Enter the secret key. This is required to prevent templates to be executed without authorization.
   
7. Set any other settings you would like to apply, for example a specific usergroup that is only allowed to use the menu item. When all done, the settings will look like this:
   
8. Save the menu item

 The menu item will now show up on the front-end if the user has the correct permissions.

 Export via a link

It is also possible to run an export via a link, this way the export doesn't have to be visible in the menu. The link can actually be seen in the menu item above as this will be the same link.

The link looks like this:
http://www.example.com/index.php?option=com_csvi&view=export&csvi_template_id=121&exportto=template&task=export&tmpl=component&key=abcd

The link has 3 important parts:

• csvi_template_id
  This is the ID of the template you want to use. This number can be found when you edit the template
• exportto
  This sets the location where the exported file should be sent to. By default this is template, meaning the settings in the template will be used. Other options are:
  • tofront
    Show the export result in the browser
  • todownload
    Download the export file
• key
  This needs to be the same as the secret key set in the template

Styling the output

In case you have chosen to export the type HTML on the Options page, CSV Improved will render an HTML table. This table has no styling at all, however you can add your own CSS file and style the page as you wish.

Create a CSS file called exporttable.css and place it in the folder media/com_csvi/css and this file will be loaded when the table is rendered.

Override template settings

It is possible to override options you have in your template to make the export more flexible. Each option must begin with form_ and then followed by the name of the option. For example to set a specific order number in the HikaShop export, the URL will look like this:
http://www.example.com/index.php?option=com_csvi&view=export&csvi_template_id=121&exportto=template&task=export&tmpl=component&key=abcd&form_orderlist=15

This will export only order ID 15.

Read more ...

07 July 2026 | RO CSVI

Updating RO 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:

1. Log in to the website https://rolandd.com
2. After you have logged in, click the My Subscriptions link
3. You will then find the Download ID for each subscription. Copy the Download ID from here.
   

Setting up the Download ID

With the Download ID, go to your website and follow these steps:

1. Login to the backend of Joomla
2. Go to System
3. Under Update click on Update Sites
4. Look for RO CSVI in the list
5. Click on the title RO CSVI
6. You can enter your download key
7. Save the changes

Updating RO CSVI

You can now update RO CSVI using the Joomla updater.

1. Go to System
2. Under Update click on Extensions
3. Click on Check for Updates button in toolbar
4. You should now see RO CSVI in the list
5. Select RO CSVI and click on Update
6. Your RO CSVI should now be updated by Joomla.

After the update has finished you can return to RO CSVI.

Read more ...

15 January 2025 | 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.

Read more ...

16 August 2023 | 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.

Read more ...