File Content Conversion

[anita_r]

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.

[madanmohan_agrawal · Accepted solution]

Hi Anu,

You need only one sample CSV file. So you just ask your client to provide you one sample CSV file that they are going to send to XI. Looking into the CSV file you can configure the FCC adapter.

Pls reward points if it helps.

Br,

Madan Agrawal

[anita_r · Accepted solution]

Hi Madan,

1) What does delimiter mean, is it the seperator between field values of the file. If it is, then in case of CSV file it should be ','(comma).

2) So a CSV file is nothing but a text file (.txt) with the seperator between the field values as ','(comma).

Please correct me in the above sentences if I am wrong.

3) So no need to ask the client for the delimiter of the file?

4) How can I see the data of the CSV file, infact how can I open it in my system.

Can I see the seperator i.e ','(comma) if I open a CSV file.

So if I am correct in the above sentences 1 and 2, then what are the conversion parameters to be given for a csv file conversion on sender file adapter.

Can I give the fine name as 'a.txt ' if my file name is 'a' in the file name parameter of source tab and the row.fieldSeparator parameter as ',' in the content conversion tab?

Please help me.

Regards,

Anu.

Edited by: Anu P on May 25, 2008 11:56 AM

[Former Member · Accepted solution]

Hi Anu,

1. What does delimiter mean, is it the seperator between field values of the file. If it is, then in case of CSV file it should be ','(comma).

Please correct me in the above sentence if I am wrong.

A. yeh its a comma delimiter file.

For eg open your EXCEL sheet and write your names in each column and then save as CSV file you will see when you save it, then oven that csv file in notepad then you will see that comma delimter file. You got it right.

2. So no need to ask for the delimiter of the file?

A. Yes you ask for delimiter file.

3.How can I see the data of the CSV file, infact how can I open it (with which icon it will be displayed in our system).

Can I see the seperator i.e ','(comma) if I open a CSV file.

A. You need to open in notepad you can see the comma delimited file.

Ask your client for .CSV file and then proceed for scenario.

Hey sry i didnt answer this question

2) So a CSV file is nothing but a text file (.txt) with the seperator between the field values as ','(comma).

A. Exartly you are correct

Please Rewards points if it helps.

Thanks

Vikranth

Edited by: Khimavath Vikranth on May 25, 2008 12:17 PM

[anita_r · Accepted solution]

Hi Vikranth,

So if I am correct in the above sentences 1 and 2, then what are the conversion parameters to be given for a csv file conversion on sender file adapter as well as receiver file adapter.

Can I give the fine name as 'a.txt ' if my file name is 'a' in the file name parameter and the row.fieldSeparator parameter as ',' in the content conversion tab?

Please help me.

Regards,

Anita.

[ambili_jose · Accepted solution]

Hi Anita,

In the sender file adapter, provide the foll parameters:-

<node>.fieldSeparator = ,

<node>.fieldNames = field1,field2

Kindly refer the following blog

[https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1150] [original link is broken] [original link is broken] [original link is broken];

Regards,

Ambili