Blackboard

Ask The Doctors Home » Blackboard Learn » System Administrators (IT Pros) » Where to find group and user ID in database

Where to find group and user ID in database

rated by 0 users
Not Answered This post has 0 verified answers | 5 Replies | 2 Followers

Top 100 Contributor
Female
20 Posts
Robyn Harcott posted on 3 Apr 2012 2:57 PM

Apr 3, 2012 10:13:05 AM - Member 

[Membership, update, group=IMS_SCT50317.201205, user=IMS_SCT18732]

I need to update the Batch Uid Prefix - mostly by removing it (IMS_SCT)- can you tell me the best way to do this?  I'm assuming I can run an update query if I could find the proper table . . .

All Replies

Top 10 Contributor
Male
6,271 Posts
Reply
Michael Zimmerman replied on 3 Apr 2012 3:07 PM

Robyn,

The information for users is in the USERS table, but directly editing the database may not be the best way to do what you're trying to do.

You mentioned both batch_uid and user_id, which are two different things, and also said something about "group".  What, specifically, do you need to do?  Are you creating users via snapshots, or batch files, or through the GUI?  What kind of "group" are you talking about?

Mike

Top 100 Contributor
Female
20 Posts
Reply
Robyn Harcott replied on 3 Apr 2012 3:21 PM

Batch Uid Prefix
Used to prefix identifiers for objects created by this integration to avoid id conflicts. It is not recommended that this be modified after data has been created for this integration.
this is in the IMS Enterprise Integration 1.1 properties
A number of records were imported with IMS_SCT in the Prefix box - we needed to take this out and we re-imported the course using an XML, but I don't really want to re-import the users - if I don't have to . . .  We're using the LDI-to-Learn Bridge and it's working beautifully for what we need.  I'm not sure if the users are being updated as we go along or not - I can't find the BatchUID for the users . ..

Top 100 Contributor
Female
20 Posts
Reply
Robyn Harcott replied on 3 Apr 2012 3:22 PM

It's not recommended to change this after integration, but we didn't have a choice . . .

Top 10 Contributor
Male
6,271 Posts
Reply
Michael Zimmerman replied on 3 Apr 2012 3:37 PM

Robyn,

Where is that quoted from?  I'm afraid I don't really know anything at all about the "LDI-to-Learn Bridge", but there isn't really a "Batch Uid Prefix" in Blackboard itself.

Where are you looking for the batch_uid for the users?  Are you looking in the Blackboard database itself, or somewhere else?

Mike

Page 1 of 1 (6 items) | RSS