Friday, June 10, 2005
[BLKBRD-L] make all courses unavailable
From: blkbrd-l - A list for Blackboard course administrators and faculty
[mailto:BLKBRD-L@asu.edu] On Behalf Of Neal Caidin
Sent: Friday, June 10, 2005 11:23 AM
To: BLKBRD-L@asu.edu
Subject: Re: [BLKBRD-L] make all courses unavailable
>wondering if there is an easy way to mark all existing courses as
unavailable (we have about 900)
Yes. If you are on the enterprise version, the snapshot tool is the way
to go. There is an AVAILABLE_IND field that you can use to set to Y or
N. You might need to do an SQL query to get the list of courses that
you need, unless you have that stored somewhere else.
If it is really for **all** courses the sql would be
SELECT batch_uid FROM bb_bb60.course_main;
There is another related field "course_id" in the bb_bb60.course_main
table and usually that is equal to batch_uid, but batch_uid is the
official identifier for the snapshot EXTERNAL_COURSE_KEY field.
- Neal
==================================
Neal Caidin
Center for Instructional Technology
Email: neal.caidin@duke.edu
Voice: 919-660-5981 Fax: 919-660-5923
Box 90198, Duke University
Durham, NC 27708-0198
==================================
Directions to BLKBRD-L archives and settings:
http://is.asu.edu/instruction/faq/usingBLKBRD-L.html
