well, in rdlibrary I found a button at the bottom that says reports, so that got them going with enough info and they are happy for now. I'll try the mysql querry though just for the experience, and EMMA.
Thanks! Nathaniel C. Steele Assistant Chief Engineer/Technical Director WTRM-FM / TheCrossFM On 8/3/2012 11:29 AM, Wayne Merricks wrote: > There are some reports built into Rivendell but I'm pretty sure they're > based on whats played on air (or from a certain machine). > > You can easily get this list using MySQL: > > select ARTIST, TITLE, ALBUM from CART order by ARTIST asc, TITLE asc > > Under linux theres a GUI called emma (and I'm sure many others) that > will let you run this and then save as a csv for import into calc or excel. > > Wayne Merricks > The Voice Asia > > On 03/08/12 16:18, Nathan Steele wrote: >> I've been asked if I can get a list of all the music info from >> rivendell, I think they want artist title album info for all the music >> in the library. any idea how to do this? I"m not experienced with doing >> mysql queries, but my guess would be that's the ticket? Can I do it with >> a rivendell report? >> >> Thanks, >> > > ####################### > Scanned by MailMarshal > ####################### > > ############ > > Attention: > > The information contained in this message is confidential and intended > for the addressee(s) only. If you have received this message in error > or there are any problems, please notify the originator immediately. > The unauthorised use, disclosure, copying or alteration of this message > is strictly forbidden. Christian Vision or any of its subsidiaries will > not be liable for direct, special, indirect or consequential damages > arising from alteration of the contents of this message by a third party > or as a result of any virus being passed on. Please note that we reserve > the right to monitor and read any e-mails sent or received by the > company under the Telecommunications (Lawful Business Practice) > (Interception of Communications) Regulation 2000. Christian Vision is > registered in England as a limited company 2842414 and as a charity > 1031031 > > ############ > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev > > > _______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
