cancel
Showing results for 
Search instead for 
Did you mean: 

File to IDOC (content conversion)

Shabarish_Nair
Active Contributor
0 Kudos

Hi,

My scenario is File to IDOC.

My input file is as

"AAA",399,"DD",20050302,100642,3289

"B01","E",20051,39.1,"AC","M","L"

"B01","L",20051,38.3,"AC","F","D"

"B01","L",20301,37.7,"AC","F","W"

"L9",50

wherein the structure should look as follows:

<root>

<header> => occurence 1

<hdata1>.....</hdata1>

....................

<hdatan>.....</hdatan>

<body> => occurance unbounded

<data1>.....</data1>

.........

<datan>.....</datan>

</body>

</header>

<trailer> => occurance 1

<data2>....</data2>

</trailer>

</root>

Now my question is that how do we go for the content conversion in this scenario.(the problem is that header contains element data and subnode body)

Regards,

Shabz

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

you do not have to nest the B structure under the header... Make header, line detail, and trailer all on the same level as complex objects with their associated attributes.

In content conversion, when you specify recordset structure, you'd have Header,1,Detail,*,Trailer,1

does this make sense?

Shabarish_Nair
Active Contributor
0 Kudos

Hi Amanda..

Thanx 4 the response.

But i have a query, since the target idoc is structured

with the heirarcy ( a header and a body inside the header, a footer ) during file conversion, if we change the structure as u said will that affect the context while the mapping takes place.

Ref: IDoc structure is

A

_B

C

Regards,

ShabZ

PS: I am not able to test your suggestion as my system is down

Former Member
0 Kudos

Hmmm. Perhaps. In the IDoc structure, let me see if I understand

A

B (child of A, unbounded)

C

or is C under B?

If C is the same level as A, you are fine. I ran a quick test - when you map B across, say "remove contexts". You'll get as many B's on the destination as you had in the source, and one header, one trailer...

Let me know if this makes sense

Shabarish_Nair
Active Contributor
0 Kudos

Yes indeed.... the idoc structure is indeed

A

B (child of A, unbounded)

C

But lemme rephrase my question...

in my File to Idoc scenario....

suppose i have a flat file as follows...

"AAA",399,"DD",20050302,100642,3289

"B01","E",20051,39.1,"AC","M","L"

"B01","L",20051,38.3,"AC","F","D"

"B01","L",20301,37.7,"AC","F","W"

"L9",50

and i need to genrate an xml file with the structure as

A

B (child of A, unbounded)

C

how will i accomplish this with Content Conversion.

Regards,

ShabZ

Former Member
0 Kudos

When you specify xml.recordsetStructure, use:

SegA,1,SegB,*,SegC,1

The setup of structure conversion was done in a weblog - if you want, I can email you the PDF of the setup (or at least a start, we used the JMS adapter, but it works the same) - it's easy to follow. They've made some udpates to the parameters, so it's even easier IMO. Let me know if you can't find it - I'll email you the copy I have.

Shabarish_Nair
Active Contributor
0 Kudos

Hey Amanda,

Really appreciate your patience on this.

It would be wonderful if you could sent me the document.

My email id is shabarish.vijaykumar@wipro.com

Regards,

ShabZ

Former Member
0 Kudos

Hi Amand

I am interested in getting the document. Can you plz send it to me.

Former Member
0 Kudos

You need to post your email address

Former Member
0 Kudos

Hi Amanda,

could plz mail one copy to gopal_n2k@yahoo.cOM. Thanks in advance.

Rgds,

Ram Sri

Former Member
0 Kudos

Amanda,

Would appreciate if you could also mail a copy to sapknowledge@gmail.com.

thanks,

sapknowledge