Community
Showing results for 
Search instead for 
Do you mean 
Reply

Importing ACT DB into a new DB

Highlighted
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?

Highlighted
Nickel Elite Contributor
Posts: 988
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 / ACT! Consultant / Trainer at FILL STAFF HR "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://www.fillstaffhr.com/backupfolderspro.html - FREE
Backup your ACT! Databases DAILY using ACT! / File/ Backup/ Backup Database.(Include Attachments).
Also - FREE - BIG ACT! LAYOUTS for Larger Monitors http://www.fillstaffhr.com/bigaldl01.html
Also - FREE - BullZip PDF Printer - Print directly to PDF http://www.bullzip.com/products/pdf/info.php
Highlighted
Platinum Elite Contributor
Posts: 14,825
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
Highlighted
Platinum Elite Contributor
Posts: 14,825
Country: Australia

Re: Importing ACT DB into a new DB

Highlighted
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.

Highlighted
Platinum Elite Contributor
Posts: 14,825
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