Index: trunk/ippToPsps/jython/objectbatch.py
===================================================================
--- trunk/ippToPsps/jython/objectbatch.py	(revision 33776)
+++ trunk/ippToPsps/jython/objectbatch.py	(revision 33777)
@@ -105,7 +105,8 @@
         filterCount = len(filters)
 
-        self.logger.infoPair("Available filters", filters)
+        self.logger.infoPair("Available filters in Photcodes", filters)
 
         # the 'code' now defines the order in the cps file that the mags are listed for a given filter
+        self.logger.infoPair("Adding magnitudes from", "cps table")
         for filter in filters:
 
@@ -123,4 +124,14 @@
             self.scratchDb.execute(sql)
 
+        # now set to null all MeanMagErr values > 0.5 (cut set by Gene, 2012-04-12)
+        cut = 0.5
+        self.logger.infoPair("Setting to NULL all MeanMagErr value >", "%f" % cut)
+        for filter in filters:
+
+            sql = "UPDATE Object \
+                   SET " + filter[1] + "MeanMagErr = null \
+                   WHERE " + filter[1] + "MeanMagErr > " + str(cut)
+            self.scratchDb.execute(sql)
+
     '''
     Inserts colors
@@ -128,4 +139,5 @@
     def updateColors(self):
 
+        self.logger.infoPair("Calculating", "colors")
         sql = "UPDATE Object \
                SET \
@@ -189,5 +201,4 @@
             return False
 
-
         # add row count columns so we can perform joins to get colors
         self.logger.infoPair("Adding 'row' columns to", "Object and cps tables")
@@ -195,8 +206,6 @@
         self.scratchDb.addRowCountColumn(cpsTableName, "row")
 
-        self.logger.infoPair("Adding magnitudes from", "cps table")
         self.insertMags(cpsTableName)
 
-        self.logger.infoPair("Calculating", "colors")
         self.updateColors()