DomoticzGazpar

Import data from GDRF to Domoticz

create a device in Domoticz

• In Domoticz, go to hardware, create a virtual "Managed counter". You may as well create a virtual 'Managed counter, Gas' device in m3 (to do so : create first a Managed counter, then modify it in the Utility tab to change Switch type to Gas)
• Then in Devices, add it to the devices. (mark down the id for later).

modules to install - linux

sudo apt-get install python3 python3-dateutil python3-requests
pip install openpyxl
git clone https://github.com/Scrat95220/DomoticzGazpar.git

Workaround due to the CATPCHA issue

• The script will try to import the GRDF xlsx file if the connection to the API fail.
• Go to the GRDF website, import the XLSX data in "Jour". Use de attribute XLS_PATH for set the path of your file (example: grdf.xlsx)

rename configuration file, change settings

cp _domoticz_gazpar.cfg domoticz_gazpar.cfg
nano domoticz_gazpar.cfg

and change:

[email protected]
GAZPAR_PASSWORD=password
NB_DAYS_IMPORTED=30
XLS_PATH=path to your xlsx file imported
DOMOTICZ_ID=123
DOMOTICZ_ID_M3=456
DB_PATH=/home/pi/domoticz (if needed)
HOSTNAME=https://localhost:8080 
USERNAME = 
PASSWORD = 

Where NB_DAYS_IMPORTED correspond to the number of days to import and DOMOTICZ_ID is id device on domoticz and DOMOTICZ_ID_M3 is the id device of a virtual 'Smart Meter, Gas' device in m3 if exists

Configuration file will not be deleted in future updates.

testing before launch

Manually launch

./gazpar.py

Then check the login credential if they are ok:

domoticz_gazpar.log

If this is good, you'll get several json files in the directory

Add to your cron tab (with crontab -e):

30 7,17 * * * python3 /home/pi/domoticz/DomoticzGazpar/gazpar.py