NAME: recontupd PURPOSE: (one line only) Update start and ending times for RECON event video files in the database DESCRIPTION: The recon.data database is queried for all event videos (catid='E') whose utdate is known and utstart or utend is still set to NULL. Broken video files are skipped. For those videos scanned, the beginning and end of the video is extracted to determine the start and stop time of the video. The location of the video end is expected to be consistent with the video duration posted in the database. If the file ends early that file will be marked broken in the database and utend will be left as NULL. CATEGORY: Database CALLING SEQUENCE: recontupd INPUTS: OPTIONAL INPUT PARAMETERS: KEYWORD INPUT PARAMETERS: DT - integer number of seconds to skip into the file to read the starting time code. The default is 0 which will lead to decoding the second video frame. This should be used sparingly and usually when there is a single stubborn frame remaining to be processed. If used, the starting time is estimated from the frame read, pushed backward by the offset, DT, used. IDX - If provided, turns on a special mode and just a single database entry is scanned. In this mode, the usually email report is disabled. MAXTODO - mostly for testing, if set will restrict this program to process no more than MAXXTODO records. OUTPUTS: all output is to the recon.data database table KEYWORD OUTPUT PARAMETERS: COMMON BLOCKS: SIDE EFFECTS: RESTRICTIONS: PROCEDURE: MODIFICATION HISTORY: 2016/03/06, Written by Marc W. Buie, Southwest Research Institute 2016/03/11, MWB, added mail notification and MAXTODO keyword 2016/03/25, MWB, added IDX keyword