BLKBRD-L Notes

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

// posted by Bill @ 2:42 PM

From: blkbrd-l - A list for Blackboard course administrators and faculty
[mailto:BLKBRD-L@asu.edu] On Behalf Of Glen Parker
Sent: Tuesday, November 01, 2005 10:46 AM
To: BLKBRD-L@asu.edu
Subject: Re: [BLKBRD-L] Query to determine Blackboard course usage

I take it back, the query needs a bit of tweeking for Oracle. Also, this
will probably take a long time to run.

SELECT
U.FIRSTNAME ||' '||U.LASTNAME as "User Name" ,count(A.PK1) as "Login
Count"
FROM
ACTIVITY_ACCUMULATOR A INNER JOIN USERS U ON A.USER_PK1 = U.PK1 WHERE
A.TIMESTAMP >= to_date('09/01/2003','MM/DD/YYYY') AND A.TIMESTAMP <=
to_date('09/19/2003','MM/DD/YYYY) AND A.DATA = 'Login succeeded.' AND
A.EVENT_TYPE = 'LOGIN_ATTEMPT' AND
U.INSTITUTION_ROLES_PK1 = 2
group by A.User_PK1,U.FIRSTNAME, U.LASTNAME order by
U.LASTNAME,U.FIRSTNAME;

On 11/1/05, Glen Parker <glparker@usf.edu> wrote:
>
> BB_BB60_STATS is a different schema, not a table. If you wanted to run

> it against the ACTIVITY_ACCUMULATOR table in the BB_BB60_STATS schema,

> you can either log into the BB_BB60_STATS schema, or prefix the table
> with teh schema name, like BB_BB60_STATS.ACTIVITY_ACCUMULATOR
>
> The query above should run fine, and will run against your 'main'
> schema's activity_accumulator table. To run against your stats schema,

> replace ACTIVITY_ACCUMULATOR with BB_BB60_STATS.ACTIVITY_ACCUMULATOR
> in line 5 of the above query.
>
> Thanks, Glen
>
>
>
> On 11/1/05, John Pfeffer <jpfeffer@buffalo.edu> wrote:
> >
> > apologies for my previous post, I meant to include the original
> > message I was referring to- here it is: (My question was, is this
> > doable against an oracle database? This refers to a table I can't
> > find in ours, BB_BB60_stats. Thanks.
> >
> > "In our MS SQL Dtabase, I am using the following query to get the
> > login count for the Instructors. It will give you the Instructor
> > names with no.
> > of times they successfully logon to Blackboard during a period. It
> > should be run on the "BB_BB60_Stats" database.
> >
> > Simply change the Date Range for your need. Also put "1" instead of
"2 "
> > to get student login count.
> >
> > With Regards,
> > Jomon
> >
> >
> > SELECT
> > U.FIRSTNAME +' '+ U.LASTNAME as [User Name] ,count(A.PK1) as [Login
> > Count] FROM ACTIVITY_ACCUMULATOR A INNER JOIN USERS U ON A.USER_PK1
> > = U.PK1 WHERE A.[TIMESTAMP] >= '09/01/2003' AND A.[TIMESTAMP] <=
> > '09/19/2003' AND A.DATA = 'Login succeeded.' AND A.EVENT_TYPE =
> > 'LOGIN_ATTEMPT' AND
> > U.INSTITUTION_ROLES_PK1 = 2
> >
> > group by A.User_PK1,U.FIRSTNAME, U.LASTNAME order by
> > U.LASTNAME,U.FIRSTNAME"
> >
> > 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 @ 9:13 AM

From: blkbrd-l - A list for Blackboard course administrators and faculty
[mailto:BLKBRD-L@asu.edu] On Behalf Of Glen Parker
Sent: Tuesday, November 01, 2005 10:44 AM
To: BLKBRD-L@asu.edu
Subject: Re: [BLKBRD-L] Query to determine Blackboard course usage

BB_BB60_STATS is a different schema, not a table. If you wanted to run
it against the ACTIVITY_ACCUMULATOR table in the BB_BB60_STATS schema,
you can either log into the BB_BB60_STATS schema, or prefix the table
with teh schema name, like BB_BB60_STATS.ACTIVITY_ACCUMULATOR

The query above should run fine, and will run against your 'main'
schema's activity_accumulator table. To run against your stats schema,
replace ACTIVITY_ACCUMULATOR with BB_BB60_STATS.ACTIVITY_ACCUMULATOR in
line 5 of the above query.

Thanks, Glen

On 11/1/05, John Pfeffer <jpfeffer@buffalo.edu> wrote:
>
> apologies for my previous post, I meant to include the original
> message I was referring to- here it is: (My question was, is this
> doable against an oracle database? This refers to a table I can't find

> in ours, BB_BB60_stats. Thanks.
>
> "In our MS SQL Dtabase, I am using the following query to get the
> login count for the Instructors. It will give you the Instructor names
with no.
> of times they successfully logon to Blackboard during a period. It
> should be run on the "BB_BB60_Stats" database.
>
> Simply change the Date Range for your need. Also put "1" instead of "2
"
> to get student login count.
>
> With Regards,
> Jomon
>
>
> SELECT
> U.FIRSTNAME +' '+ U.LASTNAME as [User Name] ,count(A.PK1) as [Login
> Count] FROM ACTIVITY_ACCUMULATOR A INNER JOIN USERS U ON A.USER_PK1 =
> U.PK1 WHERE A.[TIMESTAMP] >= '09/01/2003' AND A.[TIMESTAMP] <=
> '09/19/2003' AND A.DATA = 'Login succeeded.' AND A.EVENT_TYPE =
> 'LOGIN_ATTEMPT' AND
> U.INSTITUTION_ROLES_PK1 = 2
>
> group by A.User_PK1,U.FIRSTNAME, U.LASTNAME order by
> U.LASTNAME,U.FIRSTNAME"

// posted by Bill @ 8:38 AM

-----Original Message-----
From: blkbrd-l - A list for Blackboard course administrators and faculty
[mailto:BLKBRD-L@asu.edu] On Behalf Of Leslie D. Harris
Sent: Thursday, September 08, 2005 9:35 AM
To: BLKBRD-L@asu.edu
Subject: Re: [BLKBRD-L] System Email Address

Hi, Bedan (and others).

Thanks for the very specific information. I tried to find that setting
again, and didn't succeed in finding it on my own until I received the
message below.

That address is actually set to mine. There is a second address on the
system itself that you have to change from the Blackboard server itself,
and not from the GUI. I finally asked my TSM how to do it, and here is
what he said:

You need to change the System Admin information in the
bb-config.properties file.

1. Look for the following lines:

bbconfig.admin.name=
bbconfig.admin.email=

2. Enter the correct information there and save the changes.
3. Finally, run a PushConfigUpdates.bat from the command prompt (located
under \blackboard\tools\admin) to solidify this change.

That's how you do it - at least from messages from that "Lost Password"
and "Copy Course" functions.

Leslie Harris
Blackboard Course Administrator
The University of Scranton

Bedan Kamau wrote:

>Control Panel > HELP > and Local Support contact
>
>
>Instructional Designer
>Office of Distributed Learning
>5500 University Parkway
>Cal State University-San Bernardino
>San Bernardino, CA 92407-2397
>OFFICE: PL- 252
>(909) 537-3416.
>Fax: (909) 537-7637
>bkamau@csusb.edu
>http://odl.csusb.edu
>
>-----Original Message-----
>From: blkbrd-l - A list for Blackboard course administrators and
>faculty [mailto:BLKBRD-L@asu.edu] On Behalf Of Ramirez, Jose
>Sent: Wednesday, September 07, 2005 11:00 AM
>To: BLKBRD-L@asu.edu
>Subject: Re: System Email Address
>
>We are using Basic 6.2.3.23. I found that the email address being sent

>is from the Administrator account. Change the email address from the
>Admin profile. That worked for us.
>
>Jose Ramirez
>Systems Operator
>College of the Redwoods
>Information Technology
>jose-ramirez@redwoods.edu
>
>
>-----Original Message-----
>From: Leslie D. Harris [mailto:harrisl4@SCRANTON.EDU]
>Sent: Monday, August 29, 2005 7:02 AM
>To: BLKBRD-L@asu.edu
>Subject: System Email Address
>
>Hi, Folks.
>
>I know this has come up on the list before, but I couldn't find the
>answer when searching the archives, and Blackboard's Knowledge Base is
>not only messed up right now (it looks like some of the underlying
>frame pages and style sheets have been moved), but that provided no
help, either.
>
>Our system e-mail messages (for when I copy a course or when a student
>uses the Lost Password form) is being sent from an account of one of
>our former system administrators who has now retired. I'd like to
>change that e-mail address, in case a student tries to respond to the
message.
>
>I recall that the setting needs to be changed on the server itself - in

>other words, that I can't do it from the GUI side. But I can't recall
>the details. We're Blackboard Basic 6.3.1, Windows 2003, SQL 2000.
>
>Any solutions? Thanks in advance for your help.
>
>Leslie Harris
>Blackboard Course Administrator
>The University of Scranton

// posted by Bill @ 8:31 AM

From: blkbrd-l - A list for Blackboard course administrators and faculty
[mailto:BLKBRD-L@asu.edu] On Behalf Of Brian Nielsen
Sent: Thursday, September 08, 2005 10:34 AM
To: BLKBRD-L@asu.edu
Subject: Re: [BLKBRD-L] APP Pack 3 Glitch? Small Print / Pasteing

One thing you should check in IE regarding the small type issue: go to
Tools, Internet Options, click on the "Accessibility" button in the
"General" tab and check the box "Ignore font sizes specified on web
pages." That may fix your problem on an ongoing basis, rather than
changing the text size every time you hit Bb.

Brian
At 06:53 PM 9/7/2005, Lynnda Brown wrote:
>As for the small print, again I don't know why, but all the students
>have to do is go to the View menu of IE and change the text size back
>to medium.
>
>Maybe someone who is more technical can explain the "why." I would be
>interested...
>
>
>Lynnda :)

// posted by Bill @ 7:45 AM