No output file being created when using File content conversion

[Former Member]

Hi guys

Please don't refer me to 1000's of blogs as these don't really answer my question.

I've got a payload file as follows (with 3 records in it)

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

- <rfc:Z_XI_005_RFC xmlns:rfc="urn:sap-com:document:sap:rfc:functions">

- <IP_CUSTOMER_HEADER>

- <item>

<CUSTOMERID>1000001</CUSTOMERID>

<COMPANY>One-time ship-to</COMPANY>

<SHORT_NAME>ONE-TIME</SHORT_NAME>

<STREET />

etc etc etc

until end of data

<SALES_REGION />

</item>

</IP_CUSTOMER_HEADER>

</rfc:Z_XI_005_RFC>

My XML traget file is produced as follows

( for simplicity I'm only using 3 fields)

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

- <ns1:MT_customer_header xmlns:ns1="http://avenue.com/xi/test">

- <item>

<Customerid>1000001</Customerid>

<company>One-time ship-to</company>

<shortname>ONE-TIME</shortname>

</item>

- <item>

<Customerid>1000005</Customerid>

<company>ddfask</company>

<shortname>;LK;L</shortname>

</item>

- <item>

<Customerid>1000010</Customerid>

<company>One Time Customer Test</company>

<shortname>SADFIWQEFG</shortname>

</item>

</ns1:MT_customer_header>

Now what EXACTLY do I need to code as parameters for the File Content conversion to work

This is what I've currently got as parameters.

RECORDSET: IP_CUSTOMER_HEADER

item.fieldSeparator |

item.fieldSeparator 'nl'

Thist currently produces NO OUTPUT file on the target directory --XI payload is fine and is as above.

I'm going Bonkers over this --it should be EASY especially as the XML file is created

I don't really want to code a program to do this when XI should do it.

Cheers

jimbo

[former_member190389 · Accepted solution]

give record set as item.

If u need the fields under item to be "|" seperated use item.fieldSeparator as | else use 'nl' also if you want each row ona single line use item.endSeparator as nl.

[Former Member]

Stupid case of RTFM -- as I'd changed the mapping (as per other post) to include the ITEM as the higher level node this is the parameeter I need in the recordset

so when recordset parameter is changed to item the other parameters rmaining the same)

the file works fine

Output text file

1000001|One-time ship-to|ONE-TIME

1000005|ddfask|;LK;L

1000010|One Time Customer Test|SADFIWQEFG

I've given you the points in any case --although I solved the problem before I saw your post you put me on to the correct track from my other related post where I was missing the higher level node in the data and message mappings

Cheers

and thanks

Jimbo