25 July 2024 | RO CSVI

Step to be followed for installing RO CSVI automatically

1. Go to the extension manager
2. Select the file on your computer to install RO CSVI
3. Complete the installation by clicking on the Upload & Install
4. After finishing the installation you will see the message 'Installing component was successful'
5. RO CSVI is now ready to be used

Manual installation of RO CSVI 

In some cases automatic install of RO CSVI fails using Joomla extension manager. This section describes manual installation of RO CSVI using Joomla discover feature.

Copying the files

1. Download RO CSVI package from the download section
2. Unzip the package on your local computer
3. Unzip RO CSVI component on your local computer
4. Connect to your website using an FTP client
5. Open to the folder administrator/components on the server
6. Create a folder named com_csvi on the server
7. Open the folder com_csvi on the server
8. Copy all files and folders from administrator/components/com_csvi from your local computer to same server location.
9. Also copy the files csvi.xml and script.php to the folder administrator/components/com_csvi
10. Go back to the main folder
11. Open to the folder components on the server
12. Create a folder named com_csvi on the server
13. Open the folder com_csvi on the server
14. Open the folder components/com_csvi on your local computer
15. Copy all files and folders to the com_csvi folder on the server
16. Go back to the main folder
17. Create a folder Rocloud on the server in libraries folder
18. Open libraries/Rocloud folder on your local computer
19. Copy all files and folders from libraries/Rocloud from your local computer to same server location
20. Log in to the administrator section of your website
21. Go to System from menu and under Install section click on Discover
22. Click on the Discover button in the toolbar
23. Select RO CSVI of type Component from the list.
24. Click on the Install button in the toolbar

You can then install all plugins from RO CSVI packages using Joomla extension manager.

Read more ...

04 February 2012 | RO CSVI

To read a UTF-8 CSV file into Excel 2007, follow these steps:

1. Download the exported CSV/XLS file from your website.
2. Open Excel 2007
3. Open a new file
4. Click the Data Menu option
5. Click "From Text" button
6. Select the file you downloaded
7. Make sure "Delimited" is selected and Press Next
8. Select 65001: Unicode UTF8 and press Next
9. 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
10. Proceed to Next Step and Finish
11. Your excel file will be ready with all you data displayed correctly

Read more ...

12 February 2025 | RO CSVI

To add some custom text to the end of a field you can use the Replacement feature of RO CSVI.

Let's say you want to add FREE POSTAGE to your product description field, here is how:

1. Go to Replacement
2. Make a new entry with the following settings
   • New Old value: /$/
   • New New value: FREE POSTAGE
   • Type: Regular expression
   • Template: Select the template you use for the export
   • Field: Select the field the replacement is to be used for
   • Click on the Add icon
3. Do an export of your template

The value of FREE POSTAGE is only an example here of course, you can add any value you like to any field you like.

Read more ...

01 November 2024 | RO CSVI

Requirements

• CSVI Pro 6.0+
• Joomla 3.4.3+
• PHP 5.4

Background information

The replacement feature can be used to change data during export or before import.

Types of replacements

There are 2 types of replacements that can be done:

• Regular text
• Regular expressions

Regular text

A regular text replacement is a simple replacement where value x gets replaced with value y. For example replace NL with Netherlands. Any text found to match NL is being replaced with Netherlands.

Regular expressions

A regular expression replacement is a more advanced replacement using regular expressions. For example you can add extra text to the end of a field.

Creating replacement rules

From Components -> CSVI pro ->Templates tab -> Rules, Click New to add a new rule using replace plugin.

For example to create a rule to replacing text "NL" to "Netherlands"  in  virtuemart product description.

1. Give a descriptive name for the rule in name field
2. Select Action as Import
3. Select Plugin as CSVI Replace
4. Click on load plugin button

Find

Give here the text that CSVI needs to look for. When doing:

• A regular text replacement the text here is just plain text for example NL.
• A regular expression replacement the text here needs to be enclosed in forward slashes for example /NL/

It is possible to look for and replace multiple values in 1 replacement rule. Multiple values must be separated by a pipe symbol. When doing:

• A regular text replacement the text is only separated by a pipe symbol for example NL|DE|US
• A regular expression replacement each text is enclosed in forward slashes for example /NL/|/DE/|/US/

Replace

Give here the text CSVI needs to use for replacement for example Netherlands. Multiple values must be separated by a pipe symbol for example Netherlands|Germany|United States.

Multiple values

If your find and replace contains multiple values to look for, set this to Yes so all values will be searched for and replaced independently.

Method

Specify here if CSVI should do a regular text or a regular expression replacement

Examples

Add text at beginning of a value

This example adds the text Before to the value found

Find: /^/
Replace: Before
Method: Regular expression

Add text at the end of a value

This example adds the text After to the value found

Find: /$/
Replace: After
Method: Regular expression

Change text to lowercase

This changes the value to lowercase

Find: /(.*)/e
Replace: strtolower('\1')
Method: Regular expression

This will not work with PHP 7 and higher. CSVI 6.7.0 will have a new rule plugin that makes this possible.

Change text to uppercase

This changes the value to uppercase

Find: /(.*)/e
Replace: strtoupper('\1')
Method: Regular expression

This will not work with PHP 7 and higher. CSVI 7.0 will have a new rule plugin that makes this possible.

Change first letter to uppercase

This changes the first letter of the value to uppercase, if that letter is alphabetic

Find: /(.*)/e
Replace: ucfirst('\1')
Method: Regular expression

This will not work with PHP 7 and higher. CSVI 7.0 will have a new rule plugin that makes this possible.

Replace text

This replaces all occurences of a with aa in the value

Find: /(.*)/e
Replace: str_ireplace('a', 'aa', '\1')
Method: Regular expression

This will not work with PHP 7 and higher. CSVI 7.0 will have a new rule plugin that makes this possible.

Take part of the value

This takes the first 5 characters of the value

Find: /(.*)/e
Replace: substr('\1', 0, 5)
Method: Regular expression

This will not work with PHP 7 and higher. CSVI 7.0 will have a new rule plugin that makes this possible.

Read more ...

04 February 2012 | RO CSVI

The flexibility of Excel with CSV files is quite limited, so limited even that you cannot use your own field delimiter, text enclosure and encoding when opening a CSV file.

Read more ...