You can copy your reporting data from GiveSmart Fundraise to GiveSmart Donor CRM with a few simple clicks.
Exporting Donor Data from GiveSmart Fundraise
The first step is to gather your data from GiveSmart Fundraise. This is similar to any other Search Transactions report you may run. This article provides a streamlined process. For full information on running a Search Transactions report, click here.
Generate Report
- Go to Reporting > Existing Reporting > Search Transactions
- Build the report you wish to export. For more information on the options in the Report Builder, click here.
Currently, set it to only search for Settled transactions, no Pending/Refunded/Voided transactions.
Pay particular attention to the Date Information. You do not want to enter transactions that have already been imported into GiveSmart Donor CRM to avoid the risk of overwriting an update you made manually since the previous import. You can save your report (described below) to assist with this for multiple exports.
It is recommended to set the end date at least 3-4 days previous (so not a report of the same day or the day before), in case there are any issues with a transaction being cleared with the processor.
Note: it will only view the actual donations, not the matched donations.
Be aware, that you can import offline and non-payment supporter information, but it could exceed your Licensed Limit in your Donor CRM account, so watch what you actually are planning to import.
- Click Search when ready.
Review and Export
If you do not have the Donor CRM Export button, contact Support to make sure you have both GiveSmart Fundraise and GiveSmart Donor CRM so it can be enabled.
- Make sure your search criteria at the top of the generated report page have the correct information, especially the date range.
- Click the Donor CRM Export button in the upper right.
The Donor CRM Export provides all the needed columns of information that will go into GiveSmart Donor CRM, so you do not have to manage the columns shown on the lower half of the page. Essentially, this is all you need, but we recommend saving the report for use later.
Save Report and Working with the Save
You have now exported the data and can start the import process for GiveSmart Donor CRM. But, it is very likely that you will have new donors, new supporters that you will want to import at a later time. To make this process easier, and to avoid potential duplicate entries, save your GiveSmart Fundraise report.
- Click the Save Report button and give your report a memorable name, like Donor CRM Export or whatever you prefer
.png)
- Click Save Report
Accessing the Saved Report
Now when you are ready to run the report again, you can:
- Go to Reporting > Existing Reporting > Search Transactions
- This time, click on the Saved Reports tab
- Click on the name of the report you wish to run (such as Donor CRM Export)
- All your previous search criteria will show and be used to run the report
- Click on Edit Search
- Change the Date Information
- Scroll down and click Search
- Export your new Donor CRM data with the Donor CRM Export button
You will likely want to save this "new" report so you have a nice record of the last time you ran it, so the next time you know when to start the next report. Saved Reports do not save changes you make when you run them, so you would need to create a new Saved Report.
Export Files
The Exported files will be two CSV (comma separated value) files in a zip. It is listed as "donorcrm_export_####_[date of export].zip"
For example, donorcrm_export_2051_20220912.zip
You will need to unzip the file to have direct access to each of the CSV files for import.
In the Zip, the two CSVs will be:
- donors__####_[date of export].csv This includes the Donor CRM Fields for the donor information:
- DONOR_ID: A unique database ID to differentiate between each donor.
- FIRST_NAME: First Name
- LAST_NAME: Last Name
- CREATED_AT: The date this donor first was added to the GiveSmart Fundraise system
- CONTACT_METHODS_DICT.CELL_PHONE: Phone number
- CONTACT_METHODS_DICT.EMAIL: Email
- ADDRESSES.0.ADDRESS1: Street Address
- ADDRESSES.0.CITY: City
- ADDRESSES.0.STATE_PROVINCE: State
- ADDRESSES.0.POSTAL_CODE: Zip Code
- txns__####_[date of export].csv This includes the Donor CRM Fields for the donation information:
- TRANSACTION_ID: A unique database ID of the transaction / donation
- DONOR_ID: The same Donor ID in the donor list's CSV
- GIFT_DATE: The date of the transaction/donation
- TY_DATE: The date the donor was (automatically from Fundraise) thanked for their donation
- THANK_YOU_METHOD: Since this is pulling the automated thank you email, it should just say email
- GIFT_AMOUNT: Donation amount
- SOLICIT_NAME: A database ID that corresponds to the specific activity the donation came from
- SUB_SOLICIT_NAME: The type of transaction, such as donations or a ticket sale
- GL_NAME: This is a required field for Donor CRM, and should just say UNRESTRICTED
- CAMPAIGN_NAME: This is the friendly name of the campaign within the organization's account
- CAMPAIGN_ID: A unique database ID for the campaign
Importing the Data into Donor CRM
Now that you have the export from your GiveSmart Fundraise account, go into your GiveSmart Donor CRM account to import the data.
Remember to unzip the files from the GiveSmart Fundraise download!
You need to import the contacts first and then the gifts/transactions next. The contact ID from the contacts file is needed so the transaction can be attributed to that contact.
- Click on Launchpad on the left
Import Contacts
- To import contacts, click on Select File in the Import Contacts box
- Select the CSV file from your hard drive wherever you saved/downloaded it. For the Contacts import, you want to choose the donors__####_[date of export].csv
- You will see the progress bar and then a Done message (if you're paying attention!) and then the Import Contacts will revert to normal, so you could enter another csv or import the gifts/transactions.
- You will also receive an email letting you know when the import is complete.
- You can check to see the new contacts in your Donors & Contact section.
Import Gifts
- To import gifts (transactions), click on Select File in the Import Gifts box
- Select the file from your hard drive wherever it saved. For the Contacts import, you want to choose the txns__####_[date of export].csv
- You will see the progress bar and then a Done message (if you're paying attention!) and then the Import Gifts will revert to normal, so you could enter another csv or import contacts.
- You will also receive an email letting you know when the import is complete.
- You can check to see the newly imported gifts in your Gifts > Gift listing section.
