Solved: Transfer using CSV-files

Former Member · ‎09-30-2009

Hello! In our project we discussing about possibility to use CSV-files to transfer information.

Can I use CSV in PI ?

former_member187339 · ‎09-30-2009

Hi,

Yes you can. Use File adapter to read and do a file content conversion on it. By doing it the CSV format will be converted to XML format in PI

Lot of weblgs are available on this

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/sundararamaprasad.subbaraman/blog/2005/12/09/making-csv-file-lookup-possible-in-sap-xi

/people/rahul.nawale2/blog/2006/07/18/java-mapping-an-alternate-way-of-reading-a-csv-file

/people/swaroopa.vishwanath/blog/2005/06/24/generic-approach-for-validating-incoming-flat-file-in-sap-xi--part-1

Regards

Suraj

Edited by: S.R.Suraj on Sep 30, 2009 9:18 AM

Shabarish_Nair · ‎09-30-2009

CSVs can be easily content converted using the option File content conversion in the file adapter

the fieldSepataror will be ,

former_member181962 · ‎09-30-2009

Hi Andrey,

It is very much possible:

Read this blog for more:

Regards,

ravi

Transfer using CSV-files