Roadmap

Database connection, shared bootstrap, configuration and initial application structure.

• Existing HighEQ database connection
• Shared application bootstrap
• Configuration and local overrides
• UTF-8 database support
• PHP 7.4 compatibility

Shared layout, navigation, dashboard and responsive user interface.

• Dashboard
• Shared header and footer
• Responsive navigation
• Workflow pages
• LMS-style application design

Quarter creation, selection, workflow status and import staging schema.

• Quarter creation
• Quarter selection
• Quarter archiving and restoration
• Import file register
• Import row staging table
• Quarter audit log
• Schema upgrade support

Living development roadmap, version tracking and schema overview.

• Application roadmap
• Schema version display
• Database table status
• Development progress summary
• Milestone planning

Protected multi-file CSV upload, inspection and queue management.

• Multiple CSV selection
• Protected non-public storage
• Delimiter, header and encoding inspection
• SHA-256 duplicate detection
• Per-file diagnostics
• Sample-row preview
• Queued and failed file removal
• Streaming row import deferred

Checkpointed low-memory CSV import into raw quarter staging rows.

• Bounded streaming batches
• CSV multiline and quoted-field support
• Encoding conversion to UTF-8
• Byte-offset checkpoints
• Safe reset-and-replay restart
• Malformed row samples
• Live import progress

Quarter totals, file breakdowns, service diagnostics and data quality.

• Row count validation
• Downloads and streams totals
• Raw and GBP revenue totals
• Service and currency breakdowns
• Data quality warnings

Automatic label resolution using existing labels, ISRCs and barcodes.

• Existing label matching
• ISRC matching
• Barcode matching
• Conflict detection
• Manual review queue
• Permanent identifier overrides
• Cleanse audit history

Optional country and mechanicals fields across mapping and validation.

• Country source-value preservation
• Mechanicals yes/no normalization
• Unknown mechanicals warnings
• Profile and remapping compatibility

Reason-first exception reporting, inspection and export.

• Validation reason filters
• Paginated exception rows
• Raw and normalized row inspector
• Per-file diagnostics and quality score
• CSV exception export
• Configured information omissions

Five-level severity and auditable zero-activity exclusions.

• Valid, information, ignored, warning and invalid statuses
• Zero activity ignored classification
• Ignored-row audit filters and export
• Quality score exclusion
• Safe validation replay

File-level mapping gaps with staged-row reconciliation.

• Clickable awaiting-mapping metric
• Shared card and filter query
• File and staged-row gap diagnostics
• Normalized severity reconciliation
• Stale mapping-state visibility

Readiness diagnostics and immutable reconciled financial previews.

• Generation readiness and blocker links
• GBP precedence and destination aggregation
• Commission and net payable previews
• Immutable fingerprinted generation runs
• Exact-zero reconciliation

Authoritative destination readiness and row-level diagnostics.

• Shared normalized-row destination predicate
• Correct unresolved destination count
• Inspectable unresolved-row diagnostics
• Readiness blocker explanations
• Destination lifecycle documentation

Canonical stored, override and central-catalogue resolution.

• ISRC catalogue to LMS destination join
• Shared optional lms_ prefix normalization
• Manual and permanent override precedence
• Resolver-aware readiness, fingerprint and aggregation
• Precise unresolved-row diagnostics

Read-only canonical LMS key comparison and impact counts.

• Every catalogue LMS key compared
• Exact normalized destination matches
• Quarter affected-row counts
• Precise mismatch classifications
• Destination key intent and remediation guidance

Explicit bounded audit batches with resilient cached results.

• No automatic audit on Settings or result-page load
• Cached key summaries and previous-result retention
• Bounded indexed normalized-row batches
• Server-side result and Inspect pagination
• Safe failure, timeout and stale-run recovery

Immediate queued runs with safe, structured startup diagnostics.

• Verified CSRF and selected-quarter request lifecycle
• Committed run record before bounded worker initialization
• Structured failure codes and support references
• Best-effort accounting and PHP error logging
• Administrator prerequisite diagnostics

Precise safe runtime-to-installer schema comparisons.

• Column datatype, NULL, default and ENUM comparison
• MySQL/MariaDB metadata normalization
• Expected, actual and required-action report
• Catalogue ISRC lookup-index diagnostics
• No schema-validation bypass

Explicit canonical catalogue keys without changing LMS identifiers.

• Nullable canonical destination catalogue_key
• Conservative exact-match installer backfill
• Transactional active-ownership uniqueness
• Impact preview and confirmed administrator assignment
• Shared cleanse, generation and audit resolver

Filtered reconciliation queue with bounded ownership evidence.

• Require-attention filters and cached classification totals
• Server-side sorting and pagination
• Bounded ownership inspection and representative samples
• Confirmed individual assignments and next-missing queue
• Precise audit trail and stale preview guidance

Immutable read-only financial snapshots and reconciliation.

• Selected-quarter workflow and readiness blockers
• Destination and DSP financial snapshots
• Immutable source-file and currency manifest
• Full precision and displayed-rounding reconciliation
• Current/stale immutable preview history

Trusted immutable quarter financial and operational headline.

• Completed-only Current/Stale/Failed snapshot states
• Financial and activity headline cards
• Separated source currencies and monthly provenance
• Snapshot reconciliation and rounding disclosure
• Audited immutable detail navigation

Queued staged generation with canonical aggregate reuse.

• Timeout-resistant queued preview processing
• Transactional stage checkpoints and duplicate protection
• Run-scoped canonical input materialization
• Safe performance timings and diagnostics
• Immutable run and manual-quarter verification

Canonical fingerprint state with inspectable components and live stages.

• Fingerprint-only Current/Stale decisions
• Deterministic component-level diagnostics
• Historical immutable-run compatibility
• Visible staged progress and completion state
• Non-overlapping queue, preparation and stage timings

Dry-run and transactionally persist one immutable preview.

• Exact immutable-preview mapping
• Read-only dry-run and schema diagnostics
• Duplicate and existing-quarter protection
• Mandatory post-write reconciliation
• Immutable publish history and quarter lock