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.

Figure1.

2. Configure DoH Members Update tab

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':
   1. is set for UAE residents;
   2. isn't set 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