XML Processing

C:\s0000001_e.xml
I have an attached file that I am trying to load using the XML part of the visual importer.

I can get the feilds by setting the table tag to siteData, however I am unable to read any of the values unless they are selected individually and with the tool I can only select one.

How should I be processing this file ?

The Site XML Tags and Attributes for this file can be found on dd.weatheroffice.ec.gc.ca/citypage_weath...cs/tags_table_e.html .

Thanks

Which values are you trying to read?

I selected siteData and dateTime and I am able to see some data

Mike

I guess I am not sure on how I need to process the file. Although I can see individual parts .. I had expected to read all of the values that are in the file .. similar to a .csv or .txt file.

How do I need to set this up ?

Thanks

Your file has got complex structure
It has multiple levels
You can process some parts of it but not all parts at the the same time

This the structure we can process at the moment

<table>
<record>
<field1>value1<field1>
<field2>value2<field1>
<record>
<record>
<field1>value1<field1>
<field2>value2<field1>
<record>
<table>

Are you sure that you want all of it at the same time?

Mike

It would be best to process it all as one file as it contains the actual and forecast data at the time the actual measurement was done.

Processing as seperate segments would get complex.

The data is similar to what is on www.weatheroffice.gc.ca/city/pages/ab-52_metric_e.html

Thanks

Well

I understand it

But is is a web page and not the csv file you want to produce

If you provide us with the csv file you want to create we will have a look at what we can do about it

Mike