I have always been able to download my data in XLS format until today 10th September when it started me EXPORT FAILED.
Kal_Lam
September 10, 2021, 2:58pm
2
Welcome to the community @nassp_osun_socu ! Could you please let us know the server you are using?
Researchers, Aid Workers and Everyone else
1 Like
Josh
September 10, 2021, 6:11pm
5
Hi @nassp_osun_socu ,
Can you please send me the following in a private message:
server (HHI/OCHA)
username
project
Josh
September 10, 2021, 6:13pm
6
@nassp_osun_socu , in the meantime, can you please try your export with the following box ticked and see if it succeeds:
1 Like
Josh
September 10, 2021, 7:07pm
8
Hi @nassp_osun_socu , the two columns of bindnd
, bindnd::relevant
stood out as I was looking at your XLSForm. When I removed them, uploaded the form and redeployed I could then successfully export the data (if the “include data for all versions” tick box was unchecked). Can you please clarify the purpose of those columns?
1 Like
Josh
September 10, 2021, 8:07pm
9
Hi @nassp_osun_socu , I’ve tracked down the issue and you can follow the fix here:
opened 08:06PM - 10 Sep 21 UTC
bug
high priority
Community report: https://community.kobotoolbox.org/t/xls-export-failing/22477
…
Exception:
```
kpi_1 | Traceback (most recent call last):
kpi_1 | File "/srv/src/kpi/kpi/models/import_export_task.py", line 135, in run
kpi_1 | self._run_task(msgs)
kpi_1 | File "/srv/src/kpi/kpi/models/import_export_task.py", line 636, in _run_task
kpi_1 | pack, submission_stream = build_formpack(
kpi_1 | File "/srv/src/kpi/kobo/apps/reports/report_data.py", line 56, in build_formpack
kpi_1 | pack = FormPack(versions=reversed(schemas), title=asset.name, id_string=asset.uid)
kpi_1 | File "/opt/venv/src/formpack/src/formpack/pack.py", line 56, in __init__
kpi_1 | self.load_all_versions(versions)
kpi_1 | File "/opt/venv/src/formpack/src/formpack/pack.py", line 115, in load_all_versions
kpi_1 | self.load_version(deepcopy(schema))
kpi_1 | File "/opt/venv/src/formpack/src/formpack/pack.py", line 139, in load_version
kpi_1 | form_version = FormVersion(self, schema)
kpi_1 | File "/opt/venv/src/formpack/src/formpack/version.py", line 203, in __init__
kpi_1 | _labels = LabelStruct(labels=_f['label'],
kpi_1 | File "/opt/venv/src/formpack/src/formpack/version.py", line 26, in __init__
kpi_1 | '{}!={}'.format(', '.join(labels),
kpi_1 | TypeError: sequence item 0: expected str instance, NoneType found
```
Caused by incorrect handling of labels for "pseudo questions" resulting in length of labels list being different to length of translations:
https://github.com/kobotoolbox/formpack/blob/55f3aa49a69669130e3368217ba7cfdbf19b911a/src/formpack/version.py#L215-L228
1 Like
I do not think those columns are the issues because I have been using this form for quite some time and never had issues with downloading in xls.
Josh
September 10, 2021, 8:33pm
11
Hi @nassp_osun_socu , a fix will be deployed shortly. Please use the legacy XLS export in the meantime — fortunately that is still working.
1 Like