Wealth Courtyard — Recovery Tool (Patch 4)

Upload many tyw-backup-*.csv exports → merge into one restore set (USERS / ACCOUNTS / TXNS) matching the Patch 4 Google Sheet headers.
Important: exports do not contain PIN hashes. After restore, admin must set PINs again.

Keep only the latest export per callsign (recommended) Deduplicate repeated transactions Include sourceFile column in txns (optional) Fill createdAt using export timestamp (recommended)

Files Loaded

Users

Accounts

Transactions

Google Sheets restore workflow (Patch 4 headers):
1) Create a new spreadsheet (or use a clean one).
2) Make 3 tabs named exactly: USERS, ACCOUNTS, TXNS
3) Import each downloaded CSV into the matching tab (File → Import → Upload → Replace current sheet).
4) Open the Wealth Courtyard app once (admin is enough) to let it auto-heal missing IDs (like txnId) if needed.
5) Admin must re-set user PINs (since exports do not include pinHash).

Preview (first 20 restored transactions)

timeISO	callsign	type	from	to	amount	note	refType	refId	sourceFile
No data yet.

This rebuilds the core ledger (USERS/ACCOUNTS/TXNS) in Patch 4 format. If you later want to restore Market offers/orders too, we can extend the backup export and extend this tool to merge them.