I am doing a File to File.. I pick up a CSV file and drop of to a target. In my Content Conversion Parameters I have specified 1 Recordset per message.
Now my problem is that on the target side I only receive 1 file when the source file has about 6 recordsets and whats worse is that the target file doesn't have any values anyway...
I have checked the mapping in the test tool and it works fine... I looked in SXMB_MONI and I am definitely getting the payload into the pipeline (although all recordsets are coming in as one XML and not multiple as I want... or does it not split it into multimple messages until receiver determination?)
The payload is full in all steps of the pipeline up until the Request Message Mapping Step and here under this particular tree the payload is just
<?xml version="1.0" encoding="UTF-8" ?>
No fields what so ever... I thought at the very worst I would get all the recordsets in one file but not no recordsets at all...
Please can someone help?
By the way my source file is CSV... and the Payload that you can see in the first step of the pipeline (inbond message central) is:
<?xml version="1.0" encoding="utf-8" ?>
- <Recordset1>
- <RecordStructure>
<id>C05-000089</id>
<SampleDescription>Fully Cooked Pork Loin B/R with BBQ Sauce</SampleDescription>
<SampleComments />
<OperatingCompany>Refrigerated Foods</OperatingCompany>
<Division>527</Division>
<location>N/A</location>
<sourcefacility>06/08/2005 10:16</sourcefacility>
<upc>Compliance</upc>
<date>1260031</date>
<sampletype>2.12</sampletype>
<samplecode>g</samplecode>
<nutrientname>zws0042</nutrientname>
</RecordStructure>
- <RecordStructure>
<id>C05-000064</id>
<SampleDescription>Pork Patties</SampleDescription>
<SampleComments />
<OperatingCompany>Culinary Products</OperatingCompany>
<Division>9030</Division>
<location>4530026311</location>
<sourcefacility>06/07/2005 15:37</sourcefacility>
<upc>Verification</upc>
<date>238585</date>
<sampletype>619.5</sampletype>
<samplecode>mg</samplecode>
<nutrientname>zjs0146</nutrientname>
<testvalue>NA</testvalue>
</RecordStructure>
- <RecordStructure>
Message was edited by:
Alex Ong