Content Conversion - Receiver File adapter

[Former Member]

Hi All,

I have to generate text file at the target folder. I am using FCC in Receiver File adapter . (referred the link already :http://help.sap.com/saphelp_nw2004s/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm) But unable to genrate the output file correctly. Request your help regarding the same.

I have used the following parameters:

Trasport Protocal: NFS

Message Protocal:File Content Conversion

Recordset Structure:Detail

Detail.fieldSeparator = |

Detail.endSeparator  = 'ln'

Input :

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

<ns1:Response xmlns:ns1="urn:test.com">
<root>
<Detail>
<Type>C</Type>
<Timestamp>20122402</Timestamp>
<FirstName>mimi</FirstName>
<LastName>yy</LastName>
<ComName>xx</ComName>
<DId>909</DId>
<ID>sdfwer23454</ID>
<Address>vfgdf</Address>

</Detail>
</root>
</ns1:Response>

I am getting the following output txt file which is wrong: (only first field value repeating)

C|C|C|C|C|C|C|C

[zameerf · Accepted solution]

Hi Prem,

You have to add the <root> node as well in your Recordset structure.

Try with below parameters.

Recordset structure: root, Detail

root.fieldSeparator='nl'

Detail.fieldSeparator=|

Hope this should solve the issue.

[Former Member · Accepted solution]

Hi Zameer ,

This does not worked as well.

How ever I got the solution by reducing one node. Seems to be Rx file adapter does not wotk for 3 level hierarchy.

Thanks.

Prem

[former_member745532]

Following should work

Recordset structure: root,Detail

root.fieldSeparator='nl'

Detail.fieldSeparator=|

Detail.endSeparator='nl'

[Former Member]

Hi.

The endSeparator should be : 'nl'

http://help.sap.com/saphelp_nwpi711/helpdata/en/44/658ac3344a4de0e10000000a1553f7/frameset.htm

Regards

Lucho.

[Former Member]

Hi Lucho,

Its just a typo .. actually used 'nl'

[Former Member]

Hi.

it's strange.. Can you try with another fieldSeparator.

Name :Detail.fieldSeparator 

Value : ,

Or put value as : '|'

Or.insted of  the endSeparator  'nl',  use '0x0A'

Regards

Lucho.

[Former Member]

Hi Lucho,

I have tried as suggested. The result is

C,C,C,C,C,C,C,C

[Former Member]

Hi.

What about the another tips.?

Regards

Lucho.

[Former Member]

hi,

1) Name :Detail.fieldSeparator 

Value : ,

result : C,C,C,C,C,C,C,C

2) Or put value as : '|'

result : C'|'C'|'C'|'C'|'C'|'C'|'C'|'C

3) Or.insted of  the endSeparator  'nl',  use '0x0A'

same as above

I have used adapter specific attributes in this channel also Trasport Protocal is NFS ..will this be  an issue for FCC ?

[Former Member]

Hi..

Your XML is the output or input Payload?. .

Can you check on SXI_Monitor.?

Regards

Lucho.

[Former Member]

Hi Lucho,

Its an output XML   needs to be converted into .txt before placing the file in the folder.

Actaul scenario is webService --> PI --> PI file system folder.

[Former Member]

Ok.

Yep is strange , maybe is an issue for FCC.

One more thing , can you delete the object and recreate the FCC.

Have you checked this ?

http://www.riyaz.net/sap/xipi-file-content-conversion-for-simple-structure/75/

Regards.

[Former Member]

Hi ,

I am able to resolve this by changing the XML structure. Removed one top node <root>. 

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

<ns1:Response xmlns:ns1="urn:test.com">
<root>
<Detail>
<Type>C</Type>
<Timestamp>20122402</Timestamp>
<FirstName>mimi</FirstName>
<LastName>yy</LastName>
<ComName>xx</ComName>
<DId>909</DId>
<ID>sdfwer23454</ID>
<Address>vfgdf</Address>

</Detail>
</root>
</ns1:Response>

My massage structure is a 3 level hierarchy ..even then it ' not working . Does Receiver File adapter won't work for a 3 level hierarchy.

Thank you