"Clock Radio" script

[dlmorgan999]

I've uploaded one of my scripts to the new download section. This script provides the functions of a "clock radio on steroids". Here is what it does:

- a task executes once a minute to compare the current time to the property containing the "alarm time" (stored in properties on the device)
- the script checks against a small Access database that contains all my vacation days
- if the current day is a weekend or matches something in the vacation database the script exits
- otherwise it takes the following actions:
- ramps my bedroom lights to 100% over 5 minutes
- runs a "wake up" macro on my Omni automation controller
- turns on my bedroom audio source

See the attached screenshots of the device and the associated task.

-- Dave

[raptor_demon]

Hi,

I love this idea! How did you write the database with the vacation days?

thanks

Raptor

[kpatel70]

This is cool. Can I get a blank database or the structure?

Thanks.

Kirt

[dlmorgan999]

Hi,

I love this idea! How did you write the database with the vacation days?

thanks

Raptor

I just created a very simple database using Microsoft Access (this is also what I use to enter new dates). The structure is just one table with three columns. A unique ID column, DateOff and Comment (this field isn't really needed).