RO CSVI
Source tab option to Load from URL
| RO CSVI
Option to load the import file from a link. Include the link in Load from URL field.
Test URL button can be used to check if the given link is valid or not. If a link is not valid, a message shows as
If a link is valid, a message is shown as
Source tab option to Load from server
| RO CSVI
Set the absolute path of import file to load directly from server. The path will be set under Load from server field. Test Path button is used to check if the path is valid or not. This option is very useful when running the import as cron so RO CSVI can load the file automatically for cron import.
If the path is not a valid path, a message is shown as
If the path is a valid path, a message is shown as
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.
Multi replace plugin
| RO CSVI
Starting from RO CSVI 7.0 version, the RO CSVI replace plugin has been replaced by the much improved Multi replace plugin with more features. With this new rule plugin, it is possible to combine multiple conditions in a single rule.
To start, create a new rule from RO CSVI Rules page >> New
Give a name to the rule, select if it is for import or export and make sure that RO CSVI Multi replace has been selected in Plugins drop down list. Save these settings before setting up the actual rule.
Now there are various operations Multi replace rule plugin offers. We will go through them one by one.
1. Absolute Value
This operation will return absolute value (positive value) of a number. This is used mostly on negative number field which need to be shown as a positive number on import or export. For example if the value in the field is -13, applying this operation will convert this value to 13.
2. Find and Replace
This is one of the most used operation and has been inherited from old RO CSVI Replace rule plugin. As the name says it finds and replaces the text. The text to be replaced can be just a Regular text or could be a Regular expression. In case you are using regular expressions make sure to enclose your expression in delimiters. The usual delimiter is a forward slash /, for example /(\w+) (\d+), (\d+)/.
3. Find the position of the first occurrence of a substring in a string.
This operation helps you to find the position of a string inside another string. In the Find field set the string to search and in Start field set the position from where the string has to be searched. If you want to find the occurance of 'CSVI' in 'My lovely CSVI team' and 'My lovely RO Team'. This operation will return position as 11 for first string and false for second string as there is no CSVI in second string.
4. Lowercase
By setting this operation you can change the field value to all lowecase letters. For example for a string CSVI, this operation will convert it to csvi.
5. Uppercase
By setting this operation you can change the field value to all uppercase letters. For example for a string csvi, this operation will convert it to CSVI.
6. Substring
You want to retrive a part of the string then use this operation. Set the start and end position from where the part of string to be extracted. For example if you want to extract love from the string iloveicecream, in the start field set 1 and end field as 5. Note that count of string starts at 0 and not 1.
7. Uppercase First letter
If you want to convert only the first character to uppercase and not the whole string, this operation will help with that. Say if you have a string netherlands, this operation will convert it to Netherlands.
8. Add before value
You want to add some text before a value in import or export then use this operation. Say if the value is happy and you want to add I am before this value, set I am in Value field, save the rule and apply the rule on the field this value to be applied. It will output as I am happy.
9. Add after value
Use this operation to append a string to the value. For example if the value is Bad and you want it to be exported or imported as Bad guy. In the value field set guy, save the rule and apply the rule on the field the value to be applied. Your output will be Bad guy.
10. Date
Get the current date and time in the format you want. More about date formats can be found at the PHP date manual. If the Date format field is set as Y-m-d, the output will be 2019-02-08.
11. Custom date format
The previous operation will output the current date and time whereas this operation is used to convert the format of date stored in database. The best example will be Orders created date. You can change this order created date to the format you want in export.
12. Unique ID
Most of the times, you would need to generate a random string automatically. This operation will help with that. Setting this operation will generate random value like 4b3403665fea6.
13. Uppercase words.
Use this operation to uppercase all the starting letter in words in a sentence. If the sentence is like i love to eat icecream, this operation will change this to I Love To Eat Icecream.
14. Round.
Use this operation to round a value to specified decimals.
Examples:
round(5.045, 2) will be rounded to 5.05
round(3.6, 0) will be rounded to 4
round(135.79, 1) will be rounded to 135.8
15. Floor.
Use this operation to rounds the number to the nearest integer below its current value.
Examples:
floor(5.2) becomes 5
floor(8.9) becomes 8
16. Ceil.
Use this operation to round the number it to the nearest integer above its current value.
Examples:
ceil(5.2) becomes 6
ceil(8.9) becomes 9
Multiple Operations
The best of Multi replace plugin is that you can add multiple operations as one rule. Here are few examples which explains on how to use multiple rules.
1. For example you have text 'My CSVI Support' and it needs to be changed to 'My CSVI Team', Find 'Support' and Replace with 'Team'. Also add ' from Netherlands' text at the end so the full text is 'My CSVI Team from Netherlands'. Here we need two operations one using Find and Replace and other using Add after value. The rule for this will look like
2. Say if you want to convert all the letters to lowercase in the string 'MY CSVI TEAM' and then select only team from the string and then finally need to add a text at front as Super so the final text changes to 'Super team'.
Date and Custom date in Multi replace plugin
| RO CSVI
Most of the times we would need to export or import today's date or a custom format date in our export and import operations. This can be now be easily accompolished using RO CSVI Multi replace rule plugin.
Date format on export
The example here explains on how to create a rule in Multi replace plugin for exporting today's date in your exports, the same can be followed for import too.
- Create a new Multi replace rule for export
- Select Operation as Date
- Under Filter section and Date format field enter the format you want to export date, for example like d-m-Y. Check for other date formats with PHP date documentation.
- Save the rule
- Apply the rule on your export template fields.
Running an export by setting Today's date export on custom template field, an example in export file will look like below
Date format on import
An example for import using date format for field created_on in VirtueMart Product import is explained below.
1. Create VirtueMart Product import template and add created_on as one of the field in import
2. This is the preview page before applying the date rule.
3. Now create a rule using Multi replace plugin with date as operation. Add a date format to the rule.
4. Apply the rule on created_on field
5. Run the import and check the preview page.
Custom date format
It is sometimes needed to change the date format you need to import or export from or to database. Custom date format operation in RO CSVI Multi replace plugin will help you with this. The below example explains changing date format for export, the same can be followed for import too.
Custom date format for export
- Create a new Multi replace rule for export
- Select Operation as Custom date format
- Under Filter section and Date format field enter the format you want to change the date to, for example like m.d.y
- Save the rule
- Apply the rule on your export template fields.
The default date format stored in database is Y-m-d H:i:s where Y is the year, m is the month, d is the date, H is the hour, i is the minutes and s is the seconds. You can change this default format to any needed custom format in your export and in import you can change the date format in your import file to database supported format. Check for other date formats with PHP date documentation.
An example export file created by applying Custom date format rule on created_on field in VirtueMart product export is shown below
Custom date format for import
Here in this example we are explaining about using custom date format to change the format of created_on date on VirtueMart product import to database supported format Y-m-d H:i:s.
1. Create a rule using Multi replace plugin
2. Create VirtueMart Product import template and add created_on as a template field. Apply custom date rule on created_on field.
3. Run the import and check the preview page.
