Greenrain Automation allows users to validate Member.Register data. There are three ways to validate the data depending on input data sources:

1. Excel

2. SelectSql

Configuration

The following settings are required to be made for GDRFAD Members Validation V2:

1. Go to Greenrain Automation Settings

Log in to Greenrain Automation. Select "Settings" from the Toolbar → 'Greenrain Automation Settings' form opens.

Figure1.

2. Configure "GDRFAD Members Validation" tab

Select "GDRFAD Members Validation V2" tab and configure settings depending on input data sources:

Open

Figure2.

1. 'Validate members against GDRFAD': should be checked.

2. 'Processing interval' drop-down fills automatically with custom values. User can select an interval from the list, '30 minutes' for example.

3. 'Choose where Greenrain Automation will get person register data from':

   1. for Excel:

      1. 'Excel' value should be selected from drop-down list.

      2. 'Select input folder for Excel files'. Specify the directory from which you want to retrieve data.

      3. 'Select output folder for Excel files'. Specify the directory where you expect output data.

   2. for SelectSql:

4. Click "Save" button.

Create Member.Register input data

Excel

1.Create excel file

Create excel file in the following fomat: ExcelFileFormat.

SelectSql

1. Create SELECT SQL script

2. Create SQL to report successful Member.Register validation

3. Create SQL to report Member.Register validation failure

Validate Member.Register data

1. Go to Greenrain Automation Services

Select "Services" from the Toolbar → 'Greenrain Automation Services' form opens (refer to Figure1.).

2. Start the service

It allows to start a service after certain runtime configured on the "GDRFAD Members Validation V2" tab (refer to Configuration → 2. Configure "GDRFAD Members Validation V2" tab).

1. Click "Start the service" link:

   1. 'Download Service Status' will be changed to RUNNING (marked with green).

   2. 'Stop the service' link will be displayed under the status.

2. Click "Close" button.

Figure4.

"Run" link in the Toolbar allows a user to run the service at any time on demand (refer to Figure1.).

3. Check Results

1. Excel:

2. Go to the output folder and check results in the following format: Results.

3. SelectSql

4.Check database.

The input data will be aaded to the following tables:

1. GA:MemberIdLog

2. GA:Transactions