Re: [slim] Slimserver Database Question
jonheal;269337 Wrote: The main reason I haven't upgraded is that I put together a considerable amount of scripting to link what is going on with the Squeezebox to our web site and I also modified the Perl of a plug-in I use. It looked like upgrading would require much gutting of code, and I just wasn't in the mood after all of the effort it took to get things working in the first place. So I'll stick with obsolescence for a bit longer. I'll post a link to my music listing for the morbidly curious if and when I get it working. I managed to build live listings of our music on our web site by querying Slimserver's database. Listing the FLAC albums the way I wanted was pretty challenging and required adding numerous views to the database. I wrote about the project here: http://www.theheals.org/jon/more_from_slimserver_1.asp ... and the listings can be veiwed here: http://www.theheals.org/miscellanea/sights_sounds.asp -- jonheal Jon Heal says: Have a nice day! http://www.theheals.org/ ~~~ SB3 (wired - 6.3.1) | Home-brew PC running XP Pro | DENON DRA-395 | PSB Stratus Bronze (2) | Outlaw Audio LFM-2 (1) | DIY Speaker Cables | Dayton Audio Interconnects jonheal's Profile: http://forums.slimdevices.com/member.php?userid=2133 View this thread: http://forums.slimdevices.com/showthread.php?t=43436 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] Slimserver Database Question
So, do you actually have BAND and ALBUM ARTIST tags in your files, and is Slimserver ignoring them? If that's your problem you might need to say more about the files types, and the exact tag names you are using. For example, in FLAC afaik ORCHESTRA is not recognised - it has to be BAND (thats the subject of an enhancement request I raised a long time ago). And I seem to recall there being something about ALBUM ARTIST vs ALBUMARTIST, but I could be wrong. You shouldn't need to check the include ... in artists boxes just to have the tags scanned. As for the virus scanning problem, IIRC that was a problem with McAfee blocking Slimserver from the MySql database, which was easily resolvable by telling McAfee to ignore database files. Or are you thinking of something else? Anyway, 6.5 itself will soon be history, we're about to move on to 7.0. So if I were you I'd hold off a little longer and then try it out - you might be surprised by how much has changed for the better. HTH -- ceejay ceejay's Profile: http://forums.slimdevices.com/member.php?userid=148 View this thread: http://forums.slimdevices.com/showthread.php?t=43436 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] Slimserver Database Question
ceejay;269204 Wrote: So, do you actually have BAND and ALBUM ARTIST tags in your files, and is Slimserver ignoring them? If that's your problem you might need to say more about the files types, and the exact tag names you are using. For example, in FLAC afaik ORCHESTRA is not recognised - it has to be BAND (thats the subject of an enhancement request I raised a long time ago). And I seem to recall there being something about ALBUM ARTIST vs ALBUMARTIST, but I could be wrong. You shouldn't need to check the include ... in artists boxes just to have the tags scanned. As for the virus scanning problem, IIRC that was a problem with McAfee blocking Slimserver from the MySql database, which was easily resolvable by telling McAfee to ignore database files. Or are you thinking of something else? Anyway, 6.5 itself will soon be history, we're about to move on to 7.0. So if I were you I'd hold off a little longer and then try it out - you might be surprised by how much has changed for the better. HTH The main reason I haven't upgraded is that I put together a considerable amount of scripting to link what is going on with the Squeezebox to our web site and I also modified the Perl of a plug-in I use. It looked like upgrading would require much gutting of code, and I just wasn't in the mood after all of the effort it took to get things working in the first place. So I'll stick with obsolescence for a bit longer. I'll post a link to my music listing for the morbidly curious if and when I get it working. -- jonheal Jon Heal says: Have a nice day! http://www.theheals.org/ ~~~ SB3 (wired - 6.3.1) | Home-brew PC running XP Pro | DENON DRA-395 | PSB Stratus Bronze (2) | Outlaw Audio LFM-2 (1) | DIY Speaker Cables | Dayton Audio Interconnects jonheal's Profile: http://forums.slimdevices.com/member.php?userid=2133 View this thread: http://forums.slimdevices.com/showthread.php?t=43436 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] Slimserver Database Question
If it doesn't appear in the DB then it must be getting pulled directly from the file when listing the details of that track. -- funkstar funkstar's Profile: http://forums.slimdevices.com/member.php?userid=2335 View this thread: http://forums.slimdevices.com/showthread.php?t=43436 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] Slimserver Database Question
I'm working around the problem by adding orchestra information in the Comments tag, which also appears in the albums table. -- jonheal Jon Heal says: Have a nice day! http://www.theheals.org/ ~~~ SB3 (wired - 6.3.1) | Home-brew PC running XP Pro | DENON DRA-395 | PSB Stratus Bronze (2) | Outlaw Audio LFM-2 (1) | DIY Speaker Cables | Dayton Audio Interconnects jonheal's Profile: http://forums.slimdevices.com/member.php?userid=2133 View this thread: http://forums.slimdevices.com/showthread.php?t=43436 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] Slimserver Database Question
6.3.1 was a long time ago and the rest of us have moved over to MySql ... but I'd have thought that the table structure might have been similar: have you looked for a Contributor table? AFAIK Conductor and AlbumArtist appear as Contributors, with an attribute that tells you what kind of contributor they are. HTH Ceejay -- ceejay ceejay's Profile: http://forums.slimdevices.com/member.php?userid=148 View this thread: http://forums.slimdevices.com/showthread.php?t=43436 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] Slimserver Database Question
ceejay;269113 Wrote: 6.3.1 was a long time ago and the rest of us have moved over to MySql ... but I'd have thought that the table structure might have been similar: have you looked for a Contributor table? AFAIK Conductor and AlbumArtist appear as Contributors, with an attribute that tells you what kind of contributor they are. HTH Ceejay My Contributors table contains items associated with three contributor roles: in my case, items that correspond to the tags: artist, composer and conductor. There is an option to include conductors and orchestras/bands in the Squeezebox's Artist menu, but I have not checked those options because they make the Artist menu too verbose. If they were checked, Slimserver might add more data to the contributors table, but I'm not going to do it for the reason previously stated. As it is, kluging the Comments tag will work fine for me, I think. Yes, I realize I'm still in the dark ages, Slimerver-wise, but 6.3.1 is serving me well. No complaints. Was the conflict between 6.5.x and anti-virus software ever resolved? -- jonheal Jon Heal says: Have a nice day! http://www.theheals.org/ ~~~ SB3 (wired - 6.3.1) | Home-brew PC running XP Pro | DENON DRA-395 | PSB Stratus Bronze (2) | Outlaw Audio LFM-2 (1) | DIY Speaker Cables | Dayton Audio Interconnects jonheal's Profile: http://forums.slimdevices.com/member.php?userid=2133 View this thread: http://forums.slimdevices.com/showthread.php?t=43436 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
