Community
Showing results for 
Search instead for 
Do you mean 
Reply

Importing ACT DB into a new DB

Avid Listener
Posts: 52
Country: United States

Importing ACT DB into a new DB

We are having some issues with an ACT! db not being able to import any lists, no matter the format (csv or xls). There are some other database errors also. 

 

I created a new, blank database and imported the troubled db into it. It lost many fields, Calendar items, custom groups, and none of the opportunities are lined to the company anymore.

 

Is there a proper way to do the import to capture an exact copy of the old database?

Nickel Elite Contributor
Posts: 934
Country: USA

Re: Importing ACT DB into a new DB

Reference KB article

Best Practices for Import and Exporting Data from One ACT! Database to Another ACT! Database

http://kb.swiftpage.com/app/answers/detail/a_id/17539/kw/exporting%20database%20practices   cheers - FSB

Bill Williams - Owner/Consultant/Trainer at Fill Staff "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://fillstaff.com/backupfolderspro.html - FREE
BIG ACT! LAYOUTS for Larger Monitors www.bigactlayouts.com
Protect your Files & Folders with Folder Lock Pro by New Software http://download.cnet.com/Folder-Lock/3000-2092_4-10063343.html
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Importing ACT DB into a new DB

Make sure you have a good backup first ... in case something goes wrong.

If you still need help after the export - you might include the version and other info as per:
http://blog.glcomputing.com.au/2009/05/how-to-get-faster-technical-support-for.html
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Importing ACT DB into a new DB

Avid Listener
Posts: 52
Country: United States

Re: Importing ACT DB into a new DB

Ok, still no luck after following the KB article.

 

This user is running ACT 2012, latest updates, with a single user account.


Windows 7, SP1, 64 Bit

No error messages after import

 

I started off by saving a blank copy of the source database. Then imported the user account. After that, I import the Comapnies, then opportunities, groups, then contacts, each is a seperate import.

 

Still getting the same results.

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Importing ACT DB into a new DB

" After that, I import the Comapnies, then opportunities, groups, then contacts, each is a seperate import."

They should all be done in the one import