Keystroke Custom Applications

Below is an alphabetized list of Keystroke Custom Applications (not included with Keystroke POS - call 800-359-3458 for Pricing) and a description of what each one does.

Go To:

ASC2INI.EXE:

Mapping program that maps an ASCII delimited file to an ASCII INI file format. The mapping file contains the INI field prompts followed by the number of the field of information desired from the ASCII delimited file. Multiple fields of information from the ASCII delimited file can be parsed to one INI prompt in the resulting INI file. If multiple fields are parsed to the same INI prompt the Field numbers need to be separated by a "+" or a "*" character. By placing a "+" between fields the parsed data will be separated by a space character and the "*" denotes a carriage return. An unlimited number of fields can be parsed to one INI prompt. Once the data is parsed to the new INI file, a batch file may be run to further manipulate the data. (ie. IMPTRN.EXE to import parsed Transactions)

ASC2INI.EXE can be run in stand alone or "Automatic Mode". The activation of this feature will cause the program to act as a TSR always searching for a certain file or file extension to process.

AUTOCHRG.EXE:

Processes a Keystroke POS IMPTRN.EXE import file of transactions using ActiveX Controls through PC Charge Payment Server. The results of the process can be printed to a text file or to a Windows printer. The program was developed to automate the processing of recurring transactions that are tendered using credit card payment types.

The program will read the import file and gather the Credit Card Number, Expiration Date and Amount. It will then send that information to PC Charge Payment Server for approval and return the response to the import file. Transactions that are not approved are flagged as layaways. If the file contains multiple transactions the program will instruct PC Charge Payment Server to hold the modem line open for the next transaction. Once all of the transactions have been processed a batch file may be run to further manipulate the data. (ie. IMPTRN.EXE to import into Keystroke).

CONTPRIC.EXE:

Contract Pricing adds the ability to offer special pricing per item per customer. The Contract Pricing editor is a standalone application that was created for use with the Keystroke POS program for the entry and editing of contract pricing.

The program will charge the contract price if it is not expired and it is cheaper than base price or any price table that may affect it.  The program supports one command line switch.  It is inifile=. These are the items that are stored in the inifile:

LEFT= Left Position of the main form.

TOP= Top position of the main form.

IMPORTFILE= The full name and path of the file that you want to import.

The program also supports the /d command line switch.

There are 5 main functions of the program:

Reports - This allows you to run reports that are related to the Contract pricing in your system.

Edit Cust - This allows you to choose the customer that you want to add or edit contract pricing for.

Edit Item - This is used to edit or add contract pricing for a specific Customer.

Import  - Specify the file that you want to import for contract pricing.  The file must be in the following format: "Product Code","Customer Number","Price","Expiration Date".

Note: The Contract Pricing files (CP*.DAT) are always read from the current data directory as opposed to an alternate inventory or customer directory.

CUPONCHK.EXE:

A program that will check the transaction's line item information against a Coupon Item file. If a match is found, a coupon will be printed. The program can be set up to only print the coupon form on the first print of the transaction and to not print a coupon if the transaction is edited and re-printed.

FIX2INI.EXE:

Mapping program that maps an ASCII fixed length file to an ASCII INI file format. The mapping file contains the INI field prompts followed by the starting character position, a comma and the ending character position for the field of information to be parsed. Multiple fields of information from the fixed length file can be parsed to one INI prompt in the resulting INI file. If multiple fields are parsed to the same INI prompt the field starting and ending positions need to be separated by a "+" or a "*" character. By placing a "+" between fields the parsed data will be separated by a space character and the "*" denotes a carriage return. An unlimited number of fields can be parsed to one INI prompt. Once the data is parsed to the new INI file an batch file may be run to further manipulate the data. (ie. IMPTRN.EXE to import parsed Transactions)

FIX2INI.EXE can be run in stand alone or "Automatic Mode". The activation of this feature will cause the program to act as a TSR always searching for a certain file or file extension to process.

FIXTAX.EXE:

