Practice sandboxTry anything: add, edit, record and send. Do not enter real people, children, gifts or contact details until we move to the launched production system. Changes stay in this browser only, and nothing sends, charges or posts.Practice only. No real data.
Legacy ChurchStaff Sandbox

Migration

Parity and data quality

The Elexio export compared with our mirror, row by row. Generated 2026-10-24 15:00 UTC.

Parity: FAIL
People
204 / 205
99.5% matched · mirror 205
Households
76 / 76
100% matched · mirror 76
Memberships
203 / 204
99.5% matched · mirror 203
Cleanup queue
22
18 adults with no email · 1 import issue

Differences

Rows where the mirror and Elexio disagree. These block the flip.

4 open
IssueRecordDetail
Missing in mirrorU10203Person is in Elexio but not in the mirror
Missing in mirrorF5075:U10203Household membership not mirrored
Gone from ElexioPat Removed-Sample U19999Still in the mirror; soft-deleted after two full snapshots
Field mismatchSkyler Del Prado U10018Mirror differs from Elexio on mobilePhone

Data quality in Elexio

Fix these in Elexio, or as a re-runnable mapping rule in packages/legacy-sync, never as a one-off edit here.

4 open
IssueRecordDetail
Likely duplicateAlejandra Valemont U10012Alejandra Valemont U10204Same name and birthdate
No primary contactF5012Household has no primary contact
No householdSam Unhoused-Example U10205Person is in no household
No birthdateWren Example U10002Child with no birthdate (needed for check-in rooms)
18 adults have no email in Elexio.Archived and excluded: Ruby Example U19998

Checks

2 of 6 passing

  • People: counts equalElexio 205 · mirror 205
    Pass
  • Households: counts equalElexio 76 · mirror 76
    Pass
  • Memberships: counts equalElexio 204 · mirror 203
    Fail
  • Nothing missing in the mirror2 missing
    Fail
  • Nothing extra in the mirror1 no longer in Elexio
    Fail
  • Fields match1 field mismatch
    Fail

How this runs

Each full sync recomputes this report and stores it in legacy.parity_report. The flip waits for a clean pass.

Markdown report (as stored in legacy.parity_report)
# Elexio parity report

Generated 2026-10-24T15:00:00Z. Result: **FAIL** (counts, missing, extra and field mismatches).

| Entity | Elexio | Mirror | Matched | Counts equal |
|---|---|---|---|---|
| People | 205 | 205 | 204 | yes |
| Households | 76 | 76 | 76 | yes |
| Household memberships | 204 | 203 | 203 | **no** |

## Differences

- Missing in the mirror: people `U10203`; households none; memberships `F5075:U10203`.
- Extra in the mirror (gone from Elexio): people `U19999`; households none; memberships none.
- Field mismatches: person `U10018` mobilePhone.
- Archived in the mirror (excluded): `U19998`.

## Data quality in the source (cleanup queue)

- Likely duplicate people: `U10012` + `U10204` (same name and birthdate).
- Adults and others with no email: 18 (`U10006`, `U10030`, `U10036`, `U10048`, `U10051`, `U10061`, `U10066`, `U10068`, `U10082`, `U10098` and 8 more).
- Households with no primary contact: `F5012`.
- People in no household: `U10205`.
- Children with no birthdate: `U10002`.
- Import issues logged: 1.