A command-line tool that checks a CSV and sets aside the bad rows.
$ python exportcheck.py --input orders.csv --rules rules.json --output runs/ordersexit 1
Input file
Edit the rows
clean.csvrow-errors.csv
Exit codes
Edit the rows or the rules
A JavaScript copy of the checks runs here. Nothing is uploaded.
0 bytesSHA-256
rules.json sample rules
Some rows were set aside
Compared with the Python tool
Saved results from the Python tool, compared byte for byte with this page on every load.
...Comparing the saved runs.
| Input | Exit code | clean.csv | row-errors.csv | summary.json |
|---|---|---|---|---|
| Comparing the saved runs. | ||||
- random CSV files tested
- 1,500
- rules files tested
- 44
- files that did not match
- 0
When a row has several problems, Python can list them in another order.
Second run into the same folder
Exit code 3. The files from the first run are not changed, checked on disk.
| File | Bytes | SHA-256, the same before and after |
|---|
What it does not do
- No currency conversion and no totals check
- No row fixing, no delimiter guessing, no Excel files
- No connection to accounting systems
What it needs
- Python
- 3.10+
- extra packages
- None
- input limit
- 5 MB
- row limit
- 10,000