To help manage several Verkada access control users simultaneously Access Admins can export, import, and make changes to the users in their organizations through a comma-separated value (CSV) file.
If you have multiple users with the same name (already in Command or the CSV) that do not have email addresses the import will create duplicate users with the same name.
Export existing users
To avoid manually creating the user list each time you need to update users you can export the current user list from Command to use as a template for your import file.
In Verkada Command, navigate to All Products > Access
.On the left menu, click Access Users and Groups
.Click Export > Export Users to download the CSV.
Required fields
If you are importing access users, these fields are required:
First Name
Last Name
If you are overwriting access users, at least one of these fields is required:
userId
externalId
email
The email field is required for users to access the Verkada Pass app, and users assigned an access control role in Command.
The userId field is generated by Verkada and can be used to identify users.
When assigning card numbers to users, the following fields are required:
cardFormat
facilityCode (if required by the card format)
cardNumber (if required by the card format)
cardNumberHex (if required by the card format)
User CSV uploads cannot be used to delete credentials. Additionally, credentials that belong to existing users will not be reassigned to new users. You can reassign credentials using the credential import feature.
Column Headers for CSV Upload
On the Upload page of the user import, here are a few things to keep in mind:
Required columns: Required columns are marked with an asterisk
. At least one of the fields with an asterisk is required per row. If a row does not have any of the required columns, that user will fail to upload.Key columns: Key columns are marked with a
. At least one key column is required to match existing users if you need to overwrite user data.Additive: If a column is marked with
, when overwriting existing users new values will be added to the user profile. Existing values will not be removed.Start Date & End Date Format: MM/DD/YYYY hh:mm:ss AM/PM
You can add more than one license plate, and Group to a user. Each entry will need to be separated by a semi-colon.
Bulk import users
CSV upload supports up to 20,000 users.
In Verkada Command, navigate to All Products > Access
.On the left menu, click Access Users and Groups
.Click Import > Import Users.
On Upload:
(Optional) Click Download Template to use the Verkada recommended template as a base for your upload.
Under Upload CSV, drag a CSV with your user information or choose select from your computer.
Click Continue to proceed to Configure.
Note: If your CSV file contains special characters, ensure that it is encoded in the CSV UTF-8 encoding.
On Configure:
Overwrite existing users: If yes is selected, then any user that matches userId, externalId, or email (in that hierarchical order) will be updated with the information in the CSV.
Remove users from omitted groups: Select yes to remove users from any groups not specified in the CSV. Users without a specified group (a blank cell) will not have their group membership modified.
Send Pass app invites: Send a download link to for the Verkada Pass app to all users, new users, or no users. We recommend sending this link to new users.
Click Next, Review Columns.
On Review Columns:
Review the information in the columns you are importing.
If any columns cannot be imported, a message will be displayed on this screen detailing which columns were not recognized for import.
Click Next, Review Rows.
On Review Rows:
If any issues are detected in a row, a message will be displayed describing the issue.
Click View rows next to an issue to see which rows are affected.
Correct the issues on the CSV and restart the upload. While rows showing these errors may be uploaded, it is highly unlikely they will succeed.
Note: This initial review does not describe all possible errors, such as conflict with existing user data.
Click Proceed with Import.
Once the import has finished, you will receive an email detailing the success of the import.
If there are any failed imports, click Download CSV with errors to view the errors that caused the import to fail.
Minor errors, such as the reassignment of credentials or invalid license plate numbers will not block user uploads. Users created with these errors can be downloaded from the email sent once the import is complete. When correcting the errors, if the user doesn't have an email, you can specify their userId to prevent creating duplicate users.
Need more help? Contact Verkada Support.