Re: [slim] Document your collection
DJanGo wrote: > No problem :o > > i am just a poor guy that even shortens all unneeded languages from the > strings.txt - > > *That* saves a bit space and added such a huge amount of response time > you cant really count :rolleyes: > And i am quite as old as your avatar loks like- when i was young 640 k > should be enough for everybody - (Yes i know its NOT Billy who say/wrote > this) > btw: did you recon the car from my avatar? Should be some in surrey as > well > > > But the truth behind that is just simple: > If you stop the logitechmediaserver (what reason ever you have to) the > filestamp from the library.db changes - so its tricky to find out "is > there is a reason to update the documentation?" > > I'd love to let my pcs do stuff for me on their own (sheduled tasks / > cronjobs) - cause i am lazy like hell Hi there, yes I come from the *640k is enough for anyone* era but times change. We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
pkfox wrote: > Don't see the point all your doing is saving a bit of space which you > can achieve by deleting the copy when you're done No problem :o i am just a poor guy that even shortens all unneeded languages from the strings.txt - *That* saves a bit space and added such a huge amount of response time you cant really count :rolleyes: Gruss Jan DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
DJanGo wrote: > > But the truth behind that is just simple: > If you stop the logitechmediaserver (what reason ever you have to) the > filestamp from the library.db changes - so its tricky to find out "is > there is a reason to update the documentation?" > > I'd love to let my pcs do stuff for me on their own (sheduled tasks / > cronjobs) - cause i am lazy like hell Surely you know if you've added new music so know when to do a documentation update. steve-g's Profile: http://forums.slimdevices.com/member.php?userid=52057 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
steve-g wrote: > Surely you know if you've added new music so know when to do a > documentation update. Precisely Steve and it takes a matter of minutes to copy the database and run the documenter - this is a classic case of *if it ain't broke fix it till it is* We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
DJanGo wrote: > > > btw: did you recon the car from my avatar? Should be some in surrey as > well > > A Mini Moke? "To try to judge the real from the false will always be hard. In this fast-growing art of 'high fidelity' the quackery will bear a solid gilt edge that will fool many people" - Paul W Klipsch, 1953 Julf's Profile: http://forums.slimdevices.com/member.php?userid=42050 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
pkfox wrote: > Precisely Steve and it takes a matter of minutes to copy the database > and run the documenter - this is a classic case of *if it ain't broke > fix it till it is* Forget about that stripdown :eek: you see me really impressed :o I should investigate that - i (better the *tux wrapper i made) need ~20 minutes for this task (refreh documentation) :confused: Anyway have a nice day:o Gruss Jan DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
DJanGo wrote: > @julf Yapp an early MKi Excellent! Great fun! I go for slightly larger ones: 19344 That picture was taken in 1999, waiting for Harwich-Hook of Holland ferry - imagine driving up to customs and immigration like that in 2015... :) +---+ |Filename: 74d7c9u-960.jpg | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=19344| +---+ "To try to judge the real from the false will always be hard. In this fast-growing art of 'high fidelity' the quackery will bear a solid gilt edge that will fool many people" - Paul W Klipsch, 1953 Julf's Profile: http://forums.slimdevices.com/member.php?userid=42050 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
@ dasmueller: its frustrating to see someone that has an idea realized that idea and decides to share his idea even when that means he has a lot more to to than just use his thing for his own purposes and some other jump on the train and ask for impossible or senseless things... @pkfox: I realized that there is some interest for an "offline collection Dokumentation" and i decided to re-animate my own way to solve this (cause in my private hours i am a Linux User i cant just use your Tool) Even without knowing exactly what your doing - i may have a tip for you and the guys that use your Tool. "My" way to get a offline Dokumentation of my collection just needs two tables out of the library.db. - contributors - albums I dont know which tables you use but instead of copying the whole library.db (if someone has to cause using a headless dedicated lms Server) Should be simple as eg: $lms_offline_db is my var for the filename under Windows it must be something like %lms_offline_db% rm is the same as del under *blows - dont "dump" the same tables into your offline_db twice Code: rm $lms_offline_db sqlite3 /var/lib/squeezeboxserver/cache/library.db ".dump albums"|sqlite3 $lms_offline_db sqlite3 /var/lib/squeezeboxserver/cache/library.db ".dump contributors"|sqlite3 $lms_offline_db After that you end up with a smaller database file if you need to copy that from your dedicated lms Server. In my case the shortend library is just 2.8 MB instead of 118 MB. Feel free to adapt this idea. Gruss Jan DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
DJanGo wrote: > @ dasmueller: > its frustrating to see someone that has an idea realized that idea and > decides to share his idea even when that means he has a lot more to to > than just use his thing for his own purposes and some other jump on the > train and ask for impossible or senseless things... > > @pkfox: > I realized that there is some interest for an "offline collection > Dokumentation" and i decided > to re-animate my own way to solve this (cause in my private hours i am a > Linux User i cant just use your Tool - and cause of my ego i wont > *lol*) > > Even without knowing exactly what your doing - i may have a tip for you > and the guys that use your Tool. > > "My" way to get a offline Dokumentation of my collection just needs two > tables out of the library.db. > > > > - contributors - albums > > > > > I dont know which tables you use but instead of copying the whole > library.db (if someone has to cause using a headless dedicated lms > Server) > Should be simple as eg: > $lms_offline_db is my var for the filename under Windows it must be > something like %lms_offline_db% > rm is the same as del under *blows - > dont "dump" the same tables into your offline_db twice - deleting the > offline_db before the dump is the simplest way to solve this > > > Code: > > > rm $lms_offline_db > sqlite3 /var/lib/squeezeboxserver/cache/library.db ".dump albums"|sqlite3 $lms_offline_db > sqlite3 /var/lib/squeezeboxserver/cache/library.db ".dump contributors"|sqlite3 $lms_offline_db > > > > > the mimic from that is: > sqlite3 source_db ".dump contributors"|sqlite3 destination_db > > After that you end up with a smaller database file if you need to copy > that from your dedicated lms Server. > In my case the shortend library is just 2.8 MB instead of 118 MB. > > Feel free to adapt this idea and add the needed tables somewhere her > to others that might uses that. Don't see the point all your doing is saving a bit of space which you can achieve by deleting the copy when you're done We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
DJanGo wrote: > Forget about that stripdown > > :eek: you see me really impressed :o > > I should investigate that - i (better the *tux wrapper i made) need ~20 > minutes for this task (refreh documentation) :confused: > > Anyway have a nice day:o > > @julf Yapp an early MKi And you :-) We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Playing around in Mp3Tag I found one can insert a column that gives the date created. %_file_create_date% it gives the date created not date modified. If there were a way to then search the database by a date range that used that tag field that would be pretty nice dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
dasmueller wrote: > I'd be happy to try it if I know what I might need to do. > > And thanks. All it will do is retrieve music added on or after the date you choose - as I said earlier if you ever clear your library when you scan it's not of any real use, I've tried it and honestly can't see the point of it. We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
dasmueller wrote: > If there were a way to then search the database by a date range that > used that tag field that would be pretty nice did you check the point? adding a idv3tag to a file to get the creation time of this file? 19339 did you ever check'd the library.db from lms? lms DOESNT store ALL tags in the DB... +---+ |Filename: tischkante.gif | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=19339| +---+ Gruss Jan DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
I'd be happy to try it if I know what I might need to do. And thanks. dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
DJanGo wrote: > did you check the point? > adding a idv3tag to a file to get the creation time of this file? > 19339 > > did you ever check'd the library.db from lms? > lms DOESNT store ALL tags in the DB... I'm sorry I brought it up and frustrated you so much but if people never asked for improvements little would get improved or invented. Please consider my request/question closed. dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
DJanGo wrote: > did you check the point? > > I do not understand this question > > > adding a idv3tag to a file to get the creation time of this file? > what I mentioned above displays this > 19339 > > did you ever check'd the library.db from lms? > Don't know how to-I never purported to be a wizard at this stuff. > > lms DOESNT store ALL tags in the DB... I don't know why you expend so much energy being frustrated. If people didn't ask questions/request things not much would ever get improved or invented. dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
dasmueller wrote: > Now, if there was a way to run this with it only showing what was added > after a certain date that might be cool as well. Sort of a catalog > update function. Hi there, I've had a look at the database and the only field that I can see that might be useful for this is *added_time* which is in the tracks table but I think this would only be helpful if you ran a rescan *new or changed media files* as clearing the library would lose all the history. Let me know if you want to try this. We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
dasmueller wrote: > pkfox knew what I was speaking about. In no place did I mention > timestamp until you brought it up. What Jan means is that the only way of determining when something was added would be by way of the file timestamp. As this would not always be the date you actually added the file to the LMS library the "all files added since ddmmyy" routine would not always be accurate. If for example you today correct a tag in a file that you might have added in 2010 the timestamp is going to be today. Indeed LMS itself will bring the album to the top of the New Music menu for exactly this reason. *Vortexbox LMS 7.8 music on QNAP TS419p via NFS* iThingys/iPeng/Tablets *Living Room* - SB3 -> Onkyo TS606 - > Celestion Ditton F20s - Zone 2 -> Sony TA FE 320 -> Sennheiser RS 130 & B P7 *Office* - RPi -> Sony TA FE320 -> Celestion F10s / SB3 -> Onkyo CRN 755 -> Wharfedale Modus Cubes *Dining Room* -> SB Boom *Kitchen* -> UE Radio (upgraded to SB Radio) *Bedroom (Bedside)* - SB Touch -> Topping TP21 -> AKG Headphones *Bedroom (TV)* - Amazon Fire TV (SB Player) -> Topping TP20 -> Wharfedale Modus Cubes d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
pkfox wrote: > ...as to why my app works on your server but not on your workstation - > what OS do they run ? Also please mention the bitness 32/64. Thanks for > the feedback. server: windows 7 32 bit, laptop: windows 10 64 bit Living Room: Squeezebox v3 (Wired), Pioneer Elite VSX 80, KEF Q100's, Energy Encore center, subwoofer, surrounds Dining Room: Paradigm Atom Monitor v.5 Anywhere Else As Needed: Boom Router: Asus RT-N56U Server: LMS Version 7.9, Dell Laptop (Wired), Windows 7 Home Fahzz's Profile: http://forums.slimdevices.com/member.php?userid=12585 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
>From looking at folders in Windows Explorer they all have a date created associated w them. That does not change when one modifies the folder name. Although not perfect it is a better source of info for dating purposes than date modified. Whether there is a way to get the app to use that info or not and the effort entailed to do so is another story. dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
dasmueller wrote: > Just thought it might be nice but not that big a deal. Hmm its the same story like the "my artist count is wrong"... And if you want something like a new feature - you should know what you want. Gruss Jan DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
pkfox knew what I was speaking about. In no place did I mention timestamp until you brought it up. dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
dasmueller wrote: > exactly ! And what is the Reason for this? I may not remember what i bought two years ago - but i know what i bought 2Months ago. And what exact do you mean? Timestamp from the File or adding time to the lib? You may know that these timestamps didnt tell the truth under all circumstances! dasmueller wrote: > exactly ! Gruss Jan DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
pkfox wrote: > Strange - what did you load to the server ? the library or the software > or both ? I installed the app on the server machine, copied the library to the desktop on the same machine, ran the app, and it gave me the pdf, which I then copied to my laptop. Not sure why it worked, and didn't before. Let me know if you want more information. Keep in mind I only know enough about technology to be dangerous. BTW: Your signature line conversation ends, if memory serves "They'll see them soon enough"? Yes? Living Room: Squeezebox v3 (Wired), Pioneer Elite VSX 80, KEF Q100's, Energy Encore center, subwoofer, surrounds Dining Room: Paradigm Atom Monitor v.5 Anywhere Else As Needed: Boom Router: Asus RT-N56U Server: LMS Version 7.9, Dell Laptop (Wired), Windows 7 Home Fahzz's Profile: http://forums.slimdevices.com/member.php?userid=12585 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Now, if there was a way to run this with it only showing what was added after a certain date that might be cool as well. Sort of a catalog update function. dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
dasmueller wrote: > Now, if there was a way to run this with it only showing what was added > after a certain date that might be cool as well. Sort of a catalog > update function. Hi there, do you mean produce a document showing music that was added on or after a certain date ? We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
exactly ! dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
DJanGo wrote: > And what is the Reason for this? > > I may not remember what i bought two years ago - but i know what i > bought 2Months ago. > > And what exact do you mean? > Timestamp from the File or adding time to the lib? > You may know that these timestamps didnt tell the truth under all > circumstances! The reason is to be able to produce a file which shows updates to the library. What the process/technical way to do it I do not know as I am not proficient in how the whole system works from a programming perspective. Just thought it might be nice but not that big a deal. I think I understand your comment about timestamps which as I understand it would then segregate from when files were modified, not when added. dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Fahzz wrote: > I installed the app on the server machine, copied the library to the > desktop on the same machine, ran the app, and it gave me the pdf, which > I then copied to my laptop. > > Not sure why it worked, and didn't before. Let me know if you want more > information. Keep in mind I only know enough about technology to be > dangerous. > > BTW: Your signature line conversation ends, if memory serves "They'll > see them soon enough"? Yes? It's from a different part of the book ( Fear and Loathing ) but yes it's linked, as to why my app works on your server but not on your workstation - what OS do they run ? Also please mention the bitness 32/64. Thanks for the feedback. We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Fahzz wrote: > Got it to work. I loaded it on to the server box, and all is well. Nice > work on this. Strange - what did you load to the server ? the library or the software or both ? We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Got it to work. I loaded it on to the server box, and all is well. Nice work on this. Living Room: Squeezebox v3 (Wired), Pioneer Elite VSX 80, KEF Q100's, Energy Encore center, subwoofer, surrounds Dining Room: Paradigm Atom Monitor v.5 Anywhere Else As Needed: Boom Router: Asus RT-N56U Server: LMS Version 7.9, Dell Laptop (Wired), Windows 7 Home Fahzz's Profile: http://forums.slimdevices.com/member.php?userid=12585 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
I installed this, and when I run it, I get an accurate artist/ album /track count, but no .pdf document is produced. Any suggestions? Living Room: Duet (Wired), Pioneer Elite VSX 80, KEF Q100's, Energy Encore center, subwoofer, surrounds Dining Room: Paradigm Atom Monitor v.5 Anywhere Else As Needed: Boom Router: Asus RT-N56U Server: LMS Version 7.9, Dell Laptop (Wired), Windows 7 Home Fahzz's Profile: http://forums.slimdevices.com/member.php?userid=12585 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Where do you see the counts ? Do you have a program installed for PDF's ? I assume you have checked where you told the app to save the program ? I know, stupid questions but details help. dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
dasmueller wrote: > Where do you see the counts ? > > In the app interface. > > > Do you have a program installed for PDF's ? > > Adobe Acrobat. > > > I assume you have checked where you told the app to save the program ? > > > Yes. > > I know, stupid questions but details help. no such thing as a stupid question. I'm on Windows 10, and I'm trying to do this on a laptop, not the same computer as the server. Copied local copy of library.db to the laptop Living Room: Duet (Wired), Pioneer Elite VSX 80, KEF Q100's, Energy Encore center, subwoofer, surrounds Dining Room: Paradigm Atom Monitor v.5 Anywhere Else As Needed: Boom Router: Asus RT-N56U Server: LMS Version 7.9, Dell Laptop (Wired), Windows 7 Home Fahzz's Profile: http://forums.slimdevices.com/member.php?userid=12585 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Fahzz wrote: > I installed this, and when I run it, I get an accurate artist/ album > /track count, but no .pdf document is produced. Any suggestions? Weird, have you checked the directory you selected to save in ? We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
The idea of using the LMS cli interface is fine for those who run LMS on a PC or similar - for those of us that run it on a 'small' computer such as a pi or Wandboard this is not very practical. The approach used by pkfox of directly querying the db seems the right method in these cases as it's easy to copy over the db to generate the album / track list rather than trying to get the o/p from lms over to the PC to do the same thing. (Unless I'm missing something) I take the number of artists listed by LMS with a farly large pinch of salt as it includes all types of tag data that I would not normally consider as an artist for the type of music it refers to (such as composer for non-classical music) so can't see the attraction of trying to replicate it! steve-g's Profile: http://forums.slimdevices.com/member.php?userid=52057 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
The idea of using the LMS cli interface is fine for those who run LMS on a PC or similar - for those of us that run it on a 'small' computer such as a pi or Wandboard this is not very practical. Why not? It's what the devices do, it's what iPeng and others do. It's one of the main tasks of LMS to respond to queries about its music library. And you're not doing this all day long, do you? You grab the data, print it, done. And in a few days or weeks you'll repeat the procedure. I don't see the problem. -- Michael ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
mherger wrote: > > The idea of using the LMS cli interface is fine for those who run LMS > on > > a PC or similar - for those of us that run it on a 'small' computer > such > > as a pi or Wandboard this is not very practical. > > Why not? It's what the devices do, it's what iPeng and others do. It's > one of the main tasks of LMS to respond to queries about its music > library. And you're not doing this all day long, do you? You grab the > data, print it, done. And in a few days or weeks you'll repeat the > procedure. I don't see the problem. > > -- > > Michael Point taken - It's probably my lack of understanding of how the interface works / transfers data for not seeing this. steve-g's Profile: http://forums.slimdevices.com/member.php?userid=52057 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
http://localhost:9000/html/docs/cli-api.html?player=#DB Sure, but this is not what pkfox is looking for. He needs a way to retrieve all tracks with the info on what album the tracks belong to. I would be very surprised if a CLI command, or even a sequence of CLI commands, would export the entire library. How do you expect does LMS send all the albums lists etc. to the player UI or iPeng or whatnot? Of course this is possible with the CLI. Just read the documentation about the various parameters you can use to get additional data for eg. tracks. Or get the full list of albums and iterate over it to get tracks album by album. It's all in there. Probably not as fast as raw SQL, but this shouldn't matter for this use case. Plus it doesn handle all the LMS settings the way LMS does for all the other UIs. I guess the best way to achieve that is by accessing the DB directly. No, that's definitely not the best way. It's a waste of time, because you'd have to re-implement LMS' logic. Concentrate on your application and let LMS deal with the gory database stuff. -- Michael ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
dasmueller wrote: > pkfox- I removed all of my mp3 files from my library and then did a Look > for new and changed media scan. I then ran your app. Artist count was > still different so I am thinking it's something other than tags in mp3 > files. Also did a search for ALBUM_ARTIST and COMPOSER tags in my FLAC > library-none there. I did remove a bunch of extraneous/extended tags > from my mp3 files so that was a good thing. > > I guess I'm not all that concerned about the small discrepancy in > counts. I think your app is great and thanks for sharing. Thank you We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
mherger wrote: > >> http://localhost:9000/html/docs/cli-api.html?player=#DB[color=blue]] > > No, that's definitely not the best way. It's a waste of time, because > you'd have to re-implement LMS' logic. Concentrate on your application > and let LMS deal with the gory database stuff. > I just wanted my document to mirror the *actual* content of anyone's collection - if I just use LMS CLI calls for counts they would not be an accurate reflection of the document We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
dasmueller wrote: > pkfox- I removed all of my mp3 files from my library and then did a Look > for new and changed media scan. I then ran your app. Artist count was > still different so I am thinking it's something other than tags in mp3 > files. Also did a search for ALBUM_ARTIST and COMPOSER tags in my FLAC > library-none there. I did remove a bunch of extraneous/extended tags > from my mp3 files so that was a good thing. > > I guess I'm not all that concerned about the small discrepancy in > counts. I think your app is great and thanks for sharing. Hi , I think its always better to clear the library and rescan - removes a little bit of doubt We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Pascal Hibon wrote: > Hi Michael, > How would one let LMS do the counting; is there an SQL query that would > provide such output? There should be a CLI command to request this information from LMS. reinholdk's Profile: http://forums.slimdevices.com/member.php?userid=36070 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
mherger wrote: > > Can anybody define how LMS actually calculates the Artist Count? > > Why would you do the counting yourself? Let LMS do it for you, then you > > don't have to know about the innards :-). > Hi Michael, How would one let LMS do the counting; is there an SQL query that would provide such output? 'M-DAC' (http://www.audiolab.co.uk/M-DAC%20Series.aspx?lang=En) -> 'Focal MP1200' (http://www.mp1200.co.nf/) -> 'Focal Electra 1028 Be' (http://www.focal.com/en/electra-1000-be-2/209-electra-1028-be-3544053695099.html) 1 x SB3, 1 x SB Boom, 1 x SB Radio and 2 x SB Touch - all wireless 2 x Wandboard Dual, 1 x Wandboard Quad ReadyNAS NVX running LMS 7.9.0. iPeng on iPhone, SqueezePad & iPeng on iPad. http://www.last.fm/user/phibon Pascal Hibon's Profile: http://forums.slimdevices.com/member.php?userid=7969 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
i just realized that in my last post i said "app" and didn't specify! i meant LMS, not the new cataloguer! it is LMS which baffles me at being so imprecise with counts... that bug is older but it may be one Michael is willing to tackle now. perhaps i will rerun the experiments and do the screenshots as described in the bug. using: win7 64 + lms 7.9 & duet & ipads w/the logitech app, and ipeng on an ipod http://wiki.slimdevices.com/index.php/various_artists_logic & http://wiki.slimdevices.com/index.php/compilations BJW's Profile: http://forums.slimdevices.com/member.php?userid=58242 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Can anybody define how LMS actually calculates the Artist Count? Why would you do the counting yourself? Let LMS do it for you, then you don't have to know about the innards :-). Because the number of artists depends heavily on your LMS settings: what are artists or contributors? Should band, conductor, composer etc. be counted or not? You can't get the number identical to LMS' count without re-implementing all those conditions. (similar arguments apply to track/album count) -- Michael ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
mherger wrote: > Why would you do the counting yourself? Let LMS do it for you, then you > > don't have to know about the innards :-). > > Because the number of artists depends heavily on your LMS settings: what > > are artists or contributors? Should band, conductor, composer etc. be > counted or not? You can't get the number identical to LMS' count without > > re-implementing all those conditions. Michael, please look at the bug i posted. there are times LMS disagrees with itself even when settings are NOT changed. using: win7 64 + lms 7.9 & duet & ipads w/the logitech app, and ipeng on an ipod http://wiki.slimdevices.com/index.php/various_artists_logic & http://wiki.slimdevices.com/index.php/compilations BJW's Profile: http://forums.slimdevices.com/member.php?userid=58242 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
> > If you want the real, one and only truth, you'll have to explain your > rules of truth, not try to understand LMS' :-) > Michael Good point, I don't think I realised the level of customisation ( because I leave everything set at default ) available in LMS which obviously affects counts et al. Thanks for your comments. We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
mherger wrote: > >Please try to reproduce in 7.9 first. i will gladly do so, and i encourage others to do so. it may take me a few weeks though, i'm not home. if the effort is made, i hope this time it yields results. using: win7 64 + lms 7.9 & duet & ipads w/the logitech app, and ipeng on an ipod http://wiki.slimdevices.com/index.php/various_artists_logic & http://wiki.slimdevices.com/index.php/compilations BJW's Profile: http://forums.slimdevices.com/member.php?userid=58242 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Michael, please look at the bug i posted. there are times LMS disagrees with itself even when settings are NOT changed. That bug report was filed more than seven years ago. LMS 7.4. We're at 7.9 now, and not only did we fix quite a few bugs in the meantime, but the whole browsing has seen a lot of unifying. Please try to reproduce in 7.9 first. -- Michael ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
There should be a CLI command to request this information from LMS. info total artists ? http://localhost:9000/html/docs/cli-api.html?player=#DB -- Michael ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
I just wanted my document to mirror the *actual* content of anyone's collection - if I just use LMS CLI calls for counts they would not be an accurate reflection of the document That's not true. Because there's no such thing as the "actual" content, other than the number of files on your disc. But then don't rely on LMS' database, because it does apply rules configured by the user. There's no such thing as THE number of artists unless you specify what you consider an artist. etc. If you want the real, one and only truth, you'll have to explain your rules of truth, not try to understand LMS' :-) -- Michael ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
pkfox wrote: > Hi there, as I said in another post I noticed that mp3 files have extra > tag info that might affect how they are classified. pkfox- I removed all of my mp3 files from my library and then did a Look for new and changed media scan. I then ran your app. Artist count was still different so I am thinking it's something other than tags in mp3 files. Also did a search for ALBUM_ARTIST and COMPOSER tags in my FLAC library-none there. I did remove a bunch of extraneous/extended tags from my mp3 files so that was a good thing. I guess I'm not all that concerned about the small discrepancy in counts. I think your app is great and thanks for sharing. dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
mherger wrote: > > There should be a CLI command to request this information from LMS. > > info total artists ? > > http://localhost:9000/html/docs/cli-api.html?player=#DB > > -- > > Michael Sure, but this is not what pkfox is looking for. He needs a way to retrieve all tracks with the info on what album the tracks belong to. I would be very surprised if a CLI command, or even a sequence of CLI commands, would export the entire library. I guess the best way to achieve that is by accessing the DB directly. But as you mentioned, even that will be very hard since LMS is very configurable. 'M-DAC' (http://www.audiolab.co.uk/M-DAC%20Series.aspx?lang=En) -> 'Focal MP1200' (http://www.mp1200.co.nf/) -> 'Focal Electra 1028 Be' (http://www.focal.com/en/electra-1000-be-2/209-electra-1028-be-3544053695099.html) 1 x SB3, 1 x SB Boom, 1 x SB Radio and 2 x SB Touch - all wireless 2 x Wandboard Dual, 1 x Wandboard Quad ReadyNAS NVX running LMS 7.9.0. iPeng on iPhone, SqueezePad & iPeng on iPad. http://www.last.fm/user/phibon Pascal Hibon's Profile: http://forums.slimdevices.com/member.php?userid=7969 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
pkfox wrote: > I just wanted my document to mirror the *actual* content of anyone's > collection - if I just use LMS CLI calls for counts they would not be an > accurate reflection of the document sorry but i didnt get the point? You using the library.db of a App called Logitechmediaserver and dont want to use some cli calls from that App cause they would not be an accurate reflection of the document even if they use the same database thats been made from that inaccurate Application?? pkfox wrote: > Hi there, as I said in another post I noticed that mp3 files have extra > tag info that might affect how they are classified. what extra tag? Gruss Jan DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
ply3908 wrote: > What font is used for generate the PDF file? The Chinese characters are > not displayed. Helvetica We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
BJW wrote: > don't want to drag this OT but this is related to the last few posts i > think: > > http://bugs.slimdevices.com/show_bug.cgi?id=8764 > > i don't understand why this is difficult? the app should be able to > easily count artists, album artists, and albums, and delineate easily > imo. The problem is , my app gets all my counts correct , some other folks here get some counts correct and others get all counts correct - it's not as simple as running a few SQL queries , what I need is the code to see how LMS decides what and how to tag a contributor, album and track counts seem ok We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
I haven't really watched in awhile what LMS reports on a daily basis. I do recall 5that I did so awhile back and the numbers changed even though I had added nothing or made any revisions. I have a Looked For new And Changed Media Files scheduled to run daily overnight. I guess my point is perhaps LMS is not infallible in how it scans. dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
pkfox wrote: > The problem is , my app gets all my counts correct , some other folks > here get some counts correct and others get all counts correct - it's > not as simple as running a few SQL queries , what I need is the code to > see how LMS decides what and how to tag a contributor, album and track > counts seem ok The Problem is some have files and spend some time to get their files tagged - some dont. Some have this and others that. Some uses that thread to get basic computer knowledge some others Hickjacks Threads. Why is the counting of the files important? Gruss Jan DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
don't want to drag this OT but this is related to the last few posts i think: http://bugs.slimdevices.com/show_bug.cgi?id=8764 i don't understand why this is difficult? the app should be able to easily count artists, album artists, and albums, and delineate easily imo. using: win7 64 + lms 7.9 & duet & ipads w/the logitech app, and ipeng on an ipod http://wiki.slimdevices.com/index.php/various_artists_logic & http://wiki.slimdevices.com/index.php/compilations BJW's Profile: http://forums.slimdevices.com/member.php?userid=58242 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Downloaded this to give it a try, works great for me. Thank you for all the hard work you put into this. Squeezebox: Classic/SB3, Duet,(Controller x2) Boom x3, Radio and Touch x3 Server: Noah Blk Mini-ITX Case, Intel D945GCLF2 Atom 330 Motherboard, 2 GB 667 RAM, X2 Western Digital Scorpio Blue 500GB 2.5" H/D's Internal. Ext Backup #1: DAS 200 with X2 Western Digital Caviar Green 1TB H/D's Raided. OS: WHS. Ext Backup #2: External USB Hardrive using GoodSync (Backup program). Ripper: dBpoweramp. (Installed on WHS & Win7) Running 24/7 Looks good and works well! RussellMrgn's Profile: http://forums.slimdevices.com/member.php?userid=29655 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
RussellMrgn wrote: > Downloaded this to give it a try, works great for me. Thank you for all > the hard work you put into this. Hi there and thank you - do your counts match with LMS ? We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
What font is used for generate the PDF file? The Chinese characters are not displayed. ply3908's Profile: http://forums.slimdevices.com/member.php?userid=38634 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Can anybody define how LMS actually calculates the Artist Count? It isn't the number of lines in "contributors" in my DB although in Pascal's case it was. *Vortexbox LMS 7.8 music on QNAP TS419p via NFS* iThingys/iPeng/Tablets *Living Room* - SB3 -> Onkyo TS606 - > Celestion Ditton F20s - Zone 2 -> Sony TA FE 320 -> Sennheiser RS 130 & B P7 *Office* - RPi -> Sony TA FE320 -> Celestion F10s / SB3 -> Onkyo CRN 755 -> Wharfedale Modus Cubes *Dining Room* -> SB Boom *Kitchen* -> UE Radio (upgraded to SB Radio) *Bedroom (Bedside)* - SB Touch -> Topping TP21 -> AKG Headphones *Bedroom (TV)* - Amazon Fire TV (SB Player) -> Topping TP20 -> Wharfedale Modus Cubes d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
d6jg wrote: > Can anybody define how LMS actually calculates the Artist Count? > > It isn't the number of lines in "contributors" in my DB although in > Pascal's case it was. I think it depends on whether you rip them yourself or download something We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
It must be the sum of something identifiable. I think it may be Album Artists (role 5 or is it 6) plus Artists (role 1) but I can't be sure without lots of testing. *Vortexbox LMS 7.8 music on QNAP TS419p via NFS* iThingys/iPeng/Tablets *Living Room* - SB3 -> Onkyo TS606 - > Celestion Ditton F20s - Zone 2 -> Sony TA FE 320 -> Sennheiser RS 130 & B P7 *Office* - RPi -> Sony TA FE320 -> Celestion F10s / SB3 -> Onkyo CRN 755 -> Wharfedale Modus Cubes *Dining Room* -> SB Boom *Kitchen* -> UE Radio (upgraded to SB Radio) *Bedroom (Bedside)* - SB Touch -> Topping TP21 -> AKG Headphones *Bedroom (TV)* - Amazon Fire TV (SB Player) -> Topping TP20 -> Wharfedale Modus Cubes d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
dasmueller wrote: > I am not at all familiar with working with PDF files. I was thinking > earlier today that there should be some way to do a search of a PDF file > so I did a search on the web. If one clicks edit and then selects Find > one can do a search. The point being I did so today and plugged in > tofu-from Bela Fleck and the Flecktones UFO tofu. For some reason it > showed up in Various Artists as well as another Bela folder along with 2 > other folders. One of the other folders had different artists within the > folder. The other did not. As steve-g stated earlier a Clear library and > rescan everything resolved the issue w the Bela folders and the other > folder that did not have issues that would lead me to believe it would > turn up under Various Artists. Why these showed up under Various I have > no clue as I have modified numerous folders in the last few days that > did not show up under Various Artists > > As far as the Artist count thing goes I have no clue but wonder if > somehow there might be something in Extended Tags that causes it. If > only there was a simple way to determine what Artists folders were not > picked up. Of course it might be that LMS picks up additional artists > due to some tagging issue as well. Someone way smarter than me may > figure that out. Hi there, as I said in another post I noticed that mp3 files have extra tag info that might affect how they are classified. We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
ModelCitizen wrote: > I think the artist account disagrees with that of LMS for pretty much > everyone who's tried the software. PKFox is aware of it (read back > through thread). > > last.fm/user/modelcitizen Hi there, I'm working on a way to improve the accuracy of the artist count will put up a new version soon - thanks to everyone for their feedback. We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
I am not at all familiar with working with PDF files. I was thinking earlier today that there should be some way to do a search of a PDF file so I did a search on the web. If one clicks edit and then selects Find one can do a search. The point being I did so today and plugged in tofu-from Bela Fleck and the Flecktones UFO tofu. For some reason it showed up in Various Artists as well as another Bela folder along with 2 other folders. One of the other folders had different artists within the folder. The other did not. As steve-g stated earlier a Clear library and rescan everything resolved the issue w the Bela folders and the other folder that did not have issues that would lead me to believe it would turn up under Various Artists. Why these showed up under Various I have no clue as I have modified numerous folders in the last few days that did not show up under Various Artists As far as the Artist count thing goes I have no clue but wonder if somehow there might be something in Extended Tags that causes it. If only there was a simple way to determine what Artists folders were not picked up. Of course it might be that LMS picks up additional artists due to some tagging issue as well. Someone way smarter than me may figure that out. dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
dasmueller wrote: > I got it to work a few hrs. ago but had to go out for a bit. I had to > add a .db to the library folder and then it worked. > > Searching for how to open the file I inadvertently changed how that file > type opens to Adobe Acrobat Reader and do not know how to change it to > what it should be. Told you I was dumb. > > > The results I got mirrored the LMS control Panel for the # of Albums and > the number of Tracks. For some reason the number of Artists is 8 less w > the app than LMS reports. I have not had time to look through it yet. > Maybe tomorrow. > > I would assume that if one does a nightly scan one would need to > regenerate the PDF w the app. There is no way to get an auto-update ? my album number and tracks are reported the same as LMS. My number of artists is 3 less. Regarding changing the default program to open a file type, go to the file in question, right click, then choose "open with". Then "choose default program", then choose the program you want to use to open that file (or browse to find it). *Home:* VortexBox 4TB (2.3) > LMS 7.8 > Transporter, Touch, Boom, Radio (all ethernet) *Cottage:* VBA 3TB (2.3) > LMS 7.8 > Touch > Benchmark DAC I, Boom, Radio w/Battery (all ethernet except Radio) *Office:* Win8(64) > LMS 7.9 > Squeezelite *Spares:* Touch(3), Radio(3), Boom, SB3, CONTROLLER *Controllers:* iPhone6 & iPadAir2 (iPeng8 & Squeezepad), CONTROLLER, or SqueezePlay 7.8 on Win7(64) laptop *Files:* ripping: dbpoweramp > FLAC; post-rip: mp3tag, PerfectTunes; Streaming: Spotify garym's Profile: http://forums.slimdevices.com/member.php?userid=17325 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
dasmueller wrote: > I am not making myself clear-sorry. While trying to figure out how to > get things to work w the app yesterday I could not open the file to look > at it. So, being a dumb rookie I t changed what program opens that type > of file. The 2nd time I did that I selected Adobe Acrobat which did not > work either. That changed the icon on the folder to PDF. Now that I have > been able to get the app to work I would like to change the icon back to > what it was and just leave things alone. I just don't know how to do > that. I've looked on the web, looked around in the Control Panel etc. no > luck. I believe there was some sort of gear icon there originally. Hi there - to reset the default program you need to go to Explorer - right click on library.db - open with - then browse to SQLiteBrowser.exe whilst making sure the checkbox "Always use the selected program to open this sort of file" is checked We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
dasmueller wrote: > I am not making myself clear-sorry. While trying to figure out how to > get things to work w the app yesterday I could not open the file to look > at it. So, being a dumb rookie I t changed what program opens that type > of file. The 2nd time I did that I selected Adobe Acrobat which did not > work either. That changed the icon on the folder to PDF. Now that I have > been able to get the app to work I would like to change the icon back to > what it was and just leave things alone. I just don't know how to do > that. I've looked on the web, looked around in the Control Panel etc. no > luck. I believe there was some sort of gear icon there originally. hmmm. not sure about how to change the .db file back to some default. I think the suggestion of an SQL program above is the best approach as I assume that is the type of program to open a .db file. Even if you don't change it, it shouldn't cause any problems, as you don't typically edit a db file anyhow. *Home:* VortexBox 4TB (2.3) > LMS 7.8 > Transporter, Touch, Boom, Radio (all ethernet) *Cottage:* VBA 3TB (2.3) > LMS 7.8 > Touch > Benchmark DAC I, Boom, Radio w/Battery (all ethernet except Radio) *Office:* Win8(64) > LMS 7.9 > Squeezelite *Spares:* Touch(3), Radio(3), Boom, SB3, CONTROLLER *Controllers:* iPhone6 & iPadAir2 (iPeng8 & Squeezepad), CONTROLLER, or SqueezePlay 7.8 on Win7(64) laptop *Files:* ripping: dbpoweramp > FLAC; post-rip: mp3tag, PerfectTunes; Streaming: Spotify garym's Profile: http://forums.slimdevices.com/member.php?userid=17325 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
dasmueller wrote: > gary thanks. I know that. What I do not know is what the correct program > is to open a .db file. Doing a web search did not help either. If you are using a Windows box use SQLiteBrowser We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Issue resolved. I used a system restore. I had a restore point of 11/4. The system restore did run completely successfully but it resolved my issue. LMSDocumenter was missing most everything so I deleted and reinstalled. Thanks to all for your help dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Took a quick look through the list of artists and found 4 entries w errors, spelling, punctuation and capital vs lower case letters-just the type of things I have been working on ! dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Continuing on w my tag revision today I then ran a Look For New And Changed media files scan. Total Artists still is off. Perhaps a Clear And Rescan will be different. Anyone else have any input as to their results of various types of rescan ? dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
I am not making myself clear-sorry. While trying to figure out how to get things to work w the app yesterday I could not open the file to look at it. So, being a dumb rookie I t changed what program opens that type of file. The 2nd time I did that I selected Adobe Acrobat which did not work either. That changed the icon on the folder to PDF. Now that I have been able to get the app to work I would like to change the icon back to what it was and just leave things alone. I just don't know how to do that. I've looked on the web, looked around in the Control Panel etc. no luck. I believe there was some sort of gear icon there originally. dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
I think the artist account disagrees with that of LMS for pretty much everyone who's tried the software. PKFox is aware of it (read back through thread). last.fm/user/modelcitizen Somewhere, something incredible is waiting to be known Last.fm/user/ModelCitizen ModelCitizen's Profile: http://forums.slimdevices.com/member.php?userid=446 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
ModelCitizen wrote: > Has anyone an idea of why this discrepancy with Artist count? > > PKFox Cataloger reports: > You have 715 Artists > With 1899 Albums > Containing 25855 Tracks > With a total runtime of: 2032h:15m:0s > > LMS Reports: > Total Tracks: 25,855 > Total Albums: 1,899 > Total Artists: 896 > Total Playing Time: 2032:13:58 Hi there, I'm investigating this issue - I think its because I only select artists that have a link to an album and a track, I notice that any downloaded mp3 files I have ( which is not many ) are not included in the output. All my tracks ripped by me are fine. We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Has anyone an idea of why this discrepancy with Artist count? PKFox Cataloger reports: You have 715 Artists With 1899 Albums Containing 25855 Tracks With a total runtime of: 2032h:15m:0s LMS Reports: Total Tracks: 25,855 Total Albums: 1,899 Total Artists: 896 Total Playing Time: 2032:13:58 Somewhere, something incredible is waiting to be known Last.fm/user/ModelCitizen ModelCitizen's Profile: http://forums.slimdevices.com/member.php?userid=446 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Pascal Hibon wrote: > I'm running 7.9. > If there are differences in the db between LMS versions then it will be > hard to sustain such an application. > > Yes, I do like the fact that it has "presets" so that the user can > generate different output data / reports. Of course, not everyone > master's SQL enough to be able to modify the queries. This thread is a > good example; it is already hard enough to "reverse engineer" how the > different tables in the db interact. You're right, of course, but with some help from forum users it is at least *possible* to adapt to db changes, even if the app is no longer maintained. So reading the SQL statements from a file could also be a way for the OP's application to allow future adaptations. reinholdk's Profile: http://forums.slimdevices.com/member.php?userid=36070 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
epoch1970 wrote: > (I don't want to hijack the thread, but I simply have to ask...) > > One thing puzzles me: in the various catalog apps or generators I've > seen, I've never found the option to actually consume the contents that > are being catalogued. Never a "play" button. Why is that? > > To me a catalog is a great way to navigate/discover a collection. But if > I browse, I want to get easy access to an element of the collection in > the end. That could be, in the case of LMS, embedding a link designed > for the directplay plugin for example (or perhaps on tablets some > deep-link to your favorite Squeezebox remote app.) If the catalog is > printed, a QR or bar code could embed such a link. > > Could I be the only one who wants a "play" button on catalog pages? In many ways what you are asking for is what we already have with LMS. You can list ALBUM, ARTISTS > ALBUMS, etc. and then play from there. Or one could use foobar2000 for that, or itunes for that matter. *Home:* VortexBox 4TB (2.3) > LMS 7.8 > Transporter, Touch, Boom, Radio (all ethernet) *Cottage:* VBA 3TB (2.3) > LMS 7.8 > Touch > Benchmark DAC I, Boom, Radio w/Battery (all ethernet except Radio) *Office:* Win8(64) > LMS 7.9 > Squeezelite *Spares:* Touch(3), Radio(3), Boom, SB3, CONTROLLER *Controllers:* iPhone6 & iPadAir2 (iPeng8 & Squeezepad), CONTROLLER, or SqueezePlay 7.8 on Win7(64) laptop *Files:* ripping: dbpoweramp > FLAC; post-rip: mp3tag, PerfectTunes; Streaming: Spotify garym's Profile: http://forums.slimdevices.com/member.php?userid=17325 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
dasmueller wrote: > When I navigate to the cache folder and try to open it I get a msg that > windows cannot open this file cache.db. I assume the library.db is > inside this file ? > > Thanks for helping no, go to cache folder, then look for the file named "library.db". Copy this file to your desktop, and then use that file for input into creating the pdf. *Home:* VortexBox 4TB (2.3) > LMS 7.8 > Transporter, Touch, Boom, Radio (all ethernet) *Cottage:* VBA 3TB (2.3) > LMS 7.8 > Touch > Benchmark DAC I, Boom, Radio w/Battery (all ethernet except Radio) *Office:* Win8(64) > LMS 7.9 > Squeezelite *Spares:* Touch(3), Radio(3), Boom, SB3, CONTROLLER *Controllers:* iPhone6 & iPadAir2 (iPeng8 & Squeezepad), CONTROLLER, or SqueezePlay 7.8 on Win7(64) laptop *Files:* ripping: dbpoweramp > FLAC; post-rip: mp3tag, PerfectTunes; Streaming: Spotify garym's Profile: http://forums.slimdevices.com/member.php?userid=17325 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
When I navigate To C:\ProgramData\Squeezebox\Cache I see a file called library, and one named library.db-shm, and one named library.db-wal. I am running version 7.7.4 if that makes a difference. dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
When I navigate to the cache folder and try to open it I get a msg that windows cannot open this file cache.db. I assume the library.db is inside this file ? Thanks for helping dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
(I don't want to hijack the thread, but I simply have to ask...) One thing puzzles me: in the various catalog apps or generators I've seen, I've never found the option to actually consume the contents that are being catalogued. Never a "play" button. Why is that? To me a catalog is a great way to navigate/discover a collection. But if I browse, I want to get easy access to an element of the collection in the end. That could be, in the case of LMS, embedding a link designed for the directplay plugin for example (or perhaps on tablets some deep-link to your favorite Squeezebox remote app.) If the catalog is printed, a QR or bar code could embed such a link. Could I be the only one who wants a "play" button on catalog pages? 4 SB 3 iPeng (iPhone + iPad) Squeezebox Server 7.9 (linux) with plugins: CD Player, WaveInput by bpa IRBlaster by Gwendesign (Felix) Server Power Control by Gordon Harris Smart Mix, Music Walk With Me, What Was That Tune? by Michael Herger PowerSave by Jason Holtzapple Song Info, Song Lyrics by Erland Isaksson WeatherTime by Martin Rehfeld ShairTunes2 by disaster123 Local Player, BBC iPlayer by Triode Auto Dim Display, SaverSwitcher, ContextMenu by Peter Watkins. epoch1970's Profile: http://forums.slimdevices.com/member.php?userid=16711 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
dasmueller wrote: > When I navigate To C:\ProgramData\Squeezebox\Cache I see a file called > library, and one named library.db-shm, and one named library.db-wal. I > am running version 7.7.4 if that makes a difference. > > What program is supposed to be able to open these files ? Maybe you've told your windows explorer not to show file extensions? This is my C:\ProgramData\Squeezebox\Cache contents. see pic. 19171 +---+ |Filename: CropperCapture[1].jpg| |Download: http://forums.slimdevices.com/attachment.php?attachmentid=19171| +---+ *Home:* VortexBox 4TB (2.3) > LMS 7.8 > Transporter, Touch, Boom, Radio (all ethernet) *Cottage:* VBA 3TB (2.3) > LMS 7.8 > Touch > Benchmark DAC I, Boom, Radio w/Battery (all ethernet except Radio) *Office:* Win8(64) > LMS 7.9 > Squeezelite *Spares:* Touch(3), Radio(3), Boom, SB3, CONTROLLER *Controllers:* iPhone6 & iPadAir2 (iPeng8 & Squeezepad), CONTROLLER, or SqueezePlay 7.8 on Win7(64) laptop *Files:* ripping: dbpoweramp > FLAC; post-rip: mp3tag, PerfectTunes; Streaming: Spotify garym's Profile: http://forums.slimdevices.com/member.php?userid=17325 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
I got it to work a few hrs. ago but had to go out for a bit. I had to add a .db to the library folder and then it worked. Searching for how to open the file I inadvertently changed how that file type opens to Adobe Acrobat Reader and do not know how to change it to what it should be. Told you I was dumb. The results I got mirrored the LMS control Panel for the # of Albums and the number of Tracks. For some reason the number of Artists is 8 less w the app than LMS reports. I have not had time to look through it yet. Maybe tomorrow. I would assume that if one does a nightly scan one would need to regenerate the PDF w the app. There is no way to get an auto-update ? dasmueller's Profile: http://forums.slimdevices.com/member.php?userid=38035 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
reinholdk wrote: > Just tried and it worked for me, using a LMS 7.8 library file. Don't > have a current 7.9 installed. > But the good thing with this application is, you can adapt the SQL > statements yourself, if necessary. I'm running 7.9. If there are differences in the db between LMS versions then it will be hard to sustain such an application. Yes, I do like the fact that it has "presets" so that the user can generate different output data / reports. Of course, not everyone master's SQL enough to be able to modify the queries. This thread is a good example; it is already hard enough to "reverse engineer" how the different tables in the db interact. 'M-DAC' (http://www.audiolab.co.uk/M-DAC%20Series.aspx?lang=En) -> 'Focal MP1200' (http://www.mp1200.co.nf/) -> 'Focal Electra 1028 Be' (http://www.focal.com/en/electra-1000-be-2/209-electra-1028-be-3544053695099.html) 1 x SB3, 1 x SB Boom, 1 x SB Radio and 2 x SB Touch - all wireless 2 x Wandboard Dual, 1 x Wandboard Quad ReadyNAS NVX running LMS 7.9.0. iPeng on iPhone, SqueezePad & iPeng on iPad. http://www.last.fm/user/phibon Pascal Hibon's Profile: http://forums.slimdevices.com/member.php?userid=7969 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Thanks PK. Latest version worked for me on a 32 bit system. Will have a closer look at the output this evening. Thanks very much. Somewhere, something incredible is waiting to be known Last.fm/user/ModelCitizen ModelCitizen's Profile: http://forums.slimdevices.com/member.php?userid=446 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
w3wilkes wrote: > @Pascal, > LMS does store BPM in the database if... It is an integer. Yes, I found the bpm value in the tracks table. I'm using Mixed In Key to generate the bmp and key values. My bpm values are in "Denon" format and are indeed numeric. 'M-DAC' (http://www.audiolab.co.uk/M-DAC%20Series.aspx?lang=En) -> 'Focal MP1200' (http://www.mp1200.co.nf/) -> 'Focal Electra 1028 Be' (http://www.focal.com/en/electra-1000-be-2/209-electra-1028-be-3544053695099.html) 1 x SB3, 1 x SB Boom, 1 x SB Radio and 2 x SB Touch - all wireless 2 x Wandboard Dual, 1 x Wandboard Quad ReadyNAS NVX running LMS 7.9.0. iPeng on iPhone, SqueezePad & iPeng on iPad. http://www.last.fm/user/phibon Pascal Hibon's Profile: http://forums.slimdevices.com/member.php?userid=7969 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Pascal Hibon wrote: > hm... that certainly suggest that the way of tagging influences the way > LMS stores the data. > Hope that Michael comes to the rescue :-) Don't know what I've started here :-) Using my database as a test piece I've noticed that I have missing contributors for mp3 files that I've bought, all my personally ripped flac files are ok ( they have a contributor , track and album id ) the mp3 files have different tags that don't show up in EasyTag which is my editor. If I use mp3tag to look at the mp3 files they have more information in them such as Composer which LMS seems to create an entry for in contributor_tracks but not in albums or tracks which I find strange. So basically as it stands my app is found wanting - I'll have to find a way of finding the album the track is on and link that to the track listing in my document under the Composers name as well as the album it's on. We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
d6jg wrote: > In contributor_albums and contributor_tracks it seems that the role > (appears to be 1 to 6) is dependent on which tag LMS read. > > I -think- I have identified that role 6 equates to AlbumArtist whereas > role 5 is TrackArtist BUT if there is no AlbumArtist in the file it is > role 1. role 2 is Composer. I haven't found examples of 3 & 4 yet. > > EDIT. role 3 is Conductor See 'this post' (http://forums.slimdevices.com/showthread.php?103454-Sort-order-forms-for-names=816429=1#post816429) for a list of contributor roles. reinholdk's Profile: http://forums.slimdevices.com/member.php?userid=36070 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
reinholdk wrote: > See 'this post' > (http://forums.slimdevices.com/showthread.php?103454-Sort-order-forms-for-names=816429=1#post816429) > for a list of contributor roles. Very useful thanks We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
d6jg wrote: > In contributor_albums and contributor_tracks it seems that the role > (appears to be 1 to 6) is dependent on which tag LMS read. > > I -think- I have identified that role 6 equates to AlbumArtist whereas > role 5 is TrackArtist BUT if there is no AlbumArtist in the file it is > role 1. role 2 is Composer. I haven't found examples of 3 & 4 yet. > > EDIT. role 3 is Conductor I wondered what role was for :-) I've now got to the point where I find the underlying album for a contributor who is *on* an album but haven't figured out how to only identify the tracks they are related to - as it is I'm getting all the tracks on the album , which is what I want for a *main* contributor but not one that is on only one or two tracks We can't stop here this is bat country. RIP Hunter S Thompson. pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
In tracks look at primary_artist - it's a contributor ID. It is the equivalent of Artist as opposed to AlbumArtist. *Vortexbox LMS 7.8 music on QNAP TS419p via NFS* iThingys/iPeng/Tablets *Living Room* - SB3 -> Onkyo TS606 - > Celestion Ditton F20s - Zone 2 -> Sony TA FE 320 -> Sennheiser RS 130 & B P7 *Office* - RPi -> Sony TA FE320 -> Celestion F10s / SB3 -> Onkyo CRN 755 -> Wharfedale Modus Cubes *Dining Room* -> SB Boom *Kitchen* -> UE Radio (upgraded to SB Radio) *Bedroom (Bedside)* - SB Touch -> Topping TP21 -> AKG Headphones *Bedroom (TV)* - Amazon Fire TV (SB Player) -> Topping TP20 -> Wharfedale Modus Cubes d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
See 'here' (http://forums.slimdevices.com/showthread.php?101600-LMS-Extractor-Is-Now-Available=781353=1#post781353) for an other application that exports data from LMS (didn't try it myself). reinholdk's Profile: http://forums.slimdevices.com/member.php?userid=36070 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
pkfox wrote: > Don't know what I've started here :-) Using my database as a test piece > I've noticed that I have missing contributors for mp3 files that I've > bought, all my personally ripped flac files are ok ( they have a > contributor , track and album id ) the mp3 files have different tags > that don't show up in EasyTag which is my editor. If I use mp3tag to > look at the mp3 files they have more information in them such as > Composer which LMS seems to create an entry for in contributor_tracks > but not in albums or tracks which I find strange. So basically as it > stands my app is found wanting - I'll have to find a way of finding the > album the track is on and link that to the track listing in my document > under the Composers name as well as the album it's on. In contributor_albums and contributor_tracks it seems that the role (appears to be 1 to 6) is dependent on which tag LMS read. I -think- I have identified that role 6 equates to AlbumArtist whereas role 5 is TrackArtist BUT if there is no AlbumArtist in the file it is role 1. role 2 is Composer. I haven't found examples of 3 & 4 yet. *Vortexbox LMS 7.8 music on QNAP TS419p via NFS* iThingys/iPeng/Tablets *Living Room* - SB3 -> Onkyo TS606 - > Celestion Ditton F20s - Zone 2 -> Sony TA FE 320 -> Sennheiser RS 130 & B P7 *Office* - RPi -> Sony TA FE320 -> Celestion F10s / SB3 -> Onkyo CRN 755 -> Wharfedale Modus Cubes *Dining Room* -> SB Boom *Kitchen* -> UE Radio (upgraded to SB Radio) *Bedroom (Bedside)* - SB Touch -> Topping TP21 -> AKG Headphones *Bedroom (TV)* - Amazon Fire TV (SB Player) -> Topping TP20 -> Wharfedale Modus Cubes d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
reinholdk wrote: > See 'here' > (http://forums.slimdevices.com/showthread.php?101600-LMS-Extractor-Is-Now-Available=781353=1#post781353) > for an other application that exports data from LMS (didn't try it > myself). Just gave it a try and it always reports an SQL error. This probably due to some changes in the db over time(?) 'M-DAC' (http://www.audiolab.co.uk/M-DAC%20Series.aspx?lang=En) -> 'Focal MP1200' (http://www.mp1200.co.nf/) -> 'Focal Electra 1028 Be' (http://www.focal.com/en/electra-1000-be-2/209-electra-1028-be-3544053695099.html) 1 x SB3, 1 x SB Boom, 1 x SB Radio and 2 x SB Touch - all wireless 2 x Wandboard Dual, 1 x Wandboard Quad ReadyNAS NVX running LMS 7.9.0. iPeng on iPhone, SqueezePad & iPeng on iPad. http://www.last.fm/user/phibon Pascal Hibon's Profile: http://forums.slimdevices.com/member.php?userid=7969 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
Re: [slim] Document your collection
Pascal Hibon wrote: > Just gave it a try and it always reports an SQL error. This probably due > to some changes in the db over time(?) Just tried and it worked for me, using a LMS 7.8 library file. Don't have a current 7.9 installed. But the good thing with this application is, you can adapt the SQL statements yourself, if necessary. reinholdk's Profile: http://forums.slimdevices.com/member.php?userid=36070 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss