When transactions are imported from Abila Fundraising Online the following message is returned:
Insert Error
The INSERT statement conflicted with the FOREIGNKEY constraint “fk_gift_import_id”. The conflict occurred in the database “your database name”, table “dbo.import”, column “import_id”
Reference 23000
Creation of new Import Definition or Update to existing one does not retain mappings to the following fields on gift card after the definition is saved: Match Company, Match Amount, Credit Another, Date 1, Table 1, Table 2, Description1, Description 2, and Batch
The definition appears to be fine if you access the definition within the same login session; but if you exit FR50 and log back in, the definition does not retain the mappings to those fields.
1099 adjustments do not import for Vendors with SSN on file. Produces an error that the Tax Identification Number is invalid for Federal Tax ID Type.
Beginning in version 2019.1.1 the message displayed may also read as 'An error occurred while translating the data for Missing Field Label 0. Type Mismatch Error: the data being translated could not be coerced into a Integer.
When attempting to import transactions from Fundraising Online into Fundraising 50 the message ‘Insufficient duplicate check data available to import this record is returned’. The message is displayed when the View Errors button is selected.
Navigator>Abila Fundraising Online>Import does not display all available transactions to import because an error appears in the Online_History table which is not being displayed on the screen indicating that the Account Key needs to be updated from Fundraising Online.
A Donor’s second ongoing* or installment** transaction from Fundraising Online imports as a gift rather than a Recurring Gift or Pledge Payment transaction type.
The first import of an *Ongoing transaction from AFO imports into FR50 as a Recurring Gift Plan & it’s first Recurring Gift
The first import of an **Installment transaction from AFO imports into FR50 as the Pledge & its first Pledge Payment.
Auto-Membership default does not function for Data Entry or Abila Fundraising Online process. Auto-Membership default works as expected in the generic Import Wizard and for Quick Gift
When importing a multi-registration form into Fundraising 50, multiple Gift cards are created. If the Import is setup so that Credit Card Name and Credit Card Address are mapped to Basic then one single constituent record is imported but there are multiple Gift cards created. If the Form First Name, Form Last Name, Form Address fields are mapped to Basic, each registrant is imported with their own constituent record and a Gift is imported to each constituent.
When Fundraising 50 is importing Multiple Registration forms containing multiple form responses blank bows are displayed on the View File tab. When the import is validated the blank rows are returned as errors
On the Donor Statement Report, Total Outstanding Balance as of…totals all open Pledges in a Donors record when one of the Pledges in the Gift Date range does not have a Pledge Schedule