Current filter:
                                You should refresh the page.
                                  • Hi,

                                    Is there a way we can take a list of email addresses and somehow automate the new user process?  In other words, instead of logging in as an administrator and clicking the "Add User" button for each user, we would like to somehow automate this process.  We have 100's of users to enter and it is taking too long.

                                    Please advise.

                                    Thanks,

                                    Karl

                                • Yaroslav (DevExpress Support) 08.30.2019

                                  Hi Karl,
                                  Would you please clarify accounts of what type you'd like to create in a batch - those that use the Report Server's authentication mechanism or Windows authentication? Note that in the former case each user gets an e-mail with the password setup instructions that is necessary to complete in order log in.
                                   
                                  Regards,
                                  Yaroslav

                                • Karl Kawano ISSC 09.02.2019

                                  Hi,

                                  This would be the report server authentication mechanism.

                                  Yes, on the email.  I probably didn’t state that exactly correct.

                                  What we would like to do is first create a .csv file which of email address and user information that is required for a new user such as username (we’ll probably make this the email address too), First Name, Last Name, Account Type, and group info.  Then automate this somehow to automatically create the invites for all the users.  The invites would go out through the normal Report Server process.

                                  Right now, we have to manually go through the steps for each user individually:

                                  1. Add User
                                  2. Manually enter username, first name, last name, email address, account type and groups.  The admins who are doing this may also type a wrong email which complicates the issues.
                                  3. Create user

                                  This process has to be done for 100’s of users and is causing a problem.

                                  In addition, the users change.  It would also be nice to have a way to automatically delete accounts that are no longer used.

                                  Please advise.

                                  Best Regards,

                                  Karl

                                1 Solution

                                Creation Date Importance Sort by

                                Hi Karl,

                                Thank you for the clarification. Report Server does not officially come with any solution for creating users in a batch. However, I believe we may have a workaround for you. As you probably know, the Report Server's web interface is using a web-based API. This means that although those endpoints, contracts and behavior are not documented, it is actually technically possible to perform any administrative actions via a remote application. For this, we need to investigate the request payload using the browser's Developer Tools (F12) and then build the same JSON object in code.

                                For your reference, I've attached a C# code snippet that creates a new user using the API from the Microsoft.AspNet.WebApi.Client  and Newtonsoft.JSON packages. Note that in order
                                to create a new user, it is necessary to login first using an already existing RS account and get a bearer token.

                                Try this solution and let us know if it works for you.

                                Regards,
                                Yaroslav

                                • Karl Kawano ISSC 09.02.2019

                                  Hi Yaroslav,
                                  I didn’t actually know that it was web based API.  That should work.  I’ll review the info below.
                                  Thank you!  You can close this case if you have not already done so.

                                • Yaroslav (DevExpress Support) 09.03.2019

                                  Karl,
                                  You're very welcome. If you run this code and encounter an issue, feel free to let us now in the comments section.

                                  Before I let you go...any chance you could share your thoughts about the Report Server product? I'd appreciate it if you can address the following questions:
                                  - I see you have a lot of end-users. Why did you go with Report Server instead of building a custom web app tailored for your specific needs using our ad-hoc reporting tools?
                                  - What kind of reports your end-users are going to create and for what is their business domain?
                                  - Taking the issue we discussed aside, is there any other functionality that you'd like to see in a future Report Server update, the functionality that you (or your end-users) can leverage the most?

                                  If you'd like to discuss this separately, feel free to reach out to our team directly via reportingteam@devexpress.com. Any ideas or suggestions on how to enhance our reporting tools would be greatly appreciated.

                                  Regards,
                                  Yaroslav