Thanks David, I too was needing a similar script! much appreciated On Fri, May 20, 2016 at 5:57 PM, John Hodgson <[email protected]> wrote:
> Hi David, > > This looks to be just what I need! I am not great with the SQL side of > things so you have saved me from a big headache. > > Many thanks > John > > -----Original Message----- > From: David Klann [mailto:[email protected]] > Sent: 19 May 2016 16:00 > To: John Hodgson; [email protected] > Subject: Re: [RDD] SQL script > > Hi John, > > Here's what I've used in the past to generate a CSV file from the CART > table > (adapted with your column names). From a command line on a system with > access to your Rivendell database: > > mysql -u rduser -pletmein -e "select \ > a.NUMBER, a.TITLE, a.ARTIST, u.TALK_END_POINT/1000, u.LENGTH/1000 \ from > CART as a \ left join CUTS as u on (a.NUMBER = u.CART_NUMBER) \ where > a.GROUP='MUSIC' \ into outfile '/tmp/cart-$(date +%F).csv' \ fields > terminated by ',' \ enclosed by '\"' \ lines terminated by '\n'" > > I'm assuming that the column "TALK_END_POINT" is what you're using to > indicate the length of the intro. This in turn assumes that > "TALK_START_POINT" is set to the beginning of the cut. Your mileage may > vary... > > The length columns are stored as number of milliseconds, so I divide by > 1000 to save the values as seconds. Exercise for the reader to convert that > to minutes and seconds... > > The "outfile" uses the current date (in YYYY-MM-DD format) as part of the > file name. You'll need to make sure that file name does NOT exist before > running the command otherwise mysql will complain. > > Hope this helps! > > ~David Klann > > > On 05/19/2016 09:10 AM, John Hodgson wrote: > > Hi everyone, > > > > I'm wondering if you can help me? > > > > I am trying to export our audio library into a CSV file... The info I > > need > > is: > > > > CART NUMBER, FILENAME, TITLE, ARTIST, INTRO LENGTH, CUT LENGTH > > > > The issue I have with the rdlibrary report I can produce is that I can > > get all I need apart from the INTRO LENGTH I can make the file name up > > from the cut number and cart number that I get out. > > > > If anyone has an SQL script I can run or something similar I would be > > very grateful. > > > > Thanks in advance. > > > > John > > > > _______________________________________________ > > Rivendell-dev mailing list > > [email protected] > > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > > > > > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
