View Single Post

Old 11-27-2007, 08:29 AM   #4 (permalink)
mjohnson mjohnson is offline
Junior Member

Join Date: Mar 2007
Location: Boston, MA
Posts: 20
Rep Power: 0 mjohnson is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Financial Edge (FE)
- Blackbaud Analytics/Researcher's Edge (BBA/TRE)

[quote=Elaine Tucker;14739]Matt, What do you mean by "we would not be able to import a manually created record ID..."?


Hi Elaine,

Our outside system will be creating and eventually importing new users into Raisers Edge. We need some value to link the records together across the two systems.

We can create an import ID for the new record in the new system for import into RE but we can not create a new record ID to import into RE. As David stated above, RE does not allow an imported record ID since RE creates it automatically on Import. Once RE creates the new record ID, there is no easy way to get it back to the outside system to link the records / systems together.

The import ID is the value that unique to the record and is available in both systems since we created it manually in one and imported it into the other (RE). As David states, thankfully, it will not change. Thus we can use it as a primary / foreign key for the record across both systems.

Does this answer your question?

Thanks,

Matt
Reply With Quote