Missing Lyrics 1.3 - Update 11/01/2010

[Bex]

This script is currently only working with MM2 (as the title says).

[spacefish]

Just what I was looking for! Subscribing to be notified when an update for 3 is ready. I need this script!

[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

[nohitter151]

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 )

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 .

[trixmoto]

It's on my list!

[drjboulder]

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 )

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?

[nohitter151]

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 )

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 .

[spacefish]

You can also do this with My Custom Nodes and if you want, that can be the only custom node you have.

Code: Select all

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

[trixmoto]

New version (1.2) is now available to download from my website. It is now compatible with MM3.

[nohitter151]

Sweet! I've been waiting for this one, many thanks.

[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.

[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!

[nohitter151]

Thanks Bex! Unfortunately after making the change I'm now getting:

[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

[nohitter151]

Excellent, thanks much Bex (and of course Trixmoto as well!)