Tag: Comparator
The Comparator
tag lets you automate the flexYgrid's integrated Data Comparator tool.
<Comparator FilePath="databaseEZ-comparator-setup.xml"/>
Tag Attributes
Attributes | Attribute Value | Value Description | Comment |
Target | Applicable Grid Code | | Not mandatory – 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 | Mandatory |
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
Field Name | Compatible Field Values | Value Description | Comment |
ModifiedAfter | User definable | A date using standard YYYY-MM-DD format | |
Detailed Description
The configuration for the Data Comparator
CANNOT be automated directly. The attribute
FilePath, along with a saved configuration file must be used.
Note | 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. |
<Comparator FilePath="databaseEZ-comparator-setup.xml"/>
Example Script
<?xml version="1.0" encoding="UTF-8"?>
<ytriaAutomation Application="databaseEZ" ApplicationVersion="16.5">
<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 in databaseEZ; 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.