Data export

[svetter]

• [x] Implement export function with parameters:
  • [x] Tables as displayed or raw data
    • [x] If as displayed: include derived statistical data or not
  • [x] Destination file
  • [x] CSV or FODS
    • [x] If CSV: Comma or tab
• [x] Implement CSV output
  • [x] Begin table
  • [x] Begin row
  • [x] Write cell
  • [x] End table
• [x] Implement FODS output
  • [x] Begin export
  • [x] Begin table
  • [x] Begin row
  • [x] Write cell
  • [x] End row
  • [x] End table
  • [x] End export
• [x] Create dialog for explaining and setting options and progress bar
  • [x] Mention that language setting will affect output
  • [x] Implement
• [x] Create new entry in main window menu bar Tools and connect

Implementation for different parameters

• [x] Tables as displayed:
  • Composite tables
  • No statistics:
    • Exclude numeric fold, ordinal and backend columns
  • Include statistics:
    • Exclude only backend columns
• [x] Raw data:
  • Base tables, including associative
  • Using IDs
  • Extra file for enum names
• [x] Single consolidated table
  • Composite ascents table
    • [x] Implement mechanism to add export-only columns to composite tables
    • [x] Add missing values from other tables as export-only columns
  • No statistics:
    • Exclude numeric fold, ordinal and backend columns
  • Include statistics:
    • Exclude only filter columns

Implementation ideas:

• enum ColumnExportFlag { NeverExport, AlwaysExport, ExportAsStat, ExportForConsolidated, ExportForConsolidatedAsStat } to mark which columns should be exported in which modes
• Adding more columns to AscentsTable:
  • In constructor as backend export-only columns which do not need to be a direct member but just added to the column list
  • OR created in export process without having a buffer attached, just using calculateValueAt() and pushing the results to export immediately

[svetter]

Basic FODS file format:

<?xml version="1.0" encoding="UTF-8"?>
<office:document xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" office:version="1.3" office:mimetype="application/vnd.oasis.opendocument.spreadsheet">
 <office:automatic-styles>
  <number:date-style style:name="N49">
   <number:year number:style="long"/>
   <number:text>-</number:text>
   <number:month number:style="long"/>
   <number:text>-</number:text>
   <number:day number:style="long"/>
  </number:date-style>
  <number:time-style style:name="N60">
   <number:hours number:style="long"/>
   <number:text>:</number:text>
   <number:minutes number:style="long"/>
  </number:time-style>
  <style:style style:name="ce1" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N49"/>
  <style:style style:name="ce2" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N60"/>
 </office:automatic-styles>
 <office:body>
  <office:spreadsheet>
   <table:table table:name="Table name">
    <table:table-column table:number-columns-repeated="2" table:default-cell-style-name="Default"/>
    <table:table-column table:default-cell-style-name="ce1"/>
    <table:table-column table:default-cell-style-name="ce2"/>
    <table:table-row>
     <table:table-cell office:value-type="string">
      <text:p>text</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="float" office:value="42">
      <text:p>42</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="date" office:date-value="2023-11-13">
      <text:p>2023-11-13</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="time" office:time-value="PT12H34M00S">
      <text:p>12:34</text:p>
     </table:table-cell>
    </table:table-row>
   </table:table>
  </office:spreadsheet>
 </office:body>
</office:document>

[svetter]

https://github.com/qt/qtbase/blob/e4315204b1412d74842b3167c3eb9a49dc233355/src/corelib/io/qzipreader_p.h

[svetter]

https://doc.qt.io/qt-6/qxmlstreamwriter.html

QFile file("example.xml");
if (!file.open(QIODevice::WriteOnly)) error();

QXmlStreamWriter xmlWriter(&file);
...

[svetter]

Making first row/colum bold

In <office:automatic-styles>:

<style:style style:name="ce1" style:family="table-cell" style:parent-style-name="Default">
 <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
</style:style>

In <table:table> for column:

<table:table-column table:style-name="co1" table:default-cell-style-name="ce1"/>

Cell:

<table:table-cell table:style-name="ce1" office:value-type="...">