By David Repka, C0-Founder MinneapolisDigiart
Hi, my name is Dave and I’m a deal junkie. I’ve made a living connecting people, opportunities and capital since the mid 1980s. My primary assets are the relationships, contacts and connections I have nurtured over my 26+ year career. My contact management system has evolved over the years to handle this growing network:
- keeping business cards in a 3-ring notebook
- then I discovered a Rolodex
- then I discovered a Windows based computer and created my own database in Excel
- In 1991 my friend, Jerry Rosen, showed me Act! for Windows (thanks, Jerry!) and I used that for 10+ years until it stopped syncing with my Treo 650 (remember those?)
- I stopped using Act! and pretended Outlook was a real contact manager… it is not!
- I switched back to the Mac platform with a MacBook Pro and pretended Entourage was a real contact manager… it is not!
- When I replaced my Treo with an iPhone I thought Mobile Me would be the answer… it was slow and creeky… time to find a real solution…
- In August 2009 I switched my e-mail host to Google (they host business accounts for $50 per address per year). Google has “contacts” built in. I use Google contacts and calendar to sync with my iPhone wirelessly through the cloud using exchange server (very easy to set up especially for a Microsoft product).
- It is a simple, elegant solution that just worked until I got a new iPhone 4S and I messed up a setting or two. Rather than staying in the Google ecosystem and got fancy and tried to get one unified database from all sources and software collected over the years. Big mistake!
- My contact database went out of control grabbing contacts through multiple platforms and devices over the last 21 years. My database had 2 to 8 duplicate records per contact and soon ballooned from about 10,000 contacts to well over 24,000.
- I did some Google research and found an application called Scrubly that promised to fix my problem
- I said a little prayer and purchased annual subscription for Scrubly.com for $25 then used this strategy:
1. Scrub my main contact database in BisonFinancial.com e-mail on Express setting using Scrubly (before the scrub the software backs up the database to their cloud which is nice)
2. Turn off Exchange Server contact sync radio button in iPhone & iPad so they are “out of the loop”
3. Export a backup of all contacts from Mac Address Book to SugarSync – Backup all contacts from Dave@BisonFinancial.com on Google Apps to SugarSync (that way I had a backup to the backup – a little anal retentive, but my contacts are the lifeblood of my business)
4. Go into Address Book on the Mac and DELETE them all (yes, delete them all)
5. Delete all contacts on iPhone – after struggling to do this in iTunes I bought app for $0.99 called DeleteQ (they are the number 15 app in Spain so how bad could that be?) that deleted all my contacts from my iPhone (it timed out a few times and needed to be restarted, but it deleted close to 12,000 contacts)
6. Do a hard reset of iPhone and iPad (just in case)
7. Reset Radio Button on iPhone and iPad to Sync with Exchange Server
8. 9,777 contacts on BisonFinancial.com – iPad – iPhone perfectly SYNCHRONIZED for the first time ever! Yes, ever! Thanks Scrubly!
Now if I could only figure out how to get all this to sync with the Apple iCloud and all the social media connections I’ve built through LinkedIn, Twitter & Facebook! But, I’ll worry about that another day.