Keystroke Integration & E-Commerce Utilities

Below is an alphabetized list of Integration & E-Commerce Utilities included with Keystroke POS (User Bundle license required) and a description of what each one does.

Go To:

ADDDATE.EXE:

Runs the ADDFIELD.EXE Utility (see below) and adds the current date or desired date to the end of a text file.

ADDFIELD.EXE:

Copies data from one file to another file while adding new text (FieldInfo) to the end of each record. This can be used to add one or more fields to a file that may be required in order to import the information into another program. Can also be used in conjunction with MAPFILE.EXE.

The syntax is ADDFIELD FileName1 FileName2 FieldInfo

All parameters must be specified. FileName2 will be overwritten if it already exists.

Example:

ADDFIELD EXPORT.TXT INV22.TXT , "22" will copy EXPORT.TXT to INV22.TXT while adding: , "22" to the end of each record.

ARPAYOFF.EXE:< /p>

Pays Off all open items (except Credit Memos) on all customers. This is the same as the Automatic Payments function in the AR Module with Pay Off set to All and no filter set. Please see the help screen [F1] on this function for more information.

Supports the standard Keystroke command line switches. It also supports the following special switches:

/NOP : No Pause - Eliminates warning prompt.

PriorTo= : Only items dated before this date will be paid off. The default is the current date. (PriorTo=6/15/00)

Ref= : Text to be entered in ROA payments Reference Field. Should be enclosed in quotes. Default is Blank. (Ref="Automatic Pay Off Payment")

PayNum= : The payment type to be used to create each ROA payment. This is the Payment's Number as seen in parentheses on the list of Sales Payments in the Configuration Manager or as shown on the Payment Types report. Default is payment type AR Adjustments (PayNum=8).

BATCHPRN.EXE:

Batch Print is an executable Keystroke program which will print a range of transactions to the specified printer create in the specified form format. It is designed to be used for printing a batch of sales transactions after they have been entered into the system but not yet printed (e.g. after using RecMerge to import a series of Recurring Invoices.

The series to be printed is defined by the type of transaction (default is SalesInvoice) and the date/time range (default is last Midnight through current Date/Time). Up to two filters (same selection as the Sales Transactions report) can also be used to further define the batch. The form/printer used is determined by the Print Button #1 or you can enter which print button to use or you can specify the form, printer, and number of copies to print. (If the FORM= parameter is used then the BUTTON= parameter is ignored).

The parameters used can be entered as command line switches or in an INI file. (Command line switch will always override any parameters set by the INI file.) The name of the INIFILE can be set by using the INIFILE= command line switch.

The standard Keystroke command line switches are supported as well as the following special switches:

INIFILE= : Enter the name of the file which holds the parameters to run this program (instead of having to use the command line switches). (INIFILE=DATA\BATCHPRN.INI)

TYPE= : Type of transaction to print (SALESINVOICE, SALESORDER, LAYAWAY)

START= : Starting Date (default=Today)

END= : Ending Date (default=Today)

STARTTIME= : Starting Time (default=Last Midnight)

ENDTIME= : Ending Time (default=Right Now)

BUTTON= : Number of Print Button to use (1,2,3,4)

FORM= : Name of form file (e.g. KSP8X11.NVC)

PRINTER= : Number of the printer to use (1,2,3,...) (e.g. PRINTER=1 for to print to the Report Printer).

COPIES= : Number of copies to print (default is 1)

FILTER= : put the filter to be used after this switch. The format is the filter number (position of field on Sales Transactions report) followed by the condition which is enclosed in quotes. For example, FILTER=2">10440 AND <10449", would print those with a Transaction Number between 10440 and 10449. (Up to 2 filters can be entered).

FILTERJOIN= : Specify how to combine the two filters (AND, OR) (e.g. FILTERS=AND if both filters must match).

BODLINK.EXE:

Used to copy marked records (records are marked by pressing [Alt+A] or [Ctrl+Enter]) from the BOD (Bike-alog - www.Bike-alog.com ) database to a file called BOD.TXT which will be located in the Keystroke program directory. The Keystroke Importer module can then be used to read these records into the Keystroke inventory database (either to update current items and/or add new ones).

Before running this utility, the BOD_HOME variable must be set to the location of the BOD files and the BOD Point of Sale Extension must be installed.

The utility will call the BOD EXPORT.EXE and will instruct it to use the KEYSTROK.TPL to determine what gets exported. The resulting BOD.TXT file will contain the following fields:

1) Item ID (required for updates - 6 digits long)

2) Sequence Number (12 digits long)

3) Department

4) Sub-Department

5) Retail Price (based on BOD markup tables)

6) Wholesale Price

7) Description

8) Extended Description (put in comment field, up to 400 characters)

Remember, all these fields do not need to be used and  one field can placed into more than one Keystroke field. Also, the Item ID field must be put into either the Keystroke Product Code, Class or Manufacturer field if  you plan to use the BOD update feature. Please refer to the Importer documentation and the file IMP.DOC for more complete information on its options and setup features.

