Import Runner allows you to run an import configured in the Tables window without accessing the Tables window. (The import routines created in the Tables window appear in the Import Runner window when the Is Public check box is selected for the routine.)

The Import Runner window has three tabs:

  • Imports: This tab displays each public import routine that is currently available for use. It also shows the target table into which the imported data will be placed.

    When you right-click a record in this tab, a shortcut menu is displayed. This menu shows the common commands along with the following special command:

    Edit Config: This command displays the dialog box for configuring the import routine.

  • Import Detail: This tab displays the record layout of the input file and its Oracle intermediate table structure. This information is set during software configuration, after which it cannot be edited. For the import routine selected in the Imports tab, the Import Detail tab provides the mapping from the columns of the data source to the columns of the target table. The information show in this tab is read-only. If you need to modify any information shown in this tab, use the Edit Config command found in the Imports tab. This tab contains two panes:

    Import Columns: This pane shows the columns in the data source.

    Import Column Mapping: This pane shows the mapping from one or more columns in the data source to a column in the target table.


  • Import Log: This tab allows you to import data into the system and shows the history of all previous import attempts.

    When you right-click this tab, a shortcut menu is displayed. This menu shows the common commands along with the following special commands:

    Download File: After importing data, this command allows you to download the error file for the import process to your computer.

    Import New Data: This command loads data from the server where the file containing the data is located to the target table in the application.

    Manage Files: This command allows you to move the desired files to the server in preparation for importing.

  • No labels