File Content Conversion

[#1]

Hi All,

I am doing a File - to - JDBC scenario. In this I am getting a CSV file from source.

What is the required information I have to ask the client to convert this flat file to an XML file using XI like file structure, lenths. what are all the other information required for this.

Could anybody please tell me what is csv file, how to convert it to xml.

If possible, please suggest screen shots.

Thanks in advance.

Regards,

Anu.

[Former Member]

Hi Anu,

.CSV file is nothing but Comma delimited file.

only an excel file can be saved as a CSV file

File content conversion is used for converting flat files (fixed lenght, comma seperated) into XML messages for further processing by an integration engine. The internal XI processing (mapping, routing etc) is based on XML messages hence you need messages to be converted to XML.

Look this document

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

This is other way around its XML - CSV conversion. I will send some more releated to your scenario.

Integration Engine understands only XML messages.Now if u r handling normal text file such as 'tab separated' file,'# separated' file, or a CSV file, you need to convert the content of the file to XML and File Content Conversion mechanism helps to do this job.This File Content conversion mechanism(option)is present with the File Adapters.both Sender and Receiver.

Below are the other blogs go through these blogs

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

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

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

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

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/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/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

Please Reward points if it helps

Thanks

Vikranth

Edited by: Khimavath Vikranth on May 25, 2008 10:57 AM

Edited by: Khimavath Vikranth on May 25, 2008 10:59 AM

Edited by: Khimavath Vikranth on May 25, 2008 11:03 AM

Edited by: Khimavath Vikranth on May 25, 2008 11:06 AM