Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[dreandre]

Writing expressions in the Rename, Move & Copy Files

The Problem:

I would like to move animated TV Shows and Animated Movies into the same folder called "Animation".

TV Shows should be named "S01E01 [Name]"
Movies should be named "[Name] ([Year])"


Question:

How can I write and IF statement that will check [Grouping] for Animation AND [Media Sub Type] for "Movie" or "TV Show"?

In Excel syntax, I would write:  IF(AND([Grouping]=Animation,[Media Sub Type]=Movie),Value if True,Value if False)

Is there a similar way to write the IF statement to check two criteria to determine the True Value, else False?

Thanks All!!

[dreandre]

I think I may have solved it.

It seems the solution was to write part of the rule in the Directories section, and the other part of the rule in the Filename Section.  Here's what I wrote that seems to work:

In the Directories Section I wrote this rule:

Ifelse(isequal([grouping],Animation,1),Animation\,isequal([grouping],Extras,1),Media Extras\,isequal([grouping],Documentary,1),Documentary\)

**** I didn't mention that I was also moving extras and documentaries as well.  ****

In the Filename Section I wrote this rule:

if(isequal([media sub type],TV Show),\[Series]\[Season]\S[Season]E[Episode] [Name],Filefolder()\[Name] ([year]))

****This rule has an error in it that I posted in a different thread.  If I can solve this error then I will be home free! ****

Let me know if there is anything I could have done differently or better.  Thanks All!

[dreandre]

Also just found this link:

https://wiki.jriver.com/index.php/Boolean_Operations

[RoderickGI]

Ifelse(isequal([grouping],Animation,1),Animation\,isequal([grouping],Extras,1),Media Extras\,isequal([grouping],Documentary,1),Documentary\)

"\Media Extras\ is not supported by the MC "Extras" functionality, if that is what you are trying to use. See below for a summary of that. If oyu are just putting a bunch of extra stuff in a separate sub-directory, fair enough.

****This rule has an error in it that I posted in a different thread.  If I can solve this error then I will be home free! ****

Done.

View Extras functionality

22.0.21 (8/24/2016)
4. NEW: When files have sidecar images, PDF files, or documents, they'll be shown in a "View Extras" submenu to open each individual file.
22.0.22 (8/29/2016)
2. Changed: Add text files to the list of "View Extras" files.
22.0.23 (8/31/2016)
1. NEW: Added HTM and HTML to the list of sidecars shown by the new View Extras menu.
3. Fixed: The View Extras menu in images would show all the images in the same folder.
5. Changed: Sidecar searching for the "View Extras" menu also looks in subfolders called "Extras", "Scans", "PDF", "PDFs", "Booklet", "Art", "Artwork", "Cover", "Covers", "Cover Scan", or "Cover Scans".
22.0.24 (9/2/2016)
2. Changed: When viewing a sidecar image with the View Extras menu, it will add all the images it found to the current playlist so you can switch between them like normal image playback.
3. Changed: Added the extension to the list of View Extras menu choices.
22.0.27 (9/19/2016)
1. NEW: Added the option "View Cover Art" to the View Extras menu.
22.0.30 (9/22/2016)
1. Changed: Added the subfolder "Album Artworks" to the View Extras search.
22.0.96 (4/3/2017)
1. Changed: Added RTF to the list of extensions the View Extras menu searches for.
22.0.98 (4/10/2017)
3. Fixed: RTF files in the View Extras menu weren't opening.
23.0.2 (6/9/2017)
1. NEW: The View extras menu looks for a zip file named "Artwork.zip" and shows the artwork in the zip file if it exists.


File Types Supported:
PDF, Documents (for example: doc, docx, docm, odt), Text, HTM, HTML, RTF, "Artwork.zip", jpg, png
File types jpg and png are viewed within MC. All other files types are opened with the default Windows application, as defined by File Type Associations.
Note: Artwork.zip is only opened with the contents presented for viewing if the zip file is in the same directory as the audio files, and won't be opened if it is in one of the Extras sub-directories.
Not supported: mht, wps, xml, xps, bmp, tif, gif,

Folders Searched:
 "Extras", "Scans", "PDF", "PDFs", "Booklet", "Art", "Artwork", "Cover", "Covers", "Cover Scan",  "Cover Scans", "Album Artworks"
Note: These folders are not moved by the RM&CF function, regardless of the "Move all non-imported files in folder with selected media files". flag.

Special Function:
"View Cover Art", which views the Cover Art image MC knows about, in the same way that "right-click > Cover Art > View (first file)" does.