on 05-12-2008 1:21 PM
Hi,
I am facing an absurd issue when reading a file via FCC.
Encoding is UTF-8 in file. When the adapter reads message from XI with Header and Item details, the first line is skipped (header).
Offset is not given any value in FCC config.
Now when I set offset as 1 and start my message from second line keeping the first line blank, the message is successfully processed.
I don't know why it is happening.
Also, the config works perfectly ok when the file is in ANSI encoding.
Regards,
Anirudh.
Hi,
Document Offset option is there in file content parameters, Specify the number of lines that are to be ignored at the beginning of the document. This enables you to skip comment lines or column names during processing. If you do not make an entry, the default value is zero lines.
follow this links
/people/sap.user72/blog/2005/01/06/how-to-process-csv-data-with-xi-file-adapter
/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem
/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file
/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Offset value indicates from which place data should be read in input file.
Thanks
--Pradeep
Reward points if helpful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Document Offset
Specify the number of lines that are to be ignored at the beginning of the document. This enables you to skip comment lines or column names during processing. If you do not make an entry, the default value is zero lines.
This should allow you to ignore the first line of your File right?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ideally, it should pick all the details when the data starts with the first line nothing is specified in offset (default = 0).
But that is not happening.
I was playing around and found that if offset is 1 and data starts with second line then it works ok.
If data starts with first line and offset is 0, it doesn't work.
That is the issue..
Regards,
Anirudh.
Edited by: Anirudh Vyas on May 13, 2008 11:56 AM
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.