Upgrades to RPIs
There purpose of this type of import is to increase the amount people are paying under their RPI - e.g. following a campaign to ask people to give more.
The RPIs (and by implication the constituents) must already exist in the database.
Open the data preparation template and remove all the worksheets except the one called 'RPI Upgrade' - the available columns are:
RPI Number - this is the number of the existing RPI in Donorfy that you want to upgrade - this must be entered
Campaign - the name of the campaign associated with the upgrade - this must be entered
Amount - the extra or upgrade amount that will be paid following the upgrade each time a payment is collected - e.g. if the payment frequency is Month then this would be a monthly amount.
Note that the existing amount(s) on the RPI will still be collected so if someone was giving £10 per month and they upgraded to give an additional £5 the amount column would contain £5 - giving a total for the RPI of £15Start Date - the date payments are expected to begin
End Date - the date payments are expected to end - enter 31/12/2099 if the upgrade does not have an end date
Reference
Channel
Product
Department
Fund
PotentialGiftAid - enter Yes if donations under this instruction can potentially have tax reclaimed under gift aid
Comments - text that can be stored for the RPI
Beneficiary ConstituentNumber, External Key or Email - if provided this information will be used to find an existing constituent who is the beneficiary of the RPI