Index: branches/eam_branches/ipp-20101205/ippTools/share/Makefile.am
===================================================================
--- branches/eam_branches/ipp-20101205/ippTools/share/Makefile.am	(revision 29959)
+++ branches/eam_branches/ipp-20101205/ippTools/share/Makefile.am	(revision 30102)
@@ -316,4 +316,5 @@
 	receivetool_revert.sql \
 	receivetool_toadvance.sql \
+	regtool_checkburntoolimfile.sql \
 	regtool_create_dup_table.sql \
 	regtool_export_exp.sql \
@@ -331,4 +332,5 @@
 	regtool_updatebyquery.sql \
 	regtool_updatebyqueryimfile.sql \
+	regtool_pendingburntoolimfile.sql \
 	stacktool_associationdefine_select.sql \
 	stacktool_definebyquery_insert.sql \
Index: branches/eam_branches/ipp-20101205/ippTools/share/chiptool_find_rawexp.sql
===================================================================
--- branches/eam_branches/ipp-20101205/ippTools/share/chiptool_find_rawexp.sql	(revision 29959)
+++ branches/eam_branches/ipp-20101205/ippTools/share/chiptool_find_rawexp.sql	(revision 30102)
@@ -1,9 +1,10 @@
 -- this query is used to find potental rawExps to be queued for chiptool
 -- processeing
-SELECT
+SELECT DISTINCT 
     rawExp.*,
     newExp.label
 FROM rawExp
 JOIN newExp using (exp_id)
+LEFT JOIN chipRun USING (exp_id)
 WHERE
     rawExp.fault = 0
Index: branches/eam_branches/ipp-20101205/ippTools/share/pubtool_definerun.sql
===================================================================
--- branches/eam_branches/ipp-20101205/ippTools/share/pubtool_definerun.sql	(revision 29959)
+++ branches/eam_branches/ipp-20101205/ippTools/share/pubtool_definerun.sql	(revision 30102)
@@ -3,5 +3,6 @@
     client_id,
     stage_id,
