dasmueller wrote: > Hopefully it's a simple fix Depends on what you would call simple. :)
The main challenge is to adapt the ACC program code to switch the database systems from MySQL (as used in old LMS versions) to SQLite (as used in the newer), because ACC V3.4 assumes that MySQL is used. Fortunately this is easy, because the ACC's executable is a ".hta" file which is basically an HTML file containing script code that will be interpreted by Internet Explorer. Note that LMS' library.db file must be accessible from the local system (from where you are running ACC - I'll come to that below), the Remote Server options in the ACC dialog cannot be used! The database change is quite simple but I added a feature that adds some more changes: there will be a new option for pattern matching in ACC's Optional Filters dialog page (some hints about wildcard characters are given in the help popup). But to make it easy, there's a patch file that allows applying my changes to your installation of ACC. So assuming you have ACC V3.4 installed, the necessary steps are: - download and install sqliteodbc.exe (an SQLite ODBC Driver) from http://www.ch-werner.de/sqliteodbc/ - download and install the "Complete package, except sources" of the GnuWin32 diff utils from http://gnuwin32.sourceforge.net/packages/diffutils.htm - go to the ACC installation folder and create a copy of the file AlbumCatalogCreator-V3.4.hta as a backup - save the attached file 23574 to the ACC installation folder - open a command prompt window and enter Code: -------------------- cd C:\path\to\the\ACC\files -------------------- but adapt the path of course, then enter Code: -------------------- C:\Utils\GnuWin32\bin\patch -b AlbumCatalogCreator-V3.4.hta ACC-V3.4_diff.txt -------------------- but adapt the path of the patch utility to where you've installed it in step 2 (and you did create a backup in step 3, didn't you?) - figure out the path of your LMS' cache folder (LMS WebUI->Settings->Information, scroll to the bottom). If LMS is running on the same system as ACC and the cache folder is "C:\ProgramData\Squeezebox\Cache" you can go directly to step 8, otherwise copy the file library.db from the LMS cache folder to some folder on the system where ACC is installed - open the file AlbumCatalogCreator-V3.4.hta of the ACC installation folder in notepad (or notepad++ if you have it), search for the text -C:\ProgramData\Squeezebox\Cache- and replace it with the path to the folder that you just copied the library.db to and save the changes - start ACC as usual (double-click the file AlbumCatalogCreator-V3.4.hta) and let it generate the catalogue That should do the trick. +-------------------------------------------------------------------+ |Filename: ACC-V3.4_diff.txt | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=23574| +-------------------------------------------------------------------+ ------------------------------------------------------------------------ reinholdk's Profile: http://forums.slimdevices.com/member.php?userid=36070 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/discuss
