'nl' Not Working for fieldSeparator in File Content Conversion

[Former Member]

I have a receiver communication channel where I want to create a file with each field being a new line. The xml (Message Protocol: File) output looks like this:

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

<ns0:complus_receiver_messageType xmlns:ns0="http://graybar.com/test/complus_rec

eiver"><cp><myrequest>AAFADFASFADFADSFDASFADFAAA</myrequest><myheader>DELADV</myheader></cp></ns0:complus_receiver_messageType>

When I turn on Message Protocol of File Content Conversion, and follow the SAP documentation on the parameters, the 'nl' is getting sent literally.

- I have Recordset Structure of: cp

- I have content conversion parameters of:

cp.fieldSeparator 'nl'

cp.fieldNames myrequest,myheader

cp.addHeaderLine 0

My file output looks like this:

AAFADFASFADFADSFDASFADFAAA'nl'DELADV0001

Note that the 'nl' is not processing as a new line. Ideas?

[Former Member]

Hi,

Receiver FileContent conversion params dosen't have <b>fieldNames</b>

cp.fieldNames myrequest,myheader

so why don't u remove this and try once again...

Recordset Structure of: cp

cp.addHeaderLine 0

cp.fieldSeparator 'nl'

Hope this weblog helps you...

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

Cheers,

Siva Maranani.

[Former Member]

same result when removing the fieldNames parameter

[Former Member]

I figured it out. If I use '0x0A' instead of 'nl', it works as desired.

[Former Member]

Keith,

just out of curiosity: Which JDK is your XI AF running on and which value does its "line.separator" system property have (which the File Adapter uses when writing a lin end)?

Thanks,

Thilo

[MichalKrawczyk]

Hi Keith,

can you try:

cp.fieldSeparator nl

Regards,

michal

[Former Member]

This just sends the literal nl to the output.

AAFADFASFADFADSFDASFADFAAAnlDELADV0001

[MichalKrawczyk]

hi,

this might be a little strange suggestion but have you tried:

cp.fieldNames myrequest,myheader

cp.fieldSeparator 'nl'

Regards,

michal

[Former Member]

same result

I was wondering if the 'nl' only applies to endSeparators but could not find that anywhere.