By the way the dates are all set valid now but I still have to touch the
cuts in RDLibrary before RDAirplay recognizes the changes......
Nathaniel C. Steele
Chief Engineer/Technical Director
WTCF-Southernlight
and
TheCross Online
On 6/23/2014 1:20 PM, Nathan Steele wrote:
It did blank the record, unfortunately the cut was still showing 00:00
in length until I went into the cut and saved it again, which put in
the default dates for today.......
Perhaps setting the enforce date time to disabled would be better than
nulling the field.......
but, no matter what, RDAirplay still reports no audio data and length
00:00 until i go into RDlibrary and the cut and save it. I don't
actually have to change anything just go into the cart, open the cut,
and hit ok.
I really don't want to have to do that for all 20,000
cuts........anythoughts?
Nathaniel C. Steele
Chief Engineer/Technical Director
WTCF-Southernlight
and
TheCross Online
On 6/23/2014 12:09 PM, Wayne Merricks wrote:
Hi,
NULL should have blanked the record, its a special case. If you want
to try a date the format is a bit weird as its a DATETIME field:
'YYYY-MM-DD HH:MM:SS'
e.g.
'2014-06-23 17:07:30'
So I guess:
UPDATE CUTS SET START_DATETIME = '2014-06-22 00:00:00', END_DATETIME
= '2050-12-31 23:59:59';
That would set the start to yesterday at midnight and the end to the
end of 2050.
Wayne Merricks
The Voice Asia
On 23/06/14 16:49, Nathan Steele wrote:
OK, Maybe I need to put a date in because I get the same problem
until I go into library and select a cart and edit the cut it adds a
start and end date of today then it shows like it should....
What is the correct syntax for the date in mysql. I tried putting
'06-01-2199' instead of null but that didn't do the trick.....
Nathaniel C. Steele
Chief Engineer/Technical Director
WTCF-Southernlight
and
TheCross Online
On 6/23/2014 10:38 AM, Wayne Merricks wrote:
Hi,
The cuts have a start and end date as well as the carts. If its
the cuts:
UPDATE CUTS SET START_DATETIME = NULL, END_DATETIME = NULL
and carts:
UPDATE CART SET START_DATETIME = NULL, END_DATETIME = NULL
Wayne Merricks
The Voice Asia
On 23/06/14 15:31, Nathan Steele wrote:
OK, sorry, this didn't work as fantastic as I thought. I have
determined that having the expired dates is causing my problems in
RDAirplay that cause the carts to show in red and say no audio
available and length 00:00, even though they will actually
play....I think this could be interfering with my music merge with
MusicMaster as well, since the system seems to think there is no
audio data......
Can you maybe give me MYsql commands to set the end date in all
the cuts? or maybe better, remove the start and end dates, as they
aren't strictly necessary right?
Nathaniel C. Steele
Chief Engineer/Technical Director
WTCF-Southernlight
and
TheCross Online
On 5/20/2014 10:18 AM, Nathan Steele wrote:
Worked just fantastic.
Nathaniel C. Steele
Chief Engineer/Technical Director
WTCF-Southernlight
and
TheCross Online
On 5/19/2014 11:00 AM, Wayne Merricks wrote:
UPDATE CUTS SET EVERGREEN = 'Y';
This will set every cut to evergreen so make sure this is what
you want to do.
Wayne Merricks
The Voice Asia
On 19/05/14 15:57, Nathan Steele wrote:
I"m going to guess this is a windows date versus linux date
thing, but almost all of the 20,000 or so carts I imported from
Wide orbit have expired cuts with dates like 1933......I think
wide orbit required start and end times, but for RD I"m fine
without using them. I tried to select all carts and edit in
rdlibrary, but since this a per cut setting, no dice.
Can someone tell me the SQL command to set all cuts in the
database to evergreen?
Thanks!
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
