MediaMonkey forum

Bex wrote:
This one sets DateAdded to the first time Played, for all tracks that have plays before DateAdded:

Code: Select all

UPDATE Songs SET DateAdded=(SELECT MIN(PlayDate) FROM Played WHERE Songs.ID=Played.IDSong GROUP BY IDSong)
WHERE Songs.ID IN (SELECT Songs.ID FROM Songs, Played WHERE Songs.ID=Played.IDSong AND PlayDate<DateAdded)

Worked perfectly

Bex wrote:This one removes all history plays before DateAdded, for all tracks that have plays before DateAdded: (The Playcount needs to be manual adjusted afterwards.)

Code: Select all

DELETE FROM Played WHERE IDPlayed IN (SELECT IDPlayed FROM Songs, Played WHERE Songs.ID=Played.IDSong AND PlayDate<DateAdded)

Let me know if they work properly!

I didn't try this one because I didn't want to remove any histories.

Thanks once again.

Great!

I'm pretty positive this isn't your fault, but I thought I would report it regardless:
I've gotten the "Cannot open clipboard" message from MM a lot, but never in regards to a script. Found it strange. Occurred while trying to open one of the nodes (I think it may have been the Tracks With node)

I haven'r seen that one before and I don't think I can fix it, even if the script is causing it...

Yeah. MM itself has been throwing a "Cannot open clipboard" message randomly for some time/releases, so I imagine its the root of the problem. However it was an error thrown during script usage, so I figured I would report it anyway. Well, I'm actually not sure if it's MM that is the issue, or something to do with my computer as I have had some trouble with the clipboard with one of my other programs (however MM is always running so if it's doing something, it might have caused the issue with the other program)

It would be interesting if you were able to track that down. I've never seen that error either.

Hi, not sure if this has been covered before, but I can't get your great program to work under Windows 7 (won't install). Had no problem under XP. Any ideas?

pachubi wrote:Hi, not sure if this has been covered before, but I can't get your great program to work under Windows 7 (won't install). Had no problem under XP. Any ideas?

Right at the bottom of the first post.

Hi, Bex. I've been away from the forum for ages; trust you're keeping well.

I've come back to MM4. Collections are fantastic.

Am I right to think that some work needs to be done on your awesome script to make it fully compatible with MM4?

If I choose a "filter" it doesn't seem to limit the created node to that "filter" (i.e. collection).

Which nodes are you having trouble with because the script is working with my filters/collections??

Thanks, Nyn. I hope you're well too.

Well, I'm only just familiarizing myself with Collections and "Type" but...

I opened up the "Albums with..." node under the Music node. In there I saw that there were lots of videos. I don't want to worry about their tagging inconsistencies just yet so...

I edited the Music Collection. By default, it consisted of "Type = Music or Music Video". I changed it to "Type = Music" only.

Sure enough, the videos don't show up under the Music node now, I use the separate Music Video collection/node for that.

But under the Tagging Inconsistencies "Albums with..." node, when I look at multiple years, there are videos.

In TI General Settings I have set the TI Default Filter as Music and all the other fields are set to use TI's default filter.

That's it really. Hope it makes sense.

Yes that makes perfect sense, now let me ask you: In the TI General settings option sheet do you see the music filter listed on the separate nodes, such as Albums With, Album Art etc....? Also, if you go into the Albums With Option Sheet does it show the music only collection on the filter for all the various nodes?

Nyn

nynaevelan wrote:Yes that makes perfect sense, now let me ask you: In the TI General settings option sheet do you see the music filter listed on the separate nodes, such as Albums With, Album Art etc....? Also, if you go into the Albums With Option Sheet does it show the music only collection on the filter for all the various nodes?

Nyn

Thanks so much. Embarrassingly I hadn't clicked on the actual Albums Nodes Settings button. It works perfectly now.

It's a fantastic script isn't it, Nyn.

MM3 monkey wrote: It's a fantastic script isn't it, Nyn.

It absolutely is, it keeps my library up to date with correct tags.

Thank you both!

I'll try to update this script so it's better suited for MM4 when I get a chance to do so in my busy schedule...