Imports and exports

In the Imports and Exports tab you can compare data on imports and exports retrieved from the staging database with the contents on the scheduling case, and choose what to update in the schedule.

Tip: If an import and export have the same value in the Linked Import Id column, they are linked. The correct configuration for a valid link is to have the same ID for one export and at least one import.

For each import or export, the Compare column contains the result of the comparison between staging database and schedule:

• New: the import or export is in the staging database but not in the schedule.

• Missing: the import or export is in the schedule but not in the staging database.

• Updated: the records in the database and in the schedule differ in some respect.

• No Change: the records in the database and in the schedule match.

  Note: Imports and exports in the staging database are matched to those in the schedule according to the Integration ID metadata value. You can set it in the Imports and Exports pages of the scheduling environment, by choosing the Metadata view.
  When multiple users reconcile the schedule and then synchronize their data, imports and exports with the same integration ID are treated as conflicts.

Inspect imports and exports

Imports and exports can include several parcels, each containing different feedstocks. To reveal information for each parcel of an import or export retrieved from the staging database, do either of the following:

• Click the arrow icon in the first cell of the row corresponding to the import or export you want to inspect.

• Right click the row and choose Expand this from the context menu.

A new row appears for each parcel in the import or export, with information on the traded material contained in the parcel and its amount.

For import parcels, you can choose the assay to associate with the traded material. In the Material column, click the arrow icon to reveal a list of matching assays, and choose the one you want to use.

Compare values

When the Compare status is Updated, you will want to check in detail what has changed. You can hover on any cell of the table to show a tooltip with the new value (from the database) and the old value (from the schedule).

To check at a glance all the differences for a given import or export, click the corresponding row and check the Export Comparison and Metadata Comparison tabs to the right. Any difference between schedule and staging database is highlighted in yellow. You can choose to display just the differences, rather than all the data, by clicking the Show changes only option button.

Accept changes

To accept all the changes in the staging database, click the Accept All button. To accept just some of the changes, select one or more rows and click the Accept (number) button, for example Accept (2) if you have selected two rows. Accepting changes results in the following actions:

• New entries are added to the schedule.

• Updated entries are modified with the data retrieved from the database.

• Missing entries are not deleted from the schedule. No changes are made for such entries.

  Warning: No change are made to the schedule until you click the Apply button in the Modelling group of the Home ribbon tab.