hämta temp ur xml fil

fredde_900 · Post by **fredde_900** » Tue 29 Jan 2013, 07:09

Hej !

har försökt hämta temp ur en xml fil som kommer från weewx (egen väderstation) tyvärr är de mer på samma rad :

         <description>
           Outside temperature: -1.5&#176;C; 
           Barometer:    N/A; 
           Wind: 5.8 m/s from 0&#176;; 
           Rain rate:    N/A; 
           Inside temperature: 23.7&#176;C
         </description>

kan man på något sätt enbart plocka ut -1.5 ?
hittils har jag lyckats få med hela raden med xpath:

Code: Select all

/rss/channel[1]/item[1]/description[1]/text()

Mvh : fredde

Post by **Martin** » Tue 29 Jan 2013, 08:31

Om temperaturen alltid kommer på samma rad i filen kan du använda typen av datakälla där man använder tecken som separatorer. Du bör då kunna använda "space" och &-tecken som separatorer och läsa från rad "X". Om det är exakt som i kodexemplet så bör det vara fält 13 på rad 2 (...men du har väl några rader innan också).

fredde_900 · Post by **fredde_900** » Tue 29 Jan 2013, 09:07

har provat med position och då blir de rad 2 kol 249 och 4 tecken men när - grader blev till + blev de fel ... och inte lyckats klura ut hur jag ska använda tecken som separatorer på så långa rader... switchking verkar läsa filen rakt av utan enter...

/ Fredde

Post by **Martin** » Tue 29 Jan 2013, 09:27

Bifoga gärna hela filen i ett inlägg. Om du öppnar filen i en webbläsare så formaterar ju webbläsaren med rader etc, så det är säkert så att filen inte har radbrytningar (eller inte har Windows-radbrytningar).

fredde_900 · Post by **fredde_900** » Tue 29 Jan 2013, 12:25

använde wordpad :

Code: Select all

