I'm using the file upload method with BHOLD (SP1) RBAC Generator. My 3 file format works fine but I'm having a problem with my 5 file format. I get the following error:  'Roles$' is not a valid name.  Make sure that it does not include characters or punctuation and that it is not too long.

Since my 3 file import works file, I'm assuming the issue must be in the 'Permissions-Applications' or 'Role' file.  Both are rejected. My column names look right.  I have values in the columns that require values.  I have removed as many special characters as possible.  And for the obvious, 'Roles$' is not text within either file. 

Any ideas on troubleshooting this? The MG_PC log files don't tell me much more than the error above. Thanks for you help in advance.

Solved. The documentation here: http://technet.microsoft.com/en-us/library/jj134933(v=ws.10).aspx  says the sheet name should be "Role" instead of "Roles".  Changing to "Roles" resolved the issue.  #Microsoft:  Please update online documentation.  The rules a very specific for these files.

• Marked as answer by Phil Bart 14 hours 13 minutes ago

Solved. The documentation here: http://technet.microsoft.com/en-us/library/jj134933(v=ws.10).aspx  says the sheet name should be "Role" instead of "Roles".  Changing to "Roles" resolved the issue.  #Microsoft:  Please update online documentation.  The rules a very specific for these files.

• Marked as answer by Phil Bart Wednesday, December 18, 2013 9:30 PM

Solved. The documentation here: http://technet.microsoft.com/en-us/library/jj134933(v=ws.10).aspx  says the sheet name should be "Role" instead of "Roles".  Changing to "Roles" resolved the issue.  #Microsoft:  Please update online documentation.  The rules a very specific for these files.

• Marked as answer by Phil Bart Wednesday, December 18, 2013 9:30 PM

Solved. The documentation here: http://technet.microsoft.com/en-us/library/jj134933(v=ws.10).aspx  says the sheet name should be "Role" instead of "Roles".  Changing to "Roles" resolved the issue.  #Microsoft:  Please update online documentation.  The rules a very specific for these files.

• Marked as answer by Phil Bart Wednesday, December 18, 2013 9:30 PM

I am loading 3 input files and it was loading correctly as long as I do not specify values in Permissions column in Accounts-Permissions file. My requirement is to load multiple permissions on an application for each user. Can anybody suggest on how to provide the data to fulfill this requirement?

Thanks

Kris

Solved. I was able to load the data by supplying one permission per row.