Aller au contenu principal
Petanque Life

Data Export & Reporting

F14.05 6 fonctionnalités Plateforme+

En bref

Data Export & Reporting turns any tenant dataset into downloadable CSV, JSON, or Excel artefacts on demand or on a six-frequency schedule, ships reusable templates with column transforms, supports federation-mandated formats (SBP CSV, FFPJP XML, DPV CSV, FIPJP JSON, generic CSV), produces GDPR Article 20 portability bundles with 48-hour expiry, and publishes curated open-data feeds in JSON, CSV, RSS, or Atom for transparent public consumption.

Comment ça fonctionne

Ad-hoc exports are modelled as ExportJob documents with format (CSV, JSON, Excel), a configurable column projection, filter clauses pushed down to the underlying collection query, and a download lifecycle (queued → running → completed/failed → expired). Large jobs stream rows through a chunked writer to avoid materialising the full result set in memory. Recurring exports are wrapped in a ScheduledExportJob with one of six frequencies (hourly, daily, weekdays, weekly, monthly, quarterly), pause/resume/trigger controls, and dual delivery — webhook POST and email attachment — with signed URLs for the artefact.

ExportTemplate captures reusable column mappings with per-column transforms (date format, decimal locale, redact PII), can be marked shared or personal, and lets the author override the delimiter and encoding for systems that demand semicolon-separated UTF-16. CompetitionExportJob specialises in federation-mandated formats: SBP CSV for Sweden, FFPJP XML for France, DPV CSV for Germany, FIPJP JSON for global submission, and a generic CSV fallback; the format module owns column order, header conventions, and the canonical character encoding. GDPR data portability is handled by GdprPortabilityExport, which packages all subject-related records under Article 20, supports JSON or CSV bundles, expires the download link 48 hours after generation, prevents duplicate concurrent requests for the same subject, and tracks every download for audit.

OpenDataFeed publishes curated public datasets (rankings, results, calendar) under stable slugs, served as JSON, CSV, RSS, or Atom; responses are cached at the CDN edge and an access counter records each fetch for transparency reporting.

Capacités clés

  • ExportJob with CSV/JSON/Excel output, configurable filters and columns, lifecycle tracking
  • ScheduledExportJob with six frequencies and webhook + email delivery
  • ExportTemplate with column mapping, transforms, delimiter/encoding override
  • CompetitionExportJob covering SBP CSV, FFPJP XML, DPV CSV, FIPJP JSON, and generic CSV
  • GdprPortabilityExport for Article 20 with 48-hour expiry and download audit
  • OpenDataFeed in JSON/CSV/RSS/Atom with slug-based access and CDN caching
  • Streaming chunked writers for memory-safe large exports

En pratique

A national federation owes the FIPJP a quarterly ranking submission. The data steward opens Reports, picks the FIPJP JSON template under CompetitionExportJob, sets the date range to Q1 2026, and runs the export. The job streams 4 800 ranking entries, validates against the FIPJP schema, and surfaces a signed download URL.

They submit the file through F14.02. To automate it next quarter they convert the run into a ScheduledExportJob with frequency=quarterly and a webhook that posts the artefact straight to their FIPJP submission endpoint. Separately they open an OpenDataFeed for the public ranking RSS and embed the link in their website footer; the access counter tells them 1 240 fetches happened in the first week.

Fonctionnalités de ce sous-système

6
ID Status Fonctionnalités
F14.05.01 Livré Bulk data export (CSV, JSON, Excel) — ExportJob CRUD, CSV/JSON/Excel format, configurable filters & columns, download lifecycle ✅ PL-F1405
F14.05.02 Livré Scheduled report generation and delivery — ScheduledExportJob CRUD, 6 frekvenser, pause/resume/trigger, webhook + e-post-leverans ✅ PL-F1405
F14.05.03 Livré Custom export templates — ExportTemplate CRUD, kolumnmappning med transform, delad/personlig, delimiter/encoding-konfiguration ✅ PL-F1405
F14.05.04 Livré Competition result export (federation-specific formats) — CompetitionExportJob, SBP CSV, FFPJP XML, DPV CSV, FIPJP JSON, generic CSV ✅ PL-F1405
F14.05.05 Livré GDPR data portability export — GdprPortabilityExport, Art. 20, JSON/CSV, 48h-utgång, dubblettskydd, nedladdningsspårning ✅ PL-F1405
F14.05.06 Livré Open data feeds (public statistics, rankings) — OpenDataFeed CRUD, JSON/CSV/RSS/Atom, slug-baserad åtkomst, caching, accessräknare ✅ PL-F1405