Error importing files (xlsx format) due to some incoherent data

[dpalomino]

I have seen this issue when moving a project from demo to staging. The project in demo is this one

Steps to reproduce:

1. From the original project in demo, download the questionnaire
2. Create a new project in staging with the same questionnaire (this one)
3. Export all data from the demo project using xlsx format
4. Try to import the data to the new project in demo

Then a few errors appear because it seems the exported information is not consistent:

1. There are some mandatory fields (like land_sufficient, acquisition and others) that there were empty in the xlsx downloaded file. I don't know how it was possible to create those records with those fields empty.
2. There were some invalid tenure_type values (ie. not defined in the choices tab). How it was possible to submit these values

After "cleaning" the data the import worked successfully.

I want to highlight that this is not a problem with the import process, but the data within that project didn't seem to be consistent.

@SteadyCadence was working on the creation of this and other demo projects. Do you have any clue about how this is possible? @amplifi, if you could take a quick look to see what happened.

[dpalomino]

Same thing happening with this one. In this case was only a invalid tenure_type ("CO" instead of "OC"), it looks like these values were inserted manually instead of via WUI, ODK or imports?

Did we use @SteadyCadence a script or QGIS plugin for this maybe?

[dpalomino]

@SteadyCadence volunteered to fix these projects in demo (thanks!).

We can close this issue for now.