The Import Card page allows importing cardholder records in CSV file format.
If you have an existing database that includes information common to the Keyscan database, such as first name, last name, telephone number etc., rather than re-enter that data, importing your database in a CSV formatted file is an option that can save you time and effort. Before you do this, however, you must be aware of the conventions to successfully import a CSV file.
The CSV file cannot have any commas between names for any field, otherwise the import will fail. Edit out any commas in the CSV file from a spreadsheet before you import the file into the Client software.
Ensure that you are importing a compatible card format. Do not import a Large Card Format or HID Corporate 1000 card format, if the 3 digit batch code/ 5 digit card number format is used and vice versa.
Before you import a CSV formatted file to the Client software, there are conventions that must be followed. This may entail adding fields to the Client software and revamping part of your CSV formatted file once you have opened it in the spreadsheet. Since there are an infinite number of possible variations to the structure and content of databases, we can only provide some general guidelines. You may have to experiment before attaining successful results. For more on import conventions, select the link below Related Topics.
Important
You must have the required field headings listed in your CSV file to import. Review Card Import Conventions for more information about the mandatory headings and proper heading structure.
From the main page, click on the Card Holder Database icon.
In the Card Holder Database screen, click on Import Cards.
From the Import Card Holder Database page, select the Browse button.
From the Choose File to Upload dialog box, navigate to the folder with the CSV file you are importing.
Select the file.
Click on the Open button.
Click on the Import button
The Import Card Holder Information page will list the cardholder records that failed the import. If the page is empty, all records were successfully imported.
Click on the Exit button.
