Ana Sayfa / Kod ve Scriptler / Spreadsheet Migration QA for Python

Spreadsheet Migration QA for Python

Bu Python eklentisi, elektronik tablo geçişlerini eksik kimlikler, kaybolan değerler ve eşlenen alan uyuşmazlıkları açısından denetler.

  • Yayın tarihi11 Kasım 2026
  • Paket içeriği.py, .json, .md
  • Son güncelleme12 Kasım 2026
  • Canlı demoVar
Spreadsheet Migration QA for Python

Overview

A small, dependency-free Python checker for the moment after a spreadsheet or database migration, before you tell anyone it worked. It compares the source CSV and the destination CSV record by record and reports what doesn't line up: missing or unexpected record IDs, duplicate IDs on either side, source values that may have been lost, record-count differences, and multiline notes that should have been flattened.

It deliberately does not guess. When a value could have moved somewhere ambiguous, the tool doesn't move it or bless it — it puts the record in a review queue for a human. With an optional field map (a small JSON file), it also checks agreed field placement exactly — value for value, including case, whitespace, and empty cells — even when the destination renamed the column. The command-line version exits 0 only when every check passes, so it can gate a delivery.

You get it two ways, sharing the same checked code: a command-line tool for scripts and repeat runs, and a desktop app for one-off checks — pick both files with a file picker, type the column names, read the findings, and save a JSON report. The app refuses to save a report over a spreadsheet you checked, and changing any input clears the old result, so a stale pass can never ride along.

What it does:

- Missing, unexpected, and duplicate record IDs — on both files

- Lost-value scan: source values that appear nowhere they should in the destination

- Optional field map checks exact values in agreed destination columns, renamed headings included

- Multiline-notes check for cells that should have been flattened during the move

- Record-count comparison and a clear pass/fail summary; exit code 0 only on a full pass

- Desktop app with file pickers and saveable JSON reports, verified end to end (see below)

- Demo files with fictional data: a clean migration, a missing record, and swapped fields — see all three outcomes

- No dependencies, no network: it runs on the two CSVs and nothing else

What's inside the download:

- data_mapping_qa.py — the complete checker (Python standard library only)

- desktop.py — the desktop app, sharing the same audit code

- README.md — what it is and how to run it

- INSTALL.md — step-by-step setup

- USER-GUIDE.txt — the full usage guide

- THIRD-PARTY-NOTICES.txt — what it's built on (standard library only, nothing bundled)

- demo/ — sample source/destination CSVs, a field map, and the reports they produce

- test_data_mapping_qa.py — the test suite (19 tests)

- LICENSE.txt — license terms for this download

How you run it: you need Python 3.9 or newer and nothing else. Point the checker at the two CSVs and the ID column, or open the desktop app and pick the files. Reports can contain source data — share them only with the people allowed to see it.

Verified before listing: the full test suite passes, and on November 11, 2026 the desktop workflow was exercised end to end on a fresh copy — clean pair passes, missing record and swapped fields are caught, report saving works, and saving over a source file is refused with the source left byte-for-byte unchanged.

One honest note: the checker flags records for human review; it never fixes a migration for you, and it reads CSV only — export from Excel to CSV UTF-8 first. This package is the Python source edition; no compiled Windows installer is included.

You pay once — there is no subscription and no account to create.