PDA

View Full Version : reporting against slimserver DB?



gutted
2007-02-28, 10:06
I did a quick search (using search terms "database reporting") but didn't find anything: apologies if this has already been discussed and I've not looked deep enough yet!

But anyway. I kind of like to report against my tags, as it helps me identify corruptions or badly tagged files. for example, if - among the various genres I've got - I find a genre called "Trace Techno" with only 1 file, but I also have a genre called "Trance Techno" with 30 or so tracks, then I can make corrections as necessary.

The way I've currently been doing it is to export all tags from MP3Tag to a text file, and then report off that. It strikes me that it would be cool to have this info in a database of some sort. Then it strikes me that this info is already in a database: the slimserver DB. (I think it's MySQL?)

So anyway - can I plug into this DB with a standard reporting tool and read what's there? Is it encrypted or anything? Has anyone already done something like this?

I work for a software house that makes a reporting tool - so the benefits for me are 2-fold. I can get a clearer picture of my tags, plus I can get to grips with new company software by using it at home against my tag library :)

Possible? Already done? Any comments?

Cheers!
Dan.

mherger
2007-02-28, 10:25
> So anyway - can I plug into this DB with a standard reporting tool and
> read what's there?

You should be able to access the DB using MySQL ODBC drivers. If you're
not running the reporting from the same machine as SlimServer you might
need to change the MySQL configuration (MySQL/my.tt): comment out the
"bind-address" line.

--

Michael

-----------------------------------------------------------------
http://www.herger.net/SlimCD - your SlimServer on a CD
http://www.herger.net/slim - AlbumReview, Biography, MusicInfoSCR