Skip to content

XLSX export with automatic schema

Specification

  • Takes list of records
    • records must all be of same record type
  • Generate schema for this record type
  • define identifying properties with "id" everywhere (for list valued references)
  • make sure that there are ID columns where needed
  • generate XLSX template
  • fill XLSX template with retrieved data

DoD

  • Implement:
    • Generate json schema for chosen record list using JsonSchemaExporter
      Problem: JsonSchemaExporter behaves weirdly with references -> Investigate solutions
    • Generate XLSX tables from json schema using XLSXTemplateGenerator, set foreign_keys to id
      Problem: modelschema/arrayschema is not used consistently -> Add support for arrayschema everywhere
    • Fill XLSX tables with data from record list using TemplateFiller
  • Followup issues created if necessary:
    • Import
Edited by I. Nüske