We have a Blackboard Learn 9.1 SP5 installation and I am having a problem assigning specific institution roles to specific modules. In short, not all existing institution roles from our blackboard install, appear on the list of available instititution roles to be assigned to modules, from the module edit properties page. I present bellow a work flow, to illustrate better what I am trying to achieve. Any help would be appreciated.
Is this a known bug, or am I doing something wrong?
Appreciate your help and kind regards,
I am not seeing this behavior on my SP5 server with newly created Institutional Roles. What sort of Role ID are you using for this new role? Do you see it among the options for granting "Available To" permissions on existing/standard modules?
Also, just to be sure, I assume your school has Community Engagement licensed? (I don't think you'd be able to create new tabs/roles/modules otherwise...)
Thank you for your response, it has got me to thinking and I think I might have spotted the problem.
Actually the role I was trying to add to the module, had been originally created directly in the database, as a batch insert through an sql query, when we first installed the new system. Although these roles are available everywhere else, it seems that they do not appear in the module availability section.
Now when I do create a role through the application interface, that role is available to be assigned to the module.
So it seems that when adding institution roles through the database, something does not register properly, and they are not available everywhere where they should be.
So question now becomes, is this a bug, or is it supposed to behave that way? If the latter, then what would be the ideal method for creating a large batch of roles instead of having to go through the interface and add them in one by one?
Again many thanks for your help.
Did you use the institution_roles_cr stored procedure to add the role, or did you just insert a record in the institution_roles table?
Simply sticking a record in the table is not the correct way to create an institutional role (or almost any other data type in Blackboard). The stored procedures are there to ensure that all the necessary records are created, and in the case of institutional role, that includes a module_group record as well as an institution_role record.
So no, if you simply stuck a record into the institution_roles table rather than using the institution_roles_cr stored procedure, the problem you're seeing is not something I would consider a bug. You almost always want to use the stored procedures to create or remove records in Blackboard, unless you have a thorough understanding of all the dependencies between the tables within the database.
© Blackboard, Inc.