Keystroke POS Go to the Keystroke POS Home Page Keystroke POS

Keystroke Multistore Utilities

Below is an alphabetized list of Multistore Utilities (Multistore Module required) and a description of what each one does.

Go To:

CHKNUM.EXE

Makes sure that the two specified files have the same Next Number stored in them.

CHKSTAMP.EXE

Makes sure all the specified files belong to the same data set by reading date/time stamp written to the file using the STAMP program.

COPYNUM.EXE

Copies the Next Number values from KSTRN001.MRG.

DATENAME.EXE

Changes the name of a file to a name representing the current date.

EXTRACT.EXE

Extracts transactions into the file KSTRN001.MRG so they can be imported with the Storemrg program.

INVLINK.EXE

Reads the current inventory data file and then writes QOH information to a file named 'KSIL#.DAT' were # is the store number.

INVLINKO.EXE

Reads the current inventory data file and then writes Qty On Order information to a file named 'KSIL#.DAT' were # is the store number.

KSSCHDLR.EXE

Simple scheduler that can run other programs automatically at a pre-set time of day.

STAMP.EXE

Stamps the specified files with the current Date/Time by writing a serialized representation of the Date/Time the utility was run to the first record of each file. Used with Chkstamp.

STOREMRG.EXE

Merges the existing transactions from the merge file KSTRN001.MRG (created by the EXTRACT.EXE utility)

STRUPDTE.EXE

Runs the Update Inventory function from the Store-Link module.

UPDQTY.EXE

Update Qty reads the file UPDQTY.DAT and then adds each Qty back into QOH.

WHMERGE.EXE

Warehouse Merge will read in the transaction file KSTRN001.MRG and create Sales Orders out of any invoice with a line item comment that contains any of the strings entered in the file WHMERGE.TXT or WHMERGE2.TXT.


CHKNUM.EXE:

Check to make sure that the two specified files have the same Next Number stored in them. The files must be Keystroke Database files (Inventory, Customer, Vendor, Clerk) to work properly. The syntax to run the program is:

CHKNUM FILE1 FILE2

If the Next Number in each file is different, then the program will return an error.

DOS Error Levels:

0 = OK - Next Number is SAME in both files .

1 = Number in First file is HIGHER than in Second File

2 = Number in First file is LOWER than in Second File

3 = Bad/Missing FileNames

4 = Bad Files (size <2048 or not a multiple of 128)

The program writes the results to the file CHKNUM.LOG.

Example (test customer files before copying them):

CHKNUM DATA\KSCST.DAT DATA\HOLD\KSCST.DAT

IF ERRORLEVEL 1 GOTO BAD

:GOOD

COPY DATA\HOLD\KSCST*.DAT DATA\KSCST*.DAT

GOTO EXIT

:BAD

ECHO Bad set of files, not copied.

:EXIT 

Keystroke POS Point Of Sale Software


CHKSTAMP.EXE:

Checks to make sure all the specified files belong to the same data set by reading date/time stamp written to the file using the STAMP program. Specify only one file name (but it can include wild cards to actually represent several names).

The program will write the results to the file CHKSTAMP.LOG. It will also return ErrorLevel 1 if any files don't match or ErrorLevel 2 if any files are not valid.

Example (test inventory files before copying them):

CHKSTAMP DATA\KSINV*.DAT

IF ERRORLEVEL 2 GOTO BAD

:GOOD

COPY KSINV*.NEW *.DAT

GOTO EXIT

:BAD

ECHO Bad set of files, not copied.

:EXIT

Keystroke POS Point Of Sale Software


COPYNUM.EXE:

Copies the second record (FileData which holds the next number values) from the transaction file KSTRN001.MRG to the customer data file KSCST.DAT.

Supports the standard Keystroke command line switches.

It also supports the following special switches :

/M - Merge directory, follow this switch with the location of the KSTRN001.MRG file.

Keystroke POS Point Of Sale Software


DATENAME.EXE:

Changes the name of a file to a name representing the current date.

The syntax is:

