cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

CSV File Content Conversion

Former Member
0 Likes
1,963

Hello, I have a litte problem with the File-Adapter and the File Content Conversion.

We get csv-files in which are 2 structures

the first row contents headerinformations like invoicenumber and sumfields.

The following rows contents item-informations.

I want to convert the file in a xml-format like this:

<invoice>

<invoiceheader>

.... (information from the first row)

</invoiceheader>

<itemlist>

<item>

... (information from 2. row )

</item>

<item>

... (information from 3. row )

</item>

....

<item>

... (information from last row )

</item>

</itemlist>

</invoice>

The csv-file looks like this:

In the csv-file i have no keys which determine the kind of row. I only know that the first row contains the headerinformation and the following rows (2. until last) contains the item informations.

Any idea ?

Kindly regards

Detlef Breitwieser

View Entire Topic
Former Member
0 Likes

hi Detlef,

To generate the required XMl file, u need to make some configuration settings in Sender File Adapter.

I'll suggest you to please go through some links first.

Please go through this weblog:

How to process CSV data with XI file adapter by Michal Galczynski

/people/sap.user72/blog/2005/01/06/how-to-process-csv-data-with-xi-file-adapter

also go through this link:

Configuring the sender file adapter

http://help.sap.com/saphelp_nw04/helpdata/en/e3/94007075cae04f930cc4c034e411e1/frameset.htm

I hope it helps,

Thanks & Regards,

Varun Joshi