bilbiware


bilbi

Introducing
BilbiWare

Introducing BilbiWare

Welcome to the Website of the BilbiWare Community Register software. This is a custom-built product, which was designed to meet the particular needs of community support registers.

It provides a wealth of functionality with unique capabilities and a surprisingly small footprint on a modest PC platform. While it was originally developed for the particular needs of the Bellarine Police Community Support Register, it has now been adapted for use by other community support registers throughout Australia.

Cost Effective, Custom Designed Software

BilbiWare was developed with cost and resource constraints in mind. It was written to operate on the earliest most popular operating systems and PC configurations currently in use by Victoria Police. It provides the kind of functionality that much larger general-purpose programs would not be able to offer without significant retooling and development, exceeding the effort required to build BilbiWare in the first instance.

The BilbiWare software package grew out of the fact that there was no specific commercial solution available to start from. Generic database management systems proved to be too complex to manage by volunteers without specialised training. Error trapping and self-auditing is also a feature of BilbiWare that goes beyond what existing software packages and systems could immediately provide.

The availability of vertical market software is shrinking; specialist software becomes more difficult to write for more sophisticated, modern systems. BilbiWare is software that does its very specific set of jobs well, demonstrating that dedicated simpler systems can provide more effective solutions than larger, generic ones.

In-depth

The first section introduces BilbiWare as a dedicated information system in its original customer-driven environment. It sets the stage for the reader in explaining the purpose of the software, and how the software performs its role as an information processing system.

The second section describes the BilbiWare software architecture, and the components it relies on to function. It also outlines the system requirements for the software, and its intended workflow.

The remaining contents illustrates the many of the features of BilbiWare, and how the software is used in support of these features.

Lastly, the contact details are shown linking you to the Bellarine Police Community Support Register Inc., the current licensor of the software, who offer licenses and other start-up support to new Community Support Registers, and to BilbiWare Database Design and Administration.

Top of page >>

bilbi

Preface

Preface

There are various reasons why specifically tailored software is better than a generic database management system:

Performance
Performance often is not a measure of sheer computing speed or program size. Rather, it is a measure of efficiency, well-designed architecture, precision of coding, and the tailoring of specific outcomes.
Usability
Bigger is not better in some cases. Specifically tailored software is easy to use, in a manner that lets you work with little distraction or interruption.
Reliability
Specifically tailored software operates without unexpected behaviour. This is achieved with specific design and high quality of software construction and implementation that included nearly two years of careful observation of user behaviour.
Suitability
Specifically tailored software is lean and fast, because it only does the one task.
User Friendly
The aim of the BilbiWare project is to produce an electronic register that is easy to use by users, some of whom may have limited skills using computing systems.

Custom Design Software

BilbiWare is a software overlay for a set of Microsoft Access 2003 database tables providing a highly controlled user interface and reliable program logic for the control of data. The user interface is designed to help reduce data entry mistakes of the sort that later cause search difficulties. For example, the user interface provides active data entry controls so that data is predictable and consistent between various related fields, such as Mr, Mrs, versus male and female respectively.

Input Assistance and Data Management

Data entry is assisted by using pop-up pick lists so that repetitive data are selected rather than re-typed by operators. This avoids inconsistencies between related entries and makes data search and matching fast and reliable. Other convenient features include automatic regular printing of audits, logs and reports of various formats, a statistics generator, and other reporting tools.

The kinds of data that BilbiWare manages are the questions typically asked on a registrant’s application form, i.e. personal information such as name, address, health status, names of doctor and chemist, next of kin data, the existence of extra house keys outside the residence, pets in the home, and call schedules for those who wish to receive care calls from the Register.

Data Security

As an application that manages sensitive information, stringent security and auditing features protect the database records and make it easy to account for access to that data.

The features provided by BilbiWare are all implemented using Microsoft Access for storing the data tables, but otherwise it runs on its own accord. No other software subsystems are required to operate BilbiWare. This makes software installation and maintenance easy.

Network Independence

BilbiWare does not require network services. Everything that BilbiWare does is limited to files on local storage devices. Thus, PCs that run BilbiWare are isolated from the Police network for additional security.

