StefanV

Hi everyone, so I had the need to get daily, weekly and monthly solar statistics emailed to me but after requesting this directly from the Solar-Assistant team for months, I decided to create it myself. I have made it available to all if you can find the use for it and can be found here - https://github.com/Stef1986/email_scheduler_solar_assistant
Once you have cloned the repo locally, you simply edit the .env file with your Solar Assistant's MQTT details as well as your reporting preferences and run the docker-compose up.
Just have a look at the README.md, it should be detailed enough to get you going.
As a quick overview, basically what will happen is on the host of your choosing, you will run the docker container that will subscribe to the MQTT topic created in Solar-Assistant and will ingest all the data. It will then (based on your choosing) schedule daily, weekly and/or monthly statistic reports to be emailed to your inbox.

The body of the email will contain a nice table with statistics (configurable in the .env file) with min/max/avg values as well as a csv attachment (also configurable) containing the totals for daily, weekly and monthly for stats like PV generated, Battery in, Battery out, etc etc

Hope you guys enjoy and if this helped you, consider supporting my efforts with a beer or two 😁🍻

Hi everyone, so I had the need to get daily, weekly and monthly solar statistics emailed to me but after requesting this directly from the Solar-Assistant team for months, I decided to create it myself. I have made it available to all if you can find the use for it and can be found here - https://github.com/Stef1986/email_scheduler_solar_assistant
Once you have cloned the repo locally, you simply edit the .env file with your Solar Assistant's MQTT details as well as your reporting preferences and run the docker-compose up.
Just have a look at the README.md, it should be detailed enough to get you going.
As a quick overview, basically what will happen is on the host of your choosing, you will run the docker container that will subscribe to the MQTT topic created in Solar-Assistant and will ingest all the data. It will then (based on your choosing) schedule daily, weekly and/or monthly statistic reports to be emailed to your inbox.

The body of the email will contain a nice table with statistics (configurable in the .env file) with min/max/avg values as well as a csv attachment (also configurable) containing the totals for daily, weekly and monthly for stats like PV generated, Battery in, Battery out, etc etc

Hope you guys enjoy and if this helped you, consider supporting my efforts with a beer or two 😁🍻

Ah I found the issue. There was an additional success message being printed from the report_generator.py where the emailer.py already handled that part. Should be fixed now.
I inputted my email password incorrect to replicate your use case:

Just do a pull again and rebuild and you should be good. 🙂

Please pull the new version and test. I just cannot test at the moment. The success message should not display if the email fails. Also you should now be able to set the csv attachment to 0 and should just need to restart the container to take effect.

Multi-recipient functionality added with whitespace support so you could add email addresses in your .env file like:
For a single recipient: [email protected]
For multiple recipients: [email protected],[email protected],[email protected]
OR
For multiple recipients: [email protected], [email protected], [email protected]

To update your code, simply run the below from your cloned directory:

git pull
docker-compose down
docker-compose up -d --build

Let me know if it works for you.

Multi-recipient functionality added with whitespace support so you could add email addresses in your .env file like:
For a single recipient: [email protected]
For multiple recipients: [email protected],[email protected],[email protected]
OR
For multiple recipients: [email protected], [email protected], [email protected]

To update your code, simply run the below from your cloned directory:

git pull
docker-compose down
docker-compose up -d --build

Let me know if it works for you.

Your are most welcome and I am glad it helps you. With regards to this report being sent to multiple emails, I can most definitely build in the functionality for you. I will see if I can get to that either today or tomorrow.

Thank you so much for this! I set up a docker on my homelab last night, and it's working as intended. Any chance that a report can be sent to two email addresses? Attached is an example output I got for someone who wants to see what the report would look like.

Hi everyone, so I had the need to get daily, weekly and monthly solar statistics emailed to me but after requesting this directly from the Solar-Assistant team for months, I decided to create it myself. I have made it available to all if you can find the use for it and can be found here - https://github.com/Stef1986/email_scheduler_solar_assistant
Once you have cloned the repo locally, you simply edit the .env file with your Solar Assistant's MQTT details as well as your reporting preferences and run the docker-compose up.
Just have a look at the README.md, it should be detailed enough to get you going.
As a quick overview, basically what will happen is on the host of your choosing, you will run the docker container that will subscribe to the MQTT topic created in Solar-Assistant and will ingest all the data. It will then (based on your choosing) schedule daily, weekly and/or monthly statistic reports to be emailed to your inbox.

The body of the email will contain a nice table with statistics (configurable in the .env file) with min/max/avg values as well as a csv attachment (also configurable) containing the totals for daily, weekly and monthly for stats like PV generated, Battery in, Battery out, etc etc

Hope you guys enjoy and if this helped you, consider supporting my efforts with a beer or two 😁🍻

Hi everyone, so I had the need to get daily, weekly and monthly solar statistics emailed to me but after requesting this directly from the Solar-Assistant team for months, I decided to create it myself. I have made it available to all if you can find the use for it and can be found here - https://github.com/Stef1986/email_scheduler_solar_assistant
Once you have cloned the repo locally, you simply edit the .env file with your Solar Assistant's MQTT details as well as your reporting preferences and run the docker-compose up.
Just have a look at the README.md, it should be detailed enough to get you going.
As a quick overview, basically what will happen is on the host of your choosing, you will run the docker container that will subscribe to the MQTT topic created in Solar-Assistant and will ingest all the data. It will then (based on your choosing) schedule daily, weekly and/or monthly statistic reports to be emailed to your inbox.

The body of the email will contain a nice table with statistics (configurable in the .env file) with min/max/avg values as well as a csv attachment (also configurable) containing the totals for daily, weekly and monthly for stats like PV generated, Battery in, Battery out, etc etc

Hope you guys enjoy and if this helped you, consider supporting my efforts with a beer or two 😁🍻

Hi everyone, so I had the need to get daily, weekly and monthly solar statistics emailed to me but after requesting this directly from the Solar-Assistant team for months, I decided to create it myself. I have made it available to all if you can find the use for it and can be found here - https://github.com/Stef1986/email_scheduler_solar_assistant
Once you have cloned the repo locally, you simply edit the .env file with your Solar Assistant's MQTT details as well as your reporting preferences and run the docker-compose up.
Just have a look at the README.md, it should be detailed enough to get you going.
As a quick overview, basically what will happen is on the host of your choosing, you will run the docker container that will subscribe to the MQTT topic created in Solar-Assistant and will ingest all the data. It will then (based on your choosing) schedule daily, weekly and/or monthly statistic reports to be emailed to your inbox.

The body of the email will contain a nice table with statistics (configurable in the .env file) with min/max/avg values as well as a csv attachment (also configurable) containing the totals for daily, weekly and monthly for stats like PV generated, Battery in, Battery out, etc etc

Hope you guys enjoy and if this helped you, consider supporting my efforts with a beer or two 😁🍻

Hi everyone, so I had the need to get daily, weekly and monthly solar statistics emailed to me but after requesting this directly from the Solar-Assistant team for months, I decided to create it myself. I have made it available to all if you can find the use for it and can be found here - https://github.com/Stef1986/email_scheduler_solar_assistant
Once you have cloned the repo locally, you simply edit the .env file with your Solar Assistant's MQTT details as well as your reporting preferences and run the docker-compose up.
Just have a look at the README.md, it should be detailed enough to get you going.
As a quick overview, basically what will happen is on the host of your choosing, you will run the docker container that will subscribe to the MQTT topic created in Solar-Assistant and will ingest all the data. It will then (based on your choosing) schedule daily, weekly and/or monthly statistic reports to be emailed to your inbox.

The body of the email will contain a nice table with statistics (configurable in the .env file) with min/max/avg values as well as a csv attachment (also configurable) containing the totals for daily, weekly and monthly for stats like PV generated, Battery in, Battery out, etc etc

Hope you guys enjoy and if this helped you, consider supporting my efforts with a beer or two 😁🍻

Hi everyone, so I had the need to get daily, weekly and monthly solar statistics emailed to me but after requesting this directly from the Solar-Assistant team for months, I decided to create it myself. I have made it available to all if you can find the use for it and can be found here - https://github.com/Stef1986/email_scheduler_solar_assistant
Once you have cloned the repo locally, you simply edit the .env file with your Solar Assistant's MQTT details as well as your reporting preferences and run the docker-compose up.
Just have a look at the README.md, it should be detailed enough to get you going.
As a quick overview, basically what will happen is on the host of your choosing, you will run the docker container that will subscribe to the MQTT topic created in Solar-Assistant and will ingest all the data. It will then (based on your choosing) schedule daily, weekly and/or monthly statistic reports to be emailed to your inbox.

The body of the email will contain a nice table with statistics (configurable in the .env file) with min/max/avg values as well as a csv attachment (also configurable) containing the totals for daily, weekly and monthly for stats like PV generated, Battery in, Battery out, etc etc

Hope you guys enjoy and if this helped you, consider supporting my efforts with a beer or two 😁🍻

You will have to set again parameters 12, 19, 20, and 21. If your inverters are running in parallel you only have to change it in one of your inverters, also you will have to change the charging currents in parameters 2 and 11, these settings you have to change in both inverters.
 

UPDATE: I am glad to report that my batteries are again 100% SOC.
Thank you to all for the assistance. I finally think I understand how the batteries internal BMS work now in order to balance the individual cells. 
 
 

UPDATE: I am glad to report that my batteries are again 100% SOC.
Thank you to all for the assistance. I finally think I understand how the batteries internal BMS work now in order to balance the individual cells.