Utilities
Issue 1 January 1997
5-5
File Import/Export
Purpose
To transfer Organization data from/to an external source — typically, another PC
with the MERLIN LEGEND Reporter application — to help maintain shared
Organization files.
MERLIN LEGEND Reporter can import and export files as text in the format
described below — we show a pipe “|” as a delimiter, but you may use any character
that does not appear as a field value. Use quotes (“”) where indicated. (See
Organization Table in chapter 3 for field format and acceptable values.)
File*
Format
Personnel
“last name”|“first name”|“title”
Example:
“
Sohn”
|“Maria”|“Ms”
Level-1
extension|“last name”|“first name”|“title”| 0 code|“cost center”|0|0-18 (masked
digits for storage)|0-18 (masked digits for reports)| yes/no (immediate output)|
Example:
21|“Sohn”|“Maria”|“Ms”|6546|“Publications”|0|0|0|no|
Level-2
“cost center”|0|0|minimum 0| “department” or empty| 0
Example:
“Publications”|0|0|0|“Marketing”|0
Level-3
“department name”|0|“division name” or empty
Example:
“Marketing”|0|“TELECOM”
Level-4
“division name”|0|“branch name” or empty
Example: “
TELECOM”|0|“USA BRANCH”
Level-5
“branch name”|0
Example:
“USA BRANCH”|0
*
To import files, higher level entries must exist in the database for lower levels to refer to them in an
association. If an imported entry refers to an undefined higher level, the entry will be added with
“Default” as the higher level owner. For example, to import extension 21 under cost center “Sales-1,”
you must have imported or added “Sales-1” to the database first.
Dialog
Box
Database File. Select the organization level for transfer.
Disk File Name. Enter the path name of the external file — the source of import data
or destination of export data. (The field only accepts file and directory names
conforming to DOS naming conventions and with less than 8 characters.)
Delimiter. Enter the character used to separate fields in the imported or exported
records.
This group appears
only in a File Import.
