FCC parametsrs in the Receiver Communication Channel

[Former Member]

Hi,

my scenario is (RFC - to - File) but the Receiver side i want to load the file in a Text format.. with the fixed filed lengths..

my structure is like bellow format..

DT_ORDER_DATA

. DETAILS

. . . ORDER_NO

. . . MAT_NO

. . . ITEM_NO

. . . QUANTITY

. . . PRICE

for this what i need to specify in the RecordSet Structure and what i ahev to specify in the parametsrs ...

I had gone through different threads by searching SDN. but those are not working for me..so, please specify the exact parameters

regards

Jain

[Former Member · Accepted solution]

Hi,

This may work in your case

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

Regards

Seshagiri

[Former Member]

Solved

[GabrielSagaya]

Since you use Receiver File Adapter

You have to use following FCC parameters

RecordSet Structure=DT_ORDER_DATA,DETAILS

DETAILS.addHeaderLine=0

DETAILS.fieldNames=ORDER_NO, MAT_NO, ITEM_NO, QUANTITY, PRICE

DETAILS.fieldFixedLengths=4,5,5,5,5

DT_ORDER_DATA.fieldSeparator='nl'

[Former Member]

RecordSet Structure = DETAILS .. dont specify occurrence

and in parameters just write

DETAILS.fieldSeparator = , .... specify

No need to specify fieldNames in receiver CC, its of no use

[Former Member]

Jain........

if DETAILS node having occurance 1 to unboundede then u have to give recordset structure as DETAILS,*

if DETAILS node having occurance 1 to n then u have to give recordset structure as DETAILS, n(max occurance).

FCC parameters:

DETAILS.fieldLengths:(Lengths of all fields seperated by comma).

DETAILS.fieldNames:(Names of all fields seperated by comma).

Sreedhar Goud.

[former_member238007]

Hi Jain,

Your Record Set Structure : DETAILS,*

in the key field

Specify DETAILS.fieldNames, and the DETAILS.fieldSeperator

for the output

regards,

Kishore

[Former Member]

Hi,

dis is all u need..

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

reward points if helpful

PrasHanT