Fil-Vision Inc. is a local CATV provider in Roxas City, Capiz. Initially they were using a MS-DOS based billing system written using dBase III. Problems inherent with the old system were data corruption due to power failures, referential integrity issues caused by direct edits to the .DBF files, and limited reporting capabilities. I wrote a custom Java-based DBF exporter to export the contents of the old database to SQL files. This is a complex project with many quirks relating to de facto business practices within the organization (i.e., dealing with leap years and 30/31 dates).

Toolchain

  • Java
  • Netbeans RCP 8.1
  • H2 Database Engine

Components

  • Subscriber database
  • Billing system
  • Report generator

Screenshots

Billing UI design
Billing UI design
Billing UI running
Billing UI running
Subscriber billing code
Subscriber billing code
Subscriber details panel
Subscriber details panel
Subscriber details UI design
Subscriber details UI design