Sample CSV formats

Depending on the printer login configuration, the CSV format can be any of the following:

Badge only

BADGE,OPERATION,EMAIL,TEMPORARY,PIN
20171a,CREATE,jdoe@company.com,true,
20172b,CREATE,llane@company.com,true,
20173c,DELETE,ckent@company.com,false,

PIN only

BADGE,OPERATION,EMAIL,TEMPORARY,PIN
,CREATE,jdoe@company.com,,123456
,CREATE,llane@company.com,,234567
,DELETE,ckent@company.com,,345678

Badge and PIN

BADGE,OPERATION,EMAIL,TEMPORARY,PIN
20171a,CREATE,jdoe@company.com,true,123456
20172b,CREATE,llane@company.com,true,234567
20173c,DELETE,ckent@company.com,false,345678

You can also change the order of the operations. For example, PIN only can be formatted as:

PIN only

PIN,OPERATION,EMAIL,BADGE,TEMPORARY
123456,CREATE,jdoe@company.com,,
234567,CREATE,llane@company.com,,
345678,DELETE,ckent@company.com,,

• BADGE—The badge ID of the user. If a BADGE value contains commas, then the value must be enclosed in double quotation marks. For example, “20171a,2a,3a”
• The value must not be empty when the printer login is set to Badge Login or Badge + PIN as second factor.
• OPERATION—Required for all badges and PINs.

Valid OPERATION values

• CREATE—Creates a badge identified by the BADGE value for the user specified by the EMAIL value.
• DELETE—Deletes the existing badge identified by the BADGE value.
• EMAIL—Required for the CREATE operation. Badge import does not create a user. The user must exist before a badge can be created. EMAIL values that are in uppercase are converted to lowercase before the operation is performed. For example, JDOE@company.com is converted to jdoe@company.com.
• TEMPORARY—Determines whether the badge is temporary or permanent. The TEMPORARY value is either true or false.
• PIN—The PIN of the user. The value must not be empty when the printer login is set to PIN Login or Badge + PIN as second factor.

Notes:

• All lines must have the same number of values as the header, including the commas. For example, 20171a,DELETE,
• The file size must not exceed 1MB.