Selecting Columns for Import

Back 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".

 

Form.ImportfromDatabase.SelectColumns_2

 

 

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.

 

Form.ImportfromDatabase.SelectColumns_2

 

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.

 

  1. Switch to Columns tab where you can select columns to import data from. If you click on Select all, all data fields will be selected, if you click Deselect all, the selection will be removed from all data fields.

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.

       

  1. On the right side of the dialog you can read and edit information about the currently selected field, e.g you can change the display name of the field:

 

form.ImportFromDatabase.LoadSaveFilter

 

Basic category:

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.

 

Settings category:

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.

 

  1. After selecting the fields to be imported, the title of these fields can be saved in an .xml file by clicking on Save Filter button.
  2. 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 on Load Filter button. This .xml file can be saved as default filter in JChem Options/General Settings/Filtering/Default Database Field Filter menu. (See also in Options/General Settings topic in this Guide.)
  3. A label with the name of the active filter file appears at the left bottom side of the dialog showing the appropriate active filter:

 

form.ImportFromDatabase.ActiveFilter

 

  1. If you click on a table, which is not included in the active filter, the label disappears.
  2. If you go back to Query tab and re-select the appropriate table or select another table, the label appears again.

 

By pressing Next button you can switch to Rows tab, where you can further refine your selection.


Back to index page