Import xls form - KoboToolBox//Float object has no attribute

Dear Community,
I have this error message when trying to import this Excel form in Kobo.
The online validator worked fine and did not show any error so I’m not sure where to look for it.
Can you please help me on this one?

Thank you very much,
Emma

TEST_Preregistry_Kenya_2023(2).xlsx (244.1 KB)

Capture d’écran 2022-11-09 à 11.00.03

Hello @it_emm_jos,
The cause is a column with a number as name in your (extra) sheet species. See stripped down example here ColumnName_01.xlsx (105.9 KB)
If you remove this sheet or change the 2022 there to something like Year 2022, it will work.

@Kal_Lam, @Josh,
The issue might be interesting for the KoBo Core Team, as the Online Validator and its Preview worked well with the original XLSForm. And this error was difficult to locate! Here is another example, reproducing the same error (from the survey sheet): ColumnName_02.xlsx (104.2 KB).

2 Likes

It worked, thank you so much :slight_smile:

1 Like

@wroos, :clap: :heart: :partying_face: