Table of Contents

Preconditions

1. Create excel file

Create excel file in the following fomat: ExcelFileFormat in the configured directory (see 'Select folder where to expect Excel files' setting).

Configuration

The following settings are required to be made for DoH Members Update via 'Excel':

1. Go to Greenrain Automation Settings

...

Select "DoH Members Update" tab and configure settings:

1. 'Upload member details with data from DoH Personal Profile Service': should be checked.
2. 'Flag 'Is Resident' is mandatory': set the flag to specify for UAE/non UAE resident the date will be received from DoH Personal Profile service.
3. 'Person Profile data expiry interval": set '30' for example.
4. 'Choose where Greenrain Automation will get data from':
   1. 'Excel' value should be selected from drop-down list.
   2. 'Select folder where to expect Excel files'. Specify the directory from which you want to retrieve data (excel file, see Preconditions p.1).
5. Click "Save" button.

3. Check common configuration

DoH Members Update

1. Run the service

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

2. Check DoH Members Update

1. GA calls DoH Personal Profile Web Service and receives data:
   1. PersonUnifiedNumber (DoH)
   2. PersonEmiratesIDNumber (DoH)
   3. PersonBirthDate (DoH)
   4. PersonPassportNumber (DoH)
   5. PersonFirstNameEn (DoH)
   6. PersonMiddleNameEn (DoH)
   7. PersonLastNameEn (DoH)
   8. PersonFirstNameAr (DoH)
   9. PersonMiddleNameAr (DoH)
   10. PersonLastNameAr (DoH)
   11. PersonNationalityCode (DoH)
   12. PersonCityCode (DoH)
2. Check e-mail notification. "[GA, SUCCESSFUL] Successful DoH Members Update on <datatime>" is recieved with "DohMembersUpdate. DoH Updates Report". The data returned by DoH Personal Profile Web Service are marked with (DoH) prefix.
3. Check GA database. New record will be created in GA:DohMembers table (if absent for this member) with the returned data by DoH Personal Profile Web Service.