Botanicus Australia Pty Ltd

VFP Vixen

VFP Vixen is a command-line utility to reindex or pack Visual Foxpro tables.

Developer: Simon Cropper 2009

License: GNU General Public License (GPLv3) – Quick Guide

Programming Language: Visual Foxpro 9.0 SP2

PROJECT BRIEF

Regular reindexing and packing of tables is essential for the health of any database system. Visual Foxpro does not ship with a stand alone program that can be run unattended in off-peak times.

VFP Vixen aims to provide a utility to reindex and pack tables unattended and provide feedback in the form of a log.

VFP Vixen is intended to be a Microsoft Window's Executable (although it should operate in the Linux environment using Wine) that can be run either from a command-line prompt by scheduling software or a GUI interface.

The GUI will provide access the program configuration file, jobs and logs.

VFP Vixen will reindex or pack all tables in designated directories (and subdirectories if required) and will keep a log of the success of opening, locking and maintaining a table.

Program behavior will be managed through a configuration and job file. Configuration options will include the ability to recursively work through subdirectories, provide a name and location for the log file, sending the log file to an administrator by email, types of data to include in logs and what should appear on screen as the program is run.

The primary aim of the project is to provide an easy to use utility to reindex or pack files at off-peak periods, as both these processes require exclusive access to files - something that is difficult to achieve during normal business hours.

Why Vixen? A Vixen is a female fox that during the breeding season stays at home and looks after the den.

Downloads

PO Box 160, Sunshine, Victoria 3020
P: + 61 (03) 9311 5822. E: scropper@botanicusaustralia.com.au

Page Last Updated: 1 April 2009