As indicated, need to find an alternative solution for data-upload.
Recently revisiting this question, and with some different Google-searchkeywords, now seem to have found access to the wiki of Sonnenertrag.eu and to some related forum-messages.
Do not ask why, but
not on my PC&Windows, but
on my iPad I can reach the wiki of Sonnenertrag.eu (through a direct call to lower level of the wiki):
e.g.
https://wiki.sonnenertrag.eu/datenimport:json and
https://wiki.sonnenertrag.eu/datenimport:selfmade and
https://wiki.sonnenertrag.eu/datenimpor ... g:solarlog
The required general setup is best summarized in wiki-section
https://wiki.sonnenertrag.eu/datenimpor ... aussetzung and it's subsections
On file-handling some practical example-info from users at
https://www.photovoltaikforum.com/threa ... -erzeugen/
The description below is resulting from my experiments using bits & pieces of info to get (with try & error) a working implementation of 'Selfmade' upload.
A rather long story, but no reason that 'successors' in this forum meet the same pitfalls and/or need to reinvent the wheel:
summary below with the bloody details to be found in the spoiler .....
1. Manual filling of data-gaps
Manual filling of the gaps is applicable if you already have some registration of values before you try to start automatic upload towards Sonnenertrag.eu, and would like to include historic data into that registration. Useful to get acquainted with Sonnenertrag.eu
Is
basic setup if you just want manual data entry per completed month (considering automatic upload a luxury)
2 Possible layouts for
data-processing:
either highly detailed by insertion of value-per-day,
or by value-per-month with min. & max.
Can be selected in bottom rows of upper right corner of UserMenu, and
then
manually enter the required data for the (incomplete) month(s) in the database of Sonnenertrag.eu
2. Filling of data-gaps by Upload of Month-infotable
For automated upload of month-data, goto setup-window for your
installation [= top rows of upper right corner of UserMenu]
For 'Selfmade'-import it is required that in the 3rd setup-window you insert the hosting-url = http://<hosting-folder>/months.js
<hosting-folder> is
your privately selected designated folder at a server at internet to which your system uploads the file, to be grabbed by Sonnenertrag.eu at a later time [= next morning].
2 Files are needed as inputs, to be placed at <hosting-folder>:
- File
base_vars.js is required for the configuration setup of the 'Selfmade' data-import.
- File
months.js contains data per month: from months.js each morning only latest 3 months in the file are being read by Sonnenertrag.eu
3.
Filling of data-gaps by Upload of Day-infotable
For this mode of operation it is required that in the setup-window for 'Selfmade'-import you
keep the hosting-url http://<hosting-folder>/
months.js
- File
base_vars.js is required same as in 2.
- File
days_hist.js contains data per day: from days_hist.js each morning only latest day is being read by Sonnenertrag.eu
- Spoiler: show
-
To arrive at application of an automatic 'Selfmade' uploadfunction the following multistep slow-train' approach might be Run-up incl. learning curve:
1. Manual filling of data-gaps
Manual filling of the gaps is applicable if you already have some registration before you try to start automatic upload towards Sonnenertrag.eu, and would like to include historic data into that registration. Useful to get acquainted with Sonnenertrag.eu
Is basic setup if you just want manual data entry per completed month (considering automatic upload a luxury)
Also for bulk filling of any data-gaps over 2018 till today unfortunately the quickest method is this laboursome procedure using the setup web-pages of Sonnenertrag.eu for 'processing of data' [= upper righhand corner of 'Usermenu'].
2 Possible layouts for data-processing: either highly detailed by insertion of value-per-day, or by value-per-month with min. & max.
manually enter the required data for the (incomplete) month(s) in the database of Sonnenertrag.eu
2. Filling of data-gaps by Upload of Month-infotable
Goto setup-window for your installation [= upper right corner of UserMenu]
For 'Selfmade'-import it is required that in the 3rd setup-window you insert the hosting-url = http://<hosting-folder>/months.js
<hosting-folder> is your privately selected designated folder at a server at internet to which your system uploads the file to be grabbed by Sonnenertrag.eu at a later time [= next morning].
File base_vars.js is required for the setup of the 'Selfmade' data-import. Described in wiki as mandatory, but it is duplicate of info already inserted by the web-setup (anyway, a simple & once-only effort to make and upload this file base_vars.js with info compatible with the web-setup)
File months.js contains data per month: from months.js each morning only latest 3 months in the file are being read by Sonnenertrag.eu
(Manually) make file months.js starting after the last complete month in database of Sonnenertrag.eu, as filled with 1. and upload file months.js to the <hosting-folder>. Sonnenertrag.eu grabs the file in next morning.
=> check upload & pick-up from <hosting-folder> by Sonnenertrag.eu => if OK for file with 1 month, then
in a series of days (manually) expanding file months.js with max. 3 months/day till database filled upto/incl.last month.
Once this method has been proven over several days, to accelerate the filling of data-gaps, useful to revert to use of method 1. for filling per month for remaining 'empty' months.
May be candidate for automation by script if your PV-system provides montly data for PV-production, but
own experience (looking at results in the webtable for manual insertion, with manual insertion halfway in a month) is that this function in this way happily reports that everything OK, but only makes a strange filling for minimal month-value, although the file seems to meet the prescribed format.
Emperically found that apparently no completed months are allowed later than the remaining gap.
Quick&Dirty solution:
- in the webtable for manual insertion clear the data-windows for all subject months till running month,
- untick all visible boxes 'autofill',
- 'save' this cleaned webtable,
- manually fill all data-windows,
- tick the 'autofill'-boxes and
- save.
3. Filling of data-gaps by Upload of Day-infotable
For this mode of operation it is required that in the setup-window for 'Selfmade'-import you keep the hosting-url http://<hosting-folder>/months.js
File base_vars.js is required same as in 2.
File days_hist.js contains data per day: from days_hist.js each morning only latest day is being read by Sonnenertrag.eu
(Manually) make days_hist.js starting after the last month in database of Sonnenertrag.eu, as filled with 2. and upload to the hosting-url. Sonnenertrag.eu grabs the file in next morning.
=> check upload & pick-up from <hosting-folder> by Sonnenertrag.eu => if OK for file with 1 day, then
in a series of days (manually) expanding file day_hist.js with 1 day/day.
Once this method has been proven over several days you have checked the functional mechanism, but you will not hook on to the actual data-registration (because of pace of 1day/day):
to accelerate the filling of data-gaps till 'yesterday', useful to revert to use of method 1. for filling per day of remaining 'empty' days.
Candidate for automation by script for upload of daily PV-production.
For 'Express' way of testing, see further down this section.
4. Automatic dailly upload
The text outside the spoiler is all needed for this mode of operation.
During test, for check of correct operation of automatic file-upload, next morning do read-back of the hosting-url (dependent on the setting of your <hosting-folder>)
by means of http://<hosting-folder>/months.js and http://<hosting-folder>/days_hist.js
or by https://<hosting-folder>/months.js and http://<hosting-folder>/days_hist.js
Possible alternative 'Express' way of testing for 3.:
a. Manually compile all files mentioned under 4. and perform upload to the <hosting folder>
b. Login to Sonnenertrag.eu
c. In upper right corner under 'Installatiebeheer' choose the applicable installation
d. 'walk' the setup pages,
d1. check&fill as required the first 2 pages
d2. fill-in the setup-page3 for 'Self-made' mode (for howto see 2. above)
d3. check at setup-page 3 that plausibility-test is OK
d4. click 'trigger automatic import'
e. check at display of graphs whether data shows as expected
4.
Automatic dailly upload/update
For
subsequent automatic upload starting 'today' then
'only' the development is required of a small script [using lua or Python or dzVents or ...] generating the required js-files and daily uploading them to the tested <hosting-folder> for pick-up by Sonnenertrag.eu in the next morning of upload-files:
- months.js (to be generated/uploaded at the end of each day)
- days_hist.js (also to be generated/uploaded at end of each day)
- base_vars.js (once-only effort to make and upload this file, as configuration-reference)
You have choice for implementation using either months.js (with daily update for production of running month), or days.hist.js (reporting daily production)
Just wondering whether & why to generate & upload the other file min_day.js as mentioned in wiki and forum-messages:
- min_day.js only seems required if you like to join the competition to be the daily topstation at Sonnenertrag.eu
[it also keeps your system busy with an upload desired every 5 minutes]
July 15th till July 20th, 2021:
Editing to include some more explanation, for own experience with automated month-input, for alignment with previous & next messages, shifting experimental details to the spoiler