Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database schema #2

Closed
pol22pol opened this issue Sep 11, 2020 · 10 comments
Closed

Database schema #2

pol22pol opened this issue Sep 11, 2020 · 10 comments

Comments

@pol22pol
Copy link

Can you share the database schema where the data is stored?

@BlazejosP
Copy link
Owner

Yes of course that isn't complicated database

@BlazejosP
Copy link
Owner

For example look in line 588 in bash file.
there is Power=alarms what means alarms descriptions are stored inside table "Power" and column "alarms" inside influxDB you can use my tables or create your own if you change this fields in curl commands. If that meaby usefully for you I can upload my already done grafana visualisation. In that case without changing names of tables/columns you can immediately see your data on graphs?

@BlazejosP BlazejosP reopened this Sep 12, 2020
@pol22pol
Copy link
Author

I think, Your grafana visualisation will be very useful. :-)
Did you try to use API from main FusionSolar site? They work similarly, but provide more informations.

@BlazejosP
Copy link
Owner

I uploaded my Grafana panel for you. This panel used my schematics of tables&columns in InfluxDB so you should have your data when you import him to Grafana, because tables are already created by curl commands from fusionsolarapp.sh if not existing. Now only in polish language but is enough for tests. And don't forget add Sun and Moon plugin in Grafana which is responsible for sun position graph.

@BlazejosP
Copy link
Owner

BlazejosP commented Sep 20, 2020

Did you try to use API from main FusionSolar site? They work similarly, but provide more informations.

I already use their official API from FusionSolarAPP problem is that not everything what is inside their software is available through API. For example Temrature of Inverter or Actually inverted power. Meaby they are scare that script like this will ask their servers too often.

@pol22pol
Copy link
Author

Thx for your Grafana dashboard.
FusionSolar have OpenAPI with same base data.
But when you enable singleKiosk then you have access to a simple API without authorization (you have to know id). For example https://eu5.fusionsolar.huawei.com/kiosk/getPowers give you access to data with 5 minutes interval.
Other API when you login to your account on https://eu5.fusionsolar.huawei.com/index.jsp.

Have you tried to use the second and third APIs?

@BlazejosP
Copy link
Owner

BlazejosP commented Sep 27, 2020

No I don't know about this simple API and access to *.jsp file So that means that are two additional sources of data from inverter especially missed ones. I only used An official one from Huawei documentation. I will investigate this and probably add additional data to .sh file to improve software.

@BlazejosP
Copy link
Owner

BlazejosP commented Nov 22, 2020

Thx for your Grafana dashboard.
FusionSolar have OpenAPI with same base data.
But when you enable singleKiosk then you have access to a simple API without authorization (you have to know id). For example https://eu5.fusionsolar.huawei.com/kiosk/getPowers give you access to data with 5 minutes interval.
Other API when you login to your account on https://eu5.fusionsolar.huawei.com/index.jsp.

Have you tried to use the second and third APIs?

Just first version of new bash script which use "Kiosk mode" is already done it can insert data to influxDB and Domoticz in a few days I will also do an MQTT sending option. I also experimented with taking data directly from fusionsoalarApp web interface there are quite interesting but i can't grab them to bash script is necessary have cookies and some data from this file like session id so I can't create them with use of bash simple I can't figure how login to web interface from bash. (that is different login tha this in API)

@pol22pol
Copy link
Author

OK, I'll check kioskmode.
In kioskmode.sh on line 29 should be "true"

@BlazejosP
Copy link
Owner

BlazejosP commented Nov 23, 2020

OK, I'll check kioskmode.
In kioskmode.sh on line 29 should be "true"

My mistake already repaired. So tell me how is that new file working in your installation hope that all is working without issues. btw You can done pull request and send file after some your improvements in the code

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants