cancel
Showing results for 
Search instead for 
Did you mean: 

CCM Upload CSV2.0 file to Supplier Catalog fails if using " ' , ;

Former Member
0 Kudos

Hello all,

We're unable to up-load supplier catalogs using CSV2.0 format when text fields in the file contain any of the following characters: comma, semi-colon, apostrophe, quote (, ; ‘ “). While we can get around this by excluding these characters from text fields in the file, the fact is that these characters are generally present across the customer’s material master description and purchase order texts in the material masters. Apostrophes and quotes are especially numerous because they are common abbreviations for foot and inch respectively.

Has anyone encountered this problem and was able to include these characters in the CSV2.0 file upload?

Thanks in advance for your help!

Frank Heisner

Accepted Solutions (1)

Accepted Solutions (1)

masa_139
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Frank,

I often use the separator "|" or Tab(not visible).

SAP CATALOG CSV 2.0 <|>

Regards,

Masa

Former Member
0 Kudos

Hello Masa,

Thank you very much for your reply. I've subsequently tried <|> as the separator but the load still fails. Have you been successful specifically with the characters <'> and <">?

Kind regards,

Frank

Answers (1)

Answers (1)

former_member544585
Contributor
0 Kudos

Frank: you should have no problems with comma (,) and semi-colon ( - as long as these are not defined as the CSV separator. Not sure about apostrophe ('). Quote (") is a special case for CSV. Per <a href="http://help.sap.com/saphelp_ccm20/helpdata/en/e1/eddebb4b63453cbf209027e0816b8c/content.htm">SAP CSV 2.0 specification</a>, you should be aware that:

<i>If the column value contains one or more double quotes, you must place double quotes around the entire content of the column, and each double quote contained in the value must be doubled.</i>

Cheers,

Serguei

Former Member
0 Kudos

Hi Serguei,

Thank you for your comments and the link. I agree that quote (") and (') are problems. I've been to

www.creativyst.com/Doc/Articles/CSV/CSV01.htm#CSVariations

and used the the CSV to XML Converter Form link to the latest converter, and tried various suggestions from there (including double quotes), but still not successful when uploading to CCM.