Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Not reporting to PVOutput #3

Closed
icepicknz opened this issue May 24, 2018 · 4 comments
Closed

Not reporting to PVOutput #3

icepicknz opened this issue May 24, 2018 · 4 comments

Comments

@icepicknz
Copy link

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
Copy link
Author

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
Copy link
Author

Could it be some form of timezone problem?

@icepicknz
Copy link
Author

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
Copy link
Owner

ekul135 commented May 24, 2018

Hi icepicknz

Glad to hear you sorted it out.

Cheers

@ekul135 ekul135 closed this as completed May 24, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants