special characters

[croc]

Hello,

 

is it possible by importing csv with products to have some special characters like comma (,) or slash (/) for example:

 

Glass fuse 2,5A  or  Power supply 30/5V

 

...or which characters cant be in columns, and which concrete import columns are strict for this and which not? (or is it possible anyway to fix it?)

 

Thanks for tips.

[nutxlago]

Hello,

 

is it possible by importing csv with products to have some special characters like comma (,) or slash (/) for example:

 

Glass fuse 2,5A  or  Power supply 30/5V

 

...or which characters cant be in columns, and which concrete import columns are strict for this and which not? (or is it possible anyway to fix it?)

 

Thanks for tips.

In the CSV import you can select which special characters are expected to separate values and codification. Semicolon (,) is used to separate multiple characteristics for combinations (multiple value separator), for example. Just change the characters you need (You decide the characters to act as separators to suit the imported file), test the import and check how Prestashop is showing the content in every column, before importing the data.  It is a great importer, by the way.

Edited September 12, 2014 by nutxlago (see edit history)

[croc]

Hi nutxlago,

 

so then comma (,) can be used in product name in import csv if i will change the separator from default (,) to other character?

 

If so, which can you suggest me?  (mostly characters are in use) - important are characters in head columns like (product name) and then columns with separations like (category, pics url ....) , others like (description ) -for example this one is not important strict?

 

 

(i tested and tried more versions of separators and changes, but still my database was broken somewhere, so i would like to understand it finaly )

 

Thanks

[nutxlago]

Yes, you decide. The main fact is not to use the field separator in your csv data content, except for that use.

 

• If you have a heading info first row (explaining row contents below), tell PS  CSV importer to skip 1 line.
• Select carefully the type of data to import (Categories, products, etc) on top of the CSV Importer.
• Charge the csv file modificated everytime, or PS will use the last it has in memory.
• Carefully select the identifier PS will use to add/update products. (I find "By reference" my best option)
• Try as many times as you like. "Next" button wil show you a preview of how PS is understanding your csv file data.
• If columns contains the readable data from your file, you must then match the info in the rows with top PS fields.

Edited September 12, 2014 by nutxlago (see edit history)

[croc]

Hi,

But i know the steps of importing csv, i just care and asked now about the content of the columns with using the special characters.

I men that ( is main na column separator, and (,) is default separator ot vapues lie atributes, or in categories or by picture urls, which i ca change to other separator character.

I just ment if (,) can be in product name too, while iwill use it as the value separator, or then i need fhange it.

 

Thanks

[nutxlago]

Categories is yet expecting nesting categories separated by semicolon. So,you must give PS the formatting it is asking for.

 

Here, just an appreciation: categories field is not working properly (does not recognize nested categories and ends creating all the cats right below root)

 

Check the forum Fixed Bugs in PS 1.6 there is a modified CSV importer class. I have replaced it with the new version, but does not work for me.  http://www.prestashop.com/forums/topic/351806-sticky-1609-solved-bugs/

 

Hope this helps!