on 05-02-2008 7:40 PM
Hi All,
I am using the File to File scenario.
My input file has one junk character at end of file which is causing which is creating one blank record in the xml.
Can any one suggest please how to remove the extra blank record?
Input file is as follows (one junk character at end of file)
2 273770000110042008PMT EB331773 EB331773 1
2 273770000106662008PMT EB331775 EB331775 1
2 273770000107912008PMT EB331776 EB331776 1
The FCC parameters are as follows
Record.fieldNames ITEM,BUKRS,BELNR,GJAHR,SGTXT,ZUONR,BUZEI
Record.endSeparator 'nl'
Record.fieldFixedLengths 3,4,10,4,50,18,3
ignoreRecordsetName true
Record.lastFieldsOptional YES
If I do not use the lastFieldsOptional Parameter it is not being picked up by XI.
Early response is highly appreciated. points will be rewarded.
Many Thanks in Advance,
Jitender
Hi Jitender.
Try to set one more parameter
Record.additionalLastFieds ignore
Let see if it works.
Thanks,
Akhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can either you a OS command to run a shell script/batch or custom adapter module to remove it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Jitender,
I'm not used to FCC, but if no native settings exist, then you will have to either get rid of this char using a "before" script or either get rid of it using your own custom module ...
Chris
PS : btw, do you know why this char exists in your input file ? are you doing FTP or (network) file system access ?
Edited by: Christophe PFERTZEL on May 2, 2008 11:18 PM
Hi Chris,
Thanks for your reply.
Actually we have the interface from EAZYBOOK to SAP.
The file is being generated with that character in EAZYBOOK and XI is pulling via FTP.
We have another interface with the same FTP service with the structure Header, Detail. In this case also they are sending the junk character but the blank record is not coming in XI.
FCC Parameters are as follows
Header.endSeparator 'nl'
Header.keyFieldValue 1
Header.fieldFixedLengths 1,4,2,8,8,8,10,20,25,5,4
Header.fieldNames Indicator,CompanyCode,DocumentType,DocumentDate,PostingDate,TranslationDate,UserName,Tcode,HeaderText,Currency,BizTransaction
Header.lastFieldsOptional YES
Detail.endSeparator 'nl'
Detail.keyFieldValue 2
Detail.fieldFixedLengths 1,3,2,1,18,1,13,50,10,13
Detail.fieldNames Indicator,Item,PostingKey,AccountType,AssignmentNumber,DCInd,Amount,ItemText,Account,LocalAmount
Detail.lastFieldsOptional YES
I have used the similar to parameters like above. I do not understand why the blank record is not coming here and why it is creating in another case. Only difference is there we have the flat structure.
Thanks and KindRegards,
Jitender
Hi,
It can be problem with file encoding.
Check the Communication channel for encoding used for the successful case.
now check encoding of unsuccessful case. If both are different modify it in the second case and execute your scenario.
Let me know once you have done.
Thanks,
Gujjeti
Edited by: Praveen Gujjeti on May 5, 2008 3:56 PM
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
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.