some problems to import from csv
- Paolo Bianchi
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
9 years 7 months ago #1975
by Paolo Bianchi
some problems to import from csv was created by Paolo Bianchi
Hello
I purchased VDATA and I would like some clarification:
1 I have problems to import data from a csv file (delimited by "semicolon").
The import is not successful for the following fields to some empty columns. it seems that the system does not recognize or does not accept missing fields in a column (although this is not directly affected by imports and is properly delimited by ";").
2 How can I customize a field so that it appears composed of multiple fields?
Ex: the field "description_it_IT" (in the table "#_jshopping_products") should be the result of the import fields: "Brend" + space + "Article" + space + "Whidt" + / + "Height" + space + R + "Rim "
Which must be: "BRIDGESTONE BR1054 215/65 R16"
... And how can I do?
3 How can I customize a string imported so that it is modified from the original to be imported?
Ex: the "url_pattern" field
" extras.tyre-energy.de/pic_910g.jpg " => "pic_910g.jpg"
" extras.tyre-energy.de/pic_12099g.jpg " => "pic_12099g.jpg"
" cartomak.net/profilbilder/cartomak3/brid...e/potenza_re_070.jpg " => "potenza_re_070.jpg"
Etc ..
... And how can I do?
I am attaching a sample csv file to import.
Thank you
Article;Brand;Width;Height;Speed;Rim;Loadindex;Pattern;Spec;PR/RF;Demo;Dot;Extra;Quality;Vehicle;Stock;Price;Discount;EAN;IPCODE;Fuel;Wet;Noise;Decibel;C Class;URL_Pattern;Per parcel;RFT;
BR1054;BRIDGESTONE ZO;215;65;RR;16;109R;R630; ; ; ; ;fz;Summer;Light Truck;100;81;62.41;"3286340105415";01054;E;C;2;72;C2; extras.tyre-energy.de/pic_9870g.jpg;2;0 ;
BR1063;BRIDGESTONE ZO;235;45;YR;17;94 Y;RE050; ; ; ; ;wz;Summer;Passenger Car;100;70.95;62.95;"3286340106313";01063;E;C;3;74;C1; extras.tyre-energy.de/pic_910g.jpg;2;0 ;
BR1142;BRIDGESTONE ZO;235;65;RR;16;115R;R630; ; ; ; ;fz;Summer;Light Truck;40;96;63.64;"3286340114219";01142;C;E;3;73;C2; extras.tyre-energy.de/pic_9870g.jpg;1;0 ;
I purchased VDATA and I would like some clarification:
1 I have problems to import data from a csv file (delimited by "semicolon").
The import is not successful for the following fields to some empty columns. it seems that the system does not recognize or does not accept missing fields in a column (although this is not directly affected by imports and is properly delimited by ";").
2 How can I customize a field so that it appears composed of multiple fields?
Ex: the field "description_it_IT" (in the table "#_jshopping_products") should be the result of the import fields: "Brend" + space + "Article" + space + "Whidt" + / + "Height" + space + R + "Rim "
Which must be: "BRIDGESTONE BR1054 215/65 R16"
... And how can I do?
3 How can I customize a string imported so that it is modified from the original to be imported?
Ex: the "url_pattern" field
" extras.tyre-energy.de/pic_910g.jpg " => "pic_910g.jpg"
" extras.tyre-energy.de/pic_12099g.jpg " => "pic_12099g.jpg"
" cartomak.net/profilbilder/cartomak3/brid...e/potenza_re_070.jpg " => "potenza_re_070.jpg"
Etc ..
... And how can I do?
I am attaching a sample csv file to import.
Thank you
Article;Brand;Width;Height;Speed;Rim;Loadindex;Pattern;Spec;PR/RF;Demo;Dot;Extra;Quality;Vehicle;Stock;Price;Discount;EAN;IPCODE;Fuel;Wet;Noise;Decibel;C Class;URL_Pattern;Per parcel;RFT;
BR1054;BRIDGESTONE ZO;215;65;RR;16;109R;R630; ; ; ; ;fz;Summer;Light Truck;100;81;62.41;"3286340105415";01054;E;C;2;72;C2; extras.tyre-energy.de/pic_9870g.jpg;2;0 ;
BR1063;BRIDGESTONE ZO;235;45;YR;17;94 Y;RE050; ; ; ; ;wz;Summer;Passenger Car;100;70.95;62.95;"3286340106313";01063;E;C;3;74;C1; extras.tyre-energy.de/pic_910g.jpg;2;0 ;
BR1142;BRIDGESTONE ZO;235;65;RR;16;115R;R630; ; ; ; ;fz;Summer;Light Truck;40;96;63.64;"3286340114219";01142;C;E;3;73;C2; extras.tyre-energy.de/pic_9870g.jpg;1;0 ;
Please Log in to join the conversation.
9 years 7 months ago #1976
by Daniel
Thanks
Daniel
Replied by Daniel on topic some problems to import from csv
Hello Paolo,
Please find comments below:
1. Please clarify
2. Choose As defined option for the column in which you want to import this string while creating the profile and enter the following text string in the text field:
@vdLocal:1 @vdLocal:0 @vdLocal:2 @vdLocal:3 R@vdLocal:5
Where 1, 0, 2, 3, 5 are CSV Column indexes as per your CSV file
3. Choose as defined and enter the following in textfield:
@vdPhp:substr_replace($a, '', 0, strrpos($a, '/', -1)+1)
Please revert in case of any queries / concerns...
Please find comments below:
1. Please clarify
2. Choose As defined option for the column in which you want to import this string while creating the profile and enter the following text string in the text field:
@vdLocal:1 @vdLocal:0 @vdLocal:2 @vdLocal:3 R@vdLocal:5
Where 1, 0, 2, 3, 5 are CSV Column indexes as per your CSV file
3. Choose as defined and enter the following in textfield:
@vdPhp:substr_replace($a, '', 0, strrpos($a, '/', -1)+1)
Please revert in case of any queries / concerns...
Thanks
Daniel
Please Log in to join the conversation.
- Paolo Bianchi
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
9 years 7 months ago #1977
by Paolo Bianchi
Replied by Paolo Bianchi on topic some problems to import from csv
Thank you so much for the explanation. 
I try to better explain the point 1 with the example of csv I have attached.
when amount, "article", "brand" "whidth" "height", "speed" the fields are ok but the contents of the fields: "stock" "price" "EAN" who are after some empty columns is randomly filled with values that are located in other columns.
if I move the blank columns beyond the column EAN the imported content is correct.

