Database fields supported by the Import tool - Using the Import tool, you can import many database fields from a CSV file. - Security Center 5.13

Security Center Administrator Guide 5.13
Product
Security Center
Content type
Guides > Administrator guides
Version
5.13
ft:locale
en-US
Last updated
2026-01-19

Using the Import tool, you can import many database fields from a CSV file.

Field name Field type Description
/ Activation date String Strings in time and date format.
/ Expiration date String Strings in time and date format.
/ Expires after X days of inactivity Unsigned integer Number of inactive days before credential or cardholder expires.
/ Expires X days after first use Unsigned integer Number of days after first use before a credential or cardholder expires.
Badge template String Credential badge template.
Card format Unsigned integer or string Credential card format. You can use one of the following values:
  • 0 = Standard 26 bits
  • 1 = HID H10306 34 bits
  • 2 = HID H10302 37 bits
  • 3 = HID H10304 37 bits
  • 4 = HID Corporate 1000 35 bits
  • 5 = HID Corporate 1000 48 bits
  • 6 = CSN (32 bits)
  • 7 = FASC-N 75 bits
  • 8 = FASC-N 200 bits

To specify a custom card format, you must spell it exactly as you created it. If no card format is specified in a CSV line, the default format specified on the import settings page is used.
{Format} - Field name Standard card format You can specify a field in a specific card format, including custom card formats.
{Format} - Field name (previous value) Standard card format Field of an old credential to replace. These “(previous value)” choices appear only if you selected Replace as Credential operation.
Cardholder <Field name> As defined by the custom field Cardholder custom field.
Cardholder group String Name of the cardholder group the cardholder should belong to. If the cardholder group does not exist, it is created in the same partition as the cardholder.
Can escort visitors Boolean Valid inputs (in English, not case sensitive):
  • 0
  • 1
  • True
  • False
  • Yes
  • No
  • On
  • Off
Credential <Field name> As defined by the custom field Credential custom field.
Credential code String Use this field to enter credential data as a string of decimal values, with individual fields separated by either the / or | character.

For example, for a credential that uses the Standard 26-bit card format, the string must include the facility code, followed by the separator character, followed by the card number. The string 35/20508 corresponds to facility code 35 and card number 20508.

For custom card formats, arrange the data according to the custom card format definition.

When you specify this field, the individual fields such as Facility code and Card number are ignored.
Credential raw data String Use this field to enter the credential data as a hexadecimal string, followed by the | character, followed by the credential bit length in decimal. The hexadecimal string matches how the credential data is stored in the database.

For example, 20200CE|26 corresponds to a Standard 26-bit credential with facility code 1 and card number 103.

When you specify this field, the individual fields such as Facility code and Card number are ignored.
Description String Cardholder entity description.
Email String Cardholder email address.
First name String Cardholder first name. This field is part of the default cardholder key.
Last name String Cardholder last name. This field is part of the default cardholder key.
License plate String License plate number. Use the cardholder’s license plate number as a credential. Use this method when a Sharp camera triggers a vehicle access barrier.
Mobile phone number String Cardholder's mobile phone number.
Name String Credential entity name. If no name is specified, the default value “Imported credential” or “Unassigned imported credential” is used.
Partition String Name of the partition the cardholder should belong to. If the partition does not exist, it is created. If it is not specified, the cardholder is put in the system partition.
Partition String Name of the partition the credential should belong to. If the partition does not exist, it is created. If it is not specified, the credential is put in the system partition.
Picture String Path to a cardholder picture file (bmp, jpg, gif, or png). The path must reference a file located on the local machine or on the network.
PIN String Credential corresponding to a PIN. The maximum length is 15 digits.
Status Boolean Cardholder status. The following values are accepted (in English, not case sensitive):
  • 1, True, Yes = Profile enabled
  • 0, False, No = Profile disabled
Status String Credential status. The following values are accepted (in English, not case sensitive):
  • Active
  • Inactive
  • Lost
  • Stolen
  • Expired
Browse