GoodWe to PVOutput using a PC?

Inverters
#1

Hello,

Recently I got a new inverter; a GoodWe GW3600T-DS with 10x400Wp panels.

Is there a convenient way to upload live data from this system to PVOutput using a PC?

The PC is not 24/7 on.

I already upload data from my other inverters; SBFspot for the SMA and youless hardware for the old Soladin 600.

I use an account with donation for the upload.

Best regards

#2

Data from SEMS: https://github.com/markruys/gw2pvo
Data from the inverter: https://github.com/yaleman/goodwe2pvoutput
If using home assistant: https://github.com/mletenay/home-assistant-goodwe-inverter

#3

1 Data from SEMS: [https://github.com/markruys/gw2pvo ]

I doubt if this still works. code is 3 years old and SEMS portal is changing. If it works it can solve the issue that I also want to upload historic data too. Other options can’t do that.

2 Data from the inverter: https://github.com/yaleman/goodwe2pvoutput

Nice. But needs PC 24/7.

3 If using home assistant: https://github.com/mletenay/home-assistant-goodwe-inverter

Installed home assistant on my PC. Works for GoodWe; detailed data, both strings for instance. Needs PC 24/7.

Option 4; Manual upload using excel sheet

=> works, but cumbersome. Can only download 1 day at once.

Has anyone done some automation for this?

Think I go for a raspberry pi and option 3. And use 4 for the historical data.

raspberry pi consumes 36W…

#4

Excel script for manual upload;

Sub GoodWeupload()
’
’ GoodWeupload Macro
’
’

Range("C4").Select
ActiveCell.FormulaR1C1 = "=+MID(RC[-2],11,6)"
Range("C4").Select
Selection.Copy
Columns("C:C").Select
ActiveSheet.Paste
ActiveWindow.SmallScroll Down:=72
Range("B74:C278").Select
Application.CutCopyMode = False
Selection.Copy

End Sub

  1. download sheet power from www.semsportal.com
  2. runs script in sheet
  3. copy / paste to Load Live Outputs window.

Only; there seems to be an error in the www.semsportal.com
e.g. yesterday the power in the sheet (and PVoutput) adds up to 13,1 kWh. Actual production is 10,3 kWh.

#5

the gw2pvo script still works. I’ve used it today. However it only exports production data but not consumption data. For historical data pvoutput only accepts import within 14 days or if you are a donator then 90 days.

#6

Thanks. Installed it and it indeed works fine. Made a bat file to upload it once a day or live when the PC is on:

ECHO %DATE%
set YEAR=%DATE:~9,4%
set MONTH=%DATE:~6,2%
set DAY=%DATE:~3,2%
set DATESTR=%YEAR%-%MONTH%-%DAY%
ECHO $DATESTR%

cd C:[…]\GoodWe
gw2pvo --config gw2pvo.cfg --date %DATESTR% --skip-offline --pv-voltage