on 10-16-2007 3:07 PM
Hi ,
I have a file structue like this.
<?xml version="1.0" encoding="utf-8" ?>
- <Test>
- <Row>
<Field1>CAL</Field1>
<Field2>$</Field2>
<Field3>PCP006</Field3>
<Field4>20060630</Field4>
</Row>
- <Row>
<Field1>CAL</Field1>
<Field2>$</Field2>
<Field3>PCP006</Field3>
<Field4>20060630</Field4>
</Row>
</Test>
I have converted this multi line xml file into a flat file by using the xmltoplain modulle in my sender communication channel and I got the output li
CAL$PCP00620060630 CAL$PCP00620060630
But I need the output like
CAL$PCP00620060630
CAL$PCP00620060630
how do I mention this newline command ?
Thanks,
Vengal.
Hi Balguri,
In case of File Adapter you can use the Content conversion parames as below for u r structure.
Recordset Structure -- Row
Row.fieldNames -- Field1,Field2,Field3,Field4
Row.fieldfixedlengths -- 3,1,6,8(and all the 12 fields)
Row.endSeparator -- 'nl'
Try with these parameters once ignore remaing all other parameters u r specifying for a while.Try to test the same and let me know the proceedings.
Cheers
Veera
>>> Reward points,if it is needful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Balguri,
What is the communication channel you have configured for Receiver side.is it File adapter or else???
Cheers
Veera
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I tried that but it is not workinfg
See my structure is a simple structure in this format.
<Test>
<Row>field1 field2 filed3 </row><Row>field1 field2 filed3</>....and so on
<Test>
so it contains only one record type having fixed no of fields
In this case I used Plain2XML
and used following parameters
Transform.clss
Transform.contenttype
row.endseperator = 'nl'
xml.addheaderline = 0
xml.conversiontype = simplexml2plain
xml.fieldfixedlengths = 3,1,6,8(and all the 12 fields)
but it is not working ....
how do we mention this end seperator?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
use the field seprator and new line correctly
row.endSeparator= 'nl'
Thanks
sudhir sharma
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
U can provide fieldSeparator
Have u seen this
http://help.sap.com/saphelp_nw04s/helpdata/en/44/748d595dab6fb5e10000000a155369/frameset.htm
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
CAL$PCP00620060630 CAL$PCP00620060630
to get result like this
CAL$PCP00620060630
CAL$PCP00620060630
you have cofigured the file receiver adapter right......mentin the end Separator as newline there
row.endSeparator= 'nl'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.