Perl program run on solstice (later equinox?).  Reads from the shoreside replicated database tables that hold the labview CTDConfigv4.ini files.

Has cfg file name hard coded!!

Map network drive and look at Z:\DTS\EXPD\RovCtd\updateRovCtdCfg.pl

Kicked off as part of the loadNightlyRovctd.bat file that is run by solstice SQLServerAgent job: EXPD_NightlyRovctdLoad

Depends on the CfgFileMonitor service running on the ships, and successful replicaion of those databases to shore.  The shoreside vehicle-specific tables are a snapshot copy of the at-sea tables.** They get blown away every night **

UpdateRovctdCfg.pl is where the vehicle-specific config tables get mined to produce the final cfg table that has the combined and parsed calibration info (the RovCtdCfg table) It has a composit primary key if vehicle and configfile id.  (The configfileid coming from the vehicle specific table's primary key which is 'id'. 

UpdateRovctd compares the ventana and tiburon tables to the 'parsed'  RovCtdCfg table looking for missing calibrations, note how the combination of the select and the union form a list of missing calibrations with the composite key:

SELECT id,vehicle='docr',localtime
 FROM RovCtdCfg_Tiburon
 Where filename like '%CTDcoeff4.ini'
 AND id NOT IN (select cfgfileid_fk
                 from RovCtdCfg
                 where vehicle='docr')
 UNION
 SELECT id, vehicle='vnta',localtime
 FROM RovCtdCfg_Ventana
 Where filename like '%CTDcoeff4.ini'
 AND id NOT IN (select cfgfileid_fk
                  from RovCtdCfg
                  where vehicle='vnta')