File Content Conversion for complex structure

[Former Member]

Hi

I have a requirement to repeat a structure consisting of three lines i.e the segment containing these 3 lines will have occurrence 0....unbounded and will be repeated in the File multiple times ,

What is the level that can be handled in File Content Conversion's recordset structure ?

My issue is that the structure is

Dt_File -> Repeating Level1->Level2 ->Field1

->Level2a->Field3

-> Level2b->Field5

where the first level is DT_File

under which I have RepeatingLevel1 as a SubElement

and under Repeating level I have Level2 , Level2a and Level2b at its subelementsl

and under Level2 I have Field1 , Under Level2a i have Field3 and under Levle 2b i have Field5

How do i handle this in the Content Conversion ?? as in how do I create my Recordset Structure ?? as it just handles one level below the Document Name (i,e) Message Type)

Is it possible ??? or should i consider some other way to constuct my data type ??

Thanks

Dev

[Former Member · Accepted solution]

Hi,

Please check this link

/people/karthiknarayan.kesavan2/blog/2007/08/22/file-content-conversion-for-multi-hierarchical-structure

You can have a intermediate structure as said in the link.

Let me know if you need any clarification

[Former Member · Accepted solution]

Hi Lakshmi,

Thanks for the blog !

/people/karthiknarayan.kesavan2/blog/2007/08/22/file-content-conversion-for-multi-hierarchical-structure

If u refer to the Blog my structure is only till LEVEL2 , i dont need Level 3 at all so I dont think I require Intermediate mapping

Can you please confirm if my target tructure is similar to the one in the blog

i.e

DT_File

Level1(0..unbounded)

Level2(1)

field1

field2

Level2a(1)

field3

field4

Level2b(1)

field4

field5

Here Level 2 , Level2a and Level2b are all at the same level ,and are child nodes of Level1 which is unde DT_File so only 3 levels

How Do I handle this in Content Conversion for File Receiver ??

Thanks

Dev

[Former Member · Accepted solution]

Hi DEV,

Try with this.....I hope this may help u.

DT_File

Level1(0..unbounded)

Level2(1)

field1

field2

Level2a(1)

field3

field4

Level2b(1)

field4

field5

Recordset Structure Level2,Level2a,Level2b

Level2.fieldSeparator ,

Level2a.fieldSeparator ,

Level2b.fieldSeparator ,

If still nt solved pl do post

Babu

[Former Member · Accepted solution]

Hi Babu

Thanks for yourreply I just have one question

In my structure i have two additional fields (1a, 1b, are at the same level as1c and 1a and 1b also have two fields each)

DT_File

Level1a(1)

fielda

Level1b(1)

fieldb

Level1c(0..unbounded)

Level2(1)

field1

field2

Level2a(1)

field3

field4

Level2b(1)

field4

field5

According to your reply if i use the record set as

Recordset Structure Level2,Level2a,Level2b

How will I account for the fields under Level 1a and Level1b

Can i use :

Recordset Structure Level1a,Level1b,Level2,Level2a,Level2b

Level1a.fieldSeparator ,

Level1b.fieldSeparator ,

Level2.fieldSeparator ,

Level2a.fieldSeparator ,

Level2b.fieldSeparator ,

Thanks

Dev

[Former Member · Accepted solution]

Hi

I am unsure if this structure can be handled by FCC.

Is it possible to convert into some simplified structure and then by means of an additional mapping step one more level of hierarchy of repeating lines to be created ??

Can any one help me on this please ?

Thanks

Dev

[Former Member]

Dear Gurus,

I have xml source structure like below

MT_input

root

node 1

field 1

field 2

node 2 - 1 -- unbound

subnodenode3 -- i - unbound

fields 4

flat Target Structure is like to

MT_out

root -- 0- unbound

field1

field 2

field 4

for every occurance in source xml , i need to generate flat file record, can you please advice.

Thanks.

Sam.

[Former Member]

Hi,

U can have upto three level in FCC.

For ur scenario....

Dt_File -> Repeating Level1->Level2 ->Field1

->Level2a->Field3

-> Level2b->Field5

This is nt clear.. please provide with proper structure.

like

Dt_File

Level1(0..1)

Repeating unit(0..unvbounded)

field1(0..1)

field2(1)

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

If it is exactly above then it's possible.

Babu.

[Former Member]

Hi Babu

for my scenario the data type is

DT_File

RepeatingLevel(0..unbounded)

Level1(1)

field1(0..1)

field2(0..1)

Level2(1)

