Support Hub/Device Guides/Add or Delete Users in Bulk from an Excel File
Guide

Add or Delete Users in Bulk from an Excel File

Instead of typing users into each device, you can add or delete many users at once from a spreadsheet, on one or several devices.

Prepare the file

The page accepts an Excel file (.xlsx or .xls) or a .csv file. Download the ready-made template, Add-User.xlsx or Delete-User.xlsx, from the Device Commands page and fill it in.

  • Add users: columns UID (user ID), UNAME (name) and, optionally, CARDNO (card number).
  • Delete users: one column, UID.

The file carries only these columns, so fingerprints and faces are not part of it. Users enroll those on the device.

Steps

  1. Open Device Commands in your Cams account.
  2. Pick Add users or Delete users.
  3. Choose your file. A preview of the rows is shown before anything is sent.
  4. Select the terminals.
  5. Confirm at Ready to send?
  6. Follow the progress in Recent commands. Open a row to see the result for each user.

If rows are rejected

  • no UID: every row needs a user ID.
  • UID repeated in the file: each user ID may appear once.
  • no UNAME: when adding users, every row needs a name.
  • No usable row in the file: check that the column headings are spelled exactly UID, UNAME and CARDNO.
  • Resend all users: the terminal sends its full list of users (IDs and names) to Cams again. It can be used once every 24 hours.
  • Clear all users: erases every user, fingerprint and face on the terminal. Check the selected terminals twice before you confirm.

If you build your own integration, the API has matching operations: AddUser, DeleteUser and ResendAllUser. See API status codes for the errors they can return.

Still stuck? Email support@camsbiometrics.com with the device serial number and a short description of the problem.

Was this article helpful?