Visual Casino supports the bulk import of records into X-LST from a folder. The folder must meet specific requirements for the import to succeed:
- contains only CSV files with properly formatted columns (see: CSV Columns)
- the folder and all referenced locations within the csv file(s) are accessible to the Visual Casino User performing the import
Folder Structure
Figure 1: Example Folder Structure
Figure 1 shows an example folder structure. All that is required is that the folder contains only csv files that are properly formatted. This means that no other csv files can be included in the folder for the import to succeed successfully.
Import Process
Person import is performed from the Administration menu at: Administration > Database Management > Import Persons.
Figure 2: Import Persons Menu
This launches the Person Import modal window. From here you browse to specify the folder to import into Visual Casino.
Figure 3: Import Persons Modal Window
Select the folder that you wish to import then click Start.
Supported Images
The following restrictions exist on images:
- PNG or JPEG format
- maximum size of 15MB
- Minimum pixel size of 800x1300 pixels
CSV Columns
The following are a description of the column requirements for the csv. An empty one can be downloaded from here: https://biometrica.zendesk.com/guide-media/01K0Y5263TS84VADGVYYAGMJ7K
CSV columns can be in any order, but it often makes managing the data easier to group them by function. All columns must exist, some columns are required to have data, some do not require data, and certain columns are required depending on the PersonType.
| Column | Type | Required | Allowed Values |
|---|---|---|---|
| PersonType | Enum | Yes | Allowed values are: Suspect, Patron, Employee, External |
| Category | String | Yes |
A Category for the PersonType. This is similar to Keywords, but only one value can be assigned for the category. This field can be used to filter during searches. |
| EmployeeNumber | String | If PersonType is: Employee |
If this value is left blank for an Employee PersonType, a new record will ALWAYS be created. Otherwise, this will update the Employee with this employee number. |
| AccountNumber | String | If PersonType is: Suspect, Patron, External |
If this value is left blank for a External, Suspect, or Patron PersonType, a new record will ALWAYS be created. Otherwise, this will update the External, Person, or Suspect with this account number. |
| Gender | Enum | Yes | Allowed values are: Male, Female, Unknown |
| FirstName | String | No | The person's given name(s). |
| MiddleName | String | No | The person's middle name(s). |
| LastName | String | Yes | The person's last or family name(s). |
| EyeColor | Enum | No | Allowed values are: Black. Blue, Brown, Gray, Green, Hazel, N/A, Unknown. |
| HairColor | Enum | No | Allowed values are: Bald, Black, Blonde, Brown, Gray, Red, White, N/A, Unknown |
| Height | Numeric | Yes | The person's height in inches |
| Weight | Numeric | Yes | The person's weight in pounds |
| Race | Enum | Yes | Allowed values are: African, Asian, Black, Caucasian, Hispanic, Indian, Middle Eastern, Mixed, Native American, White, N/A, Unknown |
| Build | String | No | |
| AddressStreet | String | No | The street name and number of the person's address |
| AddressCity | String | No | The city or town of the person's address |
| AddressStateProvince | String | No | The state or provice of the person's address |
| AddressCountry | String | No | The country of the person's address |
| AddressZipCode | String | No | The postal code of the person's address |
| PhoneNumber | String | No | The primary phone number for the person |
| LicenseNumber | String | No | The number from the person's photo identification |
| LicenseStateProvince | String | No | The state or province that issued the person's photo identification |
| LicenseCountry | String | No | The country that issued the person's photo identification |
| SSN | String | No | An alternate identification value for the person - e.g. their US Social Security Number or other unique value (e.g. FBI number) |
| No | The primary email address for the person | ||
| PositionGuid | GUID | No | A GUID referencing the position the user holds in the Visual Casino database. |
| IsActive | Boolean | Yes | True or False |
| IsTempBanned | Boolean | Yes | True or False |
| TempBannedDate | Date | If IsTempBanned is: True | YYYY-MM-DD Format |
| IsPermanentlyBanned | Boolean | Yes | True or False |
| IsSelfExcluded | Boolean | Yes | True or False |
| BanStatus | Enum | Yes | Allowed values are: NotBanned, TempBanned, PermanentlyBanned |
| DOB | Date | No | YYYY-MM-DD Format |
| PhysicalComments | String | No | Any additional information to include with the individual - e.g. incidents involved in, games preferred, job duties, alcohol preference, etc. |
| Photos | String | No |
One of:
Images must be jpeg or png format. |
| Keywords | String | No |
A semicolon separated list of keywords related to the person. This field can be used to filter during searches. |
| Groups | String | No |
A semicolon separated list of named groups the person is associated with. This field is used to create groups of known associates. This field can be used to filter during searches. |