Skip to Content
0
Former Member
Jul 01, 2009 at 10:05 AM

Problem with file content conversion for multiple substrcture. Please help!

28 Views

Hi Experts,

I am using file content conversion in file sender communication channel. The input file is a flat file with data like this:

A01 AA8I0NBVDA 20090704 84900

A02 AA8I0NBVDA 20090704 84900

A03 AA8I0NBVDA 20090704 84900

I want the data in sender side after content conversion to be like this:

<ns:Receive_Schedules xmlns:ns="http://mynamespace">

<ScheduleData>

<line>A01 AA8I0NBVDA 20090704 84900</line>

<line>A02 AA8I0NBVDA 20090704 84900</line>

<line>A03 AA8I0NBVDA 20090704 84900</line>

</ScheduleData>

</ns:Receive_Schedules>

I have tried many options in file content conversion but getting the data like this:

<ns:Receive_Schedules xmlns:ns="http://mynamespace">

<ScheduleData>

<line>A01 AA8I0NBVDA 20090704 84900</line>

</ScheduleData>

<ScheduleData>

<line>A02 AA8I0NBVDA 20090704 84900</line>

</ScheduleData>

<ScheduleData>

<line>A03 AA8I0NBVDA 20090704 84900</line>

</ScheduleData>

</ns:Receive_Schedules>

Following are the settings/properties have configured in content conversion:

Document Name Receive_Schedules

Document namespace http://mynamespace

Document Offset <no value>

Recordset Name <no value>

Recordset namespace <no value>

Recordset structure ScheduleData,*

Recordset sequence Ascending

Recordsets per message 1

Key field Name <no value>

Key Field Type String

ignoreRecordsetName true

ScheduleData.endSeparator 'nl'

ScheduleData.fieldNames line

ScheduleData.fieldSeparator 'nl'

How to get the desired message? What changes I need to do in content conversion settings? Please help!

thanks

Gopal

Edited by: GOPAL BALIGA on Jul 1, 2009 12:11 PM