Keystroke Support Utilities

Below is an alphabetized list of Support Utilities included with Keystroke POS (some require User Bundle license) and a description of what each one does.

Go To:

CHGNUMS.EXE / WCHGNUMS.EXE:

Used to renumber Inventory Stock Numbers or Customer Numbers.

ChangeNums is an executable Keystroke Program which will read in, Pack, and renumber the data specified file. It will also update old transactions to reflect the new Customer and Inventory Numbers.

Supports Alternate Transaction Files, Customer Contacts, Contract Pricing files, Matrix Items, Alternate Inventory Codes, Variances in Progress, Scripts, Productions, Store Transfers and Photo files.

Scripts support note: The program will not update Scripts that are Select Item from Range and the range is By StockNumber. These scripts will remain with the old stock number range which may no longer be valid. This type of script is not recommended in the first place, but can corrected manually by editing the script after ChgNums has been run.

Writes to (appends) a log file (CHGINV.LOG or CHGCST.LOG) listing the numbers that were changed. It only logs numbers that were changed to a new number and not those that stayed the same or were no longer in use.

Supports the standard Keystroke command line switches and the following special switches:

Change Numbers Above= : (default is 0). This number marks a limit that preserves numbers at and below its level. For example, to exclude inventory items numbered 1 to 1000 from being changed, set this number to 1000. Then only items numbered 1001 and higher will be changed. Note that the program will still change deleted items (their history is changed to number 0). To just change the history of deleted items to 0 so that their stock numbers can be reused and not change the number on any existing items, then set the Change Numbers Above parameter to 99999.

