Search found 17 matches

by skj88
Sun Dec 23, 2018 11:05 pm
Forum: Need Help? (mmw)
Topic: SQLite No Such Collation Sequence
Replies: 3
Views: 786

Re: SQLite No Such Collation Sequence

Thanks for the reply. All seems to be working well with the imported tables. I have code to work with the MM automation objects to do updates so hopefully that all still works.

Cheers

Steve
by skj88
Fri Dec 21, 2018 5:40 pm
Forum: Need Help? (mmw)
Topic: SQLite No Such Collation Sequence
Replies: 3
Views: 786

SQLite No Such Collation Sequence

Hello All It's been a while since I worked with MM and am trying to get some music files organized. I had quite a fancy Access database that assisted with getting info for the files. Anyway, I hadn't used the Access DB in years. I had been using it with an older version of MM (not sure what version ...
by skj88
Tue Nov 08, 2011 8:40 am
Forum: MediaMonkey 4 Addons developer forum
Topic: Error Updating DB: Error executing SQL statement "COMMIT"
Replies: 1
Views: 989

Re: Error Updating DB: Error executing SQL statement "COMMIT

I think I may have fixed it. I moved the .commit before the UpdateDB and I was able to update 120 songs without an error. If the error pops up again I will reply to this post with updates.

Steve
by skj88
Tue Nov 08, 2011 12:39 am
Forum: MediaMonkey 4 Addons developer forum
Topic: Error Updating DB: Error executing SQL statement "COMMIT"
Replies: 1
Views: 989

Error Updating DB: Error executing SQL statement "COMMIT"

I am running the code below in MS Access to perform some bulk updates on some songs and I am getting the error: Error executing SQL statement "COMMIT" : SQL logic error or missing database (1, 21) It works for about 30 to 60 songs, then stops with the error above. I have tried adding a delay functio...
by skj88
Thu Oct 27, 2011 3:57 pm
Forum: Need Help with Addons?
Topic: Genre Finder 5.0 - Updated 05/08/2012
Replies: 971
Views: 517396

Re: Genre Finder 4.9 - Updated 25/02/2011

Perhaps this was answered earlier, but I haven't seen it... I would like to know if I have a translation of 'Metal=%Metal%' and 'British Metal=British%Metal', will both genres get tagged if the script pulls 'British Heavy Metal'? It should hit with %Metal% as the tag contains 'Metal' but it should a...
by skj88
Sat Oct 15, 2011 12:23 pm
Forum: MediaMonkey 4 Addons developer forum
Topic: Adding Genres to Song with VBScript
Replies: 4
Views: 1109

Re: Adding Genres to Song with VBScript

That looks like it may be useful. Thanks!
by skj88
Sat Oct 15, 2011 1:09 am
Forum: MediaMonkey 4 Addons developer forum
Topic: Adding Genres to Song with VBScript
Replies: 4
Views: 1109

Re: Adding Genres to Song with VBScript

I figured it out. The database is on a networked HTPC and I am trying to update from another PC on the network. I rescanned the HTPC C:/ drive with the network name instead of C:/ and I could update from the other PC. It created duplicate entries in the database (now it has two paths to the same fil...
by skj88
Wed Oct 12, 2011 11:56 pm
Forum: MediaMonkey 4 Addons developer forum
Topic: Adding Genres to Song with VBScript
Replies: 4
Views: 1109

Adding Genres to Song with VBScript

I am trying this code as a test to build a script to do some mass updates in MM for me. The new Genre shows in MM on the song I want it to show on, but when I update the library, the Genre tag is reset to the previous Genre(s). Your help is greatly appreciated!! Sub TestAddGenre() Dim SDB, Iter, obj...
by skj88
Wed Oct 12, 2011 11:48 pm
Forum: Need Help with Addons?
Topic: SQL-Viewer 2.4 [Script] 2009-10-25
Replies: 244
Views: 139884

Re: SQL-Viewer 2.4 [Script] 2009-10-25

Actually no, it's not easier to update Genres in MM manually when you have several thousand of them. Isn't that the point of scripts? I can handle doing some manually, but not thousands. I gave up on SQL and am trying UpdateDB and WriteTags methods with no luck. I will start another thread to try to...
by skj88
Wed Oct 12, 2011 12:52 am
Forum: Need Help with Addons?
Topic: SQL-Viewer 2.4 [Script] 2009-10-25
Replies: 244
Views: 139884

Re: SQL-Viewer 2.4 [Script] 2009-10-25

I am trying to get this to work with adding new Genres. I can get a new Genre to add to the Songs table, but once I rescan my library, the new genre disappears. I tried adding the new Genre to the Songs table, Genres table and the link between the song and new genre in the GenresSongs table, but sti...
by skj88
Mon Jul 18, 2011 7:01 pm
Forum: Need Help? (mmw)
Topic: Getting name of album a song originally appeared on
Replies: 3
Views: 456

Re: Getting name of album a song originally appeared on

I've been trying Jaikoz and it works fairly well for what I want. It's auto-tagger is a little more accurate than MusicIPTagger. it has settings that can help it pick the album was originally on. If that fails, it has a manual tag function that lists the album and year the song appeared on and you c...
by skj88
Mon Jul 18, 2011 6:57 pm
Forum: Need Help? (mmw)
Topic: InStr type function for file masks?
Replies: 4
Views: 597

Re: InStr type function for file masks?

I was hoping there were more functions available as the table states "The table below describes most of the commonly used characters and fields in a mask." The phrase "most of the commonly used" implies there are more - they are just not listed.

Oh, well.

Steve
by skj88
Mon Jul 18, 2011 6:55 pm
Forum: Need Help with Addons?
Topic: Batch Art Finder 4.2 - Updated 03/07/2012
Replies: 1692
Views: 565644

Re: Batch Art Finder 4.1 - Updated 31/01/2011

Thanks for the advice, trixmoto. I think the problem may have been incompatibility between the image size selected in the drop down and the image sizes I had in the min max box. Once I changed the image size to "Large" BAF started working as I would expect. It skipped images too small/large, but sto...
by skj88
Thu Jul 14, 2011 6:41 pm
Forum: Need Help? (mmw)
Topic: InStr type function for file masks?
Replies: 4
Views: 597

InStr type function for file masks?

Is there a function for the file masks similar to the VB "InStr" function or the Excel "Search" or "Find" functions? Or even the SQL LIKE with wildcards (Acces SQL example - SELECT MyField FROM MyTable WHERE LIKE "*MySearchString*") A function like this for my masks would be helpful. If there is, co...
by skj88
Tue Jul 05, 2011 7:43 pm
Forum: Need Help? (mmw)
Topic: Getting name of album a song originally appeared on
Replies: 3
Views: 456

Re: Getting name of album a song originally appeared on

Thanks for the response. I'm going to try a multi-step approach: 1. Tag album name with MusicIPTagger What it doesn't get correct, I'll try: 2. DiscogsAutoTag Anything left, I'll get with the built in Amazon lookup. I just hate typing the name of the song for the amazon lookup as it only searches (a...