Project

General

Profile

Exporting DonorPerfect Online for CiviCRM » History » Version 3

Jon Goldberg, 10/04/2017 01:03 PM

1 1 Jon Goldberg
# Exporting DonorPerfect Online for CiviCRM
2
3
{{>toc}}
4
5
## Terminology
6
7
Here is some DPO terminology converted to Civi terminology:
8
**Gifts:** Contributions
9
**Links:** Relationships
10
**Contacts:** Activities
11
**Donor ID:** Contact ID
12
13
## Exporting Contact Data
14
15
Data on the "Main" and "Bio" tabs can be exported to CSV by going to DPO's **Reports » Easy Report Builder**.  [Full instructions](https://support.neoncrm.com/hc/en-us/articles/218530457-Exporting-Data-from-DonorPerfect) are available on the NeonCRM site.  You can also export Gifts, Contacts (Activities) and additional addresses from here.
16
17
Note that for option value (multiple choice/dropdown) fields, you can export the "Code" and/or "Description", which in CiviCRM correspond to the "Value" and "Label" of the option value.
18
19
## Exporting Links (Relationships)
20
21
There is a pre-built report to do this - but it exports data in terrible shape.
22
* Go to DPO's **Reports menu » Report Center**.
23
* Click **Listings** in the left pane.
24
* Select **Open** next to the *Relationship/Links List*.
25
26
This report only exports to "Excel" - while it opens in Excel, it's actually an HTML table.  It also contains data in a very difficult format to work in.  See the Megaphone Tech [Kettle Github repo](https://github.com/MegaphoneJon/civicrm_kettle_transforms/tree/master/donorperfect) for a transform that will convert these to a Civi-ready format.
27 2 Jon Goldberg
28
## Exporting Tributes (In Honor/In Memory/On Behalf Of)
29
30 3 Jon Goldberg
Tributes are different from their equivalent (soft credits) in Civi.  Whereas in Civi, a soft credit is always to a person (e.g. "In Honor Of Jane Doe") in DPO, they're a separate entity ("Jane Doe's 70th Birthday") so you can't easily map them to Civi.  You could try matching the names against donor records.  You can export the Tribute list from DPO's **Reports menu » Report Center, Financial Reports tab** and click **Tribute Gift Listing**.
31
32
## Exporting Option Values
33
34
To download a list of all the option values for select boxes etc. in DonorPerfect, go to the settings (gear) menu and select "Code Maintenance"
35
![]()