cancel
Showing results for 
Search instead for 
Did you mean: 

File Content Conversion for Sender Channel

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.