Has anyone been able to interface an Alpha-Ess smile5 inverter with pvoutput yet ??
I’d like to know this too!
any update
Me, too. My battery went in yesterday.
I wonder if the CSV or Live loader could be used? One can download data from the Smile5 as a CSV file.
It would be clunky but may work. I’ll try it
Yes, it works. I uploaded a day’s data but will add more.
It’s a bit of a fiddle. I downloaded the data from the AlphaESS app as a CSV file. I then loaded it into a spreadsheet and added some additional columns to convert the data, which is in kW, to watts by multiplying the contents of the data column by 1000 to convert it to watts.
i.e.,
Date Time BAT Load Solar Generated kWh Feed-in Exported kWh Consumed Consumption kWh
24/05/2024 7:10 10 6.375 6375 0.063 63 0 0 6.342 6342
Unfortunately, one can’t do much with the spreadsheet CSV file as it is. Dropping it into Live Loader directly doesn’t work because the data is separated by spaces, it needs to be comma delimited. So I opened it with Notepad and pasted it from there:
24/05/2024,7:10,10,6.375,6375,0.063,63,0,0,6.342,6342
Someone with greater ability then me could probably write a script file to do all that.
I’m not sure if one can do much with the battery data.
I’ll continue playing with the data and Live Loader.
The ‘Data separated by’ option should be able to handle space separators.
Nothing wrong with me that a new pair of glasses wouldn’t fix.
Of course you don’t need to convert the power to watts, the drop-down menus allow data to be in kW. Silly me.
I didn’t have much luck with spaces vs. commas. PVO didn’t like leading spaces on the time field. I’ll play with it again tomorrow.
Forget all that above. It’s 3.30 am, I’m in bed and I’ve just woken up and realised it’s much simpler than that. I’ll test it when I get up at 8am and have a keyboard rather than an iPad.
I’m going back to sleep.
Test and working in a much simpler method:
Open the AlphaESS Monitoring website: Alpha ESS Monitoring
In the Power Diagram section, select the date and then Download CSV
Open the saved CSV file with a text editor, e.g., Notepad, not a spreadsheet program.
The file will be a comma delimited file. Select all of it and copy it.
Go to PVOoutput, Add Output, select Live Loader
Set the date and then paste the copied data from the CSV file into the Paste Data area.
There will be 2 too many rows. Delete the header row and the last row (midnight of the following day). Setting the Header lines to skip and Trailer lines to skip to 1 doesn’t work here. You need to remove those lines before attempting to load the data.
EDIT: If after doing that, it indicates you still have to remove one record, check right at the bottom of the data to remove any extra blank lines.
Tick the boxes next to Power Generation and Power Consumption and reset both the kW rather than the default W.
Set Power Generation to be Position 4
Set Power Consumption to be Position 3
Select Load. That’s it. You will get a message: " Successfully added 288 records"
The data should show up on Your Outputs shortly after.
Actually, this is much quicker to do than to read. Once you’ve done it once, some of the settings stay set so it’s even quicker. I’ll do the rest of mine this arvo when I get home. At the moment you can see mine at: p38arover 6.460kW (Yes, I’m missing years of data.)
Thanks!
This is good as a one-off, the holy grail is live integration like my Fronius inverter does.
Indeed. One of the tech guys from the battery provider is going to look into it for me.
Ron
One thing that is annoying and which adds extra steps is having to remove two records from the datam the header line abd the 24:00 line. Live loader has the option to ignore the first and second record but it still insists that one remove 2 records or there are too many.
Hi,
A friend of mine had a AlphaESS SMILE-G3-B5-INV installed at his home last week.
While AlphaESS provides an App and a Web GUI to view the ESS’s activity it does not incorporate the data from his existing Fronius Symo inverter; at least not to the degree possible via the PV Output website.
After much trawling around the Internet I have managed to adapt a Python script, available at https://github.com/alphaess-developer/alphacloud_open_api to extract the ‘State of Charge’ and the ‘Rate of Charge’ of his battery.
In order to use the Python script the system must first be registered at https://open.alphaess.com/. This is done to obtain a Developer ID and a Developer Key.
I have written a short PHP script to process the data returned via the Python script and upload it to PVOutput.
Why have I used PHP? I am familiar with PHP but have virtually no experience with Python. Ideally, from my point of view, the entire script would be written in PHP. So while my current solution is a bit ugly it seems to work. I have also got some existing PHP scripts which happily extract data from Fronius inverters - why reinvent the wheel
I am running the Python and PHP scripts on a Raspberry Pi 5 that is using the latest 64 bit version of Raspberry Pi OS. The scripts should running on any computer that supports both Python and PHP. It shouldn’t matter which version of Pi OS but I have not tested the script elsewhere.
Grannos