<?xml version="1.0"?>
<rss version="2.0" 
     xmlns:content="http://purl.org/rss/1.0/modules/content/"
     xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#" >
   <channel>
      <title>hej, Sweden, Weather Conditions</title>
      <link>http://www.weewx.com</link>
      <description>Current conditions, and daily, monthly, and yearly summaries</description>
      <language>en-us</language>
      <pubDate>Tue, 29 Jan 2013 08:55:00 CET</pubDate>

      <lastBuildDate>Tue, 29 Jan 2013 08:55:00 CET</lastBuildDate>
      <docs>http://blogs.law.harvard.edu/tech/rss</docs>
      <generator>weewx 2.1.1</generator>
      <ttl>5</ttl>
      
      <item>
         <title>Weather Conditions at 29-Jan-2013 08:55</title>
         <link>http://www.weewx.com/index.html</link>
         <description>
           Outside temperature: 2.5&#176;C; 
           Barometer:    N/A; 
           Wind: 4.4 m/s from 0&#176;; 
           Rain rate:    N/A; 
           Inside temperature: 22.6&#176;C
         </description>
         <pubDate>Tue, 29 Jan 2013 08:55:00 CET</pubDate>
	     <geo:lat>50</geo:lat>
    	 <geo:long>20.5</geo:long>
 		 <content:encoded><![CDATA[
           <p>
             Time:                29-Jan-2013 08:55<br/>
             Outside Temperature: 2.5&#176;C<br/>
             Inside Temperature:  22.6&#176;C<br/>
             Wind Chill:          2.2&#176;C<br/>
             Heat Index:          2.5&#176;C<br/>
             Dewpoint:            1.3&#176;C<br/>
             Humidity:            91%<br/>
             Barometer:              N/A<br/>
             Wind:                4.4 m/s from 0&#176;<br/>
             Rain Rate:              N/A<br/>
        </p>
      ]]></content:encoded>
      </item>

      <item>
         <title>Daily Weather Summary as of 29-Jan-2013 08:55</title>
         <link>http://www.weewx.com/index.html</link>
         <description>
	        Min outside temperature: -1.3&#176;C at 04:27;
         	Max outside temperature: 6.3&#176;C at 08:46;
	        Min inside temperature:  22.6&#176;C at 08:30;
	        Max inside temperature:  25.0&#176;C at 00:00;
	        Min barometer:              N/A at    N/A;
	        Max barometer:              N/A at    N/A;
            Max wind :               10.5 m/s from 0&#176; at 04:23;
            Rain today:              0.0 mm
         </description>
         <pubDate>Tue, 29 Jan 2013 08:55:00 CET</pubDate>
	     <geo:lat>56.495</geo:lat>
    	 <geo:long>16.5</geo:long>
 		 <content:encoded><![CDATA[
           <p>
             Day:                     29 Jan 2013<br/>
	         Min Outside Temperature: -1.3&#176;C at 04:27<br/>
	         Max Outside Temperature: 6.3&#176;C at 08:46<br/>
	         Min Inside Temperature:  22.6&#176;C at 08:30<br/>
	         Max Inside Temperature:  25.0&#176;C at 00:00<br/>
	         Min Barometer:              N/A at    N/A<br/>
	         Max Barometer:              N/A at    N/A<br/>
             Max Wind :               10.5 m/s from 0&#176; at 04:23<br/>
             Rain today:              0.0 mm<br/>
        </p>
      ]]></content:encoded>
      </item>

      <item>
         <title>Monthly Weather Summary as of 29-Jan-2013 08:55</title>
         <link>http://www.weewx.com/month.html</link>
         <description>
	        Min outside temperature: -9.9&#176;C at 26-Jan-2013 02:07;
         	Max outside temperature: 7.3&#176;C at 28-Jan-2013 13:26;
	        Min inside temperature:  21.3&#176;C at 26-Jan-2013 08:06;
	        Max inside temperature:  26.2&#176;C at 27-Jan-2013 18:44;
	        Min barometer:              N/A at    N/A;
	        Max barometer:              N/A at    N/A;
            Max wind :               16.0 m/s from 0&#176; at 26-Jan-2013 16:22;
            Rain total for month:    0.0 mm
         </description>
         <pubDate>Tue, 29 Jan 2013 08:55:00 CET</pubDate>
 		 <content:encoded><![CDATA[
           <p>
             Month:                   January 2013<br/>
	         Max Outside Temperature: 7.3&#176;C at 28-Jan-2013 13:26<br/>
	         Min Outside Temperature: -9.9&#176;C at 26-Jan-2013 02:07<br/>
	         Max Inside Temperature:  26.2&#176;C at 27-Jan-2013 18:44<br/>
	         Min Inside Temperature:  21.3&#176;C at 26-Jan-2013 08:06<br/>
	         Min Barometer:              N/A at    N/A<br/>
	         Max Barometer:              N/A at    N/A<br/>
             Max Wind :               16.0 m/s from 0&#176; at 26-Jan-2013 16:22<br/>
             Rain total for month:    0.0 mm<br/>
        </p>
      ]]></content:encoded>
      </item>

      <item>
         <title>Yearly Weather Summary as of 29-Jan-2013 08:55</title>
         <link>http://www.weewx.com/year.html</link>
         <description>
	        Min outside temperature: -9.9&#176;C at 26-Jan-2013 02:07;
         	Max outside temperature: 7.3&#176;C at 28-Jan-2013 13:26;
	        Min inside temperature:  21.3&#176;C at 26-Jan-2013 08:06;
	        Max inside temperature:  26.2&#176;C at 27-Jan-2013 18:44;
	        Min barometer:              N/A at    N/A;
	        Max barometer:              N/A at    N/A;
            Max wind :               16.0 m/s from 0&#176; at 26-Jan-2013 16:22;
            Rain total for year:     0.0 mm
         </description>
         <pubDate>Tue, 29 Jan 2013 08:55:00 CET</pubDate>
 		 <content:encoded><![CDATA[
           <p>
             Year:                    2013<br/>
	         Max Outside Temperature: 7.3&#176;C at 28-Jan-2013 13:26<br/>
	         Min Outside Temperature: -9.9&#176;C at 26-Jan-2013 02:07<br/>
	         Max Inside Temperature:  26.2&#176;C at 27-Jan-2013 18:44<br/>
	         Min Inside Temperature:  21.3&#176;C at 26-Jan-2013 08:06<br/>
	         Min Barometer:              N/A at    N/A<br/>
	         Max Barometer:              N/A at    N/A<br/>
             Max Wind :               16.0 m/s from 0&#176; at 26-Jan-2013 16:22<br/>
             Rain total for year:     0.0 mm<br/>
        </p>
      ]]></content:encoded>
      </item>

   </channel>
