Index: openacs-4/packages/evaluation/www/admin/evaluations/grades-sheet-parse.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/evaluations/grades-sheet-parse.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/evaluation/www/admin/evaluations/grades-sheet-parse.xql	7 Jul 2004 17:26:44 -0000	1.2
+++ openacs-4/packages/evaluation/www/admin/evaluations/grades-sheet-parse.xql	30 Jul 2004 22:50:10 -0000	1.3
@@ -6,7 +6,8 @@
 <fullquery name="get_task_info">      
       <querytext>
 
-	    select task_name 
+	    select task_name, task_item_id,
+		number_of_members
         from evaluation_tasks et 
         where task_id=:task_id
 
@@ -21,6 +22,38 @@
       </querytext>
 </fullquery>
 
+<fullquery name="task_group">      
+      <querytext>
+
+	select count(*) from evaluation_task_groups etg where group_id = :party_id and task_item_id = :task_item_id
+
+      </querytext>
+</fullquery>
+
+<fullquery name="valid_user">      
+      <querytext>
+
+	select coun(*) from cc_users where person_id = :party_id
+
+      </querytext>
+</fullquery>
+
+<fullquery name="valid_student">      
+      <querytext>
+
+	select count(*) 
+	from persons p,
+	registered_users ru,
+               dotlrn_member_rels_approved app
+	       where app.community_id = :community_id
+               and app.user_id = ru.user_id
+	       and app.user_id = p.person_id
+               and app.user_id = :party_id
+	       and app.role = 'student'
+
+      </querytext>
+</fullquery>
+
 <fullquery name="get_item_id">      
       <querytext>