dresdner353 / energyutils Goto Github PK
View Code? Open in Web Editor NEWCollection of utility scripts for energy monitoring
Collection of utility scripts for energy monitoring
Hi I am trying to get the data from the Shelly EM using your script.
It created the Shelly directory but doesn't put any files in it
Can you help
Out put from CMD Shell
C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>SET PYTHON=python3.exe
C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>SET SHELLY_DATA=shelly_data
C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>SET SHELLY_SCRIPT=..\shelly_em_data_util.py
C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>SET GEN_REPORT_SCRIPT=..\gen_report.py
C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>SET REPORTS=day week month year hour tariff 24h weekday
C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>REM Shelly API config
C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>SET SET SHELLY_HOST=shelly-36-eu.shelly.cloud
C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>SET SET SHELLY_AUTH_KEY=YTUyZGZ1aWQXXXXXXXXXXX
C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>SET SET SHELLY_DEVICE_ID=485XXXXXXXX
C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>REM prepare directory for parsed SHELLY JSON data
C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>IF not exist shelly_data (mkdir shelly_data )
C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>REM Retrieve data from Shelly Cloud
C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>python3.exe ..\shelly_em_data_util.py --host --id --auth_key --odir "shelly_data" --days 30
usage: shelly_em_data_util.py [-h] --host HOST [--odir ODIR] [--days DAYS] [--solar_discard SOLAR_DISCARD] --id ID
--auth_key AUTH_KEY [--verbose]
shelly_em_data_util.py: error: argument --host: expected one argument
C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>REM Example EV report
C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>python3.exe ..\gen_report.py --idir shelly_data --file shelly_report_ev.xlsx --reports day week month year hour tariff 24h weekday --tariff_rate Day:0.4320 Night:0.2086 Boost:0.1225 --tariff_interval 08-23:Day 23-08:Night 02-04:Boost --annual_standing_charge 303 --fit_rate 0.21
Sun Feb 25 16:16:39 2024 Generating report shelly_report_ev.xlsx
Sun Feb 25 16:16:39 2024 Loaded 0 files, 0 records
C:\AAAShelly\ESB Report Program\energyutils-main\energyutils-main\windows_workflow>pause
Press any key to continue . . .
REM Example EV report
%PYTHON% %GEN_REPORT_SCRIPT% ^
--idir %SHELLY_DATA% ^
--start START Calculation Start Date (20230302)
--end END Calculation End Date (20230303)
--file shelly_report_ev.xlsx ^
--reports %REPORTS% ^
--hide_columns year month week ts ^
--tariff_rate Day:0.2692 Night:0.1576 ^
--tariff_interval 08-23:Day 23-08:Night ^
--annual_standing_charge 226 ^
--fit_rate 0.12
C:\AAAShelly\ESB Report Program\energyutils-main\windows_workflow>--end END Calculation End Date (20230303)
'--end' is not recognized as an internal or external command,
operable program or batch file.
What am I not doing correctly
PJM
Hi
I would like to remove some of the columns in the spreadsheet can I do this using a filter
if so can you give me an example
Regards
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.