Select Configuration > Lookup Lists.
You can create CSV files, or lookup lists, that enables the Search feature to create additional tables with different fields and store them in the database. You can add lookup list fields to fieldsets and use them in search queries.
The CSV file for your lookup list must meet the following requirements:
The first row must be a comma-separated list of field names.
The field names cannot exceed 40 characters. The names can only contain alphanumeric characters and underscores. They must start with an alpha character.
The remaining rows must be comma-separated values for the fields in the first row.
All rows must contain the same number of values.
You must select one of the columns as the key field, and the values of the key field must be unique.
The key field is the field that you can use with the in list operator in queries.
The file cannot exceed 25 fields and 2 million rows.
The file cannot exceed 150 MB.
Select Configuration > Lookup Lists.
Select Add.
Drag-and-drop your CSV file to the Lookup Lists page or select Browse to navigate to the file.
Specify a name for the lookup list.
Once created, you cannot change the name of the lookup list. The name must meet the following requirements:
Does not exceed 20 characters
Contains only alphanumeric characters and underscores
Starts with an alpha character
Specify the key field, then either accept the recommended value type or specify a different one.
The following are possible values:
|
Value type |
Specifies |
|---|---|
|
domain |
|
|
float |
A number whose radix point can be placed anywhere relative to the significant digits of the number |
|
hostname |
Fully qualified domain name |
|
int |
Integer value |
|
ipv4 |
IPv4 address |
|
ipv6 |
Ipv6 address |
|
mac |
MAC address |
|
short text |
Text that cannot exceed 1K of space |
|
long text |
Text that cannot exceed 4K of space |
|
time |
Time stamp |
|
url |
A URL address that cannot exceed 4K |
|
username |
A string type |
To upload the file as a table in the database, select Upload.
Replacing the contents of a lookup list does not affect queries that use the original lookup list. You cannot change the name of a lookup list. The field names in the replacement file must match the field names in the original file.
Select Configuration > Lookup Lists.
Select the list that you want to replace.
Select Replace.
Select the CSV file that you want to use to replace the contents of the existing lookup list.
Select Configuration > Lookup Lists.
Select the list that you want to delete.
Select the Trash can icon.