Access the ability to import a list of users (up to 1000 people) when adding people from the Add Person screen. The IMPORT tab has an option to use a CSV file from a spreadsheet to import multiple users, eliminating the need to add each person individually, one at a time.
Create and populate a spreadsheet file with a list of people (first name and last name), card numbers, group name(s), and the email address of each user. Save the spreadsheet file with a .csv file extension.
NOTE: Be sure any duplicate first and last names and card numbers are eliminated. Duplicate names and card numbers will not import. Legitimate duplicate names need to be added manually.
This CSV import feature allows the import of multiple persons in People. The .csv spreadsheet format looks like this.
Selecting DOWNLOAD CSV TEMPLATE in the Add Person screen downloads a spreadsheet file named import_person_template.csv that can be used as a template. This can provide the ability to easily transfer a people database from one Cloud Node to another.
IMPORTANT: If you are not using ALL of the columns when importing the CSV file, delete the columns that are not being used or you will get errors and the information in the CSV file will not import.
For an existing CSV file with name and location information, click SELECT CSV to browse to the file’s location and import the file in the following format.
NOTE: The header information in row 1 MUST be included in the file, otherwise the file import will give an error and the information will not import.
First Name - User's first name.
Last Name - User's last name.
Cards - Reader card's assigned unique ID number.
IMPORTANT: Be sure any duplicate First and Last names and Card numbers in the CSV file are eliminated. Duplicate names or card numbers will cause the CSV import to fail; legitimate duplicate names or duplicate card numbers must be added manually.
Groups - Group or groups the user is assigned to or will be assigned to after the file is imported.
NOTE: If a user is assigned to one or more groups in the Groups column of the CSV file and that group has not been created prior to the import, that group (or groups) is created and the user is assigned as part of that group after the import of the CSV file.
Email - User's company or personal email address through which the user may be contacted.
NOTE: If the Email column is used, then an email address MUST be used for EACH user. If one email cell is left blank in any row, the import will fail.
Touch - An integer stating how many Bluetooth credential invites you would like sent to this person on import. Maximum 5.
Token - An integer stating how many mobile credential invites you would like sent to this person on import. Maximum 5.
Enabled - Whether this person's account should be enabled or disabled. 1 means the account is enabled. 0 means the account is not enabled.
Pin - PIN numbers
NOTE: Using a leading zero at the start of a PIN will drop that 0 digit when it is used in PDK. A PIN with a leading zero shouldn't be used. As an example, if a PIN of 0123 is created and entered into the reader, the system will see it as 123. Zero is a non-significant digit and is dropped at the start of a number. The system will not recognize a PIN number with a leading zero as a valid PIN and will not allow it.
Duress Pin - Duress PIN numbers
Partition - Partitions that have been created
NOTE: All cells must be filled in; if any cell in the column is left blank, the import will fail.
The spreadsheet form for the People Import Template (CSV) in the Access Control Panel of the prodatakey website requires the input of the user's first and last name. The Cards column requires the user's card number. In the Groups column enter the group(s) to which the person is a member. The email address of ALL users must be included in the file. If not all emails are known, use a temporary "dummy" email address. Any unknown emails can be updated at a later time to replace the dummy address; otherwise, an incomplete list of emails will cause the import to fail. Enter a boolean value of true or false in the Touch column to indicate the use of touch io devices.
NOTE: Listing an existing group in the Groups column of the spreadsheet adds the person to the group. Entering a group which does not exist creates a new group and adds each of the persons to that group.
From your Cloud Node dashboard, select the People option and click the + icon in the lower right.
Select the IMPORT tab in the Add Person screen.
With the name of the CSV file and its location, click SELECT CSV to browse to the file’s location and select the file. Click Open.
After returning to the Add Person screen, click ADD in the IMPORT tab to accept the file and begin the import process.