Legacy technical aspects for Knobjex
Below information concerns an earlier state of Knobjex in which python-code connects to a ms access database thru an odbc-connnection using pyodbc. Allthough this odbc-code has not been removed from the source-code, Knobjex now uses the database Sqlite and the module pysqlite. See Knobjex at Google Code for the current situation.
-----------------------------------------------------older info from here on--------------------------------------------------------------
I have programmed til now under a Windows-OS, and I have not yet generalized to other OS's. Furthermore, for now I have not made an executable or even looked into creating them. So when you want to use the program you have to install a programming-environment. Thus, you need the following installs:
- python 2.6 as programming-language - www.python.org
- wxPython as gui-component; currently i use 2.8.9.1 - www.wxpython.org
- pyodbc as odbc-module - http://pyodbc.sourceforge.net/
- optionally: py-scripter or some other IDE; the native one from python is a bit limited - http://code.google.com/p/pyscripter/ - or latest release on: http://pyscripter.googlepages.com/
- in order to work, pyscripter needs rpyc - http://sourceforge.net/projects/rpyc
- select python engine: menu Run \ python engine \ remote (wx)
- reinitialize after each run; or the engine might hang
- use FindInFiles to find specific strings
- get the python-code from here
- Install the Access-database.
- You need the database ofcourse; get knobjex_python.mdb from here.
- create an odbc-system-dsn ( Data Source Name ):
- Open up the ODBC data sources on your computer. Start \ Programs \ Administrative Tools \ Data Sources (ODBC). [Or your localized version of it.]
- Go to the System DSN Tab and click on the Add button to create a new Data Source
- Choose the downloaded database and name the DSN 'KnobjexProductie' (or else you must change the source-code: jodb.odbcDatabase = 'KnobjexProductie') and fill in necessary stuff.
- beware: you need an odbc-driver for MS-Access on your pc (comes with ms-access).
- run the main knobjex-module "auiframework.py"
- documentation is incodal; see the special module "pyKnow_docu.py"