I spent a lot of time recently with another colleague, both of us trying to get this system to work.
Alas, it never did: we tried Ubuntu 14, Ubuntu 18, Cent OS7, with step by step instructions from for different (and I mean different!!) sources! All i can say is that this is a must laudable attempt at a playout system (and I've used them all, from high-end Dalet down to hobbyist Station Playlist), but it's a pity all your efforts don't go into a product that can be set up by someone who isn't a computer 'nerd' ( absolutely no offence intended)! Best of luck Mark and Jeff On Wed, 23 May 2018, 17:00 , <[email protected]> wrote: > Send Rivendell-dev mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Rivendell-dev digest..." > > > Today's Topics: > > 1. mysql query to file report (Mircea Paun) > 2. *** position out of bounds on signal: ... ([email protected]) > 3. Re: mysql query to file report (Mike Carroll) > 4. 2.19.2: all buttons disabled in RDLogManager (Calvin Hones) > 5. Re: mysql query to file report (Mircea Paun) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 22 May 2018 19:41:25 +0300 > From: Mircea Paun <[email protected]> > To: USER DISCUSSION ABOUT THE RIVENDELL RADIO AUTOMATION SYSTEM > <[email protected]> > Subject: [RDD] mysql query to file report > Message-ID: <[email protected]> > Content-Type: text/plain; charset="us-ascii" > > Hi, > From previous posts and my additions I have reached this form of mysql > query: > ------------- > SELECT Audio_SRT.EVENT_DATETIME,\ > CART.TITLE,\ > CART.ARTIST,\ > CART.COMPOSER,\ > TIME_FORMAT(SEC_TO_TIME(Audio_SRT.LENGTH/1000),"%i:%s"),\ > TIME_FORMAT(SEC_TO_TIME(CART.FORCED_LENGTH/1000),"%i:%s"),\ > CART.LABEL,CART.ALBUM FROM `Audio_SRT` > LEFT JOIN CART ON Audio_SRT.CART_NUMBER = CART.NUMBER > WHERE (Audio_SRT.EVENT_DATETIME BETWEEN DATE_FORMAT(NOW() - INTERVAL 1 > MONTH, '%Y-%m-01 00:00:00') AND DATE_FORMAT(LAST_DAY(NOW() - INTERVAL 1 > MONTH), '%Y-%m-%d 23:59:59')) > AND (CART.GROUP_NAME in ('MUSIC','XMAS')) > INTO OUTFILE '/tmp/Playout.csv' > FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\n'; > --------------- > Does anyone help me to include PLAY_COUNTER field, from another "CUTS" > TABLE, in this query output, right after ARTIST ? > Thanks! > > mIRCea > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > http://caspian.paravelsystems.com/pipermail/rivendell-dev/attachments/20180522/579e4e9f/attachment-0001.html > > > > ------------------------------ > > Message: 2 > Date: Tue, 22 May 2018 12:10:57 -0500 > From: "[email protected]" <[email protected]> > To: [email protected] > Subject: [RDD] *** position out of bounds on signal: ... > Message-ID: <[email protected]> > Content-Type: text/plain; charset=utf-8; format=flowed > > > rdairplay is kicking out these error messages. > > Almost always it is complaining about two very short cuts in one cart which > > act as a divider between nearly all of our other cuts during playback. > > But I have seen the message about a few other cuts as well. > > > I shortened one of the cuts slightly and that changed the "Pos: " > (position?) > > to be a slightly smaller number.? So... it seems to imply the problem is > > at the end of the cut. > > > Any ideas about what this means? > > > Chris Howard > > Classic Book Radio > > > > > ------------------------------ > > Message: 3 > Date: Tue, 22 May 2018 16:35:15 -0700 > From: Mike Carroll <[email protected]> > To: Mircea Paun <[email protected]> > Cc: USER DISCUSSION ABOUT THE RIVENDELL RADIO AUTOMATION SYSTEM > <[email protected]> > Subject: Re: [RDD] mysql query to file report > Message-ID: > <CAAG1q_vTcnf8iSFzyGYrcL41FT+5mx1MTnrRRr7EnF= > [email protected]> > Content-Type: text/plain; charset="utf-8" > > What have you already tried? Give us a hint so we don't waste time > duplicating your work. > > There can be many cuts in a cart. Which one do you want? > > > On Tue, May 22, 2018 at 9:41 AM Mircea Paun <[email protected]> wrote: > > > Hi, > > From previous posts and my additions I have reached this form of mysql > > query: > > ------------- > > SELECT Audio_SRT.EVENT_DATETIME,\ > > CART.TITLE,\ > > CART.ARTIST,\ > > CART.COMPOSER,\ > > TIME_FORMAT(SEC_TO_TIME(Audio_SRT.LENGTH/1000),"%i:%s"),\ > > TIME_FORMAT(SEC_TO_TIME(CART.FORCED_LENGTH/1000),"%i:%s"),\ > > CART.LABEL,CART.ALBUM FROM `Audio_SRT` > > LEFT JOIN CART ON Audio_SRT.CART_NUMBER = CART.NUMBER > > WHERE (Audio_SRT.EVENT_DATETIME BETWEEN DATE_FORMAT(NOW() - INTERVAL 1 > > MONTH, '%Y-%m-01 00:00:00') AND DATE_FORMAT(LAST_DAY(NOW() - INTERVAL 1 > > MONTH), '%Y-%m-%d 23:59:59')) > > AND (CART.GROUP_NAME in ('MUSIC','XMAS')) > > INTO OUTFILE '/tmp/Playout.csv' > > FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\n'; > > --------------- > > Does anyone help me to include PLAY_COUNTER field, from another "CUTS" > > TABLE, in this query output, right after ARTIST ? > > Thanks! > > > > *mIRCea* > > > > _______________________________________________ > > Rivendell-dev mailing list > > [email protected] > > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > http://caspian.paravelsystems.com/pipermail/rivendell-dev/attachments/20180522/79d3881e/attachment-0001.html > > > > ------------------------------ > > Message: 4 > Date: Tue, 22 May 2018 19:37:06 -0400 > From: Calvin Hones <[email protected]> > To: [email protected] > Subject: [RDD] 2.19.2: all buttons disabled in RDLogManager > Message-ID: > < > ca+jghrnf-4s1nzfn4qpp2yxt5paec3nnk371fsleuek+2rs...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > Hi, > > I'm back with more problems...went to generate a fresh batch of logs today > and found that every option in RDLogManager is suddenly grayed out, save > "close". Everything else seems to be in working order - RDAirPlay and > RDLogEdit can play/edit logs that have already been generated, the library > looks alright - it just won't let me generate any *new* logs, nor edit > events, clocks, etc. > > Any ideas on what to do to get this fixed? > > Thanks in advance! > Calvin Hones > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > http://caspian.paravelsystems.com/pipermail/rivendell-dev/attachments/20180522/b2455340/attachment-0001.html > > > > ------------------------------ > > Message: 5 > Date: Wed, 23 May 2018 07:15:37 +0300 > From: Mircea Paun <[email protected]> > To: Mike Carroll <[email protected]> > Cc: USER DISCUSSION ABOUT THE RIVENDELL RADIO AUTOMATION SYSTEM > <[email protected]> > Subject: Re: [RDD] mysql query to file report > Message-ID: <[email protected]> > Content-Type: text/plain; charset="us-ascii" > > First one. > "Cut 001" or _001. > > Sent from my mobile device > mIRCea > > > On 23 May 2018, at 02:35, Mike Carroll <[email protected]> wrote: > > > > What have you already tried? Give us a hint so we don't waste time > duplicating your work. > > > > There can be many cuts in a cart. Which one do you want? > > > > > >> On Tue, May 22, 2018 at 9:41 AM Mircea Paun <[email protected]> > wrote: > >> Hi, > >> From previous posts and my additions I have reached this form of mysql > query: > >> ------------- > >> SELECT Audio_SRT.EVENT_DATETIME,\ > >> CART.TITLE,\ > >> CART.ARTIST,\ > >> CART.COMPOSER,\ > >> TIME_FORMAT(SEC_TO_TIME(Audio_SRT.LENGTH/1000),"%i:%s"),\ > >> TIME_FORMAT(SEC_TO_TIME(CART.FORCED_LENGTH/1000),"%i:%s"),\ > >> CART.LABEL,CART.ALBUM FROM `Audio_SRT` > >> LEFT JOIN CART ON Audio_SRT.CART_NUMBER = CART.NUMBER > >> WHERE (Audio_SRT.EVENT_DATETIME BETWEEN DATE_FORMAT(NOW() - INTERVAL 1 > MONTH, '%Y-%m-01 00:00:00') AND DATE_FORMAT(LAST_DAY(NOW() - INTERVAL 1 > MONTH), '%Y-%m-%d 23:59:59')) > >> AND (CART.GROUP_NAME in ('MUSIC','XMAS')) > >> INTO OUTFILE '/tmp/Playout.csv' > >> FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\n'; > >> --------------- > >> Does anyone help me to include PLAY_COUNTER field, from another "CUTS" > TABLE, in this query output, right after ARTIST ? > >> Thanks! > >> > >> mIRCea > >> > >> _______________________________________________ > >> Rivendell-dev mailing list > >> [email protected] > >> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > http://caspian.paravelsystems.com/pipermail/rivendell-dev/attachments/20180523/f25acc9e/attachment-0001.html > > > > ------------------------------ > > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > > > End of Rivendell-dev Digest, Vol 61, Issue 21 > ********************************************* > On 23 May 2018 17:00, <[email protected]> wrote: Send Rivendell-dev mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of Rivendell-dev digest..." Today's Topics: 1. mysql query to file report (Mircea Paun) 2. *** position out of bounds on signal: ... ([email protected]) 3. Re: mysql query to file report (Mike Carroll) 4. 2.19.2: all buttons disabled in RDLogManager (Calvin Hones) 5. Re: mysql query to file report (Mircea Paun) ---------------------------------------------------------------------- Message: 1 Date: Tue, 22 May 2018 19:41:25 +0300 From: Mircea Paun <[email protected]> To: USER DISCUSSION ABOUT THE RIVENDELL RADIO AUTOMATION SYSTEM <[email protected]> Subject: [RDD] mysql query to file report Message-ID: <[email protected]> Content-Type: text/plain; charset="us-ascii" Hi, >From previous posts and my additions I have reached this form of mysql query: ------------- SELECT Audio_SRT.EVENT_DATETIME,\ CART.TITLE,\ CART.ARTIST,\ CART.COMPOSER,\ TIME_FORMAT(SEC_TO_TIME(Audio_SRT.LENGTH/1000),"%i:%s"),\ TIME_FORMAT(SEC_TO_TIME(CART.FORCED_LENGTH/1000),"%i:%s"),\ CART.LABEL,CART.ALBUM FROM `Audio_SRT` LEFT JOIN CART ON Audio_SRT.CART_NUMBER = CART.NUMBER WHERE (Audio_SRT.EVENT_DATETIME BETWEEN DATE_FORMAT(NOW() - INTERVAL 1 MONTH, '%Y-%m-01 00:00:00') AND DATE_FORMAT(LAST_DAY(NOW() - INTERVAL 1 MONTH), '%Y-%m-%d 23:59:59')) AND (CART.GROUP_NAME in ('MUSIC','XMAS')) INTO OUTFILE '/tmp/Playout.csv' FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\n'; --------------- Does anyone help me to include PLAY_COUNTER field, from another "CUTS" TABLE, in this query output, right after ARTIST ? Thanks! mIRCea -------------- next part -------------- An HTML attachment was scrubbed... URL: < http://caspian.paravelsystems.com/pipermail/rivendell-dev/attachments/20180522/579e4e9f/attachment-0001.html > ------------------------------ Message: 2 Date: Tue, 22 May 2018 12:10:57 -0500 From: "[email protected]" <[email protected]> To: [email protected] Subject: [RDD] *** position out of bounds on signal: ... Message-ID: <[email protected]> Content-Type: text/plain; charset=utf-8; format=flowed rdairplay is kicking out these error messages. Almost always it is complaining about two very short cuts in one cart which act as a divider between nearly all of our other cuts during playback. But I have seen the message about a few other cuts as well. I shortened one of the cuts slightly and that changed the "Pos: " (position?) to be a slightly smaller number.? So... it seems to imply the problem is at the end of the cut. Any ideas about what this means? Chris Howard Classic Book Radio ------------------------------ Message: 3 Date: Tue, 22 May 2018 16:35:15 -0700 From: Mike Carroll <[email protected]> To: Mircea Paun <[email protected]> Cc: USER DISCUSSION ABOUT THE RIVENDELL RADIO AUTOMATION SYSTEM <[email protected]> Subject: Re: [RDD] mysql query to file report Message-ID: <CAAG1q_vTcnf8iSFzyGYrcL41FT+5mx1MTnrRRr7EnF=w4qm...@mail.gmail.com> Content-Type: text/plain; charset="utf-8" What have you already tried? Give us a hint so we don't waste time duplicating your work. There can be many cuts in a cart. Which one do you want? On Tue, May 22, 2018 at 9:41 AM Mircea Paun <[email protected]> wrote: > Hi, > From previous posts and my additions I have reached this form of mysql > query: > ------------- > SELECT Audio_SRT.EVENT_DATETIME,\ > CART.TITLE,\ > CART.ARTIST,\ > CART.COMPOSER,\ > TIME_FORMAT(SEC_TO_TIME(Audio_SRT.LENGTH/1000),"%i:%s"),\ > TIME_FORMAT(SEC_TO_TIME(CART.FORCED_LENGTH/1000),"%i:%s"),\ > CART.LABEL,CART.ALBUM FROM `Audio_SRT` > LEFT JOIN CART ON Audio_SRT.CART_NUMBER = CART.NUMBER > WHERE (Audio_SRT.EVENT_DATETIME BETWEEN DATE_FORMAT(NOW() - INTERVAL 1 > MONTH, '%Y-%m-01 00:00:00') AND DATE_FORMAT(LAST_DAY(NOW() - INTERVAL 1 > MONTH), '%Y-%m-%d 23:59:59')) > AND (CART.GROUP_NAME in ('MUSIC','XMAS')) > INTO OUTFILE '/tmp/Playout.csv' > FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\n'; > --------------- > Does anyone help me to include PLAY_COUNTER field, from another "CUTS" > TABLE, in this query output, right after ARTIST ? > Thanks! > > *mIRCea* > > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > -------------- next part -------------- An HTML attachment was scrubbed... URL: < http://caspian.paravelsystems.com/pipermail/rivendell-dev/attachments/20180522/79d3881e/attachment-0001.html > ------------------------------ Message: 4 Date: Tue, 22 May 2018 19:37:06 -0400 From: Calvin Hones <[email protected]> To: [email protected] Subject: [RDD] 2.19.2: all buttons disabled in RDLogManager Message-ID: <ca+jghrnf-4s1nzfn4qpp2yxt5paec3nnk371fsleuek+2rs...@mail.gmail.com> Content-Type: text/plain; charset="utf-8" Hi, I'm back with more problems...went to generate a fresh batch of logs today and found that every option in RDLogManager is suddenly grayed out, save "close". Everything else seems to be in working order - RDAirPlay and RDLogEdit can play/edit logs that have already been generated, the library looks alright - it just won't let me generate any *new* logs, nor edit events, clocks, etc. Any ideas on what to do to get this fixed? Thanks in advance! Calvin Hones -------------- next part -------------- An HTML attachment was scrubbed... URL: < http://caspian.paravelsystems.com/pipermail/rivendell-dev/attachments/20180522/b2455340/attachment-0001.html > ------------------------------ Message: 5 Date: Wed, 23 May 2018 07:15:37 +0300 From: Mircea Paun <[email protected]> To: Mike Carroll <[email protected]> Cc: USER DISCUSSION ABOUT THE RIVENDELL RADIO AUTOMATION SYSTEM <[email protected]> Subject: Re: [RDD] mysql query to file report Message-ID: <[email protected]> Content-Type: text/plain; charset="us-ascii" First one. "Cut 001" or _001. Sent from my mobile device mIRCea > On 23 May 2018, at 02:35, Mike Carroll <[email protected]> wrote: > > What have you already tried? Give us a hint so we don't waste time duplicating your work. > > There can be many cuts in a cart. Which one do you want? > > >> On Tue, May 22, 2018 at 9:41 AM Mircea Paun <[email protected]> wrote: >> Hi, >> From previous posts and my additions I have reached this form of mysql query: >> ------------- >> SELECT Audio_SRT.EVENT_DATETIME,\ >> CART.TITLE,\ >> CART.ARTIST,\ >> CART.COMPOSER,\ >> TIME_FORMAT(SEC_TO_TIME(Audio_SRT.LENGTH/1000),"%i:%s"),\ >> TIME_FORMAT(SEC_TO_TIME(CART.FORCED_LENGTH/1000),"%i:%s"),\ >> CART.LABEL,CART.ALBUM FROM `Audio_SRT` >> LEFT JOIN CART ON Audio_SRT.CART_NUMBER = CART.NUMBER >> WHERE (Audio_SRT.EVENT_DATETIME BETWEEN DATE_FORMAT(NOW() - INTERVAL 1 MONTH, '%Y-%m-01 00:00:00') AND DATE_FORMAT(LAST_DAY(NOW() - INTERVAL 1 MONTH), '%Y-%m-%d 23:59:59')) >> AND (CART.GROUP_NAME in ('MUSIC','XMAS')) >> INTO OUTFILE '/tmp/Playout.csv' >> FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\n'; >> --------------- >> Does anyone help me to include PLAY_COUNTER field, from another "CUTS" TABLE, in this query output, right after ARTIST ? >> Thanks! >> >> mIRCea >> >> _______________________________________________ >> Rivendell-dev mailing list >> [email protected] >> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev -------------- next part -------------- An HTML attachment was scrubbed... URL: < http://caspian.paravelsystems.com/pipermail/rivendell-dev/attachments/20180523/f25acc9e/attachment-0001.html > ------------------------------ _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev End of Rivendell-dev Digest, Vol 61, Issue 21 *********************************************
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
