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
- Open Device Commands in your Cams account.
- Pick Add users or Delete users.
- Choose your file. A preview of the rows is shown before anything is sent.
- Select the terminals.
- Confirm at Ready to send?
- 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.
Related commands on the same page
- 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?