Boolean member can not be set to null Excel Import even though the field is filled in.
0
I have an Excel sheet with several columns, one of which is a boolean field. This field contains the value "Nee" which is parsed into a False boolean value. During debugging, I can confirm that the parsing microflow correctly recognizes the value and parses it to False. However, I keep encountering the error: com.mendix.basis.objectmanagement.member.EmptyBooleanException: Boolean member cannot be set to null The Excel sheet currently has only one row for testing, and the field is 100% filled in and parsed correctly. Despite this, the error persists, preventing me from completing the import. I’m unable to determine what’s going wrong, as everything appears correct during debugging. Any help would be greatly appreciated!
asked
Henry Buysschaert
2 answers
0
Henry,
Can you add a screenshot of your parsing microflow to your question?
Thanks,
Mike
answered
Mike Kumpf
0
Hi Mike, here is the screenshot of my parsing microflow:
In the meanwhile, if I just paste the contents of the Excel file into a brand new sheet without any further changes, the error does not occur anymore, which is very odd. I have no idea why the importer is acting the way it is. This leads me to think that maybe something behind the original excel-file is corrupted?
answered
Henry Buysschaert