I have a question in regards to prospects and the Constituent Import.
Are you currently using this function in Tessitura? If so what has your experience been with it? My concern is that there is no way to back out this import if there is an error takes place. Eventhough there is a validation report.
Here in the Sydney UCSS consortium, we have a custom version (based on the canned version) that will import data into the LT_TKT_HIS table - it also deduplicates on the way in.
We have a very clearly defined set of data entry standards that all consortium members have agreed to adhere to. As the person who does the importing here at the ACO, I spend a reasonable amount of time ensuring that the data to be imported also adheres to these guidelines so that the data to be imported will properly be deduplicated with the data already in the database. I cannot stress how important and useful this is!
Martin