I am currently working on a project where I need to copy a gift record from one constituent to another. There are 213 fields on the regular gift object i.e. CGift. That is without looking at any of the other areas of the gift such as attributes, notepads, etc. It would take a lot of typeing to copy between each field so to do this I use the meta data that is supplied with each object. Read the rest of this entry »

I have been working on a new product which will hopefully be released soon. In this new product the user needs to be able to look up a constituent in as few key strokes as possible. The approach that I took was to use the same functionality as the Quick Find mechanism that you see on the records page in The Raiser’s Edge. This is dependant on your user settings so that you can either put in a constituent id, the first name followed by the surname or the surname comma the first name. While I was testing it on the sample database it worked perfectly. However when I tested it on a client’s very large database there were issues. Read the rest of this entry »

Whenever I write a bespoke customisation for a client that needs to look up a constituent based on some biographical information I normally use the functionality available behind the scenes in IDLookup. If you are unfamiliar with IDLookup, it allows users to feed in an Excel or CSV file of names, addresses, aliases, attributes and all sorts of biographical information. Then based on criteria that you define, it will look to see if one or more constituents already exist in The Raiser’s Edge. I use much of the look-up functionality in other projects simply because Blackbaud chose not to make this functionality easily available. There is no back-end interface to their regular constituent look-up screen which is a real shame. The nearest feature is the IBBRecordFinder interface.

Read the rest of this entry »

Sorry to get your hopes up but I am reliably informed that you cannot do this. And the reason? “PCI Compliance”. Read the rest of this entry »

Most of the Raiser’s Edge users that I speak to complain that Blackbaud only offers CSV and tab delimited files as a way of importing data. They say that this is very limiting, that CSV can be unwieldy to work with outside of The Raiser’s Edge. They are also very pleased to hear that any customisation that I write allows them to import from Excel and also writes reports to Excel too. Excel offers so much functionality to prepare your data. However there are problems working with the Excel object model from within the API Read the rest of this entry »

After dispelling the myth that you do not need to buy the Blackbaud API module for The Raiser’s Edge in order to work with customisations (you can run a plug-in), I usually get asked well what are the disadvantages of using a plug-in? I normally say that one of problems with a plug-in is that somebody has to press the “start” button. I recently found a solution to this. Read the rest of this entry »

I wrote some code for a client a while back and tested it thoroughly and everything worked fine. There was somewhat of a delay before the client was due to implement it and when they ran the application it crashed at the beginning. After some investigation we worked out what was going on. The code gathered together a collection of constituents that had two constituent codes. Only now one of them was no longer in The Raiser’s Edge. Read the rest of this entry »

A lot of the work that I do involves the integration of third party products with The Raiser’s Edge. It is not always right to develop a custom application to perform this integration. There are many factors including the volume of data transfer, the complexity of data, how quickly the data needs to be integrated and of course what budget is available. This article attempts to outline the options available to Raiser’s Edge managers who need to integrate with non-Blackbaud products.

Read the rest of this entry »

There was a question recently on Blackbus asking how to open a link from a constituent record. For example if you had an external system that uses constituent ids to find individuals it would be very useful to be able to open a web page from the constituent window by pressing the macro button and going to the web page that is specific for the constituent. This requires the VBA module. Here is how it is done:

Read the rest of this entry »

The title is somewhat dramatic and probably not relevant to many people however for me and a client that I work with it proved to be a disaster. This is not the first time that Blackbaud has changed the API and it certainly won’t be the last but this was annoying. So what am I referring to?

Read the rest of this entry »