CUSTDATE.EXE

Used with ARPAYOFF.EXE to reset every customer's Oldest Open Invoice Date to the current Date/Time.

Supports the standard Keystroke command line switches.

DATACAPT.EXE:

Used in the first step to read stored data from a portable barcode data collector into Keystroketransaction (Variance, Sales Order, etc.).

Data stored in the data capture device is read through the serial port and stored in the file COUNT.TXT. The data is  first read into COUNT.TMP and is then converted from COUNT.TMP to COUNT.TXT.

Usage:

DATACAPT [(Port:)[(Baud, Parity, Data Bits, Stop Bits, Buffer Size)] [/C]

Example: DATACAPT COM1:2400,N,8,1,32767

Valid switches for this utility are:

/C : Do not read data from device, only convert data from COUNT.TMP to COUNT.TXT

DATENAME.EXE:

DateName will change 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 program will make a file called DATENAME.LST that will contain the name of the file created.

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

DBLISTS.EXE:

DBLISTS is a Windows utility that is used for editing the Valid Entries List Files that are available for each database field in Keystroke. Keystroke uses these lists (if they exist) to validate entries made into each field as well as to provide the clerk with the ability to look up an entry on the list by pressing [Ins] while in the database field.

The lists can be stored in Plain Text format where each line represents a value available for the field. The lists can also be stored in an XML based format or a special Binary format. The Plain Text and XML based formats can be edited with a standard text editor. This program can edit all three types of files including the Binary format (which has the same features as the XML format but is smaller and faster).

The XML and Binary formats support additional fields. These fields are: Value, Entry Code, Description, and Other Fields. When validating an entry, the program will check against both the Value and Entry Code fields.

The Value field is what will be placed in the database field when this entry is selected from the list.

The Entry Code field allows for a short code to be entered in the database field and the program will then replace it with its Value (e.g. A zip code file could have a line with Value of 90803 and Entry Code of 3. Entering just a 3 in the Zip Code field on the customer record and pressing [Enter] would cause the program to replace the 3 with the full zip code of 90803).

The Description is only used when selecting from the list and is just added instructions to help describe what each entry is for.

The Other Fields entry allows the selection from the current field's list to update other fields. (e.g. a zip code list could have an Other Fields entry to enter the City and State based on the selected zip code. So using the example from Entry Code, the 3 in Zip Code would not only cause 90803 to be put in the Zip Code field but would also put Long Beach in the City field and CA in the State field).

The program supports the /d data switch as well as the inifile= switch. The program also supports a few optional command line switches. These include:

DATABASE= : Character that is related to the database "I"=Inventory, "C"=Customer, "V"=Vendor, "X"=Matrix, "O"=Contact, "K"=Clerk, "D"=Department, "G"=Category, "L"=Location.

FIELD= : Field Number that is associated with the database field.A list of field numbers can be found in dblists.pdf.

FILENAME= : The file that will be opened by the program. This overrides the DATABASE= and FIELD= settings.

The inifile is in the standard inifile format and supports the following inifile settings:

TOP= : top position of your main form
LEFT= : left position of your main form
HEIGHT= : height of your grid form
WIDTH= : width of your grid form
FILETYPE= : default file type (BINARY OR XML)
VIEWTOP= : top position of your grid form
VIEWLEFT= : left position of your grid form

EXPSUM.EXE:

Copies one or more Summary Data files to a file in an ASCII Delimited format. The utility will create files with the same names as the original file but with the extension of .TXT.

Supports the switches FILE= and TAB=ON. The FILE= switch supports both a full path as well as wild card characters. If it is not used then the utility will export all the files that match DATA\SUMMARY\*.DAT. The TAB=ON parameter will create a Tab Delimited instead of a Quote/Comma Delimited file.

The first record of the file is a header containing the names of the fields. The second record is the Grand Totals for all the other records. Only records with information in them are written to the .TXT file.

FILESORT.EXE:

Sorts a file of fixed length records. It is mainly used by the Report Generator to create reports sorted in ways not supported by the Keystroke Database Engine.

The syntax is:

FILESORT FileName RecordLength

Both parameters must be specified.

FORM2LBL.EXE:

Prints Labels from the Sales Manager. This utility enables the placement of information available only in the header section of a form to be placed within each line item (the body section).

It does this by reading in a text file which contains Token definitions in the header section and then replacing the Tokens found in the body section with the value of the token. The text file name must have the extension .FRM. The utility will search for any file with the extension .FRM and then read it in, replace the tokens, and then send it out to the printer.

A token is defined by placing a single character between two ampersands followed by the value of the token: /h4>

&C&Joe Smith

The above statement defines the token &C& to be the name Joe Smith. The header section must end with a line that starts with &&. In the body section, include the token where ever you want its value to appear.

Item purchase by: &C&

The above will cause the utility to replace &C& with Joe Smith.

The following switches are supported:

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

/S - Stop, will pause before exiting.

/P - Printer output, the converted file will be sent to the device/filename following the /P.

/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.

FORMQTY.EXE:

Reformats a number in a text file to have a fixed number of decimal points. It is intended to be used when printing forms out of the Keystroke program.

The text file name must have the extension .FRM. The utility will search for any file with the extension .FRM and then read it in, replace the Qty token with a reformatted number that has the specified number of decimal points, and then send it out to the printer.

A Qty Token is defined by placing the three characters "&Q#" (where # is replace by the number of decimal points) in front of the number and a single character "&" after it:

&Q2 1& will be changed to 1.00< /p>

&Q2 1.2& will be changed to 1.20

&Q2 99.999& will be changed to 100.00

Note that the token characters are thrown away. So when creating a form, don't count the spaces taken up by the &Q# or the last &.

The following switches are supported:

/R - Resident mode, will continuously loop searching and processing

files with the .FRM extension

/S - Stop, will pause before exiting.

/P - Printer output, the converted file will be sent to the device/filename following the / P.

GETMAIL.EXE:

Reads entries in the Email Inbox of the specified MAPI server. Entries that match the specified parameters will have their attachments saved to the specified path and will then be deleted.

This utility is designed to be used in e-Commerce applications as well as Multi-Store polling procedures.

The settings are controlled through the file GETMAIL.INI. The only command line switch supported is INIFILE= to use a different file than GETMAIL.INI.

The following INI file parameters are supported:

NoPause= - Batch mode, if on (1) then it will not stop to display any messages.

UserName= - Specify the name (or profile) of the MAPI Server to use (e.g UserName = Microsoft Outlook)

Password= - specify if needed for selected UserName

Subject= - A 'Starts With' filter - first characters of email's subject must match whats listed here (leave blank to match all) if AddSubjectToPath switch is on then characters in email's subject following match are used as subdirectory name when saving attachments. (e.g. to save files to STORE1\, STORE2\, etc.)

NoteText= - A 'Starts With' filter - first characters of email's message must match (leave blank to match all). Note: some email programs do not return correct text, in which case this must be left blank.

AddSubjectToPath= - if on (1) then characters on right side of subject line will be included in path to save attachments.

AttachmentPath= - Sub Directory to save attachments to (will be below Program Directory + Right hand characters of email's Subject line (if AddSubjectToPath is On). (e.g. AttachmentPath=HOLD\)

SaveTo= - Full FileName (including path) of where to save attachment to. If this is used then the AddSubjectToPath and AttachmentPath parameters will be ignored. (e.g. SaveTo=C:\KEYSTROK\ORDERS\NEWORDER.TXT)

NOTES:

If the file already exists that the attachment should be saved to, then that E-Mail message will be skipped. This leaves it in your In Box where it can be accessed again after the existing file is removed.

GLLINK.EXE:

Create journal entries into the specified file and format as setup through the Keystroke program.

Supports the standard Keystroke command line switches. It also supports the following special switches:

/NOP : No Pause - Eliminates warning prompts.

Start= : Starting Date - put the date to mark the start of the linked period after this switch. (Start=4/10/94)

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

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

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

IMP.EXE:

Imports data from a specified file.

Supports most of the standard Keystroke command line switches.

It also supports the following special switches:

/C : Customer - Import to Customer database.

/V : Vendor - Import to Vendor database.

/P : Department - Import to Department database.

/T : caTegory - Import to Category database.

/L : Location - Import to Location database.

/X : matriX items - Import to Matrix Item database.

If neither /C, /V, /P, /T, /L or /X is specified then the Inventory database is assumed.

/R : Replace - Delete existing data and replace it with the imported DATA

/A : Append - Append imported data to the end of the existing data.

If neither /R or /A are specified merge is assumed.

/S : Setup File - put the name of the setup file (.KSI) after the switch, ie (/S KSIMPORT). The file must be in the FORMS\ subdirectory.

Note:

You cannot use the /R switch with the Department, Category, or Location databases. That's because the Replace function is done by simple erasing the file and then importing the records into a new file. But since Departments, Categories and Locations share the same file, erasing one of the databases would also erase the other.

Note:

Matrix Items can only be imported using the Windows Version of the Import Module.

IMPPOR.EXE / WIMPPOR.EXE:

Reads an ASCII file of transaction information (in an INI format) and creates new purchase transactions from the information provided. Each transaction must start with the line **START TRANSACTION and end with **END TRANSACTION. Line Items use **START LINE ITEM and **END LINE ITEM. This allows multiple transactions within the same file.

Each piece of information will be preceded by the field's title followed by an equal sign. The titles are the same ones used by the forms editor but not all fields are supported. Use the form file IMPPOR.NVC to see a complete list of fields supported and an example of how the file should look. Fields marked by '** are supported but should be avoided when possible). Also see ORDERS.NVC for a stripped down example. Note that the order of the fields does not matter in most cases. However, it does matter when identifying vendors and inventory items by fields other than the vendor number and stock number. If the number field is not imported, then the first indexed field used in the file will be used to look up the database record. Also, the field used to identify the vendor/inventory record should be the first field since when the record is looked up, all fields are updated based on that record. (i.e., If some of the fields from the transaction are read in and then the record is looked up, the transaction fields already read in will be replaced with the information from the database record).

Any setting made by the imported transaction will be retained whenever possible (e.g. Sales Tax amount, Transaction Number, etc.) Any information not included in the imported file will use default values (just as if a new transaction was being entered by hand).

The parameters used can be entered as command line switches or in an INI file. (Command line switch will always override any parameters set by the INI file.) The name of the INIFILE can be set by using the INIFILE= command line switch.

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

INIFILE= : Enter the name of the file which holds the parameters to run this program (instead of having to use the command line switches). (INIFILE=DATA\IMPPOR.INI)

FILENAME= : The name of the file to be imported. (REQUIRED)

DATE= : Date assigned to transactions if date is not imported.

TIME= : Time assigned to transactions if time is not imported.

CLERKNUM= : Clerknumber assigned to transaction if it's not imported.

NODISPLAY= : If NODISPLAY=ON then the program won't display its status as it imports the transactions. This will enable the program to run faster.

NOPAUSE= : If NOPAUSE=ON then program will not stop at screen that displays info about the file to be imported.

CONFIRM= : If CONFIRM=ON then program will display each transaction and allow you to select whether or not to import it.

ADDNEWVENDOR= ; [ON] If vendor is not found then a new one will be created

UPDATEVENDOR= ; [ON] Vendor fields will be updated if found (default=ON).

UPDATEBY= ; (N|D|V) If this switch is used then the program will first try to locate and update an existing transaction based on the Transction (N)umber (inludes letter), Transaction (D)ate, and/or (V)Vendor. If no match is found then a new transaction will be added.

ADDLINES= ; [OFF] If on then program will add line items to an existing transaction instead of replacing them. **Must also be using UPDATEBY= switch.

MERGELINES= ; [OFF] If on then program will merge multiple lines that contain the same item into one, (The line must NOT have a comment and Stocknumber / Description / Class / Price / Cost must be the same)

BUTTON= ; [0] If set to a valid print button then the program will immediately print the transaction using the form/printer specified by the print button. Valid numbers are 1 to 4 and it must have been set up in the Configuration Manager - Tables - Print Buttons function)

Notes:

If the "RESERVED/ORDER" field is not used then the transaction will be a Purchase Order (or Reserved if Purchase Orders are disabled).

If a Clerk is not assigned (or set to 0) then the program will assign Clerk Number 1 to the transaction. Clerks can be looked up by their Initials.

If vendor information is included, then the vendor record will be updated (or a new vendor will be created if the vendor is not found) with the information on the included fields. (Except when ADDNEWVENDOR= or UPDATEVENDOR= are turned OFF).

If Quantity Received for each line item is not specified then it will be set to 0 (creating open orders) no matter what the transaction type is.

Importing a Purchase Order with quantities marked as received will not create an invoice to reflect the received quantities. Also, when importing a Purchase Invoice, the program will not try to update the Order that the Invoice may have come from. For this reason, if you want to have both Purchase Orders and Purchase Invoices that agree with each other, you must import both of them as they would be after the transaction is finished.

Note: The Delete Filled Orders parameter is ignored by this program.  If you import a Purchase Order with filled items, it will not be automatically removed and will remain in your data files as a Purchase Order.

To exclude fields from being read from the file to be imported, simply put a comment character (e.g., ' or * or ;) in front of field name. This will allow you to include the information in the text file But ImpPor program will ignore it (since it won't recognize the field name).

UPDATEBY= As with updating vendors, the fields you are updating by should come first since reading in the matching transaction will throw away any information read up to that point. If updating by Date and Time, the TRANSACTION TIME field must precede the TRANSACTION DATE field. To import a transaction with today's date, include the INVOICE DATE= field but just leave it blank.

IMPTRN.EXE / WIMPTRN.EXE:

Import Transactions is an executable Keystroke Program which will read an ASCII file of transaction information (in an INI format) and create new transactions from the information provided. Each transaction must start with the line **START TRANSACTION and end with **END TRANSACTION. Line Items use **START LINE ITEM and **END LINE ITEM. This allows multiple transactions within the same file.

Each piece of information will be precceeded by the field's title followed by an equal sign. The titles are the same ones used by the forms editor but not all fields are supported. Use the form file IMPTRN.NVC to see a complete list of fields supported and an example of how the file should look. (Fields marked by '** are supported but should be avoided when possible). Also see ORDERS.NVC for a stripped down example. Note that the order of the fields does not matter in most cases. However, it does matter when identifying customers and inventory items by fields other than the customer number and stock number. If the number field is not imported, then the first indexed field used in the file will be used to look up the database record. Also, the field used to identify the customer/inventory record should be the first field since when the record is looked up, all fields are updated based on that record. (i.e., If some of the fields from the transaction are read in and then the record is looked up, the transaction fields already read in will be replaced with the information from the database record).

