How to correct values in database?

[JanPedaal]

Hi,

I have a Raspberry Pi running WSL connected via RS485 to a PowerOne 2000 inverter.

The system started energy production September 11, but I only started logging 3rd of October. From 11-09 to 3-10, I produced about 138 kWh. All of this energy is now logged as been produced on 3-10. Is there any way to correct this?

To clarify a bit: I want to manually change the reported daily production to the values I have manually recorded.

I found the instruction on repairing the SQL database using a dump text file, but so far didn't succeed in actually exporting the values to a text file.

Any ideas?

WSL data:

Actual production (Manually added to PVoutput)

Regards,

JanPedaal

[Marco]

in Admin::Yields its possible to change/add daily production values.

Is this what your looking for?

[JanPedaal]

Maybe.. this screen is kinda scary without an explanation :)

I am guessing I should choose "add new" because that's the only option it is showing. But what will it add?

[Marco]

Set the picklist to the right inverter and you should now see the production months.

Select the month on which you want to change data.

The you will see the production days with a edit link.

Also you could add production days with the "add new" link.

You will see an popup box, where you could fillout the date and production figure.

[JanPedaal]

Thanks, the "add new" doesn't do anything here, but I get the production months. This edit function is exactly what I was looking for. 

What values does the "device" column show? It is actually giving "device" values in september but the first kWh values are on 3rd of october.

[JanPedaal]

Found it, the device values are the daily production values x 10.

Thanks for your help!