Ahh got it to work. I have to refresh the opened playlist. Then the imported dates are visible. If someone needs the export SQL from Media Monkey to Strawberry:
SELECT SongPath, Artist, Album, AlbumArtist, TrackNumber, DiscNumber, SongTitle, PlayCounter, strftime('%s', datetime(LastTimePlayed + 2415019.0)) as lastplayed
WHERE LastTimePlayed > 0;
Media Monkey uses juliandate to save the date. I export the other fields additionally, to match the fields in Strawberry and find the correct songs. Form the returned entrys, i create the above UPDATE statement for Strawberry:
UPDATE `songs` SET `lastplayed` = 1631919400, `playcount` = 4 WHERE `artist` = "Some Artist" AND `album` = "Some album" AND `track` = 5 AND `title` = "some title";
I restored from a backup done on 31 December 2021.
It looks good so far. I only lost around 150 ratings.
One thing I never liked about storing data in the files was how long it took to run a backup every file I listened to was changed and got backed up. So I'm going to do the fingerprinting run a backup and see how that goes.
I was testing with the Qt development branch where it works. When testing with Qt 6.2.2 it does not work. It's a Qt bug present in Qt 6.2.2 that is already fixed, so it will resolve itself when the next Qt release is available.
@jonas I upgraded to 1.0.1 this morning, but I can't see any change. I've rescanned the collection and try to "remove unavailable tracks from playlist", but nothing happens, even if I know that there are hidden tracks there. Do I have to flush the playlist and start over?