This may be a very unique situation, but we are building a SharePoint solution that uses a large number of FBA roles. Currently over 350 different roles.
First, I'm struggling with the FBA Pack's FBA Role Management page. By default, it only lists three roles per page. With over 350 roles, this is a big nuisance. How can we modify this?
Second, I can't seem to find any method of exporting/importing FBA roles. There seem to be many options for exporting/importing FBA users, but roles appear to be uncharted territory.
I was able to write a PowerShell scriptlet that uses the SQL stored procedures to directly export/import users and roles in the database. Unfortunately, there is an additional step to get the users/roles into the SharePoint site. For FBA users, it's as simple as running the PowerShell command:
Has there been any work done for importing FBA Roles into SharePoint in bulk? Or is our solution 'breaking ground' here?
Eric
First, I'm struggling with the FBA Pack's FBA Role Management page. By default, it only lists three roles per page. With over 350 roles, this is a big nuisance. How can we modify this?
Second, I can't seem to find any method of exporting/importing FBA roles. There seem to be many options for exporting/importing FBA users, but roles appear to be uncharted territory.
I was able to write a PowerShell scriptlet that uses the SQL stored procedures to directly export/import users and roles in the database. Unfortunately, there is an additional step to get the users/roles into the SharePoint site. For FBA users, it's as simple as running the PowerShell command:
New-SPUser -Web 'http://portal.contoso.com' -UserAlias 'i:0#.f|FBAUsers|JohnSmith' -DisplayName 'John Smith'
For some reason, this method does not work for roles. When attempted like such: New-SPUser -Web 'http://portal.contoso.com' -UserAlias 'c:0-.f|FBARoles|SomeRole' -DisplayName 'Some Role'
PowerShell fails to locate the 'user', even though it exists in the membership database exactly as indicated. Oddly, if you add the FBA role directly in SharePoint, the sister commandlet of New-SPUser, Get-SPUser works just fine to retrieve the role. Which
just adds to the frustration. Has there been any work done for importing FBA Roles into SharePoint in bulk? Or is our solution 'breaking ground' here?
Eric