More > JRiver Media Center 19 for Windows

Library Export to Excel

<< < (2/2)

MikeO:
Thanks to everybody , I created the Smartlist as suggested and whammo its in Excel

Cheers

Mike

jtwrace:
I still think this should be a built in function of JRiver.  This way it will auto update as the library grows and there is no need to copy/paste into Excel as the library changes which is often in my case. 

6233638:

--- Quote from: jtwrace on July 09, 2014, 06:20:18 am ---I still think this should be a built in function of JRiver.  This way it will auto update as the library grows and there is no need to copy/paste into Excel as the library changes which is often in my case.
--- End quote ---
Well using a Smartlist will update as the library changes.
I just had a look at the "Export Playlist" options, and I see that there is an option to only include visible fields, rather than all fields. (which I assumed it would do)
 
If you create the Smartlist I posted, you can simply use the File → Export Playlist command.
As long as you select the "Text File (CSV delimited)" and "Only Visible Fields" options, you will have a file that Excel should be able to view directly.

FenceFurniture:

--- Quote from: Hilton on July 08, 2014, 08:08:56 am ---Yeah I meant to remove the second limit argument.  I copied it off the wiki and adapted it. This one works better.


--- Code: ---Media Type]=[audio] ~limit=-1,1,[album],[album artist (auto)] ~sort=[Sequence]
--- End code ---

--- End quote ---

There's a typo trap for young players (like me) in there: a square bracket [ is required before the "Media" to make it work.

JimH:

--- Quote from: FenceFurniture on August 15, 2019, 10:15:41 pm ---There's a typo trap for young players (like me) in there: a square bracket [ is required before the "Media" to make it work.

--- End quote ---
Thanks.  I fixed it.

Navigation

[0] Message Index

[*] Previous page