Home » CRM, CRM Best Practices, Sage ACT!

Four Best Practices for Cleaning Up data in Sage ACT

Written By: Cliff Ford on June 12, 2012 No Comment

This blog covers the 4 best practices that we have discovered in managing data in Sage ACT. Not just managing it but cleaning it up.

How to best clean up data in Sage ACT

Feel free to implement these four best practices to maintain your ACT database in the best possible condition.

  1. De-Duplication by merging contacts. The three top toolsfor de-duplicating ACT are (a) The Duplinator [this tool works only in ACT 5/6 (b) The Fuzzy Logic De-duper by the folks at E-Grabber (c) The De-duplication Wizard by Pat Egen (aka PEC). These provide 3 high-quality options:
    • Deduping multiple contacts all at once
    • Fuzzy Logic evaluation. The user is now empowered to combine John Smith, John H. Smith and Dr. John Smith into a single contact.
    • Make sure you have no loss of data: If multiple contacts are combined into one, then several note records are created in order to capture the data from the mulitple, combined and deleted contacts.
  2. Clear/Delete old tasks and flag them as “Not Completed”. Many times, hundreds (or thousands) of old activity records are left uncleared. These bloat the database and should be removed. The user can either highlight these multiple activities and (a) erase them or (b) clear them as “not completed”. Even though erasing these records is a simpler option, it removes all traces of the activity and is thus not recommended. Instead, clearing them as “not completed” clears them, but differentiates them from all other activities (which are normally cleared as “completed”. Please note that when multiple activities are cleared at the same time, the history date is “today” rather than the date that the activity was scheduled for.
  3. Get rid of Old Data. Under Tools|Database Maintenance|Remove Old Data, the administrator is able to remove unnecessary data. We recommend backing up the database before performing any data removal. That said, the only type of data that we can generally recommend is the removal of cleared activities (because these have already been turned into histories).
  4. Take care of “previous Employes/Users”. We don’t suggest deleting previous users from the database. The reason for this is that you will lose all the data associated with that user – including activities, histories and notes. Rather than deleting old users, we suggest(a) making these users Inactive and (b) changing the User Name as well as the Contact Name from “First Last” to “xFirst Last”. This sorts all of the previous users to the bottom of the list when selecting the record manager of any type of record.

How to get the Most of ACT!

Free Download CRM Implementation Partner Selection WhitepaperFree White Paper for you to download: How to Choose the Right CRM Implementation Partner

This White Paper discusses the most important CRM partner selection criteria. Points include Pricing, Productivity, Support, Presentations, Rating the vendors, managing the RFP Process, Proof of Concept, Negotiation with CRM partners, Vendor Scorecard and more.

==>Click to Download the CRM Partner White Paper<==

Read More…

Data Integration/Migration using SQL Integration Services (SSIS … – I wrote a blog article last year on how to integrate Microsoft Dynamics CRM using SQL Integration Service (SSIS) 2005 (http://tiny. I hope that article provided you with an alternative solution for your integration/data migration project with CRM. Due to the limited capabilities in SSIS 2005 with CRM web services, we created a proxy class as a work around to provide easy access to the CRM API.

CRM2011 « XRM Experts – Microsoft recently released this tool to validate all the java script and HTML web resources on CRM on premise or online. Java script validated via this tool will handle cross browser  support once it is out in next couple of months. Recently I was asked by a customer to populate city, county and state depending on the zip code for accounts and contact.

About the author

Cliff Ford Author: Cliff Ford. CRM Solution Comparison has provided CRM cloud software reviews and evaluations for several years. Our staff of CRM certified partners implements, tests and uses the various systems discussed within this blog. We have created a number of excellent CRM comparison and evaluation tools that we provide our readers. Google

Incoming CRM search terms:

  • cleaning up act database

Tags: , , , , ,

Digg this!Add to del.icio.us!Stumble this!Add to Techorati!Share on Facebook!Seed Newsvine!Reddit!Add to Yahoo!

Comments are closed.

Partly powered by CleverPlugins.com   Copyright © 2009 CRM Solution Comparison, All rights reserved.| Powered by WordPress and CRM 2011 Partners | Blu Mag theme by Techblissonline.com