Error importing CSV file with TRUE or FALSE values into checkbox property

Hello! When importing a csv file, with a "TRUE" or "FALSE" into a checkbox property clay always gives an error. F.e: (In the video I tried to import values to the checkbox first and gave an error, but after it, without mapping that column, doesn't give an error)

✅1

5 comments

Clay Team
APP
·
·
🕰 Hey hey! The Clay team is currently on Holiday so we’ll be a bit slower to respond than normal. We’ll do our best to get back to you within the 24-48 hours but may need some extra time here. If your request is urgent, please slack @Matthew Quan (Clay) directly.
Pedro A.
·
·
this is the table
Pedro A.
·
·
I solved this with a TRUE / FALSE BOLEAN
Clay Team
APP
·
·
Pedro A. this is a known issue with CSV imports, checkbox formatting/uploading is something we need to fix, the TRUE/FALSE boolean is the best workaround at the moment! cc: Jason L. Maggie W. for the CSV upload issue!
Arturo O.
·
·
Also, the column doesn’t import because there are some special characters like the ‘?’ In the CSV headers. Not sure what other characters cause issues but the question mark is one of them.