A commandline tool for scraping energy meter data from Tauron eLicznik service.
The data are fetched in the CSV format. It consists of hourly records of energy imported and exported from/to grid.
By default obtained data is stored in the PostgreSQL database, but this tool can also save the data directly to a CSV file.
It can also load a data from the CSV (instead of using Tauron
) and then save it in the database.
elicznik 0.1.0
Simple program to fetch and process `Tauron eLicznik` CSV data. If none arguments are given, it is
fetching last two days of data and updates missing values in the configured PostgreSQL database
USAGE:
elicznik [OPTIONS]
OPTIONS:
-c, --config <CONFIG> Config file path [default: /etc/elicznik.conf]
-d, --debug Enable debug info
-e, --end <END> End date in format: YYYY-MM-DD [default: current date]
-h, --help Print help information
-i, --input <INPUT> Input CSV file to read instead of using `Tauron eLicznik`
-o, --output <OUTPUT> Output CSV file to write output data (database will be also updated,
if configured)
-p, --print Print all CSV entries
-s, --start <START> Start date in format: YYYY-MM-DD [default: two days ago]
-V, --version Print version information
The Tauron
service is providing the data with some delay. Generally the last data available is for a previous day,
but even then it is sometimes not complete. This tool is intended to run in a daily manner to be able to fetch all data.
Due to described data availability the program by default is trying to start fetching data from day before yesterday.
One can always adjust it to one's need by providing start
and end
parameters as described above.
If not specifed, the tool is searching for the following config file:
/etc/elicznik.conf
A sample file may have the following contents:
[tauron]
username = your_tauron_username
password = your_password
[postgres]
host = 192.168.1.1
dbname = database_name
username = database_user
password = database_password