Exporting Telephone Directory Information from the 3300 ICP

Overview:

You can export telephone directory entries from the Telephone Directory form to a comma separated file (.csv): comma-delimited file that can be imported into a spreadsheet program.

• Notes:

• If the maximum number of clustered elements is set to 250 in the License and Option Selection form, the Export All function will be disabled for the Telephone Directory.

• If you export data to a Microsoft Excel spreadsheet, and the spreadsheet does not open, see Excel Spreadsheet Fails to Launch to correct this problem.

Requirements

You will need a text editor, word processor, or spreadsheet program (for example, Microsoft Excel) installed on your client station in order to manipulate the exported data.

Exporting Telephone Directory Data

1. Telephone Directory
   Click the first record that you want your selection to start with.

2. Click Export.

3. Choose the export range:

4. Click All to export all the records in the upper information frame

5. Click Selected Record to export the data for a single record from the lower frame.

6. Click Current Page to export the records in the currently displayed page

7. Click Pages and enter the page number or page range, for example 5-12.

8. Click Next "N" records and enter the number of records (1 to 999) beginning from the currently selected record. This option is only available in forms that contain large lists, such as the Telephone Directory or Multiline IP Sets forms. The maximum number of records that you can export is 999.

4. Choose file type Comma Delimited (Spreadsheet).

5. Click Export.

CAUTION: Depending on the amount and type of data being exported, there could be a significant delay before the Save As dialog box is displayed. While data is being retrieved from the system database, other users cannot access or use the Desktop Tool, the Group Administration Tool, or the System Administration Tool.

6. After the File Download dialog box appears, click Save. Do not click Open. After the system retrieves the data, the Save As dialog box appears.

7. Navigate to a folder on your computer drive or on a network drive.

8. If desired, change the filename. By default, files are given filenames that use the following format:
   Filename={Form Name (max 6 letters)}_{Switch Name (max 4 letters)}_{24-hour time followed by day and month (HHMMDDMM)}
   Examples: UsePro_Mn96_16100305.csv
   TelDir_Mn98_28031205.csv
   AllLog_Mn99_19101115.csv

9. Ensure that the file extension is set correctly to Text (comma delimited) (*.csv)

10. Click Save.

• Creating an Import File for Telephone Directory Data

• Importing Telephone Directory Data into the 3300 ICP