Page 3 of 6

Posted: Fri Sep 07, 2007 1:37 am
by Bex
This script is currently only working with MM2 (as the title says).

Posted: Fri Jan 18, 2008 4:18 pm
by spacefish
Just what I was looking for! Subscribing to be notified when an update for 3 is ready. I need this script! :)

Posted: Fri Feb 29, 2008 4:17 pm
by das Monkey
I don't know if this is something people still use, but I just installed it a few minutes ago and got the same error in MM3 others were getting. A quick glance at the database reveals they moved the lyrics to a more logical location. Change the sql line to this, and it should work:

Code: Select all

  Dim sql : sql = "WHERE Songs.Lyrics = ''"
Or if you want to be more selective, something like this:

Code: Select all

  Dim sql : sql = "WHERE Songs.Lyrics = '' AND Songs.Genre NOT IN ('Classical', 'Score', 'Instrumental', 'Podcast')"
I don't know how this thing is indexed, so there may be a more optimized solution, but it's fast enough for my purposes.

das

Posted: Fri Mar 07, 2008 12:28 am
by nohitter151
das Monkey wrote:I don't know if this is something people still use, but I just installed it a few minutes ago and got the same error in MM3 others were getting. A quick glance at the database reveals they moved the lyrics to a more logical location. Change the sql line to this, and it should work...
This is a script I definitely miss! (Trixmoto made this way back when I first started using MM, at my request :oops: :wink: )

I tried your modification das, but I'm still getting lots of wacky errors. Trixmoto, I know you're busy - I just wanted to remind you that this script is still wanted :) .

Posted: Fri Mar 07, 2008 4:25 am
by trixmoto
It's on my list! :)

Posted: Fri Mar 07, 2008 4:51 am
by drjboulder
nohitter151 wrote:
das Monkey wrote:I don't know if this is something people still use, but I just installed it a few minutes ago and got the same error in MM3 others were getting. A quick glance at the database reveals they moved the lyrics to a more logical location. Change the sql line to this, and it should work...
This is a script I definitely miss! (Trixmoto made this way back when I first started using MM, at my request :oops: :wink: )

I tried your modification das, but I'm still getting lots of wacky errors. Trixmoto, I know you're busy - I just wanted to remind you that this script is still wanted :) .
I Believe that I used to use this script w/MM2....

Maybe I am missing something, but is there a reason to update it considering the ability's of the newest MagicNodes?
I use this node and it appears under "Files To Edit":

Code: Select all

<Group|Name:Problematic tracks|Show tracks:No|Child of:FilesToEdit|Position:Last child>\Tracks without lyrics|Filter:<Lyrics> = ''\<Title>
Or maybe I am missing some other usefulness of this script?

Posted: Fri Mar 07, 2008 8:03 am
by nohitter151
drjboulder wrote:
nohitter151 wrote:
das Monkey wrote:I don't know if this is something people still use, but I just installed it a few minutes ago and got the same error in MM3 others were getting. A quick glance at the database reveals they moved the lyrics to a more logical location. Change the sql line to this, and it should work...
This is a script I definitely miss! (Trixmoto made this way back when I first started using MM, at my request :oops: :wink: )

I tried your modification das, but I'm still getting lots of wacky errors. Trixmoto, I know you're busy - I just wanted to remind you that this script is still wanted :) .
I Believe that I used to use this script w/MM2....

Maybe I am missing something, but is there a reason to update it considering the ability's of the newest MagicNodes?
I use this node and it appears under "Files To Edit":

Code: Select all

<Group|Name:Problematic tracks|Show tracks:No|Child of:FilesToEdit|Position:Last child>\Tracks without lyrics|Filter:<Lyrics> = ''\<Title>
Or maybe I am missing some other usefulness of this script?
Well I'd really rather just have the Lyrics node than all of MagicNodes (call me old fashioned, its just a script that I've never used). I would assume there are other users like me, but I guess I could be the only crazy MM user out here :lol: .

Posted: Fri Mar 07, 2008 9:42 am
by spacefish
You can also do this with My Custom Nodes and if you want, that can be the only custom node you have. :P

Code: Select all

[No Lyrics]
icon=Title
sortLike=Artist
easyCaption=BaseCaptionAndTrackCount
hideIfEmpty=1
refresh=1
trackCriteria="(Lyrics = '')"
parent="Files to Edit"

Posted: Wed Mar 19, 2008 4:37 pm
by trixmoto
New version (1.2) is now available to download from my website. It is now compatible with MM3. :)

Posted: Wed Mar 19, 2008 5:18 pm
by nohitter151
Sweet! :D I've been waiting for this one, many thanks.

Re: Missing Lyrics 1.2 [MM2+3]

Posted: Mon Oct 20, 2008 8:27 am
by nohitter151
Trix, I know you're busy but I wanted to express a small wish for this script which I use quite frequently - I'd love if the Missing Lyrics node only looked for tracks with missing lyrics in the active filter. Right now it finds all lyric-less tracks but includes those in other filters, like Podcasts.

Thanks for an already great tool. :)

Re: Missing Lyrics 1.2 [MM2+3]

Posted: Mon Oct 20, 2008 2:54 pm
by Bex
Replace line 42 from:

Code: Select all

Dim sql : sql = "WHERE Songs.Lyrics = ''"
To:

Code: Select all

Dim sql : sql = "WHERE Songs.Lyrics = '' AND " & SDB.ActiveFilterQuery
And it should work! :)

Re: Missing Lyrics 1.2 [MM2+3]

Posted: Mon Oct 20, 2008 6:46 pm
by nohitter151
Thanks Bex! Unfortunately after making the change I'm now getting:
Image

Re: Missing Lyrics 1.2 [MM2+3]

Posted: Mon Oct 20, 2008 9:08 pm
by Bex
I didn't get much right there, did I?
Replace the last Sub with this one:

Code: Select all

   Sub ShowUnknownLite(node)
      Dim FilterSQL
      If Not SDB.Database.ActiveFilterQuery="" Then FilterSQL = " AND " & SDB.Database.ActiveFilterQuery
      Dim sql : sql = "WHERE Songs.Lyrics = ''" & FilterSQL
      SDB.MainTracksWindow.AddTracksFromQuery(sql)
      SDB.MainTracksWindow.FinishAdding
    End Sub

Re: Missing Lyrics 1.2 [MM2+3]

Posted: Mon Oct 20, 2008 9:17 pm
by nohitter151
Excellent, thanks much Bex (and of course Trixmoto as well!) :)