CSV Import

[Zodiack]

Hey Guys!

I see some of you guys managed to get the CSV-import to work.
I have a problem with importing products. I read all the advice on this forum and tried (almost) everything, but i keep getting the message **** (ID 1) cannot be saved. Can anyone tell me what the problem might be. I've attached a sample of my CSV file here. It is for a sex-shop, so don't be scared by the words :-) Hope someone can help as I've spend the last week trying to get this to work.

Thanks in advance

\\Zodiack

DVD.csv

[Zodiack]

It seems as if I can't import anything. I managed to import the product kategories succesfully a week ago but i get this error message when I try to import the products. Even if I try to just import the name of the product it gives me this error. Is there anything except the import-folder that I need to set some special rights on?

[jhnstcks]

First thing i noticed is that you have used semi-colon as the delimiter, but you are using semi-colons in your product description, which is probabaly confusing the import tools.

You can change your delimiter by going into windows control panel>regional language and options > Customize > list separator. Change that option to the pipe, Shift+\ (its to the left of Z). The import your csv data into a new file and save it again and try the import again

[Zodiack]

Hey.

Thanks for the response but unfortunately it is still the same. It seems like the columns are build correctly with the right descriptions in them, but as soon as I press Import CSV Data it says (ID ***) cannot be saved as if it can't write to that file or something like that. At the same time below the errors it says: "Your csv-file has been imported to shop". I'm still very confused.

\\Zodiack

[gregbull]

Hi

I am getting the same error importing addresses. I got Customers to import OK, but no matter how simple I make the address.csv I get the "cannot be saved" error as well.

Can anybody please shed some light on this.

Attached is a sample file.

Thanks

test.csv

[jhnstcks]

Hi

I am getting the same error importing addresses. I got Customers to import OK, but no matter how simple I make the address.csv I get the "cannot be saved" error as well.

Can anybody please shed some light on this.

Attached is a sample file.

Thanks

Didnt have any problems uploading your test.csv file into my test site.

[cagrie]

do you carry real dolls?

just kidding ^^

[gregbull]

Hi jhnstcks

I tried importing with 1.2 and that worked fine but not with 1.1. I assume your test system is 1.1?

Could it be environmental? I read something on another post about php 5.2.0. Im using 5.2.8.

Also I noticed after my 1.2 import worked that the ID field it maps to in the database is the address_id. So, I am wondering how does the customer_id get populated in the address table so it has a customer parent record?

I might have to end up doing a database import directly.

Thanks

[jhnstcks]

I was using v1.2, obviously something changed between the 2 versions as far as importing goes.

[shalom]

hello all
i used this patch
http://www.prestashop.com/forums/viewthread/7720/general_discussion/csv_import

as gogle so kindly translated
http://translate.google.com/translate?js=n&prev=_t&hl=en&ie=UTF-8&u=http://www.prestashop.com/forums/viewthread/13096/rapports_de_bugs/patch_import_csv&sl=fr&tl=en&history;_state0=

but still
i cannot use any language other than english in csv
i get the data visible on the processs
but the end result
is
(ID [any numer] ) cannot be saved
any ideas??


importing UTF-8 encoded file
using notepad++ and scalc
plz let me know what u think
many thanks

[VIXUS]

Hi, this is how i managed to get things to work.

I created mine pricelist entire on prestas product template. All 30 fields (you can see them in BO/IMPORT then select products and in right side you will see all 30 needed fields)

I have attached sample csv with 2 products.

I set on my own product ID (if you leave blank than presta will asign you ID number, wich is not good solution if you want to update products prices, quantity or availability via CSV).

All fields that you dont need to have any data just set to ignore when importing.

I hope this helps (by the way im on 1.1 presta)

One more thing, open your CSV in notepad than chose "save as..." than chose encoding "UTF-8" and resave your CSV this way and than import wont break becouse wrong or unknown symbols.

cijene_update.csv