OpenSparrow v3.7 brings an automation email queue to the admin panel and unifies the entire admin UI around a single section-card pattern. The email queue gives admins full visibility and control over outgoing automation emails — filter, requeue, bulk delete, purge — while the rest of the release is a consistent overhaul of how admin screens are built: one card style, one width, one typography scale, one statistics tile pattern. Below is a breakdown of what changed and why it matters.
Automation email queue
A new section in Admin → System → Cron lists the queued automation emails stored in the existing spw_automation_emails table. Until now those rows were written by the notification cron but invisible from the UI — if a message bounced or sat undelivered, there was nowhere to see it.
- Filter the queue by status — pending / sent / error — with live per-status counters
- Bulk requeue resets the attempts counter and error message, so failed sends retry cleanly
- Bulk delete works on up to 500 rows at once
- Purge by status, optionally limited to entries older than a configurable retention window
The queue tab reports a missing table instead of failing, so an instance that never ran email automations degrades gracefully.
RAG document preview
A Preview button in the Centrum AI documents list opens a modal with the stored document content — filename, tags, size and dates included — so you can inspect what the RAG pipeline actually chunked without downloading the file. The rechunk action now shows success feedback, and the documents table respects container width with vertically stacked action buttons on narrow screens.
The RAG section is now Centrum AI
The admin section formerly known as RAG is renamed to Centrum AI across the sidebar, breadcrumbs, demo copy and guidance docs. The RAG settings fields gained explanatory tooltips covering context-file limits, upload size and timeout constraints — previously you had to check the docs to know what a field accepted.
One admin UI pattern instead of twenty
The bulk of the release is invisible until you open two tabs side by side. Every settings form, data table and log in the admin panel now renders inside a buildSectionCard section with a consistent header style:
- Section cards are never nested — one card is one section, a tab is a flat sequence of cards in reading order
- All settings tabs share one width via the
.admin-pagewrapper; per-panelmax-widthinline styles were removed - Statistics and log tabs (External API Usage, Click Statistics, Cron email queue, Users) follow the same tile-grid pattern as Centrum AI → Query Statistics
- Typography was unified to three sizes and two weights via CSS tokens;
.adm-sec-hdrstyling now lives in the stylesheet instead of inline overrides
Fixed
Admin tab renderers no longer wipe section descriptions when re-rendering a tab — content is now rendered into the inner content div instead of replacing the whole panel.
Upgrade note
No database migration and no configuration keys are removed by this release. The email queue operates on the existing spw_automation_emails table (created by earlier releases); if the table does not exist, the queue tab says so instead of erroring.
Following this series?
OpenSparrow v3.6 — External API Module with Encrypted Read-Only Keys
