didn't someone post the msql needed to get the users out of the database a
little while ago... (not that you're allowed to on your licence) or if
you've moved to oracle your oracle dba should be able to at least pull
your instructors out again? haven't tried, but i should go back through
those messages about the mysql if i were you (after easter: go and have a
holiday!)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Kate Boardman
Learning Technologies Team
Information Technology Service
University of Durham DH1 3LE
Direct tel: 0191 374 1502
Email: [log in to unmask]
On Thu, 28 Mar 2002, ben hyde wrote:
> Hi Kate
>
> You make this sound so straight forward. If only...
>
> The problem is I do not know who all the users are - as staff have been added
> an various ways - and may not necessarily even be on our staff records system
> - let alone using the same username. And there isn't an easy way for me to
> extract all instructors and teaching assistants from the system. Even with
> level 3 (learning System ;) - there isn't a built in way to extract data about
> users or courses from the Bb system. I guess this is therefore going to be an
> on-going frustration for us? I think it may require a total rethink of our
> procedures - so we link the Bb users with staff records. Now just need to
> make sure our staff record system is reliable. And then work out how to
> manage the transition... and try and make sure staff don't end up with
> duplicate accounts. I guess the only real problem will be that during this
> process any personal information that the user has entered that is not
> contained in our records will be removed?
>
> If anyone works out another way of doing this - set the PIR of all instructors
> and teaching assistants on the system to staff (sounds even easier now :( -
> then please let me know.
>
> cheers,
> ben
>
>
> Kate Boardman wrote:
>
> > Batch create accounts with role set. No way of updating existing users if
> > you have upgraded them with the system. Take 'em out and recreate as batch
> > with roles included.
> >
> > ~~~~~~~~~~~~~~~~~~~~~
> > Kate Boardman
> > Learning Technologies Team
> > IT Service
> > University of Durham
> > South Road
> > Durham DH1 3LE
> >
> > Tel.: 0191 374 1502
> > Email: [log in to unmask] <mailto:[log in to unmask]>
> > Web: http://www.dur.ac.uk/k.l.boardman
> >
> > -----Original Message-----
> > From: A list to promote discussion amongst MLE Blackboard/Courseinfo
> > users in UK [mailto:[log in to unmask]]On Behalf Of ben
> > hyde
> > Sent: 27 March 2002 15:40 PM
> > To: [log in to unmask]
> > Subject: primary institution role
> >
> > Just got my hands on our new version (L3/LS) of Bb up and running and I
> > am busily tinkering with the customisable features.
> >
> > However, for them to work effectively, you need to set the users primary
> > institution role. Hence my gripe - when you create a new instructor (say
> > when you create their course site) you cannot designate their role and
> > it is set as student!! Anyone know a way round this?
> >
> > ben
>
|