AX1284

Run imports in development mode

You can run an import in development mode to test import settings or troubleshoot an import issue. In development mode, all import steps are performed except for the last step that saves the temp table data to the destination table.

When running in development mode, additional options are available:

You can pause the import after certain transformation steps are performed and view the data in the temp table as it exists after performing the step. Reviewing this data can help you determine if a particular transform is working as you expect. If an import doesn't have defined transformation steps, you can view the import data as it exists after the temp table is populated from the source data.
For delimited file imports, you can limit development mode processing to a certain number of rows for more efficient testing and troubleshooting.

IMPORTANT: When an import is run in development mode, all of the steps in the Transforms tab are performed, including any steps that modify tables other than the temp table. If you do not want these steps to occur during testing, disable the steps on the Transforms tab before executing the import in development mode.

Do one of the following to open the import for running, depending on whether you need to access the full import settings:
- Open the full Import Wizard: On the Axiom tab, in the Administration group, select Imports > ImportName > Edit. In the Import Wizard, go to the Execute tab.
  
  Using the Import Wizard, you can switch between the Execute tab and other tabs to view and edit the import settings as needed, and then run the import again.
- Open in execute-only mode: On the Axiom tab, in the Administration group, click Imports > ImportName > Execute.
  
  This opens a special Execute Import dialog that only displays the import execution options and controls. Use this mode if you only need to run the import and you don't need to review or edit any import settings. This is the only mode available to users who have execute-only permissions to the import.
NOTE: In systems with installed products, these features may be located on the Admin tab.

TIP: You can also open imports for execution using Axiom Explorer or the Explorer task pane. If you have read/write or read-only access to the import, the full Import Wizard opens. If you have execute-only permission to the import, the Execute Import dialog automatically opens where you access the import from the Imports Library.
In the Execute Import dialog (or the Execute tab of the Import Wizard), select Execute in development mode.

After development mode is enabled, the Development Mode Options section becomes available.

Select the following Development Mode Options as required:

Option	Description
Limit the number of rows imported to	Limits the development mode processing to a specified number of rows. When testing the import, you may only need to process a handful of rows to verify that the import is working as expected. Using a smaller number of rows increases import processing speed. After selecting this option, enter a number of rows between 1 to 1000. By default, the row limit is 1000. NOTE: This option is available only when the import source is a delimited file or Ellucian. If the import source is a database, you can limit the number of rows by setting a temporary WHERE clause in the SQL select statement.
Pause after specified transforms and display current temp table data	Specifies whether pauses are honored during development mode processing. If enabled, Axiom Budget Planning and Performance Reporting honors the pause settings on the Transforms tab. If a step has Pause enabled, the import pauses after performing the step and displays the temp table in the View Data dialog. When the dialog is closed, the import continues to the next step. See Run imports in development mode. If the default setting is disabled, the import continues without pausing, regardless of whether any steps are flagged with Pause. NOTES: This option is only available on the Execute tab of the full Import Wizard, and only if you have read/write access to the import. If the import does not have any transforms, this option is renamed to Pause and display temp table data after preview data is fetched. If enabled, the temp table is populated with data from the import source and the temp table data is displayed in the View Data dialog.

Option

Description

Limit the number of rows imported to

Limits the development mode processing to a specified number of rows. When testing the import, you may only need to process a handful of rows to verify that the import is working as expected. Using a smaller number of rows increases import processing speed.

After selecting this option, enter a number of rows between 1 to 1000. By default, the row limit is 1000.

NOTE: This option is available only when the import source is a delimited file or Ellucian. If the import source is a database, you can limit the number of rows by setting a temporary WHERE clause in the SQL select statement.

Pause after specified transforms and display current temp table data

Specifies whether pauses are honored during development mode processing.

If enabled, Axiom Budget Planning and Performance Reporting honors the pause settings on the Transforms tab. If a step has Pause enabled, the import pauses after performing the step and displays the temp table in the View Data dialog. When the dialog is closed, the import continues to the next step. See Run imports in development mode.
If the default setting is disabled, the import continues without pausing, regardless of whether any steps are flagged with Pause.

NOTES:

This option is only available on the Execute tab of the full Import Wizard, and only if you have read/write access to the import.
If the import does not have any transforms, this option is renamed to Pause and display temp table data after preview data is fetched. If enabled, the temp table is populated with data from the import source and the temp table data is displayed in the View Data dialog.

NOTE: Development mode and its options apply only to the current import session, These options are not saved in the import settings.

Click Execute to run the import in development mode.

The import is run and status messages are displayed in the Execution log. If pauses are enabled, the import pauses at the designated steps to display the View Data dialog. After closing the dialog, click Continue to continue processing. After all transform steps are run, the import stops before saving data to the destination table.