How is "temperature" collected / calculated by inverter

Topics: 1. General
Aug 22, 2015 at 6:00 PM
dear all,

has someone an explication how SMA inverters get "temperature" of PV panels,

this should be of help,
  • since i my inverter does not support this feature,
  • i use a temperature sensor to measure temp. of backpanel substrate
my method's restrictions are:
  • human read-out needed
  • only one panel can be measured (unless installing several sensors)
thank you for helping in finding this wim
Coordinator
Aug 22, 2015 at 7:28 PM
It's the internal temperature of the inverter and not the one of the PV panels
Sep 20, 2015 at 8:34 AM
Hello Dear SBF.
Can you add the option to send openweather or wunderground temperature on the SBFspotUploadDaemon ?
IMHO it's a great feature and i hope you'll add it.
Thanks in advance.
Regards,
Tony
Coordinator
Sep 20, 2015 at 4:30 PM
Can you add the option to send openweather or wunderground temperature on the SBFspotUploadDaemon ?
This is automatically done by PVoutput.org
See documentation how to configure
Sep 21, 2015 at 1:42 PM
SBF wrote:
Can you add the option to send openweather or wunderground temperature on the SBFspotUploadDaemon ?
This is automatically done by PVoutput.org
See documentation how to configure
Yes, i have try to set it but don't works. PVOutput get the weather temperature but when SBF uploads , it overwrite the value with my inverter temperature.
So i ask you if you can get the weather temp into the SBF software so SBFspotUploadDaemon can send the weather temp to PVOutput when it's updating.
Thanks !
Sep 21, 2015 at 2:26 PM
Edited Sep 21, 2015 at 2:27 PM
Hello,
If you want to use your own temperature data, you have to modify first the view vwPvoData used by the soft to upload to PVOutput.
You'll find more information in the Tweaking chapter of the Quick Reference documentation.
Coordinator
Sep 21, 2015 at 2:33 PM
Good point! Will add this to the doc. Thanks
Oct 8, 2015 at 10:59 AM
SBF wrote:
Good point! Will add this to the doc. Thanks
Hello,

Can you explain a bit more, i don't understand the manual.
Oct 8, 2015 at 11:51 AM
Hello,

As said in the Quick Reference documentation, you have to redefine the view vwPvoData used to define the data that are sent to PVOutput.
Depending on the database you've chosen (SQLite or MySQL) you must first connect to your DB before making the change.

By default, the V5 and V6 columns return the system temperature and Uac1 - AC Value (from vwAvgSpotData view).

If you want to replace the V5 value by the one collected from weather service (Weather Underground for example), you have first to redfine its column.
  • First delete the actual view definition :
DROP VIEW IF EXISTS vwPvoData;
  • Than redefine it :
CREATE VIEW vwPvoData AS
SELECT dd.Timestamp,
dd.Name,
dd.Type,
dd.Serial,
dd.TotalYield AS V1,
dd.Power AS V2,
cons.EnergyUsed AS V3,
cons.PowerUsed AS V4, 
         NULL AS V5,
spot.Udc1 AS V6,
NULL AS V7,
NULL AS V8,
NULL AS V9,
NULL AS V10,
NULL AS V11,
NULL AS V12,
dd.PVoutput
FROM vwDayData AS dd
LEFT JOIN vwAvgSpotData AS spot
ON dd.Serial = spot.Serial AND dd.Timestamp = spot.Nearest5min
LEFT JOIN vwAvgConsumption AS cons
ON dd.Timestamp = cons.Nearest5min
ORDER BY dd.Timestamp DESC;
As mentionned in the guide, the V6 depends on the VoltLogging in config file but for what you want to do, the only important change to do is the one for V5

Hope it helps !
Marked as answer by SBF on 2/25/2016 at 12:22 PM
Coordinator
Oct 8, 2015 at 3:57 PM
As mentionned in the guide, the V6 depends on the VoltLogging in config file but for what you want to do, the only important change to do is the one for V5
That's correct, except for "VoltLogging in config file" - This is not used anymore
Feb 5, 2016 at 8:22 PM
Edited Feb 5, 2016 at 8:23 PM
Hi,
I want to shift inverter temperature to V7 parameter (leaving V5 parameter for Wundergound temperature otherwise it happen something like here http://pvoutput.org/intraday.jsp?id=43368&sid=39616). I run SBFspot on rpi2 with SQLite. I read the Tweaking chapter of the Quick Reference documentation but I'm not an expert on DB. I guess I have to specify somewhere:
" spot.Temperature AS V7"
Since SQLite parameters cannot be edited with "sudo nano", can somebody explain step by step what should I do?

thanks and ciao,
gabriele
Coordinator
Feb 5, 2016 at 8:50 PM
Create a text file (MyNewQuery.sql) with an editor like "nano"
In this text file you enter the query.
cd /home/pi/smadata
sqlite3 SBFspot.db < MyNewQuery.sql
That's it. Don't forget to drop the view (see example above)
Feb 6, 2016 at 6:04 PM
sorry,

what you mean with "drop the view (see above example")?
where do I specify "spot.Temperature AS V7"?

thanks,
gabriele
Feb 8, 2016 at 6:55 PM
Edited Feb 8, 2016 at 6:55 PM
I created the file "MyNewQuery.sql" and inserted above lines. Then, what should I do?

thanks,
gabriele
Feb 11, 2016 at 10:18 PM
Edited Feb 11, 2016 at 10:22 PM
Instead of creating the "MyNewQuery.sql" I did the following:
sqlite3 SBFspot.db
DROP VIEW IF EXISTS vwPvoData;
CREATE VIEW vwPvoData AS
       SELECT dd.Timestamp,
              dd.Name,
              dd.Type,
              dd.Serial,
              dd.TotalYield AS V1,
              dd.Power AS V2,
              cons.EnergyUsed AS V3,
              cons.PowerUsed AS V4,
              NULL AS V5,
              spot.Uac1 AS V6,
              spot.Temperature AS V7,
              NULL AS V8,
              NULL AS V9,
              NULL AS V10,
              NULL AS V11,
              NULL AS V12,
              dd.PVoutput
         FROM vwDayData AS dd
              LEFT JOIN vwAvgSpotData AS spot
                     ON dd.Serial = spot.Serial AND dd.Timestamp = spot.Nearest5min
              LEFT JOIN vwAvgConsumption AS cons
                     ON dd.Timestamp = cons.Nearest5min
        ORDER BY dd.Timestamp DESC;
.quit
and seems it works!
See http://pvoutput.org/intraday.jsp?id=43368&sid=39616&dt=20160212&gs=0&m=0 and http://pvoutput.org/intraday.jsp?id=43368&sid=39616&dt=20160212&gs=0&m=0 compared to http://pvoutput.org/intraday.jsp?id=43368&sid=39616&dt=20160210&gs=0&m=0 !
Marked as answer by SBF on 2/25/2016 at 12:22 PM
Feb 24, 2016 at 10:01 AM
Great !
That is exactly what you had to do (see my msg on 8th of october ;) )
  • connect to the DB
  • drop the view
  • create a new one
And the proposal of SBF was a shortcut : putting the drop and create commands in a single script that you execute through the command line (the MyNewQuery.sql script contains both of the commands)
Coordinator
Mar 9, 2016 at 9:10 PM
For more information on this subject, read this FAQ