Receiver FCC

[Former Member]

Hi,

I have the following target structure

HEADER,DETAIL and FOOTER.

I need the target output to be like this

"A","12"

"NAME","CITY","POSTCODE"

"12,"S"

These are my FCC receiver Channel paramerters

HEADER.fieldSeparator           ,

HEADER.endSeparator          'nl'

Same has been given to Footer and Detail.

When verifiying the file, I am unable to achieve two things.

Carriage return is wrong.  It is not identifying end of line

I am not able to get double quotes within each field.

Please help on this!

Regards

Anandh

[Ryan-Crosby · Accepted solution]

Hi Anand,

Follow this example for FCC and this will give you the structure you need:

Regards,

Ryan Crosby

[Former Member · Accepted solution]

Hello,

Irrespective of the double quote requirement, still the carriage return is not working in normal CSV. What is the hexadecimal value equivalent to 'nl'.  I can probably try that.

Regards

Anandh.B

[Former Member · Accepted solution]

If i open the file in notepad++, I can see everything is aligned properly, whereas in normal notepad , the carriage return seems to be missing.

[former_member184681 · Accepted solution]

Hi,

This might be because 0x0A, which is also called Line Feed, comes as a end of line separator only in Unix systems. It could possibly be interpreted well by notepad++, but not notepad, which is a typical Windows tool. For Windows, you should rather use Carriage Return plus Line Feed, which is 0x0D 0x0A (without space in between) in hex. So finally, use:

Record.endSeparator = '0x22''0x0D''0x0A'

Hope this helps,

Greg

[Former Member]

Hi,

     If i'm not wrong then ur FCC parameter suppose to be,

HEADER.beginSeparator = "

HEADER.fieldSeparator = ","

HEADER.endSeparator = "'nl'     --------------------------------------------------> (it's <double quote>< single quote> nl <single quote>)

HEADER.fieldNames = <what so ever they are>

DETAIL.beginSeparator = "

DETAIL.fieldSeparator = ","

DETAIL.endSeparator = "'nl'

DETAIL.fieldNames = <what so ever they are>

FOOTER.beginSeparator = "

FOOTER.fieldSeparator = ","

FOOTER.endSeparator = "'nl'

FOOTER.fieldNames = <what so ever they are>

try this parameters if u want ur values in double quote at receiver side.

Hopefully it works...

Regards,

Amit.

[former_member184681]

Hi,

Looks well for the requirement mentioned, except for a few things:

1. Field names attribute is not required, or rather: there is even no such parameter in receiver FCC.

2. For providing same set of parameters, only one structure is enough, like:

Record.beginSeparator = "

Record.fieldSeparator = ","

Record.endSeparator = "'nl'

The receiver FCC doesn't take the names into account, as far as I know, so the same set of parameters will be applied to all structures. For more details, see point #3 here.

3. Anandh, you will have to test this "'nl' (double quote, single quote, nl, single quote) combination if it really works - I am not sure if PI will be able to handle it correctly.

Regards,

Greg

[Former Member]

Hello Greg,

Everything is working fine except the carriage return.  It is not able to identify the new line when i try opening in notepad.

[former_member184681]

Hi,

That's what I was afraid of. Apparently this is the reason why SAP Help always mentions it as 'nl'. Would you be able to add these double quotes to each field during mapping and get back to the original FCC parameters you mentioned? I'm afraid this could be your simplest solution. You could also think of writing a custom adapter-module to do the conversion - a better way, but also a more difficult one.

Regards,

Greg

[baskar_gopalakrishnan2]

Just curious, Have you specified Header.fieldNames and similarly for the Detail and Footer. You might need to give this which is mandatory to identify the each record data.

[Former Member]

Hi,

Since these are at Receiver side, I did not bother to give them.  Should i be giving them? Even without those, the file is coming up pretty good.

[baskar_gopalakrishnan2]

either fieldSepartor or fieldFixedLength is mandatory.

[Former Member]

Baskar,

From the post, you can see that I have already mentioned fieldSeparator.