Selecting Columns for ImportBack to index page
On Columns tab columns of the previously selected database table/view are displayed. By a single clicking on the check-box beside the name of the table you can select the columns you would like to import.
In case of views the users can select which one of the listed columns should be handled as structure column with "Is Structure Column" property in the Basic category. The following column names will be selected by default in the following order: CD_STRUCTURE, STRUCTURE, CD_SMILES, SMILES. If none of these columns are available the first will be set True with "Is Structure Column".
In case of JChem databases tables the structure column is automatically selected, in this case "Is Structure Column" property is not editable and the value is set to True.
The DisplayName of the field can be edited.
Is Structure Column: see the description above.
Use as Identifier: here can be selected if this field will be used as an Identifier field after importing. This means that it can be used in ID assignment related function (JCIDSYSStructure).
ID: the previously selected ID is displayed again.
IsFormula: if this is set to True, in the grid view (see in Running the Search topic) the appropriate field will be displayed as a molecule formula format, which means that the number after atomic symbols will be displayed in subscript. (This function is not active in the excel worksheet, only in the grid view.)
Type: String, Date Time, Numeric.
In Format category the imported and exported format of data in the cell can be specified.
By pressing Next tab you can switch to Rows tab, where you can further refine your selection.