History Tab

Overview

The Data Project Designer’s History tab is used to view details of the files loaded within a data project. It is available immediately upon creating and saving a new data project.

The tab consists of:

• Data Project History list

• Selected History Details panel

Each is discussed separately.

Data Project History List

The left-hand side of the History tab displays a read-only list of the data project’s files. Files are displayed in reverse chronological order. For each, the following read-only details are displayed:

• File name

• Status icon:

  • Completed: tick

  • Failed: cross

• Status

  • Failed: a failure occurred and further progress is not possible without manual intervention

  • Completed: the load completed successfully

• Started: the date/time file processing began

• Completed: the date/time file processing ended

You can highlight a file to view its details in the Selected History Details panel to the right.

Selected History Details Panel

The following toolbar buttons are shown at the top of the panel:

View sample: this button is available when the selected file load has completed. Clicking this button shows a sample of the data in the read-only Loaded Data Sample dialog. Note that the SEQ_NUM, BRAND_DT, JOBID and BRAND_FILE columns are created automatically by RPI during data load.

You can close the dialog by clicking the OK button.

Download: on invocation of this option, you can download the file stored in the FileAssets folder within the current RPI server's FileOutputDirectory. A Download file job is initiated at the My Jobs dialog (for more information, please see that interface's documentation). On its completion, you can open the downloaded file.

The Selected History Details section contains the following:

• Started: the date/time file processing began

• Completed: the date/time that the load completed

• Validation Results section:

  • Processed

  • Successes

  • Failures

• Load Results section:

  • Total rows

  • Rows read

  • Rows filtered

  • Rows loaded

  • Rows updated

• Log Details: presented in chronological order