Hi Roland
I have a problem formatting fields on import ( please have a look at screenshot here attached )
Let's say I have 3 fields in csv file I want to import in virtuemart product description field ( field1, field2 and field3 in csv file )
Problem 1 : field2 has sometime a space caracter at the beginning, csvi import is suppressing them
Problem 2 : I don't see any way to add html at the beginning or at the end of the fields. I tried with multireplace rule using operation "Add before value"/"Add after value" and it's not working.
Now : how can get those fields formated please ?
Here are 2 examples following the screen shot example...
"DETECTEUR VOLUMETRIQUE PIR + CAMERA" + " GRADE 2" + "Noir" ( please note in this case " GRADE 2" has a space before )
should not be :
DETECTEUR VOLUMETRIQUE PIR + CAMERAGRADE 2Noir ( actual result )
but :
<p>DETECTEUR VOLUMETRIQUE PIR + CAMERA GRADE 2<br>Noir</p>
AND
"DETECTEUR VOLUMETRIQUE DOUBLE TECHN" + "O GRADE 2" + "Blanc"
should not be :
DETECTEUR VOLUMETRIQUE DOUBLE TECHNO GRADE 2Blanc ( actual result )
but :
<p>DETECTEUR VOLUMETRIQUE DOUBLE TECHNO GRADE 2<br>Blanc</p>
Thank you for your help !
Best Regards
Eric
- ekcsvi
- RO CSVI
- Tuesday, 11 February 2020
- Subscribe via email
Accepted Answer
Pending Moderation
Hello Eric,
How are you using these three fields for product description? Are you combining the fields field1, field2 and field3 using RO CSVI combine rule and then importing it to product description? If yes, can you post a screenshot of your combine rule?
How are you using these three fields for product description? Are you combining the fields field1, field2 and field3 using RO CSVI combine rule and then importing it to product description? If yes, can you post a screenshot of your combine rule?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello Eric,
In the Combine character field give an empty space and save the rule. Check product description field after that.
In the Combine character field give an empty space and save the rule. Check product description field after that.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hi Tharuna,
I had to set-up "Combine empty value" to Yes too
Now I get a space between the 3 fields.
example : DETECTEUR VOLUMETRIQUE PIR + CAMERA GRADE 2 Noir
... better, but this is not resolving :
Problem 1 : I still get TECHN O instead of TECHNO = not taking in account the space in the csv field
Problem 2 : How can I inject html command for example <br> = return between field2 and field3
Thank you in advance !
Eric
I had to set-up "Combine empty value" to Yes too
Now I get a space between the 3 fields.
example : DETECTEUR VOLUMETRIQUE PIR + CAMERA GRADE 2 Noir
... better, but this is not resolving :
Problem 1 : I still get TECHN O instead of TECHNO = not taking in account the space in the csv field
Problem 2 : How can I inject html command for example <br> = return between field2 and field3
Thank you in advance !
Eric
Accepted Answer
Pending Moderation
Hello Eric,
This is not clear to me, TECHN is the value of one field and O is from next field? Or they are values from same field?
1. Please load the attached patch file.
2. Create a Multi replace rule for Add after value and enter <br> in value field. Save the rule. See attached screenshot.
3. Apply the rule on field2 in template fields.
4. Run import and check.
Problem 1 : I still get TECHN O instead of TECHNO = not taking in account the space in the csv field
This is not clear to me, TECHN is the value of one field and O is from next field? Or they are values from same field?
Problem 2 : How can I inject html command for example <br> = return between field2 and field3
1. Please load the attached patch file.
2. Create a Multi replace rule for Add after value and enter <br> in value field. Save the rule. See attached screenshot.
3. Apply the rule on field2 in template fields.
4. Run import and check.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello,
Can you post me a screenshot of your template fields and how you have set the rules on the fields? Also post sample of your import file to check along with your import template XML file. To get your template XML file, in RO CSVI maintenance menu select RO CSVI in first option, backup templates on second option, select your template and download the XML file. Post the XML file to check.
Problem 1 : I still get TECHN O instead of TECHNO = not taking in account the space in the csv field
Can you post me a screenshot of your template fields and how you have set the rules on the fields? Also post sample of your import file to check along with your import template XML file. To get your template XML file, in RO CSVI maintenance menu select RO CSVI in first option, backup templates on second option, select your template and download the XML file. Post the XML file to check.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hi Tharuna
Problem 1 : I tested the Patch and it seems to work well.
Just one important remark : The rules don't apply to combined fields. Is there a way to resolve this ?
I am asking this because I need to format a lot of fields from CSV file ( +- 30 ) into the Virtuemart description field... without some formating, it is just awfull ;-)
Problem 2 : Regarding the space before some datas in field2 and before going in complicated exchanges my question is : did you tested it on your side ? I mean : if you put a space in field2 does CSVI take it in account ?
Thank you for all your efforts !
Best Regards
Eric
Problem 1 : I tested the Patch and it seems to work well.
Just one important remark : The rules don't apply to combined fields. Is there a way to resolve this ?
I am asking this because I need to format a lot of fields from CSV file ( +- 30 ) into the Virtuemart description field... without some formating, it is just awfull ;-)
Problem 2 : Regarding the space before some datas in field2 and before going in complicated exchanges my question is : did you tested it on your side ? I mean : if you put a space in field2 does CSVI take it in account ?
Thank you for all your efforts !
Best Regards
Eric
Accepted Answer
Pending Moderation
Hello Eric,
Can you share a screenshot of the rule and how it is applied on template fields?
Yes i did test this and can see the space removed in field values. I have fixed it with attached patch file. Load the patch file and check your import again.
Just one important remark : The rules don't apply to combined fields. Is there a way to resolve this ?
Can you share a screenshot of the rule and how it is applied on template fields?
Problem 2 : Regarding the space before some datas in field2 and before going in complicated exchanges my question is : did you tested it on your side ? I mean : if you put a space in field2 does CSVI take it in account ?
Yes i did test this and can see the space removed in field values. I have fixed it with attached patch file. Load the patch file and check your import again.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hi Tharuna
The last patch file is bringing other problems ...
Can how tell me how to reverse to original ? ( I am going to make another test )
Thank you
Eric
The last patch file is bringing other problems ...
Can how tell me how to reverse to original ? ( I am going to make another test )
Thank you
Eric
Accepted Answer
Pending Moderation
Hello Eric,
I have attached original file as a patch file in this post. You can load the attached patch file in the same way as you did for other patch files.
I have attached original file as a patch file in this post. You can load the attached patch file in the same way as you did for other patch files.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »