some problems to import from csv

More
9 years 7 months ago #1975 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 ;

Please Log in to join the conversation.

More
9 years 7 months ago #1976 by Daniel
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...

Thanks
Daniel

Please Log in to join the conversation.

More
9 years 7 months ago #1977 by Paolo Bianchi
Thank you so much for the explanation. :woohoo:

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.

More
9 years 7 months ago #1979 by Daniel
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.

Thanks
Daniel

Please Log in to join the conversation.

More
9 years 7 months ago #1981 by Paolo Bianchi
I just sent the FTP data
thank you so much
;)

Please Log in to join the conversation.

More
9 years 7 months ago #2000 by Paolo Bianchi
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

Please Log in to join the conversation.

Cron Job Starts