Problem Importing .csv

[bluebolt44]

Hi all,

 

I am trying to import a .csv with 60 items in it but I cannot get it to import correctly.

 

When uploading the whole file, I manage to get the first 23 records uploaded before it stops.

When uploading the last half of rows only (30-60), none of the products import successfully.

 

The fields are all separated by semi-colons (, multiple values separated by commas (,) as per Prestashop instructions.

 

I make sure to skip line 1, I have tried both deleting and not deleting all products before import as well as making sure the rows are named correctly (e.g. Name = Name, ID = ID), I have also tried with and without ID's.

 

I have tried encasing each field in speech marks (" ") but this seems to make no difference.

 

I noticed that 2/3 of the records have the description or name missing when uploading them - I have omitted these from the file and attempted to upload again and this has still not worked. These records do not have any unusual characters or characters that are not used in other records that are showing correctly.

 

I have checked the files and they look fine when opening the .csv in notepad++ or Excel.

 

My version of PS is 1.4.7.3.

 

 

Any help would be much appreciated! Please let me know if you require anymore information.

 

Kind regards,

Bluebolt44

[helldog2004]

Could you send the .csv file?

 

FYI I stopped using prestashop import for .csv and use the prestashop manager.

It seems lots need to be changed becuase some icons are unknown to prestashop.

 

You get the questionmark (?) icon!

[MEG Venture]

Do you receive any error message when you uploaded first 23 items?

 

Do you check 23 products after import? Are they successfully imported?

 

If you can provide any error message, I can help.

[bluebolt44]

Hi,

 

Thanks for your replies and please find attached the problem .csv

 

When the file is uploaded, there is no error messages or warnings, when finished it just goes to a new page showing just the tabs at the top, from there I click "Catalog" to go see the items that have uploaded - The ones that do manage to upload, do upload successfully.

 

I tried removing ID row incase somehow it was conflicting, I tried uploading just the last 5 records, 5 random records from the bottom half of the 60 but everytime it just seems to not even spend a few seconds loading and goes straight to the page i described previously without loading (normally I can see it working in the tab at the top of my browser for 5-10 minutes before moving to the new page.

 

Also, is there any reason it does take so long (5-10 mins) to upload 60 files of which only 23 upload successfully? I would have thought of it timing out but the fact I have tried to upload a small amount of records from the bottom half of the list it seems unlikely.

 

I have tried u/l'ing with IE, FF and Chrome to no avail!

 

 

Thanks again and any more replies will be welcomed!

Bluebolt44

 

p.s. Wouldnt let me upload as a .csv so changed extension to .txt - If you change back to .csv, have checked and it still looks the same (in notepad, records appear to be across several lines but this is due to the length - In notepad++ it looks normal.

product import (semicolons).txt

[helldog2004]

On line 24 you have this sentence "Dynaudio Acoustics LS5/12A Broadcast Reference Monitor"

Try to delete the / and change it into - or something like that.

 

Let me know if it works.

BTW change all / into -

 

Cheers Helldog

[bluebolt44]

I have changed the slashes (where they are not HTML) into dashes, and changed the lines 24 and 25 to remove the slashes there also.

 

It would seem odd if that fixes it as normally the record on line 24 uploads fine, with everything intact.

Although I did manage once to get record 25 (line 26) uploaded along with the first 23, but nothing else.

 

Just uploading now and so hopefully will have good news in 10 minutes!

 

Thanks,

Bluebolt44

[bluebolt44]

Just finished uploading and it only has records 1-23 uploaded =(

[helldog2004]

Did you also delete the / in the short description and description?

 

Attention: don't delete the / for </ BR>

 

let me know if this worked out cheers helldog!

 

FYI: If you create this .csv yourself you might want to consider downloading the free-ware CSVed.

This makes perfect .csv files, which you can you use for your prestashop!

 

let me know!

Edited May 18, 2012 by helldog2004 (see edit history)

[bluebolt44]

Hi Helldog,

 

I did remove all slashes across the .csv except for the ones encased in HTML (</strong> </br>).

 

I will download CSVed now and have a look, thanks for the help.

 

Hopefully have an update soon!

Bluebolt44

[helldog2004]

Let me know if it worked out for you.

Cheers Helldog!

[bluebolt44]

Hi,

 

See the attached 2 files I made in CSVed.

csved test1.txt

csved test2.txt

 

One has everything encased in speech marks, the other does not.

Both still use the ; delimiter and , multiple value separator but still seem to only get to record 23 before failing.

 

I have just tried to upload a file csved test3.txt without the 'Image URL' column and it has successfully uploaded all 60 products.

 

My problem now is I don't want to have to sit and upload 180+ images individually, so does anyone have any ideas why that part of my file seems to be giving so much hassle?

 

Thanks,

Bluebolt44

[helldog2004]

Then I think this has to do with your database and can't add this much at once.

You might want to contact your host and ask what might cause this problem.

 

Cheers helldog!

[bluebolt44]

Prestashop is run locally on WAMPserver at the moment and so it couldn't be the host or a problem with FTP timing out.

 

Also, it doesnt make sense that when I try to upload a file with only records 40-60, none of them upload successfully when image URL column is enabled?

 

The image column is consistent throughout the file, the links are valid and there is no difference between images used in the beginning, middle or end of file so I can't understand why items 1-23 load and yet nothing else regardless of which files are included/excluded from the file.

[bluebolt44]

I just had a thought about the column "Image URL (x, y, z)".

 

Now it may be just me but record 24 has 5 images in that row, and several rows after it have quite a few as well but no item up until 23 uses more than 3 images.

 

Could it be that the prestashop is struggling to upload more than 3 images per product? I am currently uploading a new .csv with 3 or less images per product and will report back on how it goes! Possibly the filesize of the photos is causing a problem too?

 

It may be absolutely useless and come to nothing, but I would really like to find out why this is happening.

Edited May 18, 2012 by bluebolt44 (see edit history)

[helldog2004]

So do we, as I am not using Prestashop to upload my .csv files.

I personally use MagneticOne Prestashop manager (expensive though) but works perfectly.

 

But did it work after changing the.csv file to a maximum of one picture for each product?

[bluebolt44]

It did not work, I am thinking maybe the length of the fields is causing an issue so I am going to try shortening the descriptions/field length then attempt to load the records that have not been uploaded successfully.

 

I will look at the demo of prestashop manager, cheers.