Need help

[Former Member]

Hi ,

I am facing a problem ,how can we do integration from csv format file to an IDOC ..

I mean i have only done file to file simple scenario before in which we can create a data type but in csv format no colummn names or table we have.

Thanks,

Kunal

[moorthy · Accepted solution]

Hi,

Check this guide~

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/877c0d53-0801-0010-3bb0-e38...

Regards,

Moorthy

[former_member91687]

Hi Kuna,

As XI understands only xml format of the data, you need to perform content conversion on the incoming flat file. The rest of the configurations would be that of a file to idoc scenario.

On how to achieve content conversion these blogs will help you:

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

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

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

http://help.sap.com/saphelp_erp2005/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/frameset.htm

Regards,

Chandra

[Former Member]

Hi Kuna,

For using the csv format you need to use the file content conversion in the file adapter. You can find the usage of the same in the sender file adapter in detail from this following link.

http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm

Also pls do refer Venkat's blog on https://weblogs.sdn.sap.com/pub/wlg/1818. [original link is broken] [original link is broken] [original link is broken] [original link is broken] [original link is broken]

Pls do refer the file to idoc scenarios in the following blogs.

/people/ravikumar.allampallam/blog/2005/06/24/convert-any-flat-file-to-any-idoc-java-mapping

Cheers

JK

[MichalKrawczyk]

Hi,

>>>but in csv format

those types of file usually look like this

data1; data2; data2;

data1; data2; data2;

data1; data2; data2;

so you can use

<b>fieldSeparator</b> = ;

to map them to the xml structure

have a look at :

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

on how to use <b>fieldSeparator</b>

to post those lines them as jdbc you'll need one of those formats (insert probably):

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

michal