Un-flattening XML-data

[Adri Genis]

Hi,

I am exporting data from a MS Access 2003-database and has to transform it
into a structured document. The input is as follows:

<departments>

<department>
<name>Community Services</name>
<person-in-charge-first-name>Gabriel</person-in-charge-first-name>
<person-in-charge-surname>Brown</person-in-charge-surname>
<portfolio-councillor-first-name>John</portfolio-councillor-first-name>
<portfolio-councillor-surname>Doe</portfolio-councillor-surname>
<primary-function>department primary function</primary-function>
<division-name>div1</division-name>
<division-person-in-charge-first-name>Peter</division-person-in-charge-first-name>
<division-person-in-charge-surname>Smith</division-person-in-charge-surname>
<division-function>Primary func here for div 1</division-function>
</department>
<department>
<name>Community Services</name>
<person-in-charge-first-name>Gabriel</person-in-charge-first-name>
<person-in-charge-surname>Brown</person-in-charge-surname>
<portfolio-councillor-first-name>John</portfolio-councillor-first-name>
<portfolio-councillor-surname>Doe</portfolio-councillor-surname>
<primary-function>department primary function</primary-function>
<division-name>div2</division-name>
<division-person-in-charge-first-name>Hillary</division-person-in-charge-first-name>
<division-person-in-charge-surname>Black</division-person-in-charge-surname>
<division-function>Primary func here for div 2</division-function>
</department>
</departments>

and the output has to be:

<departments>
<department name=Community Services>
<person-in-charge first-name=Gabriel surname=Brown/>
<portfolio-councillor first-name=John surname=Doe/>
<primary-functiondepartment primary function </primary-function>

<division name=div1>
<person-in-charge first-name=Peter surname=Smith/>
Primary func here for div 1
</division>

<division name=div2>
<person-in-charge first-name=Hillary surname=Black/>
Primary func here for div 2
</division>
</department>
</departments>

Any advice will be appreciated.

Regards,
Adri

[Latish Sehgal]

This can be done really easily using a XSLT transformation.
Check out http://www.w3schools.com/xsl/default.asp
for a really simple but good introduction.