Proxy to CSV format

[Former Member]

Hi

I have a scenario proxy to CSV format. What are the content conversion parameters i have to use on receiver side for CSV format.

venkat

[Former Member]

Sedamkar,

Since it is CSV file you will use

.fieldSeparator : ,

.endSeparator : 'nl'

Regards,

---Satish

[Former Member]

In the Target Directory i have to put the file name as output.csv

[justin_santhanam]

Venkatesh,

Could you please clear us wht u wanna do? You want to place the file output.csv !!!wht is the reqmt?

Best regards,

raj.

[Former Member]

Sedamkar,

In the file receiver communication channel in file name put your filename as output.csv. Thats it. Its very straight forward.

Regards,

---Satish

[Former Member]

Hi Venkat !!

Basically, you should use a communication channel with File Adapter, type receiver, message protocol = File Content Conversion.

Take this XML structure for example:

<resultset>

<row>

<column-name1>column-value</column-name1>

<column-name2>column-value</column-name2>

<column-name3>column-value</column-name3>

</row>

<row>

<column-name1>column-value</column-name1>

<column-name2>column-value</column-name2>

<column-name3>column-value</column-name3>

</row>

</resultset>

In content conversion parameters, to obtain a CSV format file, you should enter:

Recordset Structure: "resultset" (without quotes)

In the below table:

name: resultset.fieldSeparator -

---

> this sets the field separator

value: ',' ---> as comma

name: resultset.endSeparator -

---

> this sets the line separator

value: 'nl' -

---

> as new line

Regards,

Matias.

[justin_santhanam]

Venkatesh,

It all depends on the structure.If you give us the structure it would be easy for us to suggest.

Best regards,

raj.