root / pykota / trunk / openoffice / README @ 3561

Revision 3561, 3.7 kB (checked in by jerome, 11 years ago)

Changed copyright years.

  • Property svn:eol-style set to native
  • Property svn:keywords set to Author Date Id Revision
Line 
1# $Id$
2
3PyKota - Print Quotas for CUPS
4
5(c) 2003-2013 Jerome Alet <alet@librelogiciel.com>
6This program is free software: you can redistribute it and/or modify
7it under the terms of the GNU General Public License as published by
8the Free Software Foundation, either version 3 of the License, or
9(at your option) any later version.
10
11This program is distributed in the hope that it will be useful,
12but WITHOUT ANY WARRANTY; without even the implied warranty of
13MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
14GNU General Public License for more details.
15
16You should have received a copy of the GNU General Public License
17along with this program.  If not, see <http://www.gnu.org/licenses/>.
18
19====================================================================
20
21This directory contains some screenshots of direct access to PyKota's
22database through OpenOffice.org, as well as a sample report in both
23PDF and OpenOffice.org's sxc format.
24
25The sample report is a Jobs per User diagram, created from a
26simple SQL query to PyKota's database from within OpenOffice.org
27
28Since it works but I don't know OpenOffice enough to do something
29really nice with it, I've added these screenshots and here's a small
30howto below. For people interested in a more complete howto, please
31see : http://kandalaya.org/download/oo-pgsql.html
32
33PyKota + PostgreSQL + OpenOffice.org HowTO :
34--------------------------------------------
35
36        - Install and configure :
37
38          godbcconfig
39          gtkodbcconfig0
40          iodbc
41          libiodbc2
42          odbc-postgresql
43          odbcinst1
44          unixodbc
45
46        - Within gODBCConfig, add the PostgreSQL driver by
47          filling the Configure Driver form :
48
49                   Name : PostgreSQL
50            Description : PostgreSQL
51                 Driver : /usr/lib/postgresql/psqlodbc.so
52                  Setup : /usr/lib/odbc/libodbcpsqlS.so
53              FileUsage : 1
54
55          See gODBCConfig1.png
56
57          Then create a system DSN (only the more important fields
58          are listed below) :
59
60                   DSN : PyKota
61           Description : PostgreSQL access to PyKota
62                Driver : PostgreSQL
63              Database : pykota
64            Servername : your.postgresql.server.here
65              Username : pykotauser
66              Password : pykotauser's password
67                  Port : 5432
68
69          See gODBCConfig2.png
70
71        - Then in OpenOffice.org add a new data source, selecting
72          ODBC in the Database Type field. By clicking on the URL
73          field's continuation dots, the PyKota DSN should appear.
74          Just select it and you're done.
75
76          See ooo1.png
77
78        - You can now create your own queries to the PyKota database,
79          and create any report you want.
80
81          See ooo2.png
82
83        - When you've got something nice, please contribute it back
84          so we can learn from your experience.
85
86WARNING :
87
88        The above procedure doesn't work if you use the OpenLDAP backend
89        to store PyKota's datas. A similar procedure is probably possible
90        but last time I checked, the LDAP attributes accessible from
91        OpenOffice.org were limited to what one usually finds in
92        address books, unfortunately.
93
94Windows Users :
95
96        You'll find information on how to use the PostgreSQL ODBC
97        driver with OpenOffice.org for Windows at :
98
99        en: http://www.openoffice.org/nonav/issues/showattachment.cgi/3481/postgresql.sxw
100        de: http://de.openoffice.org/doc/howto/datenquelle/tech_pgsql.html
101        es: http://es.openoffice.org/files/documents/73/799/pgsql-win.sxw
102
103        Thanks to Johannes L�ermann for this information.
104====================================================================
Note: See TracBrowser for help on using the browser.