How to Import New Card Data in Bulk via CSV?

Table of Contents

  • What to Include in your CSV file:
  • Start Importing

Please make sure to design your card template and add the fields you want to be displayed on your cards BEFORE you upload your CSV file.

What to Include in your CSV file: #

Card ID: This is a unique card ID used to identify each card in the system. This won’t be shown to your cardholders or displayed on the card itself. (Required)

Unique Identifier: Unique Identifier is used to verify cardholder identity before they can install an ID card for your institution in the app. It can be an email address or ID number (whichever you selected while designing your card template). This won’t be displayed on the card itself. (Required)

Security Question(s): Security Questions are used to verify cardholder identity before they can install an ID card for your institution in the app. At least one security question is required. Although you can use anything you’d like as your security questions, some of the examples include the date of birth, phone number or the last 4 digits of a social security number. This won’t be displayed on the card itself. (Required)

Barcode Value: This is the value displayed in the barcode. You can either import your barcode values (typically it is a cardholder ID number) or you can skip this field if you selected the option to auto generate barcode value while designing your card template. (Optional)

Cardholder Data: (Name, Title, Email, etc.). You can add any data you’d like to be displayed on your ID cards. To import ID photos, create a separate column with image URLs or if you’d like to import photos via a zip file, create a column with image file names as they appear in the zip folder (must include file extension).  (Optional)

Recipient Email Address: If you are planning to issue cards via email, include email addresses for each cardholder in your file. (Required)

Note: You can use the same value for multiple fields. For example, you can use a cardholder ID number as a Card ID, Unique Identifier, and Barcode Value. You don’t have to have separate columns for each, you can simply match the fields during Step 5.

Start Importing #

Step1: Log in to your IDMS account and from the Card Templates page click on “Card Data”.

Step 2: Click “Import Data” for the template you’d like to add data via CSV.

Step 3: Click on “Add New Data” and then “Next” If you are adding new data for the first time or don’t need to update existing records.

Step 4: Download the “Example CSV” file, which informs you on the type of data that needs to be imported. Then Click on the “Upload CSV/TSV” button and choose a file from your computer.

Step 5: Map the columns from your CSV file to the fields in your card template and click on “Import Card Data” to finalize your data import.

Step 6: Wait for your import to process. Once processed, your data will be available to view on the “Card Data Dashboard” page.

That’s all it takes to import card data in bulk via CSV! If you still have questions regarding importing data to your ID Management System, do not hesitate to chat with us!

Go to Top