Read Changes from File=: Reads in the Old/New number combinations from the file CHGNUMS.TXT. This file can be in just about any delimited format as long as each record has the Old number field first, followed by a delimiter, followed by the New Number. The delimiter will usually be a Space, Comma, or Tab, but can also be any non-numeric character(s). The log files generated by CHGNUMS are supported. To use them, copy CHGINV.LOG (or CHGCST.LOG) to CHGNUMS.TXT before running the program. If a log file is used, then the program will search for the last set of changes in the file and used those (since the log file can hold more than one set of changes). The Starting New Number parameter is ignored. However, the Change Numbers Above parameter is still used (i.e. the program won't change a record if its current number is below the Change Numbers Above value).

***Important note for Read Changes from File parameter:

When using this parameter, it is possible to create duplicate Customer/Inventory numbers. Verify that the changes to be made are compatible with the data set that is being updated (no numbering conflicts). However, this is also a feature of the program that can be used to merge two or more Customer or Inventory records together. For example, if you have a customer listed in your database twice (e.g once as Customer Number 212 and again as 3076), you remove 3076 and assign his history to 212 by creating CHGNUMS.TXT with a single line of 3076 212. Running CHGNUMS on Customers, with Read Changes from File turned on, will cause customer 3076 to become 212. Two customer numbers 212's will then exist in the database. Use the Record Delete function in the Database Manager to delete the duplicate record. The result is the elimination of customer 3076 and all their history now attached to customer 212.

CHKSCRIPT.EXE:

Checks whether each inventory item has a script and then updates the hidden flag (scripted item) on the inventory record.

Supports the standard Keystroke command line switches.

CONVPTG.EXE:

Convert Price Tag is a stand alone executable Keystroke program which converts old price tag forms (.PTG) to the new format (.TAG). The Old file must be in the FORMS\ directory and the new file will be in the REPORTS\ directory.

The syntax is: CONVPTG OldTag

Do not place a path or file extension on the OldTag filename, the program will do it for you (FORMS\OLDTAG.PTG).

Field Text in the new forms is limited to 30 characters. If the old form was using more than 30 in a single entry, then the rest of the text will be place in the Heading field for that line. 

Only supported switch is the name of the file to be converted. Only 1 file can be converted at a time. (e.g. CONVPTG 1WIDE.PTG).

COPYCLK.EXE:

Copyclk is an stand alone executable Keystroke program which will copy the time clock information from the file KSCLK.TMP to the file KSCLK.DAT, the times are only copied if they are newer than the present times.

This program supports the standard Keystroke command line switches and the following special switches:

/M - Merge directory, follow this switch with the  location of the KSCLK.TMP file.

DELTRANS.EXE / WDELTRANS.EXE:

Replaced DELORDRS. Used to mass delete transactions that match the specified criteria. It creates the file DELTRANS.LOG in the Data Directory and writes information to it about when it was run and what transactions were deleted.

Deltrans will remove sales and purchase transactions that match the parameters entered on the command line. Both a Start Date (START=) and Ending Date (END=) must be specified.

Supports all the standard Keystroke command line switches as well as the following special switches:

Start= : Starting Date (Start=04/10/94 or Start=-2Y).

End= : Ending Date (End=05/26/96 or End=-2D )

StartTime= : default is 0:00am

EndTime= : default is 11:59pm

TYPE - put what to export after this switch. This is two characters which match the Hot Keys on the export function used in the Configuration Manager, but only Sales Transactions and Purchase Transactions are supported. Valid Types are for Sales are: TYPE=SA, TYPE=SB, ... TYPE=SL. Valid Types for Purchase Transaction are: TYPE=PI, TYPE=PO, TYPE=PR.

Filter= : put the filter to be used after this switch. The format is the filter number followed by the condition which is enclosed in quotes. The number is found by the position of the field in the Filter Field list on the Transaction Reports. (e.g Filter=2">100 and <200" will delete Transaction Numbers between 100 and 200). More than one filter switch can be used. If more than one is used, all must match.

/NOP : No Pause - Eliminates warning prompts.

/NOINV : No Inventory - do not update inventory levels.

DELUTIL.EXE / WDELUTIL.EXE:

Provides special data file maintenance routines that are not available in the standard Keystroke program. This special tool originally was used to force deletion of problem payments (mark with an X to delete). Now many "Update" functions have been added, such as resetting Customers’ oldest open invoice date to force the program to recalculate AR.

Supports the standard Keystroke command line switches as well as the following special switches.

/G - Go to function. This switch will automatically run the specified function. Specify the function by entering the Highlighted Hotkey from the menu in the program. (e.g. Update-Open Orders is /GPO). Not all functions are supported due to security concerns.

/NOP - NO Pause - Will not stop to ask if you really want to run the selected function.

FIXHDR.EXE:

This program erases File pointers and Dates and sets the version of the specified file to 4.10.

Enter FIXHDR filename - where filename is the full name of the file (DATA\KSTRNHDR.DAT)

HEADER.EXE:

***This utility should only be used with the help of Keystroke Technical Support***.

Provides the ability to read and edit transaction file link information.

Supports the standard Keystroke command line switches as well as the following special switch:

FILE=filename - Where filename is the first five letters of the type of file to view (e.g. FILE=KSSTR for Store Transfers).

IMPALTIC.EXE:

Imports Alternate Inventory Codes into Keystroke (also Alternate Customer and Vendor Codes). The file to be imported must be in ASCII delimited format where the first field is the new Alternate Code and the second field identifies the existing item in Keystroke.

USAGE : IMPALTIC [/F filename] [DBCODE= I|C|V] [/C N|D|C|L|M] [/I]

DBCODE= The database to import into.
I=Inventory (default), C=Customer, V=Vendor

/C - What to look up by:
For Inventory: N=Stock Number, D=Description, C=Product Code, L=Class, M=Manufacturer
For Customers and Vendors: N=Customer/Vendor Number, C=Code

/F - Filename (including path) of file to be imported (default is ALTCODES.TXT located in the program directory).
The default is to look up each inventory item by Stock Number. Use /C to specify a different field to search by.

/I - ID First - switches the order of the fields. The first field identifies the exiting item in Keystroke and the second field is the new Alternate Code. (This is the order that Keystroke exports Alternate Codes in).

Supports most of the standard Keystroke command line switches.

IMPORTAR.EXE:

Imports Accounts Receivables Customer Balances into Keystroke by creating a Balance Forward invoice for the balances contained in the ASCII delimited file CUSTBAL.TXT.

The first field in this file is the Customer Code (unless changed by a switch), the second field will be total balance, any other fields will be balances for previous periods.

Note that the the balances from previous periods are optional and the amount posted to the current period will be the total minus these other fields.

IMPORTAR [/F filename] [/C C|N|M|P|Z] [P0=date] [P1=date] [P2=date] [P3=date]

/C - C=Code, N=Number, M=Name, P=Phone, Z=Zip

The default is to look up each customer by Customer Code and the date for each period will be the last date of the prior month.

Supports most of the standard Keystroke command line switches.

KEYSTROK.EXE:

Starts the Keystroke POS system.

This program supports the standard Keystroke command line switches:

/TUTOR : Use the tutorial data (located in the TUTOR\ subdirectory)

/D : Directory - Follow with the path of the directory that contains the data files. (/D C:\DATA)

/R : Register Number - Follow with the register number.

/K : Keystroke Resource Directory - Follow with the path to store the files that are used to produce the screens displayed. (/K C:\TEMP)

/U : User Temporary Directory - Follow with the path to store temporary files in.

/C : Configuration File - Follow with the name of the Configuration file. (/C KSCNF.DAT)

/F : Forms File - Follow with the name of the forms file (/F FORMS.DAT).

/P : Printer - Follow with the name of the printer setup file. (/P PRINTERS.DAT)

/LOWMEM : Program will use less memory to run (use with large data files).

/B : Black and White - Turns color off.

/S : No Sound - Turns sound off.

DISPLAYOFF: No Customer Display

DRAWEROFF: No Cash Drawer

/E : Data Extension - Follow with the extension to be used for the data files. (/E DAT)

ATKB : AT Keyboard - Forces recognition of new keyboards (use on laptops).

XTKB : XT Keyboard - Forces recognition of older keyboards.

/NOSNOW : Helps to reduce 'Snow' or 'Flicker' on older monitors.

/NOSPLIT : Don't split (start new) transaction files (don't use).

