summaryrefslogtreecommitdiff
path: root/contrib/non-profit-audit-reports/csv2ods.py
Commit message (Collapse)AuthorAgeFilesLines
* chore: Fix inline python format-stringsAlexis Hildebrandt2023-12-081-1/+1
|
* Migrate Python scripts to Python 3Alexis Hildebrandt2023-12-041-15/+23
| | | | Update ooolib-python to 0.1.0
* Support for title: field, to name sheets in the ODS file.Bradley M. Kuhn2013-02-181-1/+4
| | | | | If "title:SOMETHING" occurs in the CSV file, use SOMETHING as the title of the sheet.
* Support for a list of known checksums of files already copied over.Bradley M. Kuhn2013-02-181-9/+70
| | | | | | | | | | For the times when we want to make shorter names of files by doing copies of the documentation files for hyperlink usage, allow input of a new command line option which is a list in the form of: PATH_TO_FILE : sha25sum so that those files can be used rather than new copies made.
* Add --single-file-directory option: create single directory with all linked ↵Bradley M. Kuhn2013-02-181-5/+46
| | | | | | | | | | | | | | | | files. This new option copies all files to the directory specified as an argument to the --single-file-directory option, and also creates dummy shorter filenames for the files. This feature was implemented to get around a problem found when zip'ing the spreadsheet up with the supporting files for users on Windows. The Windows users encounter the error 0x80010135 related to some of the ZIP files going beyond the maximum path name length on windows. Apparently, opening ZIP files with long path names just doesn't work on Microsoft systems. I've suggested our accountants switch to a Free Software operating system, but they declined.
* More flexible CSV -> ODS hyperlinks and pagebreaks; csv2ods.py produces ↵Bradley M. Kuhn2013-01-061-17/+26
| | | | | | | | | | | | | | | | | | MANIFEST. Previous version of csv2ods.py simply assumed that fields beyond five would have links to files. This obviously lacked flexibility and was a silly hard-code. Now, those CSV fields that have link:SOMETHING will cause a hyperlink to be created to SOMETHING. Meanwhile, the pagebreak support was similarly hard-coded. Now, any CSV field that has the word "pagebreak" in it will generate a pagebreak. The general ledger and cash receipts/disbursement journals have been modified to make use of these new features in csv2ods.py. Finally, the --skip-page-break option is now moot in csv2ods.py, so that is herein removed.
* Ordering of options had always been incorrect on this call; Fixed.Bradley M. Kuhn2013-01-061-1/+1
|
* Add option to skip generating the page breaks.Bradley M. Kuhn2013-01-031-5/+9
|
* Support selection of string encoding.Bradley M. Kuhn2012-11-261-2/+7
| | | | | Allow command line option that permits specification of string encoding, passed to Python's unicode() function.
* Support a broader set of possible tags to be placed into the spreadsheet.Bradley M. Kuhn2012-11-261-1/+4
| | | | | | | | | | I've now made a hard-coded list of potential tags that are supported and will be linked to in the general ledger spreadsheet. This list should probably be in a configuration file of some sort eventually, rather than hard coded. Indeed, note that the hard-coding goes into two different scripts, and thus the lists could easily get out of sync.
* Receipt/Invoice are additional information thus better if they're final columns.Bradley M. Kuhn2012-09-081-1/+2
| | | | | | | | | Change the column of Receipt and Invoice in the CSV file first, then the generated ODS file must have the same change propagated, which requires changes to the column numbers hard-coding in csv2ods.py. Perhaps if/when this application is refactored these things shouldn't be hard-coded in this way in the first place.
* First pass technical study of creating ODS from ledgerTom Marble2012-09-081-0/+106