I recently discovered that the person who had this position prior to me didn't enter our new University Graduates into Raiser's Edge. This needs to be done and I'm trying to do it, but it hasn't been easy. I have spent hours working on Imports and have called Customer Support twice and read everything there is to read about it, but still, I'm having problems.
I'm guessing there's someone out there who is a master at Imports, and if so, I'd love some help! No matter what I do, no matter how I change my Import file, I get 'Exceptions' when I Validate my Import. The latest 'exception' for each one of my records is 'Phone Number - Record Does Not Exist'. But yet I have a phone number listed for almost all of the Graduates!
If anyone out there can help me, please let me know!
Thank you!
Linda Richards: I recently discovered that the person who had this position prior to me didn't enter our new University Graduates into Raiser's Edge. This needs to be done and I'm trying to do it, but it hasn't been easy. I have spent hours working on Imports and have called Customer Support twice and read everything there is to read about it, but still, I'm having problems. I'm guessing there's someone out there who is a master at Imports, and if so, I'd love some help! No matter what I do, no matter how I change my Import file, I get 'Exceptions' when I Validate my Import. The latest 'exception' for each one of my records is 'Phone Number - Record Does Not Exist'. But yet I have a phone number listed for almost all of the Graduates! If anyone out there can help me, please let me know! Thank you!
You should have these fields in your file. I hope this helps.
This is actually a known issue with validation and it can't add a subrecord to a record without the record existing first. If you are trying to import the constituent as a new record and get this message sometimes it means nothing. When this happens it is sometimes better to take a sample of 2 or 3 of your records and try importing them (without validating) and see if they import right without exceptions. If they do then you should feel okay to import the rest.
AS ALWAYS, create a backup immediately prior to importing in case things go wrong and create the exception file so you can import those that did not go in as a separate batch.
Below is the KB solution that explains this better than I did.
Note: Before you proceed with the following instructions, we recommend you back up the database.
Review the exceptions to determine if they are caused by the record not yet existing. If so, import the file.
For import instructions, refer to the following solution. Each contain a sample data file.