by ITgreybeard » Thu May 03, 2018 6:15 pm
Is there a workable .dll to load into SQLiteSpy (or other such db tool) that makes possible both reading and writing to the current version of MediaMonkey?
I am running MM 4.1.20.1864 on Win10 Pro, am committed to MM as the best cataloging tool anywhere, have purchased the Lifetime Gold version, and have more than 35K audio tracks managed with it starting half a dozen years ago. I now want to catalog a video collection, but that is requiring some up-front tag massaging.
I am looking to craft a few special updates that would pertain to video files, and have downloaded a half-dozen SQLite-compatible tools to do so, including SQLiteSpy. When a copy of MediaMonkey.dll is placed in the same directory as the SQLiteSpy executable, SQLiteSpy works pretty well for reading, but falls down on updating, complaining that an unknown tokenizer 'mm' is missing.
Elsewhere in the forum it is suggested that SQLite3MM.dll and SQLite3MMExt.dll could work. So I have tested placing copies of SQLite3MM.dll and SQLite3MMExt.dll into the SQLite3 folder, and then loading them singly or in all possible combinations with MediaMonkey.dll via the tools/extensions interface on SQLiteSpy. Either of these two alternative dll's produces the error that 'the specified procedure could not be found,' though SQLite3Spy does not actually specify the procedure -- to me, that is.
ODBC proved an interesting but not useful tool, as errors persisted in sorting or joining data, though simple reading usually was successful. I could link tables to MS Access, but running much of anything sucked.
There is a reputed SQLite3 interface to Visual Studio, and while I have installed it, it seemed better to try these retail interfaces first.
So let me re-pose the question: Is there a workable.dll to load into SQLite3Spy (or other such db tool) that makes possible both reading and writing to the current version of MediaMonkey?
If not, I might try my hand at scripting, but I gravitate towards SQL, what with long career experience in the many variants and versions of the language.
Thanks. ITG
Is there a [b]workable .dll[/b] to load into [b]SQLiteSpy[/b] (or other such db tool) that makes possible both reading and writing to the current version of MediaMonkey?
I am running MM 4.1.20.1864 on Win10 Pro, am committed to MM as the best cataloging tool anywhere, have purchased the Lifetime Gold version, and have more than 35K audio tracks managed with it starting half a dozen years ago. I now want to catalog a video collection, but that is requiring some up-front tag massaging.
I am looking to craft a few special updates that would pertain to video files, and have downloaded a half-dozen SQLite-compatible tools to do so, including [b]SQLiteSpy[/b]. When a copy of [b]MediaMonkey.dll[/b] is placed in the same directory as the SQLiteSpy executable, SQLiteSpy works pretty well for reading, but falls down on updating, complaining that an [b]unknown tokenizer 'mm' is missing[/b].
Elsewhere in the forum it is suggested that [b]SQLite3MM.dll[/b] and [b]SQLite3MMExt.dll[/b] could work. So I have tested placing copies of SQLite3MM.dll and SQLite3MMExt.dll into the SQLite3 folder, and then loading them singly or in all possible combinations with MediaMonkey.dll via the tools/extensions interface on SQLiteSpy. Either of these two alternative dll's produces the error that '[b]the specified procedure could not be found[/b],' though SQLite3Spy does not actually specify the procedure -- to me, that is.
[b]ODBC[/b] proved an interesting but not useful tool, as errors persisted in sorting or joining data, though simple reading usually was successful. I could link tables to MS Access, but running much of anything sucked.
There is a reputed SQLite3 interface to [b]Visual Studio[/b], and while I have installed it, it seemed better to try these retail interfaces first.
So let me re-pose the question: Is there a [b]workable.dll[/b] to load into SQLite3Spy (or other such db tool) that makes possible both reading and writing to the current version of MediaMonkey?
If not, I might try my hand at [b]scripting[/b], but I gravitate towards SQL, what with long career experience in the many variants and versions of the language.
Thanks. ITG