We are in the process of a major scale-up. Therefore, we are trying to find an effective tool for bulk importing users (with passwords).
Currently, we are using BIF for creating users. It is a good tool, but it does not allow us to create or update user passwords. As a result, it usually requires a lot of manual work.
For testing purposes, I managed to create a JSON payload for a single user that can update the password. I just added a user credentials part to the JSON file:
So, I am thinking about some sort of Excel template where all necessary information about users will be placed in columns, allowing us to automate the process. The plan is then to convert such a file into JSON format to be used in the import/export app or with an API such as Postman.
I do believe it must be possible. Maybe someone has already created such a template. But I don’t know where to start. That’s why I am here kindly asking for your assistance.
Also, if you know another effective way to bulk update user passwords, I would be gratefull if you share it wuth me!
Many thanks for your shared resources which helped me a lot to understand how to use Postman to make loop queries with the pre-request and post-response scripts. Your detailed explanations really helped me out to figure it out.
For your information, I noticed there is a slight mistake in the excel template file to build the user array: I had to add " character at the beginning of cells H1 and I1 to make it work.
I also removed the comma from the end of the last line (cell E14) as it was the last element of the array.
Instead of coding the loop in the pre-script and postscript, you add a csv file as a data file in the Postman Runner, and Postman automatically loops the csv to build and commit the PATCH API requests.
In my case, the csv file attached as a data file to the runner was:
id,code
azerty12uiu3,code1
qsdf123hjkl,code2
And the patch request in postman looked like this:
Just FYI Passwords is also something you can affect with the User Extended App from @eyeseetea . For us this allows a more decentralized approach for user creation/maintenance.
Thank you, I also noticed that slight mistake in Excel yesterday, when tried to follow @Ulanbek instructions. Anyway, the job he has done is just Amazing! And very helpfull!
P.S. @gregory , TY for your video also! Havent tried this approach yet though, But TY!!
P.P.S. CSV file with Postman runner works like a charm!!
Interesting, thanks a lot. But this app is not compatible with V2.41.
Do you know if “User profile” App provides the same functionalities as User extended app?
Interesting, didn’t realize it wasn’t functional on V41 (apologies for that oversight!) I’m not familiar with the User Profile App or any other app that can work in the same way. Will have a look though.
