Home >

On this page

AX2426

Execute tab

Using the Execute tab, you can define execution settings and run the import.

NOTE: This tab is not visible to non-admin users who do not have Execute permissions for the import.

Execute Options

The following options affect the execution of the import.

Option

Description

Allow pauses

Specifies whether pauses are honored during processing.

  • If enabled, then Axiom Software honors the pause settings on the Transforms tab. If a step has Pause enabled, then the import pauses after performing the step, and displays the temptable in the View Data dialog. When the dialog is closed, the import continues to the next step. See Troubleshooting imports using pause.

  • If disabled (the default setting), then the import will continue without pausing, regardless of whether any steps are flagged with Pause.

This option is only available to users with read/write access to the import. This option only applies to the current execution of the import; it is not saved in the import settings.

Preview only

Specifies whether the import will be run in "preview mode."

  • If enabled, then all steps of the import are performed except for the final step where data is saved to the destination table. This option is for testing purposes, so that you can test the import settings without actually saving data.

  • If disabled (the default setting), then the full import is run and data is saved to the destination table.

IMPORTANT: When an import is run in preview mode, all of the steps in the Transforms tab are performed, including any steps that modify tables other than the temptable. If you do not want these steps to occur as part of a preview, then you should disable the step on the Transforms tab before executing the preview.

This option only applies to the current execution of the import; it is not saved in the import settings.

Ignore lookup and key errors

Specifies the import behavior if lookup and key errors exist in the temptable data before saving. These errors include invalid lookup data, blank keys, and duplicate keys (if saving to a reference table or if Aggregate rows on final save is disabled).

  • If enabled, then any rows with lookup and key errors are ignored, and only valid rows are saved to the destination table. Once the import is complete, an error log is provided to detail the invalid rows. For more information, see Import validation errors.

    This option allows you to continue to save valid data even if invalid data is present. You can then investigate the invalid data, make corrections, and reimport.

  • If disabled (the default setting), then the import is aborted if any lookup and key errors exist in the temptable data. No data is saved to the destination table.

This option is only available to users with read/write access to the import. This option is saved in the import settings and will apply to future executions of the import by default.

NOTES:  

  • If this option is enabled and the import is executed by Scheduler, the execution status of the job is set to Partial Success if any errors are found. This will result in an email notification if the job is set to notify only on error.
  • This option does not apply if a Pre-Save Validation function is used in the import's transform steps. If this function is used, then the import is aborted if any validation errors are found and no further import steps are processed.

Aggregate rows on final save

Specifies whether duplicate rows are aggregated during the final save to the destination table. Duplicate rows are rows that have the same key column values.

  • If enabled (the default setting), then duplicate rows are aggregated before saving data to the destination table. This aggregation process may take some time for large imports.

  • If disabled, then the temptable data is not aggregated before saving data to the destination table. If any duplicate rows exist, the import is aborted and no data is saved to the destination table. You can optionally use the Ignore lookup and key errors option to instead exclude the invalid rows and only import valid rows.

    Disabling this option improves import performance for large imports where aggregation is not necessary.

This option is only available to users with read/write access to the import. This option is saved in the import settings and will apply to future executions of the import by default.

This option only applies when saving data to a data table. If you are saving data to a reference table, rows are never aggregated and duplicate keys are not allowed.

Description

You can optionally enter a description for the import. The description can be used to document the purpose of the import and/or to detail important import instructions. The description is limited to 2000 characters.

Executing the import

Click Execute to run the import. If you want to stop the execution, click Stop.

The Execution log displays the process steps of the import as it executes. If errors occur, they are displayed in the log.

For more information, see Executing import utilities.