I'm trying to figure out how to use the %CHANID% and %STARTTIMEISO% data to lookup a recording in the oldrecorded table. %STARTTIMEISO% correlates to the start time in recorded, for example:<br>1091 2012-06-19 18:29:00 2012-06-19 19:05:00 ABC World News With Diane Sawyer<br>
<br>but the starttime column in oldrecorded has a different value (1 minute later), so I can't map directly from one to another:<br>1091 2012-06-19 18:30:00 2012-06-19 19:00:00 ABC World News With Diane Sawyer<br>
<br>it looks like recorded uses the actual start/stop times (including early/late padding) whereas oldrecorded use the strict scheduled starttime.<br><br>Do I need to pull the pad time from the DB and adjust %STARTTIMEISO% in my perl script to do the oldrecorded lookup or is there some easier way? I'm running 25-fixes.<br>
<br>Thanks<br>Dave<br>