Importacular

Error adding constituent code: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'CODE', table 'RE7.dbo.CONSTITUENT_CODES'; column does not allow nulls. INSERT fails
This error crept into into v3.0 of Importacular. Previously when a user didn't want to add a constituent code for an existing constituent then the mapp...
Thu, 9 Nov, 2017 at 10:23 AM
Before we proceed, Blackbaud requires us to ask this question of you - message always appears on hosting
We are required to ask this question the first time you enter the application. However unless you save some settings in the application it will continue to ...
Fri, 10 Nov, 2017 at 9:55 AM
How do I export Raiser's Edge configuration (if asked by Zeidman Development)
Sometimes we need to troubleshoot an issue that you have been experiencing. It would be impractical for us to take a copy of your whole database on many lev...
Mon, 27 Nov, 2017 at 8:44 PM
Working with Split Gifts
When adding a gift In Raiser's Edge a split is always added automatically. If you go to the split gift tab you will see a single split representing the...
Tue, 29 Oct, 2019 at 8:38 PM
Why is gender always being overwritten with Unknown?
In RE update to and including version 7.96 patch 6 there were only every three choices for gender; male, female and unknown. What is more a record must have...
Tue, 19 Dec, 2017 at 12:53 PM
Importing Recurring Gift or Instalment Schedules
When mapping gifts it is possible to restrict the fields shown. By default Importacular only shows the most common fields. However if you are importing gift...
Fri, 27 Jul, 2018 at 11:09 AM
Error in LookupMatchInGrid or Error in RunLookupPatternConstit- the lookup row returned without a value
This error is very general in nature and can occur for a number of reasons. In one case it may happen when the education class of field is mapped to a v...
Fri, 19 Jan, 2018 at 6:17 PM
How do the phone/email settings in RE affect Importacular mappings?
It is possible to import phones and email addresses on to constituent records so that they either create a new record or update an existing one. In this art...
Mon, 19 Feb, 2018 at 10:51 AM
Our data consists of international addresses some with state, some with province and some with county. How is this handled?
Sometimes when you capture data the form is kept concise to keep it simple. One example of this is field reuse. For example an address in the US has a state...
Tue, 24 Sep, 2019 at 2:02 PM
How do I import gifts when I only have the constituent id? - Last name is required!
Sometimes you need to import gifts or other data that you have supplied to a third party. Sensibly you supplied the constituent id so that you could easily ...
Tue, 6 Mar, 2018 at 9:44 PM