Domoticz

Hello Forum members
I would like to get some tips for the next challenge.
Since a week I have my ZeverSolar (solar panels) on domoticz.
Now I have downloaded all data via the SolarCloud as a csv file.
Now I would like to put this data in the Zeversolar Counter (dummy counter).
How can I best tackle that?
1 a script that automatically fills the counter?
2 editing the domoticz.db
3 ?
Attachment, type of counter and example csv file.
Please comment
Greetings Jan

Anyone have a good suggestion or tip?
Think input yourself via json script,
The data is then in a csv, the json script loads data and date and writes them in the counter.

It worked, inserted 5 years of data from my solar panels.
My method was as follows,
1 First put all data in a csv file in the correct format. comma separated etc.
2 Backup the domoticz so that you have the latest data.
3 Copy the backup, and open copy with DB Browser (SQLite).
4 Now you can import the CVS, indicate correct folder, with me 'Meter_Calendar' You will be asked if you want to add the values.
5 Save and close the DB
6 Restore the backup.
7 Stop and restart Domoticz.
8 Clear the short log sensors.
Now all values can be seen, under the sensor.

So far, will add some screenshots.
Greetings Jan

Make a good CSV file
Here some screenschots

Open db and insert.
CSV insert, see tabel looking good.