LOCKFILES= Increase File Locking/Unlocking frequencies to flush out data buffered by the computer or network. 1=File Level, 2=Record Level 4=Confirm each Write (numbers can be added together, see below) .

The following special switches are also available:

/NEWFILE : Force program to immediately split the current transaction file (start a new one).

/TIME : Prompt for current Date and Time.

/G : Go Direct to Module - Follow with name of module to go to. (/G LOGO)

/NOD : No Disk Space Check or File Size Check - turns off  'About out of disk space' and 'File is reaching maximum size warnings.'

NOTES:

LOCKFILES= switch is designed to help eliminate data corruption problems on networks that are caching/buffer data that should not be. The support settings are 1, 2, 4, or a combination of the numbers added together (e.g. 7 would turn on 1, 2, and 4). 1 = Lock/Unlock file when opened. 2 = Lock/Unlock records when adding new records. 4 = Verify each new record.

KSBACKUP.EXE:

Uses PKZIP.EXE to make a backup of all changed files (those with attribute A turned on) in the Current directory and all directories below it to the specified location. (Use the ATTRIB +A *.* /S to turn on the attribute on all files if first if you want to back up everything).

The utility will create three files in the specified destination. YYMMDD.ZIP, YYMMDD.LST, and LASTBACK.TXT. YYMMDD will be the date of the backup (a dash followed by a character may be added if a backup already exists for the current date). The .ZIP file is the backup and the .LST file is a list of all the files that were backed up. LASTBACK.TXT will hold information about the last backup performed.

The file NOBACK.LST in the current directory can be used to enter the names of files to be excluded from the  back up (list each file on a separate line, wild cards can be used. e.g. *.TMP).

The syntax is KSBACKUP Z:\. Note only the destination for the backup can be specified and that the source is always the current directory and all the sub- directories below it. Also, the filename (for .ZIP and .LST) will automatically be created.

Supports only the following special switches:

PAUSE=1 : Will pause before performing backup.

RESETATTRIB=1 : the Attribute flag on files backed up will be cleared.

CHECKLAST=1 : Will stop if last backup has not been restored. This switch should only be used when using the backup to transport files between two locations (store/home).

PASSWORD= : follow with the password required to restore the files.

PASSWORD=* will stop and ask for the password. If this is used, PKZIP will encrypt the backup file and it will be unreadable without the password.

KSRESTOR.EXE:

Restores all files stored in a backup made with KSBACKUP.EXE to the current directory structure. It will check the file LASTBACK.TXT to find the name of the last backup file and will then ask if you want to restore it. Then it calls PKUNZIP to restore the files. It  will ask for a password, if one wasn't used to create the backup then just enter anything and the program will continue.

The only switch supported is the path where the backup file is located.

KSSORTDB.EXE / WSSORTDB.EXE:

Keystroke Sort Databases - Resorts indexes on fields that are over 10 characters wide where the first 10 characters are the same on more than one record.

The standard Keystroke Database Engine only sorts on the first 10 characters which can cause records that start with the same first 10 characters to appear to be not sorted. This utility will find these types of records and then check the full field in order to resort the index them.

KSSORTDB.EXE (and the windows version WSSORTDB.EXE) is a utility that runs the Re-Sort function from the Files Menus in the Configuration Manager from a command prompt or through a batch file or script.

It supports all the standard Keystroke command line switches.

NUMBERS.EXE:

Reports on all available (unused) Stock Numbers.

Supports all the standard Keystroke command line switches.

REMDUPES.EXE / WREMDUPE.EXE:

Remove Duplicates is a utility that will delete any duplicate Sales Invoices or ROA payments.  It works the same as if you deleted each one manually.  Theprogram was mainly designed to be used whenever the same set of sales data wasaccidentally merged in more than once (either through the STOREMRG or RECMRGprograms).  Note: the transactions must be exactly duplicated (which can really only happen through a merge function). If the same transaction was simply entered twice they would not be duplicates as far as this program is concerned since the Time Stamps would never be the same.

