Wrong date in zipped export

[moniquewiza]

When a user exports results to the XLS format, all files that were uploaded to the survey and are packed into zip file have wrong timestamp - it is updated with the date and time of the zip file. In the file system, uploaded files have correct timestamps

To Reproduce

1. go to the survey having 'Upload' option where some files have been uploaded together with contributions.
2. go to 'Results' tab
3. click on 'Export' - wait for the file to be exported
4. download exported file (.zip) from the Export tab
5. open zip - all attached files has current (zip file) date and time

Expected behavior
Export shall not update the timestamp of attached files

Screenshots
in the files system:

in the zip file

[LMA-EUSurvey]

Dear Monique,

I will investigate further and will come back to you as soon as possible.

Best regards

EUSurvey Support

[LMA-EUSurvey]

Dear Monique,

I have been doing tests and cannot reproduce the different dates. When doing extraction I get the date of extraction for both the excel and files. Could you please specify where do you get the first screen shot with the 15/03/2021?

Also, when the ZIP file is created, the entries automatically get the creation date of the zip file.

This might be changed if needed to match the creation date of the file.

Best regards

EUSurvey Support

[moniquewiza]

Hi, the first screenshot is from the file system where the EUSurvey keeps files attached to the survey.
And this is exactly the issue: entries in the zip file have a date of the zip file itself instead of keeping original dates. When compressing/packing files with zip tools like winrar, windows zip compressor, etc., entries in the zip file have original dates, not date of the zip.
The original metadata is important in many cases - in our case we have auditors who wants to check when original files have been created

Best regards
Monique

[LMA-EUSurvey]

Dear Monique,

I apologies for my late reply on this issue.

The developers and I will investigate the possibility to make this request an improvement on future versions of EUSURVEY.

Best regards

EUSurvey Support

[LMA-EUSurvey]

Jira ticket SURVEY-7564

Dear Monique,

Improvement ticket created.

Best regards

EUSurvey Support

[BRU-EUSurvey]

Currently planned for version 1.6.
I will request this one to be processed earlier.