/
Table in Customer Database

Table in Customer Database

Preconditions

1. Create Greenrain Automation database schema

Create the required database tables by running the script.

2. Create Customer database schema

Create the required database tables by running the script.

3. Create record in PersonRegister table (Customer database)

Create record in the following format: Person Register Table (TransactionId=NULL).

Configuration

The following settings are required to be made for Person.Register transaction generation from 'Table in Customer Database':

1. Go to Greenrain Automation Settings

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

Figure1.

2. Configure Person.Register tab

Figure2.

Select Person.Register tab and configure settings:

  1. 'Generate and upload Person.Register transactions to Shafafiya': 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. 'DatabaseTable' value should be selected from drop-down list.
    2. 'Connection string to the database'. Click "Configure Database Connection..." button and set Database = Name of the Customer database (see Preconditions p.2). Click "OK" button (if you wish to test the connection string click the "Test Connection String" button.).
    3. 'Table name'. Specify the table from which you want to retrieve data (PersonRegister from Customer database, see Preconditions p.2).
  4. Click "Save" button.

3. Check common configuration

Generate PersonRegister transaction

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 Person Resister tab (refer to Configuration → 2. Configure Person.Register 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.

Figure3.

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

3. Check PersonRegister transaction

  1. check e-mail notification.
  2. check Greenrain Automation database:
    1. PersonRegister table: 1 record is created;
    2. Transactions table: 1 record is created (FileName format: <Persons_Sender_CurrentDate_CurrentTime>).
  3. check Customer database:
    1. PersonRegister table: TransactionId is updated.
  4. check PersonRegister transaction in Greenrain Messenger: 
    1. Log in to Greenrain Messanger (refer to common configuration → 3. Configure Post Office Settings).
    2. Select "Download" tab.
    3. Set filters and click "Search" button → the uploaded Person.Register transaction has been found ('Transaction File' format: <Persons_Sender_CurrentDate_CurrentTime>):
      1. set "Transaction date"
      2. set "Person.Register" checked
      3. set "Sent only" and "New only"

Figure4.



Related content

SELECT SQL Statement
SELECT SQL Statement
More like this
Member Register V2. SelectSql
Member Register V2. SelectSql
More like this
Person Register
More like this
GDRFAD Members Validation User Guide
GDRFAD Members Validation User Guide
More like this
DoH Members Update - Table in Customer Database
DoH Members Update - Table in Customer Database
More like this
DoH Members Update - Select SQL Statement
DoH Members Update - Select SQL Statement
More like this