SMA SB 1300-TL

Topics (not sure which fora)
when not sure where to post, post here and mods will move it to right forum.

Moderators: leecollings, remb0

Post Reply
User avatar
groetg
Posts: 39
Joined: Tuesday 06 January 2015 20:41
Target OS: Raspberry Pi / ODroid
Domoticz version: V2.4025
Location: Heerhugowaard, Holland
Contact:

SMA SB 1300-TL

Post by groetg »

What hardware do i need to get de data of my solar "omvormer" into domoticz?

I have a sb 1300 TL from SMA. But now i doet have the option to Any data from it.
Master: RPI Model 2B
Sub 1: RPI Model 2B
RFX transmitter/receiver 433 Mhz
13 KAKU units (3 window sensors, 1 door sensor, 7 light switches, 1 dusk sensor, 1 motion sensor)
4 IP cam
Meteostick
OTGW
P1 cable
Davis Vantage Pro weatherstation (incl. solar/UV)
User avatar
groetg
Posts: 39
Joined: Tuesday 06 January 2015 20:41
Target OS: Raspberry Pi / ODroid
Domoticz version: V2.4025
Location: Heerhugowaard, Holland
Contact:

Re: SMA SB 1300-TL

Post by groetg »

This are my options qua hardware:
http://www.sma-benelux.com/nl_BE/produc ... temen.html

To het the data in domoticz i Will have to use sbfspot i understand?
Master: RPI Model 2B
Sub 1: RPI Model 2B
RFX transmitter/receiver 433 Mhz
13 KAKU units (3 window sensors, 1 door sensor, 7 light switches, 1 dusk sensor, 1 motion sensor)
4 IP cam
Meteostick
OTGW
P1 cable
Davis Vantage Pro weatherstation (incl. solar/UV)
User avatar
gizmocuz
Posts: 2552
Joined: Thursday 11 July 2013 18:59
Target OS: Raspberry Pi / ODroid
Domoticz version: beta
Location: Top of the world
Contact:

Re: SMA SB 1300-TL

Post by gizmocuz »

SBFspot will work
Quality outlives Quantity!
User avatar
bbqkees
Posts: 407
Joined: Sunday 17 August 2014 21:01
Target OS: Linux
Domoticz version: 4.1x
Location: The Netherlands
Contact:

Re: SMA SB 1300-TL

Post by bbqkees »

You would need to add a SMA Piggy Back (Webconnect) module to the converter with either ethernet of Bluetooth.
In the latter case you also need to add a bluetooth stick to the Pi.
And then use SBFSpot.
Bosch / Nefit / Buderus / Junkers / Worcester / Sieger EMS bus Wi-Fi MQTT Gateway and interface boards: https://bbqkees-electronics.nl/
Derik
Posts: 1602
Joined: Friday 18 October 2013 23:33
Target OS: Raspberry Pi / ODroid
Domoticz version: BETA
Location: Arnhem/Nijmegen Nederland
Contact:

Re: SMA SB 1300-TL

Post by Derik »

Or when your inverter has Bluetooth...
Buy a cheap bt usb, that on your rpi...

And then use SBF spot the old version....[ u can also upload data to pv output]

Or if you uplod no your data to PVO you can import it directly from PVO...
Xu4: Beta Extreme antenna RFXcomE,WU Fi Ping ip P1 Gen5 PVOutput Harmony HUE SolarmanPv OTG Winddelen Alive ESP Buienradar MySensors WOL Winddelen counting RPi: Beta SMAspot RFlinkTest Domoticz ...Different backups
User avatar
groetg
Posts: 39
Joined: Tuesday 06 January 2015 20:41
Target OS: Raspberry Pi / ODroid
Domoticz version: V2.4025
Location: Heerhugowaard, Holland
Contact:

Re: SMA SB 1300-TL

Post by groetg »

I bought and installed the Piggy Back and my rpi sees the Mac address of the piggy Back.

I am following everything at: http://www.domoticz.com/wiki/SMASpot_Mo ... n_Domoticz

When I must move the SBFspot.cfg to /bin/Release_MySQL I got an error:
mv: cannot move `SBFspot.cfg' to `bin/Release_MySQL/SBFspot.cfg': Permission denied

rights on SBFspot.cfg are on 0777, so that shouldn't be a problem.

Also creating a database like below, won't work
sql
sql
sql.PNG (11.88 KiB) Viewed 4361 times
pi@raspberrypi ~/smadata $ sqlite3 SBFspot.db < /home/pi/SMAspot/SBFspot/CreateSQLiteDB.sql
-bash: sqlite3: command not found
Last edited by groetg on Saturday 04 July 2015 8:36, edited 1 time in total.
Master: RPI Model 2B
Sub 1: RPI Model 2B
RFX transmitter/receiver 433 Mhz
13 KAKU units (3 window sensors, 1 door sensor, 7 light switches, 1 dusk sensor, 1 motion sensor)
4 IP cam
Meteostick
OTGW
P1 cable
Davis Vantage Pro weatherstation (incl. solar/UV)
Derik
Posts: 1602
Joined: Friday 18 October 2013 23:33
Target OS: Raspberry Pi / ODroid
Domoticz version: BETA
Location: Arnhem/Nijmegen Nederland
Contact:

