Supporters import

File format, values and deduplication are described in CSV Imports.

No column is required: a row with all cells empty is skipped without error.

Columns

Column	Description
supporter external ref	External reference, primary reconciliation key. Unique per organization.
donor type	Supporter type. Values: individual, company, organization, family, group.
first name	First name.
last name	Last name.
company	Company name (for companies/organizations).
date of birth	Date of birth, format YYYY-MM-DD.
place of birth	Place of birth.
title	Title (e.g. Dr., Ms.).
job	Occupation.
phone	Landline phone.
mobile	Mobile phone.
email	Email. Secondary deduplication key.
tax identification number	Tax identification number. Format validation only (alphanumeric). Secondary deduplication key.
vat	VAT number. Format validation only (alphanumeric). Secondary deduplication key.
address	Address.
city	City.
province	Province.
zip	ZIP code.
country code	Country, ISO 3166-1 alpha-2 (e.g. IT).
accepts email marketing	Email consent. Boolean value (t/f, true/false, 0/1).
accepts sms marketing	SMS consent. Boolean value.
accepts phone marketing	Phone consent. Boolean value.
accepts postal marketing	Postal consent. Boolean value.
accepts profilation marketing	Profiling consent. Boolean value.
tags	Multi-value tags (cell in quotes if it contains multiple values).
note	Free-text note.

You can add custom_<key> columns for custom fields of type supporter (see Custom fields).

Notes

• code is not importable: Riseact generates it.
• Imported marketing consents must be tracked with their source ("import N of <date>"). For privacy matters, refer to the DPO.
• A supporter matching an existing record is reused without changes.