############################################################################## # Account Tracker # # Released under GNU General Public License # Copyright 1999-2007, unixabg_AT_gmail.com # # This program is free software; you can redistribute it and/or # modify it under the terms of the GNU General Public License # as published by the Free Software Foundation; either version 2 # of the License, or (at your option) any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. ############################################################################## INFORMATION: --------------------------------- Account Tracker was designed for my small consulting company to run on my unix workstation. It was created with Visual Tcl at: http://vtcl.sourceforge.net/ Database is driven by Metakit at: http://www.equi4.com Originaly developed under Redhat & FreeBSD4.x at: http://www.redhat.com http://www.freebsd.com Current development and testing under Lindows: http://www.lindows.com Designed for Un*x! INSTALLATION ---------------------------------- Since the 0.97 version only the .tcl files will be included in new upgrades. The Mk4tcl.so now builds under FreeBSD4.4 and is in the ports tree. Please read the Makefile for the settings for your /etc/make.conf to get the tcl build. All data is expected to be located in the current working directory. Latest version require tcl/tk 8.3.2 or later to be installed (see http://www.scriptics.com ) and see http://www.equi4.com for a Mk4tcl.so lib for your platform. Again now builds from the ports tree on FreeBSD. First: Make a working directory wher you want to run the app. i.e. ~/AT Second: Download the AT-xxx.tcl script to the working directory. Third: Download the Mk4tcl.so file for your platform to the working directory. Fourth: Launch app! To run merely type {yourPathToWish} ./AT-xxx.tcl from the working directory. i.e. /usr/local/bin/wish8.3 ./AT-xxx.tcl If you want you can write a small script to do something like this if you want to: #!/bin/sh # Launch from a single script file. # Assume ~/AT is our working dir. cd ~/AT /usr/local/bin/wish8.3 ./AT-xxx.tcl & The above should launch the AT for you. If you want to send it to a remote desktop try something like: #!/bin/sh # Launch from a single script file to display on remote desktop xxx.xxx.xxx.xxx # Assume ~/AT is our working dir. cd ~/AT /usr/local/bin/wish8.3 ./AT-xxx.tcl -display xxx.xxx.xxx.xxx:0 & Notes: ---------------------------------- All development is now under FreeBSD4.x and Debain (Lindows Version). The developent FreeBSD Mk4tcl.so is built on 8.3.4 and Debain is from current download at www.equi4.com. If you are running 0.96 or higher, then automatic database upgrades should work. You will be prompted on startup of the app upgrade if one is needed. The app now expects to see all datafiles in the working directory. THINGS TO DO ---------------------------------- * None listed. FEATURES UNDER CONSIDERATION ---------------------------------- * Recurring charge report. * Switch printing from text only to canvas oriented and dump to postscript. This will allow for printing a company image and other visual enhancements. VERSION HISTORY AND INFORMATION ---------------------------------- ################################################################# # # C u r r e n t V e r s i o n I n f o r m a t i o n # ################################################################# ----------------------------------- AT-103a.tcl released on 10-29-2007 Minor changes for working with taxes. --------------------------------- AT-101a.tcl released on 08-05-2003 Enhancements: * None. Fixes: * Minor code cleanup. * Recognize carriage returns for statements and reports. * Bug after printing client invoice of losing client listing. Notices: * None. -------------------------------------------------------------------- AT-100.tcl released on 03-28-2003 Enhancements: * None. Fixes: * Minor code cleanup. * Code and app appears to be stable for 1.0 release. Notices: * None. ---------------------------------- AT-099j.tcl released on 11-30-2002 Enhancements: * Carriage returns recognized from textWidgets for output printing. Fixes: * Corrected so that you can not print an invoice until has been saved. * Removed old procedure for writing prefs called writePrefs Notices: * None. ---------------------------------- AT-099i1.tcl released on 11-10-2002 Enhancements: * None. Fixes: * Fixed bug related to timer on new users and database creation. * Notices: * None. ---------------------------------- AT-099h.tcl released on 10-26-2002 Enhancements: * None. Fixes: * Report bug corrected on cover pages and information for all clients. Notices: * None. ---------------------------------- AT-099g.tcl released on 10-24-2002 Enhancements: * Created wrap around on the Invoices tab. * Added a control for dialog time from prefrences screen. * Modified printClientCover to accept a runType var and added to Print menu. * Modified printClientInfo to accept a runType var and added to Print menu. Fixes: * None. Notices: * AT-099f was the next version release but some minor bugs were discovered and decided to just make the modifications with the next release. ---------------------------------- AT-099e.tcl released on 10-13-2002 Enhancements: * Added selected client name on Invoices tab. Fixes: * None. ---------------------------------- AT-099d.tcl released on 9-10-2002 Enhancements: * None. Fixes: * Corrected bug that sneaked in on rMouse operations on tickets. ---------------------------------- AT-099.tcl released on 3-26-2002 Enhancements: * Shortcut keys for common tasks. * Modified some window positions and formats. Fixes: * Corrected rucurring charge error for invoice. * Cleaned up various code and dialog placement on screen. ---------------------------------- AT-098b.tcl released on 1-9-2002 Corrected a divide by zero on reports error bug. ---------------------------------- AT-098.tcl released on 12-4-2001 Cleaned up code and some logical issues with mouse features. Mouse orientation now for all operations. ---------------------------------- AT-097.tcl released on 10-28-2001 Now test for default dir of ~/.AT for all data files. If no ~/.AT folder then it will create an empty database and an empty AT.ini file. Added a field of cstatus for client to address activity. The app now lets you display only clients marked as active from preferences. Print preview option implemented in beta form. Moved interface to final format of main window for 1.0 release. Fixed small details printing error on lineWrap proc. More code cleanup. ---------------------------------- AT-096p9a.tcl released on 10-11-2001 Minor revamp of the line wrapping operations. This is pretty clean and functional now. If unprintable areas are encountered the printout will say so. ---------------------------------- AT-096p9.tcl released on 9-17-2001 Minor code cleanup and cleanup of backup process. ---------------------------------- AT-096p8.tcl released on 9-6-2001 Bug fix for client edit/add window and recurring charge flags. If you have upgraded you database to the tracker9.6.dat format you need to rename the data file back to tracker9.dat and allow the script to upgrade again to correct a field issue that crept in during the database format modifications. This will only effect the amount that you have established for recurring charges for each client. ---------------------------------- AT-096p7.tcl released on 08-24-2001 Bug fix for generating statements. ---------------------------------- AT-096p6.tcl released on 08-24-2001 Added a regular bill period for lease services. Added access to client information from invoice by clicking on the client name from the invoice screen. General coding cleanup. Automatic database upgrade from a tracker9.dat to a trecker9.6.dat. This will be standard for future upgrades. ---------------------------------- AT-095p2b.tcl released on 05-30-2001 Now leave notes section open until invoice is paid. Fixed bug caused by { or } or a pairing of the symbols. ---------------------------------- AT-095p2.tcl released on 05-20-2001 This is just an update for the tcl file. Not a full release. Fixed some binding errors that caused index problems. Fixed some spelling mistakes. Now leave notes section open until invoice is paid. ---------------------------------- AT-095p-Beta.tcl.tar released on 05-18-2001 Made modifications to function correctly with the tclkit from www.equi4.com . The tclkit provides builtin MetaKit functions so you can download tclkit and then get the tclkit tcl and put in your install dir. Then /pathTo/tclkit AT-095p-tclkit.tcl should do the trick. If you are not running Linux this may be your best bet. Changed the format of release numbering to AT-(.versionNumber) !!!!!!!!!!!!!!ATTENTION!!!!!!!!!!!!!!! !!!!!!!!!!!!!AT0.8.0 USERS !!!!!!!!!!!! If you are upgrading from 0.8.0 then you need to run the script to update your database to 0.8.1 format then run the next update! !!!!!!!!!!!!!!ATTENTION!!!!!!!!!!!!!!! !!!!!!!!!!!!!AT0.8.1x USERS !!!!!!!!!!!! Modified database structure (tracker81.dat) to the following: mk::view layout db.account { client contact email phone fax address city state zip details { ticket{ invoice details amount cost invdate completed paid paiddate notes } } } The new database is tracker9.dat and this table change allows for a the application to function correctly under the tclkit. Script provided to convert your database to the tracker9.dat format. ** You only need to do this if you are an 0.8.1 user moving to 0.9.x ** Script is: 8.1-to-9.x.tcl Run script in the folder that you AT program is in and it will convert your data in tracker81.dat to a new database called tracker9.dat. This should not alter the data in the tracker81.dat, only create a new database with the new format for the AT0.9.x branch. Always make backups! Modified screens with grab to keep main window up at all times. ---------------------------------- AT0.8.1e1-beta.tcl released on 01-22-2001 Added cut pand paste features via RMouse. Fixed reports to print 1 page even when no report information available. ---------------------------------- AT0.8.1d-beta.tcl released on 11-25-2000 Fixed bug on RMouse on ticket that did not activate the correct ticket for items RMoused. Upgraded MetaKit to 2.3.3-28 ---------------------------------- AT0.8.1b-beta.tcl released on 09-23-2000 Fixed bug that was introduced in at the 0.8.1a release during add new client. ---------------------------------- AT0.8.1a-beta.tcl released on 09-16-2000 #!!!!!!!!!!!!!!ATTENTION!!!!!!!!!!!!!!! !!!!!!!!!!!!!AT0.8.0 USERS !!!!!!!!!!!! Modified database structure (tracker80.dat) to the following: mk::view layout db.account { client contact email phone fax address city state zip details { ticket{ invoice details amount cost date completed paid paiddate notes } } } The new database is tracker81.dat and this table change allows for a client details section. This is for information including hourly rates and any specific information you wish to keep on client. Script provided to convert your database to the tracker81.dat format. ** You only need to do this if you are an 0.8.0 user moving to 0.8.1 ** Script is: 8.0-to-8.1.tcl Run script in the folder that you AT program is in and it will convert your data in tracker80.dat to a new database called tracker81.dat. This should not alter the data in the tracker80.dat, only create a new database with the new format for the AT0.8.1 branch. Always make backups! ---------------------------------- AT0.8.0i-beta.tcl released on 09-15-2000 Upgraded the Mk4tcl.so file. This upgrade now requires that you use tcl8.2 or later for stub support. Reduced some unrequired code to sleek up the top a bit. ---------------------------------- AT0.8.0h-beta.tcl released on 09-12-2000 Fixed bug on commiting data out after changes. This also fixed backup bug. Added the ability to just view Open & Unpaid Invoices. ---------------------------------- AT0.8.0f-beta.tcl released on 09-05-2000 Fixed bug on database backup after changing database name. Fixed bug on catching a close from the prefs window. ---------------------------------- AT0.8.0d-beta.tcl released on 08-22-2000 #!!!!!!!!!!!!!!ATTENTION!!!!!!!!!!!!!!! !!!!!!!!!!!!!AT0.6.x and/or AT0.7.x USERS !!!!!!!!!!!! Modified database structure (tracker70.dat) to the following: mk::view layout db.account { client contact email phone fax address city state zip { ticket{ invoice details amount cost date completed paid paiddate notes } } } The new database is tracker80.dat and this table change allows for a private notes section on the ticket. Script provided to convert your database to the tracker80.dat format. ** You only need to do this if you are a (0.6.x or 0.7.x) user moving to 0.8.x ** Script is: 7.x-to-8.x.tcl Run script in the folder that you AT program is in and it will convert your data in tracker70.dat to a new database called tracker80.dat. This should not alter the data in the tracker70.dat, only create a new database with the new format for the AT0.8.x branch. Always make backups! ---------------------------------- AT0.7.8.tcl released 06-02-2000 Corrected bug for details with something of the order of: d:\somedir Added a couple of handy RMouse features for invoices. Added double click feature on invoice to open the invoice. ---------------------------------- AT0.7.7.tcl released 04-27-2000 Added double click to open invoice. ---------------------------------- AT0.7.6.tcl released 03-14-2000 Fixed statements bug that was printing open tickets on statements. Added right mouse features on client for printing single statement and a complete client history. ---------------------------------- AT0.7.5.tcl released 02-06-2000 Fixed print bug on single ticket. Put additional information on the single ticket printout. ---------------------------------- AT0.7.4.tcl released 02-05-2000 Enhanced front screen to provide some additional information. ---------------------------------- AT0.7.3.tcl released 01-21-2000 Fixed window sizes. COMPLETED Create an interface to copy the tracker70.dat data file to a backup file. COMPLETED (In Beta) ---------------------------------- AT0.7.2.tcl released mm-dd-yyyy (skipped release) Fix divide by zero error trap on reports when total of all tickets is 0. COMPLETED Sort clients in alpha order. COMPLETED ------------------------------------------ AT0.7.1.tcl released 01-08-2000 #!!!!!!!!!!!!!!ATTENTION!!!!!!!!!!!!!!! !!!!!!!!!!!!!AT0.6.x USERS !!!!!!!!!!!! Modified database structure (tracker.dat) to the following: mk::view layout db.account { client contact email phone fax address city state zip { ticket{ invoice details amount cost date completed paid paiddate } } } The new table database is tracker70.dat Script provided to convert your database to the tracker70.dat format. ** You only need to do this if you are a 0.6.x user moving to 0.7.x ** Script is: 6.x-to-7.x.tcl Run script in the folder that you AT program is in and it will convert your data in tracker.dat to a new databas called tracker70.dat. This does not alter the data in the tracker.dat, only create a new database with the new format for the AT0.7.x branch. Generate paid report the paid date not invoice date. COMPLETED Invoice that is marked completed may not be edited. COMPLETED New report for open invoices based on invoice date. COMPLETED ------------------------------------------ At0.6.1.tcl released 01-06-2000 Fix the print bug with "" in statment procdure. COMPLETED Put in global invoice totals, costs and percent at bottom of report. COMPLETED Using only one proc for the client reports instead of two. COMPLETED Cleaned up report formats a bit. COMPLETED ------------------------------------------ At0.6.0.tcl released 12-2-1999 Working on date ranges for reports.COMPLETED Catch the toplevel close allowing close on db.COMPLETED Catch intra program window closes and events. COMPLETED Reports cover either detailed or general on paid tickets. COMPLETED Complete reports with paid and unpaid tickets.COMPLETED All reports will work with a double window envelope.COMPLETED Fix bug with printing when a "'s appeared in details window. COMPLETED ------------------------------------------ AT0.5.x.tcl Smoothed up some of the rough edges. Put on web site for download. ------------------------------------------ AT0.4.tcl Statements -- Generated if you still owe money. COMPLETED %Profit -- All paid invoices less costs on invoices.COMPLETED New Splash Gif! COMPLETED Single Window interface! COMPLETED Single open / close on metakit datafile! COMPLETED ------------------------------------------ AT0.1.1 Work on marking tickets paid completed. Work on printing tickets that work in a double window envelope completed. Insert Dates on new tickets and on marked paid completed. ------------------------------------------ AT0.0.9 Working on marking tickets paid. Working on Printing tickets and reports. ------------------------------------------ AT0.0.7 AT.ini now expected to be in the working dir. Implemented Ticket methods of New, Edit and delete. Implemented Ticket number increment. Modified database structure (tracker.dat) with the following: # Build the data base with cost mk::file open db tracker.dat mk::view layout db.account { client contact email phone fax address city state zip { ticket{ invoice details amount cost date paid paiddate } } } mk::file close db No need to keep amount paid since I do not bill interest nor work for people who will not pay their bill in full. ------------------------------------------ AT0.0.5 Created tracker functions for clients including New Client, Edit Client and Delete Client. Fixed bugs in the preferences. ------------------------------------------ AT0.0.3 Not functional. ------------------------------------------ AT0.0.1 and AT0.0.2 Nothing very special. Front end completed.