Import from IJC Database-Source Tab

To open the Import from IJC dialog, click the Import IJC button under the Database group of the ribbon.

images/download/attachments/1802410/Import_IJC_Button.png

On the Source tab, you can select a source for import and you can specify data placement settings.

images/download/attachments/1802410/Import_from_IJC_Source_Tab.png

URL

The personal server address you want to use can be entered in the IJCServerSelectorView form or you can select one of the servers previously used from a drop-down list.

The IJCServerSelectorView form can be opened by pressing the small browse icon next to the URL field.

The address must be entered in the following format:

http://<IPaddress of the server>:<port number>

images/download/attachments/1802410/IJCServerSelectorView.png

After specifying a valid server address press the Next button to open the Data tree and Import options form where you can select a data tree.

Only one data tree can be selected to be imported. You can decide if you want to import all records from the selected data tree or only the current result set retrieved from the database in the IJC application.

images/download/attachments/1802410/Data_Tree_and_Import_Options.png

After pressing the Finish button on the Data tree and Import options form, the address of the selected data tree will be displayed in the URL field of the Source tab.

Format Specific Import Options

  • Skip Atom Values: It is possible to import structures from the IJC data table without atom numbers by selecting this check-box. The check-box is unselected by default.

To Workbook and Worksheet

The destination workbook and worksheet can be specified for the import. Use the combo box to specify the desired workbook and worksheet.

The active worksheet is selected by default, and the imported data will be mapped at the end of the sheet (last used cell in the file).

It is also possible to create a new worksheet for the import by typing in a name for the new sheet. A red exclamation mark with a tooltip indicates if the entered sheet name already exists, contains a not allowed character, or the field is left blank.

In Office 2013 and newer Office versions, it is not possible to import to another workbook, the drop-down list is deactivated, only the worksheet can be selected.

Use the Rename Target Worksheet checkbox to overwrite the name of the selected worksheet with the name of the imported table.

The target worksheet cannot be renamed if the name of the selected table contains any characters that are not allowed in sheet names, for example, square brackets.

The default state of the checkbox can be specified in Options > General > Worksheet Name.

Data Placement

  • Append: By using this radio button when importing structures with their properties to a worksheet, which is not empty, the new structures and data are appended to the existing ones.

  • Overwrite: By using this radio button when importing structures with their properties to a worksheet, which is not empty, the existing structures and data are overwritten by the imported ones.

    • Start: When overwriting the existing data, it is possible to specify a starting cell for the process. The column and row number can be specified or the active cell can be selected as a starting cell.

  • Create Header: It is possible to import the structures and their data with or without headers by selecting or unselecting this checkbox. The checkbox is selected by default.

  • Transpose: It is possible to import the structures and their data into columns instead of rows by selecting this checkbox. The checkbox is unselected by default.

Click the Next button to switch to the next tab.