1. Here's my conversion to mm:ss (take off the first and last quote marks)
"=TEXT(E2/86400000,CHOOSE(MATCH(E2,{0,60,3600},1),"[h]:mm:ss","[h]:mm:ss","[h]:mm:ss"))"
On Wed, Dec 9, 2015 at 8:03 PM, Brandon <[email protected]> wrote:
> Hello again!
>
> Robert Orr was very helpful pointing me in the right direction to find the
> SQL tables that contain the Rivendell library data I need. Thank you,
> Robert!
>
> I'm about to send off my existing DB in a spreadsheet for RCS to convert
> to GSelector and could use some more help with the following:
>
>
> 1. RCS is going to convert the existing data to GSelector data but
> they require time in mm:ss format. It looks like the time is calculated in
> milliseconds?? Anyone know a shortcut (or a formula to convert to mm:ss
> format in a libreoffice / open document spreadsheet?) Google hasn't been
> much help with this one. Right now, I'm entering the times manually --
> using the the "Segue Start" parameter to specify the length of each cut
> -- and will continue to do so unless someone has a better idea :-)
> 2. Since Title and Artist info is saved to the CART table and
> RDAirplay plays carts with multiple cuts, it seems logical to me that
> RDAirPlay only cares about CARTs not CUTs as far as log generation is
> concerned. Is it correct to assume that the (CART) table holds the
> critical info for external music scheduling software log generation?
> 3. I can't find any kind of Rivendell music log in a text format, only
> in the SQL database. Does RDAirPlay read it directly from the SQL DB? Or
> does it generate a text file somewhere?
> 4. Which begs the next question... When you merge music in
> RDLogManager, is it actually importing your third-party log into SQL for
> RDAirPlay to read from?
> 5. Just finished reading this Wiki
> <http://rivendell.tryphon.org/wiki/Importing_External_Logs_into_Rivendell>
> and
> this wiki
>
> <http://rivendell.tryphon.org/wiki/Importing_External_logs_into_Rivendell_-_Music_and_Traffic>
> on importing music from external software. Right now, in Rivendell, I
> specify a Timed(MakeNext), scheduler EVENT on my top of the hour IDs, which
> seems to do a pretty good job of keeping me on time and dropping songs and
> their associated imaging if I'm running over. All of my Rivendell Events
> have "segue" as the default transition. Should I let my pre-merge Rivendell
> Clock handle the Top of the Hour ID with the hard start time and drop it
> from the first position in my GSelector clock/log to keep things working
> the same way? Or can you achieve the same behavior with an external
> scheduler?
> 6. Wait, thinking out loud here: if the transition type and hard start
> times are functions of EVENTS (in RDLogmanager/Edit Events) then it's not
> dependent on Rivendell or Selector clocks... Correct? Does RDAirPlay
> interpret the transition and hard times as each cart is played? Can anyone
> confirm or correct?
> 7. What are the absolute required fields from the Rivendell database
> for an external music scheduler, like GSelector, to generate a proper
> program log for Rivendell to read? Right now, I'm planning on sending:
> NUMBER, GROUP, TITLE, ARTIST, ALBUM, LABEL, COMPOSER, and LENGTH -- which
> I'm entering manually.
> 8. Does Rivendell have a mechanism for reconciling played music logs
> back into GSelector to maintain proper rotation and keep actual play
> history vs. scheduled history?
> 9. Not using any macros yet, but if/when I do, how is that handled
> with an external scheduler? Do they work like carts? Build them in
> Rivendell, assign a cart number and schedule the cart with external
> scheduler?
>
> Sorry, I know that's a ton of info... but hopefully this will help someone
> else down the road too :-)
>
> With gratitude,
> Brandon
>
> _______________________________________________
> 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
