- Joined
- May 23, 2010
- Messages
- 1
- Reaction score
- 0
I know how to write script from mysql to excel but I don't know how to write this xml to excel:
How can specify and write childs (bellow) to excel rows?
results->traffic_out->krit
results->traffic_out->pros
results->overall->kapa
Code:
<?xml version="1.0" encoding="UTF-8" ?>
- <!-- # wanstats
-->
- <cacti>
- <report>
- <settings>
<title>Wan_links</title>
<owner>Administrator (admin)</owner>
<template>wan_statistic</template>
<start>2010-04-03</start>
<end>2010-04-09</end>
<last_run>2010-04-10 22:34:05</last_run>
</settings>
- <variables>
- <variable>
<id>3</id>
<name>over90percent</name>
<description>Your description</description>
<value>10</value>
<min_value>10</min_value>
<max_value>100</max_value>
</variable>
</variables>
- <measurands>
- <measurand>
<abbreviation>CAPA</abbreviation>
<description>kapacitet</description>
</measurand>
- <measurand>
<abbreviation>CRIT</abbreviation>
<description>critical - time (%) more than 10% usage</description>
</measurand>
</measurands>
- <data_items>
- <item>
<description>MIAMI - wan546 - Gi1/0/8</description>
<subhead />
<start_day>Monday</start_day>
<end_day>Sunday</end_day>
<start_time>00:00:00</start_time>
<end_time>24:00:00</end_time>
<time_zone>GMT</time_zone>
- <results>
- <traffic_in>
<krit measurand="KRIT" unit="%">0</krit>
</traffic_in>
- <traffic_out>
<krit measurand="KRIT" unit="%">0</krit>
</traffic_out>
- <overall>
<kapa measurand="KAPA" unit="Bits/s">5.76E+8</kapa>
</overall>
</results>
</item>
- <item>
<description>LONDON[2] - wan134_Gi4/1/0.10</description>
<subhead />
<start_day>Monday</start_day>
<end_day>Sunday</end_day>
<start_time>00:00:00</start_time>
<end_time>24:00:00</end_time>
<time_zone>GMT</time_zone>
- <results>
- <traffic_in>
<krit measurand="KRIT" unit="%">0</krit>
</traffic_in>
- <traffic_out>
<krit measurand="KRIT" unit="%">0</krit>
</traffic_out>
- <overall>
<kapa measurand="KAPA" unit="Bits/s">32000000</kapa>
</overall>
</results>
</item>
</data_items>
</report>
</cacti>
How can specify and write childs (bellow) to excel rows?
results->traffic_out->krit
results->traffic_out->pros
results->overall->kapa