Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: only mapping up to day6 (not 7)
Section
Column
width70%

Custom Application

The TVA Weather Reader is a custom application built to meet the needs of our client. It follows a similar interface design as our other weather reader applications.

First Time Launch

The first time you start the TVA Weather Reader after installing it you will need to configure it. You will be prompted to enter a Instance Name.

The instance name is arbitrary - it can be any name you like such as Live, Production, Test, Jose, GoJaysGo. It is simply a label to associate with a specific set of configuration values. This is helpful in situations where you have multiple tickers that you want to update. This enables you to do so without running multiple copies of the reader.

Configuration

The reader requires some information about the data source and the target Tick-It database before it can begin running.

  

Instance name is an arbitrary name
for the settings

 

The Super Ticker MySQL section
is pre-filled with defaults that will
likely work with your Tick-It or
Super Ticker database 

Default user id is Updater

 

 

The data source is is your
Microsoft SQL Server database.

 

You can specify the server as an IP
or as a name.


The user id and password are optional
if the logged in Windows account has
access to the SQL Server database. 

When the day name abbreviated
checkbox is checked it uses the
first 3 letters of the day name. 

The Case list offers the following:
- Source - no change
- UPPER - convert all to upper case
- lower - convert all to lower case
- Title - convert all to lower except first 

 

Running

Once launched and running - it will count down to the next update displaying the time remaining.

You can force an immediate update by pressing the Start Now button when enabled.

In this example the reader was started by pressing the start now button and the status text box has been updated with a message to reflect this.

Locations

This tab of the application provides a list of the locations that it is working with.
It is populated during the first execution and updated each time it runs.

This list is not editable. You cannot manually add or delete or edit any of the location details.

French (français)

The application includes an option to force the use of French (français) in the UI.

NOTE: French text has been provided using a best-guess translation and may not be perfectly correct for all texts.

Select the Français option from the Help menu item.
Some of the UI elements will automatically convert to français while others will only convert when you restart the reader.

NOTE: that the application may automatically use French if that is the default language of the machine it is installed on.

 

Database Code Connections

The data for the TVA weather app comes from a custom Microsoft SQL Server database created and maintained by TVA.

TVA FieldST Field 
SA_StationUnique location ID 
current
SA_IconCurrent - Weather Id^Graphic
SA_Temp_Time

Current - Day of Week
Current - Day

^Day
SA_TempCurrent - temp^Temp
day1(today) 
WeatherTodayToday - Short text^Condition[D1]
Jour_HiToday - High temperature^High[D1]
Nuit_lo

Today - Low temperature

^Low[D1]
Jour_IconToday - Weather Id^Graphic[D1]
POPTodayToday - p.o.p.^POP
day1 night(tonight) 
Nuit_IconTonight - Weather Id 
WeatherTonightTonight - Short text 
Nuit_lo

Tonight - Temperature 1

 
POPTonightTonight - p.o.p. 
day2 - day7day6(day2 = tomorrow) 
(no field)

Day of Week
Day

(calculated assuming today is day 1)

^Day[D2] - [D7D6]
WeatherDay1Day2 - 76: Short text^Condition[D2] - [D7D6]
Icon_1Day2 - 76: Weather Id^Graphic[D2] - [D7D6]
Hi_1Day2 - 76: High temperature^High[D2] - [D7D6]
Lo_1Day2 - 76: Low temperature^Low[D2] - [D7D6]
POPDay1Day2 - 76: p.o.p^POP[D2] - [D7D6]
   
Column
width30%
Panel
borderColor#0070b1
bgColor#FFFFFF
borderWidth1

In this section:

Table of Contents
indent15px

Include Page
XA:Promos Top
XA:Promos Top

...