Skip to main content

Import Applicants Data

The second way of adding Applicants is by importing them via CSV or Excel. Down below are two downloadable files. Please click on them to download the respective file.

Once you open the file, you will see 2 rows. Row 1 contains all the headers necessary for the importation to work correctly.
On the second row you will see an example applicant. Please use this as a guide for all your other applicants.

You may delete any column if you do not wish to import that specific information.

danger

Do NOT leave any empty rows between applicants. It will cause the importer to import an Empty applicant as shown below.

Import Applicants Warning

Import Applicants Warning 2

If you wish to add a field, please view the table below for all acceptable column names.

note

The column names can be inputted with Upper case letters and spaces. EX: "First Name" is acceptable and will be read as "firstname".

Acceptable Fields​

FieldAcceptable Column Names
First/Middle Name
  • givenname
  • firstname
Last Name
  • familyname
  • lastname
Title
  • title
Rank
  • rank
Address Line 1
  • agencystreet1
  • address1
Address Line 2
  • agencystreet2
  • address2
City
  • agencycity
  • city
State/Province
  • agencystate
  • state
  • province
Zipcode/Postal Code
  • agencyzipcode
  • zipcode
  • postalcode
Country
  • agencycountry
  • country
Issue Date
  • issuedate
  • issueddate
Expiration Date
  • expirationdate
Hire Date
  • employmentdate
Date of Birth
  • dob
  • birthdate
Height
  • height
Weight
  • weight
Eye Color
  • eye
  • eyecolor
  • eyescolor
Hair Color
  • hair
  • haircolor
Sex
  • gender
  • sex
Badge No.
  • id
  • idnumber
  • badgenumber
  • badgeid
Helpline
  • helpline
  • helplinenumber
Supervisor Name
  • supervisor
  • supervisorname
Supervisor Title
  • supervisortitle
Additional Date Field 1
  • datefield1
Additional Date Field 2
  • datefield2
Additional Date Field 3
  • datefield3
Additional Text Field 1
  • textfield1
Additional Text Field 2
  • textfield2
Additional Text Field 3
  • textfield3
Additional Text Field 4
  • textfield4
Additional Text Field 5
  • textfield5
Endorsement 1
  • endorsement1
Endorsement 2
  • endorsement2
Endorsement 3
  • endorsement3
Endorsement 4
  • endorsement4
Endorsement 5
  • endorsement5
URL QRCode
  • qrcode

Importing Restrictions​

Certain Fields require specific information or it will not be imported. Down below is another table with all the fields and their specific information.

note

Just like the Headers, these values are not restricted by case sensitivity, but they are space sensitive. EX: "ReDaubUrn" will work but "Red Auburn" will not work.

FieldValues Allowed
CountryUnited States
  • usa
  • u.s.a
  • us
  • u.s.
  • united states
  • united states of america
Canada
  • canada
  • ca
  • can
StateUnited States
  • AL
  • AK
  • AR
  • AZ
  • CA
  • CO
  • CT
  • DC
  • DE
  • FL
  • GA
  • HI
  • IA
  • ID
  • IL
  • IN
  • KS
  • KY
  • LA
  • MA
  • MD
  • ME
  • MI
  • MN
  • MO
  • MS
  • MT
  • NC
  • ND
  • NE
  • NH
  • NJ
  • NM
  • NV
  • NY
  • OK
  • OH
  • OR
  • PA
  • RI
  • SC
  • SD
  • TN
  • TX
  • UT
  • VA
  • VT
  • WA
  • WI
  • WV
  • WY
ProvinceCanada
  • AB
  • BC
  • MB
  • NB
  • NL
  • NS
  • ON
  • PE
  • QC
  • SK
  • YT
  • NU
  • NT
Eye
  • Black
  • Blue
  • Brown
  • Gray
  • Green
  • Hazel
  • Maroon
  • Pink
  • Dichromatic
  • Unknown
Hair
  • Bald
  • Black
  • Blonde
  • Brown
  • Gray
  • RedAuburn
  • Sandy
  • White
  • Unknown
Sex
  • Unknown
  • Male
  • Female
  • NotSpecified
HeightHeight in Inches
  • EX: 60 becomes 5'-0"
Issue Date
  • ##/##/####
Expiration Date
  • ##/##/####
Hire Date
  • ##/##/####
Date of Birth
  • ##/##/####
Endorsements
  • yes
  • true
  • no
  • false
URL QRCodeAny website link but it requires proper format
  • https://#####.###
  • http://#####.###
EX: https://GetIDPaaS.com

Importing Applicants​

As you finish inputting all your applicant's information, please save the file and go back to the GETIDPaaS Website.

Please click on Enter Data from the main page. Then on the left Navigation, click on the Tab "Import Applicant Data"

Another drop-down list like on the Enter Applicant Data will appear. All your current IDs will be there. Please select one of your ID's. A button/upload link will then appear. There you can either select the file from your file explorer or drag and drop it there. Your applicants will then begin to be imported.

tip

If an Badge ID of an applicant on the Import Sheet matches with an ID with an Applicant on the Review Applicants page, it will overwrite all the information of the Applicant with the information from the Import Sheet. Please note that if there are more than one applicant with the same Badge ID in the Review Applicant page, it will overwrite the most recently modified Applicant.

Import Applicants

After your applicants are imported, the total amount of cards imported will be displayed.

Import Applicants Success

If the importer ran into any issues, it will display a new button at the bottom called "Summary of Errors".

Summary Applicants

Clicking the button will then open up a Summary of all the errors the importer had while importing your Applicants. You can find out which Applicant and what the issue was. You can use the row number to determine which applicant it was.

Summary Applicants 2

Once you have finished importing all of your applicants, you can go to Review Applicants if you would like to make any changes there. You can go to Review Applicants by clicking the button at the bottom or by clicking Review Applicants in the left navigation.