DATENAME FileName1 FileName2 where FileName1 is the file to be renamed and filename2 is the mask to name the file to. Note that the mask must be entered with an * in it where the * will be replaced with YYMMDD (e.g. DATENAME KSTRN001.MRG *.MRG will rename the file KSTRN001.MRG to 990423.MRG).

Note that a dash and a letter (-A, -B, -C, etc.) may also be added after the date if the filename already exists. The utility will make a file called DATENAME.LST that will contain the name of the file created.

This utility can be used in MultiStore polling procedures to provide a backup for each day's KSTRN001.MRG so that it can be recovered more easily.

Keystroke POS Point Of Sale Software


EXTRACT.EXE / WEXTRACT.EXE:

Extract transactions into the file KSTRN001.MRG so they can be imported with the storemrg program.

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

/M : Merge Directory - put the name of the directory that contains the merge file after this switch. (/M C:\DATA)

/NOLOCK : Don't update transaction lock date.

/NODISPLAY : Don't display status.

/FORCEDATE : Save End Date of Extract even if before last Extract's End Date.

Start= : Starting Date - put the date to mark as the start of the extracted period after this switch. (Start=04/10/00)

End= : Ending Date - put the date to mark as the end of the extracted period after this switch. (End=05/26/00)

StartTime= : Starting Time - put the time to mark as the start of the extracted period after this switch. (StartTime=05:30a)

EndTime= : Ending Time - put the time to mark as the end of the extracted period after this switch. (EndTime=18:15)

Extract= : List of characters that define what to extract (see Supported Categories below). Default is Extract=CV1WQO5RYyA0T9

Include= : Add additional characters to list of categories to extract. (e.g. Include=s to extract serial numbers)

