ImportFromDatabaseByKeyAction

Back to index page

Description: Imports structures and other data from JChem Cartridge and JChem Base tables to preexisting data on the Excel sheet.

 

For example: IDs (1-10) of the compounds are in column A on the Excel sheet for assay report, and the database table has IDs (1-10) and the corresponding structures.

 

Import from Database By Key form - File tab

You can select a database table from you want to import structures. You have to select column A as key column and the field name of IDs in database table. You have to specify which is the structure column in the selected database table and the molecule string format. You can also decide if you want to create column headers or not. The data in database table can be imported according to IDs.

Actions.ImportFromDatabaseByKey_1

 

 

Import from Database By Key form - Columns tab

If the selected database table contains additional fields, you can specify which properties to import on the Columns tab, data without structures can be imported as well. There is no mandatory field, but at least one column has to be selected.

Actions.ImportFromDatabaseByKey_2

 

Import from Database By Key form - Progress tab

Clicking on the Import button starts the import process. The progress is displayed on the Progress tab. When the process is finished, the imported structures and data are displayed on the selected worksheet. Clicking Close button closes the Import from Database By Key wizard.

Actions.ImportFromDatabaseByKey_3

 

 

The ImportFromDatabaseByKeyAction is not available in the JChem for Excel ribbon/context menu/menu/toolbar by default but it is possible to make it available by customization of the ribbon/context menu/menu/toolbar.


Back to index page