on 07-20-2007 7:11 PM
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
Sedamkar,
Since it is CSV file you will use
.fieldSeparator : ,
.endSeparator : 'nl'
Regards,
---Satish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Venkatesh,
It all depends on the structure.If you give us the structure it would be easy for us to suggest.
Best regards,
raj.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.