Online Sales Database Version 3.5j A PCBoard 14.x Door Program (c)Copyright 1989-91 By Thomas S. Thayer 1 Herron Place. Bramalea, Ontario L6S 1P3 All Rights Reserved Available From Streamline Design Company 416-790-1997 or Download From The MIDI Exchange BBS 416-790-2151 The Latest Version of The Sales Door can be file requested from FIDONet 1:259/206 or PODNet 93:9630/6. The Magic word is SALES. FEATURES -------- - 99999 Categories - Unlimited amount of items - Key word searches - Category Searches - Extremly fast indexing and searching routines - Order Placement - Downloading of orders - Credit Card Verifications - Membership Registration and Automatic Upgrade Options - Personalized Key File - Tax, Freight, and weight calculations - PCBTEXT Style Prompts. - Automatic Printing of Order Invoices and Membership Registrations. - Importing of invoices and memberships into conferences - Interfacing with Sparkys and Gerry Freymanns Fax Doors - Many More.......... Table of Contents 1 - Introduction 2 - Requirements 3 - Testing 4 - Setup 4.1 - Main Setup Menu 4.2 - General Setup Features 1 4.3 - General Setup Features 2 4.4 - Create Index Files 4.5 - Define Language File 5 - Database Layout 6 - Membership Registrations Database 7 - TXT2MSG Rules 8 - Interfacing with fax doors 9 - Running On-Line Sales Locally 10 - Invocation Batch File 11 - User Supported Software 12 - Other Information 13 - On-Line Sales Program Registration 14 - Obtaining a Demo Key 1. Introduction The On-Line Sales Door is a product of many hours of work. It has been designed to make the use of PCBoard, and other third party programs, to provide an easy and efficient means of online sales and registrations. Online Sales has been designed to allow users access to a database of items you have for sale on you BBS. This is not a real database but is only a text file that is extracted from a database or spreadsheet. I use a Spread Sheet to enter all my Items and calculate the Prices. It is quite easy to dump the file to text from there. Outlined below are the rules for setting up the text file. I have included a sample of the text file for you to use. You can also set them up in categories, search on keywords, scroll through the whole database, flag items for processing, Place orders online, calculate taxes & freight, specify defaults for everything!!!!! This door can provide you with many other options and is very flexible. The fact that it is flexible brings along a fair number of problems in its self. These docs are an attempt to clear up any problems you may run into. Please keep in mind this is a rough take of the docs. Anyone needing more information can contact our board at (416)790-2151 and enter conference 165. Leave a message there and I will try to assist you as best as I can. 2. Requirements The following list of items are required for complete operation of this program: - PCBoard or a conversion program for BBS control file. - IBM PC or Compatible - A Modem (Optional, can be run locally) - ANSI - TXT2MSG (Optional, only needed if you are importing or faxing invoices) - DSZ.COM (Optional, only needed to allow downloading of invoices) 3. Testing This program has been run and successfully tested on the following machines and modems. Any other additions to the list will be appreciated. - IBM 80286 - 12 compatible - IBM 80386 - 33 compatible - NEC V40 - Compaq 80386 - 25 - USR HST9600 - ATI2400ETC 4. Setup Setup of the Sales door should be performed completely through the setup program provided. There are 4 other programs that come with the setup program. The following is a list of programs needed to run the complete setup functions: - SETUP.EXE This is the main shell. Run this. - OPTION1.EXE This is the General setup options page 1. - OPTION2.EXE This is the General setup options page 2. - CONVDB.EXE This is the index creation program - SALESTXT.EXE This is your SALESTXT modification program. This program will allow you create language specific prompts for the sales door. 4.1 Main Setup Menu Below is a print of the menu you will be presented with: °°°°°°°°°°°°° The On-Lines Sales Database Setup Program Ver 1.4 °°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°ÚÄ[]ÄÄÄÄÄÄÄÄMain MenuÄÄÄÄÄÄÄÄÄÄÄÄ¿°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°³ ³°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°³ 1 General Setup Features 1 ³°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°³ 2 General Setup Features 2 ³°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°³ Create Index Files ³°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°³ Define Language File ³°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°ÃÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ´°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°³ Quit ³°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° StartUp Definitions Page 1 The main menu will allow you to access the different portions of the setup program. You can use 3 different methods of selecting your menu option. You can 1) use your cursor keys and move the red bar over top of the selection you want then hit enter, 2) press the first, or Highlighted, letter corresponding to the selection desired, or 3) use your mouse to click upon the selection you require. The key will abort any of the following screens and return you to the main menu. 4.2 General Setup Features 1 Upon Selecting option 1 from the main menu you will be presented with the following screen: °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°ÚÄ[þ]ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄG:\SALES\*.cfgÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ[]Ä¿°°°°°°°°° °°°°°°°°°³ NODE.CFG SALES.CFG °°°°°°°°° °°°°°°°°°³ QRT.CFG °°°°°°°°° °°°°°°°°°³ PCQ.CFG °°°°°°°°°° °°°°°°°°°³ MINES.CFG °°°°°°°°°° °°°°°°°°°³ TALES.CFG °°°°°°°°°° °°°°°°°°°³ ODOOR.CFG °°°°°°°°°° °°°°°°°°°³ TEST.CFG °°°°°°°°°° °°°°°°°°°³ KEYDOOR.CFG °°°°°°°°°° °°°°°°°°°³ SALESKEY.CFG °°°°°°°°°° °°°°°°°°°³ TSALES.CFG °°°°°°°°°° °°°°°°°°°³ TESTSEC.CFG °°°°°°°°°° °°°°°°°°°³ SSALES.CFG °°°°°°°°°° °°°°°°°°°³ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ°°°°°°°°°° °°°°°°°°°³ NODE.CFG 12 Feb 08,1990 11:45p A °°°°°°°°° °°°°°°°°°À°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°Ù°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°Press [S] or Right Mouse Button for Sort Options°°°°°°°°°°°°°°°°° This screen will allow you to select and maintain as many configurations as you wish. To select the configuration you need simply place the highlight bar on top of the configuration you require and hit enter. If you have a mouse activated, you can also place the mouse on top of the selection desired and click to select the configuration. Some people will have many different sales doors and will have a number of configuration files. To simplify this matter we have added a sorting function for the setup. This functon can be activated by clicking the right mouse button or pressing the letter 'S'. Upon activating this function you will be presented with the following screen: °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°ÚÄ[þ]ÄDirectory Sort OptionsÄÄÄÄÄ¿°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°³ ³°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°³ Sort on: ³°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°ÚÄ[þ]ÄÄÄÄÄÄÄÄÄij (ù) Natural DOS ³ÄÄÄÄÄÄÄÄ[]Ä¿°°°°°°°°° °°°°°°°°°³ NODE.CFG ³ ( ) Name ³ °°°°°°°°° °°°°°°°°°³ QRT.CFG ³ ( ) Ext OK Ü ³ °°°°°°°°° °°°°°°°°°³ PCQ.CFG ³ ( ) Size ßßßßßßßß ³ °°°°°°°°°° °°°°°°°°°³ MINES.CFG ³ ( ) Time ³ °°°°°°°°°° °°°°°°°°°³ TALES.CFG ³ Cancel Ü ³ °°°°°°°°°° °°°°°°°°°³ ODOOR.CFG ³ Sort Order: ßßßßßßßß ³ °°°°°°°°°° °°°°°°°°°³ TEST.CFG ³ (ù) Ascending ³ °°°°°°°°°° °°°°°°°°°³ KEYDOOR.CFG ³ ( ) Descending ³ °°°°°°°°°° °°°°°°°°°³ SALESKEY.CFG³ ³ °°°°°°°°°° °°°°°°°°°³ TSALES.CFG ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ °°°°°°°°°° °°°°°°°°°³ TESTSEC.CFG °°°°°°°°°° °°°°°°°°°³ SSALES.CFG °°°°°°°°°° °°°°°°°°°³ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ°°°°°°°°°° °°°°°°°°°³ NODE.CFG 12 Feb 08,1990 11:45p A °°°°°°°°° °°°°°°°°°À°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°Ù°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°Press [S] or Right Mouse Button for Sort Options°°°°°°°°°°°°°°°°° To select the sorting options with a mouse click on the option desired then click 'OK'. To select the sorting options with the keyboard, use your cursor keys and your Tab key to move around until you are highlighting the option needed and then press the space bar. You will see the little dot appear on the option and disappear from the previous option. Once you have the correct options use your Tab key to highlight 'OK' and press enter. Once you have selected the configuration you require you will be presented with the following screen: ÚÄÄÄÄÄÄÄÄÄÄÄÄÄ The On-Lines Sales Database Setup Program Ver 1.4 ÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ³ ³ ³ Company Name: Streamline Productions IIúúúúúúúúúúúúúúú ³ ³Opening Bulletin: SALES.BLTúúú DataBase: SALES.BBBúúú ³ ³ Order Intro: SALES.SDCúúú Invocation Batch: SALESúúú ³ ³Orders Directory: G:\SALESúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúú ³ ³ ³ ³ Freight: Y Amount Extra 1lb Memberships: Y ³ ³ Company 1: UPS GROUNDú 2.10úúúúúú 1úúúúúúúúú Listing: MEMB.TXTúúúú ³ ³ Company 2: UPS Redúúúú 0úúúúúúúúú 0úúúúúúúúú ³ ³ Company 3: UPS Blueúúú 0úúúúúúúúú 0úúúúúúúúú Invoices/Membership: N ³ ³ Company 4: Fed Express 0úúúúúúúúú 0úúúúúúúúú ³ ³ ³ ³ Default Tax: 15.00 % CAN/USA Prompts: USA ³ ³ Config Name: SALESúúú PCB Batch Name: BOARD.BATúúú ³ ³PCBoard Path: G:\SALESúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúú ³ ³ Door Path: G:\SALESúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúúú ³ ³ Com Port: 0 Zmodem: Y MobyTurbo: Y Ymodem: Y Ymodem-G: Y ³ ³ Ymodem-1k: Y Xmodem: Y Xmodem/CRC: Y Xmodem-1k: Y ³ ³ Qmodem-G: Y ³ ³ ³ ³ Credit Cards?: Y VISA: Y Mastercard: Y AMEX: Y ³ ³Enter The Name of Your Company or BBS. ³ ³To change fields press:   Ctrl Ctrl Enter, or TAB. Esc/F10 to Save. ³ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ To move around the screen use you up and down arrows or Tab keys. The left and right arrows will allow you to move within each field. The end key will move you to the end of the field and the home key will move you to the beginning of the field. The F10 key will save your configuration and the will abort it. PgUp and PgDn do nothing. Company Name - The entry you place here will appear on several screen in the Sales Door and will also appear on the invoice. Opening Bulletin - This is the name of the ANSI file you wish to display above the main menu selections of the Sales Door. Database - This is the name of your main database of items. Please refer to the section 5 of the documentation for the proper layout of this file. Order Intro - This is the name of the screen you wish to display before entering the order placement module of the Sales Door. Invocation Batch - This is the name of the file you will call from PCBoard to run the sales door. Upon saving the configuration the setup program will generate this file for you. Orders Directory - This is the path to the directory you wish to save your orders in. The system will write all orders inside this directory. The orders are generated in sequential order with a numbering scheme as follows: ORD1.INV ... ORD99999.INV FREIGHT ============================================================================ Freight - This field will accept a 'Y' or 'N'. Placing a 'Y' will enable the frieght calculation of the Sales Door. Company x - This is the name of the freight company that will appear in the Sales door. Amount x - This is the initial/onetime freight charge for the item. Extra 1lb x - This is the cost per extra pound for shipping The freight charge is calculated as follows: Freight Charge = (Amount x) + ((Weight) * (Extra 1lb x)) Weight is specified in the Database. Please refer to section 5 for the layout of the database. ============================================================================ Memberships - This field will accept a 'Y' or 'N'. If a 'Y' is entered it will enable the membership module of the Sales door. Please refer to section 6 for specs on membership. Listing - This is the name of the memberships text file. Please refer to section 6 for the layout of this file. Invoice/Memberships - This field will accept a 'Y' or 'N'. Entering a 'Y' will instruct the Sales door to print all invoices and memberships. It uses the printer port specified in your PCBoard setup. Default Tax - This is the tax you wish to default to in the Sales door. This will appear when a user places an order. If the user specifies 'Y' when asked if the order is taxable this value will appear in the tax field. The user can overwrite this value if needed. The reason for this format is to make the door portable throughout the world. CAN/USA Prompts - No longer applicable. Please ignore. Config Name - This is the name of the configuration you are building or modifying. This also allows you to create new configurations. If you specify a different name in this field, the program will leave the old config untouched and simply save all the options in the new configuration. PCBoard Path - This is the path to the node you are running this door and configuration on. Door Path - This is the path to the directory that your sales door lives in. Comm Port - This is the communications port that the modem running the Sales door with this configuration is using. This is essential to the correct operation of DSZ for downloading invoices. Zmodem: - These fields will accept a 'Y' or 'N'. Specifying a 'Y' MobyTurbo: will enable these protocols for downloading invoices. Ymodem: Ymodem-G: Ymodem-1k: Xmodem: Xmodem/CRC: Xmodem-1k: Qmodem-G: Credit Cards? - This field will accept a 'Y' or 'N'. Entering a 'Y' will enable the credit card verification portion of the Sales door. VISA: - These fields will accept a 'Y' or 'N'. Entering a 'Y' Mastercard: will enable the verification ability for that credit card AMEX: in the Sales Door. 4.3 General Setup Features 2 Upon Selecting option 1 from the main menu you will be presented with the following screen: °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°ÚÄ[þ]ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄG:\SALES\*.cfgÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ[]Ä¿°°°°°°°°° °°°°°°°°°³ NODE.CFG SALES.CFG °°°°°°°°° °°°°°°°°°³ QRT.CFG °°°°°°°°° °°°°°°°°°³ PCQ.CFG °°°°°°°°°° °°°°°°°°°³ MINES.CFG °°°°°°°°°° °°°°°°°°°³ TALES.CFG °°°°°°°°°° °°°°°°°°°³ ODOOR.CFG °°°°°°°°°° °°°°°°°°°³ TEST.CFG °°°°°°°°°° °°°°°°°°°³ KEYDOOR.CFG °°°°°°°°°° °°°°°°°°°³ SALESKEY.CFG °°°°°°°°°° °°°°°°°°°³ TSALES.CFG °°°°°°°°°° °°°°°°°°°³ TESTSEC.CFG °°°°°°°°°° °°°°°°°°°³ SSALES.CFG °°°°°°°°°° °°°°°°°°°³ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ°°°°°°°°°° °°°°°°°°°³ NODE.CFG 12 Feb 08,1990 11:45p A °°°°°°°°° °°°°°°°°°À°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°Ù°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°Press [S] or Right Mouse Button for Sort Options°°°°°°°°°°°°°°°°° This screen will allow you to select and maintain as many configurations as you wish. To select the configuration you need simply place the highlight bar on top of the configuration you require and hit enter. If you have a mouse activated, you can also place the mouse on top of the selection desired and click to select the configuration. Some people will have many different sales doors and will have a number of configuration files. To simplify this matter we have added a sorting function for the setup. This functon can be activated by clicking the right mouse button or pressing the letter 'S'. Upon activating this function you will be presented with the following screen: °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°ÚÄ[þ]ÄDirectory Sort OptionsÄÄÄÄÄ¿°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°³ ³°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°³ Sort on: ³°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°ÚÄ[þ]ÄÄÄÄÄÄÄÄÄij (ù) Natural DOS ³ÄÄÄÄÄÄÄÄ[]Ä¿°°°°°°°°° °°°°°°°°°³ NODE.CFG ³ ( ) Name ³ °°°°°°°°° °°°°°°°°°³ QRT.CFG ³ ( ) Ext OK Ü ³ °°°°°°°°° °°°°°°°°°³ PCQ.CFG ³ ( ) Size ßßßßßßßß ³ °°°°°°°°°° °°°°°°°°°³ MINES.CFG ³ ( ) Time ³ °°°°°°°°°° °°°°°°°°°³ TALES.CFG ³ Cancel Ü ³ °°°°°°°°°° °°°°°°°°°³ ODOOR.CFG ³ Sort Order: ßßßßßßßß ³ °°°°°°°°°° °°°°°°°°°³ TEST.CFG ³ (ù) Ascending ³ °°°°°°°°°° °°°°°°°°°³ KEYDOOR.CFG ³ ( ) Descending ³ °°°°°°°°°° °°°°°°°°°³ SALESKEY.CFG³ ³ °°°°°°°°°° °°°°°°°°°³ TSALES.CFG ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ °°°°°°°°°° °°°°°°°°°³ TESTSEC.CFG °°°°°°°°°° °°°°°°°°°³ SSALES.CFG °°°°°°°°°° °°°°°°°°°³ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ°°°°°°°°°° °°°°°°°°°³ NODE.CFG 12 Feb 08,1990 11:45p A °°°°°°°°° °°°°°°°°°À°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°Ù°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°Press [S] or Right Mouse Button for Sort Options°°°°°°°°°°°°°°°°° To select the sorting options with a mouse click on the option desired then click 'OK'. To select the sorting options with the keyboard, use your cursor keys and your Tab key to move around until you are highlighting the option needed and then press the space bar. You will see the little dot appear on the option and disappear from the previous option. Once you have the correct options use your Tab key to highlight 'OK' and press enter. Once you have selected the configuration you require you will be presented with the following screen: ÚÄÄÄÄÄÄÄÄÄÄÄÄÄ The On-Lines Sales Database Setup Program Ver 1.4 ÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ³ ³ ³ Import Memberships/Orders: Y ³ ³ Message Subject: 790-1997úúúúúúúúúúúúúúúúú ³ ³ Receiver: SYSOPúúúúúúúúúúúúúúúúúúúú ³ ³ Conference #: 165úúú ³ ³ Taxation: Y ³ ³ Sparkys Fax Door: Y ³ ³ Gerrys Fax Door: N ³ ³ Phone Number: 790-1997úúúúúúúúúúúúúúúúú ³ ³ ³ ³ ³ ³ ³ ³ ³ ³ ³ ³ ³ ³ ³ ³ ³ ³ ³ ³ ³ ³ ³ ³ ³ ³Do You Wish To Import Memberships & Registrations to a conference? ³ ³To change fields press:   Ctrl Ctrl Enter, or TAB. Esc/F10 to Save. ³ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ To move around the screen use you up and down arrows or Tab keys. The left and right arrows will allow you to move within each field. The end key will move you to the end of the field and the home key will move you to the beginning of the field. The F10 key will save your configuration and the will abort it. PgUp and PgDn do nothing. Import Memberships/Orders - This field will accept a 'Y' or 'N'. Entering a 'Y' will enable the TXT2MSG module of the Sales Door. Message Subject - This is the subject to appear in the message in PCBoard when you import the invoice or Membership. Receiver - This is the name of the person the message should be addressed to. Conference # - This is the number of the PCBoard conference you wish to import the message into. Taxation - This field will accept a 'Y' or 'N'. Entering a 'Y' will enable the taxation module and calculation of taxes. Entering a 'N' will suppress all functions pertaining to taxes. Sparkys Fax Door - This field will accept a 'Y' or 'N'. Entering a a 'Y' will tell the Sales door that you wish to use Mark Herrings Fax door. This will make the Sales door automatically default the subject to 'FAX GATEWAY' and the first line will be 'TO: + phone number'. Gerrys Fax Door - This field will accept a 'Y' or 'N'. Entering a a 'Y' will tell the Sales door that you wish to use Gerry Freymanns Fax door. This will make the Sales door automatically default the subject to 'FAX'. Phone Number - This is the phone number that you want placed on the first line of the message. It should be the number you wish to fax the invoices to. 4.4 Create Index Files Once you have created your database, as specified in section 5 of these docs, you have to run this function. When you have selected this option you will be presented with the following screen: °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°ÚÄ[þ]ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄG:\SALES\*.cfgÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ[]Ä¿°°°°°°°°° °°°°°°°°°³ NODE.CFG SALES.CFG °°°°°°°°° °°°°°°°°°³ QRT.CFG °°°°°°°°° °°°°°°°°°³ PCQ.CFG °°°°°°°°°° °°°°°°°°°³ MINES.CFG °°°°°°°°°° °°°°°°°°°³ TALES.CFG °°°°°°°°°° °°°°°°°°°³ ODOOR.CFG °°°°°°°°°° °°°°°°°°°³ TEST.CFG °°°°°°°°°° °°°°°°°°°³ KEYDOOR.CFG °°°°°°°°°° °°°°°°°°°³ SALESKEY.CFG °°°°°°°°°° °°°°°°°°°³ TSALES.CFG °°°°°°°°°° °°°°°°°°°³ TESTSEC.CFG °°°°°°°°°° °°°°°°°°°³ SSALES.CFG °°°°°°°°°° °°°°°°°°°³ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ°°°°°°°°°° °°°°°°°°°³ NODE.CFG 12 Feb 08,1990 11:45p A °°°°°°°°° °°°°°°°°°À°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°Ù°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°Press [S] or Right Mouse Button for Sort Options°°°°°°°°°°°°°°°°° This screen will allow you to select and maintain as many configurations as you wish. To select the configuration you need simply place the highlight bar on top of the configuration you require and hit enter. If you have a mouse activated, you can also place the mouse on top of the selection desired and click to select the configuration. Some people will have many different sales doors and will have a number of configuration files. To simplify this matter we have added a sorting function for the setup. This functon can be activated by clicking the right mouse button or pressing the letter 'S'. Upon activating this function you will be presented with the following screen: °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°ÚÄ[þ]ÄDirectory Sort OptionsÄÄÄÄÄ¿°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°³ ³°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°³ Sort on: ³°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°ÚÄ[þ]ÄÄÄÄÄÄÄÄÄij (ù) Natural DOS ³ÄÄÄÄÄÄÄÄ[]Ä¿°°°°°°°°° °°°°°°°°°³ NODE.CFG ³ ( ) Name ³ °°°°°°°°° °°°°°°°°°³ QRT.CFG ³ ( ) Ext OK Ü ³ °°°°°°°°° °°°°°°°°°³ PCQ.CFG ³ ( ) Size ßßßßßßßß ³ °°°°°°°°°° °°°°°°°°°³ MINES.CFG ³ ( ) Time ³ °°°°°°°°°° °°°°°°°°°³ TALES.CFG ³ Cancel Ü ³ °°°°°°°°°° °°°°°°°°°³ ODOOR.CFG ³ Sort Order: ßßßßßßßß ³ °°°°°°°°°° °°°°°°°°°³ TEST.CFG ³ (ù) Ascending ³ °°°°°°°°°° °°°°°°°°°³ KEYDOOR.CFG ³ ( ) Descending ³ °°°°°°°°°° °°°°°°°°°³ SALESKEY.CFG³ ³ °°°°°°°°°° °°°°°°°°°³ TSALES.CFG ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ °°°°°°°°°° °°°°°°°°°³ TESTSEC.CFG °°°°°°°°°° °°°°°°°°°³ SSALES.CFG °°°°°°°°°° °°°°°°°°°³ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ°°°°°°°°°° °°°°°°°°°³ NODE.CFG 12 Feb 08,1990 11:45p A °°°°°°°°° °°°°°°°°°À°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°Ù°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° °°°°°°°°°°°°°°°Press [S] or Right Mouse Button for Sort Options°°°°°°°°°°°°°°°°° To select the sorting options with a mouse click on the option desired then click 'OK'. To select the sorting options with the keyboard, use your cursor keys and your Tab key to move around until you are highlighting the option needed and then press the space bar. You will see the little dot appear on the option and disappear from the previous option. Once you have the correct options use your Tab key to highlight 'OK' and press enter. Once you have selected the configuration you require you will see the following messages appear on the screen: Creating Index A . . . Creating Index Z Creating Categories Please wait............ Created Category . . . Created Category Creating Item Number Indexes............ ******** NOTE ************* This function is absolutely essential to the proper opration of the Sales Door. 4.5 Define Language File This section will allow you to create language specific prompts for the Sales door. The Sales Door will read the language selected in PCBoard and use that default. For example: If Joe Blow selected French in PCBoard, PCBoard would use PCBTEXT.FRE. The Sales Door will detect this and will look for a file named SALESTXT.FRE in the directory it lives in. If it does not exist it will default to SALESTXT. Upon Selecting option 4 from the main menu you will be presented with the following screen: ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º SALESTXT File Generator/Editor º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» ºEnter filename to edit/convert: º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º (C) Copyright Streamline Design Company. - 1989/91 º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ 3 (Local) - Salestxt 1.0 18:32 18:32 (08-08-91) #On=702 Sec0=231 Up=0/0k Dn=0/0k (A) 0 (Home)=Help To Edit/Create/Convert a SALESTXT file simply type in the name and hit enter. If the file does not exist the system will ask you if you wish to create it, if it does exist it will pull up the contents of that file. If the file you typed in exists and is an older version it will convert it to the proper version. You will then see the following screen: ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º SALESTXT File Generator/Editor º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» ºEnter filename to edit/convert: salestxt º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º Record No.: 1 º ÇÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄĶ º Online Sales Main Menu º º Online Sales Main Menu º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º = Ahead 1 Record. = Back 1 Record. º º = Ahead 10 Records = Back 10 Records. º º = Top of File. = End of File. º º = Save & Quit. = Locate a Record. º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º (C) Copyright Streamline Design Company. - 1989/91 º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ 3 (Local) - Salestxt 1.0 18:32 18:32 (08-08-91) #On=702 Sec0=231 Up=0/0k Dn=0/0k (A) 0 (Home)=Help You will see 2 lines like those above. The top line is the original prompt and the second line can be edited to reflect the change you wish to implement. When you have modified the prompts to your satisfaction hit and the file will be saved with the new prompts. 5. Database Layout THE DATABASE FILE (SALES.BBS) ------------------ This file Must be setup in a specific order. I have included a sample SALES.BBS file for you to look at. The following are the rules. 1) The very first line of the SALES.BBS file must be blank. 2) They very last line of the SALES.BBS file must be ~~~, this signifies the end of the file to the program. 3) There must be a blank line between categories followed by a heading line. The heading line must be followed by an underline. 4) The Category Title can be no longer than 35 Characters. 5) The Item Name must be no more than 25 characters long. You can use blanks to fill in the rest of the line. 6) The price must be no more than 12 characters long. 7) Weight is up to 4 characters (I think?). Test it and let me know. Below is an example. When you run option 3 from the main setup menu against this file it will create 7 category, 26 SALESNDX.? indexes, and 11 ITEMNO?.NDX files. The category files will be named CAT1.BBS .... CATn.BBS according to the way they appear in the database. The SALESNDX.? files will be named SALESNDX.A ... SALESNDX.Z. These files are for faster keyword searches. The ITEMNO?.NDX files will be named ITEMNO.NDX and ITEMNO0.NDX ... ITEMNO9.NDX. These file are faster checking of item numbers for the order placement and flagging options. The WGT entry is the weight for the freight calculation. This is the amount of extra poundage to apply against the order when calculating the freight charges for the order. Please make sure you create the database exactly as below and in the example. ------------------------------------------- Top of File ------------------ Online Programs Item # Item Sale Pr. WGT ------------------------------------------ --------------- 7 The Online Sales Door 3.4 40.00 0 Crescent Software Item # Item Sale Pr. WGT ------------------------------------------ --------------- 8 QuickPak Professional 6.0 229.00 0 9 QuickPak Professional 7.0 249.00 0 10 QBase 199.00 0 11 QuickScreen 129.00 0 12 QBase Report 109.00 0 13 GraphPak Professional 199.00 0 14 Quickmenu 69.00 0 15 LaserPak 109.00 0 16 QPak Scientific 109.00 0 17 QuickHelp 69.00 0 18 P.D.Q. 179.00 0 19 P.D.Q. Comm 65.00 0 20 XREF 69.00 0 Kedwell Software Item # Item Sale Pr. WGT ------------------------------------------ --------------- 21 DataBoss 3.0 For C 599.00 0 22 DataBoss 3.0 For Pascal 599.00 0 ADC Software Item # Item Sale Pr. WGT ------------------------------------------ --------------- 23 SNAP PC Manager 89.00 0 Micro Mentor Inc. Item # Item Sale Pr. WGT ------------------------------------------ --------------- 24 Mentor Accountant 229.95 0 Magee Enterprises Item # Item Sale Pr. WGT ------------------------------------------ --------------- 25 Automenu - English 79.00 0 26 Automenu - French 79.00 0 27 Treeview 29.00 0 28 Screen Manager Professional 359.00 0 AK Microsystems Item # Item Sale Pr. WGT ------------------------------------------ --------------- 29 Paymate 269.00 0 30 Paymate Plus 449.00 0 ~~~ ------------------------------------------- End of File ------------------ 6. Membership Registrations Database. The membership registration portion of this program will allow users to be automatically upgraded when applying for a membership. The system will present the user with a listing of memberships and allow the user to choose the membership they wish. Upon selecting the membership, the system will check the upgrade security against the users current security. If the system finds the current security is higher or equal to the memberships security selected, it will issue an error message to the user. If the users security is lower than the membership selected the system will ask the user if they wishe to apply using a credit card. The credit cards available on your system will be listed. If the answers is 'N' the user will be returned to the main menu. If 'Y' they will be prompted for a credit card number. If a valid credit card number and expiration is entered then the system will log the registration to the logfile specified in the configuration file and automatically upgrade the users access. This way the user will have a new access level when he leaves the door. The following is the file layout for the memberships registration file: Legend Characters Description A 1 - 10 Item Number B 11 - 43 Item Description C 44 - 54 Membership price D 55 Space E 56 - 58 Security Level to upgrade user to upon Credit Card registration. F 59 Space G 60 - 63 Length of registration in days. (ie: 365 = 1 year) File Layout Memberships Item # Item Sale Pr. -------------------------------------------------------------- 1 60 Mins a Day 4 Months 1000K 20.00 15 120 2 60 Mins a Day 1 Year 1000K 45.00 16 365 3 90 Mins a Day 1 Year 1500K 60.00 20 365 4 120 Mins a Day 1 Year 2000K 90.00 25 365 5 150 Mins a Day 1 Year 3000K 120.00 35 365 6 180 Mins a Day 1 Year 4000K 150.00 45 365 ~~~ A B C DE F G NOTE!!!!!!! The first line must be blank. The second line must be a descriptor for the file. The 3rd & 4th lines must remain as above. The last line must only contain ~~~. 7. TXT2MSG Rules The only rule for the use of TXT2MSG to import invoices and memberships is that the file TXT2MSG.EXE must be in the current directory or on the path. Unzip the TXT2MSG.ZIP file. 8. Interfacing with Fax doors Sparkys Fax Door To use Sparkys Fax Door simply run General Setup Features 2, enter a 'Y' and fill in the phone number below. Specify the conference you are using as the FAX Gateway above and save the setup. The Sales Door will now place all invoices in that conference with addressed to FAX GATEWAY and 'TO: XXX-XXXX' on the first line. When your event runs the invoices will be faxed. Gerrys Fax Door To use Gerrys Fax Door simply run General Setup Features 2, enter a 'Y' and fill in the phone number below. Specify the conference you are using as the FAX conference above and save the setup. The Sales Door will now place all invoices in that conference with addressed to FAX and 'XXX-XXXX' on the first line. When your event runs the invoices will be faxed. 9. RUNNING ONLINE SALES LOCALLY If the door is run from within a BBS you will not need any extra commands in your batch file. If it is run from the command line or outside of a BBS you will have to add the command LOCAL. You should also work best if you enter PCBoard and shell to DOS. Then copy your PCBoard.sys & PCBoard.dat to a destination of your choice. After doing so replace 'C:\PCB' below with the path to the copies of PCBoard.sys and PCBoard.dat. ie: SALES SALES.CFG C:\PCB LOCAL 10. INVOCATION BATCH FILE Each door program which runs under PCBoard must have a batch file associated with it which carries out the necessary housekeeping tasks for PCBoard. This file changes directory areas if necessary, invokes the program and passes necessary parameters, and returns the user to PCBoard when the door function is completed. An example invocation batch file is included. SALES ----> Sample Door Batch File ECHO OFF CD C:\PCB\DOORS SALES SALES.cfg C:\PCB CD C:\PCB BOARD 11. USER SUPPORTED SOFTWARE ----------------------- This program is NOT public domain and is (c)Copyrighted 1989-91 by Tom S. Thayer with all rights reserved. It may not be distributed for personal gain under any circumstances. The SALESxxx.ZIP file in its original form may be copied or distributed thru Bulletin Board systems provided no fee is charged for its distribution and no modifications are made to the program files contained therein. User Supported Software is a way for you to review a program on a trial basis and test its operation on your system prior to purchasing it. Under this type of distribution system, you are insured that the program meets your needs and requirements. This software is provided on an "As Is" basis without warranty either implied or expressed of any kind. Tom S. Thayer, the author and sole owner of this software, takes no responsibility for loss of data or damage to equipment thru the use of this software. Should the software prove defective the entire burden of any and all repairs and replacements and/or data restoration rests with the user. In no event will the author be liable for any costs and/or losses either tangible or intangible arising from the use of this software. 12. OTHER INFORMATION If you have any problems or questions concerning the use of this program you may contact me at Streamline Design Company 416-790-1997 (10:00am to 6:00pm). I would greatly appreciate hearing from you with suggestions for improvements or other comments. The latest version of this software can always be obtained from within the The MIDI Exchange (416)790-2151 or file requested on FIDONet node 1:259/206, PODNet node 93:9630/6, or Crystal 84:5004/78. The Magic Name is SALES. 13. ONLINE SALES PROGRAM REGISTRATION Send To: Streamline Design 1 Herron Place. Bramalea, Ontario L6S 1P3 Name:_____________________________________________________ Address:_____________________________________________________ City:__________________________ St/Prov:______ Zip/Post:_________ Phone:_________________ Date:____________________ BBS Name:_______________________________________ Sysop's Name:_______________________________________ BBS Phone:___________________ Copies:_____ Key Type: 1 Year ($40.00) ___ Unlimited ($120.00) ___ Please add me to the list of Registered users/owners of Online Sales For PCBoard. Please find payment enclosed for each copy of Online Sales to cover the cost of registration. Registration provides the means to notify users of future software releases and/or enhancements and to provide software support. Registered owners will be authorized on-line access to the MIDI Exchange BBS. 14. Obtaining a Demo Key A one month DEMO Key is available by calling The MIDI Exchange and downloading the key. Just enter the Sales Door from the doors menu and use option C. The type of key you are eligible for will be determined when you enter the door. If you are a registered user of The On-Line Sales Door a registered key will be generated. If you are here to receive a Demo Key the system will automatically generate that key for you. If you are here for a Demo Key a 1 month key will be generated. You can enter the door as many times as want within the next month to regenerate the key. However, you can only do that during that 1 month period. The system will not allow you to receive another key after the 1 month period has expired. Example: Joe Blow enters the door on 03-11-74. He receives his key. He returns on 24-11-74 and receives an the same key. Joe then returns on 04-12-74 and enters the door. The system then advises Joe that his 1 month Demo is complete.