There are several flavors of Wide Orbit automations. Is this the old SS32/Scott/Google audio? Replacing a bit of the metadata in the wav header can be automated. If you send me / attach a copy of one of the WO audio files you're dealing with ( a small one will do ) I will send you a small script/program to change that field to an expiration of 12/31/2099 you can put in a batch to run against all of them.
TC -----Original Message----- From: rivendell-dev-boun...@lists.rivendellaudio.org [mailto:rivendell-dev-boun...@lists.rivendellaudio.org] On Behalf Of Nathan Steele Sent: Monday, June 23, 2014 10:00 PM To: rivendell-dev@lists.rivendellaudio.org Subject: Re: [RDD] Expired cuts help, imported from wide orbit. Well, there seems to be no way around this. As far as I can tell, the Air Date/Time enabled sets Start_datetime and End_datetime fields when enabled and nulls them if disabled. Disabling in RD library fixes my problem, but setting the values to NULL in mysql does not. I need a way to force RD to recheck the validity of the entire library en masse after the SQL edits. even changing the validity fields doesn't work.....making the cuts /carts evergreen doesn't work either. Of course the root of the problem is the wrong endtimes coming in from the import, but I have to use the metadata or I won't have the artist and title info......there seems to be no way to use the metadata but ignore the start/end datetimes...... Well, this is a serious problem for anyone migrating from wide orbit......oh well the logs will play as long as the first cart is valid, it seems to keep playing so I must move on. SOMEONE is going to gt the mind numbingly boring task of going through 20000 carts and setting them all to start/end datetime disabled.....and it's not going to be ME. I thought about reimporting with the end date offset, but it is limited to 7 days... i need a hundred years or so....... Anyone know how I can strip the end dates out of the original files but leave theartist/title metadata? In an automated fashion of course...... Nathaniel C. Steele Chief Engineer/Technical Director WTCF-Southernlight and TheCross Online On 6/23/2014 5:47 PM, Nathan Steele wrote: > Of course this proccess took longer than the RDLibrary way......so > unless I can automate it, and that's above my head at the moment, it > doesn't help. > > At least I learned something today..... > > Nathaniel C. Steele > Chief Engineer/Technical Director > > WTCF-Southernlight > > and > > TheCross Online > > On 6/23/2014 5:44 PM, Nathan Steele wrote: >> Now I tried to fix a cart from MYSQL only. >> >> First I checked the length of cart 5652 (really the cut in that cart >> but it is only cut, and all carts so far only have one cut) >> >> >> >> mysql> SELECT * FROM CUTS WHERE CART_NUMBER = '5652' ; >> +------------+-------------+-----------+-----------------------+--------+--- ---+------+--------+---------------------+---------------------+------------ ---------+------+------+------+------+------+------+------+---------------+- ------------+-------------+--------+---------------------+-----------------+ --------------+---------------+----------+---------------+-------------+---- ------+----------+-----------+-------------+-----------+--------------+----- -----------+-------------------+-----------------+------------+------------- -----+----------------+------------------+----------------+ >> >> | CUT_NAME | CART_NUMBER | EVERGREEN | DESCRIPTION | >> OUTCUE | ISRC | ISCI | LENGTH | ORIGIN_DATETIME | >> START_DATETIME | END_DATETIME | SUN | MON | TUE | WED >> | THU | FRI | SAT | START_DAYPART | END_DAYPART | ORIGIN_NAME | >> WEIGHT | LAST_PLAY_DATETIME | UPLOAD_DATETIME | PLAY_COUNTER | >> LOCAL_COUNTER | VALIDITY | CODING_FORMAT | SAMPLE_RATE | BIT_RATE | >> CHANNELS | PLAY_GAIN | START_POINT | END_POINT | FADEUP_POINT | >> FADEDOWN_POINT | SEGUE_START_POINT | SEGUE_END_POINT | SEGUE_GAIN | >> HOOK_START_POINT | HOOK_END_POINT | TALK_START_POINT | TALK_END_POINT >> | >> +------------+-------------+-----------+-----------------------+--------+--- ---+------+--------+---------------------+---------------------+------------ ---------+------+------+------+------+------+------+------+---------------+- ------------+-------------+--------+---------------------+-----------------+ --------------+---------------+----------+---------------+-------------+---- ------+----------+-----------+-------------+-----------+--------------+----- -----------+-------------------+-----------------+------------+------------- -----+----------------+------------------+----------------+ >> >> | 005652_001 | 5652 | N | I Know Enough To Know | >> NULL | NULL | | 219834 | 2014-05-18 12:27:26 | 2014-06-01 >> 00:00:00 | 2075-06-06 00:00:00 | Y | Y | Y | Y | Y | Y >> | Y | NULL | NULL | rdhost | 1 | >> 2014-06-23 11:18:45 | NULL | 3 | 3 | 2 >> | 0 | 44100 | 0 | 2 | 0 | >> 0 | 219834 | -1 | -1 | -1 | >> -1 | -3000 | -1 | -1 | 0 | 17000 | >> +------------+-------------+-----------+-----------------------+--------+--- ---+------+--------+---------------------+---------------------+------------ ---------+------+------+------+------+------+------+------+---------------+- ------------+-------------+--------+---------------------+-----------------+ --------------+---------------+----------+---------------+-------------+---- ------+----------+-----------+-------------+-----------+--------------+----- -----------+-------------------+-----------------+------------+------------- -----+----------------+------------------+----------------+ >> >> 1 row in set (0.00 sec) >> >> >> >> Length is 219834. Checking the Cart: >> >> >> >> mysql> SELECT * FROM CART WHERE NUMBER = '5652' ; >> +--------+------+------------+-----------------------+-------------+-------+ ------+------+-------+-----------+--------+--------+-----------+----------+- ---------------+---------+------+------------+---------------+-------------- --+------------------+----------------------+---------------------+--------- -----+-----------------+------------+----------+---------------------+------ ---------------+----------------+----------------+-------------+-------+---- ----+-------------+-------+---------------------+------------------+-------- ---------+-------------+------------------+ >> >> | NUMBER | TYPE | GROUP_NAME | TITLE | ARTIST | ALBUM >> | YEAR | ISRC | LABEL | CONDUCTOR | CLIENT | AGENCY | PUBLISHER | >> COMPOSER | USER_DEFINED | SONG_ID | BPM | USAGE_CODE | >> FORCED_LENGTH | AVERAGE_LENGTH | LENGTH_DEVIATION | >> AVERAGE_SEGUE_LENGTH | AVERAGE_HOOK_LENGTH | CUT_QUANTITY | >> LAST_CUT_PLAYED | PLAY_ORDER | VALIDITY | START_DATETIME | >> END_DATETIME | ENFORCE_LENGTH | PRESERVE_PITCH | ASYNCRONOUS | >> OWNER | MACROS | SCHED_CODES | NOTES | METADATA_DATETIME | >> USE_EVENT_LENGTH | PENDING_STATION | PENDING_PID | PENDING_DATETIME | >> +--------+------+------------+-----------------------+-------------+-------+ ------+------+-------+-----------+--------+--------+-----------+----------+- ---------------+---------+------+------------+---------------+-------------- --+------------------+----------------------+---------------------+--------- -----+-----------------+------------+----------+---------------------+------ ---------------+----------------+----------------+-------------+-------+---- ----+-------------+-------+---------------------+------------------+-------- ---------+-------------+------------------+ >> >> | 5652 | 1 | 101 | I Know Enough To Know | Wine Family | >> NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL >> | NULL | 101_SP6633.wav | NULL | 0 | 0 | 0 >> | 0 | 0 | 0 >> | 0 | 1 | NULL | NULL >> | 2 | 2014-06-01 00:00:00 | 2075-06-01 00:00:00 | >> N | N | N | NULL | NULL | >> NULL | NULL | 2014-05-18 12:27:26 | N | >> NULL | NULL | NULL | >> +--------+------+------------+-----------------------+-------------+-------+ ------+------+-------+-----------+--------+--------+-----------+----------+- ---------------+---------+------+------------+---------------+-------------- --+------------------+----------------------+---------------------+--------- -----+-----------------+------------+----------+---------------------+------ ---------------+----------------+----------------+-------------+-------+---- ----+-------------+-------+---------------------+------------------+-------- ---------+-------------+------------------+ >> >> 1 row in set (0.00 sec) >> >> >> And Changing the Entry: >> >> >> >> mysql> UPDATE CART SET FORCED_LENGTH = '219834', AVERAGE_LENGTH = >> '219834' WHERE NUMBER = '5652' ; >> Query OK, 1 row affected (0.00 sec) >> Rows matched: 1 Changed: 1 Warnings: 0 >> >> mysql> >> >> >> And then go to Airplay, reload the log, and now that cart is white >> not red and has the length listed. >> >> Nathaniel C. Steele >> Chief Engineer/Technical Director >> >> WTCF-Southernlight >> >> and >> >> TheCross Online >> >> On 6/23/2014 5:38 PM, Nathan Steele wrote: >>> >>> Nathaniel C. Steele >>> Chief Engineer/Technical Director >>> >>> WTCF-Southernlight >>> >>> and >>> >>> TheCross Online >>> >>> On 6/23/2014 5:29 PM, Nathan Steele wrote: >>>> OK, It looks like when I touch the files, the FORCED_LENGTH and >>>> AVERAGE_LENGTH entries in the CART table go from 0, to whatever is >>>> appropriate. here is a snippet from my terminal. CART 101101 was >>>> one that was working properly, it was a new legal ID imported this >>>> morning. CART 002364 is one that didn't work, and the second >>>> instance is after I opened the cut in RDLibrary and clicked OK, not >>>> actually changing any fields. So....How do I update the Carts >>>> entries with the correct values without having to open each cut and >>>> click OK? and better yet, why Did this happen in the first place? >>>> >>>> mysql> SELECT * FROM CART WHERE CART_NUMBER = '101101' ; >>>> ERROR 1054 (42S22): Unknown column 'CART_NUMBER' in 'where clause' >>>> mysql> SELECT * FROM CART WHERE NUMBER = '101101' ; >>>> +--------+------+------------+------------+--------+-------+------------+--- ---+-------+-----------+--------+--------+-----------+----------+----------- ---+---------+------+------------+---------------+----------------+--------- ---------+----------------------+---------------------+--------------+------ -----------+------------+----------+----------------+--------------+-------- --------+----------------+-------------+-------+--------+-------------+----- --+---------------------+------------------+-----------------+-------------+ ------------------+ >>>> >>>> | NUMBER | TYPE | GROUP_NAME | TITLE | ARTIST | ALBUM | >>>> YEAR | ISRC | LABEL | CONDUCTOR | CLIENT | AGENCY | PUBLISHER >>>> | COMPOSER | USER_DEFINED | SONG_ID | BPM | USAGE_CODE | >>>> FORCED_LENGTH | AVERAGE_LENGTH | LENGTH_DEVIATION | >>>> AVERAGE_SEGUE_LENGTH | AVERAGE_HOOK_LENGTH | CUT_QUANTITY | >>>> LAST_CUT_PLAYED | PLAY_ORDER | VALIDITY | START_DATETIME | >>>> END_DATETIME | ENFORCE_LENGTH | PRESERVE_PITCH | ASYNCRONOUS | >>>> OWNER | MACROS | SCHED_CODES | NOTES | METADATA_DATETIME | >>>> USE_EVENT_LENGTH | PENDING_STATION | PENDING_PID | PENDING_DATETIME >>>> | >>>> +--------+------+------------+------------+--------+-------+------------+--- ---+-------+-----------+--------+--------+-----------+----------+----------- ---+---------+------+------------+---------------+----------------+--------- ---------+----------------------+---------------------+--------------+------ -----------+------------+----------+----------------+--------------+-------- --------+----------------+-------------+-------+--------+-------------+----- --+---------------------+------------------+-----------------+-------------+ ------------------+ >>>> >>>> | 101101 | 1 | LEGAL | Network ID | | | >>>> 0000-00-00 | NULL | | | | | | | >>>> | | 0 | 0 | 7900 | 7900 | 0 >>>> | 7998 | 0 | 1 | NULL | NULL >>>> | 2 | NULL | NULL | N | >>>> N | N | NULL | NULL | | NULL | >>>> 2014-06-23 09:19:15 | N | NULL | NULL | >>>> NULL | >>>> +--------+------+------------+------------+--------+-------+------------+--- ---+-------+-----------+--------+--------+-----------+----------+----------- ---+---------+------+------------+---------------+----------------+--------- ---------+----------------------+---------------------+--------------+------ -----------+------------+----------+----------------+--------------+-------- --------+----------------+-------------+-------+--------+-------------+----- --+---------------------+------------------+-----------------+-------------+ ------------------+ >>>> >>>> 1 row in set (0.00 sec) >>>> >>>> mysql> SELECT * FROM CART WHERE NUMBER = '002364' ; >>>> +--------+------+------------+------------------+-------------+-------+----- -+------+-------+-----------+--------+--------+-----------+----------+------ ----------+---------+------+------------+---------------+----------------+-- ----------------+----------------------+---------------------+-------------- +-----------------+------------+----------+---------------------+----------- ----------+----------------+----------------+-------------+-------+--------+ -------------+-------+---------------------+------------------+------------- ----+-------------+------------------+ >>>> >>>> | NUMBER | TYPE | GROUP_NAME | TITLE | ARTIST | ALBUM | >>>> YEAR | ISRC | LABEL | CONDUCTOR | CLIENT | AGENCY | PUBLISHER | >>>> COMPOSER | USER_DEFINED | SONG_ID | BPM | USAGE_CODE | >>>> FORCED_LENGTH | AVERAGE_LENGTH | LENGTH_DEVIATION | >>>> AVERAGE_SEGUE_LENGTH | AVERAGE_HOOK_LENGTH | CUT_QUANTITY | >>>> LAST_CUT_PLAYED | PLAY_ORDER | VALIDITY | START_DATETIME | >>>> END_DATETIME | ENFORCE_LENGTH | PRESERVE_PITCH | ASYNCRONOUS | >>>> OWNER | MACROS | SCHED_CODES | NOTES | METADATA_DATETIME | >>>> USE_EVENT_LENGTH | PENDING_STATION | PENDING_PID | PENDING_DATETIME >>>> | >>>> +--------+------+------------+------------------+-------------+-------+----- -+------+-------+-----------+--------+--------+-----------+----------+------ ----------+---------+------+------------+---------------+----------------+-- ----------------+----------------------+---------------------+-------------- +-----------------+------------+----------+---------------------+----------- ----------+----------------+----------------+-------------+-------+--------+ -------------+-------+---------------------+------------------+------------- ----+-------------+------------------+ >>>> >>>> | 2364 | 1 | 101 | I Choose To Live | Autum Nelon | >>>> NULL | NULL | NULL | NULL | NULL | NULL | NULL | >>>> NULL | NULL | 101_SP2369.wav | NULL | 0 | 0 >>>> | 0 | 0 | 0 | 0 >>>> | 0 | 1 | NULL | NULL | 2 >>>> | 2014-06-01 00:00:00 | 2075-06-01 00:00:00 | N | >>>> N | N | NULL | NULL | . | NULL | >>>> 2014-05-18 07:30:54 | N | NULL | >>>> NULL | NULL | >>>> +--------+------+------------+------------------+-------------+-------+----- -+------+-------+-----------+--------+--------+-----------+----------+------ ----------+---------+------+------------+---------------+----------------+-- ----------------+----------------------+---------------------+-------------- +-----------------+------------+----------+---------------------+----------- ----------+----------------+----------------+-------------+-------+--------+ -------------+-------+---------------------+------------------+------------- ----+-------------+------------------+ >>>> >>>> 1 row in set (0.00 sec) >>>> >>>> mysql> SELECT * FROM CART WHERE NUMBER = '002364' ; >>>> +--------+------+------------+------------------+-------------+-------+----- -------+------+-------+-----------+--------+--------+-----------+----------+ ----------------+---------+------+------------+---------------+------------- ---+------------------+----------------------+---------------------+-------- ------+-----------------+------------+----------+---------------------+----- ----------------+----------------+----------------+-------------+-------+--- -----+-------------+-------+---------------------+------------------+------- ----------+-------------+------------------+ >>>> >>>> | NUMBER | TYPE | GROUP_NAME | TITLE | ARTIST | ALBUM | >>>> YEAR | ISRC | LABEL | CONDUCTOR | CLIENT | AGENCY | PUBLISHER >>>> | COMPOSER | USER_DEFINED | SONG_ID | BPM | USAGE_CODE | >>>> FORCED_LENGTH | AVERAGE_LENGTH | LENGTH_DEVIATION | >>>> AVERAGE_SEGUE_LENGTH | AVERAGE_HOOK_LENGTH | CUT_QUANTITY | >>>> LAST_CUT_PLAYED | PLAY_ORDER | VALIDITY | START_DATETIME | >>>> END_DATETIME | ENFORCE_LENGTH | PRESERVE_PITCH | ASYNCRONOUS >>>> | OWNER | MACROS | SCHED_CODES | NOTES | METADATA_DATETIME | >>>> USE_EVENT_LENGTH | PENDING_STATION | PENDING_PID | PENDING_DATETIME >>>> | >>>> +--------+------+------------+------------------+-------------+-------+----- -------+------+-------+-----------+--------+--------+-----------+----------+ ----------------+---------+------+------------+---------------+------------- ---+------------------+----------------------+---------------------+-------- ------+-----------------+------------+----------+---------------------+----- ----------------+----------------+----------------+-------------+-------+--- -----+-------------+-------+---------------------+------------------+------- ----------+-------------+------------------+ >>>> >>>> | 2364 | 1 | 101 | I Choose To Live | Autum Nelon >>>> | | 0000-00-00 | NULL | | | | | >>>> | | 101_SP2369.wav | | 0 | 0 | 237900 >>>> | 237900 | 0 | 237986 | 0 >>>> | 1 | NULL | NULL | 1 | >>>> 2014-06-01 00:00:00 | 2075-06-06 00:00:00 | N | >>>> N | N | NULL | NULL | . | NULL | >>>> 2014-06-23 13:26:03 | N | NULL | >>>> NULL | NULL | >>>> +--------+------+------------+------------------+-------------+-------+----- -------+------+-------+-----------+--------+--------+-----------+----------+ ----------------+---------+------+------------+---------------+------------- ---+------------------+----------------------+---------------------+-------- ------+-----------------+------------+----------+---------------------+----- ----------------+----------------+----------------+-------------+-------+--- -----+-------------+-------+---------------------+------------------+------- ----------+-------------+------------------+ >>>> >>>> 1 row in set (0.00 sec) >>>> >>>> mysql> >>>> >>>> Nathaniel C. Steele >>>> Chief Engineer/Technical Director >>>> >>>> WTCF-Southernlight >>>> >>>> and >>>> >>>> TheCross Online >>>> >>>> On 6/23/2014 3:36 PM, Thomas Churchill wrote: >>>>> Not around the test system to check, but you might try checking >>>>> the DB entry for one for the cuts that is not working, export it >>>>> save it etc. >>>>> Then do the >>>>> "touch" and go back and look at the same entry and see what if >>>>> anything changed - perhaps that might give a clue as to what you >>>>> need to do to edit using MySQL. Of course the changed data might >>>>> be in another table you're not monitoring I suppose. I haven't >>>>> gotten to looking at the structure in detail yet. But just a >>>>> thought. >>>>> >>>>> TC >>>>> >>>>> >>>>> >>>>> -----Original Message----- >>>>> From: rivendell-dev-boun...@lists.rivendellaudio.org >>>>> [mailto:rivendell-dev-boun...@lists.rivendellaudio.org] On Behalf >>>>> Of Nathan Steele >>>>> Sent: Monday, June 23, 2014 1:24 PM >>>>> To: Wayne Merricks; Rivendell Mailing List >>>>> Subject: Re: [RDD] Expired cuts help, imported from wide orbit. >>>>> >>>>> 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 >>>>> >>>>> >>>>> >>>>> >>>>> >>>> >>> >>> _______________________________________________ >>> 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