Any setting made by the imported transaction will be retained whenever possible (e.g. Sales Tax amount, Transaction Number, etc.) Any information not included in the imported file will use default values (just as if a new transaction was being entered by hand).

The parameters used can be entered as command line switches or in an INI file. (Command line switch will always override any parameters set by the INI file.) The name of the INIFILE can be set by using the INIFILE= command line switch.

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

INIFILE= : Enter the name of the file which holds the parameters to run this program (instead of having to use the command line switches). (INIFILE=DATA\IMPTRN.INI)

FILENAME= : The name of the file to be imported. (REQUIRED)

TYPENAME=: matches with the Short Name entered on the Sales transaction type.

TYPEABBREV=: matches with the abbreviation entered on the Sales transaction type.

DATE= : Date assigned to transactions if date is not imported.

TIME= : Time assigned to transactions if time is not imported.

CLERKNUM= : Clerknumber assigned to transaction if it's not imported.

NODISPLAY= : If NODISPLAY=ON then the program won't display its status as it imports the transactions. This will enable the program to run faster.

NOPAUSE= : If NOPAUSE=ON then program will not stop at screen that displays info about the file to be imported.

CONFIRM= : If CONFIRM=ON then program will display each transaction and allow you to select whether or not to import it.

ADDNEWCUST= ; [ON] If customer is not found then a new one will be created.

