This screencast of IDLookup shows you how perform a lookup based on data coming in from an online donation page. The data is downloaded from the website without constituent ids. We run IDLookup and find several matches. We are now able to import the data into The Raiser’s Edge with existing constituent information being updated and new constituents being created.
For more information about IDLookup or to download a fully working version (tied to the sample database) visit the IDLookup download page.
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:
This is less of a coding issue and more of a Raiser’s Edge in general issue. I had known that when you make a change to an address on a constituent both the address’ and the constituent’s last changed date would be updated. This is understandable as you cannot save the address without saving the constituent. Continue reading Inconsistent Last Changed Date Behaviour→
What better way of starting the new year than taking a look at the next generation of Blackbaud’s products that are based on their Infinity platform. A couple of products have already been released but unlike many other products released into the IT wild Blackbaud has chosen, wisely in my opinion, to make the release a quiet affair and not a must have upgrade. I have managed to take a look at Blackbaud CRM. This product is aimed at the larger fundraising organisation and its flexibility certain shows this.
A few days shy of the end of the year, I hearby present to you the top visited plugins of 2008 (unless of course there is a sudden rush on any of them before midnight in which case the list will be adjusted accordingly). This list is based on the top number of clicks through to the more information about each plug-in supplied by each plug-in author.
Blackbaud NetCommunity Integration
Bank Checker Solution
Clear Invalid Spouse IDs
Constituent Document Linker
Code Insert Custom Part
Convio DataSync Connector RE
Action Reminder Updater
Thank you to all that have added to the directory during the year and to those that have rated the plug-ins.
When I first started out working with Raisers Edge API I realised that I was reusing many routines over and over and that would it not be better to create my own tools class so that I would not reinvent the wheel. Over the years I have added items to this class that I have found useful and have developed older items in order to do more things. In this post I will share with you some of the items that I find invaluable. Continue reading Your own API Tools Class→
There was a post on Blackbus recently where a Raiser’s Edge user was having trouble mapping the output of a third party system to RE. The other system had the constituent system id and did not have the import id or the constituent ids so importing the data directly into RE was proving to be a problem. It would also be difficult to do any kind of lookup natively in RE unless it was done manually through a query.
I suggested that this was a straight forward solution if you were to write a plugin. In fact I felt that it was so straight forward that I would just write it. So here it is a new plugin that takes a system constituent id and outputs the constituent and import ids appending them to a copy of the input file.
I have on several occasions expressed my delight about the arrival of the Batch API. I am still enthusiastic but somewhat war weary having spent this passed week trying to solve problems that have appeared. Clearly the Batch API was not rigorously tested before it was released as otherwise the sort of errors I am getting would not have appeared. In case you have been struggling too or in case you thinking about using this functionality here is what I have been up against. Continue reading Battling on with the Batch API→
One issue I had when I first started was how do I remove a child object from a collection. For example if I want to remove one constituent code from a constituent I need to loop through them, find the one I want to remove and remove it. My fear though was that if I simply remove it whilst looping won’t I mess up the collection? This can happen in some classes.