PDA

View Full Version : Export Album List



Patrick Dixon
2005-06-24, 03:07
I'm still not quite convinced that Slimserver is counting albums correctly (partially because the same database on 6.03 and 6.1 reports 666/10094/360 & 665/10082/363 respectively) - and I think it might actually be 668!

So in an effort to either put my mind at rest or help fix a bug, it would be useful to be able to export Slimserver's Album list to a csv file or similar so that I can manipulate it in excel and compare with a list from Tag&Rename.

Is there an easy-ish way to do this?

Thanks.

mherger
2005-06-24, 03:26
> So in an effort to either put my mind at rest or help fix a bug, it
> would be useful to be able to export Slimserver's Album list to a csv
> file or similar so that I can manipulate it in excel and compare with a
> list from Tag&Rename.
>
> Is there an easy-ish way to do this?

Install sqlite on your machine, then run something like:

echo select \* from albums\; | sqlite .slimserversql.db > albums.txt

This is for Linux - Windows might need some adjustments.

--

Michael

-----------------------------------------------------------
Help translate SlimServer by using the
StringEditor Plugin (http://www.herger.net/slim/)

Patrick Dixon
2005-06-24, 03:47
Actually the db is on Linux but I was hoping there might be an easier way than installing SQlite: the Linux box is low power, headless and GUI-less - but I can do Excel on my XP machine!

The other thing is that I really need to know what Slimserver THINKS my albums are, rather than what SQLite says.

mherger
2005-06-24, 07:47
Patrick

> Actually the db is on Linux but I was hoping there might be an easier
> way than installing SQlite: the Linux box is low power, headless and
> GUI-less - but I can do Excel on my XP machine!

I really don't know whether it can get any easier than that line.
SlimServer does not contain any export functionality. But you could of
course use slimserver's CLI - if you think this is easier... And as long
as Excel can't read sqlite files you'll have to take an andditional step.

And don't worry about your machine's specs: sqlite is really lite! It
weighs not even 500kb. And my P/200 took a fraction of a second to execute
the command I gave you with about 6300 songs in a little more than 500
albums. And this machine is about lowest power I could imagine...

> The other thing is that I really need to know what Slimserver THINKS my
> albums are, rather than what SQLite says.

Can't help here.

--

Michael

-----------------------------------------------------------
Help translate SlimServer by using the
StringEditor Plugin (http://www.herger.net/slim/)

Patrick Dixon
2005-06-24, 11:34
I really don't know whether it can get any easier than that line.It's the line above it that worries me more ;-)

mherger
2005-06-24, 13:13
>> I really don't know whether it can get any easier than that line.It's
>> the line above it that worries me more ;-)

One other possibility is indeed the CLI. But you'd have to work on the
result. Connect to the slimserver on port 9090:

telnet yourservername 9090

Get a list of the albums:

albums 0 9999

But seeing the result of this, I guess you'd better install sqlite... :-)

--

Michael

-----------------------------------------------------------
Help translate SlimServer by using the
StringEditor Plugin (http://www.herger.net/slim/)

JJZolx
2005-06-24, 15:13
I really need to know what SlimServer THINKS my albums are, rather than what SQLite says.

They should be one and the same. To date I've found that whatever mistakes I see in the SlimServer web interface I also see in the database - whether SQLite or MySQL.

Offhand, I'd expect the counts in 6.1 to be "more" correct than what you see in 6.03. Still not 100% accurate, but getting closer.