Solved

Read out xml from yr.no

Posted on 2008-10-20
2
611 Views
Last Modified: 2009-04-02
How can I read out the weatherdata from this xml? http://www.yr.no/sted/Sverige/Västmanland/Kungsörs_Kommun/varsel.xml
Cant get so deep in the xml
- <weatherdata>
- <location>
  <name>Kungsörs Kommun</name> 
  <type>Administrativ inndeling</type> 
  <country>Sverige</country> 
  <timezone id="Europe/Stockholm" utcoffsetMinutes="120" /> 
  <location altitude="16" latitude="59.4333333" longitude="16.1" geobase="geonames" geobaseid="2698680" /> 
  </location>
- <links>
  <link id="xmlSource" url="http://www.yr.no/sted/Sverige/Västmanland/Kungsörs_Kommun/varsel.xml" /> 
  <link id="overview" url="http://www.yr.no/sted/Sverige/Västmanland/Kungsörs_Kommun/" /> 
  <link id="hourByHour" url="http://www.yr.no/sted/Sverige/Västmanland/Kungsörs_Kommun/time_for_time.html" /> 
  <link id="weekend" url="http://www.yr.no/sted/Sverige/Västmanland/Kungsörs_Kommun/helg.html" /> 
  <link id="longTermForecast" url="http://www.yr.no/sted/Sverige/Västmanland/Kungsörs_Kommun/langtidsvarsel.html" /> 
  <link id="radar" url="http://www.yr.no/sted/Sverige/Västmanland/Kungsörs_Kommun/radar.html" /> 
  </links>
- <meta>
  <lastupdate>2008-10-21T09:12:23</lastupdate> 
  <nextupdate>2008-10-21T18:00:00</nextupdate> 
  </meta>
- <forecast>
- <tabular>
- <time from="2008-10-21T12:00:00" to="2008-10-21T18:00:00" period="2">
- <!--  Valid from 2008-10-21T12:00:00 to 2008-10-21T18:00:00 
  --> 
  <symbol number="4" name="Skyet" /> 
  <precipitation value="0.0" /> 
- <!--  Valid at 2008-10-21T12:00:00 
  --> 
  <windDirection deg="214.7" code="SW" name="Sørvest" /> 
  <windSpeed mps="4.4" name="Lett bris" /> 
  <temperature unit="celcius" value="11" /> 
  <pressure unit="hPa" value="996.4" /> 
  </time>
- <time from="2008-10-21T18:00:00" to="2008-10-22T00:00:00" period="3">
- <!--  Valid from 2008-10-21T18:00:00 to 2008-10-22T00:00:00 
  --> 
  <symbol number="2" name="Lettskyet" /> 
  <precipitation value="0.3" /> 
- <!--  Valid at 2008-10-21T18:00:00 
  --> 
  <windDirection deg="215.4" code="SW" name="Sørvest" /> 
  <windSpeed mps="5.3" name="Lett bris" /> 
  <temperature unit="celcius" value="10" /> 
  <pressure unit="hPa" value="995.9" /> 
  </time>
- <time from="2008-10-22T00:00:00" to="2008-10-22T06:00:00" period="0">
- <!--  Valid from 2008-10-22T00:00:00 to 2008-10-22T06:00:00 
  --> 
  <symbol number="1" name="Sol" /> 
  <precipitation value="0.0" /> 
- <!--  Valid at 2008-10-22T00:00:00 
  --> 
  <windDirection deg="231.0" code="SW" name="Sørvest" /> 
  <windSpeed mps="6.9" name="Laber bris" /> 
  <temperature unit="celcius" value="9" /> 
  <pressure unit="hPa" value="998.2" /> 
  </time>
- <time from="2008-10-22T06:00:00" to="2008-10-22T12:00:00" period="1">
- <!--  Valid from 2008-10-22T06:00:00 to 2008-10-22T12:00:00 
  --> 
  <symbol number="2" name="Lettskyet" /> 
  <precipitation value="0.3" /> 
- <!--  Valid at 2008-10-22T06:00:00 
  --> 
  <windDirection deg="232.6" code="SW" name="Sørvest" /> 
  <windSpeed mps="6.0" name="Laber bris" /> 
  <temperature unit="celcius" value="7" /> 
  <pressure unit="hPa" value="1003.9" /> 
  </time>
