Skip to content
English
  • There are no suggestions because the search field is empty.

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

  1. 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


    GroupID

    Used to add the person to one or more existing Groups in Qumulex. To find a Group ID:

    • Browse to Groups

    2026-02-26 09_34_32-Chat _ Hassan Elmansy _ Microsoft Teams
  2. 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.
  3. 2026-02-26 09_34_51-Chat _ Hassan Elmansy _ Microsoft Teams

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

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.