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 database tables the structure column is automatically selected, in this case "Is Structure Column" property is not editable and the value is set to True.
Select (5), Select (15)
If you click on Select (5) the first 5 data fields will be selected. You can specify the maximum number of columns to be selected in Options/General/Data Mapping Limitations.
Note: If CD_STRUCTURE column is not selected, then no structures will be displayed on the sheet. Only the column named CD_STRUCTURE is considered as Structure column.
The DisplayName of the field can be edited.
Use as Identifier: we are using the same dialog as in JChem for Excel, but in JChem for Office this option has no effect.
ID: the previously selected ID is displayed again.
IsFormula: if this is set to True, in the grid view (see in Selecting Rows for Import 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 button you can switch to Rows tab, where you can further refine your selection.