How do I fill a counter

[JanAtHome]

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

screenshot.6737.jpg (271.65 KiB) Viewed 940 times

[JanAtHome]

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.

[JanAtHome]

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

[JanAtHome]

Make a good CSV file

screenshot.6760.jpg (167.58 KiB) Viewed 885 times

Here some screenschots

Open db and insert.

screenshot.6761.jpg (302.7 KiB) Viewed 885 times

CSV insert, see tabel looking good.

screenshot.6757.jpg (195.52 KiB) Viewed 885 times