Hi, all.
I created a survey in LimeSurvey and exported the answers to a xlsx file so I can create a dashboard. In the xlsx file the cells are defined as "General" but the texts appear aligned at left and numbers aligned at right, as normal.
When I load the file to AGOL, most of the fields are assumed as text /when they should be numbers, Integer or double. If I change the data type to integer or double, the features will be deleted. The rows just vanishes.
I tried with a CSV instead of XLSX and the resultass are the same.
I tried load the file to a geodatabase and the data types are ok in the geodatabase, but if I load it to AGOL, the results are still the same.
I changed the header names so they keep below the 10 characters, just in case, and the result keeps the same.
My question is: what can be done so the data types can be correctly assumed by AGOL?
Thanks in advance
PS: I attached an extract of the file so you can test it if you want