Follow-On Topics

Related Topics

# Using the Import Repository

The Import Repository feature is provided to enable a `.csv` file containing data to be imported into King Task Centre from another location. Columns contained in the imported file may be mapped against columns available in the existing Repository schema, or new tables and columns may be created in the schema to accommodate the importing of new data.

The importing process is started by clicking on the Import button in the Data tab of the Repository dialog box and then consists of two steps as follows:

Step 1 — Import Data

The first dialog box contains the following for selecting the data to be imported:
|  | Filename — A file name may be manually entered or selected through the Browse button.
|  | Delimiter — Contains check boxes for selection of the following options depending on what is used in the source file:
|  | Tab
|  | Space
|  | Semi-colon
|  | Comma
|  | Other — If this option is checked then a text box below it may be used to enter the appropriate character.
|  | Contents — Contains the following:
|  | Column headings in first row — Check this option if the first row of the source file contains the column headings.
|  | String Qualifier — A string qualifier may be manually entered. By default the parenthesis symbol `"` is used.

Step 2 — Map Columns

The second dialog box contains the following for mapping the data to be imported into the existing repository database:
|  | Elements — Displays a list of available Elements in the Repository for selection.
|  | Mapping — Each field in the Repository database is displayed under the Attribute column. Clicking on the associated Column column displays a drop down list of either column heading names, if the first row of the imported data included the column headings and the Column headings in first row option was selected in Step 1, or the column numbers to be mapped against the field in the Attribute column.
|  | Back — Displays the Step 1 dialog box to enable details to be edited.
|  | Finish — Completes the importing process. A progress bar is displayed during the import process. Once completed, clicking on the OK button closes the dialog box.

Copyright © 2018 Quadrant Software B.V. All rights reserved.