Skip to main content

How to Bulk Update User Data in Sibme | Sibme Help Center

Bulk Update existing Users' data using a CSV import.

Jeff Ritter avatar
Written by Jeff Ritter
Updated over a week ago

Account Owner (AO) or Super Admins (SA) in Sibme now have the ability to bulk update existing User profile data directly from the People page using a CSV import. The bulk update process includes Custom Field data, email address, and role. This feature streamlines the process of managing User information, allowing you to efficiently add, modify, or remove data across multiple profiles simultaneously.

Who is this article for?

Based on the default User settings in the Sibme platform, you should have permission to complete this task if you are one of the user levels listed below. If you do not see the screens in this article, you can ask your Sibme account administrator if you have permission.

  • Account Owner

  • Super Admin

Exporting Existing User Data

To begin the bulk update process, first export the current user data:

  1. Navigate to the People Page: Log into and click on the "People" tab.

  2. Access the Bulk Update Function: At the top-right corner of the page, in the "Add/Update Multiple People" section, click on the white "Update Multiple People" button.

  3. Download the User Data CSV: Follow the instructions and click on the "Download User Data CSV" button. Click on the "Detailed Instructions" for more information on the process.

    • For Parent Accounts: There are 2 options: 1) download the Parent Account data only or 2) download both the Parent and Child Account data as well.

    • File Naming Convention: The downloaded file will be named "UserUpdateData - yyyy-mm-dd.csv," where "yyyy-mm-dd" represents the download date.

Preparing the CSV File for Import

After downloading the CSV file:

  1. Open the CSV File: Use a spreadsheet application (e.g., Microsoft Excel, Google Sheets) to open the file.

  2. Review and Edit Data: Make the necessary changes to the User information:

    • Add Data: Fill in empty fields with new information.

    • Modify Data: Update existing information as needed.

    • Remove Data: To delete existing data, clear the content of the desired fields; leaving a field empty will remove its data upon import.

  3. Custom Fields: If there are Custom Fields, these columns can have data added to them or the existing data can be updated. Ensure any new Custom Fields are created in Sibme before importing the data.

  4. Important Considerations:

    • Account ID and User ID: Do not alter the Account ID or User ID columns, as these are unique identifiers essential for matching records. Changing these IDs will result in validation errors during import.

    • Username Changes: Usernames can be updated if necessary but please note this will affect how a User logs into Sibme.

    • Roles: User roles can be modified by selecting a new role from the designated dropdown menu.

Importing the Updated CSV File

Once the necessary have been made to the import file:

  1. Return to the People Page: Navigate back to the "Update Multiple People" section.

  2. Upload the CSV File: Click the "Upload" button and select your updated CSV file.

  3. Validation Process: After uploading, the system will validate the data:

    • Error Handling: If there are discrepancies or errors (e.g., altered Account IDs), they will be highlighted in red. These errors need to be corrected before proceeding.

    • Warnings: Fields with changes will display a "Ready to update" status in purple, indicating pending modifications.

    • Data Removal: Fields left empty will show an "Empty Field. Data will be removed." warning in purple, signifying that the existing data will be deleted upon import.

  4. Finalize the Import: Once all errors are resolved and the data is ready to be imported:

    • Confirm Updates: Review the summary of changes.

    • Import Data: Click the "Next" button to initiate the import process. A confirmation message will indicate the number of Users queued for updates.

    • Download Updated CSV: For your records, download a copy of the updated data by clicking "Download Updated CSV."

  5. Completion: Click "Finish" to conclude the process and return to the People page.

Additional Notes

  • Unchanged Rows: Rows without any modifications will be skipped during the import, leaving the existing data intact.

  • Parent Accounts: When updating data in a Parent Account, only Custom Fields shared with Child Accounts can be imported.

By following these steps, you can efficiently manage and update User information in bulk, ensuring your Sibme account remains current and organized.

What’s Next?

If you’d like more information about people management, check out the following articles and videos.

Did this answer your question?