01-02-2013 10:06 AM - edited 01-02-2013 10:12 AM
Hope everyone had a great New Years.
The Thursday before New Years we were importing 225,000 contacts from one ACT database to another ACT database, everything was going well before the computer went to sleep 10 hours into it (it imported about 140,000 contacts). Since coming back from our little break here we are trying to complete that same task but we are experiencing some slight issues.
One database has 225,000 contacts, the other has 3,100. We have the ACT duplicate checker on and it is matching based on DUNS Number. Everything is set up the same way but it keeps stopping the import after 6,000-10,000 contacts (changes every time) and says that the import has been completed. We are doing it this way so that the data from the 225,000 "wins" and overrides the data in the 3,100.
We've ran the database maintenance on both databases and still no results. Thoughts?
01-02-2013 10:24 AM
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.
01-03-2013 04:40 PM
ACT, unfortunately, can't really handle large imports. In the past I had a 90k contacts to import and broke them into batches of 10k. Each 10k batch took 45-60 minutes.
My tool of choice is Oakmerge. It's much more effecient and Alan Lee and the staff are very helpful and quick to respond to whatever questions you have. Here's the website: http://www.oakmerge.com/