Report Files

Delta Statistics.txt

This is the primary log created by the comparison. It contains useful statistics about the differences, or delta, between the two dictionaries.

The following is an annotated example:

14:56:2.888 12/18/2012 -------------------------- New Dictionary Compare. ---------------------------
Open First dictionary: rel_HECDLCOM2012.4.2_20121114.2.eddv
Compare TO dictionary: rel_HECDLCOM2012.4.3_20121214.1.eddv

14:56:25.835 --- Begin All Documents Compare ---
592 document count in rel_HECDLCOM2012.4.2_20121114.2.eddv.
622 document count in rel_HECDLCOM2012.4.3_20121214.1.eddv.

591 same.
31 new.
1 removed.

14:56:54.325 --- Begin All Packages Compare rel_HECDLCOM2012.4.2_20121114.2.eddv TO 
rel_HECDLCOM2012.4.3_20121214.1.eddv ---
241 package document count in PKG.Commercial.
242 package document count in PKG.Commercial.

241 same.
1 new.
0 removed.

455 package document count in PKG.HomeEquity.
484 package document count in PKG.HomeEquity.

454 same.
30 new.
1 removed.

2:56:55 PM.427 --- Begin All Attribute Compare rel_HECDLCOM2012.4.2_20121114.2.eddv (5349) TO 
rel_HECDLCOM2012.4.3_20121214.1.eddv (5478) ---
5349 attribute count in rel_HECDLCOM2012.4.2_20121114.2.eddv.
5478 attribute count in rel_HECDLCOM2012.4.3_20121214.1.eddv.

5343 same.
135 new.
6 removed.

rel_HECDLCOM2012.4.2_20121114.2.eddv
rel_HECDLCOM2012.4.3_20121214.1.eddv

14:56:55.947 12/18/2012 Finished Dictionary Compare. -----------------------------------------------------

Delta Doc Attrib List Stats.txt

Short for Delta Document Attribute List Statistics, this file contains useful statistics about the Attribute By Document Delta comparison. Each document that exists in BOTH dictionaries will have an entry in this file. If the attributes matched exactly, the entry will be a single line beginning with the word IDENTICAL. If the attributes did not match exactly, the entry will consist of two spaced lines: the document ID surrounded by dashes followed by the statistics of the delta.

For example:

IDENTICAL ------ 55 matching xpaths in PKGD.Addendum-CrossCollateral
IDENTICAL ------ 55 matching xpaths in PKGD.AddendumEscrow
IDENTICAL ------ 69 matching xpaths in PKGD.Addendum-PreferredRate-ClosedEnd

------------ PKGD.AddendumToLoanApplication-HE ------------
19 same, 32 new, 19 removed.

IDENTICAL ------ 49 matching xpaths in PKGD.AdjustableRateMortgageNoticeOfRateChange 
IDENTICAL ------ 83 matching xpaths in PKGD.Affidavit-BusinessPurpose-MI 
IDENTICAL ------ 74 matching xpaths in PKGD.Affidavit-BusinessPurpose-PA

All Attributes DELTA.csv

This file reports all new and removed attributes. The following columns will appear, followed by any defined custom metadata attributes.

Delta This column indicates Added or Removed.
XPath The full xpath of the attribute.
Prompt The prompt this attribute will display in the Document Viewer application.
Data Type Data type of the attribute.
Enum Count Count of enumerations.
Enumerations List of enumerations this attribute can have separated by a semicolon and space.
Description Description of the attribute.
Doc Count If added, the count of documents in the compare dictionary this attribute occurs on. If removed, the count of documents this attribute was removed from.
Documents If added, the list of documents in the compare dictionary this attribute occurs on. If removed, the list of documents this attribute was removed from.

If the custom metadata attributes are defined differently in the two dictionaries, they will both appear in the column heading separated by a dash “ – “. For example, if the first dictionary has one custom metadata attribute defined as Source Data Element and the second has one custom metadata attribute defined as CSV Field Name, the column heading would read Source Data Element - CSV Field Name. If in this same example the second dictionary didn’t have any custom metadata defined, the column heading would display as Source Data Element - . If in this same example the second dictionary has one custom attribute and they matched (case insensitive) the column heading would display as Source Data Element.

Note: Typically you would not compare two dictionaries containing different custom metadata defined as they will always compare differently. However, the compare feature handles these cases gracefully and catches the legitimate problem when the custom metadata attributes are in only one of the dictionaries.

All Attributes Metadata DELTA.csv

This file contains the metadata comparison results for any attributes that exist in both dictionaries. Only attributes where a change was detected are written to this file. Each entry consists of two lines: Was and Now. The Was row will contain a single tick ‘ indicating it was a match to the Now row. A blank column in the Was row indicates it was blank before but is not blank in the the Now row. The same metadata column headings appear in this file that were described for the All Attribute Delta.csv file. The following metadata attributes are compared for change:

  • Prompt
  • Data Type
  • Enum Count
  • Enumerations
  • Description
  • Any custom defined metadata

All Documents DELTA.csv

This file reports all added and removed documents. The following columns appear:

Delta This column indicates Added or Removed.
Document ID The ID of the document.

All Packages DELTA.csv

This file reports all added and removed packages. The following columns appear.

Delta This column indicates Added or Removed.
Package ID The ID of the package.

Attribute By Document DELTA.csv

This file reports all new and removed attributes for each individual document.

Document ID The ID of the document.
Delta This column indicates Added or Removed.
XPath The full xpath of the attribute.

Document By Package DELTA.csv

This file reports all new and removed documents for each individual package.

Package The ID of the package.
Delta This column indicates Added or Removed.
Document ID ID of the document.
WKFS