Exporting the data from Virgin Money Giving
Donation and fundraising page information appears in Donorfy as a result of you uploading the information that you must first export from Virgin Money Giving using the Donations Report.
Why do we use export/import? It is necessary to export and import a file because Virgin Money Giving does not have an API for this information.
The Donation Report file must be saved/exported from Virgin Money Giving in CSV format and use the 'All Data Items' template.
It is important you do not open or rename the file before importing it into Donorfy. That's because the data inside the file may be corrupted (e.g. if opened in Excel) and the upload to Donorfy would not then work.
Importing the Donation Report into Donorfy
From the Integrations > Virgin Money Giving area click on the Upload tab.
Here you can upload your Virgin Money Giving file/s and also see previously uploaded files under the upload area.
Find your recently exported Donation Report and drag/drop it into the area shown below.
Once the file has been uploaded it will be checked and if all is OK then the Apply Changes button will appear against the file name.
Clicking this button means the following updates will occur:
- for donations to a new fundraising page the fundraiser constituent will be added if not matched to an existing constituent
- for donations to a new fundraising page, the page will be added
- add the donations to either the anonymous constituent or the constituent found/added - according to Settings.
- The Payment Method associated with a transaction will be set to "Virgin Money Giving"
- Donations to pages will be soft-credited to the fundraiser constituent. The Transactions will be created and attributed to the campaign, product, fund, department associated with the page.
- add the donor constituent - according to settings. Donor comms consent is updated as follows:
- if the donor ticked the box during the donation process in Virgin Money Giving then the corresponding Purpose in Donorfy will be set to Green (OK to contact)
- if the donor did not tick the box and a new constituent is being created then the Purpose will be set to Red (do not contact)
- if the donor did not tick the box and the donor is an existing constituent (we may have matched on say email and first name...) then the Purpose is left unchanged.
Donations are not imported when...
Donations are not imported when the donation date is prior to the Integration Start Date in Integrations > Virgin Money Giving >Settings tab.
If a file has been uploaded and processed in error it is possible to undo the import (therefore removing any transactions, pages, constituents that were added). The Undo button appears against the file name of imported files.