search

ekul135 / Powerwall2PVOutput

Send Tesla Powerwall data to PVOutput
24 stars 5 forks source link

Not reporting to PVOutput #3

Closed icepicknz closed 6 years ago

icepicknz commented 6 years ago

Logger is running

root@piaware-dayna:~/Powerwall2PVOutput-master# ps -auxwww | grep PW root 14356 0.7 1.7 20332 13252 pts/0 S 19:31 0:32 python /root/Powerwall2PVOutput-master/PW_Datalogger.py

Crontab is installed root@piaware-dayna:~/Powerwall2PVOutput-master# crontab -l | grep PW /5 * python /root/Powerwall2PVOutput-master/PW_PVOExport.py root@piaware-dayna:~/Powerwall2PVOutput-master#

root@piaware-dayna:~/Powerwall2PVOutput-master# tail pvo.log 2018-05-24 19:30:13,161 - Start PVOutput datalogger 2018-05-24 19:31:00,815 - Start PVOutput datalogger 2018-05-24 20:26:23,400 - Start PVOutput export 2018-05-24 20:26:24,224 - No data returned 2018-05-24 20:26:24,229 - End PVOutput export 2018-05-24 20:27:47,693 - Start PVOutput export 2018-05-24 20:27:48,235 - No data returned 2018-05-24 20:27:48,241 - End PVOutput export root@piaware-dayna:~/Powerwall2PVOutput-master#

Yet nothing showing up

root@piaware-dayna:~/Powerwall2PVOutput-master# cat PW_Config.py

!/usr/bin/env python

pvo_host= "pvoutput.org" pvo_key = "XYZ" pvo_systemid = "55404" PowerwallIP = "192.168.33.5" extData = True log_file = "pvo.log"

only needed if using datalogger

sqlite_file = "pw.sqlite" retain_days = "30" #days to retain data in db, use 0 to not delete

Any ideas?

icepicknz commented 6 years ago

Data seems to be present in the sqlfile...

sqlite> select * from pw; 2018-05-24 19:30:13|5.09000015258789|5586.87196667155|0.0|235.440002441406|5570.0|5586.87196667155|39.9879093915579|14.0699996948242|235.460006713867 2018-05-24 19:30:18|11.6899995803833|5555.92473589559|0.0|235.639999389648|5540.0|5555.92473589559|39.9487927171864|14.4899997711182|235.649993896484 2018-05-24 19:30:23|13.8199996948242|5539.24431927181|0.0|235.539993286133|5450.0|5539.24431927181|39.9132321041215|25.1000003814697|235.559997558594 2018-05-24 19:30:28|5.28999996185303|5509.21021891293|0.0|235.889999389648|5460.0|5509.21021891293|39.8918957362825|33.4300003051758|235.910003662109

sqlite> select * from View_pw; 2018-05-24 19:30:00|19:30|20180524|18.83|4801.94|0.0|235.47|4789.55|4801.94|39.58|-24.78|235.48 2018-05-24 19:35:00|19:35|20180524|72.93|4691.64|0.0|235.19|4609.66|4691.64|38.6|2.38|235.2 2018-05-24 19:40:00|19:40|20180524|84.06|4876.24|0.0|234.28|4787.76|4876.24|37.27|7.09|234.29

icepicknz commented 6 years ago

Could it be some form of timezone problem?

icepicknz commented 6 years ago

Got it working now, seemed to be time zone related and also cron doesn't seem to be working, may need to change into the local directory or something for it to run.

My Pi box was in UTC where as my PVO is in NZ time

ekul135 commented 6 years ago

Hi icepicknz

Glad to hear you sorted it out.

Cheers