- <time from="2008-10-22T12:00:00" to="2008-10-22T18:00:00" period="2">
- <!--  Valid from 2008-10-22T12:00:00 to 2008-10-22T18:00:00 
  --> 
  <symbol number="1" name="Sol" /> 
  <precipitation value="0.0" /> 
- <!--  Valid at 2008-10-22T12:00:00 
  --> 
  <windDirection deg="238.7" code="WSW" name="Vest-sørvest" /> 
  <windSpeed mps="6.0" name="Laber bris" /> 
  <temperature unit="celcius" value="9" /> 
  <pressure unit="hPa" value="1008.9" /> 
  </time>
- <time from="2008-10-22T18:00:00" to="2008-10-23T00:00:00" period="3">
- <!--  Valid from 2008-10-22T18:00:00 to 2008-10-23T00:00:00 
  --> 
  <symbol number="2" name="Lettskyet" /> 
  <precipitation value="0.0" /> 
- <!--  Valid at 2008-10-22T18:00:00 
  --> 
  <windDirection deg="228.2" code="SW" name="Sørvest" /> 
  <windSpeed mps="5.0" name="Lett bris" /> 
  <temperature unit="celcius" value="8" /> 
  <pressure unit="hPa" value="1011.2" /> 
  </time>
- <time from="2008-10-23T00:00:00" to="2008-10-23T06:00:00" period="0">
- <!--  Valid from 2008-10-23T00:00:00 to 2008-10-23T06:00:00 
  --> 
  <symbol number="2" name="Lettskyet" /> 
  <precipitation value="0.2" /> 
- <!--  Valid at 2008-10-23T00:00:00 
  --> 
  <windDirection deg="221.2" code="SW" name="Sørvest" /> 
  <windSpeed mps="3.8" name="Lett bris" /> 
  <temperature unit="celcius" value="6" /> 
  <pressure unit="hPa" value="1014.0" /> 
  </time>
- <time from="2008-10-23T06:00:00" to="2008-10-23T12:00:00" period="1">
- <!--  Valid from 2008-10-23T06:00:00 to 2008-10-23T12:00:00 
  --> 
  <symbol number="1" name="Sol" /> 
  <precipitation value="0.0" /> 
- <!--  Valid at 2008-10-23T06:00:00 
  --> 
  <windDirection deg="237.3" code="WSW" name="Vest-sørvest" /> 
  <windSpeed mps="3.7" name="Lett bris" /> 
  <temperature unit="celcius" value="5" /> 
  <pressure unit="hPa" value="1016.5" /> 
  </time>
- <time from="2008-10-23T12:00:00" to="2008-10-23T18:00:00" period="2">
- <!--  Valid from 2008-10-23T12:00:00 to 2008-10-23T18:00:00 
  --> 
  <symbol number="2" name="Lettskyet" /> 
  <precipitation value="0.0" /> 
- <!--  Valid at 2008-10-23T12:00:00 
  --> 
  <windDirection deg="233.2" code="SW" name="Sørvest" /> 
  <windSpeed mps="5.4" name="Lett bris" /> 
  <temperature unit="celcius" value="9" /> 
  <pressure unit="hPa" value="1018.3" /> 
  </time>
- <time from="2008-10-23T20:00:00" to="2008-10-24T02:00:00" period="3">
- <!--  Valid from 2008-10-23T20:00:00 to 2008-10-24T02:00:00 
  --> 
  <symbol number="4" name="Skyet" /> 
  <precipitation value="0.0" /> 
- <!--  Valid at 2008-10-23T20:00:00 
  --> 
  <windDirection deg="206.4" code="SSW" name="Sør-sørvest" /> 
  <windSpeed mps="3.5" name="Lett bris" /> 
  <temperature unit="celcius" value="8" /> 
  <pressure unit="hPa" value="1017.7" /> 
  </time>
- <time from="2008-10-24T02:00:00" to="2008-10-24T08:00:00" period="0">
- <!--  Valid from 2008-10-24T02:00:00 to 2008-10-24T08:00:00 
  --> 
  <symbol number="3" name="Delvis skyet" /> 
  <precipitation value="0.0" /> 
- <!--  Valid at 2008-10-24T02:00:00 
  --> 
  <windDirection deg="204.4" code="SSW" name="Sør-sørvest" /> 
  <windSpeed mps="4.8" name="Lett bris" /> 
  <temperature unit="celcius" value="8" /> 
  <pressure unit="hPa" value="1015.7" /> 
  </time>
