Media Library Report

[mphare]

Hi,

Is there a way to create a printable list of my Media Library? Ideally, it would provide the data in the same columns and same order as 'Local Media' does (e.g. if I sort Local Media by Artist, then so does the report)

I have Winamp installed in two locations and I want to sync the media across the two sites. A list would provide a simple way to make sure the two sites are the same. Now that I say that, exporting to a CSV or XML file would be good to. I could pull them into excel or create some bash scripts to do the comparison for me.

Thanks,

- mike

[DrO]

http://nunzioweb.com/daz/mlexporter.html fits that need though requires Winamp 5.57 as it works with the most recent changes of the library database format.

-daz

[MrSinatra]

neat.

some feature reqs:

export to excel native format.
export to html.
ability to export artwork optionally, and set the max size.
ability to choose what criteria are exported, and in what order, meaning i would want it like this:

AA, A, album, track #, title, length, rating, genre, bitrate, filepath

or whatever a user wants.

mp3tag has some powerful export options, BUT i hate all the tacky templates over there.

[DrO]

exporting to native xls isn't going to happen. koopa also asked for it but there's just no benefit to having to work out the file format (though i think it is sort of documented) when importing a csv file does the same without the extra space in the file.

not sure about html output as not sure what the benefit of that would be and also the format unless i just dump it out as a basic table. as a basic table is more likely for me to get it done this side of the festive season (though i'm still wanting to get xspf support in there).

with the artwork, i believe i can read the two sets of database files containing the information and vaguely work out the size it has been stored in but i was never too certain on the benefit / use of just dumping a load of image data (or where / how to place / name it).

the choice on what is exported is something i thought about but haven't done anything towards though would pretty much require the internals to be re-done to make it possible (as it dumps the data pretty much in the order things are stored in the db files).

and ironically, the two people i implemented the plug-in for have never posted back / replied to the test versions i sent (got to love that, heh).

-daz

[MrSinatra]

Originally Posted by DrO

not sure about html output as not sure what the benefit of that would be and also the format unless i just dump it out as a basic table. as a basic table is more likely for me to get it done this side of the festive season (though i'm still wanting to get xspf support in there).

don't know what xspf is, but html output would make it look nice when posted to the web, (you could browse my collection) and allow the insertion of artwork images, one per album.

Originally Posted by DrO

with the artwork, i believe i can read the two sets of database files containing the information and vaguely work out the size it has been stored in but i was never too certain on the benefit / use of just dumping a load of image data (or where / how to place / name it).

in an html export, you could arrange by AA and album, and then have the file limited to one side being a max of 200 (or whatever the user specifies) pixels, maintaining aspect ratio.

just use the same filename it already has... if its generic like Folder.jpg, do <AA>-<Album>-Folder.jpg

Originally Posted by DrO

the choice on what is exported is something i thought about but haven't done anything towards though would pretty much require the internals to be re-done to make it possible (as it dumps the data pretty much in the order things are stored in the db files).

and ironically, the two people i implemented the plug-in for have never posted back / replied to the test versions i sent (got to love that, heh).

-daz

can't speak to the internals, but couldn't the plugin call the data in the order wanted? kinda like title formating, or something like that, use the symbols to arrange the output?

when i exported to a txt file, i basically just got a big list of every files filepath. useful in case of calamity or i want to send to others if they want to search it, but not very friendly or really useful otherwise.

[DrO]

don't know what xspf is

xspf is a shareable xml based playlist format -> http://xspf.org/ it's basically something i'd like to add in to complement the xspf playlist loader floating around for Winamp (in the sdk if i remember correctly) and also so i have an xml format but not one that is tied to iTunes.

in an html export, you could arrange by AA and album, and then have the file limited to one side being a max of 200 (or whatever the user specifies) pixels, maintaining aspect ratio.

now i see what you're wanting to achieve with an html output (and makes more sense with the AA aspect).

but couldn't the plug-in call the data in the order wanted? kinda like title formatting, or something like that, use the symbols to arrange the output?

yes it could do that, but i'd have to change things around to cope with doing that. as it was a quick day and a bit job to get the plug-in to it's current state, i only really designed it to just dump the data based on the two requests and how that was described and then for some of the bits i added in additionally to the requests. so i just made it output things in the order they were instead of going for the complete design from the start where it's all configurable and all that fun stuff

when i exported to a txt file, i basically just got a big list of every files filepath. useful in case of calamity or i want to send to others if they want to search it, but not very friendly or really useful otherwise.

that was one of the ones requested to just dump the filenames so it does what it does. it was the inflexibility of that which made me then add in the csv support so it is easier to export and then manipulate the file later.

the fun will be if i get around to importing the data back into the library.

-daz

[mphare]

Nice plugin, Thanks for the link!
Since we are requesting features...
I'd like to be able to export information as it is shown in my Media Browser.. In otherwords, Sorted as my media library is sorted, and containing the columns I've Customized.
In short, I'd like a dump of my media library as I am currently viewing it.

But even without that.. It's a nice plugin.

Thanks again!

[DrO]

well the columns is pretty much what MrSinatra is requesting though i don't know of anyway to get the actual sorting order either via reading in settings or by hacking into the current view.

it would be possible to do it based on a specific view / query and is already something i had got in my mind to do (it already does it as it basically specifies a blank query to work on the whole dump) so that'd be about the nearest i can do.

-daz

[tigercap]

I, too, would love to be able to copy all my media library info. I have thousands of songs and have taken great pride in having actual LP, year, etc. I'd love to have that same view in Excel and sort through it, save it, send it to friends, etc.