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 (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 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

Select Person.Register tab.

Figure2.

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.3)
   3. 'Table name'. Specify the table from which you want to retrieve data (PersonRegister from Customer database, see Preconditions p.2).

3. Generate PersonRegister transaction

Output