Re: Auto organize
Posted: Wed Aug 14, 2019 2:03 pm
I'm just fixing typos
I’m pretty good with Excel but your method of “IF statements” is breaking my brain. I’m sure I’m the problem. I want to auto organize as follows.
First Directory:
C:\<Type>\
Second Directory:
If there is an artist I want to use the first letter of the artist field, moving the prefix.
If the artist field is empty, I want to use the first letter of the album artist field, moving the prefix.
If the album artist field is empty, I want the folder “Unknown” to be used.
Third Directory:
If there is an artist I want to use artist field, moving the prefix.
If the artist field is empty, I want to use album artist field, moving the prefix.
If the album artist field is empty, I want the folder “Unknown” to be used.
Forth Directory:
I want to use the Album field, removing the prefix.
If the Album field is blank, I want the folder “Unknown” to be used.
File name:
File Name:
If the Artist, Album Artist, Album and Title fields are all blank I want the file moved to C:\<Type>\Unknown\Unknown\Unknown\ with no change to the file name.
If there is a Disc number in the Disc# filed I want “Disc “<Disc#>” - “, Followed by the <Track#:2> if the track number is one or two digits or <Track:3> if there are 3 digits” – “,Followed by the <Title >.
MASSIVE Bonus:
If the original file name starts with a {four digit year}_ or a {group of up to three letters} followed by a {two digit year}_
C:\<Type>\Year\ no changes to the file name.
I know this could cause a problem it the original file name is something like:
1999_Prince_02_Little Red Corvette.mp3
But it’s better to put 1999_Prince Lets go Crazy.mp3 type files in the C:\<Type>\Year\ folder than to move it to C:\Music\P\Prince\1999\02 - Little Red Corvette.
If this massive bonus can’t be done it would be best if the files didn’t move at all.
Yes, I've tried off and on for years to get this and avoid file names too long, but it has escaped me to the point I willing to get help.
Signed:
A loyal, lifetime updates, MediaMonkey user of 10 or 11 years.
Doug
I’m pretty good with Excel but your method of “IF statements” is breaking my brain. I’m sure I’m the problem. I want to auto organize as follows.
First Directory:
C:\<Type>\
Second Directory:
If there is an artist I want to use the first letter of the artist field, moving the prefix.
If the artist field is empty, I want to use the first letter of the album artist field, moving the prefix.
If the album artist field is empty, I want the folder “Unknown” to be used.
Third Directory:
If there is an artist I want to use artist field, moving the prefix.
If the artist field is empty, I want to use album artist field, moving the prefix.
If the album artist field is empty, I want the folder “Unknown” to be used.
Forth Directory:
I want to use the Album field, removing the prefix.
If the Album field is blank, I want the folder “Unknown” to be used.
File name:
File Name:
If the Artist, Album Artist, Album and Title fields are all blank I want the file moved to C:\<Type>\Unknown\Unknown\Unknown\ with no change to the file name.
If there is a Disc number in the Disc# filed I want “Disc “<Disc#>” - “, Followed by the <Track#:2> if the track number is one or two digits or <Track:3> if there are 3 digits” – “,Followed by the <Title >.
MASSIVE Bonus:
If the original file name starts with a {four digit year}_ or a {group of up to three letters} followed by a {two digit year}_
C:\<Type>\Year\ no changes to the file name.
I know this could cause a problem it the original file name is something like:
1999_Prince_02_Little Red Corvette.mp3
But it’s better to put 1999_Prince Lets go Crazy.mp3 type files in the C:\<Type>\Year\ folder than to move it to C:\Music\P\Prince\1999\02 - Little Red Corvette.
If this massive bonus can’t be done it would be best if the files didn’t move at all.
Yes, I've tried off and on for years to get this and avoid file names too long, but it has escaped me to the point I willing to get help.
Signed:
A loyal, lifetime updates, MediaMonkey user of 10 or 11 years.
Doug