File length in File Content Conversion

[former_member200339]

Dear All,

I have developed an Integration Process (IDOC to Fixed Field Length).

Total length - 56

Breakup for each field - 5, 1, 14, 1, 5, 1, 14, 1, 5, 1, 8 (Total - 56 characters)

The file is getting created successfully but it is showing a length of 57 character.

But if I create the file manually then it is showing 56 characters.

I tried removing the last line 'endSeparator', but it is still showing 57 character length.

Please suggest

Regards,

Rana Brata De

[zameerf · Accepted solution]

Hi Rana,

Can you try with Controls.endSeparator as  '0'

[former_member200339 · Accepted solution]

Hi Zammer,

THANKS FOR THE HELP. It has solved my problem. Now the control file is getting generated with 56 characters.

Can you suggest me on another file - Payment file (similar structure but multi-line).

Each line has a total length of 94 characters. If the file is created with i.e. say 5 lines then instead of  470, it is showing 475. I tried with '0' similar to Control file, but it did not work.

[zameerf · Accepted solution]

Can you share the complete screenshot of FCC parameters for payment file?

[former_member200339 · Accepted solution]

Payment file consists of the following

1. Header Line

2. Details-1 Line

3. Details-2 Line

Header Line occurs only once while the Details 1, 2 repeats.

All the 3 lines has a fixed length of 94 characters.

I am getting one extra character for every line.

[zameerf · Accepted solution]

Whether Details-1 and Details-2 Line corresponds to segment Rows?

The FCC configuration looks bit different for me.

What is the Recordset Structure you had mentioned?

Also, you have mentioned both fieldFixedLengths and fieldSeparator for Rows.

[former_member200339 · Accepted solution]

You are correct. Details1 and 2 corresponds to segment rows. In the message type there are 2 element nodes - Header (under which there are 13 text fields), Rows (under which there are 2 text fields). FCC is only applied to header text nodes. Rows has occurance 1 .. n.

But I feel that we cannot avoid it in the payments file. We need to have the end-separator else the lines will get jumbled.

[zameerf · Accepted solution]

Please have only these parameters in FCC and give a try.

Header.fieldFixedLengths: mention length

Header.fixedLengthTooShortHandling: Cut

Rows.fieldSeparator: 'nl'

If your source has 2 Rows like

Row1

Field1: A

Field2: B

Row2

Field1: C

Field2: D

Then your output for Rows will be

A

B

C

D

If still you have to maintain the length as 94 for Field1 and Field2, do that in graphical mapping.

[MichalKrawczyk]

Hi,

open the file in notepad ++ (http://notepad-plus-plus.org/)

to be able to see what is the last char (which is not visible in standard notepad) and compare with the one created manually

this way you will know what's wrong I hope,

Regards,

Michal Krawczyk