Importing CSV file. Descriptions truncates at certain characters

[rgwhitaker]

I'm trying to import a CSV file. I'm using a Products csv import file.

 

In my long description column, my descriptions have characters like apostrophes ('), quotes ("), etc. Whenever the import comes to those characters, the description truncates at that point.

 

Why is that and is there a workaround?

Edited September 13, 2014 by rgwhitaker (see edit history)

[Branoo]

I'm trying to import a CSV file. I'm using a Products csv import file.

 

In my long description column, my descriptions have characters like apostrophes ('), quotes ("), etc. Whenever the import comes to those characters, the description truncates at that point.

 

Why is that and is there a workaround?

 

You can read about PS import here

PrestShop import uses quotes (")  as text or "someother purpose" separator.

 

However, I had a try to import long description with "" and '' and it worked for me.

 

Also get Notepad++ it helps a lot.

 

Create a NEW csv file, as I've found out that sample csv file from PS is corrupted or something and its not Encoded in UTF-8 and that gave me lots of trouble till I found out.

 

 

This is my structure (after checked and a bit modified in N++)

ID;Reference;Description
1;12345678;"<p>""I'm trying to import a CSV file. I'm using a Products csv import file.""</p><p>In my <b>"long description column"</b> my descriptions </p><p>have characters like apostrophes ('), quotes ("), etc.</p><p>"Whenever the import comes to those characters, the description truncates at that point."</p><p>Why is that and is there a workaround?</p>

The above code worked for me.

 

ID = its an ID# assign by presta database

Reference = its my product number, and all my csv imports are based on this number

Description = text

 

In description field, you can use html code. You can see that it starts with the quote and it end with the quote. I had to put double quote in first paragraph as it wont take and show single (strange). Than I could put single quote anywhere a wanted.

 

I highly recommend to use Notepad++, as you can check for hidden characters or formatting in csv (xls). My first csv for this test was in csv and had in it something that didnt work well.

 

Hope it helps.

[rgwhitaker]

Thanks. I've downloaded Notepad++ and will start using that.

 

It's strange but I've always had trouble when using certain characters. For example, I have code in my long description like the following:

 

<p>It can be fun to customize your own sign! So, we've given you options  to customize your sign...

 

And here is what I get in PS backoffice for the item description:

 

<p>It can be fun to customize your own sign! So, we

 

And it always cuts it off where the apostrophe appears. I've have this problem before when using measurements here in the U.S. For example, if I have something like:

 

Sign measures 6'W x 3'H.

 

The description in PS back office would appear as:

 

Sign measures 6

 

And it would truncate at the apostrophe.

 

Strange.

[Branoo]

Have you tried the code above? How did you go?