Herta
What you have outlined is something I have wanted to be able to do!
Is it as possible to update aspects of a students records in a similar way?
I want to be able to identify students who have not entered an email address and add
their insitute email.
I would be very grateful if you could help!
What about extracting a list of instructors and teaching assistants?
This is another thing I would really like to be able to do....
Does the extracted data include their personal details (email, user name, etc...)
Mark
Re. batch enrolment
It is pretty straight forward - using User Utilities - batch enrol users
Format is:
Course ID*, Login ID*, Role in Course, Available, Course Availability
If they don't already exist you simply need to do the batch create users first.
hope this helps,
ben
Herta Van den Eynde wrote:
> 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
--
IT Research and Development Unit
THE LONDON INSTITUTE
65 Davies Street London W1K 5DA
phone: +44 (0)20 7514 8107
fax: +44 (0)20 7514 8050
email: [log in to unmask]
web: http://www.seeingdrawing.com
--
BlackBoard / LInst Ønline (staff support)
http://online.linst.ac.uk
--
|