FIle Adapter Receiver - Content Conversion

[Former Member]

I have a xml file as below that I am trying to convert to a simple csv file. All I get is a blank csv file at the ouptput. I tried different setting for the file conversion in the reveiver file adapter. No luck yet. I could write to an output XML file with no problem, so my interface is working!

The SAP Help doesn't provide much info on this. Your help is highly appreciated.

Thnaks.

?xml version="1.0" encoding="UTF-8" ?>

- <ns:PlantMaintenanceMessageType xmlns:ns="http://cs.par/demo/plantmaintenance">

<EquipmentID>10005661</EquipmentID>

<FunctionalLocation>KB</FunctionalLocation>

<Date />

<Time />

</ns:PlantMaintenanceMessageType>

[Shabarish_Nair · Accepted solution]

What is your root node ?

For your content conversion you need to specify the Recordset Structure but in your case i dont find an entry for the same.

If your XML had an extra tag like

xml version="1.0" encoding="UTF-8" ?>

- <ns:PlantMaintenanceMessageType xmlns:ns="http://cs.par/demo/plantmaintenance">

<b><details></b>

<EquipmentID>10005661</EquipmentID>

<FunctionalLocation>KB</FunctionalLocation>

<Date />

<Time />

<b></details></b></ns:PlantMaintenanceMessageType>

then your record set structure wud be details

and in you content conversion parameters you cud say

details.fieldSeparator -> ,

details.endSeparator 'nl'

I guess you are on sp13 or above hence there even if you content conversion fails a blank file will be created (thats what i have experienced).

Reagrds,

ShaBZ

[Former Member · Accepted solution]

Hi: ShaBZ

Thanks for the reply. I added the recordset structure for the receiver - at the data type ,message type and re-did the mapping. It is till not working. It is stuck at the adapter. The adapter eror mesage is about not having a .fieldSperator or fixedLength. I can provide the exact error message a little later.

What should be my record structure at the top of the conversion parameters box?

Thanks again.

Param.

[Former Member · Accepted solution]

Hi Param,

try this,

Give your recordset structure as "details", am assuming according to previous post structure.

then just give these two parameters,

details.endSeparator = 'nl'

details.fieldSeparator = ,

follow the quotes in also.

hope this helps.

regards,

P.Venkat

[Former Member · Accepted solution]

Thanks a lot guys. I awarded the points. Could you confirm?

[Former Member · Accepted solution]

Hi Param,

Thats good to hear. keep going on in XI. If any queries forums wil always help you.

regards,

P.Venkat

[moorthy]

Hi,

Go thru following blog /people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

Hope this helps,

Regards,

Moorthy

[Former Member]

Hi,

Refer this blog for XML to CSV..

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

Regards,

Uma