Conversion of an excel file into a CSV 2.0 file for uploading in CCM 2.0

[Former Member]

Hi guys,

We are downloading content from SAP R/3 into an excel spread sheet.

We are uploading this content in a CSV file 2.0 into CCM 2.0

the csv file we use today we are arming manualy because of the difference in structure between excel and CSV 2.0. We would like to be able to convert easily the excel file in a CSV file. How can one do this.

Example of our csv-file:

SAP CATALOG CSV 2.0 <,>FULL,,,,,,,,,,,,,,

DEFAULTS,ES,,,,,,,,,,,,,,

Model,,,,,,,,,,,,,,,

DataType,String_ID,String,,,,,,,,,,,,,

Characteristic,Z_COMPANY,/CCM/ID,,,,,,,,,,,,,

Characteristic,Z_DOC_TYPE,/CCM/ID,,,,,,,,,,,,,

Characteristic,Z_DATE,STRING_ID,,,,,,,,,,,,,

Characteristic,Z_SUPPLIER_ID,/CCM/ID,,,,,,,,,,,,,

Characteristic,Z_MARCA,/CCM/DESCRIPTION,,,,,,,,,,,,,

Schema,ENTEL,Z_COMPANY,Z_DOC_TYPE,Z_DATE,Z_SUPPLIER_ID,Z_MARCA,{}ENTEL,,,,,,,,,,,

Category,PRODUCTOS ENTEL,,,,{}ENTEL PRODUCTS,,,,,,,,,,

Category,A.B.G INGENIERIA S.A.,PRODUCTOS ENTEL,,{}A.B.G. INGENIERIA S.A.,,,,,,,,,,,

Content,,,,,,,,,,,,,,,

ItemValuation,parent cty,/ccm/supplier_part_no,/ccm/base_uom,/ccm/order_unit,/ccm/price[1]#/ccm/amount,/ccm/price[1]#/ccm/currency_code,Z_DOC_TYPE,/ccm/supplier_name,/ccm/contract_id,/ccm/contract_item_id,Z_MARCA,/ccm/short_description,Z_SUPPLIER_ID,/ccm/product_group,/ccm/product_id,Z_DATE,Z_COMPANY

1,A.B.G INGENIERIA S.A.#ENTEL,61,PCE,PCE,1,UF,ZSV0,A.B.G INGENIERIA S.A.,4410000181,10,ALL,Insp.TTecnica Terreno Servicios Privado,096898120K,A0307S001,3001870,20060111,ENT

Any advice is welcome,

Thanks in advance

Aart

[Former Member]

Problem solved via SRM260

[Former Member]

Hi,

We are also facing same issue like when we saved data was in CSV formate but now when we open the file then it comes in Text formate.

Currently file extension is .xls but we tried to change that to .csv but still it opening in text only...

Regards,

[Former Member]

Hello,

Send me a mail on my business card mail ID

will send you one sample CSV

you can specify yr data in different columns of excel before saving to CSV

this reduces yr pain of managing the blank seperators

BR

Dinesh

[jason_boggans]

Dear Aart

Just try saving the file as a text file, you have already indicated in the file what the delimiter is, (comma)

so the file will be interpreted by CCM correctly. This is perhaps the easiest way of dealing with the CSV

files without having to perform much manipulation on them.

Regards

Jason