Community
Showing results for 
Search instead for 
Do you mean 
Reply

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

Copper Elite Contributor
Posts: 175
Country: USA

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

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?

Platinum Elite Contributor
Posts: 6,652
Country: USA

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

The database value of True is -1.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Elite Contributor
Posts: 175
Country: USA

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

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?
Copper Elite Contributor
Posts: 175
Country: USA

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

Is there a solution to this problem?