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

added EnhancementAccepted label

assigned to @i.nueske

changed iteration to Sprint Feb 3, 2025 - Feb 16, 2025

removed iteration Sprint Feb 3, 2025 - Feb 16, 2025

changed the description

changed the description

From caosdb/customers/dimr/management#259:

• Assumption that only the first element of each reference list needs to be considered
• Assumption that records only have one RecordType
• Integration into the advanced user tools

marked the checklist item Generate json schema for chosen record list using JsonSchemaExporter as completed

marked the checklist item Generate XLSX tables from json schema using XLSXTemplateGenerator, set foreign_keys to id as completed

marked the checklist item Fill XLSX tables with data from record list using TemplateFiller as completed

marked the checklist item Implement: as completed

mentioned in merge request !132