ExportCheck 1.0.0 Selected work

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/orders
exit 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.

Inputorders.csv
0 bytesSHA-256
rules.json sample rules
Resultruns/orders

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.

Saved Python output compared with the output of this page
InputExit codeclean.csvrow-errors.csvsummary.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.

Error outputexit 3

        
Result files in runs/clean, before and after the second run
FileBytesSHA-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