A Keystroke POS utility program that changes the Tax Table code on saved sales transactions. An example use of the program would be to replace the tax table on saved Keystroke POS sales transactions with the tax table code for the correct tax rate so when the transaction is edited the tax rate does not recalculate incorrectly causing the transaction to be over or under tendered.

Settings:

The FIXTAX.EXE program uses one optional command line switch, INIFILE= to locate an INI file containing the program information. All other settings are defined within the specified INI file. Following is an example command line: FIXTAX.EXE INIFILE=c:\keystrok\data\FIXTAX.INI. The available settings within the above INI file are a follows: TRANSACTIONFILE= Name and location of transaction file to change taxes in. TAXTABLE= Tax table code to assign to designated transactions. TRNFROM= Starting Transaction number. TRNTO= Ending Transaction number. TRANSACTIONTYPE= Sales Invoice, Sales Order, or Layaway. BACKUPEXT= 3 character file extension to assign to backup copy of transaction file.

Notes:

The program will copy the designated transaction file using the same name and location but assign the designated Back Up extension to the file before the program changes any tax table information. For example, using BAK as the back up extension C:\KEYSTROK\DATA\KSTRN001.DAT will be copied to C:\KEYSTROK\DATA\KSTRN001.BAK before the program changes any tax table information. This is to create a back up of the file in case the changed information is incorrect.

Note:

The Keystroke POS User Bundle must be properly installed and licensed in order to run the FIXTAX.EXE program.

FLEXLINK.EXE:

A custom program that processes Keystroke transaction information for a specified payment type. The program will subtotal item Price and Tax amounts per Inventory Department per Invoice for the Payment Type specified. Thus, item amounts w/ like departments are subtotaled per Invoice. Once the Transaction information is gathered, the Inventory Department Codes are converted to Associated Revenue codes and an Output file is created. The output file is an ASCII Comma Delimited file following import specs for the FLEXLINK accounting program. The output file is to be imported into FLEXLINK. Added 09/19/00 - If the total of the tax amounts for the Line Items on the Invoice differs from the Tax amt on the Invoice record then the difference will be applied to the Line Item that has the largest tax amount on the transaction. Added to get rid of errors when importing into FLEXLINK caused by tax rounding issues from the Invoice Detail information and the Main Invoice Information.

FORMTOTL.EXE:

Program reduces the total number of Shipped items on a printed Invoice if the Invoice contains certain designated Inventory Items. The program first reads a list of Inventory Stock Numbers that are not to be included in the Total Shipped Items on the Invoice. Then it reads a list of the Stock Numbers and shipped quantities from the sales transaction and checks to see if any of the designated Stock Numbers are on the transaction. If so, then the Shipped Qty for those items is reduced from the Total Qty Shipped information on the printed Invoice.

INIMERGE.EXE

Merges data file into a master source file and sends the output to a specified device (file or printer). The data file must be in a Tagged Text (.INI format).

The Master Source file should contain Tokens that match the field names in the data file. The program will repeat the use of the master file for each series of data in the data file (e.g. line items).

The tokens are in the format &FieldName=&. These tokens will be replaced with the matching data from the data file. The token can be followed by an alignment parameter which is used to alter the data as it is put in the file. The Alignment Codes are always 3 characters and are enclosed in percent signs. Right now, the only alignment code supported is the Encrypted Cost code (% C%) which converts numbers to other characters based on the COSTCODE.TXT file.

For Example:

 "&Transaction Date=&% C%" Will print the transactions date of 09/30/02 as ANRAAW.

The program prints whenever it finds the line **END LINE ITEM in the data file. If this line is never found, then it will print when it reaches the end of the data file. The program can print multiple copies for each set of data based on the PrintQty= field in the data file. The PrintQty= token can be changed by using the COPIESTOKEN= switch (for example: COPIESTOKEN="Quantity Shipped" will print a label for each item based on the Quantity Shipped for each line item).

Note:

With the exception of the tokens used to set the Print Qty and Filter, all tokens are case sensitive (i.e. "PRODUCT CODE=" does not match "Product Code=").

Note:

