When you create a custom recipient group, you can import the e-mail addresses from a file. When you click on the button
, you can download an example of the file format which is accepted by the
importer. This template is also attached here below. The file must be an Excel
sheet in (XLSX) format.
The importer will load and check the file when you drag it into the upload area or you chose the file by clicking into the
upload are.
When you push the button , the uploaded data is processed and stored.
Following rules apply for the file rows:
- First line of the file (header line) is always skipped
- If the e-mail address already exits in the list, the record is skipped and not processed. This avoids duplicates.
-
If the RI_ID is set in the first column, the corresponding member must
exist in Polaris. His his Polaris data will be
taken and the data provided in
the file is ignored
- If the RI-ID number
already exits in the list, the record is skipped and not processed.
This avoids duplicates.
- If the
language code is not set, the default club language is taken.
Practical hints:
If you want to import non-Rotarians or people not in Polaris, use file with the columns: firstname, lastname, salutation, language and mail and let the
RI-ID empty. See the template file below.
If you want to import Rotarians existing in Polaris, set only the column
RI-ID and let all other columns empty. The member data will be automatically taken from Polaris.
See the template file below.