?
Solved

Load ACT backup files into SQL-Server

Posted on 2008-11-19
7
Medium Priority
?
553 Views
Last Modified: 2012-05-05
I have a client whose ACT contacts table was scrambled due to a rogue PDA synchronization.  I have backup files produced by AutoAdmin III from prior to, and after, the corruption.  I need to find a way to load them into SQL-Server to identify the affected rows.  The files are named like SQL-Server files (xxx_master, xxx_model, dbname) with a .bak extension.  SQL-Server states they are "not in a primary database format" if you try to attach them.

Thanks in advance.
0
Comment
Question by:AielloJ
  • 4
  • 3
7 Comments
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 22994261
You should be able to use File | Restore in ACT!

For PDA, I find issues with a lot of the link solutions. The best option (if using Blackberry or Windows Mobile) is Handheld Contact. You can download a trial to test from www.GLComputing.com.au/HHC
0
 
LVL 13

Author Comment

by:AielloJ
ID: 22995034
Would we be able to restore only the Contacts table?

FYI:  The corruption was caused by users not properly signing out from the Remote Access Server (RAS).  "Orphaned" RAS sessions running when the user synchronized her PDA caused the Contacts table data to be scrambled.  My company (a vendor to the client) is now categorized as an accounting tax client with some other name listed as the owner.
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 22995098
No, you can't just restore one table.

What PDA do they use?
What do they use to sync it to ACT!?

Do you have a backup before the damage? If so, you might look at restoring that.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 13

Author Comment

by:AielloJ
ID: 22996343
Unfortunately we have to correct/restore the Contacts table only as they continued to input appointments, etc for the contacts that were unaffected.  I have backups created by AutoAdmin III prior and post corruption.  The goal is to to load the Contacts into SQL-Server for analysis if possible.

This client has over 6K contacts and extensions to the number of columns (~243 columns).  I don't rememer the PDA brand, but they are using CompanionLink for sync.
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 22996473
If you take out the contacts, you won't easily be able to merge them back in.

If you restore a good copy, you can try and import the damaged one - telling it to leave the contacts intact and merge new activities and histories.

You'll need to have some fields the are fairly unique and not damaged to match with
0
 
LVL 13

Accepted Solution

by:
AielloJ earned 0 total points
ID: 23085820
Must resort to a manual process.
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 23088076
Which manual process?

If you think you can do it in Excel, restore the database, use itImport to auto number all the records and export them to Excel from the Contact List (including the auto number field)

Fix them in Excel, then merge them back with itImport using the Auto number field as the match field

You can get itImport from http://www.glcomputing.com.au/main/57/1

This is the easiest way to work on the contact table and not lose all the sub-table links.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of users new to ACT!, especially those who don't get the benefit of a consultant, seem confused between when to share on a network and when to sync ... or, in fact, how to do either. So I thought I would attempt to explain the various options …
Microsoft have a hotfix for Windows systems that will improve application that uses UTC dates and times - including Outlook, the Windows Event Viewer and many third-party applications. Most date and time stamps that are created and displayed in W…
Progress
Starting up a Project

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question