Importing Cardholders to Qumulex
Importing Cardholders to Qumulex
Qumulex lets you bulk import cardholders from the People page.
Step 1: Prepare the .csv file
Download the template and fill in the relevant columns, then save it as a .csv file. Do not delete unused columns. Simply leave them blank.
Template at the following link: QumulexBulkImportTemplate
-
The template columns are: CardValue, FirstName, LastName, Suffix, Salutation, JobTitle, Department, EmployeeID, LicensePlate and GroupID. Most are self-explanatory. The two that need a specific format are below.
CardValue
Enter each credential as FacilityCode-CardNumber (ex.
123-45678).For cards with no facility code, leave the facility code blank but keep the dash
(ex.-45678). The dash is required.To give a person more than one card, separate each credential with a space:
123-45678 -45679
GroupIDUsed to add the person to one or more existing Groups in Qumulex. To find a Group ID:
- Browse to Groups

- Click the group you want. The Group ID is the number at the end of the address in your browser’s URL bar. Copy it exactly as shown and paste it into the spreadsheet.

To add a person to more than one Group, separate each Group ID with a space:1ABCDE23456 1FGHIJ78901
Example row
csv
CardValue,FirstName,LastName,Suffix,Salutation,JobTitle,Department,EmployeeID,LicensePlate,GroupID
123-45678 -45679,John,Smith,,Mr.,Technician,Facilities,1001,,1ABCDE23456 1FGHIJ78901
Important: If you edit the file in Excel, format the CardValue column as Text before entering card numbers. Otherwise, Excel may drop leading zeros or turn values like 1-2345 into dates.
Step 2: Import the file
- Set your Scope to the Customer level for the correct customer. See: https://www.qumulex.com/kb/setting-your-scope
- Go to People and select Import Cardholders
- Select your .csv file from your computer
It is HIGHLY recommended to do a trial import with 2 or 3 cardholders first to confirm everything comes in correctly before doing a large import.