Importing Extension Tables

The selected file will now be listed in the ‘Filename’ box. In this particular example, the first row of the CSV file contains column headers which need to be ignored. To do this, the user simply clicks the check-box against ‘Ignore First Line (Header Record)’, circled in the screen-shot.

The next step is to select the Fields (‘Fields In Order Of Occurrence’) which need to be used against the columns in the CSV file. A point which needs to be clarified are the ‘Hierarchy’ fields. These relate to the structure of the company or business. For example, in the case of a large corporate, the levels might look like this:

Hierarchy Level 1 – Parent Company

Hierarchy Level 2 – Company

Hierarchy Level 3 – Division

Hierarchy Level 4 – Department

Hierarchy Level 5 – Office

In the case of a smaller business, only one or two levels may need to be used. Of the available ‘Fields’ listed, the following are mandatory:

Action (see here)

Hierarchy Level 1

Site Name

Extension Number

Surname

In other words, they must be used.

Note: If these fields do not exist as columns in the original spreadsheet, then the columns must be added before any attempt is made to perform an import into report X Setup.

If we take the ‘extensions.csv’ as an example, the ‘Fields’ that would need to be selected are: 

Action (A, E or D) - ‘A’ for Add, 'E' for edit, 'D' for delete

Group 1 (Hierarchy Level 1 - Company)

Group 2 (Hierarchy Level 2 - Department)

Site Name - Site (Location)

Extension Number - Extn.

Title - Title

Forename - First-Name

Surname - Surname

User - User (P/S) (only a Primary user will be shown in Reports).

These fields can be seen listed in the right-hand pane in the screen-shot.

The unwanted fields (circled in the screen shot) have been moved into the left-hand pane using the ‘<’ button, and the fields have been organized to correspond with the order of the CSV file using the ‘Move Up’ & ‘Move Down’ buttons. The field must firstly be highlighted, by clicking on the entry with the mouse, before any action can be taken.

Once all the fields have been selected and arranged in the correct order, clicking the ‘OK’ button will start the import of the CSV file.

A bar-graph window indicates the progress of the import. When the process is completed, the user is shown an ‘Information’ window, indicating the results of the data import.

The user is advised to check that the number of rows in the 'CSV' file correspond to the number of lines read within the file.