A log file is created in the data directory (REMDUPES.LOG) that records when this program was run and what records were deleted.

Supports all the standard Keystroke command line switches as well as the following special switches:

/NOINV - No Inventory Updates - Will not update the QOH, etc. as duplicates are removed. This should be used when the duplicates were created by running STOREMRG /NOINV.

/NOCUST - No Customer Updates - if this is used then the program will not update the Customer's Amount Due and Total Purchased fields as duplicates are removed.  This should be used when the duplicates were created by running STOREMRG /NOCUST.

 /NOLOG - Do not write to the log file (REMDUPES.LOG)

SCRPT.DOC:

Documents the format of the ASCII files used to Export/Import scripts. The file is ASCII Quote/Comma delimited where each record is on a single line. The first field of each record identifies its type. There are 3 types of records; Main ("M"), Script ("S"), and Item List ("I").

The Main record identifies the inventory item that the script is attached to. The Script records (there can be 0 to 30 of these following each Main record), contain the script settings for each script line. The Item List (there can be 0 to 1 of these following each Script record) lists the individual inventory items that can be selected from the script.

The format for these records are as follows:

Main :

"M", "Description", "ProductCode", "StockNumber", "Class", Beeps, NumScripts

 Script:

"S", "Name", "Type", "SortNum", "StartRange", "EndRange", Flags, MinItems, MaxItems, Qty, NumListItems, "Message", "Comment"

Type:

1 = Reminder Message

2 = Prompt for Comment

3 = Tag-along Item

4 = Add Item from List

5 = Add Item from Range

SortNum:

1 = Description

2 = Product Code

3 = Stock Number

4 = Class

Flags: (Several can be set at one time)

1 = Component Item

2 = Replace Scripted Item

4 = Out of Stock Only

8 = Fixed Qty

16 = Roll Up Cost

32 = Prompt For Qty

64 = Roll Up Price

Item List:

"I", NumListItems, SortNum, Stock#1, Stock#2, S#3, ..., S#59, S#60.

SCRNSAVE.TXT:

Used for built-in screen saver display. Use DOS EDIT to change the text in this file.

UDPRICE.EXE:

Update Price Fields is used to update the price fields on inventory items using the specified Price Table (formulas). This is the same as the Search & Update Price function in the Database Manager, except it uses Filters instead of the Search screen to specify which items to update.

Note: To update more than one price field or to use different tables/dates with different items, set up a batch file to run this utility more than once, where each time it will update a different field and/or set of items. Also, remember that items with a blank Price Code field can not be updated via price formulas.

Supports all the standard Keystroke command line switches as well as the following special switches:"

PriceTable= : Enter the single character Code that identifies the Price Table to use (default is PriceTable=$)

Update= : Enter either P/S/L/1/2/3/A/C for basePrice / Saleprice / Listprice / level1 / level2 / level3 / Avgcost / lastCost (default is Update=P).

Date= ; Enter date that formula must be valid on (default is Date=Today)

Filter= : put the filter to be used after this switch. The format is the filter number followed by the condition which is enclosed in quotes. The number is found by the position of the field in the Filter Field list on the Inventory Database Report. (e.g Filter=3">100 and <200" will update items whose stock number is between 100 and 200). More than one filter switch can be used. If more than one is used, all must match.

/NOP : No Pause - Eliminates warning prompts.

UPCCOST.EXE:

Update Parent Child Costs is used to update the Last and Average Cost of items that have a Parent/Child relationship. This utility will update the Last Cost field of each Child to match that of the Parent (taking into account the Order Multiplier).

It will also update the Average Cost of the items by first recalculating the Average Cost of the parent after rolling all the (QOH+QtyOnLayaway+QtyAllocatd) and Average Cost from its children up into it and then resetting the Average Cost of each Child to match.

Note that the Filters apply (and are checked on) only the main parent (an item that has children but no parent). Children of a Parent that matches the filter will be updated even if the Child itself does not match the filter.

Supports all the standard Keystroke command line switches as well as the following special switches:"

Filter= : put the filter to be used after this switch. The format is the filter number followed by the condition which is enclosed in quotes. The number is found by the position of the field in the Filter Field list on the Inventory Database Report. (e.g Filter=3">100 and <200" will update items whose main parent's stock number is between 100 and 200). More than one filter switch can be used. If more than one is used, all must match.

/NOLASTCOST : Don't update Last Cost fields.

/NOAVGCOST : Don't update Average Cost fields.

/NOP : No Pause - Eliminates warning prompts.

END OF LIST