Skip to content

[STABrAPP] - Improve export results #61

@jframi

Description

@jframi

UI changes
Provide a new option to Export results together with summary statistics and model statistics in a single Excel file.
i. Rename button on the right from “CSV Export” to “Export results”
ii. new toggle switch All in one file on the right of Export results button, off/deactivated by default.
iii. new tickbox One file per environment. If All in one file is switched on, then tick One file per environment by default.

Export file format

  • If All in one file is off/deactivated, export the usual CSV containing only BLUPs/BLUEs.
  • If All in one file is on/activated:
    • If One file per environment is ticked:
      • Download format: .zip containing multiple Excel files if analyzed study has multiple environments, .xlsx if analyzed study has one environment.
      • One file for one environment. The file has four sheets appearing in this order: BLUPS, BLUES, Summary statistics, Model statistics
        • NB: Analysis variable names in Summary statistics, Model statistics should appear as rows, whilst the raw “parent” variable names should appear as columns.
      • To find a balance between a human-readable file requested by the client and machine-readable file, the following format is proposed
    • If One file per environment is NOT ticked:
      • Download format: .xlsx regardless of number of environments
      • One file for ALL environments. The file has four sheets appearing in this order: BLUPS, BLUES, Summary statistics, Model statistics.
        • NB: Analysis variable names in Summary statistics, Model statistics should appear as rows, whilst the raw “parent” variable names should appear as columns.

Export file name.

  • If All in one file is off/deactivated, the file should be named as follows: StudyName_username_yyyymmdd_hhmmss_STA.csv
  • If All in one file is on/activated:
    • If One file per environment is ticked: StudyName-environment_username_yyyymmdd_hhmmss_STA.xlsx
    • If One file per environment is NOT ticked: StudyName_username_yyyymmdd_hhmmss_STA.xlsx

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions