The File Uploader What is it and what does it do? The File Uploader is an inbuilt facility that allows you to import data quickly and efficiently in a standardised way. So, whether you are populating your Donorfy system for the 1st time, adding mo...

Robin Fisk

December 18, 2015 14:04

In the File Uploader Overview you will have found out the purposes it can be used for, who has access, what can be uploaded and suggested course of building your data uploads.  To help you upload data with minimal errors and as quickly as possible...

Graham Bell

December 02, 2019 14:42

Using File Upload     Once you have your data as clean as possible (remember junk in will result in either errors within the file upload, or data inconsistencies on records, which in turn can lead to reporting problems and potential problems with ...

Graham Bell

December 02, 2019 16:42

An external key is an id or key value that is already assigned to your constituents e.g. from an existing database you have. If can be useful to bring in the external key when you import constituents into Donorfy as you can then use the external ...

Ben Brett

June 26, 2015 14:56

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 data...

Graham Bell

April 01, 2022 14:48

You can update (or refresh) the data preparation template by going to Data Management | File Upload and pressing the Update Template button - this button is on the top right of the File Upload box. This will rebuild the Data Preparation Template i...

Ben Brett

October 20, 2015 15:08

These are the steps needed to import Constituents. Download the Donorfy data preparation template from Data Management | File Upload - this is an Excel workbook. Copy your constituent data into the rows in the appropriate worksheet and columns in...

Ben Brett

May 08, 2015 13:59

When you upload a file of constituents you can create connections between the new constituents in your file and existing constituents in your Donorfy this article explains how to do that. However if you want to create connections between existing ...

Ben Brett

December 06, 2017 17:26

Creating connections between constituents When you upload a file of constituents you can include information in the columns below to create a connection between existing constituents and the constituents that will be added by the file upload If yo...

Ben Brett

January 20, 2017 14:35

You can import donations (Donorfy calls them Transactions) using Donorfy’s Data Preparation Template. This template is available to download within Data Management > File Upload Prior to downloading the template ensure you refresh it by clicking o...

Graham Bell

September 26, 2016 11:42

This article explains how to update existing constituents using the File Uploader. Updating Constituents is different from Cleaning Constituent data, in that the updating of constituents is for block updating of fields, e.g. Post Code, Gender, Con...

Ben Brett

September 05, 2019 07:42

You can use the File Uploader to update Channel and Purpose permissions for existing Constituents. Below are the steps you need to follow.   Caution: Please note that this type of file upload cannot be undone. Please ensure that the data that is ...

Ben Brett

April 26, 2018 13:15

You can use the file uploader to update social media ids and website addresses for existing constituents these are the steps you need to follow. Download the Donorfy Updates Data Preparation Template from here: Constituent Update.xlsx Read the Im...

Ben Brett

June 24, 2021 07:42

You can upload (import) a file and use it to Add or remove tags from existing constituents, or Allow or block communication channels for existing constituents   Note - Updates to channels made via this importer do not get recorded in the Prefere...

Ben Brett

April 12, 2016 08:37

This article explains how to update existing transactions using the File Uploader. The transactions you want to update are identified by the transaction number. A transaction has two (or more) transaction numbers - one relating to the Payment part...

Ben Brett

August 09, 2019 09:57

You can use the file uploader to update existing activities - for example, if you want to record if someone attended an event you held. Important You cannot undo updates made by the file uploader.It is a good idea to download a list of the Activi...

Ben Brett

July 03, 2018 13:45

If your bank can provide you with a file of Standing Order payments in a format known as BACS Standard 18 - example shown below - you can match them to Recurring Payment Instructions in Donorfy as follows. If you cannot get a file in this format s...

Ben Brett

June 17, 2016 16:06

If this is the first time you have imported a CAF file you should go into Settings (see this) search for Payment Methods and add a new payment method called 'CAF' Each time you download a file from CAF you will need to open it in Excel and add the...

Ben Brett

March 23, 2016 14:31

What is a duplicate? When Donorfy detects that a constituent has very similar details to another constituent, Donorfy will flag them as possible duplicates. This means they might be the same person or organisation. Enabling or disabling the checks...

Mark Eastwood

November 08, 2019 10:05

The Duplicates process separates single matches from multiple matches so that you can merge duplicate records quickly.   The single matches display all of the results where the target constituent (right side) only has one matched constituent. Thes...

Graham Bell

December 21, 2020 11:36

Where there are many potential duplicates found for a single constituent profile, these are then added to the All Matches section.   The All Matches section displays 10 duplicate sets on a single page and will notes how many potential duplicates ...

Graham Bell

December 21, 2020 11:54

An auto merge feature in Duplicates is available to help to reduce the amount of time spent assigning items to merge. This can be switched on from Settings > Configuration > Duplicates Settings The auto merge feature will merge matches that have b...

Graham Bell

December 21, 2020 12:06

Please Note - Once deleted these Constituents cannot be restored   The Bulk Delete option under Data Management can be used to removed archived constituents from your Donorfy, you  must be an administrator to access the bulk delete option can arc...

Ben Brett

June 14, 2018 16:27

This article explains how to import cleaned data relating to constituents using the File Uploader. Cleaning Constituent is different from Updating Constituents data, in that the Updating of Constituent data is for block updating of fields, e.g. Po...

Ben Brett

December 01, 2017 13:53

On occasions, a file that is being uploaded to Donorfy may present the error message Unable to open file... File may not be a valid Excel workbook, for example:     The spreadsheet contents and name extension are all appearing to be fine, but the...

Graham Bell

July 07, 2021 09:05

If Donorfy has a problem reading a file that you have uploaded you will see message similar to the examples below  To fix this problem you should start Excel and Open the workbook you originally uploaded Remove any worksheets that you are not us...

Ben Brett

February 06, 2018 17:12

When you upload a file containing constituents Donorfy checks whether the people in the file are already in the database - if there are matches you will see a message similar to the one shown below You can download the file to review the matches ...

Ben Brett

August 24, 2017 13:33

After you upload a file Donorfy will check it - if there are problems which prevent the data in the file being imported the file will be displayed similar to the example below   To see details of errors of you need to Download your file. When you...

Ben Brett

March 11, 2016 08:28

You can undo a file upload - this will remove all the data added by the file upload.  Important if you undo a constituent import then any data you have added to the constituents since the import - e.g. transactions added to the timeline - will als...

Ben Brett

March 18, 2016 17:34