Home › Forums › Knowledge Base › Legacy Applications › Street Database Module
- This topic has 0 replies, 1 voice, and was last updated 19 years ago by
Rob.
-
AuthorPosts
-
April 15, 2006 at 1:42 pm #1639
Rob
MemberStreet Database Module
by Doug Martin of Custom ComputingLast edited: December 15, 2003 08:17 AM
The street database module consists of three parts. A module to create the database, a module to index the database, and a module to interface with the Touchnet program. This module allows the user to preprogram the street names and numbers into a database and assign delivery zones, allowing the operator to immediately determine if the caller is in the delivery area, and if so which delivery zone he is in.
In the NEXT_VAR chain in the pizza template the command Activate C:Street should be replaced with the following commands:
If C:Street > ‘Ability to edit street
Activate C:Street
End IfIf C:Street = ‘New entry, use street database
Shell to STR_KEY
Var Branch = 7 ‘Jump to Cus:Memo1
End IfA shell should be created to call STR_KEY from the application directory. It should pass variables 18 to 25 and have the Store Variables, Get Variables, Preserve Screen, and Swap to EMS/XMS/VMS options checked.
InstallationThe following files should be placed in the UTILITY directory:
STRINDEX.EXE
STR_KEY.EXE
DBC.EXE
TOSFM.DBCThe following commands need to be added to the AUTOEXEC.BAT of all
workstations that will be running Touchnet:
COPY TOUCHNET(application)DATASTRNAME.NDX Z:
COPY TOUCHNET(application)DATASTREET.DAT Z:Create a CHOOSE menu option called Edit Street Database as follows:
C ‘or N if that is the network drive
TOUCHNET(application) ‘directory
DBC ‘filename
UTILITYTOSFM.DBC ‘command line instructionCreate a second CHOOSE menu option called Reindex Streets as follows:
C ‘or N if that is the network drive
TOUCHNET(application) ‘directory
STRINDEX ‘filename
(blank) ‘command line instruction
Creation and EditingRun Edit Street Database from the Choose Menu. The DBC program runs by entering your menu options as a text command. Available choices are listed at the bottom. To create a new database type in ADD. On the add screens all fields must be filled in. This can be accomplished by pressing the Enter key repeatedly. Upon completion of editing, the Reindex Streets option in Choose should be selected. This will rebuild the index files actually used by STR_KEY. The workstations will then have to be rebooted to pick up these changes.
OperationWhile editing the customer information in Touchnet, the program will shell to a street database window upon reaching the Cus:Street field. The window first asks for the street number followed by {Enter}. Then the first letter of the street name must be keyed in. This brings up a list of all streets starting with that letter. The exact street can then be highlighted either with the arrow keys or using speed search. After selecting the street the shell terminates and all applicable fields are updated in Touchnet. If it is desired to manually edit any information directly within Touchnet, simply press the {Enter} key
repeatedly to cycle through the fields until the proper field is highlighted. The street database will not be accessed if there is already data in the field. If it is desired to make another call to the street database program then {Backspace} out all the text in the
Cus:Street variable and Touchnet will again shell out.
VariablesCus:Street
Cus:City
Cus:State
Cus:Zip
Cus:Memo 2 – zone number(STR_KEY will append any information already in this variable to the zone) -
AuthorPosts
- You must be logged in to reply to this topic.