As the sets the token as it reads in the file, the tokens are erased as each section is printed. Therefore, a token that is set with a value in a previous section will contain that same value unless the token is used again in current section.

The following command line switches are supported:

/R - Resident mode, program will continuously loop searching and processing files with the .FRM extension

/S - Stop, program will pause before exiting.

/A - Append Mode - if /P is used to print to a file, /A can be used to add to the end of the file instead of overwriting it each time.

SOURCE= Master file that data is merged into (default is INIMERGE.TXT)

DATAFILE= File to read data from. Wild cards can be used (default is *.FRM)

OUTPUT= Printer (or File) to send output to (default is LPT1:)

Filter="FieldTag=Condition" - will only print data sections that match the condition (FieldTag must be found or filter is ignored).(e.g. Filter="Product Code=>A" to only print items with a Product Code greater than the letter A). Note that this filter is done on a text basis only. Therefore Filter="Stock Number=>200" would print the following Stock Numbers: 5, 40, 999) but would not print (1, 110, 1250).

COPIESTOKEN=FieldTag will use the FieldTag field to determine number of copies of each data section to print (default is COPIESTOKEN="PrintQty")

KS2EXPRN.EXE:

A Keystroke POS utility program that convert customer accounts receivable data from Keystroke POS to a fixed length file for the Experian Reporting system. The program reads the Accounts Receivable data from a Keystroke Aging Detailed repot printed to a delimited file from the Keystroke POS system. The report file can be created manually from the Keystroke system or the user can have KS2EXPRN run a designated Keystroke report cue to create the report file. Once the report data has been converted the designated report file will be renamed with the .TMP file extension.

Settings:

The KS2EXPRN program uses one optional command line swtich, INIFILE= to locate an INI file containing the program information. All other settings are defined within the specified INI file. If the INIFILE= switch is omitted the default KS2EXPRN.INI in the program directory will be used. Following is a sample command line:

KS2EXPRN.EXE INIFILE=c:\keystroke\data\KS2EXPRN.INI

The settings within the above INI file are as follows:

KSPROGDIR= Location of Keystroke POS program directory.
KSDATADIR= Location of Keystroke POS data directory.
FILEOUT= Name and location of Experian file to create.
REPORTFILE= Name and location of Keystroke POS aging detailed report file.
REPORTCUE= (optional) Name of Keystroke POS report cue to have KS2EXPRN execute to create the designated report file.
CUSTID= Used to designate Keystroke customer ID to use as Experian Accounts Receivable Number or Customer Number. 0 = Customer Number, 1 = Customer Code, 2 = Customer Name, 3 = Customer Phone, 4 = Customer Zip Code.
CONTRIBNUM= Experian Assigned Contributor Number.
BUSINESSCATG= Business Category for business sending data to Experian. (See Experian documentation)
CLOSEDATE= Closing date for for Accounts Receivable Period.
SICCODE= SIC Code for business sending data to Experian.
RUNRPTCUE= 0 = Do not run a report cue, 1 = Run designated report cue.
DISPLAYAMT= Used to designate the Customers' Account balance to have Experian display on report. 0 = Actual Amount, 1 = +$100,000, 2 = +$200,000, 3 = +$300,000, 4 = +$400,000, 5 = +$500,000, 6 = +$600,000, 7 = +$700,000, 8 = +$800,000, 9 = +$900,000.

Notes:

When assigning grace period information for Customers, the program will assign the global grace period set in the Keystroke Accounts Receivable Finance Charge parameters unless the grace period field on the Customer's record contains a value other than 0. Then the program will assign that customers respective grace period to their record in the Experian file. The customer shipping address will be used unless blank, then the mailing address information will be used.

Note:

The Keystroke POS User Bundle must be properly installed and licensed in order to run the KS2EXPRN.EXE program.

KS2XMLQB.EXE:

