AnsweredAssumed Answered

Import flags some fields, but the bad data isn't there

Question asked by KOM KOM on Mar 3, 2015
Using 6.5.20 CE

I'm importing into a Boolean field.  It's complaining about 47 records out of ~50,000.  The complaint is that the field contents doesn't match 0 or 1.  It shows the field as containing:

0"""

When I search the Excel spreadsheet that holds the import data, it can't find any such string.  When I go to that column and sort it, I can't see any bad data.  The column has either a 0, a 1 or null.

Anyone know what's going on?

Outcomes