ETL Import History

This article provides step-by-step guidance on accessing and reviewing the ETL Import History in ACE. By navigating to Transactions → ETL Import → History, users can select specific import files to view detailed information on the Delta Log page. The Delta Log page offers a comprehensive summary of each import job, including status, duration, error counts, and records loaded. This guide explains each component of the Delta Log, helping users understand key details about the import process, troubleshoot issues, and even roll back imports if necessary.

Locating ETL Import History

1. Navigate to: Transactions → ETL Import → History

2. On the Imports list screen, click on the desired file to view its details.

3. This will open the Delta Log page, where you can review comprehensive information about the selected import.

Reviewing the Delta Log in ETL Imports

The Delta Log section provides a summary of each import job, enabling you to monitor the success and details of your data imports. Below are the key components and their descriptions:

Delta Log Details

• Delta Log ID: A unique identifier for each import job.

• Download Messages: Click this button to download detailed messages related to the import, including any warnings, errors, or other log messages.

General Information Section

• Delta Status: Displays the completion status of the import job (e.g., COMPLETED, FAILED).

• Start Time and End Time: Show when the import started and ended.

• Duration: Total time taken to complete the import.

• Error Count: The number of errors encountered during the import.

• Info Count: Number of informational messages logged.

• Warn Count and Duplicate Count: If applicable, display the count of warnings and duplicate records encountered.

Records Loaded by Type

This section provides a breakdown of the different types of records loaded:

• Client Count: Number of client records imported.

• Debt Misc Count: Additional debt-related records.

• Debt Count: Total number of debt records imported.

• Transaction Count: Number of transactions imported.

• Demographic Count: Total number of demographic records.

• Form Count: Number of form entries loaded.

• Debt Balance and Transaction Balance: Show balance information loaded for debts and transactions, if applicable.

Rollback

Rollback: Click this button to reverse the import if any issues are detected, allowing you to undo the data load if necessary.

For more details view the Rollback Accounts article.

Caution:

The Rollback Feature allows the removal of accounts from your ACE application.

Accounts with transaction history cannot be rolled back.