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";
Sorry for the late reply @jonas .
I tried the integrity check and it came back ok.
I did a bit more thinking about this, and I think I pinned down the problem.
Suppose I open a file from the "Collection" menu and right click --> "Edit Track Info." Then Path shows up as /media/WD1TB/music/collection/whatever.mp3, even though this is just a symlink to /media/WD2TB/music/collection/whatever.mp3.
However, now suppose I open a playlist that has /media/WD2TB/music/collection/whatever.mp3 as one of the entries. Then "Edit Track Info" shows the Path as /media/WD2TB/music/collection/whatever.mp3. Presumably that file is not found in the collection/library, so it has empty playcounts and lastplayed information.
Now here's the part that doesn't make sense to me, and which I think might be undesirable behavior in Strawberry. Suppose I go into that playlist and manually edit the filename so that it is /media/WD1TB/music/collection/whatever.mp3, which again is just a symlink to /media/WD2TB/music/collection/whatever.mp3. When I open the playlist, "Edit Track Info" follows the symlink and still says the Path is /media/WD2TB/music/collection/whatever.mp3, so that the file is again not found in the collection/library.
So it seems like Strawberry's behavior with respect to symlinks is different when opening something through collection than it is through a playlist.
A related question on how the database is organized. Is it really the case that files are indexed and searched for by their absolute paths, as suggested by the behaviour above? If so, what is the recommended procedure for changing where the collection is mounted?
@v1993 +1 on this question. Maybe it is a planned (future) feature but when I saw it I thought maybe it played the first 30 seconds (or some other duration) of each track in a playlist. I've tried enabling it before or after loading a playlist but nothing really seems to happen. Just curious.