Standalone Keystroke Utility that exports Keystroke General Journal information to a file called journal.rpt. This file is stored in the Program directory.  The program will then prompt you to import the file to QuickBooks 2002. The first time that you run the program, you will have to allow access to your QuickBooks Company file in QuickBooks. If you have QuickBooks open on your Windows desktop and are logged in as an administrator, QuickBooks will prompt  you to see if you want to allow the program to access your company file. If you choose Yes, Always, then Quickbooks will always allow the program access when QuickBooks is open. If you choose the path to Quickbooks on the User Interface, and in your QuickBooks preferences section you allow the application to login automatically, then you do not even need to have QuickBooks running to use the program. The program creates these files in the process of running:

KS2QB.RPT - File that is written out by the Keystroke General Journal that is the same as a Keystroke General Journal Report printed to a delimited file.

KS2QBLOG.TXT- This file is written to every time the program is run. It stores the same information as postlog.txt, but it will continue to grow till it reaches the 8mb limit, at which point it will be copied to the filename KS2QBLOG.OLD.

POSTLOG.TXT - This is a file that is written for the current post.

XMLFILE.DAT - The XML data that the program merges into the QuickBooks program.

QBSDKLOG.TXT- A very detailed file that is written by the QuickBooks  SDK that logs everything that is posted by KSXML2QB.EXE.

The program supports the inifile= command line switch. The fields that are in the inifile are as follows:

KSDIR= - The path to your Keystroke Data.
QBFILE= - The full path to your QuickBooks company file.
LEFT= - The horizontal starting position of the program on. your screen.
TOP= - The veritcal starting position of the program on your screen.
IMPORTFILE= - The file that you import when the Post Existing GL-Link Data File Parameter is checked.
PROMPT= - The Parameter Prompt for Date Range (1=On 0=Off).
POST= - The Parameter Post Existing GL-Link Data File (1=On 0=Off).
DISPLAY= - The Parameter Display GL Entries Before Posting. This displays a message box that lists the number of GL Entries that are in the current file, and asks if. You would like to post them. (1=On 0=Off)

KS2WTCOM.EXE:

A Keystroke POS utility program to convert a specified date of transaction information to a fixed length file for import into the WineTasting.com system. The program reads the transaction information from the specified Keystroke POS data directory for the date specified and parses the information to the designated File Out. WineTasting.com takes the transaction information and creates an electronic invoice and ships the products on each transaction converted. For example, to ship out the packages for a batch of wine club transactions.

Settings:

The KS2WTCOM program uses one optional command line switch, INIFILE= to locate an INI file containing the program information. All other settings are defined within the specified INI file. If the INIFILE= switch is omitted the default  KS2WTCOM.INI in the program directory will be used. Following is a sample command line:

KS2WTCOM.EXE INIFILE=c:\keystrok\data\KS2WTCOM.INI

The settings within the above INI file are as follows:

KSDATADIR= Location of Keystroke POS data directory.
FILEOUT= Name and location of WineTasting.com fixed length file to create.
TRNSDATE= Transaction date to process, if AUTOMODE(see below) is 0 then will use date specified after the prompt. If AUTOMODE is 1 then will use the current system date.
AUTOMODE= 0 = OFF, 1 = ON. If set to 1 (ON) then the program will use the current system date. If set 0 (OFF) then will use the date specified in the TRNSDATE= prompt above.
USEPRICE= 0 = NO, 1 = YES. If set to 1(YES) then the Use Price flag in the fixed length file being created will be set to Y.
USEFREIGHT= 0 = NO, 1 = YES. If set to 1(YES) then the Use Freight flag in the fixed length file being created will be set to Y.
WINERY= Five character code for winery converting files for WineTasting.com. Assigned by WineTasting.com
BATCHNUM= Batch number to assign to transaction information in the converted fixed length file.
ITEMID= Keystroke inventory item ID to assign to item information in file out. 0 = Stock Number, 1 = Product Code, 2 = Class, 3 = Description Default is Stock Number.

Notes:

If the designated fixed length file exists, then the program will prompt to overwrite the existing file. If the YES to overwrite is chosen then the old File Out will be renamed with a .TMP file extension.

Note:

The Keystroke POS User Bundle must be properly installed and licensed in order to run the KS2WTCOM.EXE program.

KSSERNUM.EXE:

