Hello,
First post here, so firstly I would like to say thank you in advance for anyone who reads and helps me out.
I would like to take some XML and generate CSV via XSLT. I'm not too bad at that however I have an issue with how i need it to look.
My XML links together by using ids to have parents etc (clearly if you look at the XML below). Basically I need to produce the result below it and I am really struggling, due to the fact theat I am confused with loops and things like that within XSLT.
The parentid relates to a group id.
To let you know the employee numbers will always be in the bottom tier but there can be unlimited tiers and groups.
Hope that makes sense. Any help greatly appreciated.
[u]
XML</u>
Code:
<company comp-id="12345">
<tier depth="1" name="Company">
<group name="My Company" groupid="1" parentid="0" />
</tier>
<tier depth="2" name="Division">
<group name="Shop" groupid="3" parentid="1" />
<group name="Office" groupid="4" parentid="1" />
<group name="Warehouse" groupid="5" parentid="1" />
</tier>
<tier depth="3" name="Department">
<group name="Admin" groupid="6" parentid="3">
<employee number="166" name="Dave" />
<employee number="345" name="Phil" />
</group>
<group name="Assistants" groupid="7" parentid="4">
<employee number="678" name="James" />
<employeenumber="034" name="Bill" />
</group>
<group name="Managers" groupid="8" parentid="5">
<employee number="87" name="Paul" />
</group>
</tier>
</company>
[u]
OUTPUT</u>
Code:
12345,My Company
12345,My Company,Shop
12345,My Company,Shop,Admin
12345,My Company,Shop,Admin,166
12345,My Company,Shop,Admin,345
12345,My Company,Office
12345,My Company,Office,Assistants
12345,My Company,Office,Assistants,678
12345,My Company,Office,Assistants,034
12345,My Company,Warehouse
12345,My Company,Warehouse,Managers
12345,My Company,Warehouse,Managers,87
Producing a loop of XML in CSV
