Comparator: Launch Data Comparison

Tag: Comparator

The Comparator tag lets you automate the FlexyView integrated Data Comparator tool.

XML

<Comparator FilePath="databaseEZ-comparator-setup.xml"/>

Tag Attributes

Attributes	Attribute Values	Value Description
Target	Applicable Grid Code	N/A - Not Required. If no target is set, this will default to the main grid.
FilePath	User definable	The file path to the previously saved Comparator configuration XML file - Required
Remove	Rows, Columns, All	Remove all 'Not Present' Family Member entries from the grid. Remove all comparison results columns / Remove both Attributes cannot be combined, only one can be chosen at a time—see detailed description

Attributes

Attribute Values

Value Description

Target

Applicable

Grid Code

N/A - Not Required. If no target is set, this will default to the main grid.

FilePath

User definable

The file path to the previously saved Comparator configuration XML file - Required

Remove

Rows, Columns, All

Remove all 'Not Present' Family Member entries from the grid.

Remove all comparison results columns / Remove both

Attributes cannot be combined, only one can be chosen at a time—see detailed description

SetParam Options

Attributes	Attribute Values	Value Description
ModifiedAfter	User definable	A date using standard YYYY-MM-DD format

Detailed Description

The comparator configuration can be loaded via a file, or imported directly into the script,

When using the attribute FilePath to retrieve incoming files, it will validate if both the folder path is correct and that the file itself exists.

XML

<Comparator FilePath="databaseEZ-comparator-setup.xm>

Example Script

XML

<ytriaAutomation>
	<Load Server="ACME01/ACME" Select="True"/>
	<Comparator FilePath="C:\comparator_config.xml"/>
</ytriaAutomation>

In the script above, the entire server "ACME01/ACME" will be loaded into the database tree; all databases will be selected and loaded into the main grid. The action 'Comparator' will trigger the retrieval of the saved Data Comparator configuration file "comparator_config.xml" and run a data comparison, of the data in the main grid, based on this configuration.

Tag: SetGridComparatorDefault

Use the SetGridComparatorDefault tag inside the Comparator tag to load the configuration directly from the script.

The content of a file generated by the Comparator dialog can be reused directly.

XML

<ytriaAutomation Application="sapio365">
	<Comparator>
	  <SetGridComparatorDefault>
		<AddColumn ColumnID="membershipType" Title="Membership Type" Type="C2C"/>
		<AddColumn ColumnID="displayName" Title="Group Display Name" Type="PK"/>
		<AddColumn ColumnID="memberDisplayName" Title="Member Display Name" Type="SK"/>
		<SetColor Different="3684607" Equals="40479" Missing="906204" Unwanted="14779416"/>
		<Option PresenceOnly="False" Reference="0" RowPK="|*pk*|id|*==*|7d1ee427-3ec5-4247-8b95-e0e45c389a41|*pk*||*==*|" ShowFamilies="True" ShowHidden="False" Verbose="False" WYSIWYG="True"/>
	  </SetGridComparatorDefault>
	</Comparator>
</ytriaAutomation>