hey all, i was wondering if their was somewhere i could find out about how the music database is structured in amarok

i really like it so far ( have changed from windows to ubuntu) but i was wanting to write myself a python script to import my entire itunes library directly, i know you can use the MySQLdb module to do this in python, however i dont know where to get the information about the database itself...

any pointers would be much apreciated thanks

sorry, this is prob in the wrong post... if their is a mod... could you please move it to dev possibly or help

I'm writing a python script to do the exact same thing, actually.
If you're using MP3s, you can just point Amarok to your top-level directory and it will work fine. If, like me, you're using WAVs, you need some sort of script (you seem to have figured this out already)

I don't know if there are any formal documents on the format. I'd suggest going into mysql and doing a "show tables;" then "describe ;" for each table that looks interesting. That's what I've been doing. I don't have it in a text file, though. Otherwise I'd send it to you.

The other thing I'd suggest doing is findind some tagged MP3 files so you can see how things actually get stored in the database. It's really helpful.

yeh thats what iv been trying to do ( show tables and desc tables...) but i was yeah more looking for a more formal format of the database, its ok though, thanks for that, and i was making mine so that it will take all of them playcounts and ratings etc out of an itunes xml export...

I'm not worried about playcounts and ratings - it's a shared iTunes setup. Mine's just grabbing standard metadata (artist, album, genre, &c).

If you're interested in collaborating, I'm gonna set up a page on Google code to handle source control anyway, so it's not a big deal to get it set up with another author.

are you working in python???

email me... n_d_89@hotmail.com