Name | Date | Size | #Lines | LOC | ||
---|---|---|---|---|---|---|
.. | 18-May-2020 | - | ||||
ooolib2/ | H | 18-May-2020 | - | 1,988 | 1,626 | |
tests/ | H | 03-May-2022 | - | 47 | 38 | |
GPLv3 | H A D | 18-May-2020 | 34.3 KiB | 675 | 553 | |
LICENSE | H A D | 18-May-2020 | 703 | 15 | 11 | |
README | H A D | 18-May-2020 | 2.8 KiB | 101 | 71 | |
bank-reconcilation.plx | H A D | 18-May-2020 | 7.6 KiB | 233 | 184 | |
cash-receipts-and-disbursments-journals.plx | H A D | 18-May-2020 | 7.8 KiB | 204 | 108 | |
csv2ods.py | H A D | 18-May-2020 | 9.9 KiB | 234 | 177 | |
demo.sh | H A D | 18-May-2020 | 996 | 46 | 30 | |
fund-report.plx | H A D | 18-May-2020 | 7.9 KiB | 236 | 169 | |
general-ledger-report.plx | H A D | 18-May-2020 | 9.1 KiB | 225 | 162 | |
readcsv.py | H A D | 18-May-2020 | 1.1 KiB | 32 | 8 | |
summary-reports.plx | H A D | 18-May-2020 | 19.7 KiB | 466 | 369 | |
unpaid-accruals-report.plx | H A D | 18-May-2020 | 3.9 KiB | 111 | 66 |
README
1README 2 3This document provides backround on the enclosed example 4 5Demo 6---- 7To run the demo do 8./demo.sh 9 10Which should generate the following files in tests/ 11 chart-of-accounts.txt 12 general-ledger.txt 13 general-ledger.csv 14 general-ledger.ods 15 16And a final, "portable" zip file with the spreadsheet in 17 general-ledger.zip 18 19It *should* be possible to copy general-ledger.zip to another system, 20unzip it, open general-ledger.ods in Libre Office and have the relative 21links resolve correctly. 22 23NOTE: Export to PDF should also work. 24 25 26Known Dependencies 27------------------ 28ledger (3.0) 29python (2.x) 30zip 31libdate-manip-perl 32libmath-gmp-perl 33 34 35Temporary Hacks 36--------------- 37Due to an urgent project deadline the ooolib2 directory 38represents some fixes to: 39 http://ooolib.sourceforge.net/ 40 41The proper version of this library can be installed on Debian systems with 42# apt-get install python-ooolib 43 44Compare the deltas to the current version with 45# diff -u /usr/share/pyshared/ooolib/__init__.py ooolib2/__init__.py 46 47Note also that the csv2ods.py treats columns 4 and 5 (numbering from 1) of the csv 48magically. If column 4 contains a non-empty string which is not 'Receipt' 49then it is interpreted as a relative path of an artifact to link to. 50Similary for column 5 and 'Invoice'. 51 52 53Sample PDF files 54---------------- 55The sample PDF files were created as follows: 56 57paps --font="Courier 12" --paper letter --top-margin=18 tests/Projects/Foo/Expenses/hosting/AprilHostingReceipt.txt | ps2pdf - tests/Projects/Foo/Expenses/hosting/AprilHostingReceipt.pdf 58 59paps --font="Courier 12" --paper letter --top-margin=18 tests/Financial/Invoices/Invoice20110510.txt | ps2pdf - tests/Financial/Invoices/Invoice20110510.pdf 60 61 62Resources 63--------- 64ooolib 65 http://ooolib.sourceforge.net/ 66 67LIBPF 68 probably does not replace ooolib 69 http://wp.libpf.com/?p=82 70 71Libre Office Calc Guide (contains function reference) 72 https://www.libreoffice.org/get-help/documentation/ 73 74Libre Office API 75 http://api.libreoffice.org/examples/examples.html 76 http://api.libreoffice.org/examples/DevelopersGuide/examples.html 77 78OpenOffice Developers Guide 79 http://wiki.openoffice.org/wiki/Documentation/DevGuide/OpenOffice.org_Developers_Guide 80 81Spreadsheet Documents 82 http://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Spreadsheet_Documents 83 84How to correctly create ODF documents using zip 85(Do NOT do this, use ooolib instead) 86 http://www.jejik.com/articles/2010/03/how_to_correctly_create_odf_documents_using_zip/ 87 88Line Breaks 89 fo:break-before="page" 90 http://books.evc-cit.info/oobook/ch03.html#page-content-section 91 92ODF Validator 93 http://opendocumentfellowship.com/validator 94 95Editing Hyperlinks 96 http://help.libreoffice.org/Common/Editing_Hyperlinks 97 98Perl OODoc 99NOTE: a replacement for POD, not ooolib 100 http://search.cpan.org/dist/OpenOffice-OODoc/ 101