Migrate "platform: integration" sensors from configuration.yaml to Integrations -> Powercalc in the UI

[lokster]

I have multiple "platform: integration" sensors, configured in configuration.yaml like this:

sensor:
  - platform: integration
    name: "Plug1 Energy"
    source: sensor.plug1_power
    round: 3
    method: left

Is it possible to somehow migrate them to the Powercalc Integration configuration available in the UI using "Energy from real power sensor" without losing any stats data?
Even if it requires some manual work, it's ok, as long as there is a way...

[bramstroker]

I don't think there is a solution for this out of the box,

But you could do it yourself with some SQL queries if you have DB access.
You could update the newly created powercalc entity with the historical data from the existing entity.
Two tables statistics and statistics_short_term
You can do so with an INSERT INTO .. SELECT FROM. don't have time to make an example right now.