on 07-18-2012 11:06 AM
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
Hi Rana,
Can you try with Controls.endSeparator as '0'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.