Here are the steps used to put the 3PI.PV1 calibration info into the database on 2013-08-06

# dump Images.dat
ftlist columns=NAME,MCAL,DMCAL,SECZ,EXPTIME,TZERO,PHOTCO,FLAGS,UBERCAL_DIST /data/ipp060.0/gpc1/catdir/LAP.ThreePi.20120706.v2/Images.working.dat T > Images.working.txt


# loop over entries and select values for each exposure from the up to 60 rows in the images table
# Note this program has hardcoded values for the photcode information. A correct implementation would
# get the values from there.
perl extractinfo < Images.working.txt > 3pi.pv1.calibration.txt



# read that file and update the relExp entries
perl updatecalib 3pi.pv1.calibration.txt >& updatecalib.log


Note that there are 224597 rows in relExp for 3PI.PV1 but only 211793 values extracted from DVO.
12804 are currently missing.
1253 of the relExps are for camRuns with bad quality so those are expected to be missing.
11551 are missing

Heather points out that the lower declination area in slice 18 has not been loaded into dvo yet.
This accounts for 8104 of them.

This leaves 3447 to track down. This will be easier once the updates are done
