Hi to all!

I'm using Amarok for more than 3  years, I donate (not a lot) some money, and I very happy with this application.

A few months ago, I was installed Ubuntu 9.04, and Amarok (2.?). My unpleasant surprise arribes when I start Amarok 2 for first time and I can't saw my statistics (how many times I played a song, score, ...). After ask to Saint Google, research in forums, etc... I can't find solution. For this reason I decided to downgrade to Amarok 1.4.

Here my question... after this time, there is a way to save all my Amarok 1 statistics and then import to Amarok 2?

Thank's!

Just do:
Settings -> Configure Amarok -> Collection -> Import Collection
and you will get an assistant for importing it.
I use Amarok 2.1.1, but I think Amarok 2.1 is able to do it, too.

JanGerrit wrote:Just do:
Settings -> Configure Amarok -> Collection -> Import Collection
and you will get an assistant for importing it.
I use Amarok 2.1.1, but I think Amarok 2.1 is able to do it, too.

So, what is one to do when that doesn't work? The assistant tries to do the import from my Amarok 1.4 database (MySQL), but fails. The only information returned is "0 tracks imported."

Hi !

interesting thread.

JanGerrit wrote:Just do:
Settings -> Configure Amarok -> Collection -> Import Collection
and you will get an assistant for importing it.
I use Amarok 2.1.1, but I think Amarok 2.1 is able to do it, too.

This only works if you used the default SQLite database in 1.4, not with a MySQL one. Full import from SQLite (including scores and ratings) now works in 2.2-git, but not yet from other databases, sorry.

Ok, thank's for the answers!

I'm wait for amarok 2.2 becomes stable.

Thank's again!

Mamarok wrote:

JanGerrit wrote:Just do:
Settings -> Configure Amarok -> Collection -> Import Collection
and you will get an assistant for importing it.
I use Amarok 2.1.1, but I think Amarok 2.1 is able to do it, too.

This only works if you used the default SQLite database in 1.4, not with a MySQL one. Full import from SQLite (including scores and ratings) now works in 2.2-git, but not yet from other databases, sorry.

Hi ! (sorry for my bad english)

it's no possible to convert SQL database amarok 1.4 to SQlite (always for amarok 4.1) and import to amarok 2.x ?

it's no possible to convert SQL database amarok 1.4 to SQlite (always for amarok 4.1) and import to amarok 2.x ?

If I understand JanGerrit correctly, it's possible using amarok 2.1.1 or 2.2

nandelbosc wrote:

it's no possible to convert SQL database amarok 1.4 to SQlite (always for amarok 4.1) and import to amarok 2.x ?

If I understand JanGerrit correctly, it's possible using amarok 2.1.1 or 2.2

Well, no, you didn't understand correctly (and mix up different things), please see my previous post.

jajaX wrote:it's no possible to convert SQL database amarok 1.4 to SQlite (always for amarok 4.1) and import to amarok 2.x ?

No, not as far as I know, there only is an import wizard from 1.4 SQLite to 2.x MySQL embedded for now, I don't remember a database conversion tool in 1.4.

There's an unsupported way in the Amarok wiki to convert MySQL to SQLite.

http://amarok.kde.org/wiki/MySQL_HowTo

But, I tried this, and Amarok didn't import anything. It doesn't imports anything no matter the format.

gjulian wrote:There's an unsupported way in the Amarok wiki to convert MySQL to SQLite.

http://amarok.kde.org/wiki/MySQL_HowTo

But, I tried this, and Amarok didn't import anything. It doesn't imports anything no matter the format.

So you now have a collection.db?
If so, start a scan without importing anything.
After the scan finished, import the collection.db
But be sure to build the collection first.

m0nk

Dieter Schroeder wrote:So you now have a collection.db?
If so, start a scan without importing anything.
After the scan finished, import the collection.db
But be sure to build the collection first.

m0nk

I tried to do that. Also tried with a fresh installation of Amarok 2 (moving the amarok directory in home/.kde)

Nothing worked.

Okay step by step:
To clearify it: Importing means import of your statistics, not of your collection.
So you need to have a collection before importing something.
OK:
You've dumped your old MySQL database, created a SQLite database (name doesn't matter, but let's call it collection.db) with the schema mentioned in the wiki?
You can access the SQLite database with

Code: Select all

sqlite3 collection.db

?
On the prompt type

Code: Select all

.tables

Are there tables in your db?
type

Code: Select all

select * from statistics;

to see if there are entries
Any entries?
If not, there's nothing to import. If yes, fine.
Start amarok-->open the settings tab-->collection/import collection(btw. unlucky name, should be import statistics)-->point it to your new collection.db-->ok
Now cross fingers and after a while A2 should start importing your stats from Amarok 1.4.
Btw. In 2.2 you can import from all three databases used by Amarok 1.4.x but I haven't tested it.

Good luck

m0nk

Thanks for your help, it worked fine.