Well you can get basically anything you want to know filtered how you want with mysql query, it's pretty much all in the database.
mysql -h 'hostname -p'password' Rivendell "SELECT ARTIST, TITLE, NUMBER FROM CART" will give a list of all carts using those fields 'artist title and cart number' many other fields available from the database tables. Filter by adding 'WHERE (PLAYS) > '50' or something similar. You can then sort it by adding a pipe command. | sort, then write it to file with > filename.txt Mysql query outputs a tab delimited file with headers by default. All can be adjusted with the right syntax. A couple of short shell scripts and you can have any type of report you want. Cheers On 4 Apr 2013 20:31, "Lee Baker" <[email protected]> wrote: > Hi All, > > I am just wondering this same thing, I need to export an Australia APRA > Music report and I'd like to be able to create a customer report that > exports certain info such as title and artist, composer, isrc, and number > of > plays for a given month as well as report only between certain times and > dates. > > Is this possible to do? > > Cheers, > Lee > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Peter > Claes > Sent: Sunday, 10 March 2013 4:58 AM > To: User discussion about the Rivendell Radio Automation System > Subject: [RDD] Custom export filters for report generation > > Hi guys, > > Is there a way to alter the export filter for report generation ? Or even > to > create a Custom ? > > Regards, > _______________________________________________ > 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 >
_______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
