Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[okvaal]

is that possible? The reason why I want to do this, is that I'd like to make a complete list of all the music I've got, vinyl, CD and mp3s.

[csimon]

I'm sure this is possible and seen references to it before, try searching in the forums for "export to excel".  There is also this Wiki article: http://wiki.jriver.com/index.php/Export_Playlists

And I've also quickly tried it myself via Windows copy-and-paste, i.e. you get a file listing in the content pane with the columns that you require, select them all, then CTrl-C. You can then paste that into a text file and it becomes tab-delimited, which you can then import into a spreadhseet.

[MrC]

You can paste directly into the spreadsheet - no middleman required.

[Alex B]

You can start with creating a smartlist that shows only the necessary data.

Here is what I use for creating an album list:

.

[Media Type]=[Audio] ~limit=-1,1,[Filename (path)] ~sort=[Album Artist (auto)],[Date],[Album]

The rule shows only a single track from each album (it works correctly when each album is in a separate folder.)

I have set the list to show only three relevant columns. Only these fields are included when I copy the list to a spreadsheet ( click the list pane > Ctrl+A > Ctrl+C > switch to Excel > Ctrl+V ):

[Arindelle]

+1 Alex B, I do the same thing.

For info you can also create a smart list like this then export it in csv or html for other uses.

Can't find the post, but there is a good one if you dig a bit to create dummy entries for your vinyls which you could then also export in this manner and/or have them catalogued through MC

EDIT: was just under my "nose" http://yabb.jriver.com/interact/index.php?topic=82202.0

[okvaal]

Thanks a lot to all of you. Yes, I was pretty sure I had seen this topic too, but couldn't find what I was looking for. This was even better! 

[Arindelle]

Code: [Select]

[Media Type]=[Audio] [File Type]=[fla],[flac] ~nodup=[Album Artist /(auto/)],[Album] ~sort=[Album Artist (auto)],[Album Artist],[Album],[Groupings],[Genres] ~limit=-1,1,[album]
@okvaal - might want to look at mine too. I tried Alex B's smartlists on my library and I have too many multiple CDs in subfolders -- I'm using Album and not path/ plus this removes possible dupes.

you have to remove the File Type= .... if you want all formats in your library

[okvaal]

Thanks, Arindelle. I'll have a look at this this afternoon. (Summer holiday, and it's too hot to think right now. In Norway, that is  )
But I definitely seem to be getting what I want/need know. I'll try these solutions and your File Type notification will probably be of some use.
Thanks again.