Importing check boxes yes no boxes true false is not merging the records

[tbudde]

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?

[Roy_Laudenslager]

The database value of True is -1.

[tbudde]

So If I change the 1 ' s to -1, it should work? If so, why? Why would it export as 1 if import requires -1?

[tbudde]

Is there a solution to this problem?