field3(0..1)

field4(0...1)

Level3(1)

field5(0..1)

field6(0..1)

here Repeating level is a sub element of DT_File

Level1 Level2 Level3 are at the same level as sub elements of Repeating Level

and field 1 field are subelements of Level1 and so on ...

is it possible ?

or should i have a sperate structure for the file

i am unable to create the structure for the file

Thanks

Dev

[Former Member]

Hi,

Please refer to this blog

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

Best Regards,

Lakshmi

[Former Member]

Hi Lakshmi

Tthe blog u provided talks about File Sender and Key field concept

I am looking at a multi level hierarchy and its treatment in Content Conversion where it is just 3 levels

ie.

the Data Type name

level 1

& level2

How to handle this at the File Content Conversion level

Thanks

Dev

[former_member206760]

hi sd,

here there is no meaning of the fields Level1, level2 , level3 in the target structure..

u can create a structure like this,

DT

->main(0..unbounded)

--->record1..1

-

---

>Filed1

-

---

>Field2

-

---

>Field3

etc

so receiver FCC would be

Recordset structure-----main,record

record.fieldSeperator -

---

comma

record.endSeperator -

---

nl

main.fieldSeperator -

---

nl

[Former Member]

Hi Tarang

My DT according to the target file structure is this :

DT_File

-

---

>Main1(1,1)

-

---

>Main2(1,1)

-

---

>Main3(0...unbounded)

-

---

>Record1(1,1)

-

---

>Field1

-

---

>Field2

-

---

>Field3

-

---

>Record2(1,1)

-

---

>Field4

-

---

>Field5

-

---

>Record3(1,1)

-

---

>Field6

-

---

>Field7

SO I want to confirm if the receiver FCC will be - Main1,Main2,Main3,Record1,Record2,Record3

Record1.fieldSeparator ,

Record1.endSeparator 'nl'

Record2.fieldSeparator ,

Record2.endSeparator 'nl'

Record3.fieldSeparator ,

Record3.endSeparator 'nl'

or Main1,Main2,Record1,Record2,Record3

Thanks

Dev

[former_member206760]

try

DT_File

> -

---

>Main1(1,1)

> -

---

>Main2(1,1)

> -

---

>Main3(0...unbounded)

> -

---

>Record(1,1)

> -

---

>Field1

> -

---

>Field2

> -

---

>Field3

> -

---

>Field4

> -

---

>Field5

> -

---

>Field6

> -

---

>Field7

>

> receiver FCC will be - Main1,Main2,Main3,Record

>

>

> main1.fieldSeparator ,

> main1.endSeparator 'nl'

> main2.fieldSeparator ,

> main2.endSeparator 'nl'

> Record.fieldSeparator ,

> Record.endSeparator 'nl'

> main3.fieldSeparator nl

Edited by: Tarang Shah on Feb 25, 2010 8:47 PM

Edited by: Tarang Shah on Feb 25, 2010 8:48 PM

Edited by: Tarang Shah on Feb 25, 2010 8:49 PM

Edited by: Tarang Shah on Feb 25, 2010 8:49 PM

[Former Member]

not possible

field 1 2 3 are in 1st Line

field 4 and 5 in the next

field 6 is i nthe last

it is a set of these 3 lines that have to be repeated

so the whole structure has to be repeated

rest everything occurs only once in the file

so the structure that i have given is the one ......that has to be used .. but even that is 3 levels only .. cant that be used ???

\

Thanks

Dev

[Former Member]

Can the following be achieved ,, This structure is just 3 levels down and i hope this can be done without an intermediate mapping or writing an Adapter module

Kindly guide me if some one can help me any link or blog for the same

Thanks

Dev

[Former Member]

If the structure is of just 3 levels..then refer the below wiki's .

Hope this solves your issue.

http://wiki.sdn.sap.com/wiki/display/XI/XI_File_Content

http://wiki.sdn.sap.com/wiki/display/XI/BasicFileAdapterContentConversion

Regards,

Swetha.

[Former Member]

Hi Swetha

The structure is

DT_File

-

---

>Main1(1,1)

-

---

>Main2(1,1)

-

---

>Main3(0...unbounded)

-

---

>Record1(1,1)

-

---

>Field1

-

---

>Field2

-

---

>Field3

-

---

>Record2(1,1)

-

---

>Field4

-

---

>Field5

-

---

>Record3(1,1)

-

---

>Field6

-

---

>Field7

Can this be tackled , by the following links provided ?

Thanks

Dev