A Keystroke POS utility program that parses an ASCII delimited file of Inventory Serial number information to an ASCII delimited file that can be imported into Keystroke POS using the Importer Custom Module. Once all of the data has been parsed a batch file or other custom program can be executed to further manipulate the data. An example use of the KSSERNUM.EXE program would be to scan all of the serial numbers and item id information for inventory items and use the Keystroke POS Importer to update the Inventory Database.

Settings:

The KSSERNUM.EXE program uses one optional command line switch, INIFILE= to locate an INI file containing the program information. All other settings are defined within the specified INI File. Following is an example command line: KSSERNUM.EXE INIFILE=c:\keystrok\data\KSSERNUM.INI
The available settings within the above INI file are as follows:
FILEIN= Location of ASCII Quote/Comma Delimited file to be converted.
FILEOUT= Filename and location of resulting converted file.
BATCHFILE= Used to specify an optional batch file or other program which will run immediately following the KSSERNUM.EXE program.

Notes:

The file to be converted is a simple ASCII delimited file that contains the Inventory Item's Keystroke ID in the first field and a serial number for that item in the second field. Following is an example record using Stock Number 25 for the Item ID: 25,125k77h.

Each record in the file should only contain one serial number  for the item. If there are multiple serial numbers for an item that item will have multiple records in the file.

KSSERNUM.EXE will group each item by its respective item
ID and parse the items information to one record in the converted file. The serial number information for Inventory Item will be appended to that item's record and separated by an ASCII Character 255. This follows Keystroke POS Importer guidelines for importing serial numbers.

**Please Note:

When using the importer to import Inventory serial number information that the serial numbers being imported will overwrite the serial numbers saved in Keystroke for the respective items.

This program requires the Keystroke POS User Bundle.

NVC2LBL.EXE:

Allow the user to print labels for items from a Sales or Purchase Transaction. The program can print one label for each item on an Invoice or if the QTY is more than one a Loop Token can be used to print Multiple labels for one line item on the transaction.

Future:

1. Add a filter feature that will allow the user to print labels for certain designated items. Will filter all Line Items for a match/no match.

PADANY.EXE:

This program pads the left side of any string in a fixed length file with any of the available ascii keyboard characters. The program currently supports the following inifile settings:

STARTPOS= This is the horizontal position on the Line that PADANY.EXE will start reading the string from. Must be Numeric. Also will be used for field# in CSV Files(future).
LASTPOS= This is the last position in the string for the program to convert. Must be Numeric.
LINEBEGINS= This optional setting allows you to specify a character string that the lines you are padding will begin with.  Default is nothing and the program will pad every line.
REMOVE= This optional parameter works with the LINEBEGINS=. If it is set to Yes, then it will use this to determine whether or not to print those characters on the output. If this parameters set to yes, then the program will remove whatever is after
LINEBEGINS= and the associated spaces.
PADCHAR= Supports any 1 character string.
INPUTFILE= The file that needs to be padded.
OUTPUTFILE= The file that the program will output after padding it
RUNCOMMAND= An Optional command that the program can run after printing the file.

RPTDATE.EXE:

Reads a Date value from a file (default = RPTDATE.DTE) and then replaces the token values "$$" in the batch file with the date read from the date file.

Once the tokens have been replaced in the batch file, the program executes the batch file and updates the date value in the date file with the current date.

Designed to automate the running of date sensitive report cues during the Polling process.

RUNTIMER.EXE:

Performs a specified command string at designated minute intervals. The user interface gathers the command string to perform and the time interval (in Minutes) in which to perform the command. When the user has entered all the information and executes the program it will immediately perform the command string specified. Then RUNTIMER will wait the designated time period before running the command string again. Before the command string is executed again the program will send an ESC to the active window. This allows batch files or other processes to be terminated before the command string is run again. Sample usage: printing inventory levels to screen and refreshing periodically.

TRN2FIX.EXE:

Converts Keystroke POS Transaction data to Fixed Length records. The Program uses a IMPTRN format to parse the data field information.

Settings:

