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.Columns_Views

 

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.

 

Form.ImportfromDatabase.SelectColumns_2

 

 

  1. If you click on Select all above the list of column names, all data fields will be selected, if you click Deselect all, the selection will be removed from all data fields.
  2. 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.EditFields

 

Basic category:

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).

 

Settings category:

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.

 

  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.)

 

Form.ImportfromDatabase.Load_Save_Fields

 

  1. 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 to 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 tab you can switch to Rows tab, where you can further refine your selection.


Back to index page