In the Import Set Type area, select File-Based

3. Type a name for the Import Set of up to 32 characters. The name can include letters, digits, spaces, and the following special characters:

& ( ) . ! ' + = @

4. Click OK. The Import Set appears in the Import Sets node of the Directory Manager tree pane. To import Listings into the Import Set, see "Importing a Text File of Listings" on page 161.

Collisions in the Listing are not considered.

Creating a File-Based Import Set

158 • Directory Manager

When you import Listings from a text file into the Directory Manager, the text file must be formatted in a certain way for successful import.

For successful import, each entry in the text file to be imported must be on a separate line, with no blank lines between entries. By default, each entry consists of the following fields in the order listed here, separated by commas. If a field is not required, you can use an empty set of commas to denote that field. Only Last Name and Local Number are required. See

"Changing the Order of Fields/Delimiter" on page 159.

Field Contents

Last Name Up to 50 characters and spaces, including letters, digits, and special characters other than double quotes (")

First Name Up to 50 characters and spaces, including letters, digits, and special characters other than double quotes (") or commas.

Country Code 1 to 3 digits.

Area Code 1 to 8 digits.

Local Number 1 to 36 digits. Any punctuation in the number is discarded during import.

Site Up to 100 characters and spaces, including letters, digits, and special characters other than double quotes (") or commas.

Department Up to 100 characters and spaces, including letters, digits, and special characters other than double quotes (") or commas.

Location Up to 100 characters and spaces, including letters, digits, and special characters other than double quotes (") or commas.

Authorization Number

Up to 100 characters and spaces, including letters, digits, and special characters other than double quotes (") or commas.

Email Address Up to 100 characters.

Mail Code Up to 100 characters and spaces, including letters, digits, and special characters other than double quotes (") or commas.

Comment Up to 255 characters and spaces, including letters, digits, and special characters other than double quotes (") or commas.

Formatting the File for Import

Import Sets • 159 Formatting the Import File, continued

Field Contents

Extension Type(s) Type one or more of the following characters in uppercase to indicate the extension type(s): Invalid characters and duplicates are ignored. The order of multiple entries is not important. Do not use commas between multiple entries. For example, to denote Modem and Fax, type MF or FM.

Custom1 The first user-defined field in the Listing, labeled Custom1 by default but able to be renamed.

Custom2 The second user-defined field in the Listing, labeled Custom2 by default but able to be renamed.

Custom3 The first user-defined field in the Listing, labeled Custom1 by default but able to be renamed.

URI1 The first URI associated with the Listing.

URI2 The second URI associated with the Listing.

URI3 The third URI associated with the Listing.

URI4 The fourth URI associated with the Listing.

URI5 The fifth URI associated with the Listing.

The required format for the import text file is determined by a SQL*Loader control file in the ETM^® System installation directory. Each Import Set uses its own copy of this file. This copy is created when you create a new Import Set. If the fields in the import file are in a different order from the

reconcile.ctl file or are delimited by tabs instead of commas, you can edit this file after you create the Import Set but before you import the Listings.

When you create a new Import Set, a system-named Import Set Directory is created in the ps\Directory\import_sets directory of the ETM System installation directory—for example, C:\Program Files\SecureLogix\ETM

\ps\Directory\import_sets\0102d-7fffffff-7fffffec 00000002. A text file in this directory named import_set_details.txt identifies the Import Set by the name you gave it in the GUI.

In each Import Set directory, the file reconcile.ctl defines the required format for imported file(s). This is the file you edit to change the order of the fields or the delimiter.

Changing the Order of

Fields/Delimiter

160 • Directory Manager

When a new Import Set is created, the following is the default format of the reconcile.ctl file.

The order in which the Listing fields appear in this file is the order in which they must appear in the text file to be imported. The Delimiter field specifies the character that separates the fields.

To change the order of the fields and/or the delimiter 1. Open reconcile.ctl in a text editor.

2. Arrange the Listing fields in the order that they appear in the text file to be imported.

For example, if the fields in the text file are arranged as follows:

COUNTRY_CODE,AREA_CODE,LOCAL_NUM,LAST_NAME,FIRST_NAME ,SITE,DEPT,LOCATION,AUTH_NO,EMAIL,MAIL_CODE,COMMENTS, EXT_TYPE,USER1,USER2,USER3,URI1,URI2,URI3,URI4,URI5 you would arrange the fields as shown in the illustration below.

IMPORTANT Do not edit any text in the file except the delimiter. Do not rearrange the first nine lines.

Making a backup copy of any file you intend to edit is good practice.

Listing fields Delimiter field

Import Sets • 161 3. In the line that begins FIELDS TERMINATED BY, the comma ( , )

indicates that the text file you will import is a comma-separated values (CSV) file. If the text file you want to import is TAB delimited, replace the comma with: \t.