- <time from="2008-10-24T08:00:00" to="2008-10-24T14:00:00" period="1">
- <!--  Valid from 2008-10-24T08:00:00 to 2008-10-24T14:00:00 
  --> 
  <symbol number="4" name="Skyet" /> 
  <precipitation value="0.0" /> 
- <!--  Valid at 2008-10-24T08:00:00 
  --> 
  <windDirection deg="205.3" code="SSW" name="Sør-sørvest" /> 
  <windSpeed mps="4.9" name="Lett bris" /> 
  <temperature unit="celcius" value="8" /> 
  <pressure unit="hPa" value="1013.4" /> 
  </time>
- <time from="2008-10-24T14:00:00" to="2008-10-24T20:00:00" period="2">
- <!--  Valid from 2008-10-24T14:00:00 to 2008-10-24T20:00:00 
  --> 
  <symbol number="4" name="Skyet" /> 
  <precipitation value="0.0" /> 
- <!--  Valid at 2008-10-24T14:00:00 
  --> 
  <windDirection deg="203.3" code="SSW" name="Sør-sørvest" /> 
  <windSpeed mps="6.4" name="Laber bris" /> 
  <temperature unit="celcius" value="11" /> 
  <pressure unit="hPa" value="1013.0" /> 
  </time>
- <time from="2008-10-24T20:00:00" to="2008-10-25T02:00:00" period="3">
- <!--  Valid from 2008-10-24T20:00:00 to 2008-10-25T02:00:00 
  --> 
  <symbol number="9" name="Regn" /> 
  <precipitation value="0.9" /> 
- <!--  Valid at 2008-10-24T20:00:00 
  --> 
  <windDirection deg="194.2" code="SSW" name="Sør-sørvest" /> 
  <windSpeed mps="4.6" name="Lett bris" /> 
  <temperature unit="celcius" value="10" /> 
  <pressure unit="hPa" value="1010.4" /> 
  </time>
- <time from="2008-10-25T02:00:00" to="2008-10-25T08:00:00" period="0">
- <!--  Valid from 2008-10-25T02:00:00 to 2008-10-25T08:00:00 
  --> 
  <symbol number="2" name="Lettskyet" /> 
  <precipitation value="0.5" /> 
- <!--  Valid at 2008-10-25T02:00:00 
  --> 
  <windDirection deg="204.5" code="SSW" name="Sør-sørvest" /> 
  <windSpeed mps="6.4" name="Laber bris" /> 
  <temperature unit="celcius" value="7" /> 
  <pressure unit="hPa" value="1008.9" /> 
  </time>
- <time from="2008-10-25T08:00:00" to="2008-10-25T14:00:00" period="1">
- <!--  Valid from 2008-10-25T08:00:00 to 2008-10-25T14:00:00 
  --> 
  <symbol number="9" name="Regn" /> 
  <precipitation value="0.8" /> 
- <!--  Valid at 2008-10-25T08:00:00 
  --> 
  <windDirection deg="222.9" code="SW" name="Sørvest" /> 
  <windSpeed mps="3.8" name="Lett bris" /> 
  <temperature unit="celcius" value="6" /> 
  <pressure unit="hPa" value="1010.5" /> 
  </time>
- <time from="2008-10-25T14:00:00" to="2008-10-25T20:00:00" period="2">
- <!--  Valid from 2008-10-25T14:00:00 to 2008-10-25T20:00:00 
  --> 
  <symbol number="5" name="Regnbyger" /> 
  <precipitation value="0.9" /> 
- <!--  Valid at 2008-10-25T14:00:00 
  --> 
  <windDirection deg="210.0" code="SSW" name="Sør-sørvest" /> 
  <windSpeed mps="8.9" name="Frisk bris" /> 
  <temperature unit="celcius" value="8" /> 
  <pressure unit="hPa" value="1007.6" /> 
  </time>
- <time from="2008-10-25T20:00:00" to="2008-10-26T02:00:00" period="3">
- <!--  Valid from 2008-10-25T20:00:00 to 2008-10-26T02:00:00 
  --> 
  <symbol number="1" name="Sol" /> 
  <precipitation value="0.2" /> 
