Very Odd! The Python data should settle down as you get more data points I think. One way of seeing what going on might be to look directly into the Domoticz database. Could you download a copy from your zero and view it on a another computer?

Glad to have been of help

#!/usr/bin/python from sqlite3 import connect from datetime import datetime from datetime import datetime conn = connect('/home/pi/smadata/SBFspot.db') curs = conn.cursor() #Get last rows of day file for latest reading of solar output curs.execute("select Timestamp, Power, TotalYield from vwDayData ...

Just spotted that all the tabs have become misplaced in the code I posted. I will repost a screenshot of my updated code so you can see where the tabs should be.

I knew it was a particular type :-) Most likely it is just a tab that has gotten in the wrong place on line 29. Could be just a space next to it (hard to spot). If you could screenshot the code I might be able to spot it for you. The line under "if DT!=rows1[n][0] and a==0: #append data" should have ...

Im not sure this is going to help but ill screenshot what I have. If you need anything else feel free to ask

Just to prove its worth the effort

Right. I think I see what I did. Its easier if you can directly read the domotictz database. I use DB Browser for SQLite for that. To get the right display units, the device I created had a Hardware ID of 7, Type 243 and Subtype 29. These are shown in the DeviceStatus Table of the domoticz database ...

Right. Its been a long time since I did that and cant remember exactly. Ive had a play and first you go to setup-hardware and create a new hardware device. I think the type was important. Ill have a look in the actual Domotitcz database table and see what the settings are and get back to you.

You can run the script at regular time intervals from crontab. Type crontab -e to start editing the crontab file. There are loads of tutorials about crontab on the net. Mine looks like the one below. ## run SBFspot jobs */5 6-22 * * * /usr/local/bin/sbfspot.3/daydata 55 05 * * * /usr/local/bin ...

Hi. I’m still using the python script. To be honest I haven’t tried to use the original method again

The total production is stored in the vwDayData table in the SBFspot database. It could be accessed in a similar way to how I did it in this post.

https://www.domoticz.com/forum/viewtopi ... ot#p228990

Hope that is useful.

Just for anyone else with the same issue Im going to share the finished python code below. its been working fine for several days now. Just run the python script from crontab every 5 minutes with the relevent paths changed for your system. #!/usr/bin/python from sqlite3 import connect from datetime ...

Virtualdevice.png OK, so I havent been able to get the inbuilt import function to work properly but I have managed to use a virtual sensor and a python script to do what is required. There are a couple of glitches with the data in the image but Im very close. Im still fiddling with it to get the ...

Your config file is similar to mine. The naming issue is mentioned at the bottom of: https://www.domoticz.com/wiki/SMASpot_Monitoring_in_Domoticz "Internally, domoticz relies on SBFspot to generate logfiles in the spot format. It is therefore important that SBFspot is kept running in the background ...

I am having exactly the same issues as you describe. There is some information in the forum about changing the spot file names in the SBFspot.cfg file but I havent managed to get anything to work yet have you?

Cheers Mark