How to do content conversion three level structure?

[Former Member]

Hi all,

i am working on scenario file to idoc.sender side is tab delimited excel file and it is coming in three levels.i want to know that whether content conversion works for tab delimited excel file(extension .xls) and if it work means then how to do the content conversion for three level.

sender side structure is like this :

root

header occurance 1 fist level

e1edk01 1 second level

orgid 1 third level

line items occurance 0 to unbounded 1st level

e1edp01 0 to unbounded 2nd level

menge 0 to unbounded 3rd level

pstyv 0 to unbounded

thanks,

seshagiri

[Former Member]

Hi Seshagiri,

As the standard file adapter can support max to 2 level. In order if your hierarchy structure is more than 3 then Write the Java mapping and create your XML structure based on the read file. As you will be creating the xml Structure you can create as per you requirement Hierarchy i.e. upto 3 level hierarchy

Regards,

Chandra Shekhar.

[Former Member]

This may help u

http://www.riyaz.net/blog/xipi-convert-flat-file-to-deeply-nested-xml-structures-using-only-graphica...

[Shabarish_Nair]

you cannot do for 3 levels using the standard file adpater

[madhusudana_reddy2]

Hi Seshagir,

sender side is tab delimited excel file and it is coming in three levels.

XML May come in 3 levels or more, but how excel file will come in 3 levels???.

If you are getting sender data in the form of excel file then you need to use Module in sender channel to read and convert excel data into xml. Directly you can not read and convert excel file into xml.

thanks,

madhu