Re: [slim] Announce: Album Catalog Creator v3
squeezebox_Fan wrote: > I would be very happy to get your maual or how to to get a Music Catalog > in HTML to cary with me on my mobile ohone. > > Greetings Sorry it's taken till now - I've started a thread here: https://forums.slimdevices.com/showthread.php?112602-How-to-list-all-Albums-and-Artists-in-LMS-library Digital: Raspberry Pi 3B; piCorePlayer 6 + LMS 8; HifiBerry DAC+DSP > Yamaha RX-V2700 > Jamo speakers Analogue: HifiBerry DAC+DSP > Speakercraft MZC-66 > whole house Library: External USB drive Android: Squeezer app Viragored's Profile: http://forums.slimdevices.com/member.php?userid=32954 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
squeezebox_Fan wrote: > I would be very happy to get your maual or how to to get a Music Catalog > in HTML to cary with me on my mobile ohone. > > Greetings Ok, I'll sort something out over the next couple of days. I'll reply here with a link to a new thread so the forum auto-email should tell you when there's something to see. Digital: Raspberry Pi 3B; piCorePlayer 6 + LMS 8; HifiBerry DAC+DSP > Yamaha RX-V2700 > Jamo speakers Analogue: HifiBerry DAC+DSP > Speakercraft MZC-66 > whole house Library: External USB drive Android: Squeezer app Viragored's Profile: http://forums.slimdevices.com/member.php?userid=32954 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
I would be very happy to get your maual or how to to get a Music Catalog in HTML to cary with me on my mobile ohone. Greetings *Hardware:* 1 Touch,3 Radio,1 Boom,2 SB3, PiCorePlayer *Players Software:* squeezelite *Steuerung:*Squeeze Comander *Plugins:*"Lesezeichen, Custom Browse, TrackStat; Custom Scan; 'MusicInfoSCR' (http://www.herger.net/slim-plugins/detail.php@nr=446&kategorie=slim-plugins); 'LazySearch 2' (http://www.hickinbottom.com/lazysearch), JustCovers,PlayHLS;ENM for Dreambox, and more. LMS 7.9.3 WINDOWS 10 2004 64Bit &'MusicIP ' (http://www.spicefly.com/)Server squeezebox_Fan's Profile: http://forums.slimdevices.com/member.php?userid=63027 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Every now and then I get the urge to have a search through the forums to see if anyone has come up with a neat way of producing a list of albums, using LMS as the source. I'll describe what I've successfully been doing, but it is clunky, is based on a Windows PC, and won't appeal to anyone looking for a simple one-click option. Samples of my output are available on these pages: https://wbeachdave.weebly.com/artists.html and https://wbeachdave.weebly.com/albums.html I found an open-source app called "DB Browser for SQLite" that lets people like me peep into SQLite databases - https://sqlitebrowser.org/ LMS settings information page includes the path to the "Cache", where the library.db file is. (I copy the library file to the PC so I don't accidentally damage it) On the PC, opening the library.db file in DB Browser displays the contents of the library, both structure and data. And that's where it gets a bit more interesting with more steps needed to progress from seeing the data on screen to having the data in a usable form. If there are any other (relative) novices who'd like further info on how I got from displaying the library in DB Browser to having usable album lists, just comment below. If there's any interest, I'll write up the steps I used, and put them in a new thread. Have fun! Digital: Raspberry Pi 3B; piCorePlayer 6 + LMS 8; HifiBerry DAC+DSP > Yamaha RX-V2700 > Jamo speakers Analogue: HifiBerry DAC+DSP > Speakercraft MZC-66 > whole house Library: External USB drive Android: Squeezer app Viragored's Profile: http://forums.slimdevices.com/member.php?userid=32954 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Thanks for some useful suggestions. And the link to LMSDocumenter... Had used this before but somehow lost the download. SB Touch (modded)/Chord Mojo or Linn LP12/MuseII/AudioMods Tonearm, Cambridge Audio Azur 851E pre & Crimson 640 (x4) power, Martin Logan Aerius i ntom's Profile: http://forums.slimdevices.com/member.php?userid=3197 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
I'll look into that ignore tracks setting. TBH, I figure with all the effort it would take to actually listen to Everything, I'll live with the variations. Plenty of other things to obsess over! :) fphredd's Profile: http://forums.slimdevices.com/member.php?userid=33133 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
fphredd wrote: > I've used MediaMonkey with a plug-in Just List Albums. The only problem > is the MM list differs from a bit from LMS, more than one instance of > LMS differs from another on the same set of music. > > MediaMonkey: 78,751 Tracks > LMS1 (RaspberryPi/Max2Play): 78,815 Tracks > LMS2 (Windows 7): 78,811 Tracks You don't have the "ignore tracks shorter than 'x' seconds" enabled do you? Also I find MediaMonkey does not always reliably clear deleted or moved tracks when you rescan - so you may have some ghost ones in that library db? - *Hi-Fi 1*: VortexBox LMS/SOtM tX-USB; Oppo Cirrus ESS Sabre32 DAC (BDP-105D), Yamaha Aventage CX-A5000; Focal SM9s. - *+ HT*: Sony 55" 4K KD-55X8500C LED, Oppo UDP-203, Apple TV 4K, PS3/PlayTV; Focal SM6s (1 Twin6, 2 Solo6, 2 Sub6). - *Hi-Fi 2*: Sqbox Touch/Focal XS Books. - *Hi-Fi Misc*: iPeng (iPad/iPhones), Plantronics BB Pro 2 LE Headphones. - *Accessories*: Tchernov Classic & Van den Hul IC; Thor PS10 Power Station; Blue Jeans & Ruleconnect Cables (Power, HDMI, USB & Coaxial); Aurios & Vibrapods. Mycenius's Profile: http://forums.slimdevices.com/member.php?userid=56466 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
I've used MediaMonkey with a plug-in Just List Albums. The only problem is the MM list differs from a bit from LMS, more than one instance of LMS differs from another on the same set of music. MediaMonkey: 78,751 Tracks LMS1 (RaspberryPi/Max2Play): 78,815 Tracks LMS2 (Windows 7): 78,811 Tracks fphredd's Profile: http://forums.slimdevices.com/member.php?userid=33133 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
https://forums.slimdevices.com/showthread.php?106963-New-version-of-LMSDocumenter&highlight=lmsdocumenter VB2.4[/B] STORAGE *QNAP TS419P (NFS) [B]Living Room* - Joggler & SB3 -> Onkyo TS606 -> Celestion F20s *Office* - Pi3+Sreen -> Sony TAFE320 -> Celestion F10s / Pi2+DAC & SB3 -> Onkyo CRN755 -> Wharfedale Modus Cubes *Dining Room* -> SB Boom *Kitchen* -> UE Radio (upgraded to SB Radio) *Bedroom (Bedside)* - Pi2+DAC ->ToppingTP21 ->AKG Headphones *Bedroom (TV)* - SB Touch ->Sherwood AVR ->Mordaunt Short M10s Everything controlled by iPeng d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
ntom wrote: > Know this is an old thread, but does anybody still use this or can > anyone suggest an alternative tool for producig a formatted hard copy > list from the LMS database? > > Sadly I can no loger find a download of this tool. Had used it in the > past but can no longer find it. I seem to recall that it is possible to create a catalogue of albums using mp3tag? Shozzer's Profile: http://forums.slimdevices.com/member.php?userid=58726 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Know this is an old thread, but does anybody still use this or can anyone suggest an alternative tool for producig a formatted hard copy list from the LMS database? Sadly I can no loger find a download of this tool. Had used it in the past but can no longer find it. SB Touch (modded)/Chord Mojo or Linn LP12/MuseII/AudioMods Tonearm, Cambridge Audio Azur 851E pre & Crimson 640 (x4) power, Martin Logan Aerius i ntom's Profile: http://forums.slimdevices.com/member.php?userid=3197 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
usbethjim wrote: > Yep - started patched file in the original folder - "includes" folder > is there with a "js" subfolder containing "balloon.js" > > Yes I get the same scripting error running the unpatched hta file. > > Maybe my copy of ACC 3.4 is not good? > > Jim Unfortunately I don't know why you're getting scripting errors while starting the .hta file. But from your log file it seems that the script is executed anyway after you clicked the button. So what you can try is clearing all the settings that ACC is storing in Windows Registry before running ACC again. Do you feel comfortable enough in editing a key in Windows Registry? If not, I can provide you a script that automates it. If yes follow these steps: - start regedit.exe - from the hierarchical nodes on the left side of the regedit window navigate to HKEY_CURRENT_USER\Software\ACC - while the ACC node is selected press F2 to rename it e.g. to ACC.old - close regedit Now run the patched .hta again and try creating the catalog. Hopefully it is able to connect to the database file then and perform some actions on it. We should see some more entries in the log file at least... 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
reinholdk wrote: > The patched .hta file is perfectly fine and I can launch it without > problems. > > Did you start the patched file from within the same folder where the > original one is located, i.e. the subfolder "Includes/js" is there? > Can you start the original file without getting scripting errors? > > Btw, a path to the sqlite driver is not needed. Only the path to the > library.db as you did already. Yep - started patched file in the original folder - "includes" folder is there with a "js" subfolder containing "balloon.js" Yes I get the same scripting error running the unpatched hta file. Maybe my copy of ACC 3.4 is not good? 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
usbethjim wrote: > Done! Thanks for the help... > > Jim The patched .hta file is perfectly fine and I can launch it without problems. Did you start the patched file from within the same folder where the original one is located, i.e. the subfolder "Includes/js" is there? Can you start the original file without getting scripting errors? Btw, a path to the sqlite driver is not needed. Only the path to the library.db as you did already. 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
reinholdk wrote: > I can check if the patch produced the correct file if you send me your > modified version of the .hta file using this link: > https://www.dropbox.com/request/R11LoBlKeDb8cJZUz4XZ Done! Thanks for the help... 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
usbethjim wrote: > Line: 35 > Char: 4 > Error: The value of the property 'BalloonConfig' is null or undefined, > not a Function object > Code: 0 > > I answer YES to continue running scripts. The ACC UI comes up but if I > use it I get this over and over again: > > Line: 1 > Char: 1 > Error: Unable to get property 'show Tooltip' of undefined or null > reference > Code: 0 > > If I just click "Create Catalogs" I get what I think I remember from > wayback as an ACC error: "Error Connecting to Squeezebox Server > Database." with a few paragraphs of possible reasons for failure. > > I did change the location of the "library.db" to it's proper location. > Am I missing some sort of link/path to the sqlite package that I > installed in "Step 1"? > > Thanks alot for your work... > Jim I can check if the patch produced the correct file if you send me your modified version of the .hta file using this link: https://www.dropbox.com/request/R11LoBlKeDb8cJZUz4XZ 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
reinholdk wrote: > Thanks for clarifying the link to the patch utility. What is the exact > error message when you start the patched ACC? Line: 35 Char: 4 Error: The value of the property 'BalloonConfig' is null or undefined, not a Function object Code: 0 I answer YES to continue running scripts. The ACC UI comes up but if I use it I get this over and over again: Line: 1 Char: 1 Error: Unable to get property 'show Tooltip' of undefined or null reference Code: 0 If I just click "Create Catalogs" I get what I think I remember from wayback as an ACC error: "Error Connecting to Squeezebox Server Database." with a few paragraphs of possible reasons for failure. I did change the location of the "library.db" to it's proper location. Am I missing some sort of link/path to the sqlite package that I installed in "Step 1"? Thanks alot for your work... 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
usbethjim wrote:
> 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
Thanks for clarifying the link to the patch utility. What is the exact
error message when you start the patched ACC?
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
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
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
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
reinholdk wrote: > Unless Frank doesn't provide a new download site you can find it through > the internet archive's wayback machine at https://web.archive.org/ by > entering Frank's original download url given in the first post of this > thread. The download file does not seem to be available from Wayback, but I have a copy lying around. If it is alright with Frank, I can make it available - I will wait for his reply here before I do anything. Mikkel Pokersut's Profile: http://forums.slimdevices.com/member.php?userid=14520 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
bobertuk wrote: > I like that ACC can now be used with LMS 7.91. I gave up on ACC when LMS > went over to SQLite, no longer have a copy of ACC anywhere and the files > can no longer be downloaded - the website is dead. > > Is there any way to get a copy of ACC 3.4 so that I can give it a try? > > Bob Unless Frank doesn't provide a new download site you can find it through the internet archive's wayback machine at https://web.archive.org/ by entering Frank's original download url given in the first post of this thread. 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
I like that ACC can now be used with LMS 7.91. I gave up on ACC when LMS went over to SQLite, no longer have a copy of ACC anywhere and the files can no longer be downloaded - the website is dead. Is there any way to get a copy of ACC 3.4 so that I can give it a try? Bob 1 x Touch 1 x Radio 1 x Boom 1 x Intel-NUC server/squeezelite running LMS 7.91 on Windows 10 1 X Odroid-XU4 server/squeezelite running LMS 7.91 on Ubuntu 16.04 WaveIO USB into Lavry DA-10 DAC Starfish Pre-amp : Based on NAIM NAC 72 Heavily modified NAIM NAP 250 Power-amp Behringer DEQ2496 Linn Isobarik DMS bobertuk's Profile: http://forums.slimdevices.com/member.php?userid=30376 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
dasmueller wrote: > I assume by- > > quote[cd C:\path\to\the\ACC\files > but adapt the path of course, then enter]quote] > > you mean the path to the music library itself ? Or, do you mean to the > ACC folder ? The path to the ACC program folder. 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
SilverRS8 wrote: > As the original author I got a notification of a post in this thread. > Wasn't expecting people still using ACC. Nice to read ! Hope you don't mind my poor tries to explain how to resurrect ACC for the latest LMS versions. When I did those changes a few years back just for myself, I tried to contact you via the email given in the ACC but without success. As I didn't want to redistribute your work, I took the approach to explain how to modify it. Of course, all credit belongs to you for this nice program (it's fun even if I used it rarely in the past). 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
I assume by- quote[cd C:\path\to\the\ACC\files but adapt the path of course, then enter]quote] you mean the path to the music library itself ? dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
dasmueller wrote: > I will need to see if I can work through this not being a whiz with > these types of things. Any thoughts on reverting to an older form of > LMS ? Might be simpler-just a thought. I wouldn't return to a LMS that is that old - don't know what was the last version using MySQL. I think the biggest challenge could be - only if you're running LMS on a different device - to copy the LMS library.db file to your PC. All other steps should be manageable for non tech-savvy people. 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
I will need to see if I can work through this not being a whiz with these types of things. Any thoughts on reverting to an older form of LMS ? Might be simpler-just a thought. dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Am running LMS 7.9.0 how do I get ACC to run w that so I can update ? Hopefully it's a simple fix Thanks. dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
A few years ago I've modified ACC v3.4 to work with recent versions of LMS using the SQLite database. If anybody is interestet, I can share how to do it. 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
venus light wrote: > Does anyone have a recent version of this that they can share? It looks > like acc.vanholt.nl is offline. > > The most recent version that I have is v1. I realize this only works on > older versions of SBS, but I was hoping to use it again. > > Anyone? 1drv.ms/1PuD1bT including mysql-connector-odbc-5.1.0-alpha-win32.msi topaz's Profile: http://forums.slimdevices.com/member.php?userid=61901 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Thanx for your answer, that's too bad, so I must generate the pdf from the computer where ACC is running. For me that's a bit annoying because I am mainly on a Mac now. I should have take note of the ACC settings I worked with years ago. HiFi : SqueezeBox3, SC V7.3.2 - 24695 (avec SSODS de flipflip) - NAS Synology DS 127+.128, Dac Northstar 192, NAD C320BEE, Triangle AlteaESW. HC : BD Prime Dune, Denon AVR-1908 (couplé au NAD), ALteaESW + 2 vielles biblios Jamo, VP Sony HW10. stof77's Profile: http://forums.slimdevices.com/member.php?userid=12949 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
I believe this is a bug in IE. To get a 'portable' version of the catalog you can create a PDF instead. 1xTouch, 1xSB3, 1xDuet, 1xRadio, 1xiPhone iPeng, Ubuntu NAS + SBS 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Hello, it's been a long time I haven't use ACC, now that I'd like to update my catalog, it seems I just can't get the cover art to be included in the mht file. I want the option to use that archive on other computer for pdf building process. So far I'm testing with everything setup on the same computer : SBS v7.5.3 ACC v3.5 music library So generating the catalog is ok in html, but the MHT do not "include" the cover art. Both are displaying ok on the same computer, but when I open the MHT on another computer, there is no covert art, they are all empty, the MHT is only few hundred ko, so that's the problem. I don't now what settings should I modify ? All cover are named "folder.jpg", one file by album in each folder. and one folder for each album. Any help would be very appreciated !!! HiFi : SqueezeBox3, SC V7.3.2 - 24695 (avec SSODS de flipflip) - NAS Synology DS 127+.128, Dac Northstar 192, NAD C320BEE, Triangle AlteaESW. HC : BD Prime Dune, Denon AVR-1908 (couplé au NAD), ALteaESW + 2 vielles biblios Jamo, VP Sony HW10. stof77's Profile: http://forums.slimdevices.com/member.php?userid=12949 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
There may be some similar non-LMS-based products that do the same thing: http://my-music-collection.com/ http://www.firetongue.com/cd-database.html http://www.collectorz.com/music/music_catalog.php and the list goes on... http://zzzone.net http://have-a-nice-day.org http://www.last.fm/user/zzzoneDOTnet http://somethingsomethingsomething.net dBpoweramp Cisco E4200 SBS 7.8 - i7 laptop - Win 8 64bit 3 Booms, 2 Radio, 1 Touch, 1 iPod Touch w/digital dock 2 controllers, various tablets/phones Various apps including iPeng, Logitech Android, etc. 'Library' (http://zzzone.net/photo/2009/music1.jpg): 236,000+ FLAC/MP3 files - 12 TB HD Onkyo TX-NR818, KEF Q300/Q200/iQ30, Outlaw LFM-1 Plus jimzak's Profile: http://forums.slimdevices.com/member.php?userid=17592 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Does anyone have a recent version of this that they can share? It looks like acc.vanholt.nl is offline. The most recent version that I have is v1. I realize this only works on older versions of SBS, but I was hoping to use it again. Anyone? venus light's Profile: http://forums.slimdevices.com/member.php?userid=10916 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
I wonder if there is a software alternative to do this... sle118's Profile: http://forums.slimdevices.com/member.php?userid=35009 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
bumping this thread... I've been trying to find the tool, but the web site is down and the wayback machine didn't include the downloads area http://web.archive.org/web/20120827000444/http://acc.vanholt.nl/ I've sent Frank a personal message in hope that he will respond. sle118's Profile: http://forums.slimdevices.com/member.php?userid=35009 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
I can only speak for Windows 7, but using shortcuts makes it fairly easy for Squeezebox Server to scan music files located either on an external hard drive plugged into the same computer or else on a network drive located on an external networked computer. I don't recall whether I have tried scanning with Squeezebox server running on computer A and the music files on an external USB drive plugged into an external networked computer B, but that should work too. I have never used a NAS (network attached storage) drive. It is important to remember that AAC works through the Squeezebox server which has to be running at the same time AAC is run. I usually just plug a USB hard drive into the computer now and have Squeezebox server and AAC running on the same computer. But in the past I had AAC running on my windows computer and I could either have it use the Squeezebox server running on the same computer, or else the AAC on the windows computer could also use the SQueezebox server running on an external Linux box. In the latter case, the Squeezebox server needs to be modified slightly to allow access to its database from an external computer. The AAC website gave instructions on how to do that, but since those seem to be gone, below are the notes I wrote to myself (since I forget otherwise!): Installation of ACC (on a Windows 7 64-bit machine): 1. First install the MySQL ODBS driver v5.1 (32-bit version): (Download, run setup.exe). 2. ACC requires no installation: just unzip to a folder and double-click the .hta file. 3. If Squeezebox Server is running on the same machine as ACC, no further set up is necessary. To check though, in the ACC program, on 'Remote Server options': -- IP address should be set to 127.0.0.1 (using local Server, not external server) -- Port number should be set to '9000' -- Drive mapped to remote Server either blank or set to R: (my mapped network drive on the external computer) -- leave physical path blank Then skip to step 5. 4. If Squeezebox Server is running on a remote machine then it has to be configured to allow ACC to connect remotely. The change is to add a '#' character before the 'bind-address' command in the my.tt file. My external computer was a headless Linux box so I had to use PuTTY to SSH into it; if you external box is windows you can just use notepad. Then: Change directory to /usr/share/squeezeboxserver/MySQL and edit the file 'my.tt' with the 'nano' editor: insert a '#' character before the 'bind-address' command in the file and then save it and restart squeezeboxserver. Then, set up the AAC program: In the ACC program, on the 'Remote Server options' page, set the IP address to the external computer's IP address [e.g. 192.168.1.106]; set the Port number to '9002' (usually 9000 but my linux box used 9002); set mapped drive to 'R:' (my mapped drive), set physical path to '/media/Music'. (the music library on the linux box) 5. On the Windows machine running ACC, set Internet Explorer's security level to allow Access data sources across domains (IE, Tools Menu, Internet Options, Security Tab, Internet Zone, Custom Level, select 'enable'). 6. In ACC, main page, leave Starting Folder blank, or set to [drive]:\[subfolder]if desired. To run ACC, the SqueezeBox Server must be running. Then simply double-click the .hta file. Hope that helps - it makes it look more complicated than it is Swimmer Swimmerbird123's Profile: http://forums.slimdevices.com/member.php?userid=17285 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Swimmerbird or anyone else: Do external HDDs with music files on them have to be connected to the actual computer running Squeezebox Server or should I be able to scan the files over a network? maximus's Profile: http://forums.slimdevices.com/member.php?userid=41211 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Anyone know where i can download AAC? Official homepage seems to be down. maximus's Profile: http://forums.slimdevices.com/member.php?userid=41211 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Just thought I'd mention that Muso can generate an HTML catalog for your music collection - it has it's own database but it can be configured so that it will mirror the LMS database. Muso: http://klarita.net/muso.html Examples of generated catalog: Modern music : http://www.klarita.net/catalog3/catalog.html Classical : http://klarita.net/catalog2/catalog.html jezbo's Profile: http://forums.slimdevices.com/member.php?userid=9888 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Swimmerbird123 wrote: > What a great little program this is/was. It is too bad that the whole > server database method changed to make it inoperable. I still keep an > older version of the squeezebox server on an old computer with a library > consisting of just a short cut to an external USB drive, just so that I > can still plug in the USB drive with my backup collection, run the SBS > and then run ACC to get an updated catalog. > > Swimmer Great idea, thanks!! maximus's Profile: http://forums.slimdevices.com/member.php?userid=41211 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
What a great little program this is/was. It is too bad that the whole server database method changed to make it inoperable. I still keep an older version of the squeezebox server on an old computer with a library consisting of just a short cut to an external USB drive, just so that I can still plug in the USB drive with my backup collection, run the SBS and then run ACC to get an updated catalog. Swimmer Swimmerbird123's Profile: http://forums.slimdevices.com/member.php?userid=17285 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
dasmueller wrote: > Are there any plans to make this work w 7.7.1 ? Or even for 7.7.2 ??? Roger66's Profile: http://forums.slimdevices.com/member.php?userid=29812 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Are there any plans to make this work w 7.7.1 ? -- dasmueller dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
jimzak;679254 Wrote: > Is there any other way to produce a listing of one's LMS music > collection automatically? You might look at this thread http://forums.slimdevices.com/showthread.php?t=90928&highlight=album+list -- dasmueller dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Is there any other way to produce a listing of one's LMS music collection automatically? -- jimzak http://zzzone.net http://have-a-nice-day.org http://www.last.fm/user/zzzoneDOTnet http://somethingsomethingsomething.net Ripper: dBpoweramp Router: Cisco E4200 Server: SBS 7.7.1 - i3 - Win 7 64bit Player: 2 Booms, 1 Radio, 1 Touch Control: 2 controllers, iPad1, iPad2, Nexus S smartphone, Transformer Eee tablet Apps: iPeng for iPad, SqueezePad, Logitech Squeezebox app 'Library' (http://zzzone.net/photo/2009/music1.jpg): 131,000+ FLAC/MP3 files - 2TB external HD x 3 jimzak's Profile: http://forums.slimdevices.com/member.php?userid=17592 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
maximus;671078 Wrote: > Did I understand you correctly, ACC only works with 7.5.5 and below? Correct. -- Roger66 SB Touch SB Boom Win XP Pro SP3 Thinkpad X60s Roger66's Profile: http://forums.slimdevices.com/member.php?userid=29812 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Did I understand you correctly, ACC only works with 7.5.5 and below? -- maximus maximus's Profile: http://forums.slimdevices.com/member.php?userid=41211 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
I don't use this utility very often - only a few times a year to regenerate my album catalog. But I sure miss it when I need it and it doesn't work! I have donated a small amount to help motivate the release of a version that works with SBS 7.6+ and whatever the default database is now. -- Henry66 Henry66's Profile: http://forums.slimdevices.com/member.php?userid=38863 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Haha. I saw my mistake. I am running 7.6.1 of squeezeserver Now I understand why ACC not working I'll wait for any new version with excitement -- t2capa t2capa's Profile: http://forums.slimdevices.com/member.php?userid=10030 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Hello.
Hope somebody here can help me.
First of all. Ive used an earlier version of ACC and I think it is
marvelous! It gave me a very nice catalogue of all my music.
Now I have resintalled a new PC and a new Squeezebox server and I am
not able to make ACC run.
PC is running windows XP with servicepack 3. Norwegian version. This
means I dont have C:\Program Files, but I have C:\Programfiler
Squeezebox server installed is latest version 7,6,1 and data and server
are all installed on the same PC
Running ACC 3.4 and MySQLconnection 5.1.9, (installed from
mysql-connector-odbc-5.1.9-win32.msi)
All 32bit
Windows XP, Squeezebox server, the music collection and ACC are all
installed and running on the same PC. Nothing is remote
I have removed HKEY-CURRENT_USER\Software\ACC key from the registry,
but still no success.
I have tried to turn off Windows firewall and antivirus but no
success.
I will be very happy any feedback on this.
Regards T2capa
I get this error message 3716 and a picture is attached
Here is a copy of the ACC log file:
ACC Version : 3.4
STARTED : 07.10.2011 --- 07:12:42
STATUS : fnStart():ENTER:07:12:42
MAIN PREFERENCES
OPTION SELEC: Catalog Title = Squeezebox Album Collection
OPTION SELEC: Catalog Sub Title: =
OPTION SELEC: Location of album property data = 1
OPTION SELEC: Display Tracks = Sann
OPTION SELEC: Display track duration = Sann
OPTION SELEC: Display Genre = Usann
OPTION SELEC: Display starting Capitals = Usann
OPTION SELEC: Display codec = Usann
OPTION SELEC: Display bitrate = Usann
OPTION SELEC: Create Table Of content = Sann
OPTION SELEC: Normal album art = Sann
OPTION SELEC: Use Large track fonts = Sann
OPTION SELEC: Sort by = 1
OPTION SELEC: Sort artist by ARTISTSORT tag = Usann
OPTION SELEC: Group by comment = 0
OPTIONS
-
OPTION SELEC: Use album cover stored in SqueezeCenter instead of
physical file(slow) = Sann
OPTION SELEC: Use Zero Prefix = 0
OPTION SELEC: Swap Artist - track for VA albums = 0
OPTION SELEC: Ignore 'The' prefix when sorting = Usann
OPTION SELEC: Vertical align = 0
OPTION SELEC: Horizontal align = 0
OPTION SELEC: Apply Drop Shadows to Album covers = -1
OPTION SELEC: Display CD# (if applicable) in header instead of
tracklist = -1
OPTION SELEC: Use Disc instead of CD for multiple CDs/Disc = 0
OPTION SELEC: Filter: From Date =
OPTION SELEC: Filter: Genres entered =
OPTION SELEC: Filter: GenreInclude = -1
OPTION SELEC: Filter: Comments entered =
OPTION SELEC: Filter: CommentInclude = -1
OPTION SELEC: Filter: Starting folder =
ADVANCED OPTIONS
OPTION SELEC: Create .MHT = 0
OPTION SELEC: TPE2 tag is AlbumArtist instead of band = 0
OPTION SELEC: Create CSV file = 0
OPTION SELEC: Maximum tracks on page = 110
OPTION SELEC: Maximum album rows per page = 5
OPTION SELEC: Maximum TOC rows per page = 50
OPTION SELEC: Alternative coverart filename =
OPTION SELEC: Alternative output folder =
REMOTE SERVER OPTIONS
---
OPTION SELEC: Remote IP Number = 127.0.0.1
OPTION SELEC: Port Number = 9000
OPTION SELEC: Mapped local drive = -1
OPTION SELEC: Physical directory path =
END OF GUI OPTIONS
--
STATUS : fnStart():LEAVE:07:12:42
STATUS : fnStart2():ENTER:07:12:42
STATUS : fnStart2():MySQL Connectstring=DRIVER={MySQL ODBC 5.1
Driver};Server=127.0.0.1;Port=9092;Database=slimserver;UID=slimserver;Password=slimserver;Option=3
STATUS : fnQueryLogic():ENTER:07:12:42
STATUS : fnCreateACCTable():ENTER:07:13:01
STATUS : fnCreateACCTable():sql(1):
Create table ACC
SELECT DISTINCT
CONVERT(album_artist.name USING UTF8) AS 'AlbumArtist',
IF ( LEFT( CONVERT(album_artist.name USING UTF8), 4)='The ',
SUBSTRING(CONVERT(album_artist.name USING UTF8) FROM 5),
CONVERT(album_artist.name USING UTF8)) AS AlbumArtistAlt,
CONVERT(album_artist.namesort USING UTF8) AS 'AlbumArtistSort',
IF ( LEFT( CONVERT(album_artist.namesort USING UTF8), 4)='THE ',
SUBSTRING(CONVERT(album_artist.namesort USING UTF8) FROM 5),
CONVERT(album_artist.namesort USING UTF8)) AS AlbumArtistSortAlt,
CONVERT(albums.title USING UTF8) AS 'AlbumName',
albums.id AS 'AlbumID',
CONVERT(tracks.title USING UTF8) AS 'Title',
CONVERT(tracks.disc USING UTF8) AS 'Disc',
CONVERT(SEC_TO_TIME(tracks.secs),CHAR) as 'Duration',
albums.year AS 'AlbumYear',
tracks.url AS 'path',
tracks.tracknum AS 'TrackNum',
comments.value AS 'comment',
tracks.id AS 'TrackID',
GROUP_CONCAT(DISTINCT CONVERT(track_artist.name USING UTF8) SEPARATOR
';') AS 'TrackArtist',
GROUP_CONCAT(DISTINCT CONVERT(genres.name USING UTF8) SEPARATOR ';') AS
'genre',
tracks.lossless AS 'lossless',
tracks.bitrate AS 'bitrate',
tracks.content_type AS 'codec'
FROM albums
join contributors AS album_artist on albums.contributor=album_artist.id
left join trac
Re: [slim] Announce: Album Catalog Creator v3
Hi, are there any news about ACC 4.0 :) ? regards Roger -- Roger66 SB classic SB Boom Win XP Pro SP3 Thinkpad X60s Roger66's Profile: http://forums.slimdevices.com/member.php?userid=29812 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
SilverRS8;644437 Wrote: > I believe there should be an option in the settings to use MySQL instead > of SQlite. You must have an available MySQL instance somewhere to be > able to do so. In that case ACC should work. If not I'll look into it > when 7.6 is released. Regarding the release, if you look in the > developer threads, it is uncertain when and if it will be released. If > may be that SBS is replaced by LMS (Logitech Media Server). A lot of > SBS code will ofcourse be incorporated but I will wait for making ACC > compatible until things are more clear. > > Frank There was at one time an option in SBS 7.6 settings to select either MySQL or SQLite - SQLite was selected by default. This option was removed some time ago but it is still possible to use MySQL by altering something in one of the SbS config files. Can't remember where but I'm sure someone on the forums will be able to guide you in the right direction. Bob -- bobertuk 1 x Touch - SC 7.6.0 - SSOTS v4.91 1 x Radio 1 x Boom Lavry DA-10 DAC QNAP TS-509 3.3.6 build 1110T Starfish Pre-amp : Based on NAIM Heavily modified NAIM NAP 250 Power-amp Behringer DEQ2496 Linn Isobarik DMS bobertuk's Profile: http://forums.slimdevices.com/member.php?userid=30376 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
SilverRS8;644437 Wrote: > If not I'll look into it when 7.6 is released. Regarding the release, if > you look in the developer threads, it is uncertain when and if it will > be released. Hi, I'm a little bit confused ... My (auto updated) german SBS for Windows is 7.6.0 since 2 days ... Roger +---+ |Filename: IMG_1391.JPG | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=12133| +---+ -- Roger66 SB classic SB Boom Win XP Pro SP3 Thinkpad X60s Roger66's Profile: http://forums.slimdevices.com/member.php?userid=29812 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
SilverRS8;65 Wrote: > Whahaha I must have been sleeping. Will install it tonight and start > experimenting Really happy to read that, Thanks in advance -- reniera reniera's Profile: http://forums.slimdevices.com/member.php?userid=40705 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
reniera;61 Wrote: > 7.6 IS released ! Whahaha I must have been sleeping. Will install it tonight and start experimenting -- SilverRS8 Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for Squeezebox Server . 1xTouch, 1xSB3, 1xDuet, 1xRadio, 1xiPhone iPeng, Ubuntu NAS + SBS 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
SilverRS8;644437 Wrote: > I believe there should be an option in the settings to use MySQL instead > of SQlite. You must have an available MySQL instance somewhere to be > able to do so. In that case ACC should work. If not I'll look into it > when 7.6 is released. Regarding the release, if you look in the > developer threads, it is uncertain when and if it will be released. If > may be that SBS is replaced by LMS (Logitech Media Server). A lot of > SBS code will ofcourse be incorporated but I will wait for making ACC > compatible until things are more clear. > > Frank 7.6 IS released ! -- reniera reniera's Profile: http://forums.slimdevices.com/member.php?userid=40705 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
bobertuk;644426 Wrote: > ACC 3.4 and its predecessors are built to work with MySQL databases. SbS > 7.6 has moved on to use SQLite so current versions of ACC won't work. I > believe that 'SilverRS8' is in the process of updating ACC to work with > SQLite and SbS 7.6. > > Bob I believe there should be an option in the settings to use MySQL instead of SQlite. You must have an available MySQL instance somewhere to be able to do so. In that case ACC should work. If not I'll look into it when 7.6 is released. Regarding the release, if you look in the developer threads, it is uncertain when and if it will be released. If may be that SBS is replaced by LMS (Logitech Media Server). A lot of SBS code will ofcourse be incorporated but I will wait for making ACC compatible until things are more clear. Frank -- SilverRS8 Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for Squeezebox Server . 1xTouch, 1xSB3, 1xDuet, 1xRadio, 1xiPhone iPeng, Ubuntu NAS + SBS 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Thank you, Bob :-) -- Roger66 SB classic SB Boom Win XP Pro SP3 Thinkpad X60s Roger66's Profile: http://forums.slimdevices.com/member.php?userid=29812 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Roger66;644423 Wrote: > Hello, > > I've just updated to SBS 7.6.0 under Win XP SP3. ACC 3.4 doesn't work > anymore - SQL error. As far as I understand, I have to edit the my.tt > again now. > > Sorry for this dumb question, but what is the right editor for the > my.tt under windows ? > > With regular windows editor there are no separate lines, even with > "carriage return" enabled. There is a block of text instead. I cant see > the beginning of the line to put the "#" in front of. Shall I replace > the "=" with "#" ? > > Can U help me please ? > > Regards > Roger ACC 3.4 and its predecessors are built to work with MySQL databases. SbS 7.6 has moved on to use SQLite so current versions of ACC won't work. I believe that 'SilverRS8' is in the process of updating ACC to work with SQLite and SbS 7.6. Bob -- bobertuk 1 x Touch - SC 7.6.0 - SSOTS v4.91 1 x Radio 1 x Boom Lavry DA-10 DAC QNAP TS-509 3.3.6 build 1110T Starfish Pre-amp : Based on NAIM Heavily modified NAIM NAP 250 Power-amp Behringer DEQ2496 Linn Isobarik DMS bobertuk's Profile: http://forums.slimdevices.com/member.php?userid=30376 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Hello, I've just updated to SBS 7.6.0 under Win XP SP3. ACC doesn't work anymore - SQL error. As far as I understand, I have to edit the my.tt again now. Sorry for this dumb question, but what is the right editor for the my.tt under windows ? With regular windows editor there are no separate lines, even with "carriage return" enabled. There is a block of text instead. I cant see the beginning of the line to put the "#" in front of. Shall I replace the "=" with "#" ? Can U help me please ? Regards Roger -- Roger66 SB classic SB Boom Win XP Pro SP3 Thinkpad X60s Roger66's Profile: http://forums.slimdevices.com/member.php?userid=29812 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
I hope this has nopt been covered elsewhere - but I've skimmed the 22 pages and not seen it ... I can't seem to authorise my remote server to run ACC - I am using SSDOS on a NAS and have edited my my.tt file (found at [my ip]/ssods4/var/home/SqueezeboxServer/MySQL and restarted SBS, and continue to get this message: Am I missing something obvious? Jon +---+ |Filename: ACC Capture.JPG | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=12025| +---+ -- JonWill Main system: SB Touch, Arcam A85, Mission 733i speakers SB Classic into old JVC microsystem (next thing on list to upgrade!) SB Boom, Logitech Z4 subwoofer SB Radio SB Server 7.5.1 (SSODS4) running on a Synology DS210J NAS iPeng on iPhone 3GS JonWill's Profile: http://forums.slimdevices.com/member.php?userid=20259 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
SilverRS8;625465 Wrote: > Thank you for your paypal drop. I do not understand your performance > issue yet. For example when I run ACC I get the following stats: > Total number of Tracks : 5952 > Total number of Albums : 413 > Pages (ex. Table of Contents) : 60 > Catalog creation time : 00:29 > > Translated to your album collection size it should only take a few > minutes. What part of ACC processing seems to take the longest time? > > I'll come back on your album art size question sometime later (i'm at > work now) I have looked at the log and at the beginning of the processing ACC seems to be doing about 40 entries a second. However by the end of the run it takes two or three seconds to process each entry. ACC is progressively slowing down - I do not have the skills/knowledge to troubleshoot this. Maybe it has to do with the NAS? Anyway with the 7.6 changes coming you've got enough to do. I'm just happy to be able to generate the quickref ONLY. Thanks Jim -- usbethjim All wireless (Linksys WRT54GS) except NAS (ReadyNAS PRO - 3GB RAM - 5 X 1TB drives - XRAID2 - Squeezebox Server 7.5.4) Squeezebox Boom - Anywhere with an AC outlet SqueezeBox 3 (Slim version) > Bose Wave Radio - Kitchen Squeezebox Duet controller/receiver > Hafler 100 preamp > Hafler DH-220 amp > Sima SSW-L6 EX Speaker selector= Polk Audio Monitor70 Series II - Living Room, Definitive Tech ProMonitor 100 - Dining Room, Infinity US-1 - Porch 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
usbethjim;625330 Wrote: > Just ran it with the QuickRef only option. Ran just fine. Same > processing time as before - 51 minutes. But the QuickRef catalog > generation was almost instantaneous. Thanks for the OPTION add. I did > drop you a little paypal. > > Am I missing something in the options concerning cover art to speed up > the full catalog generation? The art is all 500x500 - avg 110K files. > It is in the form of a "cover.jpg" placed in each individual album > folder. No imbedded art at all. Any ideas/suggestions? Or should I > just let it run & run until done - ie that's the way it is? > > Thanks again... > Jim Thank you for your paypal drop. I do not understand your performance issue yet. For example when I run ACC I get the following stats: Total number of Tracks : 5952 Total number of Albums : 413 Pages (ex. Table of Contents) : 60 Catalog creation time : 00:29 Translated to your album collection size it should only take a few minutes. What part of ACC processing seems to take the longest time? I'll come back on your album art size question sometime later (i'm at work now) -- SilverRS8 Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for Squeezebox Server . 1xTouch, 1xSB3, 1xDuet, 1xRadio, 1xiPhone iPeng, Ubuntu NAS + SBS 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
SilverRS8;625183 Wrote: > Can you try 'ACC v3.5 Beta 1' > (http://acc.vanholt.nl/downloads/acc-v35beta1.zip) to check out the > QuickRef only option? Just ran it with the QuickRef only option. Ran just fine. Same processing time as before - 51 minutes. But the QuickRef catalog generation was almost instantaneous. Thanks for the OPTION add. I did drop you a little paypal. Am I missing something in the options concerning cover art to speed up the full catalog generation? The art is all 500x500 - avg 110K files. It is in the form of a "cover.jpg" placed in each individual album folder. No imbedded art at all. Any ideas/suggestions? Or should I just let it run & run until done - ie that's the way it is? Thanks again... Jim -- usbethjim All wireless (Linksys WRT54GS) except NAS (ReadyNAS PRO - 3GB RAM - 5 X 1TB drives - XRAID2 - Squeezebox Server 7.5.4) Squeezebox Boom - Anywhere with an AC outlet SqueezeBox 3 (Slim version) > Bose Wave Radio - Kitchen Squeezebox Duet controller/receiver > Hafler 100 preamp > Hafler DH-220 amp > Sima SSW-L6 EX Speaker selector= Polk Audio Monitor70 Series II - Living Room, Definitive Tech ProMonitor 100 - Dining Room, Infinity US-1 - Porch 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
usbethjim;622519 Wrote: > dasmueller FYI > > It took 51 minutes for the ACC 3.4 to complete (NOT including > generating the FULL Catalog). I'm using Windows XP - Pentium 4 2.8ghz > - 1GB ram. > The PC is wired to a router which is wired to a NAS that runs > SqueezeServer and holds all the files. > > Total Tracks: 36,496 > Total Albums: 2,634 > Total Artists: 1,119 > > All tracks are FLAC. Not sure of all this but I think my big problem > is when ACC finishes and then tries to generate the Full Catalog. At > this point my PC just grinds and grinds - I assume trying to get all > the cover art into the Full Catalog as the Quick Ref is already done > and displayed in another browser window. That's a lot of artI'm > not listing any tracks and not choosing large art option. > > Jim Can you try 'ACC v3.5 Beta 1' (http://acc.vanholt.nl/downloads/acc-v35beta1.zip) to check out the QuickRef only option? -- SilverRS8 Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for Squeezebox Server . 1xTouch, 1xSB3, 1xDuet, 1xRadio, 1xiPhone iPeng, Ubuntu NAS + SBS 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
usbethjim;622282 Wrote: > I tried ACC 3.4 and the full catalog run drives my pc to it's knees. > Searching threads here and checking program options but cannot seem to > find anything mentioning running the Quick Ref only. Am I missing the > obvious? Anyone have a suggestion? > > I really like the Quick Ref - is there some other program/CLI way to > run a catalog like the quick ref in ACC? The full catalog is something > I might run every once in awhile but the quick ref is great to check my > tagging. Thanks to the author for the ACC program. > > Jim Server is up and running again and I'm working on the update to be able to select whether or not to also generate the full catalog. I know I said to deliver it this week but it may take me a few more days as I also want to include some fixes and other new minor options. -- SilverRS8 Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for Squeezebox Server . 1xTouch, 1xSB3, 1xDuet, 1xRadio, 1xiPhone iPeng, Ubuntu NAS + SBS 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
I have downloaded all the software including the recommended Bullzip and generated the catalog. I have found no info at the bullzip site on how to actually use this printer on my Windows 7 PC. Any help greatly appreciated. The catalog looks great and took about 5 mins to generate!! -- dasmueller dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
SilverRS8;622663 Wrote: > But your browser supports the saving of webpagesDuh! Of course. I have done > this before. I must be getting old. Thanks for the reminder. -- Henry66 Henry66's Profile: http://forums.slimdevices.com/member.php?userid=38863 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Henry66;622594 Wrote: > Hi SilverRS8, > > I really ACC and use it regularly. Keep up the good work. > > Two things: > > - The QuickRef CSV generator is missing a quote (Chr(34)) before the > YEAR in the headline row. It's on line 2194 in V3.4.hta. > > - It would be nice to have an option to create a web page that does not > require the server to be present/accessible. This would mean downloading > all the artwork and creating local JPGs. This would allow me to copy the > html to a web server I can access from anywhere on the Internet. Thanks for posting. I'll fix it together with the catalog option. I can implement that but I'll focus on making ACC compatible with SBS 7.6 first as 7.6 is SQlite based where previous versions were MySQL based. But your browser supports the saving of webpages including the album art which it will place is a separate folder structure. You can copy the folder structure to a web server and it should be browseable (I did not test it though). -- SilverRS8 Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for Squeezebox Server . 1xTouch, 1xSB3, 1xDuet, 1xRadio, 1xiPhone iPeng, Ubuntu NAS + SBS 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
usbethjim;622593 Wrote: > Thanks for adding the option - I thought I was missing it. > > I'm a bit dull as to who does what to whom when. The NAS is pretty > well powered - Intel Pentium Dual CPU E2160 @ 1.80GHz. The load on the > PC seems to come after I get the ACC completion message. So the slow > down must be in the retrieval of the art from the NAS. > > Should I be picking another art option in ACC? Where does the art > reside after the full catalog is built? PC (in the generated HTML > file) or still on the NAS? > > Both units are hard wired to a 10/100 gb router. > > Thanks for your help - a little paypal on the way - oopps server down - > I WILL do it later! > > Jim The art resides in Squeezebox Server. The catalog album art just links to a specific SBS URL. The advantage is that this also supports embedded album art. Do you maybe use a high resolution album art? This may slow down performance also because of the resizing that is performed for inclusion in the catalog. -- SilverRS8 Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for Squeezebox Server . 1xTouch, 1xSB3, 1xDuet, 1xRadio, 1xiPhone iPeng, Ubuntu NAS + SBS 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Hi SilverRS8, I really ACC and use it regularly. Keep up the good work. Two things: - The QuickRef CSV generator is missing a quote (Chr(34)) before the YEAR in the headline row. It's on line 2194 in V3.4.hta. - It would be nice to have an option to create a web page that does not require the server to be present/accessible. This would mean downloading all the artwork and creating local JPGs. This would allow me to copy the html to a web server I can access from anywhere on the Internet. -- Henry66 Henry66's Profile: http://forums.slimdevices.com/member.php?userid=38863 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
SilverRS8;622556 Wrote: > I will post a minor update with an option to select which catalogs > should be created. I hope this will be on sunday as today my server > crashed and I hope the new hardware is delivered tomorrow. > > Regarding the slow processing; This strongly depends of the performance > of the MySQL server. If this is on a low powered NAS it may take a > longer time as ACC creates a temporary table to process all data. After > this the catalogs are generated. This part should go fast. Next the > catalogs are opened and the webbrowser will retrieve all cover art that > is linked from the catalog. The art is retrieved from the NAS which > again may determine the performance. Thanks for adding the option - I thought I was missing it. I'm a bit dull as to who does what to whom when. The NAS is pretty well powered - Intel Pentium Dual CPU E2160 @ 1.80GHz. The load on the PC seems to come after I get the ACC completion message. So the slow down must be in the retrieval of the art from the NAS. Should I be picking another art option in ACC? Where does the art reside after the full catalog is built? PC (in the generated hmtl file) or still on the NAS? Both units are hard wired to a 10/100 gb router. Thanks for your help - a little paypal on the way Jim -- usbethjim All wireless (Linksys WRT54GS) except NAS (ReadyNAS PRO - 3GB RAM - 5 X 1TB drives - XRAID2 - Squeezebox Server 7.5.3) Squeezebox Boom - Anywhere with an AC outlet SqueezeBox 3 (Slim version) > Bose Wave Radio - Kitchen Squeezebox Duet controller/receiver > Hafler 100 preamp > Hafler DH-220 amp > Sima SSW-L6 EX Speaker selector= Polk Audio Monitor70 Series II - Living Room, Definitive Tech ProMonitor 100 - Dining Room, Infinity US-1 - Porch 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
I look forward to trying this out next week. Thanks for all your work. -- dasmueller dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
usbethjim;622282 Wrote: > I tried ACC 3.4 and the full catalog run drives my pc to it's knees. > Searching threads here and checking program options but cannot seem to > find anything mentioning running the Quick Ref only. Am I missing the > obvious? Anyone have a suggestion? > > I really like the Quick Ref - is there some other program/CLI way to > run a catalog like the quick ref in ACC? The full catalog is something > I might run every once in awhile but the quick ref is great to check my > tagging. Thanks to the author for the ACC program. > > Jim I will post a minor update with an option to select which catalogs should be created. I hope this will be on sunday as today my server crashed and I hope the new hardware is delivered tomorrow. Regarding the slow processing; This strongly depends of the performance of the MySQL server. If this is on a low powered NAS it may take a longer time as ACC creates a temporary table to process all data. After this the catalogs are generated. This part should go fast. Next the catalogs are opened and the webbrowser will retrieve all cover art that is linked from the catalog. The art is retrieved from the NAS which again may determine the performance. -- SilverRS8 Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for Squeezebox Server . 1xTouch, 1xSB3, 1xDuet, 1xRadio, 1xiPhone iPeng, Ubuntu NAS + SBS 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Do you have "Create Internet Explorer Archive (.MHT) file" enabled in advanced options? That will cause this kind of behaviour. -- Henry66 Henry66's Profile: http://forums.slimdevices.com/member.php?userid=38863 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
dasmueller FYI It took 51 minutes for the ACC 3.4 to complete (NOT including generating the FULL Catalog). I'm using Windows XP - Pentium 4 2.8ghz - 1GB ram. The PC is wired to a router which is wired to a NAS that runs SqueezeServer and holds all the files. Total Tracks: 36,496 Total Albums: 2,634 Total Artists: 1,119 All tracks are FLAC. Not sure of all this but I think my big problem is when ACC finishes and then tries to generate the Full Catalog. At this point my PC just grinds and grinds - I assume trying to get all the cover art into the Full Catalog as the Quick Ref is already done and displayed in another browser window. That's a lot of artI'm not listing any tracks and not choosing large art option. Jim -- usbethjim All wireless (Linksys WRT54GS) except NAS (ReadyNAS PRO - 3GB RAM - 5 X 1TB drives - XRAID2 - Squeezebox Server 7.5.3) Squeezebox Boom - Anywhere with an AC outlet SqueezeBox 3 (Slim version) > Bose Wave Radio - Kitchen Squeezebox Duet controller/receiver > Hafler 100 preamp > Hafler DH-220 amp > Sima SSW-L6 EX Speaker selector= Polk Audio Monitor70 Series II - Living Room, Definitive Tech ProMonitor 100 - Dining Room, Infinity US-1 - Porch 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Sorry I cannot help w your problem, but have some questions. Were you successful in running the full catalog,and if so how long did it take ? You say the full catalog brought your PC to its knees, what OS are you running and how much RAM ? How large is your library and what file type ? I am close to finishing the process of ripping,tagging etc and would like to run a printout of sorts. Thanks in advance for your response. -- dasmueller dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
I tried ACC 3.4 and the full catalog run drives my pc to it's knees. Searching threads here and checking program options but cannot seem to find anything mentioning running the Quick Ref only. Am I missing the obvious? Anyone have a suggestion? I really like the Quick Ref - is there some other program/CLI way to run a catalog like the quick ref in ACC? The full catalog is something I might run every once in awhile but the quick ref is great to check my tagging. Thanks to the author for the ACC program. Jim -- usbethjim 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
>However SBS 7.6 also provides an option to use the MySQL database. Not any more :-( Or rather, there may be support within 7.6 for MySQL, but not officially maintained by Logitech. The settings file can be modified to make it use MySQL, but there's no Advanced setting any more to switch DB engine. ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
SilverRS8;614237 Wrote: > > > However SBS 7.6 also provides an option to use the MySQL database. It > will be easy to modify ACC to support this scenario and hence this > support will be the first available after 7.6 release. I think this is no longer the case - since a fairly recent recent nightly build. Bob -- bobertuk 1 x Touch - SC 7.6.0 - SSOTS v4.91 1 x Radio 1 x Boom Lavry DA-10 DAC QNAP TS-509 3.3.6 build 1110T Starfish Pre-amp : Based on NAIM Heavily modified NAIM NAP 250 Power-amp Behringer DEQ2496 Linn Isobarik DMS bobertuk's Profile: http://forums.slimdevices.com/member.php?userid=30376 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
stehohrhase;614233 Wrote: > Are there any news - to use this tool with Squeezebox Server 7.6.0 ?? SBS 7.6 has a new database schema which requires ACC to be updated to become compatible. SBS 7.6 will also by default use the new SQlite database. SQlite is not made with multi-user & remote access in mind. For ACC to support it a number of possibilities need to be evaluated (like using a non-official ODBC driver or working with a local copy of the database file, ...) However SBS 7.6 also provides an option to use the MySQL database. It will be easy to modify ACC to support this scenario and hence this support will be the first available after 7.6 release. -- SilverRS8 Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for Squeezebox'_' (http://www.badkamerpech.nl)Server . 1xTouch, 1xSB3, 1xDuet, 1xRadio, 1xiPhone iPeng, Ubuntu NAS + SBS 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Are there any news - to use this tool with Squeezebox Server 7.6.0 ?? -- stehohrhase stehohrhase's Profile: http://forums.slimdevices.com/member.php?userid=36772 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
I'm running SC7.5.2 on a QNAP NAS. ACC fails to connect and I need more help understanding how to make it work. The instructions tell to install SQL ODBC drivers.. but where? On the NAS or on my Windows PC? I tried installing it on my Windows PC, but that doesn't help. Then it tells to edit a file called my.tt supposedly stored in a directory on the NAS named /usr/share/squeezeboxserver/MySQL However, there exists no such directory on my NAS...! Finally, nowhere does it say if all this is specific for a Squeezeserver using its own internal MySQL, or what if I'm using an external MySQL installation? I'm using the MySQL server that came with my NAS. Then where do I find this my.tt file? -- oyvindo oyvindo's Profile: http://forums.slimdevices.com/member.php?userid=19302 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Hi, nobody any ideas? But now the users of ACC and ReadyNAS can help me with the info, which MySQL version is used on their ReadyNAS. My NAS uses 5.0.32-Debian_7etch5 and this version leeds to issues with ACC. What is the right version and how to install (update) to that version? Regards, Christoph -- cne2 cne2's Profile: http://forums.slimdevices.com/member.php?userid=24171 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Hallo everybody, today I tried ACC version 3.4 but unfortunately i got the following error: Error while creating ACC table in database. Error number: -2147217887 Error Description: Der ODBC-Treiber unterstützt die angeforderte Eigenschaft nicht. I use the current 5.1 ODBC-Driver from the MySQL Page, and I use a ReadyNAS with allowed remote access. I followed the advices to adjust my readynas and the the Test-Button succeded! Does anybody have a clue? Thanks, Christoph -- cne2 cne2's Profile: http://forums.slimdevices.com/member.php?userid=24171 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Thank you very much for your answers. I have played around with the parameters and found that I get the most information on the least amount of space with 118 tracks per page, max. 5 album rows per page and then reducing to 80% when printing and cutting the border to almost zero. I use the album catalog on my cell phone while I'm in CD shops for example, that's why I need to cramp as much information into as little space as possible. The one main thing I really just don't understand though is why creating 'pages' when creating the HTML files really doesn't seem to correspond in any way to what actually happens when you print. (I understand that I probably just don't understand the technical background enough.) But in practice I'm assuming that this leads to most people (using the default settings) creating very ugly catalogs in PDF which usually look like this: One normal page, then one half filled page, then again one normal page, etc. etc. -- maximus maximus's Profile: http://forums.slimdevices.com/member.php?userid=41211 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Alas, it seems i have been able to partly find the solution for my problem myself. If I select one folder manually, it works. Is it not possible to use ACC if the music files are located on two separate physical drives? (The sound files are on two external HDDs.) -- maximus maximus's Profile: http://forums.slimdevices.com/member.php?userid=41211 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
I'm running ACC to run for the first time. I let it run for a couple of hours, and it seems to be stalling while 'Correcting incorrectly marked Various Artist albums...'. The window status bar says 'no response'. I restarted the programm, and the window actually says 'no response' when it is still 'Querying Squeezebox Server...', but then does move on to the step mentioned above. Do I just have to be more patient? Does it take hours just for the above mentioned step? And if it shouldn't, how can I deactivate that step? -- maximus maximus's Profile: http://forums.slimdevices.com/member.php?userid=41211 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
I've appended a screen shot of the tagging for the Robert Levin CD that I showed earlier. It looks correct to me. So I still suspect it is something in ACC. When I do a fresh SBS scan of my library, I get an album count of 2553. When I then run ACC, I get an album count of 2566, with a track count that matches SBS. So ACC sees 13 more albums than SBS does. By comparing the ACC Quick Reference with the SBS Music Folder display, I have identified exactly 13 situations where I have non-consecutive tracks from the same CD in the same folder, and ACC displays the non-consecutive tracks as separate albums. So this would account for the discrepancy in statistics. Using the "Use folder structure to determine albums" does not affect this non-consecutive track issue, but it does correctly handle the situation where a folder contains tracks from 2 CDs is displayed. (That happens when a long piece is split over two CDs and I re-combine the two parts as a single folder): When I set the "Use folder structure" option in ACC and ran it again, now I get an album count of 2550, so 16 less than without that option. All 13 of the 'non-consecutive tracks' folders are still displayed incorrectly as multiple albums, so the new lower album count is not due to that being corrected. However, comparing the two Quick Reference printouts, I can identify exactly 16 situations where I had tracks from two separate CDs in the same folder. These 16 two-CD folders are displayed as two albums in the 'regular' ACC (because the tracks are tagged as coming from two CDs) but with the "use folder structure" option, they are correctly shown as one album. So that option generally works right but still has the non-consecutive track problem. This is not a big problem for me, so don't waste a lot of time on it. I'm sure you have more important tasks to tackle. I just thought that it may be a simple coding thing where you break out a new album when the track number sequence is interrupted. If you can fix it, great, and if not, ACC is still a great program. Thanks, Swimmer +---+ |Filename: tags.jpg | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=10627| +---+ -- Swimmerbird123 Swimmerbird123's Profile: http://forums.slimdevices.com/member.php?userid=17285 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Swimmerbird123;577371 Wrote: > Yes, i've tried the "use folder structure" option and it doesn't seem to > make any difference. > > I've attached some screen shots to illustrate: > > The first (exampl5: Ligeti Vol. 6) shows the first situation I > mentioned. This CD is stored with Tracks 1-9 in one folder, Tracks 10 > and 12 in a second folder, Track 11 in a third folder all by itself, > and Tracks 13,14,15 in a fourth fodler. ACC incorrectly displays Tracks > 10 and 12 here as two albums, even though they are stored in the same > folder. The other folders are shown correctly. > > The second (exampl1: Robert Levin plays Mozart) shows the second > situation I mentioned. On the CD, Tracks 1-3 are one piece, Tracks 4-6 > are a second piece, and Track 7 is an alternate version of the movement > in Track 2. I have stored this CD as two folders, with Tracks 1,2,3,7 > in one folder and Tracks 4,5,6 in the other. Yet ACC breaks out Track > 7 as a separate album, even though it is stored in the same folder with > 1,2,3. > > The third (exampl4: disc 2 of a collection by Richter) shows a final > situation. The CD contains pieces by various composers, and I have > created a separate folder for each composer's tracks. I've grouped the > three Chopin tracks 10, 15, 16 in one folder, but ACC shows them as two > albums. > > Does this help? > > Swimmer ACC determines when to start a new album based on: 1. If the track resides in a different folder (this requires you to select the 'Use folder structure...' option in ACC) 2. If the album ID is different. I haven't tested it myself as it is not a common practice to split up an album over different folders but it appears that SBS assigns a different album ID for tracks in a different folder or the problem is tagging related. Can you post a screenshot of the tagging of one album? Is there a difference in a particular tagging field that can be related to this problem? -- SilverRS8 Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for Squeezebox'_' (http://www.badkamerpech.nl)Server . 1xTouch, 1xSB3, 1xDuet, 1xRadio, 1xiPhone iPeng, Ubuntu NAS + SBS 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
SilverRS8;577355 Wrote: > Hi Bob, > > Nope. ACC doesn't support v7.6 yet as SQLite requires a totally > different approach as it natively does not support remote access at > all. There is an ODBC driver out there and I expect to start > experimenting with it this week. Thanks 's for replying Frank. I'll keep a watch on your website for an SQLite version. Keep up the good work - ACC is invaluable and appreciated by a lot of users. Bob -- bobertuk 1 x Duet - SC 7.4.2 - SSOTS v4.1 1 x Boom Lavry DA-10 DAC QNAP TS-509 3.1.2 build 1014T Starfish Pre-amp : Based on NAIM Heavily modified NAIM NAP 250 Power-amp Behringer DEQ2496 Linn Isobarik DMS bobertuk's Profile: http://forums.slimdevices.com/member.php?userid=30376 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Yes, i've tried the "use folder structure" option and it doesn't seem to make any difference. I've attached some screen shots to illustrate: The first (exampl5: Ligeti Vol. 6) shows the first situation I mentioned. This CD is stored with Tracks 1-9 in one folder, Tracks 10 and 12 in a second folder, Track 11 in a third folder all by itself, and Tracks 13,14,15 in a fourth fodler. ACC incorrectly displays Tracks 10 and 12 here as two albums, even though they are stored in the same folder. The other folders are shown correctly. The second (exampl1: Robert Levin plays Mozart) shows the second situation I mentioned. On the CD, Tracks 1-3 are one piece, Tracks 4-6 are a second piece, and Track 7 is an alternate version of the movement in Track 2. I have stored this CD as two folders, with Tracks 1,2,3,7 in one folder and Tracks 4,5,6 in the other. Yet ACC breaks out Track 7 as a separate album, even though it is stored in the same folder with 1,2,3. The third (exampl4: disc 2 of a collection by Richter) shows a final situation. The CD contains pieces by various composers, and I have created a separate folder for each composer's tracks. I've grouped the three Chopin tracks 10, 15, 16 in one folder, but ACC shows them as two albums. Does this help? Swimmer +---+ |Filename: exampl4.jpg | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=10623| +---+ -- Swimmerbird123 Swimmerbird123's Profile: http://forums.slimdevices.com/member.php?userid=17285 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
Swimmerbird123;577227 Wrote: > I have a problem with the way ACC displays a folder with non-consecutive > tracks in it. Let me explain: > > My library is mostly classical music and I have arranged it generally > by piece rather than CD. So each piece of music, which typically has > multiple movements that are each a separate track in its separate file, > is in its own folder. Each track is still tagged with the CD name as > its album name and the tracks retain the original track numbering from > the CD, but otherwise, the CD structure is more or less ignored. > > For example, a CD may contain 3 different sonatas each of which has 4 > movements, but I store each sonata in its own folder, so that a folder > named "Sunshine Sonata" may contain only tracks 5,6,7 and 8 from the > original CD, and all are tagged with the CD name as the album name. > > Usually ACC handles this in an appropriate way - it sees each folder as > a separate album and displays the CD name (from the album tag) as the > album name. In the example above, that yields three albums in the > catalog with the same name, but with each containing a different > sonata. That is OK for me. > > My problem is that if the folder contains tracks that are numbered > non-consecutively, ACC splits the folder into multiple folders > according to the track numbers. So a single folder that contains only > tracks 10 and 12 from a CD is displayed by ACC as two albums, each with > one track, while SBS displays this correctly as one album with two > tracks. Or a folder with three consecutively numbered track and a 4th > non-consecutive track (e.g. an alternate ending for the piece) is > displayed by ACC as two albums, one with the three consecutive tracks > and one with the non-consecutive 4th, even though SBS includes all four > tracks as one album. > > Is it possible for ACC to handle these situations differently, or would > I need to go in and re-tag the track numbers to get the desired tracks > treated as one album? > > Thanks for a great program, > Swimmer Hi Swimmer, I think I get the picture. As your situation would more be folder based than Album based, did you try the 'Use folder structure to distinguish albums' setting in the advanced settings screen in ACC? If this does not help, please post a screenshot as a picture tells more than 1000 words. Regards, Frank -- SilverRS8 Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for Squeezebox'_' (http://www.badkamerpech.nl)Server . 1xTouch, 1xSB3, 1xDuet, 1xRadio, 1xiPhone iPeng, Ubuntu NAS + SBS 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
bobertuk;574476 Wrote: > Hi Frank, > > I've been trying to get ACC working with SbS 7.6 SQLite but can't get a > server connection when I use server options "Test". Is ACC set up to use > SQLite yet? > > Many thanks, > > Bob Hi Bob, Nope. ACC doesn't support v7.6 yet as SQLite requires a totally different approach as it natively does not support remote access at all. There is an ODBC driver out there and I expect to start experimenting with it this week. -- SilverRS8 Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for Squeezebox'_' (http://www.badkamerpech.nl)Server . 1xTouch, 1xSB3, 1xDuet, 1xRadio, 1xiPhone iPeng, Ubuntu NAS + SBS 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
fphredd;572188 Wrote: > Frank, > > Yet another question... > > In the Quick Reference, is it possible for multi-disc 'albums' to only > be listed under the title once as opposed to: > > Album name > Album name Disc 2 > > In SBS I have the setting under 'Group Discs' as 'Treat multi-disc sets > as a single album' > > Thanks, as usual. First of all sorry for my late reaction but it appears the e-mail notification on this thread does not process all new entries. I've put it on my todo list for the next version. Regards, Frank -- SilverRS8 Author of -'AlbumCatalogCreator' (http://acc.vanholt.nl)- for Squeezebox'_' (http://www.badkamerpech.nl)Server . 1xTouch, 1xSB3, 1xDuet, 1xRadio, 1xiPhone iPeng, Ubuntu NAS + SBS 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 discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Announce: Album Catalog Creator v3
I have a problem with the way ACC displays a folder with non-consecutive tracks in it. Let me explain: My library is mostly classical music and I have arranged it generally by piece rather than CD. So each piece of music, which typically has multiple movements that are each a separate track in its separate file, is in its own folder. Each track is still tagged with the CD name as its album name and the tracks retain the original track numbering from the CD, but otherwise, the CD structure is more or less ignored. For example, a CD may contain 3 different sonatas each of which has 4 movements, but I store each sonata in its own folder, so that a folder named "Sunshine Sonata" may contain only tracks 5,6,7 and 8 from the original CD, and all are tagged with the CD name as the album name. Usually ACC handles this in an appropriate way - it sees each folder as a separate album and displays the CD name (from the album tag) as the album name. In the example above, that yields three albums in the catalog with the same name, but with each containing a different sonata. That is OK for me. My problem is that if the folder contains tracks that are numbered non-consecutively, ACC splits the folder into multiple folders according to the track numbers. So a single folder that contains only tracks 10 and 12 from a CD is displayed by ACC as two albums, each with one track, while SBS displays this correctly as one album with two tracks. Or a folder with three consecutively numbered track and a 4th non-consecutive track (e.g. an alternate ending for the piece) is displayed by ACC as two albums, one with the three consecutive tracks and one with the non-consecutive 4th, even though SBS includes all four tracks as one album. Is it possible for ACC to handle these situations differently, or would I need to go in and re-tag the track numbers to get the desired tracks treated as one album? Thanks for a great program, Swimmer -- Swimmerbird123 Swimmerbird123's Profile: http://forums.slimdevices.com/member.php?userid=17285 View this thread: http://forums.slimdevices.com/showthread.php?t=74452 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
