ACT! Record Manager Fix
If you have lost the Record Managers for your Contacts,
Activities, History, Notes and Sales
but you have an older version of your database that has the correct Record
Managers
we can use that as a reference to fix your current database.
This utility fixes the Record Managers, based on an earlier ACT!
6.0 database that you have.
It fixes the Contact, Activities, History & Notes, Groups, and Sales/Opportunity
tables in ACT!
Main Menu
Contacts: NewData
This is the latest data, but the Record Managers
in the User field have all become the same "K)%>*#6W"
Contacts: OldData
It may be old, but it has the correct Record
Manager codes in the User field
Activities: Schedl_for and
Schedl_by fields
Notice that the Schedl_for has the same Unique_Id, "K)%
>*#6W" for all the records. For the first activity it should be "=5:|
&?T/W" as seen in the OldData' activity table. These will be fixed.
History - User field
Groups: User field
Sales & Opportunities
Report
At the end of the process, a listing of what has been done is
put in to a Text file for your reference.
|
Record Manager Fix
Source: OLDDATA
Target: NEWDATA
Start: 01/29/09 12:19:43 PM
1000 TARGET.User with SOURCE fixed for PV6( PP+[(! in CONTACTS
500 TARGET.Schedl_for with SOURCE.Schedl_for fixed for PV6( PP+[(! in ACTIVITIES
400 TARGET.Schedl_by with SOURCE.Schedl_by fixed for PV6( PP+[(! in ACTIVITIES
600 TARGET.User with SOURCE fixed for PV6( PP+[(! in HISTORY/NOTES
20 TARGET.User with SOURCE fixed for PV6( PP+[(! in GROUPS
100 TARGET.User with SOURCE fixed for PV6( PP+[(! in SALES
2620 records updated
Finished: 01/29/09 12:27:58 PM |
See also
C I Corporation
PO Box 2816
Arlington, VA 22202
202-829-4444 202-449-9500 Fax
800-319-3190 877-727-9070 Fax
CIC@CICorp.com
C I Corporation Software
C I Corporation Home page
$ 59
