Enhance the naming convention rules for downloaded Excel & CSV files
As Sandrine,
I want that the rules for naming downloaded Excel and CSV files change generically to:
- for filtered Excel and CSV files:
<agency ID>,<Dataflow ID>,<version>,filtered,<YYYY-MM-DD HH-MM-SS>.csv|xlsx - for unfiltered CSV file:
<agency ID>,<Dataflow ID>,<version>,complete,<YYYY-MM-DD HH-MM-SS>.csv
OECD,SNA_TABLE1,1.0,filtered,2023-02-21 17-22-55.xlsx
So that the downloaded files can always be opened in Excel without issue (as today the name can be too long when there are very many filter selections).
Note: The CSV files will contain the filtered or complete information once the ticket dotstatsuite-core-sdmxri-nsi-ws#329 (closed) is done
The usage of :
is not allowed in the filename. It has been replaced by -
.
previous description details
# Steps to reproduce - Choose a large table with many dimensions, e.g. on lustat.statec.lu - Select on the page "Download -> Table in Excel". - When opening the file, Excel 2016 complains:![image](/-/project/10532325/uploads/5da0e0403d086418d7b6871d37cb100e/image.png)
Structure file: DF_LU1-DF_E3400_1.0_.xml
Data file: DF_LU1-DF_E3400_1.0__data.xml
Unsuccessfull Excel file with generated name: LU1_DF_E3400_1.0_L001+r003+r004+r005+r006+r007+r008+r009+r010+r011+r012+r013+L014+L015+L016+r017+r018+r019+r020+r021+r022+r023+r024+r025+r026+r027+L029+r030+r031+r032+r033+r034+r035+r03.xlsx
Successfull Excel file with shorter name: LU1_DF_E3400_1.0_DefaultView.xlsx