Many Pies

Many Pies

Thursday, July 31, 2008

Changing Phone Types in Raiser's Edge, part 2

Further to my post on changing Phone Types in Raiser's Edge:
I found that Table Cleanup would fail even if phone types weren't duplicated for a given address. So I ended up changing them with various global changes, or creating an import file, changing and reimporting.

Further to this:
I found that Table Cleanup would fail even if phone types weren't duplicated for a given address. So I ended up changing them with various global changes, or creating an import file, changing and reimporting.

I also had problems with queries not finding duplicates. If I looked for
Phone Type one of "Old email 1", "Old email2"

it would fail to find some duplicates. I had to add
OR Phone Type one of "Old email 2", "Old email1"

i.e. put them in a different order

1 comment:

G & G Recruitment Solutions said...

Hi Paul,

I work for G & G Recruitment Solutions. I found your blog and was very interested to read that you work with Raisers Edge. I currently have a Raisers Edge Database Manager role which i thought you could well be interested in, so please do contact me as soon as it is convenient.

Kind Regards


Mark Gibbons
Resource Manager
0844 800 4984