j k

j k

  • NA
  • 34
  • 0

XML to excel/datagridview parsing

Aug 23 2011 3:41 PM
Hi All,
First of all I would like to thank you for the support. I am new in coding and need assistance in getting a specific xml content to an excel spreadsheet or to a datagridview.
 
the XML file is not a standard one (i think and below is a sample).
what i need from this xml file is the following data:
 
the name (Towers xxx] of the alert and the gps points (dont need the utm)
 
this is the xml
[code]
<?xml version="1.0" encoding="UTF-16"?>
<layer>
  <name>
  SF Zones
  </name>
  <alert_area_object>
  <creation_time>
  1303889594
  </creation_time>
  <name>
  Tower 1
  </name>
  <description> Fence Alert </description>
  <event_types num="1">
  <event_type>
  11111
  </event_type>
  </event_types>
  <event_severity>
  2
  </event_severity>
  <event_override_flag>
  false
  </event_override_flag>
  <identities num="0"/>
  <categories num="0"/>
  <groups num="0"/>
  <target_appear_in_area>
  true
  </target_appear_in_area>
  <target_enter_area>
  true
  </target_enter_area>
  <target_leave_area>
  true
  </target_leave_area>
  <from_hour>
  0
  </from_hour>
  <from_minute>
  0
  </from_minute>
  <to_hour>
  23
  </to_hour>
  <to_minute>
  59
  </to_minute>
  <from_speed>
  0
  </from_speed>
  <to_speed>
  98.8889
  </to_speed>
  <weighting>
  <weight>
  <type>
  2
  </type>
  <value> 99 </value>
  </weight>
  <weight>
  <type> 204 </type>
  <value>
  99
  </value>
  </weight>
  <weight>
  <type>
  205
  </type>
  <value>
  99
  </value>
  </weight>
  </weighting>
  <visual_feedback>
  true
  </visual_feedback>
  <sound_repeats>
  -1
  </sound_repeats>
  <wave_file>
  C:\4C\RunTime\OWP\Sounds\sirenwawa.wav
  </wave_file>
  <utm_zone>
  40
  </utm_zone>
  <shape type="ClosedPolygon">
  <num_of_alloc_points>
  22
  </num_of_alloc_points>
  <num_of_points>
  5
  </num_of_points>
  <geo_position lat="40.76876678920284" long="-73.98097831075269"/>
  <geo_position lat="40.76869191861909" long="-73.98078254132794"/>
  <geo_position lat="40.76839192572469" long="-73.97999998924834"/>
  <geo_position lat="40.76749000414105" long="-73.97804528571041"/>
  <geo_position lat="40.76643902004108" long="-73.97593868227233"/>
  <utm_points x="132131" y="132131"/>
  <utm_points x="132131" y="132131"/>
  <utm_points x="132131" y="132131"/>
  <utm_points x="132131" y="132131"/>
  <utm_points x="132131" y="132131"/>
  </shape>
  </alert_area_object>
  <alert_area_object>
  <creation_time>
  1303890003
  </creation_time>
  <name>
  Towers 1 to 4
  </name>
  <description>
  Fence Alert
  </description>
  <event_types num="1">
  <event_type>
  11111
  </event_type>
  </event_types>
  <event_severity>
  2
  </event_severity>
  <event_override_flag>
  false
  </event_override_flag>
  <identities num="0"/>
  <categories num="0"/>
  <groups num="0"/>
  <target_appear_in_area>
  true
  </target_appear_in_area>
  <target_enter_area>
  true
  </target_enter_area>
  <target_leave_area>
  true
  </target_leave_area>
  <from_hour>
  0
  </from_hour>
  <from_minute>
  0
  </from_minute>
  <to_hour>
  23
  </to_hour>
  <to_minute>
  59
  </to_minute>
  <from_speed>
  0
  </from_speed>
  <to_speed>
  98.8889
  </to_speed>
  <weighting>
  <weight>
  <type>
  2
  </type>
  <value>
  99
  </value>
  </weight>
  <weight>
  <type>
  204
  </type>
  <value>
  99
  </value>
  </weight>
  <weight>
  <type>
  205
  </type>
  <value>
  99
  </value>
  </weight>
  </weighting>
  <visual_feedback>
  true
  </visual_feedback>
  <sound_repeats>
  -1
  </sound_repeats>
  <wave_file>
  C:\4C\RunTime\OWP\Sounds\sirenwawa.wav
  </wave_file>
  <utm_zone>
  40
  </utm_zone>
  <shape type="ClosedPolygon">
  <num_of_alloc_points>
  22
  </num_of_alloc_points>
  <num_of_points>
  6
  </num_of_points>
  <geo_position lat="40.76876678920284" long="-73.98097831075269"/>
  <geo_position lat="40.76869191861909" long="-73.98078254132794"/>
  <geo_position lat="40.76839192572469" long="-73.97999998924834"/>
  <geo_position lat="40.76749000414105" long="-73.97804528571041"/>
  <geo_position lat="40.76643902004108" long="-73.97593868227233"/>
  <utm_points x="132131" y="132131"/>
  <utm_points x="132131" y="132131"/>
  <utm_points x="132131" y="132131"/>
  <utm_points x="132131" y="132131"/>
  <utm_points x="132131" y="132131"/>
  </shape>
  </alert_area_object>
</layer>
[/code]
 
thanks again

Answers (11)