Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 12097)
+++ trunk/ippTools/share/Makefile.am	(revision 12174)
@@ -9,3 +9,4 @@
 	regtool_find_unprocessed_imfile.sql \
 	regtool_processedimfile.sql \
-	regtool_pendingexp.sql
+	regtool_pendingexp.sql \
+	chiptool_queuerawexp.sql
Index: trunk/ippTools/share/chiptool_completely_processed_exp.sql
===================================================================
--- trunk/ippTools/share/chiptool_completely_processed_exp.sql	(revision 12097)
+++ trunk/ippTools/share/chiptool_completely_processed_exp.sql	(revision 12174)
@@ -12,14 +12,14 @@
     ON chipPendingExp.exp_tag = rawExp.exp_tag
 LEFT JOIN chipProcessedExp
-    ON chipPendingExp.exp_tag = chipProcessedExp.exp_tag
+    ON chipPendingExp.chip_id = chipProcessedExp.chip_id
 LEFT JOIN chipPendingImfile
-    ON chipPendingExp.exp_tag = chipPendingImfile.exp_tag
+    ON chipPendingExp.chip_id = chipPendingImfile.chip_id
 LEFT JOIN chipProcessedImfile
-    ON chipPendingExp.exp_tag = chipProcessedImfile.exp_tag
+    ON chipPendingExp.chip_id = chipProcessedImfile.chip_id
 WHERE
-    chipProcessedExp.exp_tag IS NULL
-    AND chipPendingImfile.exp_tag IS NULL
-    AND chipProcessedImfile.exp_tag IS NOT NULL
+    chipProcessedExp.chip_id IS NULL
+    AND chipPendingImfile.chip_id IS NULL
+    AND chipProcessedImfile.chip_id IS NOT NULL
 GROUP BY
-    chipPendingExp.exp_tag
+    chipPendingExp.chip_id
 HAVING rawExp.imfiles = COUNT(chipProcessedImfile.class_id)
Index: trunk/ippTools/share/chiptool_find_unprocessed_imfile.pl
===================================================================
--- trunk/ippTools/share/chiptool_find_unprocessed_imfile.pl	(revision 12097)
+++ trunk/ippTools/share/chiptool_find_unprocessed_imfile.pl	(revision 12174)
@@ -3,6 +3,6 @@
 FROM chipPendingImfile
 LEFT JOIN chipProcessedImfile
-    USING(exp_tag, class_id)
+    USING(chip_id, class_id)
 WHERE
-    chipProcessedImfile.exp_tag IS NULL
+    chipProcessedImfile.chip_id IS NULL
     AND chipProcessedImfile.class_id IS NULL
Index: trunk/ippTools/share/chiptool_pendingimfile.sql
===================================================================
--- trunk/ippTools/share/chiptool_pendingimfile.sql	(revision 12097)
+++ trunk/ippTools/share/chiptool_pendingimfile.sql	(revision 12174)
@@ -5,7 +5,7 @@
 FROM chipPendingImfile
 JOIN chipPendingExp
-    USING(exp_tag)
+    USING(chip_id)
 JOIN rawExp
-    USING(exp_tag)
+    ON chipPendingExp.exp_tag = rawExp.exp_tag
 LEFT JOIN chipMask
     ON chipPendingExp.label = chipMask.label
Index: trunk/ippTools/share/chiptool_queuerawexp.sql
===================================================================
--- trunk/ippTools/share/chiptool_queuerawexp.sql	(revision 12174)
+++ trunk/ippTools/share/chiptool_queuerawexp.sql	(revision 12174)
@@ -0,0 +1,15 @@
+-- we can only enqueue one exp_tag at a time or the generated chip_id of all
+-- put the last one inserted will be lost
+INSERT INTO chipPendingExp
+    SElECT
+        0,              -- chip_id
+        exp_tag,        -- exp_tag
+        0xdeadbeef,     -- guide_id
+        '%s',           -- label
+        '%s',           -- recipe
+        '%s',           -- expgroup
+        '%s'            -- dvodb 
+   FROM rawExp
+   WHERE
+        rawExp.fault = 0
+        AND rawExp.exp_tag = '%s'
Index: trunk/ippTools/share/chiptool_queuerawimfile.sql
===================================================================
--- trunk/ippTools/share/chiptool_queuerawimfile.sql	(revision 12174)
+++ trunk/ippTools/share/chiptool_queuerawimfile.sql	(revision 12174)
@@ -0,0 +1,11 @@
+INSERT INTO chipPendingImfile
+    SELECT
+        chipPendingExp.chip_id,
+        rawImfile.class_id,
+        rawImfile.uri
+    FROM chipPendingExp
+    JOIN rawImfile
+        USING(exp_tag)
+    WHERE
+        rawImfile.fault = 0
+        AND chipPendingExp.chip_id = LAST_INSERT_ID()