Posts for the month of December 2008

SQLite and ODBC for Data Entry

The one downside of all the good database systems is the lack of an easy tool for entering data, especially coding in data off of hand written field forms.

I recently revisited the idea of using Open Office Base or Access as a front end to better databases. In this particular case due the number of issues and my familiarity I got Access working, I plan to go back and also get OOo working next chance I get and taking over my friends windows box (The data entry is for her anyways).

Tools: sqlite-odbc driver (I tested it on Windows and Linux) An ODBC client: Access, Excel, Open Office Base, Calc

Issues:

  1. All your tables must have a primary key declared.
    1. If you don't have one it's real quick using the Firefox SQL Manager to fix that, however you have to make new tables), something like this.
      CREATE TABLE NewData (pk INTEGER PRIMARY KEY AUTOINCREMENT, Afield, someotherfield);
      INSERT INTO NewData (Afield,someotherfield) SELECT * FROM Data;
      DROP TABLE Data;
      ALTER TABLE NewDATA RENAME TO Data;
      
  2. Declaring field types as TEXT, Access will import them as blobs if you do and this makes linking the tables difficult. Just drop the type.
  3. The Relationship tool in Access and Open Office are useless with linked-tables in this case. OO tells you so, Access doens't.
    1. To get around this I created nested forms each based on 1 table. When inserting a nested table into another I built in the relationship to the form so that for every record in the parent child records would be matched automatically.

More details to come soon...

List of useful links:

  • a
  • b

Ever wonder what's in the box without, shutting down and crawling under...

A few helpful commands I'm collecting to figure out what's inside the machine from the Command Line Interface (CLI):

$ sudo dmidecode | more
#A readout from your motherboard, give you name, model, which ram slot's have chips etc.
$ cat /proc/cpuinfo
#What processor do you have?

Setting up Trac, getting past the errors.

So I thought the install would go smooth but a few hiccups always creep in.

Basically I followed these  instructions and another page for  authentication

With some diligent work I worked through: (make sure to look at your apache logs, mines at /var/log/apache2/error.log)

  1. mod_python is the way to go in terms of setup, speed etc.
  2. Get an IOError: zipimport: go check the permission on the mentioned file, make sure it's at least 644 example:
     sudo chmod 644 setuptools-0.6c9-py2.5.egg
    
  1. Python Option and Set Env PYTHON_EGG_CACHE flat out didn't work for me though as  reported and worked around, although a fix to the code eludes.
  2. Import Error on compat, take a look at this  ticket

Welcome to Wildintellect's Blog

Hello and welcome to my blog and code hosting site. If you're looking for my photography that's currently down for a major rewrite.

This site is more oriented towards the geek details to keep the world running, and most importantly to serve as my memory since I clearly can't remember things for more than a couple of hours.

Alex aka Wildintellect

  • Posted: 2008-12-18 23:40 (Updated: 2011-06-16 18:42)
  • Author: wildintellect
  • Categories: (none)
  • Comments (0)

Just started, will it work

Well, I've got it installed. Not 100% configured yet but we'll see if this manages to work as a decent blog platform.

For those curious I'm using the  FullBlogPlugin with a  Trac site. Not exactly meant for a blog, but it will let me post code snippets and downloadable applications I write, including python eggs.