</rss>

/Fredde

Post by **Martin** » Tue 29 Jan 2013, 13:06

Ursprungsfilen behövs nog. Om du klistrar in i Wordpad så tror jag att Wordpad konverterar exempelvis radbrytningar som kommer från Linux till Windows-format automatiskt.

fredde_900 · Post by **fredde_900** » Tue 29 Jan 2013, 14:29

från chrome :

Code: Select all

This XML file does not appear to have any style information associated with it. The document tree is shown below.
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#" version="2.0">
<channel>
<title>hej, Sweden, Weather Conditions</title>
<link>http://www.weewx.com</link>
<description>
Current conditions, and daily, monthly, and yearly summaries
</description>
<language>en-us</language>
<pubDate>Tue, 29 Jan 2013 14:20:00 CET</pubDate>
<lastBuildDate>Tue, 29 Jan 2013 14:20:00 CET</lastBuildDate>
<docs>http://blogs.law.harvard.edu/tech/rss</docs>
<generator>weewx 2.1.1</generator>
<ttl>5</ttl>
<item>
<title>Weather Conditions at 29-Jan-2013 14:20</title>
<link>http://www.weewx.com/index.html</link>
<description>
Outside temperature: 3.3°C; Barometer: N/A; Wind: 3.0 m/s from 0°; Rain rate: N/A; Inside temperature: 21.9°C
</description>
<pubDate>Tue, 29 Jan 2013 14:20:00 CET</pubDate>
<geo:lat>50</geo:lat>
<geo:long>20.5</geo:long>
<content:encoded>
<![CDATA[
<p> Time: 29-Jan-2013 14:20<br/> Outside Temperature: 3.3&#176;C<br/> Inside Temperature: 21.9&#176;C<br/> Wind Chill: 3.3&#176;C<br/> Heat Index: 3.3&#176;C<br/> Dewpoint: 1.7&#176;C<br/> Humidity: 89%<br/> Barometer: N/A<br/> Wind: 3.0 m/s from 0&#176;<br/> Rain Rate: N/A<br/> </p>
]]>
</content:encoded>
</item>
<item>
<title>Daily Weather Summary as of 29-Jan-2013 14:20</title>
<link>http://www.weewx.com/index.html</link>
<description>
Min outside temperature: -1.3°C at 04:27; Max outside temperature: 6.4°C at 13:31; Min inside temperature: 21.9°C at 13:57; Max inside temperature: 25.0°C at 00:00; Min barometer: N/A at N/A; Max barometer: N/A at N/A; Max wind : 10.5 m/s from 0° at 04:23; Rain today: 0.0 mm
</description>
<pubDate>Tue, 29 Jan 2013 14:20:00 CET</pubDate>
<geo:lat>56.495</geo:lat>
<geo:long>16.5</geo:long>
<content:encoded>
<![CDATA[
<p> Day: 29 Jan 2013<br/> Min Outside Temperature: -1.3&#176;C at 04:27<br/> Max Outside Temperature: 6.4&#176;C at 13:31<br/> Min Inside Temperature: 21.9&#176;C at 13:57<br/> Max Inside Temperature: 25.0&#176;C at 00:00<br/> Min Barometer: N/A at N/A<br/> Max Barometer: N/A at N/A<br/> Max Wind : 10.5 m/s from 0&#176; at 04:23<br/> Rain today: 0.0 mm<br/> </p>
]]>
</content:encoded>
</item>
<item>
<title>Monthly Weather Summary as of 29-Jan-2013 14:20</title>
<link>http://www.weewx.com/month.html</link>
<description>
Min outside temperature: -9.9°C at 26-Jan-2013 02:07; Max outside temperature: 7.3°C at 28-Jan-2013 13:26; Min inside temperature: 21.3°C at 26-Jan-2013 08:06; Max inside temperature: 26.2°C at 27-Jan-2013 18:44; Min barometer: N/A at N/A; Max barometer: N/A at N/A; Max wind : 16.0 m/s from 0° at 26-Jan-2013 16:22; Rain total for month: 0.0 mm
</description>
<pubDate>Tue, 29 Jan 2013 14:20:00 CET</pubDate>
<content:encoded>
<![CDATA[
<p> Month: January 2013<br/> Max Outside Temperature: 7.3&#176;C at 28-Jan-2013 13:26<br/> Min Outside Temperature: -9.9&#176;C at 26-Jan-2013 02:07<br/> Max Inside Temperature: 26.2&#176;C at 27-Jan-2013 18:44<br/> Min Inside Temperature: 21.3&#176;C at 26-Jan-2013 08:06<br/> Min Barometer: N/A at N/A<br/> Max Barometer: N/A at N/A<br/> Max Wind : 16.0 m/s from 0&#176; at 26-Jan-2013 16:22<br/> Rain total for month: 0.0 mm<br/> </p>
]]>
</content:encoded>
</item>
<item>
<title>Yearly Weather Summary as of 29-Jan-2013 14:20</title>
<link>http://www.weewx.com/year.html</link>
<description>
Min outside temperature: -9.9°C at 26-Jan-2013 02:07; Max outside temperature: 7.3°C at 28-Jan-2013 13:26; Min inside temperature: 21.3°C at 26-Jan-2013 08:06; Max inside temperature: 26.2°C at 27-Jan-2013 18:44; Min barometer: N/A at N/A; Max barometer: N/A at N/A; Max wind : 16.0 m/s from 0° at 26-Jan-2013 16:22; Rain total for year: 0.0 mm
</description>
<pubDate>Tue, 29 Jan 2013 14:20:00 CET</pubDate>
<content:encoded>
<![CDATA[
<p> Year: 2013<br/> Max Outside Temperature: 7.3&#176;C at 28-Jan-2013 13:26<br/> Min Outside Temperature: -9.9&#176;C at 26-Jan-2013 02:07<br/> Max Inside Temperature: 26.2&#176;C at 27-Jan-2013 18:44<br/> Min Inside Temperature: 21.3&#176;C at 26-Jan-2013 08:06<br/> Min Barometer: N/A at N/A<br/> Max Barometer: N/A at N/A<br/> Max Wind : 16.0 m/s from 0&#176; at 26-Jan-2013 16:22<br/> Rain total for year: 0.0 mm<br/> </p>
]]>
</content:encoded>
</item>
</channel>
</rss>

