on 04-28-2007 1:23 PM
in flat file to flat file (.txt)
How should I give conversion settings( I mean for example 'endSeparators') I need all settings for sender and receiver side, especially when I m sending two records. I m able to send with 1 record, but when I send two or more records only first field of every record is receiving... I think I m doing mistake in conversion settings for records..
my data type is :
record
---> row
-
>name
-
>class
-
>marks.
and same for receiver as well..
Kumar,
Sender Comm channel:
Recordset Structure: row,*
Parameters:
ignoreRecordsetName : true
row.fieldFixedLengths : <Give the lenghts of your fields>
row.endSeparator : 'nl'
Receiver Comm. Channel:
Recordset Structure : row
Parameters:
row.addHeaderLine : 0
row.fieldFixedLengths : <Give the lenghts separated by commas)
row.endSeparator : 'nl'
If this does not work send us the error message and the payload.
---Satish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In the receiver side, you can add Header line Items.. for this refer-
http://help.sap.com/saphelp_nw2004s/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm
Regards
Agasthuri Doss
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi shiva kumar ,
You can handle this with File Content Conversion of the File Adapter. Make use of Key field to identify each record. And use *, whenever you feel it is 0-unbounded.
Also make sure that your content conversion is in sequence wrt Datat Type Sturcture.
I have a situation where the Flat File has the following stucture:
H01 100 200 300
H02 400 500 600
H02 700 800 900
H03 10 20
L01 10 20 30
S01 10 20 30
H01 Occurs once. H02 1 - unbounded.
H03 0 - unbounded.
L01 1 - unbounded
S01 1 - unbounded.
Can File Content Conversion handle such data. Especially like H03 which might not exist in the file.
To more-
/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
Have a look at this weblogs.
/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
/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter
Go also thru these links
AdapterConverting File Content in the Sender Adapter
http://help.sap.com/saphelp_erp2004/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm
AdapterConverting File Content in the Receiver Adapter
http://help.sap.com/saphelp_erp2004/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm
<b>reward points if helpful
regards
sreeni</b>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
shiv,
Could u provide some sample data to assist then it might be helpful
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hey amit,
data is :
shiva,MS,99
ravi,bsc,80
raju,ten,90
Note: Im getting output as shiva,ravi,raju
I need output as below :
shiva,MS,99
ravi,bsc,80
raju,ten,90
Please just provide for above data, I can understand actual funda ..
if I send single record(shiva,ms,99), I am able to receive correctly but not wid multple records.
Shiva,
For the sender side:
http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm
For the receiver side:
http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm
Thanks,
Himadri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.