Receiver File Empty

[Former Member]

I have been struggling with this for a day now and cant understand what is wrong.

I have the following payload which is sent from the pipeline to the receiver comm channel which has content conversion.

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

- <ns34:MT_INT xmlns:ns34="urn:text.com:xi">

- <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>

</Recordset1>

</ns34:MT_INT>

So I know my mapping works etc but why do I get an empty receiver message.

My content conversion parameters are as follows.

Recordset Structure: Recordset1,RecordStructure

RecordStructure.fixedLengthValues: 10

RecordStructure.endSeperator: 'nl'

RecordStructure.endSeparator: 'nl'

So why do I get an empty message? please help with you solution

[Former Member · Accepted solution]

Bhavesh,

What do you mean remove recordset.... remove it from the DataType Completely?

[bhavesh_kantilal · Accepted solution]

> Bhavesh,

>

> What do you mean remove recordset.... remove it from

> the DataType Completely?

yes. the reason is that the Content Conversion on the receiver file adapter can be done only on a format listed in this link,

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

Your target has the added tag RECORD1. Eliminate this tag and then the strcuture becomes like the one shown in the help link and then you can use the parameters mentioned in my previous reply to do the content conversion.

Regards,

Bhavesh

[Former Member]

Praveen is this for the receiver?

[former_member192798]

hi,

I have mentioned an example hereunder. Frame your FCC parameters the same way:-

Recordset Structure = Recordset,Row

Recordset.endSeparator = 'nl'

Recordset.fieldNames = Row

Recordset.fieldSeparator = 'nl'

Recordset.fieldFixedLengths = 37 (specify the total Length of Name, Age and Dept)

Row.fieldNames = Name,Age,Dept

Row.fieldFixedLengths = 20,7,10

Row.endSeparator = 'nl'

Regards.

Praveen

[bhavesh_kantilal]

Hi,

Can you remove the RECORD1 in the target XML and then do the cotnent conversion with these values as Receiver File adapter supports content conversion of only of such an hierarchy,

<root>...

<nameA>

<value1>value</value1>

<value2>value</value2>

<value3>value</value3>

</nameA>

<nameB>

<value4>value</value4>

</nameB>

...

</root>...

<?xml version="1.0" encoding="UTF-8" ?> 
- <ns34:MT_INT xmlns:ns34="urn:text.com:xi">
- <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>
</ns34:MT_INT>

RecordsetStructure : RecordsetStructure

In the table,

RecorsetStructure.fieldSeparator : ,

RecordsetStructure.endSeparator: 'nl'

Regards,

Bhavesh