Virtuous G&C Import Write
Learn about how to integrate Fundraise Up with Virtuous using the Import Tool.
Virtuous is an all-in-one CRM platform designed to help nonprofit organizations streamline their supporter management processes. Fundraise Up offers two ways to integrate with Virtuous.
- The first option is a basic integration (simply called “Virtuous” in the Dashboard) that processes data in real time.
- The second option, which we recommend, is the advanced Virtuous G&C Import Write. This method uses Import Tool for a more flexible and comprehensive integration.
Connection guide
To connect Virtuous to Fundraise Up, follow the steps below.
Prerequisites
- Administrative access to your organization’s Virtuous account.
- Access to your organization’s Fundraise Up account as a user with the Organization Administrator role.
- If your organization was previously using basic Virtuous integration, disconnect that connection before starting. To do this, go to Settings → Integrations → Virtuous CRM → Disconnect Virtuous CRM.
Steps
- Open Virtuous CRM and create API Keys in Virtuous. Click here for instructions on how to do this.
- Log in to Fundraise Up.
- Select your user profile from the upper right area of the Dashboard.
- Select Settings.
- Select Integrations from the sidebar menu.
- Select Add Integration.
- Select Virtuous G&C Import Write.
- Select Connect Virtuous G&C Import Write.
- In the API key field, input the API key you copied from Virtuous CRM.
- Select Connect my Virtuous CRM account.
Virtuous is now connected to Fundraise Up. Review and configure the integration settings in the same Integration side tab, and then enable the automatic sync function when you are ready to sync donation information from Fundraise Up to Virtuous.
Import Tool
Compared to the basic Virtuous integration, the Virtuous G&C Import Write integration uses a different approach to send data to the CRM. To send data to Virtuous, we use the platform’s Import Tool, which allows organizations manage incoming data more effectively and minimize data duplication.
Data Processing
Data is sent to Virtuous in batches, each of which contains information about all the recurring gifts (donations), new gifts and supporters created from the moment the previous batch was sent to Virtuous. Batches are automatically created once a day at 8:00 a.m. in the organization's time zone.
Once a batch has been sent, it can then be seen in the Import Tool in Virtuous.
Importing new data
The data needs to be imported in order to appear in your Virtuous CRM. To do this, go to your Virtuous account, select “Import tool” in the left-hand menu, click on the name of the batch you need to import, complete any additional actions required, and click “Import” in the top-right corner. Until the batch is imported into the CRM, Fundraise Up will not be able to update the data for recurring gifts and gifts.
Gift and Recurring Gift updates
Pre-existing and recurring gift information is automatically and instantly updated in Virtuous. This means that your organization doesn't need to do anything to update the details of existing and recurring gifts.
Constituent Matching and Deduplication
The matching of contacts and recurring gifts is done by Virtuous when the data batch is being processed.
Recurring plans
There is a one-to-one correlation between the Recurring Plans object in Fundraise Up and the Recurring Gifts object in Virtuous. When a recurring plan is created in Fundraise Up and synced to Virtuous, a recurring gift is created in Virtuous. Similarly, recurring plan installments in Fundraise Up are synced to corresponding installments in Virtuous.
When any of the following conditions are met, a recurring gift created by Fundraise Up in Virtuous is deleted and a new one is created:
- The donation amount for the recurring plan is changed in Fundraise Up.
- The recurring plan is canceled and then reactivated in Fundraise Up.
Refunded donations
If a donation is refunded in Fundraise Up, a new gift with the Gift Type set to Reversing Transaction should be added directly to Virtuous.
Handling multiple currencies
Virtuous supports multiple currencies. This means that donations made in different currencies on Fundraise Up will be synced to Virtuous without having to be converted to Virtuous's default currency.
You can view the amount in the original currency amount and the converted amount (in your default currency) in the Virtuous Gift details. The following rules must be configured so that the Amount field displays the original currency amount and the Converted Amount field displays the converted amount in the default currency. The conversions will then be performed automatically.
| FUNDRAISE UP PROPERTY | VIRTUOUS PROPERTY |
| donation → amount | gift → amount |
| donation → currency | gift → currencyCode |
If you prefer to not support multiple currencies, you can configure the following mapping rule for the Virtuous integration in Fundraise Up.
| FUNDRAISE UP PROPERTY | VIRTUOUS PROPERTY |
| donation → converted amount ([account currency]) | gift → amount |
| account → default currency ([account currency]) | gift → currencyCode |
Configuration
These optional settings control standard integration features.
- Syncing test data: When using test mode to experiment with platform settings, you can opt to send test transactions to Virtuous. This enables you to configure and refine mapping rules so that values from Fundraise Up are synced to the expected properties in Virtuous. By default, the Sync test data option is disabled when you enable an integration, but it can be enabled from the integration’s settings.
- Sync subaccounts: When the Subaccounts feature is enabled, you can opt to sync data from a primary account’s subaccounts to apps connected at the primary account level. This is useful for tracking donations and simplifying reporting when your organization uses a chapter-based or federated model.
- Track payments (in Virtuous CRM): When this setting is enabled, Virtuous generates a schedule of expected future payments for recurring gifts in Virtuous, which is useful for tracking outstanding balances or identifying late or missed payments.
- Gifts are tax deductible – mark donations as tax deductible.
- Default segment – The default gift segment (optional setting).
- Default comment – The default comment for the gift.
- Default project – The default gift project (mandatory setting).
- Supporter phone type – select a default type for contact phone numbers.
Mapping rules
Use mapping rules to define the destination objects and properties of data values synced from the platform. Support for mapping rules is based on the flexibility of Virtuous’ API.
Mapping rules are configured by linking a Fundraise Up object and property to an object and property in Virtuous. A value sent from Fundraise Up will be written to a property in your Virtuous account. By default, Fundraise Up defines some rules for you to reduce the implementation steps you need to take. These rules can be removed or modified as needed.
Mapping rules examples:
- Linking the designation property from Fundraise Up to the project code property on the Contact object in Virtuous.
FUNDRAISE UP VIRTUOUS Object: Designation Object: Project Property: Designation code Property: code
Special rules
The Virtuous integration can be configured to use special rules. These types of rules use if/then conditions that enable you to link a property’s value in Fundraise Up to a property’s value in Virtuous.
Special rule examples:
- If Campaign equals “Shelter” in Fundraise Up, then set the project in Virtuous to “Shelter.”
- If Designation equals “Areas of Greatest Need” in Fundraise Up, then set the segment in Virtuous to “General Giving Audience.”
Non-configurable mappings
In some cases, Fundraise Up sets mapping values that cannot be adjusted from the integration settings page. These mappings are described below.
Contacts → Household information
| VIRTUOUS PROPERTY | FUNDRAISE UP MAPPING BEHAVIOR |
| Contact Type | By default, sets the value to Household |
| Name | Inserts a concatenated form of the first and last name values from Fundraise Up |
| On Behalf Of | If the Donate as organization option is used, the value from Fundraise Up is written to the Name field in Virtuous and the Contact Type is set to Organization |
| Informal Name | Inserts the supporter’s first name |
| Primary Phone (Home Phone) | Inserts the supporter’s phone number (if provided) |
| Primary Email (Home Email) | Inserts the supporter’s email address |
| Address Line 1 | Inserts the first line from the supporter’s address (if provided) |
| Address Line 2 | Inserts the second line from the supporter’s address (if provided) |
| City | Inserts the city from the supporter’s address (if provided) |
| State/Province/Region | Inserts the state, province, or region values from supporter’s address (if provided) |
| Postal Code | Inserts the postal code from supporter’s address (if provided) |
| Country | Inserts the country from a supporter’s address (if provided) |
Gift → Gift details
| VIRTUOUS PROPERTY | FUNDRAISE UP MAPPING BEHAVIOR |
| Gift Type | If a card payment method is used, the value is set to Credit. For bank-based methods, the value is set to Electronic Funds Transfer. For all other payment methods, the value is set to Other. |
| Transaction ID | Inputs the donation ID |
| Amount | Inputs the donation amount |
| Gift date | Inserts the donation date |
| Receipt date | Write the value of the internal property, receiptSentAt |
| Private | Writes the Boolean value of the Anonymous donation property. If the anonymous donation option is not used in Checkout, the value is false |
Recurring Gift → Recurring Gift details
| VIRTUOUS PROPERTY | FUNDRAISE UP MAPPING BEHAVIOR |
| Amount | Inserts the donation amount |
| Frequency | Sets the recurring plan frequency if the value is Weekly, Bimonthly, Monthly, Quarterly, Semiannual, or Annual. If the value is Daily, Biweekly or Every 4 weeks, the record is synced as a one-time donation. |
| Start Date | Inserts the success date of the donation |
| Next Payment Date | Inserts the Next Donation Date value |
| Private | Writes the Boolean value of the Anonymous donation property. If the anonymous donation option is not used in Checkout, the value is false |
Sync settings
Fundraise Up’s Virtuous integrations include settings for managing the sync behavior for records.
- Automatic sync: By default, the automatic sync option is disabled when you connect Fundraise Up to Virtuous. This allows you to fully configure the integration’s settings and mapping rules before any records are synced.
Once you are satisfied with your configuration for the integration, we recommend enabling the automatic sync feature.
Even if you opt for the Automatic sync option, you will still need to import data from within your Virtuous Import Tool, as described above, in order to complete the transfer of data. - Manual sync: This option is useful if you prefer to not use the automatic sync function, or if you want to re-sync previous records. In order for a manual sync to be completed successfully, you must manually import the batches of data into Virtuous from your Virtuous account once you’ve clicked Manual sync on this page.
Scenarios:
- Resyncing previous records: When you make changes to record properties for past donations in Fundraise Up, you can use the manual sync option to update the associated records in Virtuous. This is beneficial for scenarios where an incorrect mapping was made in Fundraise Up.
- Sync period: When you manually sync records, you can opt to sync all records or specify date range. Narrowing the sync scope using a date range is useful when you need to target a specific set of records or want to avoid resyncing a significant number of records.
- Disconnect Virtuous: You can disconnect Virtuous at any time from its settings page. Disconnecting and then reconnecting Virtuous using the same credentials will preserve the settings and mapping rules set before Virtuous was disconnected from Fundraise Up.