Exclude= : Remove characters (Don't Extract) from list of categories to extract. (e.g. Exclude=C to not extract customers)

/NOCUST : Don't extract new/changed customers *(OLD use EXCLUDE=C instead)*

/NUMBERS : Extract serial numbers from inventory.

The following parameters are all optional and are used to establish a range (or filter) of which records to extract. If the switch is not used than records will not be tested against it. If a Start... switch is used then the record's value must be Greater Than or Equal to the value specified. If an End... switch is used then the records value must be Less Than or Equal to the value specified. (e.g. StartStore=2 EndStore=2 StartReg=4 will only extract records whose Store Number is 2 and whose Register Number is 4 or higher).

StartStore= : Starting Store Numberl.

EndStore= : Ending Store Number.

StartReg= : Starting Register Number.

EndReg= : Ending Register Number.

StartClerk= : Starting Clerk Number.

EndClerk= : Ending Clerk Number.

StartTrans#= : Starting Transaction Number *(not supported by all categories).

EndTrans#= : Ending Transaction Number *(not supported by all categories).

The Extract=, Include=, and Exclude= parameters accept a string of one or more characters that define what types of data to extract. These are as follows:

Supported Categories = CV1WQO5RYyA0T9s 's-Not on by default C=Customer, F=Contacts, V=SalesInvoice, 1=SalesOrder, W=Layaway, Q=Quote , Y=SalesPayment O=PurchaseInvoice, 5=PurchaseOrder, R=ReservedOrder, y=PurchPayment A=ROAPayment, 0=Variance, T=TimeClock, 9=Audit, s=SerialNumbers (Off by default), ~=Clerk Passwords (Off by default) (Note that when a password is extracted, only the Password, Password Changed, and Password Expires field are updated and not the rest of the clerk's information. Also, Storemrg will only merge in this information if the clerk's current Password Last Changed field is older than the one being merged in).

Note that Upper/Lower case DOES make a difference, therefore you must use the EXTRACT.DAT file with SerialNumbers and PurchasePayments (s and y) since the command line switches are always passed to the program as all uppercase characters.

NOTE: 

These switches can also be specified in the file EXTRACT.DAT. See documentation on Multi-Store / Store Merge for more information.

Keystroke POS Point Of Sale Software


INVLINK.EXE:

Reads the current inventory data file and then write QOH information to a file named 'KSIL#.DAT' were # is the store number as recorded in the Keystroke Configuration Module. The new file can then be read from an inventory record by pressing [Shift+F5] to display the QOH for all the stores for which a 'KSIL#.DAT' file is available.

Supports the standard Keystroke command line switches.

Note:

The serial number from the KEYSTROK.LIC file is stored in the KSIL#.DAT file. These files will not be used unless each one has a different serial number. If you are going to generate these files for several stores on the same machine, copy the KEYSTROK.LIC file from the installation disks for each store into that store's data directory.

Keystroke POS Point Of Sale Software


INVLINKO.EXE:

Reads the current inventory data file and then writes Qty On Order information to a file named 'KSIL#.DAT' were # is the store number. The default store number is -1 but can be change but using the STORE= switch. The new file can then be read from an inventory record by pressing [Shift+F5] from within Keystroke

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

STORE= 'Followed by the Store Number to use.

Keystroke POS Point Of Sale Software


KSSCHDLR.EXE

A simple utility which can be used in conjunction with Batch programs to cause other programs to automatically run at a pre-set time of day.

When this utility is run, it will continuously display a screen blank message until the specified time is reach. (Essentially causing the batch program to wait for the specified time before it can continue). It will then exit back to the program that launched it. This will then allow the rest of the programs in the batch file to continue.

USAGE: KSSCHDLR Time

The command line must include the desired pre-set Time, which can be specified in any format acceptable by Keystroke Time entry fields. The utility will set the DOS ERRORLEVEL to 1 if the user aborts the program.

Keystroke POS Point Of Sale Software


STAMP.EXE:

Stamps the specified files with the current Date/Time by writing a serialized representation of the Date/Time the utility was run to the first record of each file. You must specify one (and only one) filename (but it can include wild cards to actually represent several names). The specified size of each file must be at least 2048 bytes and be divisible by 128 (all Keystroke Database and Transaction files meet these parameters).

This stamp can then be used by the CHKSTAMP.EXE utility to ensure all the files are from the same data set.

Examples:

To stamp the inventory files enter:

STAMP DATA\KSINV*.DAT

To stamp all Keystroke Database and Transaction files enter:

STAMP DATA\KS*.DAT

Keystroke POS Point Of Sale Software


STOREMRG.EXE / WSTORMRG.EXE:

Merges the existing transactions from the merge file KSTRN001.MRG (created by the EXTRACT.EXE utility) into your existing data files. Please see the Multi-Store section of your User Guide for complete documentation.

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

NOTE:

These switches can also be specified in the file STOREMRG.DAT. See documentation on Multi-Store / Store Merge for more information.

/M : Merge Directory - put the name of the directory that contains the merge file after this switch. (/M C:\DATA)

/NOP : No Pause - Eliminates warning prompts.

/NOINV : No Inventory - do not add new inventory.

/NONEXTNUMS : No Next Nums - do not update Next Number on transactions. (Customer Next Number is always updated. Use COPYNUM.EXE to restore it). This should be used when merging in both directions for stores that enter data in the same data set but at 2 locations.

Extract= : List of characters that define what to type of records to merge in (see Supported Categories below).

Default is Extract=CV1WQO5RYyA0T9

Include= ; Add additional characters to list of categories to merge. (e.g. Include=s to merge serial numbers).

Exclude= : Remove characters (Don't Merge) from list of categories to merge in. (e.g. Exclude=C to not merge customers).

/SALESONLY : Do not include purchase transactions. (same as EXCLUDE=OR5y).

/NOCUST : Do not add new customers. *(OLD use EXCLUDE=C instead)*.

/NOVAR : No Variances. *(OLD use EXCLUDE=0 instead)*.

/NOTIMECLOCK : No Time Clock entries. *(OLD use EXCLUDE=T instead)*.

/NOAUDIT : No Audit entries. *(OLD use EXCLUDE=9 instead)*.

/NUMBERS : Merge in Serial Numbers. (Erases all current serial numbers then adds back in those from merge file).

The following parameters are all optional and are used to establish a range (or filter) of which records will be merged in. If the switch is not used, then records will not be tested against it. If a Start... switch is used then the record's value must be Greater Than or Equal to the value specified. If an End... switch is used then the records value must be Less Than or Equal to the value specified. (e.g. StartStore=2 EndStore=2 StartReg=4 will only merge in records whose Store Number is 2 and whose Register Number is 4 or higher).

Start= : Only merge transactions after this date.

End= : Only merge transactions before this date.

StartTime= : Only merge transactions after Start date and this time.

EndTime= : Only merge transactions before End date and this time.

StartStore= : Starting Store Number

EndStore= : Ending Store Number

StartReg= : Starting Register Number

EndReg= : Ending Register Number

StartClerk= : Starting Clerk Number

EndClerk= : Ending Clerk Number

StartTrans#= : Starting Transaction Number *(not supported by all categories).

EndTrans#= : Ending Transaction Number *(not supported by all categories).

The Extract=, Include=, and Exclude= parameters accept a string of one or more characters that define what types of data to merge in. These are as follows:

Supported Categories = CV1WQO5RYyA0T9s 's-Not on by default C=Customer, F=Contacts, V=SalesInvoice, 1=SalesOrder, W=Layaway, Q=Quote, Y=SalesPayment, O=PurchaseInvoice, 5=PurchaseOrder, R=ReservedOrder, y=PurchPayment, A=ROAPayment, 0=Variance, T=TimeClock, 9=Audit, s=SerialNumbers (Not on by default), ~=Clerk Passwords (Off by default) (Note that when a password is extracted, only the Password, Password Changed, and Password Expires field are updated and not the rest of the clerk's information. Storemrg will only merge in this information if the clerk's current Password Last Changed field is older than the one being merged in).

Note that Upper/Lower case DOES make a difference, therefore you must use the STOREMRG.DAT file with SerialNumbers and PurchasePayments (s and y) since the command line switches are always passed to the utility as all uppercase characters.

Keystroke POS Point Of Sale Software


STRUPDTE.EXE:

Runs the Update Inventory function from the Store-Link module. All parameters are set in the Store-Link Update parameters.

Supports all the standard Keystroke command line switches.

Keystroke POS Point Of Sale Software


UPDQTY.EXE:

Update Qty reads the file UPDQTY.DAT and then adds each Qty back into QOH.

Note: the Qty in the UPDQTY.DAT file is set to 0 as the inventory is updated. This guards against accidentally updating the same file twice. If you need to use this file more than once, then make a copy of it first.

The purpose of this program is to be used in conjunction with the WHMerge program.

This program supports most of the standard Keystroke command line switches including:

/D : Data Directory and location of UPDQTY.DAT

/E : Extension for data files (including UPDQTY.DAT)

Keystroke POS Point Of Sale Software


WHMERGE.EXE:

Warehouse Merge will read in the transaction file KSTRN001.MRG and create Sales Orders out of any invoice with a line item comment that contains any of the strings entered in the file WHMERGE.TXT or WHMERGE2.TXT. These will then be stored in the file KSTRN001.WHM which can then be merged into the warehouse. The purpose of this program is to allow the sales of an item from one store with the delivery from another store. It thus needs to deduct the qty from the Warehouse and put it back into the store that made the sale. This is done by creating a file UPDQTY.DAT which stores the Qty Adjustments. This can then be used by the program UPDQTY.EXE to put the inventory back into the store.

Comments in WHMERGE2.TXT are for items that should appear on the Warehouse sales order but will come out of the store's inventory. This is done by setting the stock number to 0 in the KSTRN001.WHM file.

Note: the comments to match ARE case sensitive .

This program supports most of the standard Keystroke command line switches as well as the following special switches.

/D : Directory to save both KSTRN001.WHM and UPDQTY.DAT files

/M : Merge Directory - put the name of the directory that contains the file KSTRN001.MRG after this switch. (/M C:\DATA)

Keystroke POS Point Of Sale Software


END OF LIST

Keystroke POS Point of Sale Software

Home | Products | Support | Dealers | Downloads | Search | Contact
Keystroke | SW Review Tool | Where To Buy | Download FREE Eval CD

|