I try to better explain the point 1 with the example of csv I have attached.
when amount, "article", "brand" "whidth" "height", "speed" the fields are ok but the contents of the fields: "stock" "price" "EAN" who are after some empty columns is randomly filled with values that are located in other columns.
if I move the blank columns beyond the column EAN the imported content is correct.

Please Log in to join the conversation.
9 years 7 months ago #1979
by Daniel
Thanks
Daniel
Replied by Daniel on topic some problems to import from csv
Hello Paolo,
It should work correctly. Have you made the required changes in Configuration for CSV file settings? If you have done this and still It's not working. Please share your FTP & Backend login credentials via Contact us form, We'll look into it.
It should work correctly. Have you made the required changes in Configuration for CSV file settings? If you have done this and still It's not working. Please share your FTP & Backend login credentials via Contact us form, We'll look into it.
Thanks
Daniel
Please Log in to join the conversation.
- Paolo Bianchi
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
9 years 7 months ago #1981
by Paolo Bianchi
Replied by Paolo Bianchi on topic some problems to import from csv
I just sent the FTP data
thank you so much
thank you so much

Please Log in to join the conversation.
- Paolo Bianchi
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
9 years 7 months ago #2000
by Paolo Bianchi
Replied by Paolo Bianchi on topic some problems to import from csv
Hello
I sent you the data that you're asking, but I have not received any answer yet.
you need any more information?
Thank you
Paolo
I sent you the data that you're asking, but I have not received any answer yet.
you need any more information?
Thank you
Paolo
Please Log in to join the conversation.