1 person thinks this is worth it.
(What is RSS?)
How I did it: Long nights of either writing programs to remove duplicates or removing duplicates by hand. Cleaning data and running it through address & phone number list clean up services. We had three databases to merge and it wasn't pretty. Best to start with one database (CiviCRM seems nice) and keep to it.
Lessons & tips: Clean your data first - first/last names switched, sync to common first names, etc. Then write a program to do as much of the merging as possible. Finally sort seven ways til sunday and remove duplicates.
Resources: www.listcleanup.comwas helpful for updating addresses and appending phone numbers. however, be sure that you sort your list so that records without address are at the bottom, then give each record its own id. Did the later, but not the former and the merge back was a pain. Also, be sure to run NCOA services at least once a year or you will miss address changes.
Officially transferred the db to Scott L. I was to send him the bad email addresses for him to remove, but I found that there are a bunch of additional changes. I have gathered them into one file and I will make the changes tonight, I hope, and send him the new file then. So I am behind on completing this task, but in sight of the end.
SaraLuWho wants to improve my financial situation
Lose 20 pounds
Kiss in the rain
Stop over thinking everything
Learn a different language
find the perfect pair of jeans
meet new people
visit a monastary
sell my truck
lose 25 pounds
watch Instant Star
paint a self portrait
Mud wrestle
lose 15 pounds
Indiesgirl wants to move to Portland
not judge others--let people live their lives as they choose
drink 4 glasses of water each day
Learn to speak Gaelic
relax
go to a Korn concert
buy a dslr
learn to walk in high heels
visit california
Buy a House
DarkDog wants to Balance
be fluent in French
Learn Japanese