/fredde

Post by **Martin** » Tue 29 Jan 2013, 14:44

Nu känner jag mig som en riktig plåga, men det som Chrome visar är också redan formaterat till en "xml-anpassad vy".
För att kunna veta exakt var i filen man ska leta för att hitta temperaturen måste man ha filen som den ser ut direkt från källan, innan något verktyg (som Chrome) har varit inne och skruvat på innehållet och därmed presenterar en "förfinad vy".
Eftersom Weewx är en linuxbaserad mjukvara så är det nästan säkert så att radbrytningarna i dokumentet är linux-varianter. Switch King läser bara standardradbrytningar och det är därför det inte fungerar att ange "rad 14" - Windows uppfattar hela dokumentet som en enda lång rad tecken.

Alternativet är om du själv äger väderstationen och kan ändra så att "grader celcius" inte kommer med i dokumentet.

fredde_900 · Post by **fredde_900** » Tue 29 Jan 2013, 15:12

jag använde anteckningar när jag fick fram rad osv kanske den som visar de bäst ? alla editor å sånt jag provat öppna filen med ser ut som dom övriga men inte i anteckningar... :

Code: Select all


<?xml version="1.0"?>
<rss version="2.0" 
     xmlns:content="http://purl.org/rss/1.0/modules/content/"
     xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#" >
   <channel>
      <title>hej, Sweden, Weather Conditions</title>
      <link>http://www.weewx.com</link>
      <description>Current conditions, and daily, monthly, and yearly summaries</description>
      <language>en-us</language>
      <pubDate>Tue, 29 Jan 2013 14:20:00 CET</pubDate>

      <lastBuildDate>Tue, 29 Jan 2013 14:20:00 CET</lastBuildDate>
      <docs>http://blogs.law.harvard.edu/tech/rss</docs>
      <generator>weewx 2.1.1</generator>
      <ttl>5</ttl>
      
      <item>
         <title>Weather Conditions at 29-Jan-2013 14:20</title>
         <link>http://www.weewx.com/index.html</link>
         <description>
           Outside temperature: 3.3&#176;C; 
           Barometer:    N/A; 
           Wind: 3.0 m/s from 0&#176;; 
           Rain rate:    N/A; 
           Inside temperature: 21.9&#176;C
         </description>
         <pubDate>Tue, 29 Jan 2013 14:20:00 CET</pubDate>
	     <geo:lat>50</geo:lat>
    	 <geo:long>20.5</geo:long>
 		 <content:encoded><![CDATA[
           <p>
             Time:                29-Jan-2013 14:20<br/>
             Outside Temperature: 3.3&#176;C<br/>
             Inside Temperature:  21.9&#176;C<br/>
             Wind Chill:          3.3&#176;C<br/>
             Heat Index:          3.3&#176;C<br/>
             Dewpoint:            1.7&#176;C<br/>
             Humidity:            89%<br/>
             Barometer:              N/A<br/>
             Wind:                3.0 m/s from 0&#176;<br/>
             Rain Rate:              N/A<br/>
        </p>
      ]]></content:encoded>
      </item>

      <item>
         <title>Daily Weather Summary as of 29-Jan-2013 14:20</title>
         <link>http://www.weewx.com/index.html</link>
         <description>
	        Min outside temperature: -1.3&#176;C at 04:27;
         	Max outside temperature: 6.4&#176;C at 13:31;
	        Min inside temperature:  21.9&#176;C at 13:57;
	        Max inside temperature:  25.0&#176;C at 00:00;
	        Min barometer:              N/A at    N/A;
	        Max barometer:              N/A at    N/A;
            Max wind :               10.5 m/s from 0&#176; at 04:23;
            Rain today:              0.0 mm
         </description>
         <pubDate>Tue, 29 Jan 2013 14:20:00 CET</pubDate>
	     <geo:lat>56.495</geo:lat>
    	 <geo:long>16.5</geo:long>
 		 <content:encoded><![CDATA[
           <p>
             Day:                     29 Jan 2013<br/>
	         Min Outside Temperature: -1.3&#176;C at 04:27<br/>
	         Max Outside Temperature: 6.4&#176;C at 13:31<br/>
	         Min Inside Temperature:  21.9&#176;C at 13:57<br/>
	         Max Inside Temperature:  25.0&#176;C at 00:00<br/>
	         Min Barometer:              N/A at    N/A<br/>
	         Max Barometer:              N/A at    N/A<br/>
             Max Wind :               10.5 m/s from 0&#176; at 04:23<br/>
             Rain today:              0.0 mm<br/>
        </p>
      ]]></content:encoded>
      </item>

      <item>
         <title>Monthly Weather Summary as of 29-Jan-2013 14:20</title>
         <link>http://www.weewx.com/month.html</link>
         <description>
	        Min outside temperature: -9.9&#176;C at 26-Jan-2013 02:07;
         	Max outside temperature: 7.3&#176;C at 28-Jan-2013 13:26;
	        Min inside temperature:  21.3&#176;C at 26-Jan-2013 08:06;
	        Max inside temperature:  26.2&#176;C at 27-Jan-2013 18:44;
	        Min barometer:              N/A at    N/A;
	        Max barometer:              N/A at    N/A;
            Max wind :               16.0 m/s from 0&#176; at 26-Jan-2013 16:22;
            Rain total for month:    0.0 mm
         </description>
         <pubDate>Tue, 29 Jan 2013 14:20:00 CET</pubDate>
 		 <content:encoded><![CDATA[
           <p>
             Month:                   January 2013<br/>
	         Max Outside Temperature: 7.3&#176;C at 28-Jan-2013 13:26<br/>
	         Min Outside Temperature: -9.9&#176;C at 26-Jan-2013 02:07<br/>
	         Max Inside Temperature:  26.2&#176;C at 27-Jan-2013 18:44<br/>
	         Min Inside Temperature:  21.3&#176;C at 26-Jan-2013 08:06<br/>
	         Min Barometer:              N/A at    N/A<br/>
	         Max Barometer:              N/A at    N/A<br/>
             Max Wind :               16.0 m/s from 0&#176; at 26-Jan-2013 16:22<br/>
             Rain total for month:    0.0 mm<br/>
        </p>
      ]]></content:encoded>
      </item>

      <item>
         <title>Yearly Weather Summary as of 29-Jan-2013 14:20</title>
         <link>http://www.weewx.com/year.html</link>
         <description>
	        Min outside temperature: -9.9&#176;C at 26-Jan-2013 02:07;
         	Max outside temperature: 7.3&#176;C at 28-Jan-2013 13:26;
	        Min inside temperature:  21.3&#176;C at 26-Jan-2013 08:06;
	        Max inside temperature:  26.2&#176;C at 27-Jan-2013 18:44;
	        Min barometer:              N/A at    N/A;
	        Max barometer:              N/A at    N/A;
            Max wind :               16.0 m/s from 0&#176; at 26-Jan-2013 16:22;
            Rain total for year:     0.0 mm
         </description>
         <pubDate>Tue, 29 Jan 2013 14:20:00 CET</pubDate>
 		 <content:encoded><![CDATA[
           <p>
             Year:                    2013<br/>
	         Max Outside Temperature: 7.3&#176;C at 28-Jan-2013 13:26<br/>
	         Min Outside Temperature: -9.9&#176;C at 26-Jan-2013 02:07<br/>
	         Max Inside Temperature:  26.2&#176;C at 27-Jan-2013 18:44<br/>
	         Min Inside Temperature:  21.3&#176;C at 26-Jan-2013 08:06<br/>
	         Min Barometer:              N/A at    N/A<br/>
	         Max Barometer:              N/A at    N/A<br/>
             Max Wind :               16.0 m/s from 0&#176; at 26-Jan-2013 16:22<br/>
             Rain total for year:     0.0 mm<br/>
        </p>
      ]]></content:encoded>
      </item>

   </channel>