The TRN2FIX.EXE Program uses one optional command line switch, INIFILE= to locate and INI file containing the program inforamtion. All other settings are defined within the the specified INI file. Following is an example command line: TRN2FIX.EXE INIFILE=c:\keystrok\data\TRN2FIX.INI The available settings within the above INI file are as follows:

FILEIN= Location of the file to be converted.
FILEOUT= Name and location of resulting converted fixed length file.
BATCHFILE= Used to specify an optional batch file or other program to which will run immediately following the TRN2FIX.EXE program.
VAR1= Data for Variable #1
VAR1LABEL= Label Text for Variable #1 (Can also be edited in Program)

FILE FORMAT:

The file format is a simple ASCII Delimited string for each field of information to be parsed to the fixed length file. Each field's information is contained on a separate line in the file. The beginning of a Transaction is denoted with **START TRANSACTION and the end with **END TRANSACTION. The beginning and end of each Line Item is denoted with **START LINE ITEM and **END LINE ITEM respectively. The field information for each field of data is defined by using an ASCII delimited string in the following format:

Field Position, Field Length, Field Data Type, Pad Character, Field Data 

See TRN2FIX.NVC for an Example.

DATA TYPES:

There are 3 different Data Types that may be used, C, N, or V.

C = Character/Text - Data will be Left Justified in the field

N = Numberic - Data will be Right Justified in the field
N(#) - Numeric Data where # equals the number of decimal places to to use, if no decimal then do not use.
N(+#) - Numeric Counter where # is the counter starting number. If a Counter data type is used in the Header Section the counter will increment for each record or transaction. If the Counter data type is used in the Line Item section the counter will increment for each line in the file.
N(-99) - Numeric data where decimal will be stripped from the value. This is used where a decimal value is implied in Fixed Length file. For Example: 2 Digits implied - 2.50 is changed to 250
V# = Variable - Variable Data where # is the Variable Number. This is used where there is data that is not contained in the Input file but needs to be placed in the Fixed Length File. You can assign the Variable information in the Program's INI file or by using on-screen prompts and the Variable data will be inserted in fields that have the Variable Data Type. Currently only supports Variable #1.

Note:

The Keystroke POS User Bundle must be properly installed and licensed in order to run the TRN2FIX.EXE program.

WORTHRF.EXE:

Interfaces a Worth RF Data Collector and Keystroke POS. The program creates import files to be imported onto a Variance, Sales Order, or Purchase Order. It also can create a Price Update file to be used with the Keystroke Importer to update prices on Inventory items. The Program will gather the entered or scanned Item ID information and return the Keystroke Inventory database item information to the Hand Held Unit. The user can configure the program to prompt for Qty or not. If an item is not found the user is given the choice to add the item information to the file or discard it.

Upon execution, the Program’s interface screen will come up. From here the user needs to set the Program’s prompts to the desired settings. Once the Program’s settings are entered click or enter on the Run button. The Program will export the  items. The Program will gather the entered or scanned Item ID information and return the Keystroke Inventory Database to file and read in the Inventory Item Information. Once the Inventory Item Information has been read the Program will prompt for the Hand Held RF unit to Sign In. The Unit must Sign In for the Program to proceed. Once Signed In the Program will send a prompt to the Hand Held RF unit to enter an Item ID. When an Item ID is scanned or entered the Hand Held unit will transmit the information the Base Unit and the WorthRF program will read the Item ID Information. Taking the Item ID Information the program will query the  items. The Program will gather the entered or scanned Item ID information and return the Keystroke POS Inventory Database for the Item Information. If the Item is found in the Database the Item Information will be transmitted back to and displayed on the Hand Held RF unit. If an entered Item is not found in the Database the user will be prompted that the Item was not found and asked if they would like to add the Item to the file. When entering Item Quantity or Price information on the Hand Held RF unit, if the Item’s Price or Quantity is the same as displayed on the Hand Held RF unit just hitting enter on the Hand Held RF unit will write the current Quantity or Price to file. If the Hand Held RF Unit is turned off or Signed Out the program will prompt asking if you would like to quit the Program or Sign In again and continue.

END OF LIST