Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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
Not what you were looking for? View more on this topic or Ask a question