Tuesday, November 22, 2005
Batch Course Unavailable
From: blkbrd-l - A list for Blackboard course administrators and faculty [mailto:BLKBRD-L@asu.edu] On Behalf Of Tony Harris
Sent: Tuesday, November 22, 2005 3:13 PM
To: BLKBRD-L@asu.edu
Subject: Re: [BLKBRD-L] Batch Course Unavailable
Ah, well since everyone has posted this, then let me say yes, we do the SQL bit about a month after each semester to turn off the courses for that semester (we use a term code imbedded in the name, which makes it easy).
Could do it by snapshot of course, and that might be easier for you.
For us, generating the appropriate file out of our SIS would probably be more work than just doing the one line SQL statement.
The statement Chuck and others have shared will work in Oracle too.
Tony Harris
Assistant CTO
Community College of Vermont
harrist@ccv.edu
(802) 241-3535
Zhë dishthe shthál ñe lhôñ svóná záxá.
(The direct path is not always straight.)
-------------------------------------------
PRIVACY & CONFIDENTIALITY NOTICE: This message is for the designated recipient only and may contain privileged, confidential, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of an email received in error is prohibited.
Rothman, Chuck wrote:
>I believe version 6.2 will still run the Blackboard utilities:
>http://www.wcc.vccs.edu/services/blackboard/tipsTricks.html (scroll
>down for bbUtilities).
>
>Otherwise, there's a simple query to the database that will make the
>change:
>
>update course_main set available_ind='N' where course_id like '%U05%'
>and available_ind='Y'
>
>(This works for MS-SQL; not sure about others) Change the '%U05%' to
>match some unique element in the courseID. Make sure to include the
>single quotes; the % is the wild card.
>
>
>---
>Chuck Rothman, Educational Technology (518) 783-2573
>Siena College I&TS
>515 Loudon Rd., Loudonville, NY 12211
>"Ever pick your feet in Poughkeepsie?"
>
>
>-----Original Message-----
>From: blkbrd-l - A list for Blackboard course administrators and
>faculty [mailto:BLKBRD-L@asu.edu] On Behalf Of Chad Lewis
>Sent: Tuesday, November 22, 2005 1:43 PM
>To: BLKBRD-L@asu.edu
>Subject: Batch Course Unavailable
>
>Is there a way to make courses unavailable through a batch process?
>The thought of changing 450 manually is not attractive. I am running 6.2
>enterprise.
>
>Thanks,
>Chad Lewis
>Catawba College
>cwlewis@catawba.edu
>
>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
