|
|
 next
|
  Subject: Need help converting CSV to Nested XML
Author: Billy Dean
Date: 13 Oct 2007 10:27 AM
Originally Posted: 13 Oct 2007 10:19 AM
|
I have been able to use the CSV to XML to convert to XML, but can't create the nested XML as I need to. Here's my problem:
Input file:
Network: 10.0.0.0, Name0, ... 5 fields
Network: 11.0.0.0, Name1, ... 5 fields
Network: 12.0.0.0, Name2, ... 5 fields
Host: 12.0.0.1, HostName1, ... 10 fields
Host: 12.0.0.2, HostName2, ... 10 fields
Host: 12.0.0.3, HostName3, ... 10 fields
Network: 13.0.0.0, Name3, ... 5 fields
Host: 13.0.0.1, HostName4, ... 10 fields
I can use the CSV to XML and get the following:
<Network>
<Network range=10.0.0.0 name='Name0' ... 5 attributes/>
<Network range=11.0.0.0 name='Name1' ... 5 attributes/>
<Network range=12.0.0.0 name='Name2' ... 5 attributes/>
<Network range=13.0.0.0 name='Name3' ... 5 attributes/>
</Network>
<Host>
<Host address=12.0.0.1 name=Hostname1 ... 10 attributes/>
<Host address=12.0.0.2 .../>
<Host address=12.0.0.3 .../>
<Host address=13.0.0.1 .../>
</Host>
But this is not what I want. I want the Hosts to be nested under the Network like this:
<Network>
<Network 10.0.0.0 ... />
<Network 11.0.0.0 ... />
<Network 12.0.0.0 ... >
<Host address=12.0.0.1 .../>
<Host address=12.0.0.2 .../>
<Host address=12.0.0.3 .../>
</Network 12.0.0.0>
<Network 13.0.0.0 ... >
<Host address=13.0.0.1 .../>
</Network 13.0.0.0>
</Network>
This stems from the perceived limitation in the CSVtoXML tool that doesn't allow me to create 'Child-elements' during the initial conversion.
Is there something I'm missing? Or is there an easy XSLT transform to deal with this?
Thanks,
Billy
|
|
|
|
top