UPDATECUST= ; [ON] Customer fields will be updated if found (default=ON).

UPDATEBY= ; (N|D|C) If this switch is used then the program will first try to locate and update an existing transaction based on the Transction (N)umber (includes letter), Transaction (D)ate, and/or (C)ustomer. If no match is found then a new transaction will be added.

ADDLINES= ; [OFF] If on then program will add line items to an existing transaction instead of replacing them. **Must also be using UPDATEBY= switch.

MERGELINES= ; [OFF] If on then program will merge multiple lines that contain the same item into one, (The line must NOT have a comment and Stocknumber/Description/Class/Price/Cost must be the same).

BUTTON= ; [0] If set to a valid print button then the program will immediately print the transaction using the form/printer specified by the print button. Valid numbers are 1 to 4 and it must have been set up in the Configuration Manager - Tables - Print Buttons function).

Notes:

If the "Layaway/Order" field is not used then the transaction will be a Sales Order (or Layaway if Sales Orders are disabled). If the transaction is marked as an invoice (Layaway/Order is specified by a value of blank) then it will be saved as a Layaway if payments don't match total.

If a Clerk is not assigned (or set to 0) then the program will assign Clerk Number 1 to the transaction.

Clerks can be looked up by their Initials.

If customer information is included, then the customer record will be updated (or a new customer will be created if the customer is not found) with the information on the included fields. (Except when ADDNEWCUST= or UPDATECUST= are turned OFF).

