Polycom Digital Signage Administrator Guide Data Source Tutorial
178 Polycom, Inc.
General Settings
The general settings for the weather data source are straightforward. We tell
Data Parser to refresh the feed every hour (i.e. 3600 seconds), to allow
duplicate rows in the table, to fetch the feed from
http://www.srh.noaa.gov/zipcity.php?inputstring=10005, and to store the
parsed data in a table named Weather in the DataFeeds.mdb database:
<General>
<RefreshInterval>3600</RefreshInterval>
<AllowDuplicates>True</AllowDuplicates>
<Url>http://www.srh.noaa.gov/zipcity.php?inputstring=10005<
/Url>
<Database>DataFeeds.mdb</Database>
<TableStructure Name="Weather">
<Field Type="Text">DayPart</Field>
<Field Type="Text">Condition</Field>
<Field Type="Text">Temp</Field>
<Field Type="Memo">ImageURL</Field>
<Field Type="Memo">LocalImage</Field>
</TableStructure>
</General>
The Weather table we create has the following fields:
• DayPart: The part of the day that described by the weather data in the
current row. For example, "Today" or "Friday Night".
• Condition: The weather conditions for the day part. For example, "Mostly
Sunny" or "Partly Cloudy".
• Temp: The temperature for the day part.
• ImageURL: The URL of the image used on the web site to depict the
weather for the day part.
• LocalImage: The path and file name of a local copy of the image. We'll
download the image as we parse the web page.
• Building the Data Source Definition
Resolving the URL (e.g. by opening it in a browser and viewing the source)
gives us the following raw HTML code. This code contains a lot of extraneous
information. The part we're interested in is the "Forecast at a Glance" section,
which is highlighted in below.
<!doctype html public "-//W3C//DTD HTML 4.0
Transitional//EN"><html><head>
<title>7-Day Forecast for Latitude 40.74N and Longitude
-74.01W</title><link rel="STYLESHEET" type="text/css"
href="fonts/main.css"></head><body leftmargin="0"