INTERACT FORUM

More => Old Versions => JRiver Media Center 18 for Windows => Topic started by: okvaal on July 24, 2013, 04:58:52 am

Title: Copying Artist/Album to Excel or other spreadsheet
Post by: okvaal on July 24, 2013, 04:58:52 am

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.

Title: Re: Copying Artist/Album to Excel or other spreadsheet
Post by: csimon on July 24, 2013, 04:45:39 pm

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 (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.

Title: Re: Copying Artist/Album to Excel or other spreadsheet
Post by: MrC on July 24, 2013, 04:55:29 pm

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

Title: Re: Copying Artist/Album to Excel or other spreadsheet
Post by: Alex B on July 24, 2013, 06:11:05 pm

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

Here is what I use for creating an album list:

(http://i224.photobucket.com/albums/dd212/AB2K/MC/album_list_rule.jpg).

[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 ):

(http://i224.photobucket.com/albums/dd212/AB2K/MC/album_list.jpg)

Title: Re: Copying Artist/Album to Excel or other spreadsheet
Post by: Arindelle on July 25, 2013, 04:05:17 am

+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 (http://yabb.jriver.com/interact/index.php?topic=82202.0)

Title: Re: Copying Artist/Album to Excel or other spreadsheet
Post by: okvaal on July 25, 2013, 05:07:24 am

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!  :)

Title: Re: Copying Artist/Album to Excel or other spreadsheet
Post by: Arindelle on July 25, 2013, 05:59:41 am

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

Title: Re: Copying Artist/Album to Excel or other spreadsheet
Post by: okvaal on July 25, 2013, 06:05:12 am

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  :P )
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.