on 10-29-2006 9:29 AM
Hi all;
i have a scenario where i am getting in a file of format
Hxxxxxxxxxxxxxxxxxxxx...
Tjjjjjjjjjjjjjjjjjjjj...
Tllllllllllllllllllll...
Dkkkkkkkkkkkkkkkkkkkk...
with header text and detail lines.
can any one tell me the structure of the data type to be made in IR for this file structure and the adapter parameters which needs to be set for the same in the file adapter
Mudit,
can you please post yhour file as well as source strrucutre , so that we can help you better .
Regards,
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi bhavesh;
my file structure will be like this
H...............
T.............
T.............
D.............
D............
H.................
T........
and so on
H is header T is Text and D is detail
there will be one header line corresponding to multiple text and detail lines in a single record.
i made the structure like
recordset 0....unbound
header 1..1
field1
field2
text 0....unbound
field1
field2
details 0....unbound
field1
field2
is this correct.How will it interpret the recordset
Mudit,
For this, these are the paramters you would need,
DocumentName : <MessagetypeName>
DocumentNamespace: <namepace>
Recordetname: RECORDSET
RecordsetNamespace: leaveitblank
RecordsetStrucutre: HEADER,1,TEXT,*,DETAILS,*
keyFilename: key
keyfieldtype : String
HEADER.fieldNames : key,otherfieldnames
HEADER.fieldSeparator : , -->if separator is comma
HEADER.keyFieldValue : H
HEADER.keyFieldInStrucutre: ignore
TEXT.fieldNames : key,otherfieldnames
TEXT.fieldSeparator : , -->if separator is comma
TEXT.keyFieldvalue : T
TEXT.keyFieldInStrucutre: ignore
DETAILS.fieldNames : key,otherfieldnames
DETAILS.fieldSeparator : , -->if separator is comma
DETAILS.keyFieldvalue : D
DETAILS.keyFieldInStrucutre: ignore
if you do not want recordset level node, then you can use <b>ignoreRecordsetName</b> with value true.
Regards,
Bhavesh
Hi,
You will need to define the structure like this
Recordset
-Header
--Field1
--Field2
-Text
--Field1
--Field2
-Details
--Field1
--Field2
You content conversion should be based on the type of file, I mean CSV or fixedLenght.
Regards,
Prakash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Structure of the data type is based on the file format.
So accordingly you can go on that.
And regd, File channel configuration-http://help.sap.com/saphelp_nw2004s/helpdata/en/0b/9a50465ccf84479e39a6d50c90fb3f/content.htm
Regards,
Moorthy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Plz go thru the following blogs:
1) /people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file
2) /people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns
3) /people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter
4) /people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1
5) /people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2
Thanks & Regards
Viji
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.