Proper Import Tutorial and what am i doing wrong?

[nikitas]

Hi. i'm testing prestashop and i'm having 'big' time trouble on howto to import my data from .csv files to prestashop!So
i wrote my own mini-script for importing them as 'import' does not seem to work for the following , but it's hardcoded and works as a standalone procedure using basic csv php functions etc!
So basically these are my situation-conclusions after experimenting with prestashop import module :
1.!File encoding is ANSI not ! UTF-8 .All the files of prestashop are ANSI.so if i use greek chars everything breaks!
2.this is not a server ( uploading or ftp ) issue as i'm testing it 'localhost' .
3.After changing the files from ANSI to UTF-8 the code breaks after the 1st line ( .csv line ) of products.csv file
4.After changing the files even at admin123/import/index.php etc it works but when it finishes the upload procedure
this error comes up !->

# Ασημένια κάρδια (ID 60) cannot be saved
#
# Ασημένια κάρδια (ID 61) cannot be saved
#
# Ασημένια κάρδια (ID 62) cannot be saved
#
# Ασημένια κάρδια (ID 63) cannot be saved
#
# Ασημένια κάρδια (ID 64) cannot be saved
#
# Ασημένια κιθάρα (ID 65) cannot be saved
#
# Ασημένια κοριτσάκια (ID 66) cannot be saved
#
# Ασημένια κοριτσάκια (ID 67) cannot be saved
#
# Ασημένια κοριτσάκια (ID 68) cannot be saved
#
# Ασημένια κοριτσάκια (ID 69) cannot be saved
#
# Ασημένια κοριτσάκια (ID 70) cannot be saved
#
# Ασημένια κοριτσάκια (ID 71) cannot be saved
#
# Ασημένια κοριτσάκια-αγοράκι (ID 72) cannot be saved
#
# Ασημένια μαργαρίτα (ID 73) cannot be saved
#
# Ασημένια μαργαρίτα (ID 74) cannot be saved
#
# Ασημένια μαργαρίτα (ID 75) cannot be saved
#
# Ασημενια 10 (ID 76) cannot be saved
#
# Ασημένια 10 (ID 77) cannot be saved
#
# Ασημένια 10 (ID 78) cannot be saved
#
# Ασημένια 10 (ID 79) cannot be saved
#
# Ασημένια 10 (ID 80) cannot be saved
#
# Ασημένια 10 (ID 81) cannot be saved
#
# Ασημένια 10 (ID 82) cannot be saved
#
# Ασημένια 10 (ID 83) cannot be saved
#
# Ασημένια 10 (ID 84) cannot be saved
#
# Ασημένια 10 (ID 85) cannot be saved

and then this message comes up -> !!!! The .CSV file has been imported into your shop.
but nothing happens!for once more.

Please if someone has fixed this bug let us know!as it's a very 'crucial' matter when changing eshop platforms to be able to migrate your data as easy as possible!

[Seneca]

I've had a similar problem a couple of days asgo. Try to disable all the columns you don't' inport into in the BO. Also make sure your text doesn't contain any strange characters. Try saving your .cvs file in ASCII format.
If all fails, try to enable column by column basis until you discover which columns gives errors. Of course, the mandatory column needs to be selected all the time.

[nikitas]

hi.thanx for the reply.
i've already deleted all the columns that are not used.
My text is 'probably' strange characters!!!i'm using greek as 3rd language.
I've converted all the files (.csv ) as UTF-8 using notepad++ .
do you have any other suggestions?

I'm wondering why at the end the message 'The .CSV file has been imported into your shop.' shows up after a failure?this is strange to!!!

[Seneca]

I'm sorry you haven't found the way to import your stuff.
You really need to isolate the column giving you trouble.
Try to to import to the mandatory field and one more field, one by one.
Hopefully you will be able to isolate the offending field and discover what the problem is.
As to the message at the end, the message is misleading and it should be revised in my opinion.