== IPP Progress Report for the week 2011.05.02 - 2011.05.06 == [[PageOutline]] (Up to [wiki:IPP_Progress_Reports IPP Progress Reports]) === Eugene Magnier === === Serge Chastel === === Heather Flewelling === === Roy Henderson === * Detection batches from last week loaded successfully. A relief. * able to test new, fast !DetectionCalib table with PSVO * work to confirm that we have the same calibrated magnitude in PSPS as in the original IPP smf files * Stack loading: * issue with NULL xPos and yPos values in !StackDetection: was failing load * discovered that deep stacks can have duplicate objIDs and NULL flux values in psf table, thus explaining some previous issues * power-cut on monday. Hassles getting datastore back up, loading all the stuff processed the night before * discovered hundreds of nightly stacks with 0.0 EXPTIME, thus screwing up flux calculations * gpc1 query kindly supplied by Bill, but highlighted that a proportion of the previous stacks had non-zero, but incorrect, EXPTIME * changed code to use Bill's query, and reloaded everything * dupe objID confusions in deep stacks - ok in detection table, NOT in object table. Reloaded all deep stacks AGAIN * merge failed on Friday: ID we are using for stackDetectID is not unique. Need to add stack ID to primary key as a temporary fix. * PSVO * discussions and testing of PSVO with query builder * made MOPSSchema class for query builder to use * slow queries now passed straight to TOPCAT, only first 1000 rows shown in table * many other minor changes === Bill Sweeney === === Chris Waters ===