root / pykota / trunk / openoffice / README @ 2146

Revision 2146, 3.9 kB (checked in by jerome, 19 years ago)

It seems that $Log$ is not implemented or doesn't work for some reason

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