For my 10c Brandon I would be looking very closely at Rivendell's
Scheduling abilities and saving yourself a lot of angst.
Pretty much every 'feature' of all the music scheduling systems is in
there somewhere.
Ok there are some plays like 2 in a row, 3 in a row, which are a little
harder to set up. But very possible.
If you add to the inventory; you are going to have to do the
export-conversion-schedule-import all over again.
On 10/12/15 15:03, Brandon 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?
No; because CUTS can have different lengths. Solution is to have one CUT
per CART.
1. 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?
Yup!
1. Or does it generate a text file somewhere?
2. 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?
Yup!
1. 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.
You can do this 20:20 as well to keep it tighter. Simplest way is to
schedule 5 events in the :58 minute each 10 seconds duration but
actually song selections that may be 2 or 3 minutes long. Log will be
grossly over scheduled. Put a time sync event in at 59:59 or so to drop
the excess and keep the log on track.
1. 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?
You can do either or ....
1. 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?
Yes times get updated as carts play based on actuals including segues.
RD Events can be of any duration in the CLOCK [eg: 1min] while actual
carts can be any duration. Real time predictions are updated as each
event plays.
1. 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.
I would send CART # Artist Title Duration Genre Tempo Daypart and any
other Scheduler codes you may have entered. Composer may be a useful
item in some formats.
1. 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?
Yes
1. 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?
Yes they will work no matter how you schedule them.
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
I will repeat my plug for the Rivendell Music Scheduler, it's actually
very versatile, and using Scheduler Codes and Clock Rules you can create
intricate playlists. Nevertheless you can export all you need to
whatever and import a file with all the carts and all sorts of other
stuff into the RD Playout Log as well as an Ad Log from a schedule
billing system. I am surprised that RCS don't have an import/export
template for Rivendell already in there. In fact there is no reason why
they couldn't read the MySQL direct or vice versa, so you are only
keying data in once. Besides you can't beat the price!
regards
Robert
--
Robert Jeffares
Communication Consultants
The Wireless Station 1530kHz
Big Valley Radio
Radio Spice
Raupo Radio 1170kHz
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
