Empty Cart

Knowledgebase

I'm running Duplicate Remover Wizard Expert and get an error message about fieldname should not be null.

You receive an error saying a field should not be null when running Duplicate Remover. This is typically caused by a true/false field with nulls. We see this fairly often, particularly on ACT! data bases that started back around ACT! 2006 or 2007 and have since been upgraded to newer versions. Several records have NULL in a YesNo field. You can prove this on your data base by doing a Lookup/All Contacts to get a total record count. Then Lookup/Field/Equals/True and note the count and then Lookup

You can de-duplicate a Group of Contacts. Is there a way to de-duplicate a group of Companies?

ACT! does not have the concept of a "group" of Companies as it has a Group of Contacts. So you can't tell Duplicate Remover Wizard Expert to process a Group of Companies like you can a Group of Contacts. But it is possible to have Duplicate Remover Wizard Expert process a subset of Company records by using the following process: 1. Since the Company record out of the box does not have User fields, create a temporary "Tag" field using Tools/Define Fields on the Company record. It should be

Patricia Egen Consulting, LLC

803 Creek Overlook, Chattanooga, TN 37415
Main office: 423-875-2652 • Arizona office: 480-788-7504 • Florida office: 754-300-2827
support@egenconsulting.com