on 05-11-2011 7:04 PM
Hello,
I am using FTP to FTP..
Here is the sample input file:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
FILE_TYPE=F
rec_ind Element ID Element Type ID Element Value Language Code Element Short Description Element Long Description
1 O 510110 en Books & Publications Books & Publications
1 O 510120 en Recordings Recordings
1 O 510130 en Lib Mat-Binds Library Materials - Binds
1 O 510140 en Lib Mat-Books Library Materials - Books
1 O 510150 en Lib Mat-CD Roms Library Materials - CD ROMs
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Here is my send CC content conversion..
BMOCreditRecordSet.endSeparator 'nl'
BMOCreditRecordSet.fieldFixedLengths '1000'
ignoreRecordsetName TRUE
BMOCreditRecordSet.fieldNames BMORecords
Here is my receiver CC content conversion..
BMOCreditRecordSet.endSeparator 'nl'
BMOCreditRecordSet.fieldFixedLengths '1000'
BMOCreditRecordSet.fieldNames BMORecords
ignoreRecordsetName TRUE
Output file is look like below with lot of space...
FILE_TYPE=F
rec_ind Element ID Element Type ID Element Value Language Code Element Short Description Element Long Description
1 O 510110 en Books & Publications Books & Publications
1 O 510120 en Recordings Recordings
1 O 510130 en Lib Mat-Binds Library Materials - Binds
1 O 510140 en Lib Mat-Books Library Materials - Books
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
There are lot of blanks in my output file... there are empty spaces between lines..
My question is how can I keep output and input file format identical..
THanks
John
Edited by: JOHN YAJJALA on May 11, 2011 8:05 PM
Edited by: JOHN YAJJALA on May 11, 2011 3:16 PM
Please check the File adapter FAQ note:
[Note 821267 - FAQ: XI 3.0 / PI 7.0/ PI 7.1 File Adapter|https://websmp230.sap-ag.de/sap(bD1wdCZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=821267]
" Flat Files without File Content Conversion:
Whether to configure an encoding in this case depends on if
you want to pass through the file "as is", e.g. within a File
Sender to File Receiver scenario, or if you want to convert
the file's encoding on its way through the Integration Server.
For "as is" processing, configure both the sender and the
receiver using the File Type setting "Binary".
To apply an encoding conversion, configure the respective
source and target encoding in both the sender and receiver
channel.
Important: Configuring an encoding in the receiver channel
will only lead to the expected results if the payload sent to
the receiver channel is in UTF-8 format (e.g., by having
specified an encoding conversion in the Sender channel)."
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How to separate the fields in the file content conversion,
fieldFixedLengths or fieldSeparator
I think you need to use fieldSeparator.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.