- <!--  Valid at 2008-10-25T20:00:00 
  --> 
  <windDirection deg="231.3" code="SW" name="Sørvest" /> 
  <windSpeed mps="4.3" name="Lett bris" /> 
  <temperature unit="celcius" value="5" /> 
  <pressure unit="hPa" value="1007.1" /> 
  </time>
- <time from="2008-10-26T13:00:00" to="2008-10-26T19:00:00" period="2">
- <!--  Valid from 2008-10-26T13:00:00 to 2008-10-26T19:00:00 
  --> 
  <symbol number="9" name="Regn" /> 
  <precipitation value="4.0" /> 
- <!--  Valid at 2008-10-26T13:00:00 
  --> 
  <windDirection deg="182.7" code="S" name="Sør" /> 
  <windSpeed mps="5.2" name="Lett bris" /> 
  <temperature unit="celcius" value="7" /> 
  <pressure unit="hPa" value="1002.0" /> 
  </time>
- <time from="2008-10-27T13:00:00" to="2008-10-27T19:00:00" period="2">
- <!--  Valid from 2008-10-27T13:00:00 to 2008-10-27T19:00:00 
  --> 
  <symbol number="1" name="Sol" /> 
  <precipitation value="0.8" /> 
- <!--  Valid at 2008-10-27T13:00:00 
  --> 
  <windDirection deg="327.9" code="NNW" name="Nord-nordvest" /> 
  <windSpeed mps="9.7" name="Frisk bris" /> 
  <temperature unit="celcius" value="3" /> 
  <pressure unit="hPa" value="986.8" /> 
  </time>
- <time from="2008-10-28T13:00:00" to="2008-10-28T19:00:00" period="2">
- <!--  Valid from 2008-10-28T13:00:00 to 2008-10-28T19:00:00 
  --> 
  <symbol number="3" name="Delvis skyet" /> 
  <precipitation value="0.0" /> 
- <!--  Valid at 2008-10-28T13:00:00 
  --> 
  <windDirection deg="266.5" code="W" name="Vest" /> 
  <windSpeed mps="5.0" name="Lett bris" /> 
  <temperature unit="celcius" value="4" /> 
  <pressure unit="hPa" value="1000.4" /> 
  </time>
- <time from="2008-10-29T13:00:00" to="2008-10-29T19:00:00" period="2">
- <!--  Valid from 2008-10-29T13:00:00 to 2008-10-29T19:00:00 
  --> 
  <symbol number="4" name="Skyet" /> 
  <precipitation value="0.0" /> 
- <!--  Valid at 2008-10-29T13:00:00 
  --> 
  <windDirection deg="2.6" code="N" name="Nord" /> 
  <windSpeed mps="1.7" name="Svak vind" /> 
  <temperature unit="celcius" value="1" /> 
  <pressure unit="hPa" value="1001.4" /> 
  </time>
- <time from="2008-10-30T13:00:00" to="2008-10-30T19:00:00" period="2">
- <!--  Valid from 2008-10-30T13:00:00 to 2008-10-30T19:00:00 
  --> 
  <symbol number="3" name="Delvis skyet" /> 
  <precipitation value="0.0" /> 
- <!--  Valid at 2008-10-30T13:00:00 
  --> 
  <windDirection deg="9.5" code="N" name="Nord" /> 
  <windSpeed mps="2.4" name="Svak vind" /> 
  <temperature unit="celcius" value="1" /> 
  <pressure unit="hPa" value="1001.5" /> 
  </time>
  </tabular>
  </forecast>
  </weatherdata>

Open in new window

0
Comment
Question by:ezzet
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 23

Accepted Solution

by:
Tony McCreath earned 500 total points
ID: 22806850
This should get you started.

You need to work out the data you want and create XPath expressions to get to it.
<%
Dim httpReq, xmlDoc, locationName
 
' Create the http reqiest object. you may want to use a different version
Set httpReq = Server.CreateObject("MSXML2.ServerXMLHTTP.4.0") 
 
' Create the request
Call httpReq.Open("GET", "http://www.yr.no/sted/Sverige/V%C3%A4stmanland/Kungs%C3%B6rs_Kommun/varsel.xml" , False) 
 
' send the request
httpReq.Send
 
' read the response into an XML document
Set responseDoc = httpReq.ResponseXML
 
' Read in some data using XPath syntax
locationName = responseDoc.SelectSingleNode("weatherdata/location/name").Text
 
' Display the data
Response.Write locationName
%>

Open in new window

0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question