BLKBRD-L Notes

From: blkbrd-l - A list for Blackboard course administrators and faculty
[mailto:BLKBRD-L@asu.edu] On Behalf Of Jomon Abraham
Sent: Friday, June 10, 2005 12:06 PM
To: BLKBRD-L@asu.edu
Subject: Re: [BLKBRD-L] make all courses unavailable

Hi,

The course_main table contains both courses and organizations. In order
to make only the courses available, you need to set the service_level
flag='F'. ( to get organizations, use service_level='C')

So the final update query for courses will be

update course_main set Available_IND='N' where service_level='F'

Regards,
Jomon

Michael F Zimmerman <mzimmerman@MAIL.UNOMAHA.EDU> Sent by: blkbrd-l - A
list for Blackboard course administrators and faculty <BLKBRD-L@asu.edu>
06/10/2005 11:06 AM
Please respond to
blkbrd-l - A list for Blackboard course administrators and faculty
<BLKBRD-L@asu.edu>

To
BLKBRD-L@asu.edu
cc

Subject
Re: make all courses unavailable

In SQL:

update course_main set available_ind = 'N' where available_ind = 'Y'

Mike
-----------------------------------------------------------------
Michael Zimmerman, System Administrator
University of Nebraska-Omaha, ITS Academic Information Systems
Email: mzimmerman@mail.unomaha.edu
Phone: 402-554-4357

blkbrd-l - A list for Blackboard course administrators and faculty
<BLKBRD-L@asu.edu> wrote on 06/10/2005 09:43:05 AM:

> I am running Blackboard Learning System release 6.2.3.23 on widnows
> 2003 with MS SQL2000. I am still learning my way around the product
> and was wondering if there is an easy way to mark all existing courses

> as unavailable (we have about 900).
>
> Thanks
>
> Brian Grinstead
>
> Directions to BLKBRD-L archives and settings:
> http://is.asu.edu/instruction/faq/usingBLKBRD-L.html

Directions to BLKBRD-L archives and settings:
http://is.asu.edu/instruction/faq/usingBLKBRD-L.html

Directions to BLKBRD-L archives and settings:
http://is.asu.edu/instruction/faq/usingBLKBRD-L.html

// posted by Bill @ 5:52 PM