on 08-23-2006 9:40 PM
Hi All,
The scenario is file to file.
I am reading the data from the file for example the input file is in the below.
JAN1000250000
JAN2000380000
JAN2000330000
FRA130000
I want to write the data in the file.
The above structure is Header and Trailer is their.
In the file content conversations of the receiver file adapter I have added like the below.
Header.endSeparator 'nl'
Header.fieldSeparator #
Trailer.endSeparator 'nl'
Trailer.fieldSeparator #
Header.addHeaderLine 0
This is how I am getting the output of my receiver file.
10002#50000
FRA#130000
In this case the first 3 letters are missing (JAN) and it is reading only the first row of the header line JAN1000250000. For trailer it is fine.
Remaining below rows is missing.
JAN2000380000
JAN2000330000
I need the output should be like this.
JAN#10002#50000
JAN#20003#80000
JAN#20003#30000
FRA#130000
Not able to see the next line of the header details.
Can you tell me what I have to add in the Content Conversion to print the above format?
Thanks,
Jane.
Hi,
Check your message in SXMB_MONI. See the incoming message how it is read. See if you are hacing the values. Also post the complete details of the sender and reciever adapter. I guess it is not read properlly or not mapped.
Thanks,
Prakash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prakash,
For the sender side the data is reading fine.
Here are the Content Conversion for the sender file adapter.
Header.fieldFixedLengths 3,5,6
Header.keyFieldValue JAN
Header.fieldNames Id,Ra_Id,Sal,
Trailer.fieldFixedLengths 3,7,3
Trailer.keyFieldValue FRA
Trailer.fieldNames Id,Sum,Count
ignoreRecordsetName true
Here are the SXMB_MONI payload message.
<?xml version="1.0" encoding="utf-8" ?>
- <ns:EMP_IN_MT xmlns:ns="http://smartsoft.com/GY/FiletoFile">
- <Recordset>
- <Header>
<Id>REC</Id>
<Ra_Id>10002</Ra_Id>
<Sal>50000</Sal>
</Header>
- <Header>
<Id>REC</Id>
<Ra_Id>20003</Ra_Id>
<Sal>80000</Sal>
</Header>
- <Header>
<Id>REC</Id>
<Ra_Id>20003</Ra_Id>
<Sal>30000</Sal>
</Header>
- <Trailer>
<Id>TRL</Id>
<Sum>130000</Sum>
<Count>2</Count>
</Trailer>
</Recordset>
</ns:EMP_IN_MT>
Thanks,
Jane.
Hi,
Check what have you given in your Record Structure field.
Refer this :
http://help.sap.com/saphelp_nw04/helpdata/en/bc/bb79d6061007419a081e58cbeaaf28/frameset.htm
Thanks.
Prakash
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.