If Quantity Shipped for each line item is not specified then it will be set to 0 (creating back orders) no matter what the transaction type is. Also, Invoices are not created for Orders with a shipped quantity. Therefore, you must import both the Sales Order and the Invoice for Orders that are imported as already filled (either completely or partially). Because of this, the Delete Filled Orders parameter is ignored by this program.

If Sales Tax is imported then the Manual Tax Flag will be marked on and sales tax will not be calculated. (This will cause the Tax Category and District reports to not be able to show full details of how the tax was calculated).

To exclude fields from being read from the file to be imported, simply put a comment character (e.g., ' or * or ;) in front of field name. This will allow you to include the information in the text file but ImpTrn program will ignore it (since it won't recognize the field name).

UPDATEBY= As with updating customers, the fields you are updating by should come first since reading in the matching transaction will throw away any information read up to that point. If updating by Date and Time, the INVOICE TIME field must precede the INVOICE DATE field. To import a transaction with todays date, include the Invoice Date= field but just leave it blank.

KSEXPORT.EXE/ WSEXPORT.EXE:

Executes the Export function found in the Configuration Manager. (The record layout is described in the .HDR file located in the DOC\ subdirectory).

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

File= : put the name of the file you want to write to after this switch.

File2= : put the name of the file you want to print the line item detail to for transaction exports after this switch.

Type= : put what to export after this switch. The two character variables are determined by the HotKeys (highlighted letter) for each type of data that can be exported using the standard Export function in the Configuration Manager (e.g., Databases/Inventory, Sales ransactions/A-Sales Invoices).

Sort= : put the field you want to sort by after this switch.

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. One or two filters are supported.

