Preconditions

1. Create excel file

Create excel file in the following fomat: ExcelFileFormat.

Configuration

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

1. Go to Greenrain Automation Settings

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

Image Added

Figure1.

2. Configure DoH Members Update tab

Image Added

Figure2.

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': should be checked for UAE residents and unchecked for non UAE residents.
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