CRITICAL story-bufdir-data-aggregation-organization-admin-009 8 pts
8
Story Points
Critical
Priority
Bufdir Data Aggregation
Feature

User Story

As a Organization Administrator
I want to export the validated Bufdir aggregation as a properly formatted file (Excel, CSV, or PDF) ready for submission
So that I can submit the data to Bufdir using the format they accept without any further manual formatting

Acceptance Criteria

  • Given the coordinator selects a file format (Excel, CSV, or PDF) and confirms export, when the export process runs, then a file is generated in the selected format with Bufdir's required column structure
  • Given the file is generated, when the coordinator downloads it, then the file opens correctly in the corresponding application (Excel for .xlsx, spreadsheet viewer for .csv, PDF reader for .pdf)
  • Given the export completes, when the coordinator checks report history, then a new entry appears with the correct period, timestamp, format, and metrics
  • Given attachments are required for the submission period, when export runs, then the attachment bundler packages activity attachments alongside the main report file
  • Given the export process fails mid-way, when the error occurs, then no partial file is saved, the error is logged with details, and the coordinator is prompted to retry
  • Given the coordinator triggers export, when the file is uploaded to storage, then the export audit service logs the event with organisation ID, coordinator ID, period, and timestamp

Business Value

Bufdir's grant system requires submissions in specific formats. Generating compliant files automatically eliminates the manual formatting step that currently takes coordinators several hours per reporting cycle. Supporting all required formats (Excel, CSV, PDF) ensures compatibility regardless of which intake channel Bufdir uses, and the audit log satisfies both internal governance requirements and external auditor requests.