</rss>

dock såg de rätt snarlikt ut när jag klistrade in de här i anteckningar är de bara 6 rader...
japp jag äger väder stationen men vill ogärna in å ändra nått men visst går de inte på något annat vis så

/ Fredde

Post by **Martin** » Tue 29 Jan 2013, 15:27

Två olika alternativ. Ett bör fungera...

Om filen ser ut EXAKT så som i kodfönstret (med några extrarader här och där) _och_ att radbrytningar tolkas korrekt, så bör du kunna ange:
Separeringstecken:

Code: Select all

{Outside Temperature: }{&#176;C;}

...och ange rad 22, index 2

Om filen läses in som en enda lång rad bör du kunna använda:
Separeringstecken:

Code: Select all

{Outside Temperature: }{&#176;C;}

...och ange rad 1, index 2

I båda fallen bör insamlingsmotorn hitta siffrorna mellan "Outside Temperature : " och "tecknen för grader celcius".

Switch King - Forum

hämta temp ur xml fil

hämta temp ur xml fil

Re: hämta temp ur xml fil

Re: hämta temp ur xml fil

Re: hämta temp ur xml fil

Re: hämta temp ur xml fil

Re: hämta temp ur xml fil

Re: hämta temp ur xml fil

Re: hämta temp ur xml fil

Re: hämta temp ur xml fil

Re: hämta temp ur xml fil

Who is online