Downloads

Cratchit.org TimeTool for Windows
PKZip Format, 318KB

This is a simple, fast, and efficient way to keep up with the time you spend on various projects. While I've used DOS TimeTool in a Windows world for years now, it's getting to the point where I have a lot more than 20 projects at a time to manage, and rather than upgrade the DOS version I've migrated it to a GUI. It still fits on a floppy.

This Windows version has all of the features of the DOS version, but there is no practical limit to the number of tasks that it can track.

In keeping with its lineage, Cratchit.org TimeTool for Windows is free software. Source code is available on request. You can read more about it here.

command.prg
Text Format, 5KB
script.prg
Text Format, 7KB

These FoxPro program provides the user with a simulated dBASE style "dot prompt" so the user can issue commands from inside a compiled program without the full development system. COMMAND.PRG does not support multi-line structures, nor branching, nor macros.

Although COMMAND.PRG is nice, there are times at the client site when you want to be able to write and run a small program. I wrote SCRIPT.PRG to allow you to do just that. It programmatically interprets a text file and issues certain FoxPro commands that it finds there. It supports multi-line structures, limited branching in the form of an unconditional goto, and a FOR...NEXT loop. It doesn't support multi-line IF-THENs or embedded scripts, but it's a LOT better than nothing!

These programs were the Bonus offerings on FoxPro Advisor's Professional Resource CD for August, 1998. Their ability to process scripts set them apart from other fake dot prompts

Cratchit Help Desk
PKZip Format, 311KB

This open source project has been abandoned and will. eventually be resurrected as part of the VIC CRM project. Currently the code is not even what I'd call alpha, but you can feel free to download it and try it out yourself. The Help Desk is a database written under Lotus Notes version 4.62.

dflsaver
tar.gz format, 2.2KB

One of my favorite stupid pet tricks in Linux is to have a screensaver running in the root window behind the login screen. It looks absolutely great, and never fails to impress Windows users who can't do this simple thing.

dflsaver simplifies the task of setting this up, and it randomly chooses a screensaver from among those that are supplied by RedHat by default. (if you've got another distribution, don't worry... this shell script is easily configurable.

This is a tool in two parts... dflsaver itself executes the screensaver, but grate.awk does the selection (grate.awk is a nifty tool in its own right... given any file or newline-delimited list, it will return a randomly selected list element)

DOS Timetool
PKZip Format, 28KB

This is a simple, fast, and efficient way to keep up with the time you spend on various projects. I wrote this for DOS because I do a lot of cross-platform work and needed to be able to run it regardless of platform (I know, you're thinking "Java", but there's no free JVM for my DR-DOS powered laptop). The tool is reasonably well-featured, and allows you to export your timesheet data to .CSV format, readable by most spreadsheets and databases.

Of course, DOS TimeTool is free software under the GNU GPL. Source code and the binary are included in the zip file. You can read more about it here

fixdbf.zip
PKZip Format, 539KB

Broken headers in xBASE have caused as much consternation as any other "feature" of the language. It's a unique situation in which a networking problem has caused the program to lock up between the time a record is written and the header is updated. It's so prevalent that Visual FoxPro 5.0 now AUTOMATICALLY performs fixes of the header. However, versions prior to that don't, so I wrote this. It's an interactive data file scanner/fixer that will repair broken headers and allow you to BROWSE the broken file PRIOR to fixing it! In addition, it will analyze the damage and will refuse to "repair" a file that is broken in some way other than having a broken header (if this is the case it will suggest the proper utility to use to fix the problem!) In most cases this is much more useful than Norton's FileFix program in that it's THOUSANDS of times faster! Now available here.

Retropsnart (retro.zip)
PKZip Format, 61KB

(Thanks to Pavel Celba for finding this file for me! I had lost my copy!)

When FoxPro version 2.5 was introduced, there was a utility called the "transporter" included. This converted your FoxPro 2.0 code to version 2.5. Unfortunately, the process was one way. While working under a tight deadline I found the hard way that the FoxPro 2.5 memory manager was not compatible with the LIM expanded memory that we had to use under Alloy's operating system. So, the "reverse transporter" was born. Retropsnart converts all of FoxPro's system components from version 2.5 or 2.6 to version 2.0. It's also available in the FoxPro Forum on CompuServe.

runkdelnk
Text Format, < 1KB

REALLY stupid pet trick. This shell script lets you run programs referenced by KDE link files (*.kdelnk) from the StarOffice desktop (or from Netscape, for that matter). It's so embarrasingly easy that it's done in one line.

shiftdbf.zip
PKZip Format, 16KB

This fixes one of the most frustrating and flat-out weird problems I've run into yet. There are cases where the data in DBF files can be shifted out of their fields. The data in the record is actually rotated a number of characters left or right while remaining within the record. This rotation occurs on a byte level, without regard to the data types of the fields in the affected record. The damage occurs to specific records, not all records in the file.

Don't ask me to explain why this happens, as I've had neither the time nor the inclination to really research the cause. I do know it's been around for a while, since Norton's FileFix does fix it. In fact, this problem was the reason I had FixDBF refer you to FileFix for unusual damage. Well, it recently cropped up again, and my old copy of FileFix could no longer fix it, so I wrote this to handle newer FoxPro versions. Basically, you browse the file to find the damaged records (this is faster than FileFix's record-by-record method), then manually shift the data left or right until it appears to fit properly in the fields. There are a few bells and whistles, such as remembering and applying the same shift to other damaged records. There are a number of advantages to my low-level method of fixing this damage to recommend it over Norton's program:

  1. it works on VFP 5.0 files.
  2. it's faster than FileFix since I fix only the damaged records.
  3. This method doesn't break the links to FPT memo files.
  4. it doesn't require any more space on your drive than the file already occupies. FileFix made a copy of the file, and sometimes I didn't have the physical room to fix the data!

However, this can be a VERY dangerous utility because it does NOT automatically make a copy before fixing the file!! It was turned down by FoxPro Advisor for this very good reason! So it's not really a "published program". However, It's really the best way I know of to fix this specific type of damage.