FilterJoin= : Specify how to combine the two filters (AND, OR) (e.g. filterJoin=AND if both filters must match).

Tab= : Tab Delimited - put on or off after this flag to toggle tab delimited output.

Start= : When exporting transactions Start=Starting Date - put the date to mark the start of the exported period after this switch. (Start=04/10/00). When exporting databases, Start=Start of range of data (based on Sort setting). Start=90803(a zip code).

End= : When exporting transactions End=Ending Date - put the date to mark the end of the exported period after this switch. (End=05/26/00). When exporting databases, End=End of range of data (based on Sort setting). End=90999(a zip code).

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

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

Example: KSEXPORT TYPE=SA SORT=5 FILE=MONEY.TXT START=90803 END=90803-9999 FILTER=29">0".

MAPFILE.EXE:

Copies an ASCII Delimited file to another file while rearranging the order of the fields. The field order is determined by the specified Mapping File. The Mapping File is a simple text file with one number on each line. The line number is the field to copy to and the number on the line is the field to copy from. Can also be used in conjunction with ADDFIELD.EXE.

Field numbers in the mapping file can be repeated or skipped. Putting the letter N after the field number will mark it as numeric. When using a Quote/Comma delimiter, these numeric fields will not be enclosed in quotes A field number of 0 will print whatever else is on the line to the file. If there isn't anything following the 0, then a blank field will be printed using the specified delimiter. If there is something, then that text will be printed without adding any additional delimiters (you must supply them with the specified text).

The syntax is:

MAPFILE FileName1 FileName2 MapFile [Delimiter=1]

All parameters (except Delimiter=) must be specified. Other parameters listed below may also be used.

FileName2 will be overwritten if it already exists.

Delimiter= supports the following :

1 = Quote/Comma delimited

2 = Tab delimited

3 = Comma delimited (use for Percon 2000)

NoSpace= the program will not put a space after the comma delimiter.

NoZero= Mapfile will throw out any record where the value of the specified field number is 0.

NoBlank= Mapfile will throw out any record where the specified field number is blank.

Example:

MAPFILE EXPORT.TXT PERCON.TXT PERCON.MAP DELIMITER=3 NOZERO=2

Will copy the data from EXPORT.TXT to PERCON.TXT using the field positions specified in PERCON.MAP. It will not copy any record that has 0 in field number 2.

PERCON.MAP might look like this:

---------------------------------
1
2N
0
48
0, "ea"
1
---------------------------------

This would result in Field 1 being copied to Field 1, Field 2 to Field 2 (without quotes around it), Field 3 will be blank, Field 48 to Field 4, Field 5 will be a comma followed by a space followed by the letters ea surrounded by quotes, and another copy of Field 1 to Field 6.

PRINTSAL.EXE/ WPRINTSL.EXE:

Print Sales will print a range of Sales Transactions to the specified printer in the specified form format.

It is designed to be used for printing a batch of sales transactions after they have been entered into the system but not yet printed (e.g. after using RecMerge to import a series of Recurring Invoices or after using IMPTRN to import new Sales Orders from an E-Commerce system).

The series to be printed is defined by the type of transaction (default is SalesInvoice) and the date/time range (default is last Midnight through the current Date/Time). Up to two filters (same selection as the Sales Transactions report) can also be used to further define the batch. The form/printer used is determined by the Print Button #1, or you can enter which print button to use.

The parameters used can be entered as command line switches or in an INI file. (Command line switch will always override any parameters set by the INI file.)

The name of the INIFILE can be set by using the INIFILE= command line switch.

The standard Keystroke command line switches are supported as well as the following special switches:

INIFILE= : Enter the name of the file which holds the parameters to run this program (instead of having to use the command line switches). (INIFILE=DATA\PRINTSAL.INI)

TYPE= : Type of transaction to print (Either Short Name or Abbreviation)

START= : Starting Date (default=Today)

END= : Ending Date (default=Today)

STARTTIME= : Starting Time (default=Last Midnight)

ENDTIME= : Ending Time (default=Right Now)

BUTTON= : Number of Print Button to use (1,2,3,4)

FILTER= : put the filter to be used after this switch. The format is the filter number (position of field on Sales Transactions report) followed by the condition which is enclosed in quotes. For example, FILTER=2">10440 AND <10449", would print those with a Transaction Number between 10440 and 10449. (Up to 2 filters can be entered).

FILTERJOIN= : Specify how to combine the two filters (AND, OR) (e.g. FILTERJOIN=AND if both filters must match).

NOPAUSE= : If NOPAUSE=ON then program will not stop at screen that displays the selected parameters.

CONFIRM= : If CONFIRM=ON then program will display each transaction and allow you to select whether or not to print it.

PROD.EXE:

Run the Auto Produce Function in the Production module.

Supports all the standard Keystroke command line switches.

RECMRG.EXE/ WRECMRG.EXE:

