This website is not affiliated with, sponsored by, or approved by SAP AG.

Problem with file content conversion. Please help!

All postings related to SAP XI

Moderators: thx4allthefish, Snowy

Problem with file content conversion. Please help!

Postby gopalbaliga » Wed Jul 01, 2009 3:49 am

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

gopalbaliga
 
Posts: 7
Joined: Fri Apr 21, 2006 11:32 am

Re: Problem with file content conversion. Please help!

Postby Baz » Wed Jul 01, 2009 7:16 am

I would remove the recordset entries for Schedule Data.
Baz

AsPiRiNg tUlY iDiOt Image

http://www.catb.org/~esr/faqs/smart-questions.html

Image

check out my Podcasts http://dj-baz.podomatic.com
Baz
 
Posts: 4704
Joined: Fri Nov 08, 2002 5:54 am
Location: dirt box Derby


Return to SAP Process Integration (SAP PI/XI)

Who is online

Users browsing this forum: No registered users and 1 guest




This website is not affiliated with, sponsored by, or approved by SAP AG.