Import from IJC Database-Columns Tab

On the Columns tab, you can select columns to import data from.

To select a specific column, simply check the box beside its name. It is also possible to select all columns, to do this, select the checkbox above the column names. You can deselect all columns in the same way.

After selecting the columns, it is possible to save the selection to an XML file by clicking the Save Filter button. Next time if you want to import the same data from the same kind of database (having the same tables and fields) the previously saved XML file can be loaded by clicking the Load Filter button.

images/download/attachments/1802411/Import_IJC_Columns_Tab.png

The XML file can be used as a default filter in Options > Database Connection > Field Filtering > Default Database Field Filter.

When a filter is loaded from an XML file, the name of the filter can be seen at the bottom of the Import from Database dialog.

images/download/attachments/1802411/Import_IJC_Columns_Tab_Filter.png

Options

When a column is selected, options appear at the right side of the window.

images/download/attachments/1802411/Import_IJC_Columns_Tab_Options.png

Basic

Consists of the following items:

  • Display Name: The display name of the selected column, it can be edited freely.

  • Is Structure Column: Specifies if the column is a structure column or not. Possible values are TRUE and FALSE.

  • Use as Identifier: Specifies if the column is an identifier or not. This means that it can be used in an ID assignment related function (JCIDSYSStructure). Possible values are TRUE and FALSE.

Format

Consists of the following items:

  • Export Format: Specifies the export format of data in the cell. Possible values are as follows:

    • General

    • Number

    • Currency

    • Accounting

    • Date

    • Time

    • Percentage

    • Fraction

    • Scientific

    • Text

    • Special

  • Import Format: Specifies the export format of data in the cell. Possible values are as follows:

    • General

    • Number

    • Currency

    • Accounting

    • Date

    • Time

    • Percentage

    • Fraction

    • Scientific

    • Text

    • Special

Settings

Consists of the following items:

  • ID: Displays the previously selected ID.

  • Is Formula: Specifies if the column in the grid view will be displayed as a molecule formula format or not. Molecule formula format means that the number after atomic symbols is displayed in subscript. This function is not active in the excel worksheet, only in the grid view. Possible values are TRUE and FALSE.

  • Type: Data type of the field. Possible values:

    • Default

    • DateTime

    • Numeric

    • Text

    • Currency

You can start the import process by clicking the Import button.