Changeset 3413 for pykota/trunk/openoffice
- Timestamp:
- 09/27/08 22:02:37 (16 years ago)
- Files:
-
- 1 modified
-
pykota/trunk/openoffice/README (modified) (6 diffs)
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/openoffice/README
r3259 r3413 26 26 simple SQL query to PyKota's database from within OpenOffice.org 27 27 28 Since it works but I don't know OpenOffice enough to do something 29 really nice with it, I've added these screenshots and here's a small 30 howto below. For people interested in a more complete howto, please 31 see : http://kandalaya.org/download/oo-pgsql.html 28 Since it works but I don't know OpenOffice enough to do something 29 really nice with it, I've added these screenshots and here's a small 30 howto below. For people interested in a more complete howto, please 31 see : http://kandalaya.org/download/oo-pgsql.html 32 32 33 33 PyKota + PostgreSQL + OpenOffice.org HowTO : … … 35 35 36 36 - Install and configure : 37 37 38 38 godbcconfig 39 39 gtkodbcconfig0 … … 43 43 odbcinst1 44 44 unixodbc 45 46 - Within gODBCConfig, add the PostgreSQL driver by 45 46 - Within gODBCConfig, add the PostgreSQL driver by 47 47 filling the Configure Driver form : 48 48 49 49 Name : PostgreSQL 50 50 Description : PostgreSQL … … 52 52 Setup : /usr/lib/odbc/libodbcpsqlS.so 53 53 FileUsage : 1 54 54 55 55 See gODBCConfig1.png 56 56 57 57 Then create a system DSN (only the more important fields 58 58 are listed below) : 59 59 60 60 DSN : PyKota 61 61 Description : PostgreSQL access to PyKota … … 66 66 Password : pykotauser's password 67 67 Port : 5432 68 68 69 69 See gODBCConfig2.png 70 70 71 71 - Then in OpenOffice.org add a new data source, selecting 72 72 ODBC in the Database Type field. By clicking on the URL 73 73 field's continuation dots, the PyKota DSN should appear. 74 74 Just select it and you're done. 75 75 76 76 See ooo1.png 77 77 78 78 - You can now create your own queries to the PyKota database, 79 79 and create any report you want. 80 80 81 81 See ooo2.png 82 83 - When you've got something nice, please contribute it back 82 83 - When you've got something nice, please contribute it back 84 84 so we can learn from your experience. 85 86 WARNING : 85 86 WARNING : 87 87 88 88 The above procedure doesn't work if you use the OpenLDAP backend 89 89 to store PyKota's datas. A similar procedure is probably possible 90 90 but last time I checked, the LDAP attributes accessible from 91 OpenOffice.org were limited to what one usually finds in 91 OpenOffice.org were limited to what one usually finds in 92 92 address books, unfortunately. 93 93 … … 100 100 de: http://de.openoffice.org/doc/howto/datenquelle/tech_pgsql.html 101 101 es: http://es.openoffice.org/files/documents/73/799/pgsql-win.sxw 102 102 103 103 Thanks to Johannes L�ermann for this information. 104 104 ====================================================================
