|ACT||ACT Add-ons||Marketing Help||Books||About Us|
Copy System Field
Delete Company Lookup
Delete Group Lookup
Edit Append Field
Limited Access Manager
Remove from Group
Database Field Triggers
Account No Generator
Batch Field Creator
Copy Fields Contents
Copy Opp to Lookup
Lkup Contacts in Co
Select a Quote
ACT! Style Guide
Planning & Maint Guide
Drip Marketing Letters
Creating Enticing E-mails
Converting Your Older ACT! DatabaseHow would you like a program that analyzes an ACT! 6 (2004) or ACT! 5 (2000) database and in a matter of a few minutes displays a Microsoft Excel worksheet describing the work that should be done prior to conversion? All projects turn out better when time is spent on preparation. Changing from the older database platform to the newer SQL/MSDE platform can present a few problem areas that are tricky to discover. So after you have run Scan and Repair, you will want to run Red Flags.
Red Flags analyzes an ACT! 5 or 6 database to determine any potential upgrade problems prior to converting it to the current version of ACT!. It starts by creating a backup of the existing database. It then performs a field analysis on the Contact and Group tables, displaying the list of database fields and their attributes in an Excel worksheet (Requires Excel 2002 or better). Any potential conversion problems are red-flagged for your review.
"Flags" potential problem areasRed Flags looks for things like ...
Provides Usage Statistics/Removes Bad DatesHow many times have you seen a database with fields that are created as Character 50 and all the user ever entered was a Y or an N? Or perhaps there are some fields in the database that were created with good intentions, but no one ever entered any data in the field. Wouldn't it be great to clean those up prior to conversion! Red Flags can help you to identify those fields so that you can deal with them prior to conversion. The program lets you know...
Scans For, and Repairs UNKNOWN USERSNotes, Histories, and contacts with unknown user IDs in certain fields can cause a conversion to fail. Red Flags will scan the ACT database tables for these entries and let you know if you have any. If the unknown user problem exists, Red Flags can replace them with an existing user of your choice.
Fixes Common Activity ProblemsActivities with an end date earlier than the start date will cause failure during conversion. Recurring activities that go on too long (too many recurrences) have also been reported to cause problems. RedFlags will locate and list...
Identifies and Helps Repair ACT! Attachment File ProblemsFinally the program will provide an analysis of the attachment items found in the Notes/History tab. RedFlags is capable of listing 130,000 attachments. Attachment analysis will let you know...
RedFlags also provides two special purpose tools for dealing with Attachments.
Unlimited UseThe program (which sells for $150) allows unlimited usage. So you can use it to analyze as many databases as you like to outline the work you need to perform prior to conversion. This is an essential tool for all consultants.
or contact us at:
Cornerstone Solutions, Inc., PO Box 270514, Houston TX, 77277-0514
Copyright © 1987-2012 Cornerstone Solutions, Inc. All rights reserved.