Error when compiling XLSForm: 'dict' object has no attribute 'nodeType'

Hello,
I am trying to update and compile an XLSForm using XLSForm Online and Ona, but I keep getting the following error: 'dict' object has no attribute 'nodeType'
My file is in .xlsx format, and I expected it to generate a valid .xml form. I have checked the survey and choices sheets, but the error persists. Could this be related to missing or misnamed columns, or an invalid reference between select_one and the choices list?

Has anyone experienced this issue before, and what steps should I take to fix it?

Thank you for your help!

Hi @Yan_WABO

It might be caused by incorrectly used multi-language support - see a similar issue here: Error “Error: ‘dict’ object has no attribute ‘nodeType’”. If that’s not the case, please attach your XLS file so we can take a look.

Hi @Grzesiek2010

Thank you for the suggestion. I have carefully checked both the survey and choices sheets, and everything seems to be in order. However, the problem still persists and I continue to get the same error message.

Kindly find the attached XLS file for your review.

Thank you again.

Rapport Hebdomadaire des stocks en vaccin_V010226.xlsx (164.0 KB)

The error is caused by the hint::French column being used in the choices sheet. Translatable labels and hints are supported only in the survey sheet. In the choices sheet, only translatable labels are allowed. You can add other columns in the choices sheet (for example, for choice_filter) and even name one of them hint, but without the ::French suffix (i.e. without making it translatable).

1 Like

Dear @Grzesiek2010
Thank you for support.

I just removed the hint column from choices sheet and all seems well now.
Thank you again