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
