FCC parameters in receiver adapter

[Former Member]

Hi Experts,

In the receiver file adapter output file contains the fields needs to be included with quotes using fcc parameters, unable to get it

eg: field1,field2,field3

Tobe : "field1","field2","field3"

tried with many options but the required output was not coming

regards,

sai

[Former Member]

You need to handle this in mapping

simply it would be concatenation logic

" + field + "

use standard function concat

[Former Member]

Hey

How does your payload looks like after message mapping?does it already has double quotes or not?if it doesn't,then please handle that in message mapping.

Thanks

Aamir

[Former Member]

Hi Aamir,

Dont we have any fcc parameter such as begin field ,

else do we need to manage this in mapping only

regards,

sai

[Former Member]

Hey

there is a parameter beginSeparator.

but you also need double quotes in the end as well,its better to handle this in message mapping,rather than doing in content conversion.

Thanks

Aamir

[Former Member]

Thanks Aamir,

we dont have any other solution other than handling in mapping.

regards,

sai

[Former Member]

Well you can try using the below parameters.

beginSeparator "

fieldSeparator ",

endSeparator "/nl

I m not really sure if all of them will work properly or not in FCC,i m specially doubtful of endSeparator.

Other than that,message mapping is the best and easiest option.

Thanks

Aamir

[Former Member]

Hi Aamir,

I tried using mapping but when i test it in mapping it is showing with quotes, the same when i drop the file in ftp the output text file is not having with the quotes

i have done the mapping as

taking constant-" and concatenated with the field and again concatenated with constant -" but when i test in mm the output was good but rather as an interface testing the quotes was not including to the field

regards

sai

[Former Member]

Hey

Did you activate the message mapping?

also do a Cache refresh and try your scenario again.Check the payload after message mapping in sxmb_moni as well,it should show the double quotes if mapping is done correctly.

Thanks

Aamir

[Former Member]

thks the mapping was not activated

sai