View Single Post

Old 11-27-2007, 09:20 AM   #5 (permalink)
DrewAllen DrewAllen is offline
Crystal Reports Guru

DrewAllen's Avatar

Join Date: May 2006
Location: Philadelphia, PA
Posts: 1,181
Rep Power: 4 DrewAllen is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Information Edge (TIE)
- API/VBA

There are some potential drawbacks to this system, but that doesn't mean you shouldn't use it. How are you handling duplicates? The most problematic would be the situation where both systems have a record, but the import ID in RE does not match the other system's ID.

The other issue is that the Import ID is not one of the search fields on the standard RE search screen. We actually use an Alias, so that we can look up records from the search screen. We have the problem that our patients are children, so we're soliciting the parents and the parents could potentially have multiple children as patients so we need to link multiple records in our patient data to one record in RE.

Drew
__________________
J. Drew Allen
Children's Hospital of Philadelphia

Crystal Reports and SQL Server Consultant

It is better to live your destiny imperfectly than to live an imitation of somebody else's life with perfection.
Reply With Quote