George Gaudette's IST-SA Blog

By gaudette

E.g.:

/usr/local/courseinfo/jre/bin/jre -mx1024m -cp /usr/local/courseinfo/docs/common/java:/usr/local/courseinfo/docs/common/java/twz1jdbcForMysql.jar com.blackboard.chameleon.Main CONFIGPATH /usr/local/courseinfo/docs/common/java/com/blackboard/chameleon/ userid cinfo pwd courseinfo temp /usr/local/courseinfo/recyclebin export ci4 /usr/local/courseinfo/recyclebin/export_00cwrmedms315.zip log /usr/local/courseinfo/recyclebin/php-importexportlog.txt  parts courses=’00cwrmedms315;documents;staff;links;assessments;pools;users;groups;discussions’ params rootpath=’/usr/local/courseinfo;ignore-unavailable-resources;verbosity=5′

posted in CourseInfo Administration on 03.9.2009 at 5:46 PM

By gaudette

…is not hard:

select distinct user_id into outfile “/mypath/myfile.txt” from user_auth_group where grp like ‘p’ or grp like ‘t’ or grp like ‘g’ or grp like ‘b’ order by user_id ASC;

p=instructor
t=TA
g=grader
b=course builder

(and “s” is student of course)

posted in CourseInfo Administration, Uncategorized on 03.9.2009 at 5:46 PM