Ship and ROV Core Datastreams : UpdateRovCtdCfg This page last changed on Oct 18, 2010 by rich. 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')

Document generated by Confluence on Feb 04, 2026 08:53