INTERACT FORUM

More => Old Versions => JRiver Media Center 29 for Windows => Topic started by: sgfrisbee on November 24, 2022, 07:07:02 pm

Title: A list of all media in JRiver
Post by: sgfrisbee on November 24, 2022, 07:07:02 pm

Is there a way to create list (txt, excel, doc) of all media on jriver in jriver.

Title: Re: A list of all media in JRiver
Post by: JimH on November 24, 2022, 08:14:45 pm

Select what you want, as if in a spreadsheet, copy it, then paste into a spreadsheet program.

Title: Re: A list of all media in JRiver
Post by: drhogan on January 24, 2023, 11:06:25 am

Need a list of all albums with artist and filepath.  I copy (Ctrl-A, Ctrl-C) the view in Audio:Albums with selected fields and Paste (Ctrl-V) in Excel. 
The data is pasted as a whole in a single column (see attached screenshot). 
What am I doing wrong?  Alternatives?

Title: Re: A list of all media in JRiver
Post by: markf2748 on January 25, 2023, 12:09:25 pm

Jim's suggestion always works very nicely for me (Office Pro Plus 2013).
My guess is that you have an Excel paste issue.  Consider the following in Excel:

Single click left mouse button on a single cell to highlight it, then paste.
Try Paste > Paste Special > Text (but should not be necessary).

Do not double click on the target cell in Excel before the paste.
Do not put cursor in the cell data entry window (top of spreadsheet) before pasting.
Check your selections in Excel Options > Advanced > Cut, copy, paste

You can convert your existing single column paste into multiple columns with Excel's Data Tools > Text to Columns.  Normally this should not be necessary, but it might help confirm validity of MC's copy and delimiter selection.

Title: Re: A list of all media in JRiver
Post by: drhogan on January 25, 2023, 12:59:29 pm

Pretty familiar with Excel - user and programmer since early 1980's when it was known as Multiplan.
Ended up copying one field at a time - a pain but got me there.
This could be an issue with Office365 - which our company switched to in the last year.  I do know that pasting tables from PDFs are not consistent now.
Going to have to find one of my old laptops with Office 2010 and see if that works.

Title: Re: A list of all media in JRiver
Post by: JimH on January 26, 2023, 01:28:59 am

It's been a while since I've used a spreadsheet much, but I'm pretty sure there's a way. 

Are there multiple ways to paste?

Or can you convert the single column (after pasting) to multiple columns?  I believe that works and that you can set the delimiter (space, for example).

Title: Re: A list of all media in JRiver
Post by: EnglishTiger on January 26, 2023, 06:11:55 am

Another way of doing it is to set up a smartlist that displays the columns you want and then in the Tree Right Click on the Smartlist Name, select "Export Playlist" and on the form that appears tell it to Export the Playlist as a csv file.

Title: Re: A list of all media in JRiver
Post by: drhogan on January 29, 2023, 01:53:32 pm

Is there a way to set up a smartlist so that the album names are shown only once (instead of for each track on the album)?