Merges recurring invoice entries from the file KSTRN001.REC into the standard transaction data. It will date and number them as if they were entered manually today. This is mainly used to bring in monthly club membership dues, You can also use it as Recovery Merge by using the /ADD switch to retain transaction numbers and dates. The program only reads from the file KSTRN001.REC. To get data from a different file, you need to copy it to KSTRN001.REC.

Supports most of the standard Keystroke command line switches as well as the follow special switches.

/NOP : No Pause - Eliminates warning prompts.

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

/ADD : Do not update the date or transaction number.

DATE= : Merge Date - put the merge date after this switch. (DATE=05/26/96). Set DATE=0 to keep original date.

TIME= : Merge Time - program will automatically assign a new time value to each transaction (and payment) as they are merged in. The times will start with the specified time and will then increment up approximately 9 seconds for each record. Use TIME=N to start with current time.

MERGE= : Use to merge one Transaction Type into another. The Transaction Type can be specified as either a single letter (where the letter is the one use on the menus in Keystroke to select the transaction type), or as the Short Name or the Abbreviation for desired Transaction Type. For example, to merge in the Recurring Transactions from the file KSTRREC.DAT into invoices any of the following commands can be used: MERGE="REC TO NVC" or "J TO A" or "Recurring Charge TO Sales Invoice".

If the /R - Register switch is used then the transactions will be assigned to the specified register number, otherwise they will keep their original register numbers.

Note: If new date or register numbers are being assigned to the transactions, then audit records will not be merged in. (i.e. if the /ADD switch is not used or the DATE= or /R switches are used, the Audit entries will be skipped).

RPT.EXE:

Runs a Report Cue from the command line. To run a Report Cue from the command prompt use the following syntax.

RPT CUE="Cue Name"

[START={Date}] [END={Date}] [Switches]

The Cue Name must be enclosed in double quotes and entered exactly as it is displayed in the Cues function of the Report Manager.

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

START= : Follow with the starting date for the report. You can also use the special Midnight option (START=M) to start either last night (if  RPT.EXE is run after noon) or the night before (if RPT.EXE is run before noon).

END= : Follow with the ending date for the report. You can also use the special Midnight option (END=M) to end either tonight (if  RPT.EXE is run after noon) or last night (if RPT.EXE is run before noon).

SENDMAIL.EXE:

Send Mail is an executable Keystroke Program which will post a message (with a file attachment) to the Outbox of the specified MAPI server.

This program is designed to be used in e-Commerce applications as well as Multi-Store polling procedures.

The settings are controlled through the file SENDMAIL.INI. The only command line switch supported is INIFILE= to use a different file than SENDMAIL.INI. The following INI file parameters are supported:

UserName= - The name (or profile) of the MAPI Server to use (e.g UserName = Microsoft Outlook)
Password= - If needed for selected UserName
SendTo= - Address to send e-mail to. If it is blank, the program will prompt you for an e-mail address.
Subject= - Text to place on the subject line of the e-mail
NoteText= - Text to place in the body section of the e-mail
Attachment= - Name (including path) of file to attach to e-mail

Below is a practical example of how to setup and configure SENDMAIL.EXE for use with setting up a print button in Keystroke to be able to email out a Sales Transaction. You will need to be licensed for the User Bundle as the utility SENDMAIL.EXE is part of that User Bundle.

You will need to know the following information before being able to setup and configure a print button to email transactions from Keystroke.

1. Your Microsoft Mail Profile name. You can locate this information by going to CONTROL PANEL and then clicking on MAIL and then selecting the SHOW PROFILES button. At the bottom of this next page is a line that says "Always Use This Profile" and the profile name we want to use should be listed right below that (May be different in other operating systems besides Windows XP).

2. You will also need to know your profile password if there is one. In none is supplied then you do not need to know this.

Below are the steps necessary to setup the Email capabilities for sending an Invoice/Order from within Sales Manager.

1. CONFIGURATION MANAGER - HARDWARE - PRINTERS - Press INS to create a new printer. Call the printer SENDMAIL and select the driver as PLAIN and select the port and choose FILE and type a filename such as INVOICE.DOC. You will need to remember this filename and type it in later in these steps.

2. CONFIGURATION MANAGER - HARDWARE - PRINTERS - Press INS to create a new printer. Call the printer EMAIL and select the driver as PLAIN and select the port and choose FILE and type in the filename SENDMAIL.INI. You will need to type in the following into the RUN command line:
SENDMAIL.EXE INIFILE=SENDMAIL.INI

3. CONFIGURATION MANAGER - SETTINGS - FORM MESSAGES - Select the Form Message line #30 and enter in your Microsoft Mail Profile name you noted above.

4. CONFIGURATION MANAGER - SETTINGS - FORM MESSAGES - Select the Form Message line #31 and enter in your Microsoft Mail Profile password if there is one.

CONFIGURATION MANAGER - SETTINGS - FORM MESSAGES - Select the Form Message line #32 and enter in the text that will appear in the body of the email when it is sent.

