Un Auto Organised 3.0 [MM2+3] - Updated 30/10/2009

trixmoto · Post by **trixmoto** » Thu Dec 14, 2006 5:53 am

It's a nice idea and I'll certainly put it on the list. Not sure how to add tracks to the list, but I'll mull it over and see what I come up with!

toxboy · Post by **toxboy** » Thu Dec 21, 2006 10:35 am

Trixmoto,

Thanks for the wonderful script. This is great!

This new version is very fast too! The scripters for this program are wonderful!

I also use your backup script. It saved my database on one occassion, after I did something pretty stupid. Thanks!

One question about thw Un Autoorganized script. Is there an easy change I can make to the current copy to ignore tags ending in those special characters, such as a period (.) I know you plan to address this in a later version, but just wondering.

Thanks for the great work.

Greg (toxboy)
Recent MM gold member.

trixmoto · Post by **trixmoto** » Fri Dec 22, 2006 4:20 am

Hopefully I will be releasing that fix later today!

trixmoto · Post by **trixmoto** » Fri Dec 22, 2006 5:01 am

New version (2.1) is now available from my website. Changes include...

- Fixed BPM appearing as "0-1" when blank (should be 000)
- Fixed bitrate appearing as 6 digits by default (should be 3)
- Fixed trailing characters in folders not removed
- Added exclusion list to stop tracks appearing in this node

At the moment a red cross is added to the standard toolbar. Clicking this will add all the selected tracks to the exclusion list (so they will not appear in the UnAutoOrganised list even if they are not organised correctly). The script is designed to that in the next version of MM, when the SendTo list bug has been fixed, this icon will disappear and reappear in the SendTo menus.

Currently the only way to remove tracks from the list is to manually edit the list. It is stored in a the file "UnAutoOrganised.vbs.dat". Once the SendTo menus are fixed I will work on a proper interface for editing the list, but this should do the job for now!

toxboy · Post by **toxboy** » Fri Dec 22, 2006 11:45 am

Steegy,

Thanks a bunch. I love this script! The change to the trailing special character works great. Can't comment on exclusion list function , I have not used it yet, but I will try it out later.

Greg, (toxboy)

Mizery_Made · Post by **Mizery_Made** » Fri Dec 22, 2006 3:03 pm

trixmoto wrote:- Fixed BPM appearing as "0-1" when blank (should be 000)
- Fixed bitrate appearing as 6 digits by default (should be 3)
- Fixed trailing characters in folders not removed
- Added exclusion list to stop tracks appearing in this node

BPM, The ending Period & the Exclusion List are all working fine from what I can tell, though, Bitrates are still being converted to 6 digits rather then the three.

Overall, impressive update, definitely didn't expect the implementation of an Exclusion List so quickly. *Thumbs Up* Get the Bitrate issue solved once again and the script should be solid.

trixmoto · Post by **trixmoto** » Sat Dec 23, 2006 7:39 am

Bitrate is an exception because it's the only numeric field that actually rounds the value. I'll try to make sure that's working for the next version.

Mizery_Made · Post by **Mizery_Made** » Sat Jan 06, 2007 12:32 am

Was just thinking a minute ago of a way you could expand the usage of the Exception list. You see, I often rip my CD's to a "Quarantine Folder," I normally tag everything pretty quickly and get it organized like the rest of my library, but there are some occasions where I will rip something, and let it sit there for a while before I mess with it.

Maybe a way to exclude a complete path, as it's a "Quarantine Folder," I already know it's not Organized, I don't really need it to show up in the node. (I mainly use your script to catch the files where I alter the titles, or other fields I use to organize, but forget to organize them after.) Thoughts?

Just tossing ideas out there again.

trixmoto · Post by **trixmoto** » Sun Jan 07, 2007 12:25 pm

Nice idea, I've added it to my to do list.

trixmoto · Post by **trixmoto** » Tue Jan 30, 2007 7:34 am

New version (2.2) is now available to download from my website. Changes include...

- Fixed bitrate appearing as 6 digits by default (should be 3)
- Added option to exclude folders

If you select multiple songs in the same folder and click the exclude button then you will be asked if you wish to exclude the folder or the files individually.

Mizery_Made · Post by **Mizery_Made** » Tue Jan 30, 2007 4:26 pm

