Duplicate Record Remover Help

 

Export Changes as XML: Field Descriptions and XSD Schema

Field Descriptions

The following fields appear in the ‘Changes XML’ file:

XML Attribute Name

Description

KeepPrimaryKey

The primary key of the record to keep (the Master record)

DeletePrimaryKey

The primary key of the record to delete (the Slave record)

LikenessPercent

The degree of likeness the examination process calculated between the records.

IsAutoMerge

True if the records were automatically merged as part of the examination process.  False if the merge was initiated manually by the user in the Processing Tool.

ExportBatchDate

The date and time the change was exported as part of a batch (batches are be grouped together based on this value).  This isn’t shown if batch exports are not being used.

FieldName

The source data field name the edit applies to.  This is the field name as imported from the original data.

FriendlyFieldName

The user-specified field name of the field the edit applies to, as set in the setup wizard.  See the ‘Useful Tip’ on this page for more details on how to set a friendly field name.

OriginalValue

The original value of the field before it was updated in the merge or edit.  This can be used to make an optimistic concurrency check on the live database before making an update to that field (for example checking that the value hasn’t been updated since the data was exported to the Duplicate Record Remover tool for processing).

UpdateToValue

The new value the field needs to be set to.

RecordPrimaryKey

The primary key of the record being updated.

 

XSD schema

<?xml version="1.0" encoding="utf-8"?>

<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">

  <xs:element name="DuplicateRecordRemover">

    <xs:complexType>

      <xs:sequence>

        <xs:element name="Changes">

          <xs:complexType>

            <xs:sequence>

              <xs:element maxOccurs="unbounded" name="Merge">

                <xs:complexType>

                  <xs:sequence minOccurs="0">

                    <xs:element maxOccurs="unbounded" name="Edit">

                      <xs:complexType>

                        <xs:attribute name="FieldName" type="xs:string" use="required" />

                        <xs:attribute name="FriendlyFieldName" type="xs:string" use="required" />

                        <xs:attribute name="OriginalValue" type="xs:string" use="required" />

                        <xs:attribute name="UpdateToValue" type="xs:string" use="required" />

                        <xs:attribute name="RecordPrimaryKey" type="xs:string" use="required" />

                      </xs:complexType>

                    </xs:element>

                  </xs:sequence>

                  <xs:attribute name="KeepPrimaryKey" type="xs:string" use="required" />

                  <xs:attribute name="DeletePrimaryKey" type="xs:string" use="required" />

                  <xs:attribute name="LikenessPercent" type="xs:decimal" use="required" />

                  <xs:attribute name="IsAutoMerge" type="xs:string" use="required" />

                  <xs:attribute name="ExportBatchDate" type="xs:string" use="required" />

                </xs:complexType>

              </xs:element>

              <xs:element maxOccurs="unbounded" name="Edit">

                <xs:complexType>

                  <xs:attribute name="FieldName" type="xs:string" use="required" />

                  <xs:attribute name="FriendlyFieldName" type="xs:string" use="required" />

                  <xs:attribute name="OriginalValue" type="xs:string" use="required" />

                  <xs:attribute name="UpdateToValue" type="xs:string" use="required" />

                  <xs:attribute name="RecordPrimaryKey" type="xs:string" use="required" />

                  <xs:attribute name="ExportBatchDate" type="xs:string" use="required" />

                </xs:complexType>

              </xs:element>

            </xs:sequence>

          </xs:complexType>

        </xs:element>

      </xs:sequence>

    </xs:complexType>

  </xs:element>

</xs:schema>

 

Related Topics

Export Changes Made

 

Duplicate Record Remover
Copyright (c) 2009 Precision Data, All Rights Reserved.