on 06-07-2006 3:47 PM
Hi All!
I'm having a little trouble with the file adapter. I have an interface, which picks up a file with the file adapter, and then in a business process goes through some steps.
First it is converted to an XML file, with some mapping (XSLT). Then, through RFC, additional data is requested from an R/3 system. The R/3 data and the data from the file are then merged through yet another mapping (XSLT). This all goes fine, no problems here.
Then, at the end, the merged message is written to a server, with the file adapter again, as a CSV file. This works also, but every time there is a carriage return at the end of the file. You have several lines of data, and then a return, so you get a blank line at the end of the file. I have done nothing in the configuration that justiefies this, and have no idea where this return comes from.
Can anyone please give me some pointers on this? It seems that every interface that writes files in our company suffers from the same problem...
Please, be gentle, because I am quite new to SAP XI
Thanks in advance!
(I am sorry, but I will go home in 15 minutes, but I thought I could post it for all of you who are in a different time zone. I will see if I can check again later tonight from home...)
Yordy..Do give the endserator for only last structure..are u using variable substitution?why a blank line is written always?..some thing wrong in ur configuration parameters..Can u paste the structure and configuration parametter so that we can help n a better fashion?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The message looks like this:
ROOT
- Actualsales
- data1
data2
data3
data4
In my configuration, I have set the following Content Conversion parameters (originally):
Recordset Structure: ROOT,Actualsales
ROOT.fieldSeparator '0x20'
Actualsales.fieldSeparator ;
So this is no standard Recordset - Row structure. This interface was here long before me, so changing the structure of the data type is not really an option, or at least not one my boss is gonna like.
I experimented with setting the endSeparator for Actualsales to nothing, or zero, and then all my data was written to the file in a single line.
This is some frustrating stuff! But fun, none the less.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
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.