System Administrators (IT Pros)

Re: Where to find group and user ID in database

Michael Zimmerman — Tue, 03 Apr 2012 19:37:07 GMT

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

Re: Where to find group and user ID in database

Robyn Harcott — Tue, 03 Apr 2012 19:22:07 GMT

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

Re: Where to find group and user ID in database

Robyn Harcott — Tue, 03 Apr 2012 19:21:29 GMT

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 . ..

Re: Where to find group and user ID in database

Michael Zimmerman — Tue, 03 Apr 2012 19:07:31 GMT

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

Where to find group and user ID in database

Robyn Harcott — Tue, 03 Apr 2012 18:57:00 GMT

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 . . .