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.
As the original author I got a notification of a post in this thread. Wasn't expecting people still using ACC. Nice to read ! 1xTouch, 1xSB3, 1xDuet, 3xRadio, Synology 412+ NAS, Devialet 120, Audio Physic Tempo 25 speakers ------------------------------------------------------------------------ SilverRS8's Profile: http://forums.slimdevices.com/member.php?userid=12818 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/discuss
