Users and their corresponding access credentials live in Verkada Command. Access Control Managers and Admins can import credentials into Command in bulk with an uploaded .csv [or comma-separated value (CSV)] file, or export credentials from Command to a downloaded .csv file. Learn more about Roles and Permissions for Access Control.
Through the User Import flow, you can still import a single card credential per user as well as a license plate and entry code. To import more credentials, please use the import credential flow as described below.
Import credential details and associated access user
When Access Control Managers and Admins import credentials into Command in bulk with an uploaded .csv file, the file must contain a row for each credential to be imported, including the credential details and the access user that the credential should be associated with.
You can create new credentials or modify existing credentials for users who already exist in Command. To create new access users in Command, use bulk access user import.
Format your .csv file
To achieve a successful import, we highly recommend that your .csv file match the required format below:
The file should be a .csv file with UTF-8 encoding.
The file size should not exceed 250,000 rows.
Credentials are matched to existing users in Command, so you cannot create a user during the credential import process.
One “key” column should be included in the import to map the user to an already existing user in Command. There are 3 “key” columns in hierarchical order:
User ID
External ID
Email Address
The import file CSV column headers should match the expected column headers, as defined in column headers below.
Each row should contain a single unique credential. Avoid importing multiple credentials per row.
Import credentials
Once you have formatted your file, you can import the credentials:
In Verkada Command, go to All Products > Access
.On the left navigation, click Access Users and Groups
.At the top right, click the Import dropdown and select Import Credentials.
When you enter the credential information, the Card Type should match the list of supported card types, as listed under Accepted Formats.
On Import Credentials, you can download a template that includes formatted column headers and sample credential rows.
Drag and drop or upload the formatted .csv file for import.
(Optional) Choose to reassign credentials. An already-existing credential from Command is then reassigned to match the CSV file input.
If you choose not to reassign a credential, the row shows an error if a duplicate credential is found (already assigned to an existing user).
Only reassign credentials if you want your CSV file to be the source of truth.
Click Import Credentials.
Under Review Columns:
If any errors are recognized in the columns, this page prompts you to review your file and fix the errors.
Fix errors and re-upload the .csv file.
Click Next.
Under Review Rows:
If any errors are recognized in the rows, this page prompts you to review your file and fix the errors.
Fix errors and re-upload the .csv file.
Click Next.
Click Proceed with Import if no errors exist on the rows or columns. If you choose to ignore the review suggestions, the rows fail on the import.
After the import is complete:
You should receive an email confirmation on the number of rows that passed and the number of rows that failed.
You should receive a .csv file of the failed rows with a reason for the failure.
Fix the failed rows and re-import these credentials to successfully import all desired credentials.
Export users and their corresponding credentials
In Verkada Command, go to All Products > Access
.On the left navigation, click Access Users and Groups
.At the top right, click Export and select Export Credentials.
A .csv file should export immediately where you can find it in your designated Downloads folder.
Column headers for your file
Your .csv file contains the following credentials:
User Credential | Description |
First Name | First name in Command. |
Last Name | Last name in Command. |
User ID | Verkada-managed unique ID associated with the user. |
External ID | Customer-managed unique ID associated with the user. |
Employee ID | Customer-managed ID associated with the user. Note: Employee ID uniqueness is not enforced. |
Email address associated with the user. | |
Card Type | Card type associated with the user. See supported card formats. |
Facility Code | Facility code associated with the credential (if applicable). |
Card Number | Numeric card number associated with the credential (if applicable). |
Card Number Hex | Hexadecimal card number associated with the credential (if applicable). |
License Plate | User license plate number (if applicable) is also listed as a credential for the user. |
Entry Code | Unique access entry code (if applicable) is also listed as a credential for the user. |
Credential Status | Verkada has introduced a Credential Status column.
|
Modified | Shows the date and time the credential was last updated. |
Need more help? Contact Verkada Support.