6. CONFIGURATION MANAGER - SETTINGS - FORM MESSAGES - Select the Form Message line #33 and enter in the filename that you choose in the first step #1 above.

7. CONFIGURATION MANAGER - TABLES - PRINT BUTTONS - SM:SALES - Then select ADD NEW BUTTON and call the new button SEND EMAIL. Select the FORM1 button near the bottom of the screen and select FILE and chose whatever Keystroke form file that you want to email (this will control the format of the attached file that is sent with the email. If you want the emailed file to look the same as your printed invoices choose the same form file). Click the PRINTER button on this same screen and choose the printer named SENDMAIL. Select OK and then click on the FORM2 button at the bottom of the screen. Select FILE and choose the form file SENDMAIL.NVC. Click on the printer button and select the printer named EMAIL. Select OK and then OK again to close out of the print button window. You should now have a new print button on the list that is called SEND EMAIL. Press F10 to save the print buttons windows and you are ready to go into Sales Manager and test the new Send Email button.

The program will pull the email address to send the transaction to from the EMAIL field on the Customer Contact record attached to the transaction. If there is no contact selected or the contact does not have an email address, the program will prompt you to enter in the email address when you select the print button. To test to see if it is working, pull up a Sales Transaction in Sales Manager and go to the completed sale screen and bring up your print buttons. There should now be a new print button on the list called SEND EMAIL. After you select the print button, a message box might come up asking if you would like to allow access to sending an email. You must select YES, then wait 5 seconds and select YES again for the program to send the email (this is a Microsoft Security Warning that cannot be disabled).

SHOWINFO.EXE:

The ShowInfo utility opens the door for many diverse custom enhancements to Keystroke POS. Activated by pressing [Ctrl][F2] from an inventory or other database record, the ShowInfo utility writes the data for the current record to a temporary file (with the .KFO extension, for “Keystroke inFOrmation”). Another program can then read the information about the currently selected record and do something with it such as display an image or supplementary data from another database.

Although the Picture Viewer is built-in to Keystroke POS, this is a perfect example of what can be done with the ShowInfo utility.

PHOTOVIEWER:

An alternate stand-alone Photo Viewer program is included in the User Bundle. Photo Viewer offers added flexibility and can also be used to help manage inventory photo files.

Photo Viewer can be run as a standalone program or with the optional command line switch /u. If the /u command line switch is used the program will monitor for a file that starts with INV*.KFO. The file will be in inifile format with STOCK=##### where #### is the stock number. If the file it present, then the program will delete it and display Product Code, Description, Stock, Class, Base Price, and  QOH. It is used with the [CTRL] [F2] feature.

SUMMARY.EXE:

Runs the Summarize History function by reading the current transaction history for the specified date range and writing the information to a file named 'dpyymmdd.DAT' where 'd' is I for Inventory, C for Customer or V for Vendor; 'p' is D for Daily, W for Weekly or M for Monthly; 'yymmdd' is the starting date for the period.

This information can then be viewed within Keystroke by pressing [Ctrl+F5].

If no period is specified then the program will create every period file for the specified date range. If a week or month ends within the date range then a file for that week/month will be created. If the Period= parameter is used, then only files for that type of period are created. If the Database= parameter is used, then only files for that database type will be created. If no date range is entered then the program will begin with the previous day and go backwards until it reaches a summary file that already exists or back 7 days for daily files, 5 weeks for weekly files and 1 year for monthly files.

Valid switches are:

/D : Directory - put the name of the directory that contains the data files after this switch (/D C:\DATA)

/MoveOld : The program will move all Daily files over 7 days old, all Weekly files over 5 weeks old and all Monthly files over 12 months old to the OLD directory below the current Data directory (C:\KEYSTROK\DATA\OLD\ID000501.DAT). Use the Start= parameter to specify the starting date to count back from. If the Period= parameter is used than only files for that type of period file will be moved. If this switch is used then no files will be created.

Period= : Follow with the period code ((D)aily, (W)eekly, (M)onthly).

Database= : Follow with the database code ((I)nventory, (C)ustomer, (V)endor).

Start= : Starting Date - put the date you want to mark as the start of the summarized period after this switch. (Start=12/30/02 or Start=-2D to start 2 days ago).

End= : Ending Date - put the date you to mark as the end of the summarized period after this switch. End=M will cause the program to end at the closest midnight. (End=12/31/02 or End=-1W to end 1 week ago).

/Pause : The program will pause before creating each file to show what the settings of each parameter is.

If no parameters are entered (or any of the skipped) then following defaults will be used:

DATA Directory = DATA\

Period = Daily, Weekly, and Monthly

Database = Inventory, Customer, Vendor, and Clerk

Start = 0:00am on the last day without a summary file or 7 days back for daily, 5 weeks back for weekly and 1 year back for monthly files.

End = 11:59pm on the previous day

END OF LIST