search

cidgoh / DataHarmonizer

A standardized browser-based spreadsheet editor and validator that can be run offline and locally, and which includes templates for SARS-CoV-2 and Monkeypox sampling data. This project, created by the Centre for Infectious Disease Genomics and One Health (CIDGOH), at Simon Fraser University, is now an open-source collaboration with contributions from the National Microbiome Data Collaborative (NMDC), the LinkML development team, and others.
MIT License
91 stars 23 forks source link

Multi-sheet Excel export #434

Open kennethbruskiewicz opened 2 months ago

kennethbruskiewicz commented 2 months ago

With issue #431 : rework the file saving to allow for multi-sheet Excel file saving.

kennethbruskiewicz commented 2 months ago

Will come in with https://github.com/cidgoh/DataHarmonizer/tree/dh2-431-export-as-json as I can reuse the same code.

@ddooley the "Save as..." vs the "Export to..." feature – should this only be supported in the "Save as..." feature?

I mention this because "Export to..." seems to be "owned" by the template repository. I'm not sure if it's something to force on every template if each implementation is meant to be different.

ddooley commented 2 months ago

"Export to" involves conversion of a given schema to another, so will always involve a menu of specific target formats to map/convert fields to - each usually saved as tab separated data. That's why its different from "save as" which is not mapping fields, its just saving schema content with its own slot fields/names/structure.

Export to function currently often involves adding export.js script to fiddle with fields as they are transformed to target.

Indeed templates don't necessarily need an export option and in fact the "Export to" menu may list nothing if there is no export target predefined.