Q1: Change User's Login Email to a Different Email Address
Description
Step by Step instructions
Step 1: Log in to your Prolaborate account and click "User Management"
Note:
For EASaaS users, the provided screenshot pertains exclusively to their interface. However, for those utilizing Prolaborate only, it is essential to locate user management within the Prolaborate platform by navigating to Prolaborate -> Menu -> User Management.
Step 2: Find the user whose email address you want to change and click on the edit icon next to their name.
Step 3: Enter the new email address for the user and save the changes.
Step 4: After saving the changes, make sure to log out from Prolaborate. The user can then log in using the updated email address.
Note:If a cloud customer requests these changes, we can do the changes on behalf of customer by using a Prolaborate support(Admin) account. However, it's essential to educate the customer on the steps involved for a smoother handling of such requests.
Example draft:
Hi customer name,
Thank you for reaching out to Sparx Cloud Support.
We understand that you would like to update the email address associated with the account "
PCuthbert@meaa.mea.com" to "
AUmat@meaa.mea.com" for login to Prolaborate. We would like to inform you that as an admin user in Prolaborate, it is indeed possible to change the email address of a registered user.
To change the email address of a registered user in prolaborate, please follow these steps:
Step 1: Log in to your Prolaborate account and click "User Management"
Step 2: Find the user whose email address you want to change and click on the edit icon next to their name.
Step 3: Enter the new email address for the user and save the changes.
Step 4: After saving the changes, make sure to log out from Prolaborate. The user can then log in using the updated email address.
If you have any further questions or need assistance, feel free to ask.
Related Articles and Links:
Q2: How to grant Super Admin access in Prolaborate
Description
- The customer requests “Admin Permissions” for a user.
- The customer had tried adding the user to the Prolaborate user group with admin permissions. But User Group only has repository level permissions. The customer wants portal level admin access.
Steps Taken
1. Navigate to Portal Settings/ User and License Management/ Edit User.

2.Select the "Edit" option for the person to whom you need to provide Super Admin access.

3.Enable the “Make Super Admin” option in the Edit user page and click Save.

Response Sent
Hi Customer,
Thank you for the update.
We have enabled Super Admin access for you. Please note that Super Admin users can grant Admin access to other users anytime from Portal Settings/ User and License Management/ Edit User.
You can learn more about Managing Users from the documentation here.
Please try accessing the Portal settings and provide us with your confirmation. If you have any questions or concerns regarding this, please let us know.
Reference
Q3: How to get full user list present in Prolaborate environment
Description
This article explores the process of obtaining a comprehensive list of users' presence within Prolaborate "User and License Management" module.
Prerequisites
Access to the Prolaborate hosted database with administrative privileges.
Procedure to Retrieve the List
For MS SQL
1. Go to your Prolaborate database in MS-SQL and extend the table; find the "dbo.user" table
2. Right-click on the dbo.user table and choose "Select Top 100 Rows." The total user list will be displayed.
3. In the results page, click on the left top corner or Ctrl +A, which will select all the columns and rows.
4. Then right-click and choose "Save Result As," choose the file path and format as.csv, and click on the save button. The total user list will be exported.
For MySQL
1. Go to your Prolaborate database in MY-SQL and extend the table; find the "user" table.
2. Right-click on the "user" table and choose "Select Rows - Limit 50000." The total user list will be displayed.
3. Then click on the "export record set to the external file option," choose the file path and format as.csv, and click on the save button. The total user list will be exported.
Q4: Invalid Column Name 'IsMSSMTP' error when using the Sign Up option in Prolaborate
Description
Users get an error in the Sign-Up page saying Invalid Column Name 'IsMSSMTP' when trying to sign-up for Prolaborate.
Troubleshooting Steps
We need following information to investigate this issue:
1. Current Prolaborate version.
2. Please provide us with the type of your Prolaborate database (MySQL or MSSQL).
3. Navigate to your Prolaborate database -> Tables -> smtpsettings and make sure the "IsMSSMTP" is present. If possible please share a screenshot of the table as shown below.
4. Please share the Error and Information logs from the Prolaborate installation folder. You can refer to the documentation here for detailed steps.
5. Finally, share the .HAR file from the developer console by following the steps outlined below.
- Open the developer console by pressing the F12 key.
- Click on the Network tab, reload the browser, and export the .HAR file.
Email Response
Hi <Customer>,
Thank you for reaching out to Prolaborate Support.
We've investigated the issue with the Sign-up settings. We suspect that one of the columns is missing in your Prolaborate database. Could you please provide us with some additional information as mentioned below?
If you have any questions or need assistance regarding this, please let us know.
Reference
Ticket ID: #8170
Subject: Prolaborate V4 new user creation bug
Department: Prolaborate Support
Tags
get users list ,prolaborate users list ,signup settings, sign up issues, complete users list, db level issues