TO UPDATE RECORDS USED IN TLC PRIOR TO VERSION 2.1.1 Using older records created with TLC will require modifications to the files. The changes may be made with any program that will allow changes to dBASE III type files...FOXBASE and WAMPUM are just two that will work. Instructions are for dBASE but the other commands are similar. For safety, operate from a backup of your older record files, STEP 1. Using DOS commands, make a backup of your TLC data files. Use the backup for these modifications. STEP 2. Place your file backup in drive B:. (NOTE: these instructions are for a diskette in the B: drive but apply also to larger files on other drives...a special subdirectory on your hard disk, drive C:, for example.) Operating with dBASE, at the "." (DOT PROMPT) issue these commands: SET DEFAULT TO B: (or C: and SET PATH TO C:\SPECIAL) USE SCHEDULE (and put you old files in C:\SPECIAL) MODIFY STRUCTURE Change the size of these fields: Change NUMBER from 4 to 5 Characters Change the five Numeric fields from 6 digits to 7 ADD a field named BRAKES of type Date ADD a field named EXHAUST of type Date Continue to the last field and at the prompt "Should data be COPIED", answer Y. or press to confirm. STEP 3. Type: USE DESCRIP MODIFY STRUCTURE Change the type and size of field: Change FINAL from Character to Numeric and from 6 Digits to 7 Continue to the last field and at the prompt "Should data be COPIED", answer Y. or press to confirm. STEP 4. Type: USE REPAIRS MODIFY STRUCTURE Change the type of field: Change MILEAGE from Character to Numeric Continue to the last field and at the prompt "Should data be COPIED", answer Y. or press to confirm. PAGE 2. STEP 5. After you have set up the new TLC system according to the TLC instructions, use the DOS COPY command to copy your newly modified old .DBF files into the new TLC record, thereby replacing the blank files with your newly modified existing TLC records. Use the HOUSKEEPING menu selections to reindex your files with the new .NDX type indexes. TO FLEETFAX VEHICLE RECORD SYSTEM USERS FLEETFAX was withdrawn from the SHAREWARE in mid 1987 field and is no longer supported. TLC has many improvements and corrects a few errors that were discovered in the older program. Although the files used by the two programs are similar, they cannot be interchanged without modifications. If you have just a few vehicles entered in FLEETFAX it may be easiest for you to just start over and re-enter your data in TLC. The many features of TLC will make it well worth the effort. If you have a larger number of entries, your FLEETFAX data files can be converted to TLC by using any program that will allow modification of dBASE III files. MODIFICATIONS TO FLEETFAX FILES TO USE WITH TLC Several changes in the file structure of TLC make FLEETFAX files not directly compatible. The file names are more descriptive, a few field names are changed for clarity and some field sizes are changed for better data entry. Changes to the data files can be made with any program that will allow modifications of dBASE III type database files. These instructions are for dBASE III Plus but will guide you with other programs. STEP 1. Using DOS commands, make a backup of your FLEETFAX data files. Use the backup for these modifications. STEP 2. Using DOS commands, rename these files: from: to: CARDESC.DBF DESCRIP.DBF CARFILE.DBF REPAIRS.DBF CARFUEL.DBF FUELS.DBF PREVENT.DBF SCHEDULE.DBF FILESPOT.DBF is replaced in TLC with DRIVE.DBF Page 3. STEP 3. Place your file backup in drive B:. (NOTE: these instructions are for a diskette in the B: drive but apply also to larger files on other drives...a special subdirectory on your hard disk, drive C:, for example.) Operating with dBASE, at the "." (DOT PROMPT) issue these commands: SET DEFAULT TO B: (or C: and SET PATH TO C:\SPECIAL) USE REPAIRS (copy your FLEETFAX records to ) MODIFY STRUCTURE (C:\SPECIAL) Place the highlight on the field MAINFILE and type CTRL U to delete the field. Place the highlight on the field CO_HOURS and type CTRL U to delete the field. Press to confirm Then type: MODIFY STRUCTURE Change these field names: from: to: DISTRICT DIVIS CO_NUMBER NUMBER REP_CODE CODE TOT_COST TOTAL SHOP WHO Change the type of this field MILEAGE from Character to Numeric Continue to the last field and at the prompt "Should data be COPIED", answer Y. or press to confirm STEP 4. USE DESCRIP MODIFY STRUCTURE Change the size of these fields: from: to: DESCRIPT 25 33 FR 10 12 RR 10 12 COLOR 6 8 EQPMT 50 59 LASTMILE 6 7 Press to confirm Page 4. Then type: MODIFY STRUCTURE Change these field names: from: to: CO_NUMBER NUMBER LASTMILE FINAL DISTRICT DIVIS DESCRIPT DESCRIP TAG LICENSE NEW_DATE NEW AUTH_NUMB PURCHASE DRIVER OPERATOR FUEL_TYPE FUEL Continue to the last field and at the prompt "Should data be COPIED", answer Y. or press to confirm STEP 6. USE FUELS MODIFY STRUCTURE Change these field names: from: to: CO_NUMBER NUMBER FUEL_TYPE FUELTYPE STATION SUPPLIER Change the size of this field: NUMBER from 4 to 5 Continue to the last field and at the prompt "Should data be COPIED", answer Y. or press to confirm STEP 7. USE SCHEDULE MODIFY STRUCTURE Change these field names: from: to: DISTRICT DIVIS CO_NUMBER NUMBER Change all mileage field sizes from 6 to 7 Continue to the last field and at the prompt "Should data be COPIED", answer Y. or press to confirm Add a field BRAKES of type Date Add a field EXHAUSE of type Date STEP 8. To quit dBASE, type: USE QUIT STEP 9. To delete the backup files dBASE created, at the DOS prompt, type ERASE B:*.BAK Page 6. STEP 10. After you have set up the new TLC system according to the TLC instructions, use the DOS COPY command to copy your newly modified old FLEETFAX .DBF files into the new TLC record, thereby replacing the blank files with your newly modified existing FLEETFAX records. Use the HOUSKEEPING menu selections to reindex your files with the new .NDX type indexes. HAVE TROUBLE WITH THE MODIFICATIONS If your files do not work with TLC, go back to the original diskette and make another backup and try again. Follow these instructions and the system will work properly. Still have trouble? Contact your computer dealer or someone locally that knows dBASE. If you are unable to convert your files, as a service to registered users of TLC, we will do this conversion for $10. per diskette to cover shipping and handling costs. J. H. Wilson TLC SOFTWARE Rt 2, Box 165-D Ashville, Alabama 35953-9647 (205) 594-5711