-    src_label
+    src_label,
+    output_format
 FROM (
     -- Get diffs to publish
@@ -9,5 +10,6 @@
         client_id,
         diff_id AS stage_id,
-        diffRun.label AS src_label
+        diffRun.label AS src_label,
+	output_format
     FROM publishClient
     JOIN diffRun
@@ -28,5 +30,6 @@
         client_id,
         cam_id AS stage_id,
-        camRun.label AS src_label
+        camRun.label AS src_label,
+	output_format
     FROM publishClient
     JOIN camRun
@@ -43,5 +46,6 @@
         client_id,
         diff_phot_id AS stage_id,
-        diffPhotRun.label AS src_label
+        diffPhotRun.label AS src_label,
+	output_format
     FROM publishClient
     JOIN diffPhotRun
Index: branches/eam_branches/ipp-20101205/ippTools/share/pubtool_pending.sql
===================================================================
--- branches/eam_branches/ipp-20101205/ippTools/share/pubtool_pending.sql	(revision 29959)
+++ branches/eam_branches/ipp-20101205/ippTools/share/pubtool_pending.sql	(revision 30102)
@@ -9,4 +9,5 @@
         publishClient.stage,
         publishClient.workdir,
+	publishClient.output_format,
         diffRun.diff_id AS stage_id,
         rawExp.camera,
@@ -35,4 +36,5 @@
         publishClient.stage,
         publishClient.workdir,
+	publishClient.output_format,
         camRun.cam_id AS stage_id,
         rawExp.camera,
@@ -56,4 +58,5 @@
         publishClient.stage,
         publishClient.workdir,
+	publishClient.output_format,
         diffPhotRun.diff_phot_id AS stage_id,
         rawExp.camera,
Index: branches/eam_branches/ipp-20101205/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- branches/eam_branches/ipp-20101205/ippTools/share/pxadmin_create_tables.sql	(revision 29959)
+++ branches/eam_branches/ipp-20101205/ippTools/share/pxadmin_create_tables.sql	(revision 30102)
@@ -9,4 +9,5 @@
     uri VARCHAR(255),
     epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    use_compress SMALLINT,
     PRIMARY KEY(camera, telescope)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -251,4 +252,5 @@
     md5sum VARCHAR(32),
     burntool_state SMALLINT,
+    video_cells TINYINT DEFAULT 0,
     PRIMARY KEY(exp_id, class_id),
     KEY(tmp_class_id),
@@ -1643,5 +1645,8 @@
     workdir VARCHAR(255) NOT NULL, -- working directory
     comment VARCHAR(255),            -- for human memory
-    PRIMARY KEY(client_id)
+    name varchar(64) default NULL, -- unique client_id verbose identifier
+    output_format SMALLINT NOT NULL default 1, -- format output versioning
+    PRIMARY KEY(client_id),
+    UNIQUE KEY name (name)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
Index: branches/eam_branches/ipp-20101205/ippTools/share/regtool_checkburntoolimfile.sql
===================================================================
--- branches/eam_branches/ipp-20101205/ippTools/share/regtool_checkburntoolimfile.sql	(revision 30102)
+++ branches/eam_branches/ipp-20101205/ippTools/share/regtool_checkburntoolimfile.sql	(revision 30102)
@@ -0,0 +1,31 @@
+SELECT DISTINCT
+       exp_name,
+       rawImfile.uri,
+       summitExp.dateobs AS registered,
+       summitExp.imfiles,
+       summitExp.fault AS summit_fault,
+       pzDownloadExp.state AS download_state,
+       newExp.state AS newExp_state,
+       rawExp.state AS rawExp_state,
+       rawImfile.data_state AS imfile_state,
+       newExp.exp_id,
+       summitExp.exp_type,
+       rawExp.dateobs,
+       rawExp.obs_mode AS obs_mode,
+       rawExp.object AS object,
+       rawImfile.burntool_state AS burntool_state,
+       rawImfile.class_id,
+       (pzDownloadExp.state = 'stop') AS is_downloaded,
+       (rawImfile.burntool_state IS NOT NULL) AS is_registered
+       FROM
+            summitExp
+            LEFT JOIN pzDownloadExp USING(exp_name)
+            LEFT JOIN newExp ON exp_name = tmp_exp_name
+            LEFT JOIN rawExp USING(exp_id, exp_name)
+            LEFT JOIN rawImfile USING(exp_name)
+       WHERE
+             summitExp.dateobs >= '@DATE@T00:00:00'
+	     AND summitExp.dateobs <= '@DATE@T23:59:59'
+	     AND (rawImfile.class_id = '@CLASS_ID@' OR rawImfile.class_id IS NULL)
+	     AND (exp_name <= '@EXP_NAME@')                                                                     
+ORDER BY summitExp.dateobs
Index: branches/eam_branches/ipp-20101205/ippTools/share/regtool_pendingburntoolimfile.sql
===================================================================
--- branches/eam_branches/ipp-20101205/ippTools/share/regtool_pendingburntoolimfile.sql	(revision 30102)
+++ branches/eam_branches/ipp-20101205/ippTools/share/regtool_pendingburntoolimfile.sql	(revision 30102)
@@ -0,0 +1,31 @@
+SELECT DISTINCT
+       summitExp.exp_name,
+       rawImfile.uri,
+       summitExp.dateobs AS registered,
+       summitExp.imfiles,
+       summitExp.fault AS summit_fault,
+       pzDownloadExp.state AS download_state,
+       newExp.state AS newExp_state,
+       rawExp.state AS rawExp_state,
+       rawImfile.data_state AS imfile_state,
+       newExp.exp_id,
+       newImfile.tmp_class_id,
+       summitExp.exp_type,
+       rawExp.dateobs,
+       rawExp.obs_mode AS obs_mode,
+       rawExp.object AS object,
+       rawImfile.burntool_state AS burntool_state,
+       rawImfile.class_id,
+       (pzDownloadExp.state = 'stop') AS is_downloaded,
+       (rawImfile.burntool_state IS NOT NULL) AS is_registered
+       FROM
+            summitExp
+            LEFT JOIN pzDownloadExp USING(exp_name)
+            LEFT JOIN newExp ON exp_name = tmp_exp_name
+	    LEFT JOIN newImfile USING(exp_id)
+            LEFT JOIN rawExp USING(exp_id, exp_name)
+            LEFT JOIN rawImfile ON (rawImfile.exp_name = newExp.tmp_exp_name AND rawImfile.tmp_class_id = newImfile.tmp_class_id)
+       WHERE
+             summitExp.dateobs >= '@DATE@T00:00:00'
+	     AND summitExp.dateobs <= '@DATE@T23:59:59'
+ORDER BY newImfile.tmp_class_id,summitExp.dateobs
Index: branches/eam_branches/ipp-20101205/ippTools/share/regtool_pendingexp.sql
===================================================================
--- branches/eam_branches/ipp-20101205/ippTools/share/regtool_pendingexp.sql	(revision 29959)
+++ branches/eam_branches/ipp-20101205/ippTools/share/regtool_pendingexp.sql	(revision 30102)
@@ -1,48 +1,54 @@
 SELECT DISTINCT
-    exp_id,
-    tmp_exp_name,
-    tmp_camera,
-    tmp_telescope,
-    state,
-    workdir,
-    workdir_state,
-    reduction,
-    dvodb,
-    tess_id,
-    end_stage,
-    label,
-    camera,
-    filter,
-    obs_mode,
-    obs_group,
-    epoch,
-    dateobs
-FROM
-    (SELECT
-       newExp.*,
-       newImfile.tmp_class_id,
-       rawImfile.tmp_class_id as raw_tmp_class_id,
-       rawImfile.camera,
-       rawImfile.filter,
-       rawImfile.dateobs,
-       rawImfile.obs_mode,
-       rawImfile.obs_group
-    FROM newExp
-    JOIN newImfile
-       USING(exp_id)
-    LEFT JOIN rawExp
-       USING(exp_id)
-    LEFT JOIN rawImfile
-        ON newImfile.exp_id = rawImfile.exp_id
-        AND newImfile.tmp_class_id = rawImfile.tmp_class_id
-    WHERE
-        newExp.state = 'run'
-        AND rawExp.exp_id IS NULL
--- where hook %s
-    GROUP BY
-        newExp.exp_id
-    HAVING
-        COUNT(newImfile.tmp_class_id) = COUNT(rawImfile.tmp_class_id)
-        AND SUM(rawImfile.fault) = 0
+     exp_id,
+     tmp_exp_name,
+     tmp_camera,
+     tmp_telescope,
+     state,
+     workdir,
+     workdir_state,
+     reduction,
+     dvodb,
+     tess_id,
+     end_stage,
+     label,
+     camera,
+     filter,
+     obs_mode,
+     obs_group,
+     epoch,
+     dateobs
+FROM 
+        (
+        select DISTINCT * from 
+         (
+          select newExp.*,count(newImfile.tmp_class_id) AS new_count
+          from newExp
+          LEFT JOIN newImfile USING (exp_id)
+          LEFT JOIN rawExp USING (exp_id) 
+          where 
+           newExp.state = 'run' AND rawExp.exp_id IS NULL
+          GROUP BY newExp.exp_id
+         ) AS NEWEXPOSURES
+         JOIN 
+         (
+          select DISTINCT newExp.exp_id,
+	  rawImfile.camera,
+	  rawImfile.filter,
+	  rawImfile.dateobs,
+	  rawImfile.obs_mode,
+	  rawImfile.obs_group,
+	  count(rawImfile.tmp_class_id) AS raw_count
+          from newExp
+          LEFT JOIN rawExp USING (exp_id) 
+          LEFT JOIN rawImfile USING (exp_id)
+          where 
+           newExp.state = 'run' AND rawExp.exp_id IS NULL
+           AND rawImfile.data_state = 'full'
+	   -- where hook %s
+          GROUP BY newExp.exp_id
+          HAVING SUM(rawImfile.fault) = 0
+         ) AS RAWEXPOSURES
+	 USING (exp_id)
+        WHERE raw_count = new_count 
+    ) AS Foo
 -- limit hook %s
-    ) as Foo