Create user account from data imported using excel import
0
Hi experts, Requirements: I am required to create account in mendix using the records I have imported from the excel sheet using excel importer. In that sheet have a column called customer email which I want to use as username and a telephone number column which I want to use as a password . ANd also I have 3 user roles: Admin, TC and visitor. But whatever accounts are created I want to assign them visitor user role. Can anyone please help me with how do I start with. I have imported the data successfully and it is getting stored in Asset entity. BUt not sure how to create accounts from excel sheet
asked
Harsh B
1 answers
0
I assume you show the imported rows in a page. So create select buttons so the end user can select all the records for processing. Then create a button to process these records passing the list as parameter. In the microflow retrieve the user role visitor from the database because you need that object when you create the account. Then first check if based on that email address you already not have an account. If the retrieve is empty then create a random password (community commons action) and create the account set the user role and set the password.