• Home
  • History
  • Annotate
Name Date Size #Lines LOC

..18-May-2020-

ooolib2/H18-May-2020-1,9881,626

tests/H03-May-2022-4738

GPLv3H A D18-May-202034.3 KiB675553

LICENSEH A D18-May-2020703 1511

READMEH A D18-May-20202.8 KiB10171

bank-reconcilation.plxH A D18-May-20207.6 KiB233184

cash-receipts-and-disbursments-journals.plxH A D18-May-20207.8 KiB204108

csv2ods.pyH A D18-May-20209.9 KiB234177

demo.shH A D18-May-2020996 4630

fund-report.plxH A D18-May-20207.9 KiB236169

general-ledger-report.plxH A D18-May-20209.1 KiB225162

readcsv.pyH A D18-May-20201.1 KiB328

summary-reports.plxH A D18-May-202019.7 KiB466369

unpaid-accruals-report.plxH A D18-May-20203.9 KiB11166

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