3 ms·
I've just done the same thing. My inputs are CSV files from all over the place, and the output is a ledger file. Driven by make, of course. :) Processing the C
by beej71 3y ago
I've just done the same thing. My inputs are CSV files from all over the place, and the output is a ledger file. Driven by make, of course. :)
Processing the CSVs takes about one second per year of my data, so what I think I'll probably do is summarize it out to ledger format each year.
I was using awk to do the CSV parsing, and it's blazing fast. But it gets a little bit unwieldy if you have to do multiple passes through a file or if a single CSV file has multiple sections. So I moved them to Python which is far more capable, but slower.
- fhd2 3y agoI use a Makefile as well :D Both to glue it all together and for the most common reports I need. For turning the CSV files into Ledger, I have a binary written in Common Lisp. Suppose I tried to make accounting exciting and it worked :P