cancel
Showing results for 
Search instead for 
Did you mean: 

file content conversion

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

bhavesh_kantilal
Active Contributor
0 Kudos

Mudit,

can you please post yhour file as well as source strrucutre , so that we can help you better .

Regards,

Bhavesh

Former Member
0 Kudos

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

bhavesh_kantilal
Active Contributor
0 Kudos

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

former_member206604
Active Contributor
0 Kudos

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

moorthy
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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