Import
Previous Next
Image Variant Installation properties

Import

The import feature is part of the export/import utility in iKnowBase. With the import feature you can upload a dump file previously exported from an iKnowBase instance, and import it into this iKnowBase instance.

Properties

This section describes the properties of an import, as shown on the corresponding Edit pane tabs.

Upload a new file

Property Description
Upload a new file

Upload a new datapump file exported by iKnowBase Export utility. Select a directory where you want to place the file.
After the file is successfully loaded into the database, you will be redirected to the configuration screen.

Edit tab

Property Description
Name

Displays the name of the transport set.
Description

Displays the description of the transport set.
Last built date

Date of the last time the transport set was built

Last exported date

Date of the last time the transport set was exported

Source version

Displays the iKnowBase repository version from the source of the transport set. Make sure the import side has the same version of iKnowBase before importing.
Import status

Displays the import status:

  • IMPORT_SET_CREATED: The transport set is created based on the uploaded dump file.
  • IMPORT_SET_FAILED: The transport set failed on import.
  • PRECHECK_DONE: Precheck completed with success.
  • IMPORT_DONE: The data is imported.
  • PRECHECK_FAILED: Precheck failed with errors.
Status date

Displays the time of the last precheck or import, alternatively the import creation time.
Scheduled job status

It the job is running in batch mode, the job status is displayed here.
DBLINK status

If the transport set was uploaded by the remote precheck option in the export routine, a status of the completeness of the transport set is shown here.
The message “No warnings” is displayed if the transport set is ready for import. Otherwise you need to download the file from the exporting side and upload the file on the import side.
The reason for this is XML-data, which cannot be uploaded over a database link.

Selected objects with number occurrence for each table
Name

Displays names of the database tables which are included in the import.
Description

Displays descriptions of the database tables which are included in the import.
Rows#

Displays the total number of rows in the transport set.
New#

Displays the number of rows to be inserted (rows that doesn�t already exist) per table.
Upd#

Displays the number of rows to be updated per table.
Errors#

Displays the number of rows that failed during pre-check or import.

Action if object already exists

The valid operations if an object exists on target are:

Action Description
Do nothing (leave as is) The object is unchanged
Update object The object will be updated and new details will be inserted.
Replace object The object will be updated and all details will be replaced.
Only insert new details The object is unchanged, but new details will be inserted

Debug and error log Tab

Property Description
Text

Displays the messages generated during the last pre-check or import.

Timestamp

Displays the timestamp for the messages.
Message type

Displays the message types.
Additional information

Displays additional information.

Note: The content of this tab is available after pre-check of the transport set or import of data is started.

Export tree Tab

Property Description
Name

Displays a graph of all the objects included in the import.

Creating an Import definition

Before you can create an import definition, you must create the appropriate dump file by exporting data.

To create an import definition, perform the following steps:

  1. On the List pane for import, click on the Upload new file action.
  2. Select the file to upload.
  3. Click the Upload file button. The import definition is created, and displayed in the Edit pane.

Importing Data

  1. Create an import definition. If the import definition already exists, it will be overwritten.
  2. Per table, define whether you will do a merge, or an insert. To do a merge, select the Replace on import? check box. To do an insert, with no update, deselect the Replace on import? check box.
  3. Per table, define whether you will do a delete and upload, or not. To do a delete, select the Delete details and load again check box. To not do a delete, deselect the Delete details and load again check box.
  4. After you have created the import definition, make sure to clean both the web cache (http://www.example.com:9400/) and the iKnowBase Java cache (http://www.example.com/ikb$developer/admin.do) before you validate the new import definition.
  5. Click on the Precheck button on the Edit pane of the import definition. The import is validated, and a debug and error log becomes available on the Debug and error log tab. A graphical overview of object dependencies becomes available on the Export tree tab.
  6. Check the debug and error logs.
  7. When the import definition validates, the Merge to iKnowBase button becomes available on the Edit pane. Click on this button to import data. The uploaded data is imported as specified in the import definition. A debug and error log becomes available on the Debug and error log tab. An overview of how many rows from which tables are exported becomes available on the Overview � tables tab and a graphical overview of object dependencies becomes available on the Export tree tab.
Previous Top Next
Image Variant Installation properties