Fishing Boat Ledger handling
Posted by mholmes on 21 Sep 2015 in Activity log
Met with AC and SA about the fishing boat ledger data. This is currently in an Excel spreadsheet, which is OK, but we want to make it more accessible, so I've now added a bunch of processing to the build which:
- Uses headless libreoffice to turn it into a FODS file (I had to install libreoffice-common, libreoffice-writer and libreoffice-calc on the server).
- Cleans up and expands the FODS file a bit.
- Generates an XML document from each record/row.
- Generates and HTML doc from each record.
Tweaked the XML CSS to make the XML readable; the HTML is very rudimentary and needs work. After that, I'll generate a bunch of indexes of various kinds (by name, by vessel, by date, by amount, etc.) or maybe a single table that contains columns for these, which is sortable.
This entry was posted by Martin and filed under Activity log.