Re: SMA SB 1300-TL

Post by Derik »

are you pi or root?
Perhaps sudo before the command?
Xu4: Beta Extreme antenna RFXcomE,WU Fi Ping ip P1 Gen5 PVOutput Harmony HUE SolarmanPv OTG Winddelen Alive ESP Buienradar MySensors WOL Winddelen counting RPi: Beta SMAspot RFlinkTest Domoticz ...Different backups
User avatar
groetg
Posts: 39
Joined: Tuesday 06 January 2015 20:41
Target OS: Raspberry Pi / ODroid
Domoticz version: V2.4025
Location: Heerhugowaard, Holland
Contact:

Re: SMA SB 1300-TL

Post by groetg »

pi, sudo worked, thanx!

Now I am stuck at:
pi@raspberrypi ~/smadata $ sqlite3 SBFspot.db < /home/pi/SMAspot/SBFspot/CreateSQLiteDB.sql
-bash: sqlite3: command not found
sql2
sql2
sql2.PNG (10.87 KiB) Viewed 4329 times
Master: RPI Model 2B
Sub 1: RPI Model 2B
RFX transmitter/receiver 433 Mhz
13 KAKU units (3 window sensors, 1 door sensor, 7 light switches, 1 dusk sensor, 1 motion sensor)
4 IP cam
Meteostick
OTGW
P1 cable
Davis Vantage Pro weatherstation (incl. solar/UV)
Derik
Posts: 1602
Joined: Friday 18 October 2013 23:33
Target OS: Raspberry Pi / ODroid
Domoticz version: BETA
Location: Arnhem/Nijmegen Nederland
Contact:

Re: SMA SB 1300-TL

Post by Derik »

Login with winscp.;...

And when you make a mv or you make a document...
Click the refresh button in winscp and check or the document is there where you want.
refresh and check of the document ave the good rights...

Do this with all the steps..
Xu4: Beta Extreme antenna RFXcomE,WU Fi Ping ip P1 Gen5 PVOutput Harmony HUE SolarmanPv OTG Winddelen Alive ESP Buienradar MySensors WOL Winddelen counting RPi: Beta SMAspot RFlinkTest Domoticz ...Different backups
User avatar
tcviper
Posts: 89
Joined: Monday 30 June 2014 13:34
Target OS: Raspberry Pi / ODroid
Domoticz version:
Location: Netherlands
Contact:

Re: SMA SB 1300-TL

Post by tcviper »

I actually found out today that Domoticz doesnt pick up multi inverters within the same config file of SBFSpot :)
It only logs like half of the energy. Since latest release you can put multiple inverters into the same SBFSpot.cfg file:

IP_ADDRESS=xx.xx.xx.xx,xx.xx.xx.xx

That will basically log both inverters (both each it's own ip) into the same log files.

It looks like domoticz doesnt support this yet? I started a discussion here about it: https://sbfspot.codeplex.com/discussions/645764
User avatar
gizmocuz
Posts: 2552
Joined: Thursday 11 July 2013 18:59
Target OS: Raspberry Pi / ODroid
Domoticz version: beta
Location: Top of the world
Contact:

Re: SMA SB 1300-TL

Post by gizmocuz »

tcviper wrote:I actually found out today that Domoticz doesnt pick up multi inverters within the same config file of SBFSpot :)
It only logs like half of the energy. Since latest release you can put multiple inverters into the same SBFSpot.cfg file:

IP_ADDRESS=xx.xx.xx.xx,xx.xx.xx.xx

That will basically log both inverters (both each it's own ip) into the same log files.

It looks like domoticz doesnt support this yet? I started a discussion here about it: https://sbfspot.codeplex.com/discussions/645764
Send you a PM
Quality outlives Quantity!
User avatar
tcviper
Posts: 89
Joined: Monday 30 June 2014 13:34
Target OS: Raspberry Pi / ODroid
Domoticz version:
Location: Netherlands
Contact:

Re: SMA SB 1300-TL

Post by tcviper »

Anyone any idea? I setup SBFspot again today (fresh start with latest version 3.1.2) im using 2 local inverters in the SBFspot.cfg file (both LAN). The smadata is being built but in domoticz it shows as 3501.441 Kwh today, and that is a bit much since the day just started :P The SMA app on my iphone shows 0,10 Kwh so far.Looks like the comma is wrong or something? No idea where to change that?
User avatar
bbqkees
Posts: 407
Joined: Sunday 17 August 2014 21:01
Target OS: Linux
Domoticz version: 4.1x
Location: The Netherlands
Contact:

Re: SMA SB 1300-TL

Post by bbqkees »

Isn't the 3501 value the total from start?

So the first day has all the production ever up until that day and the next day it should be just the actual daily consumption.
Bosch / Nefit / Buderus / Junkers / Worcester / Sieger EMS bus Wi-Fi MQTT Gateway and interface boards: https://bbqkees-electronics.nl/
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest