INTERACT FORUM

More => Old Versions => JRiver Media Center 26 for Mac => Topic started by: akira54 on April 11, 2020, 09:57:31 am

Title: Export sorted list of films
Post by: akira54 on April 11, 2020, 09:57:31 am: Can anyone explain if and how I can export a sorted list of films?
Title: Re: Export sorted list of films
Post by: RoderickGI on April 11, 2020, 09:01:21 pm: Create a View of all the media files you want to include, with all the columns of data you want to include.

Select all.
Copy.
Go to your favourite external application. Excel works well. Paste.

Done.
Title: Re: Export sorted list of films
Post by: blgentry on April 12, 2020, 11:45:19 am: I don't think I knew that this worked with the Mac version of MC. Just tested it using Google Sheets as the receiver. Worked like a champ. Neat!

Brian.
Title: Re: Export sorted list of films
Post by: akira54 on April 12, 2020, 02:29:44 pm: Sometimes the simplest answers are the easiest ... and I was searching for an option to do this within the program!
Title: Re: Export sorted list of films
Post by: wer on April 12, 2020, 02:49:01 pm: You can also export your view, or a playlist, as a .CSV file. (File->Export Playlist)

This can be helpful because when you import the CSV into Excel, you can actually define the data type for each column. Sometimes Excel doesn't make the best automatic decisions with cut and paste.
Title: Re: Export sorted list of films
Post by: RoderickGI on April 12, 2020, 05:36:54 pm: Excellent point Will. I always just fix the spreadsheet formatting after pasting. It could be more accurate during the CSV open process. Although when I opened the CSV file in Excel 2010 just now, it didn't go through the data mapping process. Hmmm. Usually, it does.

Anyway, I didn't know you could use "File->Export Playlist" against a View, but that does work. However it doesn't respect the columns shown in the View, and just exports all Library fields for each selected file, in some predetermined sequence.

The Copy-Paste process only carries across the fields in the View and maintains the sequence.
Title: Re: Export sorted list of films
Post by: wer on April 12, 2020, 05:43:31 pm: Quote from: RoderickGI on April 12, 2020, 05:36:54 pm
Anyway, I didn't know you could use "File->Export Playlist" against a View, but that does work. However it doesn't respect the columns shown in the View, and just exports all Library fields for each selected file, in some predetermined sequence.

Actually it does Rod. ;D You just have to select Text file (CSV delimited) and then also check "Only Visible Fields" under included fields.
Title: Re: Export sorted list of films
Post by: RoderickGI on April 12, 2020, 08:16:58 pm: Ah yes. I missed that. The option is greyed out for m3u playlists and I didn't update the selection.

Cool. 8)