05-02-2014 05:53 PM
When importing records from one ACT Pro V16 database to another, it is not merging the check box responses. I created an export comma delimited text file with about 35 check boxes. The export value for a field with a check mark is a 1. With no chec mark it is a 0. There are about 30 such fields and about 160 records. I also exported the company, city, zip, and contact fields. The destination database has duplicate checking set to first check zip, then city, then company.
After importing, the message reads that it successfully imported 160 records. However, when I search on one of the check boxes for an answer of True (checked), it comes up with zero matches. In the DB where the file came from, the result is 60 contacts for that field with a value of True (checked).
What is the problem here? What am I missing?
05-02-2014 08:31 PM
The database value of True is -1.
05-03-2014 02:47 AM
05-09-2014 11:39 AM
Is there a solution to this problem?