However, there are other ways to export data maintained by BilbiWare, where circumstances require it, to removable media such as flash memory devices, external hard disks, or to text files that can be e–mailed. As all data transfers are actively initiated by the administrator of the BilbiWare program, there is total control over information distribution.

There is nothing, however, to prevent the use of network file system servers that can be configured to operate as locally attached storage, but this is a policy issue of the licensee, rather than a technical issue with BilbiWare.

User Friendly

BilbiWare does not require users to have knowledge of Microsoft Access or programming in order to operate it. The software is self-explanatory, with built-in context–sensitive help, and additional user interface safeguards to minimise mistakes in entering data. Because BilbiWare introduces a simple, clear interface to users, training and support requirements are substantially reduced to a level applicable to computer users who have done nothing more but used a word-processing program. The software program comes with a detailed illustrated how-to manual, and additional manuals for the administrator and the office coordinator. These are supplied as PDF (Portable Document Format, viewed with Adobe Acrobat Reader) and can be displayed on the user's desktop, as well as printed out.

Top of page >>

bilbi

Software Architecture & System Requirements

Software Architecture & System Requirements

The following hardware and software is required to run BilbiWare:

  • A personal computer that runs the 32-bit x 86 version of Windows XP Home or Professional;
  • 512 MB of RAM; or
  • A personal computer that runs Windows Vista Professional or Windows 7 Professional, which include a virtual disk running Windows XP Home or Windows XP Professional;
  • A USB port for exporting and backing up data; and
  • Microsoft Access 2003; and
  • Adobe Acrobat Reader (freely available from Adobe's web site).

Optional equipment required:

  • USB flash-RAM memory sticks;
  • An external back-up medium (external hard disk)
  • A locally attached or network printer.

The BilbiWare software comes in two sets:

  • The BilbiWare Program for the main Register Office where all data entering and editing is done;
  • The BilbiWare Program for read-only users for the associated Police Watchhouse.

The Main BilbiWare Program

The BilbiWare software, and its Microsoft Access database and configuration files, are installed on a computer in the main Register Office where data are added and modified.

There are three levels of access to BilbiWare:

  1. Administrator and Deputy Administrator;
  2. Coordinator (Office Manager);
  3. All other users,
each with decreasing levels of functionality. Access to the BilbiWare is by user name and password for each user. These are stored in a hidden database with a separate password. In turn, information stored under the categories of Registrants, Chemists and Doctors also have their own passwords, only known to the administrator and deputy administrator. The support text files are hidden and read-only.

The Read-Only Interface to BilbiWare – Suitable for Use by the Associated Police Station

There is an associated Read-Only version of BilbiWare for users who are to have read-only access on the local computer system where copies of the databases are deployed.

This is a simplified Read-Only version of the full program, allowing instant inspection of all the registrants' records. It allows the printing out of registrants' records, either as a hard copy or as a desktop file. The desktop file can then be attached to an e-mail that can be delivered to other emergency services. The program allows searching the data by surname or by street address.

The Read-Only version also allows users to inspect the register usage statistics, and also features data access logs showing when and for what purpose the data is accessed by Police Members.

Transportation of data is by supervised USB memory devices, (unless special arrangements are made to have PCs connected to a network*), thus absolutely isolating the program and guaranteeing the security and integrity of the data while also maintaining the integrity of the Police computer system.

* BilbiWare is intended not to require network connectivity for its activities, thus bypassing issues relating to connectivity costs and network security.

Top of page >>

bilbi

Presentation, Features & Program Usage

Presentation, Features & Program Usage

Data Storage of Particulars

Essentially, the kinds of data that BilbiWare will request for storage would be the particulars of the registrants, as provided by the registration forms that registrants complete. The program also calculates the age of each registrant.

Apart from all the registrants' particulars, the program stores the names and addresses of all medical practitioners and chemists. The program links these with the registrant records, i.e. each registrant's record shows their doctor and chemist. From there, a direct link is available to the actual record of the doctor or chemist. The doctor's (and chemist’s) record in turn provides a list of all their patients who are registered. A link is available to go back to the registrant's record from there.

A registrant’s record shows whether they are living with another registrant(s), and a direct link toggles the user to the other resident’s record. Any edit made in the address particulars of any registrant automatically shows up in the records of all other registrants living at the same address.

The names of all locations can be entered via pop-up menus. These menus contain all the locations and postcodes provided by Australia Post countrywide. This convenience ensures uniform entries and accurate filtering functions. It also ensures that envelopes and mailing labels are configured in the Post Office-preferred manner. All of these pop-up menus can be edited and added to by the user or the coordinator.

There are a number of other pop-up menus and pre-programmed and built in, including a Date Picker for easy and error-free date entry for Australian dates.

No registrant record is ever erased. The records are simply archived by marking them as resigned, moved or deceased, and hence no longer appear on lists and summaries, but continue to be included in the statistics. Moved in this context means the registrant has moved away from the geographical area covered by the register. Archived records can still be accessed for reference purposes, as read-only displays.

Registrants' records can be located and opened in four ways:

  1. By alphabetic search (full surnames) available from menus;
  2. By ID number;
  3. By alphabetic quick search (partial surnames) – a quicker search method available from all records as well as menus;
  4. By address search (location, street, street number).

All searches are instantaneous and require only one or two mouse clicks.

User Interface Functional Design

BilbiWare's user interfaces are intuitive and easy to understand. Instructions are given for every step, either next to the field in use, or in a context-sensitive help region at the bottom of the application window.

The programs are menu-driven with clear labels and descriptions, in logical sequences, allowing the user to go forward and backtrack.

History Logs

BilbiWare maintains logs of every entry, edit and deletion in every data item to a general monthly log file, as well as onto an individual history log file for each registrant. These logs can be inspected by administrators and coordinators only, for error tracking and training purposes. The individual history logs are printed out automatically whenever a registrant record is archived (i.e. the registrant has been marked as resigned, moved or deceased).

Audits and Auto-Correction

BilbiWare contains a feature that conducts an audit of all the fields in all databases. Users are prompted once a week to run it, in order to check and make repairs to a variety of errors automatically. The records that cannot be repaired are displayed on a list, which is then printed out for the users to follow through and correct. The audit is also a first resort diagnostic tool for administrators and coordinators to track input errors by inexperienced users.

In addition, the program contains a multitude of error alerts that warn users when they have made mistakes. Many fields also have automatic self-correction and editing features, as well as some spell-checking.

Statistics

BilbiWare calculates and prints out cumulative and monthly statistics, by gender, seven age groups (Australian Bureau of Statistics categories), all the locations in a specified precinct or locality, and a dozen other characteristics of the registrants.

These characteristics include:

  • Living in shared home;
  • Having next of kin;
  • No English spoken at home;
  • Requiring interpreter;
  • Requesting to be called regularly by our volunteers;
  • Being connected to an Emergency Service (e.g. Vital Call);
  • Living with pet animals;
  • Having medical condition(s);
  • Having disability or handicap.

The above detailed statistics are calculated on all currently active registrants. Because no registrant record is ever deleted from the database, the statistics functions also provide cumulative totals of all people joined or marked as resigned, moved or deceased.

It also calculates and prints out referral statistics and the countries of origin and languages spoken by registrants.

Filtering Functions

The program allows users to filter names of registrants by up to 5 criteria at once:

  • Status (active, absent, deceased, moved, or resigned);
  • Gender;
  • Age (ABS age groups or any other preferred grouping);
  • Location.

Plus one other characteristic, as follows:

  • Living with house partners;
  • Living alone;
  • Wanting contact by e-mail;
  • Having medical condition(s);
  • Having no medical condition(s);
  • Having disability/handicap;
  • Having no disability/handicap;
  • Needing interpreter;
  • Having next of kin;
  • Having no next of kin;
  • Being on regular calls list;
  • Not being on calls list;
  • Connected to an emergency system;
  • Not connected to an emergency system;
  • Having a spare house key externally;
  • Not having a spare house key;
  • Having an external key safe;
  • Having no external key safe;
  • Living with pets;
  • Living without pets;
  • Having back-up for pets;
  • Not having back-up for pets

In addition, the above filtered lists can be subdivided into lists of people with e-mail and people without. Filtering also provides printing facilities for printing lists of people who have a birthday in any given month, and a list of e-mail recipients.

These lists can be printed out as contact lists, and/or as mailing labels, and/or as mail-merge details. Running totals of each selection can be generated in the reports that have a filter applied, thus providing statistical information in addition to that generated monthly.

Daily Care Calls

The program generates and prints an instant daily list of all the registrants who have requested regular or periodic care calls.

Other Printing Features

The program furthermore provides these additional printing features:

  • Personalised welcome correspondence;
  • An ID Card insert suitable for lamination;
  • Key tag inserts;
  • Follow-up check lists for volunteer to make sure that new registrants have received and understood everything;
  • A File History Sheet;
  • Any other mail merge letter;
  • Envelopes (3 standard sizes);
  • A file copy of all the registrant’s record particulars;
  • A history of all entry traffic and changes for every record (printed upon closing a record);
  • A list of registrants absent from their residence;
  • A contact list, mailing labels and envelopes for all doctors and chemists.

The correspondence is pre-programmed but can be edited by administrators, should circumstances change. The size of the mailing labels can also be edited if the users change their suppliers.

Authorisation of Users

Users are issued with a user name and a password by an administrator or deputy administrator. They determine the level of access by the users, (that is, as a regular user or as a coordinator).

Back-up Procedures

At the end of each work session, the users are prompted to use the BilbiWare's automated back-up procedure to back up the database files onto a USB memory device. Administrators can also organise additional backup procedures employing other technologies, (such as Windows Backup to another hard drive or to CD) as supportive backup strategies.

Reliability

The latest version of this software has now been running for two years, without loss of data or any other problems. Many improvements have been made progressively in response to user behaviours.

Top of page >>

bilbi

Training & Support

Training & Support

Volunteer users of the BilbiWare Community Support Register Software do not need to know how to write computer programs, nor how to program or operate a generic database management system. It is assumed that users should have basic computer skills and are familiar with using Microsoft Word in Windows, and with basic Windows commands and conventions.

Individual Training

Each new volunteer user is provided individual training by the site administrator until they are ready to manage independently. Further day-to-day support is given by the Coordinator. Throughout the BilbiWare program there are 'Help Hints' panels, where instructions are given, field by field, for the necessary actions. Users can also view the program's 'Help Manual' (PDF format) on their desktop.

The Bellarine Police Community Support Register Inc. offers further training for a fee.

Top of page >>

bilbi

Licensing BilbiWare

Licensing BilbiWare

Licensing to other Community Support Registers in Australia

This section pertains to the BilbiWare product to authorise its deployment at a specific customer site. Licensing terms and conditions mentioned in this section are determined by the Bellarine Police Community Support Register Inc. and are subject to change without notice.

The Bellarine Police Community Support Register Inc. (BPCSR) has been appointed as the distributor for this software. The Committee of the BPCSR determines the price for a site license for the software from time to time. This fee constitutes a means of raising funds for the BPCSR and does not benefit the author, other than to defray his expenses in connection with installing and maintaining the software, and training an administrator in the new sites.

The BPCSR will supply a numbered copy of the software to the new user, together with a copy of the manuals. A nominated representative of the BPCSR will install the software on the users’ PCs and train a site administrator. The site administrator will then be responsible for maintaining the system, and for training volunteer users.

Telephone and e-mail back-up will be provided by the BPCSR for an agreed time.

The material is supplied on the written undertaking of the new user not to copy and hand out such copies to other non-licensed parties.

Before deciding to apply, an interested Community Support Register would have to be aware of the following:

Software Compatibility
The software was developed to be compatible with Microsoft Access 2003. It is not compatibility with other versions of Microsoft Access.
Operating System Dependence
The BilbiWare software was written on the Microsoft Windows XP operating system. Windows Vista or Windows 7 may not run it reliably, other than by using a Virtual Disk which contains Windows XP as a guest operating system.
User Requested Changes to the BilbiWare Program
If a new client register adopts the format of the registration form used by the BPCSR, the software is usable in its present form. However, any change would require some re-programming of the database and of the BilbiWare Program, and would increase the lead time of delivery and installation. An extra fee would have to be charged for this type of work.

Top of page >>

bilbi

Bellarine Police Community Support Register Inc.

Bellarine Police Community Support Register Inc.

The Bellarine Police Community Support Register Inc. (BPCSR) is a not-for-profit organisation, mainly funded by voluntary charitable donations. It is a joint initiative between the Bellarine Police (Victoria Police) and a group of citizen volunteers and was founded in 2006.

It has established a database of households and residents in the Bellarine Peninsula (Victoria), where residents can choose to register their personal particulars, contact details, information on their health, the names and contact details of their doctors and chemist, next of kin and spare key holders, and particulars of pet animals on the premises. This information is given voluntarily and kept in a secure manner by the BPCSR. It can only be accessed by designated Police in cases of a mishaps or emergencies concerning either the resident or the resident’s home. It may, at the Police’s discretion, be shared with other emergency personnel, e.g. Fire Brigade officers, Ambulance Service officers or State Emergency Service officers.

Keeping Registrants Informed

BPCSR volunteers also make regular phone calls to registrants who request such calls, to ascertain their welfare. The volunteers do not counsel registrants but can provide contact information to other community support facilities. Three to four newsletters a year keep registrants informed.

A Phone Link service organises telephone links between registrants who want to be in regular contact with each other.

Analysis of the Register's Effectiveness

A survey was conducted and evaluated after the 2009 catastrophic bushfires to probe the needs of registrants. The ideas and suggestions that flowed from this were passed on to Police and the State Government. Further surveys are planned in the future, depending on funding.

The Register’s effectiveness was externally audited by academics of Deakin University after the first two years of its inception and was found to be achieving its stated goals.

Bellarine Police have found this service invaluable as it has helped them in the course of their duties, and has helped a number of registered individuals in emergency situations. Calls have been received from police interstate and overseas to help them locate next of kin of registrants.

Staffed by Volunteers

The BPCSR is staffed entirely by volunteers. Every volunteer undergoes a yearly Police check. The Register relies on its volunteers, on fund raising and on donations to function and to give its services to the community and the Police for no fee.

The BilbiWare database software was programmed and donated by Markus Stadler as a volunteer, and is audited and maintained by volunteers.

Support of Other Community Support Registers

The BPCSR is the appointed distributor of the BilbiWare software and offers licenses and training to other Community Support Registers.

In addition, the BPCSR are willing to hand over a folio containing all their forms and protocols to new registers to help them get off the ground, for no extra charge.

Top of page >>

bilbi

Contact Information

Contact Information

BilbiWare Software Licensing Enquiries

Address:

Bellarine Police Community Support Register Inc.
Bellarine Police Station,
67-69 The Parade,
Ocean Grove, Victoria 3226

Postal Address:

P.O. Box 819,
Ocean Grove, Victoria 3226

Telephone:

03 5255 3968

E-mail:

Bellarine Police Community Support Register Inc. >>

Web Site:

Bellarine Police Community Support Register Inc. >>

BilbiWare Technical Enquiries

E-mail:

BilbiWare Database Design and Management >>

Top of page >>

bilbi

BilbiWare Legal Disclaimer

Legal Disclaimer

Licensing Contracts
Any licensing contracts are a legal agreement between the Bellarine Police Community Support Register Inc. (the licensor) and the licensee.
The author of Bilbiware is not a party to any such contract.
Product Warranty
The author has extended no product warranties to the licensor, and in turn, the licensor is not in a position to extend any product warranties.
Prospective Licensees
Prospective licensees are welcome to inspect the software at premises of the licensor, by appointment, before they commit themselves to a license.
BilbiWare Intellectual Property Copyright
The BilbiWare Program and BilbiWare Logo are the intellectual property and copyright of Markus Stadler 2010.
Microsoft Trademarks
Microsoft, Windows, Windows XP Professional, Windows Vista Business, Windows 7 Professional, Visual Basic 6, Microsoft Access 2003 are registered trademarks of Microsoft Corporation in the United States and other countries.
Adobe Trademarks
Adobe, the Adobe logo, Acrobat, and the Adobe PDF logo are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States and/or other countries.

Top of page >>