Import from Database in JChem for Office-Columns Tab

    On the Columns tab, the columns of the previously selected database table or view are displayed.

    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/1806210/Import_from_Database_Columns_Tab_Buttons.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/1806210/Import_from_Database_Columns_Tab_Filter.png

    Options

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

    images/download/attachments/1806210/Import_from_Database_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

    Click the Next button to switch to the Rows tab, where the selection can be further specified.