Click on images to see them in full screen

User imports

When you deploy Door Tablet and you wish to use RFID your users must be registered on the system. You can register users and RFID tags individually (see here Database 'Door Tablet HELP', View 'Help Documents', Document 'Register NFC tags') but often when you need to have hundreds or thousands of users registered, you need a fast and practical way to import these. Therefore, Door Tablet allows you to import users from Microsoft Excel spreadsheets or Comma delimited text files. If you use Excel, the program must first be installed on the Door Tablet server.

Importing users with RFID tags
The import process is designed to be secure, fast and trouble free. The overall process is:

  1. You create an Import Job where you upload your data file
  2. Door Tablet saves your data and starts processing the entries in the background, on the server
  3. When the process ends, your job will be marked as completed
  4. You can now visit and check the records you imported
  5. If you are happy with the import you can ask Door Tablet to commit the data to the database
  6. If you are not happy and for whatever reason you wish to discard the import, you can do so easily
Once you commit the import to the database users can start using the system

Note: the maximum number of records you can insert for each job is 2000.
Another Note: When you use external ID Sources you should not import users into Door Tablet. For more information about ID Sources see here: Database 'Door Tablet HELP', View 'Help Documents', Document 'ID Sources'

Click on Imports:

Click on "+ Import":

Data format:
Name:String  Required, first name + space + last name
Email:StringRequired, RFC821
Phone number:StringOptional
RFID Code:StringOptional, match what is read by End-Points
Categories:StringOptional, hash separated list (#)
Internal ID:StringOptional, normally numeric
Checkin Exempt: StringOptional, two fixed value: Y or N
Note: when skipping optional fields still use commas, for example: Joe King,,,ABDSD543,,2345151235,N

Once you submit your Import Job, you will see it on the list of jobs:

Review your imported data:

When displaying imported data you can limit the data you see to the batch code used for the import:

You can also delete records, either one at a time or the entire imported batch by deleting the import job.

Accept the Import
To accept the imported records, open the Import Batch:

Your newly imported users will now appear in the normal users view: