Export Dialog

When you open the Export dialog, the tree hierarchy on the Definitions pane is populated with information from the Optim™ Directory.

export dialog display, showing types of objects that can be exported

You can select the check box for an object type in order to export all definitions of that type or expand the list and select definitions to be exported by qualifier or name. Tools menu commands allow you to select or de-select all definitions.

Output File

The name of the Output File. The Output File is a text file and is given a .txt extension automatically. Other extensions may be specified, or the file can be designated without an extension. The Output File is used as the Input File for Import Processing.

Append definitions to output file

Option to append definitions to an existing Output File or replace the contents of the file.

Export subordinate definitions

Option to import subordinate objects. Select the check box to export subordinate objects with the objects. Note that Local definitions are always exported (e.g., a Local Access Definition is exported as part of an Extract Request). Objects and possible subordinate objects are:

Primary Object Subordinate Object(s)
Access Definition Relationships
Archive File Collection none
Archive Request Access Definition Storage Profile
Report Request
Calendar none
Column Map Column Map Procedures
Column Map Procedure none
Compare Request Access Definition
Table Map
Column Maps
Column Map Procedures
Report Request
Convert Request Table Maps
Column Maps
Column Map Procedures
Report Request
Currency Table none
DB Alias none
Delete Request none
Edit Definition Access Definition
Report Request
Extract Request Access Definition
Insert Request Table Map
Report Request
Column Maps
Column Map Procedures
Report Request
Load Request Table Maps

Column Maps
Column Map Procedures
Report Request
Primary Key none
Relationship none
Report Request none
Restore Request Insert Requests
Load Requests
Table Maps
Column Maps
Column Map Procedures
Report Requests
Storage Profile none
Table Map Column Maps
Column Map Procedures

Menu Commands

In addition to standard File and Edit options, you can use the following commands from the File and Tools menus on the Export dialog:

File Menu

Set as Default
Save the setting for Export subordinate definitions and reuse it when the dialog is redisplayed.

Tools Menu

Select All Definitions
Select check boxes for all listed definitions. This command is especially useful when you want to export all or most of the definitions.
Deselect All Definitions
Clear the check boxes for all listed definitions, including shaded and/or selected check boxes.
Show Process Log
Display the Export Process Log generated by the last execution of Export.

Build the Output File

The Export Utility allows you to develop a strategy to meet the needs of your installation. For example, you may want to copy one Extract Request with all subordinate objects and another Extract Request with none of the subordinate objects. As another example, you may want to export an Access Definition from one Optim Directory, supplement it with relationships from a second Optim Directory, and include Table Maps from a third.

For either example, you would run Export several times. If certain objects are intended for one Optim Directory and others for another, you might direct the exported objects to different Output Files, and import each file as needed. Alternatively, you can use Export to direct the exported objects to a single Output File by selecting the Append definitions to output file check box for each Export. Then, you can import all of the objects in one step, using the single Output File as input.

Run Export

To start an export in the Export Utility, choose Run from the File menu. During Export Processing, the Export Progress pane displays the number of objects of each type that are exported and the number of errors encountered.

The status bar displays information about the current object that is processed. When Export Processing is finished, the status bar displays the message: “Ready.”

Export Errors

If errors occur during Export Processing (for example, a dropped object is selected for export), an error message is displayed. Objects for which processing errors occur are also represented visually by a red “X” and errors are written to the Export Process Log. You can check the Export Process Log for diagnostic information about errors.

The following dialog shows error indicators after an Export:

export process log, showing errors for objects that could not be exported

If some object definitions fail to be exported due to errors (for example, the object was dropped after the list was generated), you can check the definitions and review the Export Process Log.

Export Process Log

When the Export is complete, select Show Process Log from the Tools menu to display the Export Process Log.

export process log showing details of completed export

This log displays the following details:

Creation Date
Date and time the Export Process Log was created.
List of errors
Explanatory text for each error if errors were encountered.
List of exported objects
Names of the exported object definitions, grouped by object type.

Print

Print the log by choosing Print from the File menu. Each execution of Export clears the log file before information for the current execution is written. Previous log information is not retained.