Dear Experts,
My scenario is that I am using a Sender File Adapter for picking up a comma separated .csv file from a location and using content conversion in my communication channel and given below parameters:
but the .csv file is coming like this
Here you can see in the first line, wrong data is coming and due to that, file is getting wrongly interpreted by the system, means something like this:
Therefore, I need some parameters with the help of which the wrong file can be identified or the communication channel should go in error (in Adapter Engine) and file will not get processed.
Waiting for your responses.
Regards,
Aayush Aggarwal
- SAP Managed Tags:
Accepted Solutions (0)
Answers (1)
Hi,
Mention 1 in Document Offset
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.
So when you type Document Offset = 1, the first line of your input file will be ignored by the file adapter during FCC processing.
Hi Sahithi,
Thanks for your response, but the Document Offset is already there...
And this first lines doesn't comes on a regular basis, this comes when the user make change in the .csv file through excel (which should be done through notepad).
So we can't always ignore the first line.
Can you please suggest something else??
Regards,
Aayush
| User | Count |
|---|---|
| 87 | |
| 10 | |
| 10 | |
| 10 | |
| 7 | |
| 6 | |
| 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.