Committed to Helping You Maximize Your Database                                 home | blog
ACT consultants providing ACT help and ACT training

   

Red Flags

Converting Your Older ACT! Database

ACT 6 Conversion to ACT 2005 or ACT 2006How 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 areas

Red Flags looks for things like ...
  • Additional address fields (so you can be prepared for a custom conversion)
  • Additional phone fields (ditto)
  • Potential additional secondary contact fields (ditto)
  • Illegal characters in field names
  • Empty pop-ups (so you can remove the "Allow Editing" check prior to conversion)
  • Entry and exit triggers (and removes them if you like)
  • Exceptionally large drop-down lists (for cleanup and review)
  • Upper, Lower, or Initial cap fields that are longer than 70 characters (may truncate on conversion)
  • Renamed core fields
  • User fields 1-10 that have been changed to phone number fields
  • Duplicate field names (and it will fix them if you like)

Provides Usage Statistics/Removes Bad Dates

How 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...
  • How many records have data in the field (so you can consider deleting the field prior to conversion)and
  • What was the longest text entry (so you can make the field smaller if necessary).
Bad Dates... dates in date fields that are not legitimate dates (like "2/31/9"), can cause many problems both before and after conversion. When you get field usage statistics, if RedFlags encounters a bad date, it will remove it for you (they're useless anyway). A log will be kept listing these changes and you will be asked if you wish to view this log when the process is done.

Scans For, and Repairs UNKNOWN USERS

Notes, 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 Problems

Activities 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...
  • Recurring activities that go on for more than 5 years.
  • Activities with End Dates earlier than their start dates.
While RedFlags does not provide an automated tool to fix these problems, a button is provided on the Excel spreadsheet to locate the affected contacts so the problems can be quickly resolved should you decide it is necessary.

Identifies and Helps Repair ACT! Attachment File Problems

Finally 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...
  • If the path exists on the current workstation and
  • If file cannot be found.
Knowing these problems ahead of time allows you to fix the paths in Excel and have them written back to the database prior to the final conversion.

RedFlags also provides two special purpose tools for dealing with Attachments.
  • If you need to change the path of the attachments in ACT!, perhaps because you moved the files to a new location, you can use Excel's Find/Replace feature to change the recorded path in the Excel list, then click a button to write the changed paths back to ACT!.
  • When attachments are converted, the files are copied to an "attachments" folder and linked to the contacts in the converted database. Red Flags provides a tool that will copy the files original paths into the Regarding field of the item in ACT! 6 so a record of the original file location continues to exist. (The need for this second tool is rare, but invaluable if needed.)

Unlimited Use

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

Only $150.

To order, call 713-661-5200
or
Order Now

Certified consultants for the ACT! contact management software through technical support, act software training and user groups.

ACT! | ACT Add-ons | Marketing Help | Books | About Us | Home | Site Map


For comments or questions, email us
info@cornerstonesolutions.com
or contact us at:
Cornerstone Solutions, Inc., PO Box 270514, Houston TX, 77277-0514
Phone: 713-661-5200
Copyright © 1987-2012 Cornerstone Solutions, Inc. All rights reserved.