on 06-26-2007 3:04 PM
Hi guys
I'm doing a file to file scenario. When i'm using message protocol type file in receiver comm channel, I'm receiving the output file as
<?xml version="1.0" encoding="UTF-8"?>
<DATA>
<FNAME>varun</FNAME>
<LNAME>mukund</LNAME>
</DATA>
I'm using a custom xsd for the output file structure.
I want to use file content conversion here, to display the data like
varun,mukund
Can u please help me with the content conversion parameters???
I entered RecordSet Structure = DATA
DATA.fieldNames = FNAME,LNAME
DATA.fieldSeparator = ^
I'm getting an empty file as output now
Regards
Varun
Hi,
I tried everything you said, but still im getting an empty file as output. Is it because I'm using an external xsd as my output message type???
Please help me on this...
Regards
Varun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Varun,
the structure of the outbound file is not correct.
it should be like this
<?xml version="1.0" encoding="UTF-8"?>
<recordset>
<DATA>
<FNAME>varun</FNAME>
<LNAME>mukund</LNAME>
</DATA>
</recordset>
then only u can use content conversion wheather it's XSD or message type.
Check these links as well
/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion
Sachin
Hi Varun,
You can set Recordset structure as DATA ( Case sensitive ; No need to put * )
Also declare two additional parameters as below
DATA.endSeparator = 'nl'
DATA.fieldSeparator = ,
No need for paramter DATA.fieldNames for receiver adapter.
I hope this solves your problem.
CHEERS
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi varun
Specify as
DATA.fieldSeparator = , -
(put , if you want comma seperated file)
DATA.endSeparator = 'nl' -
( new line for new record)
Also specify
Recordset Structure in CC as
Recordset Structure = Data,* -
( * if you have DATA node repeating, put 1 if you have only 1 occurrence of DATA)
Hope this helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Varun,
Have u referred the thread I gave, it give u the exact ouput as u needed.
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 |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.