This wizard will guide you through the process of creating/setting up a database in rnbWeather.
All databases are created in the data folder within the HomeSeer directory.
Databases are named based on the assigned location ID which can be found in the Location and Devices page.
When using networked servers, rnbWeather attempts connection but you need to ensure your HomeSeer computer can reach the database server on the standard port.
rnbWeather does not adjust any firewalls etc to allow the traffic to pass and connection work.
rnbWeather currently supports the following database types:
SQLite (preferred)
CSV File
MS SQL Server
MySQL Server
Microsoft Access (mdb) (Windows only)
LiteDB
PostgreSQL
Firebird
This wizard will now allow you to chose one of these database types to configure. You can configure additional services as required by re-running this wizard. There is no limit to the number of databases you can have but bear in mind, each database adds to the processing time/load for the plugin on each update.
Click CONTINUE below to select a database type now..
Choose Database
Select Weatherservices/Location
Please select the weather service from the list below
Database/Table Creation Results
Configure Database Logging
For each datatype selected below, the data from each update will be saved to the database irrespective of whether you have a feature configured/setup within HomeSeer.
What this means is: if you do not have a feature created for pressure, the pressure reading will still be saved to the database.
You can make changes to which datatype is saved at any time from the settings page.
Please select the data you wish to save to the database:
Data Rentention
Data retention is not set within rnbWeather but instead as an event. to configure data rentention do the following:
Create a new event with a trigger of: A Recurring trigger Happens
Set the tigger type as required. Also set how oftern you want the event to run (eg: every 24 hours)
Select an action called: rnbWeather - Prune Database
Configure the retention period type and duration as required eg: to delete any records older than 12 months, select period type as months and a period duration of 12
Click Save and your event is ready to run
Complete Setup
rnbWeather has now successful setup, connected to and created tables in the database
