Lynn, I also don't know that we could set a 'policy' for this. As Melissa, said there are just too many exceptions with how people prefer to be contacted, changes, etc. If it will work for you, go for it. Wish you the best in doing this

Hi, I am cleaning up data existing pre-my time at the school and I see that in almost all cases the Phone – Business and Email – Business contact information has been entered on BIO1 instead of on the Business tab. The only reason I’ve been given when asking the question as to why this info resides on...

Okay... that plug-in appears to find DUPLICATE entries, but I don't actually have any duplicate entries at the moment... I have this: Email 1 Email 2 Email 3 Email 4 ... Email 20 The problem is that if I do a table cleanup and I try to replace Email 20 with Email 19 there is almost always some record...

So I'm trying to clean up our 100+ different phone types from a conversion... We're doing okay, but we keep getting snagged with that "could not be replaced because it would result in duplicate rows" error... Sometimes I can query and find the offending records, but mostly I'm stuck...

Hi Marissa, If you have the address import id number of the address onto which you are going to import the phone numbers, you could do a phone number import (Blackbaud recommends the Preferred Address as the address where emails should be stored) and if you have the constituent id or constituent import...

As this issue grows, I'm trying to figure out how we will work around this during our phone solicitations. Our pledge cards as they are right now pull phone types and #s. If Joe & Jane Doe's pledge card lists "home phone" type but if "home phone" is Jane's cell it...

Great question - seeing more and more "no land line" families. Hope you'll still receive some great suggestions. Until very recently in our area we were able tell most cell phone # from land line # by the prefix. But quickly see that changing too. Only thought I have so far is another phone...

The high school at which I is work is experiencing more families using a cell phone as their main phone number. Currently our phone types are Home, Work, Mom Cell and Dad Cell (the mom and dad cells are a carryover from a different system). Does anyone have a suggestion for coding a spouse's cell...

[quote user="Tina Gorski-Strong"] Can you share best practices for how to handle bad phone numbers? Do you delete the number or code? What do you call it, if you code it? [/quote] I just created phone type for this last month. We had been deleting occassional 'bad' numbers. I got a...

Does anyone have any suggestions for best practices on email types? Do you suggest breaking down to Email 1, Email 2, Email 3 or Home 1, Home 2, Home 3, Work 1, Work 2, Work 3? Thanks so much for your help.