channel-e information in an electronic age.

Reporter and Data Reader Applications

Background

Our street wardens (at Calderdale) needed a data collection application for use on their handhelds. I didn't have any time for development at work so I wrote these in my own time. The wardens are using Sharp Zaurus machines.

Operation

These applications both run under a GUI. Communication with the database is via wireless network.

Reporter

This was the first application written. It allows the wardens to fill a form on the display. Drop down lists are provided for warden name and action code. These lists can be updated from the database. On returned to the office the reports are added to the database.

Data Reader

The wardens wanted to be able to search existing reports whilst out in the field. This application enables this by downloading a serialized copy of the reports table. The file is recreated every four hours by the house keeping routine in the itres application suite.

Status

No current activity in this package. The itres suite is being developed to include:

Automated messaging.
The report table will be checked for certain record types, such as abondoned vehicles. Automated e-mails will be sent to other sections to initiate action.

I want to improve the record search speed of DataReader but I don't know how.

Released under the GNU General Public License. download

History

Reporter

At version 2.3 and now quite stable.

Data Reader

At version 0.4.2. Previous versions received the report file in plain text. This version uses serialized ReportRecord objects.