Skip to content

Feature

Legacy import

Bring your history over from the Plandata MS Access app, with a report that accounts for every row.

The one-shot import reads both Access databases (the current file and the archive), merges and deduplicates them and loads 12 tables: clients, plan checks, reviews, deliveries, invoicing and the reference lists.

A dry run extracts and transforms without touching a database and prints a reconciliation report: for every table, the source rows, the rows loaded and the rows quarantined. Loaded plus quarantined must equal source, so nothing disappears silently.

A row is quarantined, and counted, when it cannot be stored: a required reference does not resolve or it breaks a uniqueness rule. The import prints counts only, never row contents.