Verifying an import

You can verify the imported data at these stages:

  • After running the import task when the CSV file data has been imported into the staging table
  • After running the interface task when the entries in the staging table have been inserted into their respective system tables
  • After running either task (import or interface), view the Job Scheduler logs for information about the task run

Verifying the import process at these stages lets you detect and rectify errors.

Although most imports are ongoing scheduled tasks where an operator is unlikely to be monitoring the import task’s progress, verify the first import to ensure that the required data is importing as required.

Verifying import data after the import task has been run

After the Job Scheduler runs the import task, you can determine the status of the task by viewing the Import Transactions page. The page contains a record of all import transactions, including all import tasks, that were run by the Job Scheduler. By clicking the Edit link next to a transaction entry, you can view the details of the transaction for any anomalies before the interface task is executed.

For example, within the Import Transaction Details page, check:

  • That the date and time stamps coincide with the appropriate import task that you specified.
  • That the record counts coincide. For example, if 1,000 records should be imported, then 1,000 records should be displayed in the Import Transaction Details page.

See Viewing import or export transactions.

Verifying import data after the interface task has been run

After the Job Scheduler executes the interface task, you can determine the status of the task by viewing the Import Transaction page. The page displays each import transaction, including each import task, that was run by the Job Scheduler. When the interface task is executed, the task processes each corresponding standard import interface transaction in the Import Transaction page with status=PENDING. For example, an Employee Import Interface task processes the Employee Import task in the Import Transactions page with status=PENDING.

After the interface task has been run, a status of either SUCCESS or FAILURE is indicated on the Import Transactions page for the previously PENDING transaction. You can view the details of each transaction by clicking the Edit link next to the transaction entry, which takes you to the Import Transactions Details page.

The Import Transaction Details section (lower) displays each record of the import in the WBINT_IMPORT table; that is, all the entries in the import data file should be displayed. After the running of the interface task, a status of either APPLIED, ERROR, or WARNING is displayed for each entry in the Import Transaction Details section.

  • APPLIED: Indicates that the entry has been successfully inserted into the appropriate application table.
  • ERROR: Indicates that there is an error with one or more of the fields in the entry and the record is not loaded to the system.
  • WARNING: Indicates that the record has been loaded into the system with an error in one or more of the fields.

See Viewing import or export transactions.

For entries in the Import Transaction Details section with errors, the Message column indicates the entry error. You can correct the error by either:

  • Editing the CSV file to correct the file and run another import task, followed by an interface task.
  • Editing the entry directly using the Import Transaction Details section and running another interface task.
Note: The fields within the Import Transaction and Import Transaction Details pages are not editable by default. See Enabling modifications to the Import Transactions page.

Verifying the import data through the Job Scheduler log

After the Job Scheduler runs the import and interface tasks, you can validate the task run details through the Job Scheduler import task log. The log contains Job Scheduler task run details including task runtime, task status, and any error activities that may have occurred during the actual run. If the Job Scheduler task status is FAILED, the status is always accompanied by an error message and exception stack trace details.