root element in XML document

pillip · Post by **pillip** » Mon May 31, 2010 3:52 pm

Hi,

I need to generate an XML document which has a root element. I am able to get the rest of the document except the root element. I have checked the best practices document. Did not get much help. I feel I am missing something here.How do I obtain this root element using the XML output stage. Kindly suggest

Thanks.

chulett · Post by **chulett** » Mon May 31, 2010 4:13 pm

Just to make sure we're all on the same page, can you post an example of your "root element", please?

pillip · Post by **pillip** » Mon May 31, 2010 4:24 pm

Root element is "the parent" of all other elements.

Format :

<root>
<child>
<subchild>.....</subchild>
</child>
</root>

Thanks

chulett · Post by **chulett** » Mon May 31, 2010 6:27 pm

OK, that much I know, was looking for something more... specific, example wise.

Not sure why you're not getting that unless you've enabled the 'chunk' (off the top of my head) property or left off the leading slash. Perhaps it might help to post the XPath Expressions you are using?

pillip · Post by **pillip** » Mon May 31, 2010 7:05 pm

Below is the format required :

<note ElementID="x">
- <Table>
<MANDT>n1</MANDT>
<MATNR>n2</MATNR>
<SPRAS>n3</SPRAS>
<MAKTX>n4</MAKTX>
<MAKTG>n5</MAKTG>
</Table>
- </Table>
<MANDT>p1</MANDT>
<MATNR>p2</MATNR>
<SPRAS>p3</SPRAS>
<MAKTX>p4</MAKTX>
<MAKTG>p5</MAKTG>
</Table>
'
'
'
'
'
'
-</note >

what xpath expressions do i need to use for the root(arrayofmaterialdescriptions). Here note is the root element and Table is the child element, whch has the other elements.

I am unable to get the root element.

chulett · Post by **chulett** » Mon May 31, 2010 8:12 pm

Do you have an xsd for this target? If so, then import the metadata from it and the Importer will automatically generate the proper XPath Expressions for you. If not... post what you are using now.

eostic · Post by **eostic** » Tue Jun 01, 2010 6:32 am

The root is usually going to be the first string in your Description property on the input link of your XMLOutput Stage...... EVERY column will have the same value for that first string.....so, I would exect, in your job, to see every Description starting with /arrayofmaterialdescriptions/...

Sometimes, when the repetition isn't right you will get incorrectly get duplicates of your desired root, but you should always get the string....

Ernie