Users can be edited in bulk by importing an updated CSV template. If an existing user is found with the same email address, the new information replaces their existing data.
You can use your current user list as a reference when filling out the import CSV template. This exported list should not be edited and uploaded. Any relevant information can be copied and pasted into the import CSV template.
This report also shows the Last Login data for each user.
Select the
Export to Excel
button.
Open and fill in the CSV template. Ensure the following conditions are met. A CSV with a sample entry is attached at the bottom of this article. You can copy/paste user names and email addresses from your exported user list into the template.
Make sure that data is placed in the proper column.
Make sure that cells with numbers are formatted as text before you enter data. This prevents Excel from inadvertently truncating numbers.
Don’t add or delete any columns in the provided CSV template (even if a column is empty).
Don’t have text in any cells other than the columns provided.
Don’t change the names of any headers in the CSV template.
The
Office Location
field should only contain numbers as shown in your
My Company
settings.
Use the variable “all” to assign a user to all office locations.
The
User Group
field should contain the
User Group
name as it appears in the
User Groups
section.
When adding multiple permissions, separate entries with a vertical bar (|).
Ext
,
Fax
,
Country Code
, and
Mobile Number
fields should contain numbers only, with no additional symbols or formatting.
The
PTIN
field should be formatted as follows:
P12345678
.
The
Inactive ERO
field should contain yes or no.
After saving the CSV file, don’t reopen it before uploading it to SafeSend.
Select the
Import CSV
button.
Select a file to upload from your file browser.
Review the pop-up notification. An email is delivered to you once the upload is complete.
If the upload was successful, the email shows “Successful Updates to User Management”. If the upload was not successful, the email shows “Failed to Update User Management” with a CSV file attached. That CSV file outlines what errors occurred.