INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: A list of all media in JRiver  (Read 1354 times)

sgfrisbee

  • Recent member
  • *
  • Posts: 11
A list of all media in JRiver
« 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.
Logged

JimH

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 72443
  • Where did I put my teeth?
Re: A list of all media in JRiver
« Reply #1 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.
Logged

drhogan

  • Recent member
  • *
  • Posts: 22
Re: A list of all media in JRiver
« Reply #2 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?
Logged
David Hogan

markf2748

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 823
Re: A list of all media in JRiver
« Reply #3 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.

Logged

drhogan

  • Recent member
  • *
  • Posts: 22
Re: A list of all media in JRiver
« Reply #4 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.
Logged
David Hogan

JimH

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 72443
  • Where did I put my teeth?
Re: A list of all media in JRiver
« Reply #5 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).
Logged

EnglishTiger

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 1088
Re: A list of all media in JRiver
« Reply #6 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.
Logged
Apple Mac Mini Desktop Computer with M4 Pro chip with 12 core CPU and 16 core GPU: 24GB Unified Memory, 512GB SSD Storage, Gigabit Ethernet, 3 Thunderbolt5 + 2USBC ports.

drhogan

  • Recent member
  • *
  • Posts: 22
Re: A list of all media in JRiver
« Reply #7 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)?
Logged
David Hogan
Pages: [1]   Go Up