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
Search found 17 matches
- Sun Dec 23, 2018 11:05 pm
- Forum: Need Help? (MMW4)
- Topic: SQLite No Such Collation Sequence
- Replies: 3
- Views: 3428
- Fri Dec 21, 2018 5:40 pm
- Forum: Need Help? (MMW4)
- Topic: SQLite No Such Collation Sequence
- Replies: 3
- Views: 3428
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 ...
- 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: 1443
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
Steve
- 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: 1443
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 del...
- Thu Oct 27, 2011 3:57 pm
- Forum: Need Help with Addons? (MMW4)
- Topic: Genre Finder 5.0 - Updated 05/08/2012
- Replies: 992
- Views: 770091
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...
- Sat Oct 15, 2011 12:23 pm
- Forum: MediaMonkey 4 Addons developer forum
- Topic: Adding Genres to Song with VBScript
- Replies: 4
- Views: 1786
Re: Adding Genres to Song with VBScript
That looks like it may be useful. Thanks!
- Sat Oct 15, 2011 1:09 am
- Forum: MediaMonkey 4 Addons developer forum
- Topic: Adding Genres to Song with VBScript
- Replies: 4
- Views: 1786
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...
- Wed Oct 12, 2011 11:56 pm
- Forum: MediaMonkey 4 Addons developer forum
- Topic: Adding Genres to Song with VBScript
- Replies: 4
- Views: 1786
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...
- Wed Oct 12, 2011 11:48 pm
- Forum: Need Help with Addons? (MMW4)
- Topic: SQL-Viewer 2.4 [Script] 2009-10-25
- Replies: 245
- Views: 202321
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...
- Wed Oct 12, 2011 12:52 am
- Forum: Need Help with Addons? (MMW4)
- Topic: SQL-Viewer 2.4 [Script] 2009-10-25
- Replies: 245
- Views: 202321
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...
- Mon Jul 18, 2011 7:01 pm
- Forum: Need Help? (MMW4)
- Topic: Getting name of album a song originally appeared on
- Replies: 3
- Views: 792
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...
- Mon Jul 18, 2011 6:57 pm
- Forum: Need Help? (MMW4)
- Topic: InStr type function for file masks?
- Replies: 4
- Views: 1009
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
Oh, well.
Steve
- Mon Jul 18, 2011 6:55 pm
- Forum: Need Help with Addons? (MMW4)
- Topic: Batch Art Finder 4.2 - Updated 03/07/2012
- Replies: 1693
- Views: 741427
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/larg...
- Thu Jul 14, 2011 6:41 pm
- Forum: Need Help? (MMW4)
- Topic: InStr type function for file masks?
- Replies: 4
- Views: 1009
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...
- Tue Jul 05, 2011 7:43 pm
- Forum: Need Help? (MMW4)
- Topic: Getting name of album a song originally appeared on
- Replies: 3
- Views: 792
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...