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:
- 'Generate and upload Person.Register transactions to Shafafiya': should be checked.
- 'Processing interval' drop-down fills automatically with custom values. User can select an interval from the list, '30 minutes' for example.
- 'Choose where Greenrain Automation will get person register data from':
- 'DatabaseTable' value should be selected from drop-down list.
- '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.).
- 'Table name'. Specify the table from which you want to retrieve data (PersonRegister from Customer database, see Preconditions p.2).
- Click "Save" button.
3. Configure E-Mail Notifications tab
Figure3.
Users can be notified about the success or failure of transactions that are generated. If you'd like to get notifications select E-Mail Notifications tab and configure settings:
- 'Send e-mail notifications': should be checked.
- 'Use Greenrain SMTP server': should be checked.
- 'Failure notification addresses (comma separated)': here you can define the recipient email address(es) for where you want to receive an emailed notification about PersonRegister transaction generation from Greenrain Automation. If you wish to test the email notifications click the "Send test e-mail" link.
- Click "Save" button.
4. Configure Database tab
Figure4.
Select Person.Register tab and configure settings:
- 'Greenrain Automation database connection':
- 'Connection string to the database'. Click "Configure Database Connection..." button and set Database = Name of the Greenrain Automation database (see Preconditions p.1). Click "OK" button (if you wish to test the connection string click the "Test Connection String" button.).
- 'Your claims database connection': see p.1.
- Click "Save" button.
5. Configure Post Office Settings
Figure5.
Select Post Office Settings tab and configure settings:
6. Generate PersonRegister transaction