How to Import users to access control using excel

How to Import users to access control using excel


Manually adding users to the access control can be repetitive and tiring and takes time. Importing users to access control can help you solve this problem. Here is a quick tutorial on how to import the users into the access control.

Step 1: Open access control>Configuration>Personnel>export to excel>save “Note: you need to add at least 1 user to export to excel”. By doing this, you will get the required format for the excel file.

Step 2: Open the saved excel file

This is where you can encode new users 
Step 3: follow the first user and input a new user ID and User name and if you know the card number of the RFID card, you can also input it.

Step 4: Save the  Excel File
Step 5: Go back to Access control and open Configuration>personnel>import>ok> and finally open the saved excel file

End~ 





    • Related Articles

    • How to import data in PrintanID

      This article is for PrintanID software only 1. Go to Data Import tab 2. Select Upload data. 3. Browse the excel file you want to import 4. Link the excel database field to the built in database field of PrintanID then click Save.

    • How to enable CardExchange for all Windows Users

      Upon Installation there will be a prompt to install the application to the current user or to all windows users. Selecting Anyone who uses this computer (all users) All users will be given access to CardExchange and it's license. CardExchange folder ...

    • Anviz - How to import/export users from device and Crosschex standards using USB flash drive

      There are several ways to import and export users to the anviz device and crosschex standards one of which is by means of a USB flash drive. In this guide, you will learn how to do so. 1. You will need a USB Flashdrive and the Anviz Biometrics ...

    • How to force install Microsoft access database engine

      Download AccessDatabaseEngine.exe x32 https://www.microsoft.com/en-us/download/details.aspx?id=54920 1. Check the location of the AccessDatabaseEngine.exe by right-clicking the file > Properties > Security Tab > Object name. 2. Run command prompt as ...

    • How to add controller to Access Control System

                 1. Setting IP address of PC to static Open Control panel Go to Network and Sharing Center Click Change adapter settings Right Click Ethernet and click on properties Check Internet protocol version 4(TCP/IPV4) then click properties Change ...