Import Users

Menu path: Users > Import Users.

Large numbers of user entries may be created by importing a CSV text file.

Multiple users may be imported from a .csv file. Several tabs support the operation. The import takes place in several steps:

1. - selects the .csv file to be imported. Multiple files may be opened simultaneously or individually. Their file names are displayed in the header and must be individually selected and digested.
2. CSV File Contents - the .csv file is displayed.
3. CSV Parser Options - the basic formatting of the file is described.
4. Import Options - includes registration windows, actions, and passwords in user definitions.
5. Import Data - individual fields are associated with client values and the file is used to define or refine clients.

CSV File Contents

The contents of the file are displayed. The file may be edited using the keyboard and will be used for import.

CSV Parser Options

The parser options indicate how the .csv file is formatted, aside from the column contents. The fields are:

Field	Usage	Example
Encoding	The type of text encoding used by the file. The available choices are those supported by browsers and listed in https://encoding.spec.whatwg.org/#names-and-labels.	utf-8
Delimeter	The delimiting character between fields. Leave blank (which displays as auto) to auto-detect the delimiter from the most common characters. If the auto setting is not effective, the evidence will be seen in the Import Data tab and may be adjusted before clients are defined.	(blank)
Newline	The newline character or sequence of characters, one of \r (return), \n (newline), or \r\n. Leave blank (which displays as auto) to auto-detect from these choices.
Header	If enabled, the first row of the file will be interpreted as field names.
Skip Empty	If enabled, lines that are empty will be skipped.
Quote Character	The character used to quote fields. The quoting of all fields is not required.	"
Escape Character	The character used to escape the quote character within a field. If not set, the default escaping of quote character within a quoted field is using the quote character two times.	"
Comments	A string that indicates the start of a comment within a line. For example, '#' or '//'.	#
Preview	If greater than 0, then only that number of rows will be used. This option is useful for ensuring proper digestion of the .csv file.	2

Import Options

When this tab is selected, several additional user settings may be defined for use by imported users. The fields in this tab are:

Import Data

When this tab is selected, the options in CSV Parser Options are used to parse the .csv file. The table shown is formatted as per the following rules:

• First row -
  • If the Header parameter is enabled, the field names from the file are shown; if not enabled, then ascending field numbers starting at 0 are displayed. The arrows to the right of each field default to a double arrow, which indicates that the field is not sorted. Selecting the arrow requests that the table be sorted in ascending order (up arrow), or descending order (down arrow). Only one column may be sorted at a time.
  • Immediately below the field names or number are choices dictating the behavior of each column. The PID is required; all fields will be ignored until one field is chosen as the PID. Each field may be set to -- Ignore field --, MAC Address, or one of the optional personal information fields.
• First column - selects which rows are parsed. The uppermost check box will select all rows. The header row will not be digested even if its check box is selected.
• Import button - the button will digest and import the number of rows selected.