On Wed, 27 Feb 2002 10:34:06 +0000, Mark Gamble <[log in to unmask]> wrote:
>Hi folks
>
>Anyone know whether it's possible to batch enrol the same set of users
>(already on system) to around 40 courses (also already on system)? I'm using
>FileMaker Pro to generate comma separated .txt files.
>
>--
>Regards,
>Mark
>
>
>Mark Gamble
>Head, AV-Media Services, Learning Resources
>University of Luton, Park Square, Luton LU1 3JU
>(+44)1582 489260 (x2260) Fax (+44)1582 489259 Mobile 077 200 686 05.
I don't know of an option in blackboard, but this sql command will at least
generate the list of students currently enrolled in a course (replace XXXX
by the course id):
SELECT u.user_id
FROM bb50.course_main c, bb50.course_users i, bb50.users u
WHERE c.course_id = 'XXXX'
AND i.crsmain_pk1 = c.pk1
AND i.crsmain_sos_id_pk2 = c.sos_id_pk2
AND i.role = 's'
AND u.pk1 = i.users_pk1
AND u.sos_id_pk2 = i.users_sos_id_pk2
/
Hope this helps,
Herta
Herta Van den Eynde
Toledo system management
K.U.Leuven - Ludit
W.de Croylaan 52A
B-3001 Heverlee
Belgium
tel: +32 (0)16 322 166
fax: +32 (0)16 322 999
|