cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member192295
Active Contributor
0 Kudos

Hi,

The problem is due to parameters, you need to change parameters like below

Recordset structure ScheduleData,1,line,*

Meanwhile change data structure at source & target side also like below.

scheduledata---1.1

...Line....0..Unbound

...a

...b

I hope now clear

Former Member
0 Kudos

Hi Ranjan,

If I give the Recordset structure as ScheduleData,1,line,* then I get an error saying KeyFieldName is mandatory.

Are you sure about your answer?

Please clarify.

Thanks

Gopal

former_member192295
Active Contributor
0 Kudos

HI,

Accordingly we need to change below structure also

line.endSeparator 'nl'

line.fieldNames <filenames>

line.fieldSeparator 'nl'

Former Member
0 Kudos

Hi Ranjan,

What can I give for line.fieldNames <filenames>?

I don't have any fields under <line>.

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> ---> There is no field under <line>

<line>A02 AA8I0NBVDA 20090704 84900</line>

<line>A03 AA8I0NBVDA 20090704 84900</line>

</ScheduleData>

</ns:Receive_Schedules>

former_member192295
Active Contributor
0 Kudos

HI,

Change your structure to below format like

receiver Data Structure:

scheduledata...1.1

...line....0...Unbound

FCC Parameters

recrdsetname scheduledata

scheduledata.fieldSeparator nl

scheduledata.filedNames line

sceduledata.endSeparator nl

Former Member
0 Kudos

Hi Ranjan,

My structure is like what you ahve defined.

scheduledata...1.1

...line....0...Unbound

I also tried the parameters you gave but still getting the same.

<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:

Recordset structure ScheduleData,* -


> Is the value correct?

Recordset sequence Ascending -


> Is the value correct?

Recordsets per message 1 -


> Is the value correct?

ignoreRecordsetName true

ScheduleData.fieldSeparator nl

ScheduleData.fieldNames line

ScheduleData.endSeparator nl

Edited by: GOPAL BALIGA on Jul 2, 2009 5:28 AM