Understanding the import statistics

Q: This question pertains to the Import Results box displayed after an import. In several instances the “Applications Added” does not equate to the actual number of records contained in the imported file. This is the case even with a new document. The totals added together still does not equal the record count in our imported file. Can you help us understand why their is a difference and what is happening to the data “not imported”?

A: It is happening because of duplicate rows in the file. In most cases, with duplicate rows you get:

Row Count = Applications Added + ( 2 * Unchanged )

The reason for this is related to how the counts are determined. When the file is imported, the Status is set to null for all current applications. As the file is loaded, new applications are added with a Status of “A”. Records that already exists are marked “F”. Records that are not found stay null (and are to be deleted).

The Count is determined by doing Count where Status = “A” in SQL, etc. If a source file contains duplicate records the first application is added with “A”. When the duplicate application is loaded, the “A” gets changed to a “F”.

If some applications are duplicated more that once, that would not be true and it would be impossible to determine the row count based on the numbers shown.