How to restore stats

mbnoimi

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

mbnoimi

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?

jonas

@mbnoimi
You can either use the original DB file and modify the paths with SQL commands before you start strawberry.
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.

https://github.com/strawberrymusicplayer/strawberry/wiki/Import-collection-library-and-playlists-data-from-Clementine

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.

mbnoimi

@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?

mbnoimi

@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.