trixmoto wrote:- Fixed bitrate appearing as 6 digits by default (should be 3)
- Added option to exclude folders

Just DLed & Installed a bit ago and gave it a run through. The Bitrates appear to finally be fixed, tried it with both VBRs & CBRs and both were processed correctly.

The Folder Exclusion appears to work aswell, though it's a little more strict then I thought it would be. It appears that it only processes the files in THAT folder that you've added, which makes sense, though it would be nice if it processed sub folders and such aswell, so that I could add

Code: Select all

C:\Documents and Settings\*Name*\My Documents\My Music\Quarantine

for instance, and it would exclude any loose files floating around that specific folder at that time, but would also exclude a folder such as:

Code: Select all

C:\Documents and Settings\*Name*\My Documents\My Music\Quarantine\X-Clan - Return From Mecca

for instance, as it is contained inside of that excluded folder, you know? Just a thought. I'm still amazed at how far you have taken this script from the days of it's conception, and at a fairly fast & constant pace aswell. I applaud you.

trixmoto · Post by **trixmoto** » Wed Jan 31, 2007 4:15 am

Thank you for your kind words. I'm glad you find this script useful.

I will exclude subfolders as well in the next version. I'm glad bitrate is finally sorted!!

SHR · Post by **SHR** » Thu Feb 01, 2007 6:17 pm

Today I found your script and thought, that I can use it to find "incorrect" filenames. But then I got an errormessage on the first run.

As I'm not an Script-Newbie, I found out, that there was a problem with URL's (radio-streams) in my library. As a workaround I used the following changes to your code to exclude paths starting with "http:\\"

Code: Select all

  Dim exclude : exclude = "SongPath NOT LIKE 'http://%'"
  Dim sqlexclude : sqlexclude = ""
...  
  If exclude <> "" Then
     sqlexclude = " WHERE " & exclude
  End If
  Dim iter : Set iter = SDB.Database.OpenSQL("SELECT Count(1) AS SongCount FROM Songs" & sqlexclude)
...
  If exclude <> "" Then
     sqlexclude = "AND " & exclude
  End If
  Set iter = SDB.Database.QuerySongs(sqlexclude)

Maybe there is a better way to do this within other parts of the script.
Now the script runs fine and I got a complete resultnode.

But as I examine the result, I noticed, that there are a lot of songs, which I don't want to get listed there. The reason is, that these songs are on external medias (DVD, CD, etc.). So as I can't change them, I don't want to see them.

Or they are on devices (MP3-Player), where I need "special" naming.

Currently you support file- and/or folder-exclusions. So I extended the according function:

Code: Select all

Function NotInList(key,lst)
  Dim h : h = 0
  NotInList = False
  For h = LBound(lst) To UBound(lst)
    If Right(lst(h),1) = "\" Then
      If Left(key,InStrRev(key,"\")) = lst(h) Then

        Exit Function
      End If
      
    Else
      If Right(lst(h),1) = ":" Then
        If Left(key,InStrRev(key,":")) = lst(h) Then
           Exit Function
        End If
      Else
        If key = lst(h) Then
           Exit Function
        End If
      End If
    End If
  Next
  NotInList = True
End Function

BTW External media can now be excluded via your dat-file using ?: for the start of the path.
Again. Maybe there are better ways for you to achive this. But with these additions the script works nearly perfect for me.
On last suggestion is to add an option to ignore cases. As I think that this would be done easily, I will try to implement this.
I hope, that it is ok for you, that I modify the scripts according to my needs and of course my possibilities.

Thanks for coding this and so many other useful scripts.

trixmoto · Post by **trixmoto** » Fri Feb 02, 2007 4:28 am

Of course it is ok for you to modify this script for your own needs. I'll include the fix for streams in the next version.

In the next version subfolders will be excluded as well so you'll be able to put "?:\" in the .dat file to exclude all tracks on a certain drive.

MoDementia · Post by **MoDementia** » Tue Feb 13, 2007 7:37 pm

OMG Trixmoto,

I can't believe you actually spent the time to fix multiple $ifs.

Yes the original code was limited and I would have had to rewrite it to handle the complexity you have included now.

I hope I get the chance to check it out and see how you managed it

Thanks a heap.