Receiver File Adapter - File Content Converstion

[Former Member]

Hi,

I have an xml-output (as a string) but I need to use the content converstion tool in the receiver file adapter to make this into one string without the nodes etc. Example of the format that i want the file to be in:

1AXXX10363501 00000013PC..........etc.

And I need each instance of SBR in a new row. How can I do this? Please tell me if things are unclear.

Example of the structure the file has now without content converstion.

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

<StockBalanceFlatfile><Rows><SBR>

<Type>1</Type>

<Mode>A</Mode>

<Owner>XXX</Owner>

<SKU>10363501</SKU>

<Quantity>00000013</Quantity>

<UOM>PC</UOM>

<Attr1>2476</Attr1>

<Status>0000</Status>

<Filller>----

---

</Filller>

<ELM>*</ELM>

<CRLF>CRLF</CRLF>

</SBR></Rows></StockBalanceFlatfile>

Best Regards

Claes

[Former Member]

Solved the issue with some help from Raj and these links:

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

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

[Former Member]

Hi Claes,

You can concat all the fields at Mapping level if ur target structure is not specific.

Thanks,

Maheshwari.

[justin_santhanam]

Claes,

Use the below content conversion parameters.

<u>Content Coversion Parameters</u>

<b>Recordsetstructure</b> StockBalanceFlatfile,Rows,SBR

<b>Name</b> <b>Value</b>

SBR.endSeparator 'nl'

If it doesn't help, reply back.

Best Regards,

raj.

[Former Member]

Hi,

Yes Raj this is what I'm looking for.

My file adapter isn't working right now so I can't test it properly. Do you know if this is possible to test in the test configuration in the ID (Tools > Test Configuration)? I think not. I have to come back to you when I have got my adapter to work.

Thanks

/Claes

[justin_santhanam]

Claes,

You can't check with test configuration. Test Configuration is used to test only the objects have been configured properly, I mean does the particular Receiver Determination contains all of it necessary Interface determination, receiver agreement etc..

Best Regards,

raj.

[justin_santhanam]

Claes,

Have you tested the scenario. Is it working?

Best regards,

raj.

[Former Member]

Hi ray,

Yes I have solved it. I used the following converstion parameters.

Name / Value:

SBR.endSeparator / 'nl'

SBR.addHeaderLine / 0

StockBalanceFlatfile.fieldSeparator / 'nl'

Rows.fieldSeparator / 'nl'

SBR.fieldFixedLengths / 1,1,3,18,8,2,14,4,101,1,4

Thanks for your help

/Claes

[Former Member]

Claes,

Using the Concat functionality will solve your issue. If you have more fields then a user defined funciton can help you. This is what you are looking for?

---Satish