Avatar of PAMurillo
Flag for United States of America asked on

Export/Import ACT database

I have a client that has 2 ACT databases.  The first database (lets call LEADS) has a bunch of potential prospects.  The second database called CONTACTS has all their current customers.

When they try to export several contacts in the LEADS to the CONTACTS database, the contact may export/import but the History/Activities/Notes do not.

I have already run through each of the Database Rebuild options in the ACTdiag for both databases but no luck.  Any suggestions?

>This is on ACT Premium 2010
>Both databases have over 10k contacts
ACTOffice Productivity

Avatar of undefined
Last Comment
Mike Lazarus

8/22/2022 - Mon
Mike Lazarus

Do the same users exist in both databases?

Sometimes the contact is already have a contact in the CONTACTS database, but most of the time no.  They like to have their call list (purchased/internally developed whatever) in the LEADS database.  When they become a customer then the contact is exported/imported in to the CONTACTS  database.

Let me provide more detail in the process:
As the sales rep is tracking the lead in the LEADS database they are generating Activity and History for those contacts.

The Admin will then take a batch of contacts in the LEADS database that have been converted into clients isolate them, then export/import them into the CONTACTS database.  When this process completes (if it completes because many times it just starts and just hangs) the contacts may transfer and if they transfer the History/Activities do not.

If you do the same process with a single contact the process works  successfully including History/Activities.
Mike Lazarus

I actually seem to have heard of an issue that Sage only recently acknowledged with this

Can you see if your method is like this one reported: http://lnkd.in/ksacPh
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck

Yes. That sounds familiar except for the version of ACT that my client is using is Act Premium 2010
Mike Lazarus

I think the issue goes back to 2010 ... if it's the same, it's unlikely to be addressed unless they update to 2012 where Sage has said (as per last post in that thread) that they'll be releasing Hotfix 4 soon for it.

I have heard that creating a new database and moving all the contacts to it may solve the issue, but that just sounds like a pain in the ass.  In addition they have a few plug-ins that would have to be reconfigured.

If you have any other suggestions, please let me know
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Mike Lazarus

The problem is that it's inconsistent ...

The best bet, if it's an option, would be to wait till HF4 is released for ACT! 2012 ... then check that thread to see if the issue is resolved and then update.

Of course, this assumes that you have the same USER records in both (user, not contact)

Ill keep an eye open.  The administrators for both databases are the same.
Mike Lazarus

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question