@jonas said in How to restore stats:

I plan to make a new release soon, there will be an option to turn on song fingerprinting and tracking to prevent losing playcounts and ratings.

The recent release (Version 1.0) still doesn't fix this issue.

I suggest to make an integration with Jellyfin media server because nowadays lot of people use clouds.

@jonas said in How to restore stats:

The other option is to import the data to the new DB based on artist/album/title, you can use parts of the guide I made here, but you have to modify the query to import only playcounts and rating from the other DB.

Thanks a lot for the good guide.

@jonas said in How to restore stats:

I plan to make a new release soon, there will be an option to turn on song fingerprinting and tracking to prevent losing playcounts and ratings.

I prefer to wait for your release in case you'll produce it within less than 1 month. Do you?

I opened the original strawberry.db for comparing with the new one and I noticed the difference.
It seems the paths of my library are not the same (I enhanced my library without updating old strawberry.db) so songs.url values are different.

Example:

• Original: songs row is

INSERT INTO "main"."songs" ("title", "album", "artist", "albumartist", "track", "disc", "year", "originalyear", "genre", "compilation", "composer", "performer", "grouping", "comment", "lyrics", "artist_id", "album_id", "song_id", "beginning", "length", "bitrate", "samplerate", "bitdepth", "source", "directory_id", "url", "filetype", "filesize", "mtime", "ctime", "unavailable", "playcount", "skipcount", "lastplayed", "compilation_detected", "compilation_on", "compilation_off", "compilation_effective", "art_automatic", "art_manual", "effective_albumartist", "effective_originalyear", "cue_path", "rating") VALUES ('SALAMUN ALA DUNYA', 'SALAMUN ALA DUNYA', 'Adam Ali', 'Adam Ali', '-1', '-1', '2018', '-1', '', '0', '', 'Adam Ali', '', '', '', '', '', '', '0', '125016000000', '260', '48000', '-1', '2', '1', 'file:///home/mbnoimi/Music/Adam%20Ali/SALAMUN%20ALA%20DUNYA/SALAMUN%20ALA%20DUNYA.mp3', '8', '4060798', '1595214021', '1590594062', '0', '31', '4', '1625400994', '0', '0', '0', '0', '', '', 'Adam Ali', '-1', '', '0.800000011920929');

• Current: songs row is

INSERT INTO "main"."songs" ("title", "album", "artist", "albumartist", "track", "disc", "year", "originalyear", "genre", "compilation", "composer", "performer", "grouping", "comment", "lyrics", "artist_id", "album_id", "song_id", "beginning", "length", "bitrate", "samplerate", "bitdepth", "source", "directory_id", "url", "filetype", "filesize", "mtime", "ctime", "unavailable", "playcount", "skipcount", "lastplayed", "compilation_detected", "compilation_on", "compilation_off", "compilation_effective", "art_automatic", "art_manual", "effective_albumartist", "effective_originalyear", "cue_path", "rating") VALUES ('SALAMUN ALA DUNYA', 'SALAMUN ALA DUNYA', 'Adam Ali', 'Adam Ali', '-1', '-1', '2018', '-1', '', '0', '', 'Adam Ali', '', '', '', '', '', '', '0', '125016000000', '260', '48000', '-1', '2', '1', 'file:///home/mbnoimi/Music/Adam%20Ali/SALAMUN%20ALA%20DUNYA/Adam%20Ali%20-%20SALAMUN%20ALA%20DUNYA%20-%20SALAMUN%20ALA%20DUNYA.mp3', '8', '4060798', '1629923620', '1630573650', '0', '0', '0', '-1', '0', '0', '0', '0', '', '', 'Adam Ali', '-1', '', '-1');

Do you have any suggest for restoring playcount and rating values?

Hi,

Recently I bought a new PC so I copied Strawberry config folders to the new PC for restoring the statistics (playcounts & ratings) and the configurations of my library but it didn't work for the stats although I use the same user name (exactly the same path)

~/.config/strawberry
~/.local/share/strawberry/

What I'm missing?

• Linux Mint 20.2 XFCE
• Strawberry 0.9.3