Importing Access Control User Information

In order to more efficiently add or modify multiple access users simultaneously, a CSV file containing user information can be uploaded to Command.

Note: Bulk importing requires Access Admin permissions

Process

Navigate to Admin > Access Control > Access Users, then click Manage > Import Users in the top right.

Note: If you are trying to modify existing users, select Export Users to download the CSV of your existing users as a base for your import file.

In the import users menu, you can select Download to download the template CSV file and enter user information. Note that the exact headers (case sensitive) present in the template must be used in your uploaded CSV file.


To finalize the import select the CSV File or drag and drop the file into the box.

Once uploaded, any errors or warnings regarding the upload of the file will be displayed. These errors must be fixed before the import can complete. If no errors are present, you can click the Begin Import button.

Note: If attempting to modify existing users, select the Overwrite Existing Users checkbox. This will modify any users with emails matching those present in the CSV file, while ignoring entries in the CSV without an email.

Required Fields

At least one of the following fields is required to be populated for every row in the CSV file:

  • firstName

  • lastName

  • email

Note: The email field is required for users to access the Verkada Pass app as well as users that are assigned Access Admin and Access Manager roles.

Importing Card Numbers

If you are looking to add card numbers, the following fields are also required:

  • cardFormat

  • facilityCode (if the card format requires one)

  • cardNumber

Note: If the card format is Mifare or DESFire then you will also need to add a cardNumberHex column after the cardNumber column.

Access Groups

You can populate the groups field with the names of all groups you'd like to add the user to. Note that the groups must exist in command before import and the group name given in the CSV must match exactly the name of the group in command.

A description of all other fields is shown below:

Sample CSV file

Below is a sample CSV file, please take note of the headers used, as the name, order, etc. of the fields must match exactly in your CSV.

email,firstName,lastName,startDateTime,endDateTime,roles,entryCode,groups,cardFormat,facilityCode,cardNumber,cardNumberHex,mobile,photoUrl
[email protected],John,Smith,,,Admin,1233344,Admin,Standard 26-bit Wiegand,12,34567,,TRUE,https://www.example.com/johnsmith.jp
[email protected],Jane,Doe,,,,,Contractor,HID 37-bit,1412,213045,,TRUE,
chris.gr[email protected],Chris,Green,,,,56789014,,HID 37-bit No Facility Code,,12005826123,,TRUE,
[email protected],Amy,Burch,,,,,,Casi Rusco 40-Bit,,89762389989,,FALSE,
,Fardeen,Contreras,,,,,,HID Corporate 1000-35,354,243548,,FALSE,
[email protected],,,,,,,,HID Corporate 1000-48,939,980273,,FALSE,
[email protected],Darragh,Miles,,,,,,DESFire CSN,,,B90AC39F824,TRUE,
[email protected],Ayesha,Findlay,,,,,,MiFare 4-Byte (32 bit) CSN,,,2E87BA89,TRUE,
,Steph,Curry,,,,,,MDC Custom 64-bit,121,12,,TRUE,

Exporting Access Control User Information

Just like we imported a .csv file to enter user information, similarly, we can export access user information to a .csv file.

Process

Navigate to Admin > Access control > Access users, then click manage in the top right, and from there click export users. This will pull all the configurations for each user, place them into a .csv file, and it will send an email with this file to the email you are logged in as.

Note: The exported .csv will be emailed to the email address you are logged into the organization with and the link will only be valid for an hour.

You can now go ahead and download the .csv file and extract the required User information from it.

Did this answer your question?