on 09-29-2011 6:41 PM
Hi Experts,
We are using SAP - PI 7.11 system. We have a scenario where we wld be getting 7-8 records and the record structure repeats n no.of times in a flat-file and while converting the Flat -File data into XML data we are facing an issue , explained below with an example :
HEADER : KeyField , f2, f3, f4, f5, f6, f7, f8
RECORD1 : f1, f2, KeyField , f3, f4, f5, f6, f7 , f8
RECORD2 : f1, f2, f3, f4, KeyField, f5, f6, f7, f8
.
.
.
.
TRAILER : keyField, f1, f2, f3, f4,f5, f6, f7, f8.
Its a fixed length flat - flie. Now the problem is : we have KeyField Value for RECORD1 as '0' and when the f3 of TRAILER is '0' the record is getting formed as RECORD1 instead TRAILER even i get proper keyField value for TRAILER RECORD. Could you please tell me why its happenning so ? And please provide the solution for this. I have used all the parameters like : fieldNames, fieldfixedLengths, keyFieldValue, endSeparator and ignoreRecordsetname and lastFieldOptional and fromConfiguration.
But still i am not able to get the proper XML out of this flat - file. Could you please suggest any solution for this asap.
Thanks & Best Regards,
Lakshman
Most of the configuration seems fine,
Just validate your configuration against below configuration, which is working fine for me,
Recordset Structure : HEADER, 1, RECORD1, ,RECORD2,,TRAILER,1
Recordset Sequence : Ascending
Recordsets per message : *
Key Field Name : recid
Key Field type : string
HEADER.fieldFixedLengths *********************
HEADER.endSeparator 'nl'
HEADER.fieldNames ************************
HEADER.keyFieldValue 01
HEADER.keyFieldlnStructure add
HEADER.lastFieldsOptional YES
-santosh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.