Clara HD Migrating from sideloading to sync while keeping reading stats

[iv-nn]

Hello,

I've a Kobo Clara HD. For years I've used it with Calibre, sideloading all files. Now I'm migrating away from Calibre so I'm using Kobo sync to load the books.

Since these are two different ways to get the books on the ereader it creates duplicates, sideloaded have a `ContentID` starting with `file:///…` and synced entries use what looks like a uuid. So I've written a small script to match the duplicates and copy the reading stats from the sideloaded to the synced one directly in the `KoboReader.sqlite` db. I've copied the following columns in the `content` table*:

    "ReadStatus",
    "DateLastRead",
    "___PercentRead",
    "TimesStartedReading",
    "TimeSpentReading",
    "LastTimeStartedReading",
    "LastTimeFinishedReading",
    "CurrentChapterEstimate",
    "CurrentChapterProgress",
    "RestOfBookEstimate",
    "ChapterIDBookmarked",
    "ParagraphBookmarked",
    "BookmarkWordOffset",
    "FirstTimeReading",
    "DateCreated",
    "DateAdded",

It works well, the synced books now have the proper stats, except for one. The date I started reading. I cannot find where this is stored. I've also looked inside the `Event` db and updated the `ContentID` with the new ones but it did not work either, I'm not sure what the event types are.

Does anyone know how Kobo store the started reading date in the sqlite db?