If you didn't use a batch file for the initial course, you can as yet
create one:
SQL> SET PAGES 0
SQL> SPOOL NNN-student-enroll.txt
SQL> SELECT '"NNN","' || u.user_id || '","' || i.role || '"'
FROM bb50.course_main c, bb50.course_users i, bb50.users u
WHERE c.course_id = 'OOO'
AND i.crsmain_pk1 = c.pk1
AND i.crsmain_sos_id_pk2 = c.sos_id_pk2
AND u.pk1 = i.users_pk1
AND u.sos_id_pk2 = i.users_sos_id_pk2
ORDER BY i.role, u.user_id;
SQL> SPOOL OFF
(replace OOO by the initial course id, and NNN by the new course id).
If you only want to copy the students:
SQL> SELECT '"NNN","' || u.user_id || '","' || i.role || '"'
FROM bb50.course_main c, bb50.course_users i, bb50.users u
WHERE c.course_id = 'OOO'
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
ORDER BY i.role, u.user_id;
Kind regards,
Herta
Allen, Justine wrote:
>The quickest way is use a batch file for enrolment.
>
>*************************************************************
>This message and any files transmitted with it are confidential and are
>intended solely for the use of the individual to whom they are addressed.
>This communication represents the originator's personal views and opinions,
>which do not necessarily reflect those of Nescot College. If you have
>received this message in error you are requested to preserve this
>confidentiality and to advise the sender of any errors of transmission.
>
>
>
>
>
>
> ------------------------------------------------------------------------
>
> Subject:
> Blackboard Users
> From:
> George Howie <[log in to unmask]>
> Date:
> Wed, 26 Mar 2003 09:36:30 -0000
> To:
> [log in to unmask]
>
>
>Hi
>
>Can anyone tell me the quickest way to select students from one course and
>enrol them on another course on the Blackboard system.
>
>thanks
>
>
--
******************************************************
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
******************************************************
"For something fulfilled this hour, loved or endured."
(W.H. Auden)
******************************************************
|