Search found 92 matches

by mhendu
Sun Feb 10, 2019 11:42 am
Forum: MediaMonkey 4 Addons developer forum
Topic: SQL / scripting help - search by Artist ID
Replies: 1
Views: 213

Re: SQL / scripting help - search by Artist ID

Would love to know how to do this for this and future scripts, but for now I came up with what I think is a workable solution: Dim ArtistNameTemp ArtistNameTemp = itm.ArtistName ArtistNameTemp = Replace(ArtistNameTemp,"'","''") SQL = "SELECT Genre, Count(Genre) AS SortField FROM Songs WHERE Artist =...
by mhendu
Sun Feb 10, 2019 11:07 am
Forum: MediaMonkey 4 Addons developer forum
Topic: SQL / scripting help - search by Artist ID
Replies: 1
Views: 213

SQL / scripting help - search by Artist ID

I'm trying to write a script that will either look up genre from Musicbrainz or find the most common genre from the same artist in the existing database. A few artists have special characters (') so the script errors out when searching by itm.ArtistName, otherwise this query works: "SELECT Genre, Co...
by mhendu
Tue Sep 11, 2018 1:46 am
Forum: Alpha testing, bugs, and feature requests (MMS)
Topic: Database setup
Replies: 5
Views: 1612

Re: Database setup

Sounds good in theory, but I don't see a way to actually have MMS read my MM4 or MM5 database. It looks like it sets up an entirely new database, so I'd have to add my music folders to MMS and scan them in. Is there a way to configure MMS to read the MM5 database, including playlists? Also unclear t...
by mhendu
Thu Sep 06, 2018 8:22 am
Forum: Need Help with Addons?
Topic: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]
Replies: 2405
Views: 598022

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]

ZvezdanD wrote:
Wed Sep 05, 2018 12:56 am
mhendu wrote:
Tue Sep 04, 2018 10:38 pm
Here's a screenshot of the settings
I told you, you should get opened the new Magic Nodes SQL Editor dialog box, not Edit Magic Node.
Got it - working now, thanks!
by mhendu
Tue Sep 04, 2018 10:38 pm
Forum: Need Help with Addons?
Topic: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]
Replies: 2405
Views: 598022

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]

It works fine for me. Tried several times, no errors. Check if you copied/pasted the correct string and confirm editing of SQL query with the OK button. Then post the screenshot of the error message box if it says anything different than "The mask defining this Magic Node produced an error." Here's...
by mhendu
Mon Sep 03, 2018 6:58 pm
Forum: Need Help with Addons?
Topic: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]
Replies: 2405
Views: 598022

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]

I changed the settings in Magic Nodes and tried to use the above query but this doesn't work for some reason (it produces an error). Where did you try to use the above query, was it in the mentioned Magic Nodes SQL Editor dialog? Did you replace the string that is already displayed in the text box ...
by mhendu
Sun Sep 02, 2018 12:56 pm
Forum: Need Help with Addons?
Topic: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]
Replies: 2405
Views: 598022

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]

INNER JOIN (SELECT Custom3 || IDAlbum AS SortField1, Random() AS RandomField1 FROM Songs GROUP BY SortField1) ON Custom3 || IDAlbum = SortField1 WHERE Songs.Custom3 || IDAlbum IN (SELECT Custom3 || IDAlbum AS CLASSWORK FROM Songs GROUP BY CLASSWORK HAVING Avg(Rating) > 80 AND Custom3 <> '' AND Grou...
by mhendu
Fri Aug 31, 2018 4:29 pm
Forum: Need Help with Addons?
Topic: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]
Replies: 2405
Views: 598022

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]

I cannot see from your screenshot, but I suppose that all your albums from the same box set have the same Custom3 field, right? Thanks, but not correct. Take, for example, the album Songs from Our Ancestors (from which one work appears in my file list in the screenshot). Here's the Musicbrainz link...
by mhendu
Fri Aug 31, 2018 12:19 pm
Forum: Need Help with Addons?
Topic: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]
Replies: 2405
Views: 598022

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]

It would be helpful if you post a screenshot of the filelist with the files sorted using your second mask and you should write several files from the screenshot in the order that you want to get. I am not too much versed with the classical music, so I would like to see Album, Custom3 and Path of th...
by mhendu
Thu Aug 30, 2018 8:06 pm
Forum: Need Help with Addons?
Topic: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]
Replies: 2405
Views: 598022

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]

How about you post the complete mask that you tried which "doesn't do any sorting"? I'd describe my SQL knowledge as basic at best - I can mimic fairly well but I'm not really sure about the syntax, but thanks anyway. :) Without sorting, here's the mask: >4 star Classical works|Child of:Playlists|P...
by mhendu
Wed Aug 29, 2018 7:57 pm
Forum: Need Help with Addons?
Topic: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]
Replies: 2405
Views: 598022

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]

Trying to create a way to group by the parent work of classical works (e.g., Beethoven's 9th symphony) and then randomly order by the parent work, but deduped by album so if I have two versions of the same work they don't end up next to each other. As a start, I got this query to work (the parent wo...
by mhendu
Thu Aug 16, 2018 11:42 am
Forum: Alpha testing, bugs, and feature requests (MMS)
Topic: Database setup
Replies: 5
Views: 1612

Database setup

I have a MM4 install on my Windows 10 PC and installed this but it didn't read my database. Do I have to upgrade to MM5 for this to work, or can it be configured to read from the MM4 database? Also, looks like it's asking for the folders where the music is located, which seems like an odd setting if...
by mhendu
Sat Mar 31, 2018 9:53 am
Forum: Need Help with Addons?
Topic: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]
Replies: 2405
Views: 598022

Re: Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2

I am using the Custom4 field in MediaMonkey to store a song's Work ID from Musicbrainz, and the Custom5 field to store the AcoustID. I'm trying to create a playlist of cover versions of songs that I've rated 5 stars, but where the 5 star song is not a classical work or a jazz recording (I use the Gr...
by mhendu
Sun Nov 05, 2017 4:31 pm
Forum: Need Help with Addons?
Topic: Genre Finder 5.0 - Updated 05/08/2012
Replies: 971
Views: 468112

Re: Genre Finder 5.0 - Updated 05/08/2012

Minimum match is also not working - you need to edit line 820 (assuming you've made my edit) to say the following:

cnt = FixCount(ele.ChildNodes.Item(0).Text)
by mhendu
Sun Nov 05, 2017 3:47 pm
Forum: Need Help with Addons?
Topic: Genre Finder 5.0 - Updated 05/08/2012
Replies: 971
Views: 468112

Re: Genre Finder 5.0 - Updated 05/08/2012

Close MediaMonkey. Open this file in notepad: C:\Users\USERNAME\AppData\Roaming\MediaMonkey\Scripts\Auto\GenreFinder.vbs Find this line: str = FixGenre(ele.ChildNodes.Item(0).Text) Change it to this: str = FixGenre(ele.ChildNodes.Item(1).Text) (The 0 changes to a 1). Restart MediaMonkey. Making thi...