home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
busi
/
tlc212.zip
/
UPDATING.TXT
< prev
next >
Wrap
Text File
|
1988-10-23
|
10KB
|
242 lines
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 <ENTER> 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 <ENTER> 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 <ENTER> 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 <ENTER> 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 <ENTER> 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 <ENTER> 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 <ENTER> 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 <ENTER> 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 <ENTER> 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