I have discovered that my ratings are still present in the 1.4 database in the statistics table.

I have tried the "import collection" tool and it imports the correct number of tracks, but... not the ratings and statistics.

If it is meant to, it may be because I point 2.2 at the same DB on install, assuming it would import intelligently.

So has using the same DB for 2.2 trashed my ratings forever, if so, why are they still there? I suppose the other question is why is 2.2 not using those ratings?

Paul

I've figured out I could do this manually with something like:

select urls.id as url,
statistics.rating as rating,
statistics.accessdate as accessdate,
statistics.createdate as createdate,
statistics.playcounter as playcount

from amarok.statistics,amarok.urls

where statistics.rating > 0 AND statistics.url = urls.rpath;

To get the stats out. Just need to find the best way to INSERT those into the new DB format (now moved to armarok2 db)

Hi,
Did you figure out a way to do this? I've tried to "use external database" with the result being there are 0 tracks under each album. Using the embedded db and importing collection works, however my ratings (statistics table) are not imported. I've thought the same thing as you but don't know how to manually import the data into this embedded db. My external database in still intact.

The "Import Collection" option in the Settings menu does import rating and statistics only, the title is misleading.
There are several threads already in this forum that explain how to make this work from other databases than SQLite.

Thanks for your reply. I have read many other threads on this subject on this and other boards. I've tried several different ways to get my statistics imported. I have tried "use external database" with no luck. I have tried scanning my collection first then using the "import collection" option. I have tried the "import collection" option before scanning the collection. I have tried converting my MySQL database to SQLite http://amarok.kde.org/wiki/MySQL_HowTo#MySQL_-.3E_SQLite but I get a bunch of syntax errors when trying to read my MySQL db into SQLite.

What I'm after here is importing the percentage field from the statistics table in the 1.4 database. All of the rating values in my old db are 0. The percentage values are what reflect the score of the song from what I've come to understand after years of using 1.x. Example: my most "popular" song has a rating of 0 and a percentage of 98.1666. Amarok 1.4 had the option to show the most popular songs and this percentage is what that was based on.

I'm running Amarok 2.2.1, sqlite3 3.6.19 MySQL 5.0.84, compiled with -DPIC and -fPIC CFLAGS and CXXFLAGS. KDE 4.3.1

Any further suggestions are appreciated. Maybe I should pursue getting the db conversion to work?

Thanks,
Eric

Looks like my best bet for now is using the embedded database, "importing collection" after scanning. This preserved my playcount correctly and I can use the biased playlist feature (which is really nice btw) to pull in most of the good stuff when I feel like doing that. Another anomaly is the "last played" date is correct but the "first played" date is whatever date it's first played with 2.2.1. So I'll get stuff like last played July 2009 first played December 2009.