Data Export XLS Damaged

Kobo On Your Own Server
1

Hi there,

I encountered a problem when exporting survey data to XLS/XLS legacy/XLS Analyzer. The file is created and downloadable, but it seems to be damaged. When opening MS Excel (and LibreOffice Calc) it says something like “there are problems with parts of the content in [FILENAME]. Shall we try to restore as much as possible? (y/n)”. Choosing “yes” the next prompt says “File is damaged and cannot be opened.” A sample XLS is attached.
FPG_Alltagsmobilität - latest version - False - 2020-03-13-09-58-24.xlsx (11.3 KB)

This applies to all forms of different complexity, independent of containing repeat groups and independet of export settings (include group names, versions, XML/labels).

CSV/CSV Legacy Exports work.

Current version (own server):

kobotoolbox/nginx                          latest 
kobotoolbox/kobocat                        2.019.52-final-shared-database
kobotoolbox/enketo-express-extra-widgets   1.77.0-jnm-grunt-workaround  
kobotoolbox/kpi                            2.019.52-final-shared-database
mongo                                      3.4    
mdillon/postgis                            9.5   
redis                                      3.2

Any ideas on this?

Thanks in advance,
Daniel

2

I am having the same issue and wonder why this question has not been followed up.

Additional note: Probable the “False” in the file name indicates something, but what?

3

I think I solved this by exporting as CSV, which worked back then.

Just checked XLS exports in the same project and it’s working again, but we updated our server version early this year.

Regarding the “False” in filename: this only indicates that the values and headers are formatted as XML. If there is no “False” in the filename, values and headers are formatted as labels.

Sorry that I can’t come up with a viable solution. Maybe restarting the server will do it?