Skip to main content

Importing External Role Members

Overview

Importing external role members allows you to use Excel to update external users in existing external roles. For example, you can add supplier contacts who have joined the organization to specified roles in batches.

This feature cannot create new roles or external users. If the external roles or users do not exist, create the roles or invite the users first.


Pre-import Checks

Item

Description

Member Status

Only external users who have joined the organization can be imported. External users with pending invitations or those who have left the organization cannot be imported into roles.

Role Status

Only existing external roles are supported. New external roles cannot be created through import.

Import Limit

Up to 500 records can be imported at a time. Split larger imports into multiple batches.

File Size

The file size cannot exceed 5 MB. Check the file size before uploading.


Downloading and Filling Out the Template

  1. Sign in as an admin and go to Management > External Users.

  2. On the Roles page, click Import > Download Template.

  3. Enter the role group, role name, and member name in the template.

Template Field

Description

Role Group and Role Name

Enter the role group and role name for this import, separated by a slash (/).

Member

Enter the name of the external user to be added to the role. The external user must have joined the current organization.


Importing Role Members

Return to the Role Import page and upload the completed template. Check the import results displayed on the page. Successfully imported external users will appear in the corresponding external roles.


Notes

Importing External Users with Duplicate Names

If multiple external users have the same name, you can import them using their member numbers.

  1. Sign in as an admin. Go to External Users > Members, click the target external user, and view their information.

  2. Note the external user's Member No., for example, W000001.

  3. When filling out the external role import template, replace the external user's name with their member number enclosed in hash signs (#), for example, #W000001#.

Correcting Failed Records

If any records fail to import, check the number of failed records and the reasons, then choose the appropriate method.

Failed Records

Solution

Fewer than 30 records

Manually correct the failed records online and re-import each corrected record.

More than 30 records

Download the error report, correct the data based on the report, and import it again. Online editing is not supported in this case.

Did this answer your question?