reinholdk wrote: > 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.
First of all thanks to the original coder FRANK - I really liked ACC. Now thanks to Reinholdk for the mod attempt. *Update to "STEP 2"* - Apparently the patch utility has been repackaged - download "Complete package, except sources" and install: http://gnuwin32.sourceforge.net/packages/patch.htm Then the patch ("Step 5") seems to work OK - no error. But when I start the "patched" ACC I start getting "script" errors - I'm out of my league here - anyone else gotten this far? Jim All wireless (TM-AC1900) except NAS (ReadyNAS PRO - OS 6.9.1 - 3GB RAM - 3 X 4TB drives - XRAID2 - LMS 7.9.1 ) Squeezebox Boom - Anywhere with an AC outlet Squeezebox Touch > Bose Radio - Kitchen Squeezebox Touch > Hafler 100 preamp > Hafler DH-220 amp > Sima SSW-L6 EX Speaker selector= Polk Audio Monitor 70 Series II - Living Room, Definitive Tech ProMonitor 100 - Dining Room, Infinity US-1 - Porch Ipeng on an iPad controls everything! ------------------------------------------------------------------------ usbethjim's Profile: http://forums.slimdevices.com/member.php?userid=8024 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/discuss
