on 05-11-2010 12:21 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you cannot do for 3 levels using the standard file adpater
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.