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.
NOTE: Header information First Name, Last Name, Cards, Groups, Email, and Touch must be included in row 1, otherwise the file import will give an error and the information will not import.
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.