HomeWare 14

home *** CD-ROM | disk | FTP | other *** search

/ HomeWare 14 / HOMEWARE14.bin / database / day53.arj / DAY.DOC next >

Wrap

Text File | 1993-07-15 | 107KB | 2,328 lines

DAILY CALENDAR VERSION 5.3 July, 1993 Elizabeth B. Copper 227 F Avenue Coronado, CA 92118 Bulletin Board (619)-435-0036 Voice Message (619)-435-2687 ============================================================ Table Of Contents ------------------------------------------------------------ INTRODUCTION TO DAILY CALENDAR.............................2 REGISTRATION.............................................2 WARRANTY.................................................2 SUPPORT..................................................2 FROM THE AUTHOR..........................................3 FEATURES.................................................3 GETTING STARTED............................................4 Hardware requirements....................................4 Autoexec.bat and config.sys requirements.................4 Path and append..........................................4 The escape key...........................................4 The F1 key...............................................4 Installation.............................................5 CONFIGURATION..............................................5 Printer, video and backup configuration..................5 Calendar configuration...................................7 Modem configuration......................................7 Name and address configuration...........................8 DAILY CALENDAR OPERATION...................................8 CALENDAR CHOICE..........................................8 APPOINTMENTS...........................................9 PRINT.................................................11 SEARCH................................................11 READ FILE.............................................12 TO DO LIST............................................13 NAMES AND ADDRESSES...................................13 MULTIPLE APPOINTMENTS.................................13 OTHER OPTIONS FROM MAIN MENU..............................15 NAME..................................................15 SET COLORS............................................15 JUMP TO DOS...........................................15 DATABASE UTILITIES....................................15 FILE FUNCTIONS........................................15 TEST PORT.............................................16 PRINTER MODE DEFAULT..................................17 QUIT..................................................17 NAMES AND ADDRESSES OPERATION...........................17 EDIT AND APPEND.......................................18 MAILING LABELS........................................19 LISTS.................................................20 FORM LETTERS..........................................20 BROWSE................................................20 SEARCH................................................20 CHANGE INDEX..........................................21 NAME AND ADDRESS UTILITIES..............................21 PACK..................................................21 ZAP...................................................21 REINDEX...............................................21 ------------------------------------------------------------ ------------------------------------------------------------ SELECT ADDRESS DATABASE...............................22 COPY RECORDS TO A NEW DATABASE........................22 APPEND RECORDS FROM ANOTHER DATABASE..................22 FIELD REPLACEMENT.....................................23 NAME AND ADDRESS OTHER OPTIONS..........................24 JUMP TO DOS...........................................24 FILL LAST NAME FIELD WITH COMPANY.....................24 REVERSE LAST NAME FILL................................24 THE QUERY FUNCTION........................................25 How to build a query....................................26 Expression builder......................................26 HP LASERJET FUNCTIONS.....................................32 HISTORY...................................................33 ERRORS....................................................34 COMMON QUESTIONS..........................................34 KEY COMMANDS..............................................37 DATABASE BACKUP STRATEGY..................................38 TRADEMARK ACKNOWLEDGMENTS.................................39 ADDENDUM - NEW FEATURES WITH VERSION 5.3..................40 REGISTRATION FORM.........................................41 ============================================================ DAILY CALENDAR VERSION 5.3 Copyright 1993 Elizabeth Copper July, 1993 INTRODUCTION TO DAILY CALENDAR REGISTRATION: If you obtained this software from a shareware distribution service, you have paid only for the cost of distribution. You have not registered it. Basic, individual registration is $40, with discounts as explained in REGISTER.DOC Daily Calendar is shareware, it is not free or public domain. If you use it for more than thirty days, you are expected to register it. Use beyond this period without registration violates a variety of laws, but more importantly denies the author minimal, just compensation for the software. Complete registration information is found in the file REGISTER.DOC and at the end of this documentation. This program and associated documentation are the property of the author and may not be sold without permission. The program may be freely distributed, unaltered and as a unit, via electronic bulletin board systems. Permission to distribute on diskette or in any other manner must be obtained in writing. WARRANTY: The author does not guarantee this program to be free from defects and may not be held responsible for loss caused by it. Your use of this program constitutes your acceptance of these terms. Users of Daily Calendar must accept this disclaimer of warranty: Daily Calendar is supplied as is. The author disclaims all warranties, expressed or implied, including, without limitation, the warranties of merchantability and of fitness for any purpose. The author assumes no liability for damages, direct or consequential, which may result from the use of Daily Calendar. This program is written and compiled with Clipper 5.2b from Computer Associates, with third-party library support from the Professional SuperFunctions Library by Gary Prefontaine, Clipport by David Hepler and The NanForum 2.1 library by many authors. SUPPORT: Support is provided for registered and non-registered users through the Bulletin Board (619)-435-0036 and voice message (619)-435-2687. Bulletin Board support is the best way to get help. Call the board and - 2 - leave a message. An answer will be posted within 36 hours. If you do not have a modem or prefer call-back support, call the voice message number. Every attempt is made to return these calls promptly, usually within two days. FROM THE AUTHOR: I am a consultant who works for government and the private sector managing a variety of projects. I needed a program that would allow me to log phone calls, keep notes (at times extensive) about correspondence and phone calls, maintain names and addresses and manage a to do list. DAILY CALENDAR is the main tool I use in managing my office and my work, and I use it to print appointment schedules, phone number lists, labels, form letters, memos and lists of items to do. DAILY CALENDAR is a daily diary and calendar, a name and address database and a to-do list manager. It was written to permit tracking projects, phone calls, letters, clients and accounts. DAILY CALENDAR was written to be simple, easy and menu-driven. The documentation is provided to give you a quick tour of the program. The best way to see how it works is to use it and experiment with the features. FEATURES: This program provides a daily calendar, to do list manager name and address database, label, list and form letter utilities and an extensive ability to query data for output. It is menu-driven and includes: Daily appointment calendar - keeps appointments and prints calendars. Allows entry of multiple appointments and unlimited text entry. Extensive record-keeping ability - any amount of text can be added to any calendar entry. This feature allows logging conversations, keeping records and tracking projects and correspondence. Text can also be imported or exported. Text search ability - entries can be retrieved and assembled into a document by seaching for key words or phrases. To do list - manages a list of items by category, priority or date. Dialer - can dial home or work numbers from within the daily calendar. Name and address database - keeps names, phone numbers, birthdays and other information at hand. Multiple databases can be created. List manager - produces phone, address and other lists. Form letters - produces field replacement form letters. - 3 - Labels - produces mailing labels in a number of styles. File manager - manages files on your hard disk, enabling easy import or export of text. Printer support - support for basic printing for 100 printers. Word processor output - supports output to ASCII text files suitable for use with any word processor. Also supports the creation of secondary merge files for popular word processors. Extensive data querying capability - data can be queried when building lists, preparing form letters, printing labels and creating merge files. GETTING STARTED: Hardware requirements: Daily Calendar requires an IBM-compatible machine with 512K to 640K minimum memory, depending of DOS version. It runs with MS-DOS or PC-DOS Versions 3.3 and higher, and with 4DOS and DR-DOS. A hard disk is required. The program supports all types of monitors. On color monitors, colors can be changed. On laptops, the program can run in color or mono modes, with mono recommended for best viewing. A modem is not required, but if present can be used to dial phone numbers. Modems using the basic Hayes AT command set are supported, and modem commands can be entered for non-standard modems. Autoexec.bat and config.sys requirements: The Daily Calendar uses a number of files and you MUST have a line in your config.sys file that says files=75 to tell DOS that up to 75 files can be open. (This program does not use 75 files, but this is a safe number to give you adequate file handles for any software.) In addition, to let the program know it can open its files you MUST have a line in your autoexec.bat that says SET CLIPPER=//F75. If you do not understand this paragraph or need help, call the support number (619-435-2687). Path and append: Do NOT set the DOS path or append command to include the Daily Calendar directory. The program must be run from its own directory. The escape key: The escape key is the abort or go back key at almost every point in the program. If you want out of an operation, hit escape. - 4 - The F1 key: F1 brings up help at many places in the program and you can write your own help screen or edit existing help by pressing Alt-F1 instead of F1. If you press Shift-F1, you will see this documentation on screen. Installation: Copy the files into a new subdirectory. To make a new subdirectory, from the DOS prompt type MD <name>. Then type CD <name> to change to that directory. If you received this program in the ZIP archive form (DAY50.ZIP) from a bulleting board, unzip the files into the new directory. If you received it as the self-extracting archive in EXE form (DAY50.EXE), copy the file to the subdirectory and type DAY50 to extract the files. CONFIGURATION: After copying the files, type DAY from the DOS prompt. The program will give you basic startup information and will then check your system configuration. Next, you will be presented with three configuration screens, shown below: Printer, video and backup configuration: ┌─────────────────────────────────────────────────────────────────────┐ │ Growler Software Inc. Daily Calendar Configuration │ │ │ │ Enter printer port (NONE, LPT1-4, COM1, COM2): LPT1 │ │ Enter backup interval in days: 7 │ │ Do you want monochrome screens (Y/N)? N │ │ Do you want calendars printed with headings (Y/N)? Y │ │ Do you want blank times printed (Y/N)? Y │ │ Do you want page breaks after each day (Y/N)? Y │ │ Enter left margin (0-40): 5 and line length (40-254): 65 │ │ Enter the page length in lines (0-100, 0=continuous): 59 │ │ Pause after each printed page (Y/N)? N │ │ Enter top margin in lines: 1 │ │ Current printer is None. Change it (Y/N)? N │ │ │ │ PRESS F1 FOR HELP ON ANY CONFIGURATION OPTION. │ └─────────────────────────────────────────────────────────────────────┘ If in doubt, select the default values. On the first screen, the options are: Enter printer port (NONE, LPT1, LPT2, COM1, COM2): Default LPT1. The port to which your printer is attached. This is usually parallel port one (LPT1). If you specify a printer port, the program will attempt to initialize the printer each time it starts. If you have no printer or the printer is turned off, you will receive an error message. If you do not have a printer connected or do not plan to print anything select the - 5 - NONE option for the port to avoid the printer error message. Enter backup interval in days: Default 14 days. The program makes a backup copy of your calendar, name and address and to do database. This option selects how often it should make this copy. Do you want monochrome screens (Y/N)? : Default NO. The program knows what kind of monitor you have and will run in color or monochrome automatically. This option is mainly for laptop users who want monochrome screens because they are easier to see. Do you want calendars printed with headings (Y/N)? : Default YES. Calendars can be printed plain or with your name as a heading. Do you want blank times printed (Y/N)? : Default YES. Calendars can be printed with or without blank times included. Do you want page breaks after each day (Y/N)? : Default YES. Calendars can be printed one day per page or multiple days per page. Enter left margin (0-40): Default 5 and line length (40-254): Default 65. These options set the left printer margin and the line length in characters. The right margin is the total of the two, or default 70. This should be fine for most printers in draft, 10 characters per inch. If you use compressed print, adjust the margins accordingly. The left margin and line length for half-sheet notebook paper fed through a laser printer and printed in compressed print are 35 and 68. Enter the page length in lines (0-100, 0=continuous): Default 59. This options sets the lines per page. If you enter 0, printing will be continuous. The page length for half-sheet notebook paper fed through a laser printer is 55. Pause after each printed page (Y/N)? : Default NO. If you are feeding paper manually, change this option to YES. Enter top margin in lines: Default 1. Change this if you want printing starting lower on the page. Do not use a top margin greater than 24 lines. Current printer is : Default NONE. Change it (Y/N)? : Default NO. Use this option to select a printer. If you answer YES to change printer, you will be presented with a list of about 100 printers. Chose your printer or the one that matches the list most closely. You will then be presented with default printing options in type size and lines per inch for the calendar functions and another choice for the name and address functions. You can also change the default printing mode from either the calendar or name and address main screens. Printer support is intended to provide basic output. If you need or want multiple fonts, italics, bold, underline or other print enhancements, send your output to a disk file and use your wordprocessor to add the extras. - 6 - HP LaserJet Printers: If you select the HP LaserJet II/III (P/D) printer option, you will have advanced control of your printer available by pressing Alt L. You will then see a menu that allows you to set pitch, orientation, line height, etc. Calendar configuration: Your calendar may be a 24 hour calendar in one-hour increments or a twelve hour calendar in half-hour increments, starting at any time you choose. For most people, a twelve hour calendar beginning at 7:00 am or 8:00 am is a good choice. If you make the wrong choice, go to the main menu, select Database Utilities and then the reset option to start over. Modem configuration: The next configuration screen installs the modem: ┌─────────────────────────────────────────────────────────────────────┐ │ Growler Software Inc. Modem Configuration │ │ │ │ This program provides dialing support with a few qualifications: │ │ All phone numbers must be entered with the area code, your modem │ │ must be either Hayes-compatible or you must know the appropriate │ │ commands and your computer must accept simple dialing commands. │ │ │ │ When using the dialer or name pick list from the calendar, the │ │ the program will write the person's name into the calendar entry. │ │ Do you want their phone numbers written in as well (Y/N)? Y │ │ Enter modem reset command: ATZ │ │ Enter modem dialing prefix: ATDT │ │ Enter modem initialization command: AT &F M1 X4 E0 S6=3 │ │ Enter number for outside line (if any): │ │ Enter prefix for long distance: 1 │ │ Enter your local area code: │ │ Enter communications port (NONE, COM1-4): COM1 │ │ Enter modem command delay: 2 │ │ PRESS F1 FOR HELP ON ANY CONFIGURATION OPTION. │ └─────────────────────────────────────────────────────────────────────┘ Modem and dialer configuration: You do need to check which serial port your modem works through (usually COM1 or COM2), and you do need to enter your area code, long distance prefix and number, if any, to obtain an outside line. If you are going to use your dialer, you must enter all phone numbers with the area code in the name and address database in the following format (XXX)-XXX-XXXX. If your modem is configured as COM3 or COM4, DOS must be able to recognize these ports for the dialer to work. This usually requires running a separate utility program, even if your modem can be set to run as COM3 or COM4 without running a separate program. A port testing option is included in the program to be sure your printer and communications ports are - 7 - recognized and functioning. The port testing program will test LPT1 through LPT4 and COM1 through COM8. The program checks to be sure the communications port is responding when starting and if you do not plan to use the dialer, enter NONE for the port to avoid the error message. The modem command delay is the number of seconds to wait between modem commands. Many modems cannot handle multiple commands in rapid succession, and this delay gives them time to process one command before attempting another. It is unlikely any modem will require more than 2 seconds and most will work with the default delay. Name and address configuration: Enter your name and address. Your name will appear on calendars and other printouts. RUNNING THE PROGRAM: DAILY CALENDAR OPERATION: After answering the configuration questions, you will go to the main menu screen. The choices are CALENDAR, OTHER and QUIT. Select an option by typing the first letter of the choice or using the cursor keys to move left and right. CALENDAR CHOICE: As shown on the screen below, you have seven options under Calendar. Calendar Other Quit ┌───────────────────────┐ │ Appointments │ │ Print │ │ Search │ │ Read File │ │ To Do List │ │ Names and Addresses │ │ Multiple Appointments │ └───────────────────────┘ - 8 - APPOINTMENTS: Takes you to a three month calendar, shown below: ┌────────────────┐┌──────────────────────────────┐ January 31, 1993 │ ││ JANUARY 1993 │ 700AM │ Cursor keys to ││ SUN MON TUE WED THU FRI SAT │ 730AM │ navigate by ││ 1 2 │ 800AM │ day and week. ││ 3 4 5 6 7 8 9 │ 830AM │ ││ 10 11 12 13 14 15 16 │ 900AM │ ││ 17 18 19 20 21 22 23 │ 930AM │PgUp +3 Months ││ 24 25 26 27 28 29 30 │ 1000AM │PgDn -3 Months ││ 31 │ 1030AM │Home -1 Year ││ FEBRUARY 1993 │ 1100AM │End +1 Year ││ SUN MON TUE WED THU FRI SAT │ 1130AM │ ││ 1 2 3 4 5 6 │ 1200N │Enter- Pick Time││ 7 8 9 10 11 12 13 │ 1230PM │Esc - Exit ││ 14 15 16 17 18 19 20 │ 100PM │ ││ 21 22 23 24 25 26 27 │ 130PM │F2 - Zoom Week ││ 28 │ 200PM │F3 - Zoom Day ││ MARCH 1993 │ 230PM │F5 - Today ││ SUN MON TUE WED THU FRI SAT │ 300PM │F6 - Print Week ││ 1 2 3 4 5 6 │ 330PM │ Daily Calendar ││ 7 8 9 10 11 12 13 │ 400PM │Growler Software││ 14 15 16 17 18 19 20 │ 430PM │ 619-435-2687 ││ 21 22 23 24 25 26 27 │ 500PM │ ││ 28 29 30 31 │ 530PM │ ││ │ 600PM └────────────────┘└──────────────────────────────┘ 630PM If you use the cursor keys to move from day to day, you will see your appointments on the right. Hit enter to select a date and you will then have the option of selecting the time you want. Day display: Press F2 (or AltZ) to zoom the appointments for the day to fill the screen. You may move the cursor to a time, hit enter and go to that time. Week display: Press F3 (or AltW) to zoom the week. When in the week-at-glance display, you may move the cursor to a day and time, hit enter and go to the date and time. You may also cursor right to see three weeks ahead. When in the week display, press Alt-P to print the week, beginning with the day on which the cursor is placed. Return to Today: Press F5 to return to today's date. Print Week: Press F6 to print a seven day calendar beginning on the selected day. This option only works with HP Laserjet selected as the printer. It prints a nice shaded bar weekly calendar in landscape. - 9 - Hour display and editing screen: After selecting a date and time, you will see the screen below. This is the basic entry editing screen. ┌─────────────────────────────────────────────────────────────────────────────┐ │01/31/93, 700AM | Esc abort | F10 save | F7 print | F6 export | F5 import │ │ Line: 1 Col: 0 | F2/AltF2 names | F3 start timer | F4 to do │ └─────────────────────────────────────────────────────────────────────────────┘ ┌─────────────────────────────────────────────────────────────────────────────┐ │ Joe Smith - call him. │ │ │ │ │ │ │ │ │ │ │ └─────────────────────────────────────────────────────────────────────────────┘ At this screen, you may type as much as you wish, remembering that the first twenty characters will show by the time when you are at the three month calendar screen. It is usually best to type a name or location first (DENTIST or Joe Smith, for example). You may enter as much text as you wish (up to a practical limit of about 64K or 32 pages). The screen will scroll down as you type. Main editing keys are the same as the Wordstar format, with Ctrl-Y deleting a line, Ctrl-T deleting a word, Ctrl-B reformatting a paragraph, etc. While on this screen, you have a number of options. If you press F1 for help, you will see the choices. They are: Esc - abort and abandon anything you typed. F10 - save and quit. F7 - print this entry now. You will have a choice of making it a memo. F6 - export entry to a text file. This option allows you to create an ASCII text file from the entry that may be used with any word processor. NOTE that if you have selected a name with the F2 option, pressing F6 will give you the choice of appending the information to the person's name and address record. This allows you easily to track all contacts with a person. F5 - import a text file to an entry. This option allows you to import an ACSII text file to the entry. Options are: loading a preset form created with your word processor or exported from the Daily Calendar, attaching a letter to the entry, etc. Documents must have been saved in your word processor with the Save Text or Save DOS File option or they will contain your word processor's control characters. F4 - go to to-do list. Pressing F4 will take you directly to the to-do - 10 - list manager. This will allow you to create a to-do item as a result of an appointment or phone call. F3 - start/stop timer. This option is useful for timing phone calls or simply stamping your entries with the exact time you made them. Pressing F3 starts the timer. Pressing F3 again stops the timer. When you stop the timer, you will be prompted to enter keywords to assist in text retrieval. F2/AltF2 - names. Pressing F2 pops up a screen of names and addresses, shown below. Your choices are: F5 - dial work, F6 - dial home, F2 - lookup name (type a letter to begin search), (spacebar) - transfer information without dialing, Esc - quit. When you dial a person or transfer data by pressng the spacebar, the person's name and phone numbers are written into your daily calendar entry automatically. If you press AltF2 instead of F2, you may add names to the name and address database. ┌─────────────────────────────────────────────────────────────────────────────┐ │07/17/91, 700AM | Esc abort | F10 save | F7 print | F6 export | F5 import │ │ Line: 1 Col: 0 | F2/AltF2 names | F3 start timer | F4 to do │ └─────────────────────────────────────────────────────────────────────────────┘ ┌─────────────────────────────────────────────────────────────────────────────┐ │ │ │ │ │ │ │ ┌─────────────────────────────────────────────────────────────────────────┐│ │ │ LNAME FNAME WPHONE ││ │ │ ═════════════════════════════╤═════════════════╤═══════════════════════ ││ │ │ Smith │ John │ (619)936-3927 ││ │ │ Smith │ Martha │ (619)936-3663 ││ │ │ Smythe │ Fred │ (714)442-0987 ││ │ │ Timson │ Albert │ (619)998-1052 ││ │ │ Tindall │ Joe │ (619)980-5230 ││ │ │ Tindall │ Sam │ (619)998-8206 ││ │ │ Young │ Loretta │ (619)954-4515 ││ │ │ Young │ Robert │ (619)994-8055 ││ │ │ Zumwalt │ Edgar │ (619)979-9944 ││ │ └─────────────────────────────────────────────────────────────────────────┘│ │ ┌─────────────────────────────────────────────────────────────────────────┐│ │ │ | Esc exit | F8 View notes | F5 dial work | F6 dial home | F2 lookup ││ │ │ (spacebar) transfer data ││ └──└─────────────────────────────────────────────────────────────────────────┘┘ PRINT: Brings up the screen below for printing calendars. You may print tomorrow's calendar, the calendar for the current date or a calendar for any specified range of dates. - 11 - SEARCH: Brings up the following screen. Enter the name of the output file and the words/strings to locate. The program will scan the database and present you with each match. At each match, you may press F7 to save the entry to the file, or Esc/F10 to proceed without saving. After pressing F7, press Esc or F10 to find the next match. When done, the file you have created will be ASCII text that may be used with any word processor. ┌────────────────────────────────────────────────────────────────────────┐ │ Daily Calendar Search - Escape to Exit │ │ The database contains records from / / to / / │ │ │ │ Enter filename for search results (Esc to exit): │ │ │ │ Enter words/strings to locate. Separate items with a semicolon (;) │ │ for OR searches. You may enter as many as will fit in the space below.│ │ Words/strings: │ └────────────────────────────────────────────────────────────────────────┘ READ FILE: Gives you a choice of all files in the current subdirectory. Choose one from the list, press enter and it will appear on screen. The purpose of this function is to allow you to view lists, calendars and search files you have created to see if you have what you want. - 12 - TO DO LIST: Brings up the to do list manager, which can also be entered from any calendar entry screen by pressing F4. The to do list screen is shown below. You may add, edit, print or delete records and you may view or print them in different sorted orders. ┌─ Todo Manager ───────────────────────────────────────────────────────────────┐ │ Item Category Priority Do by Done │ │──────────────────────────────────────────────────────────────────────────────│ │ │ │ │ / / │ No │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ ├──────────────────────────────────────────────────────────────────────────────┤ │Item........ │ │Category.... Priority.. Do By..07/10/91 Done?..N │ │ │ │ │ ├──────────────────────────────────────────────────────────────────────────────┤ │ Q)uit E)dit A)dd D)elete F)ilter M)emo P)rint O)rder │ └──────────────────────────────────────────────────────────────────────────────┘ NAMES AND ADDRESSES: Take you into the name and address database program. You may append, edit and browse, and create lists, labels and form letters. This program is entirely menu driven and very simple to use. The NAMES AND ADDRESSES portion of the program is fully described later. MULTIPLE APPOINTMENTS: Allows you to create repeating appointments and, if you choose, corresponding to do items. First, pick the starting date and the time. You will then be asked to enter the text for the appointment: ┌────────────────────────────────────────────────────────────────────────┐ │ Enter appointment text: │ │ │ └────────────────────────────────────────────────────────────────────────┘ - 13 - Next, you will be asked to pick the appointment interval, as shown below: ┌Select Appointment Interval──┐ │Daily │ │Weekly │ │Monthly │ │Annually │ │Every X days │ │Every X weeks │ │Every X months │ │Same week each month │ └─────────────────────────────┘ Next, you will be asked to enter the number of repetitions: ┌───────────────────┐ │ Enter repetitions │ │ 0 │ └───────────────────┘ Next, you will be asked if you want corresponding to do list items: ┌──────────────────────────────────────┐ │ Create corresponding to do items N │ └──────────────────────────────────────┘ If you say YES, you will see the following screen: ┌──────────────────────────────────────────────────────────────────────────┐ │ To do item │ │ Category │ │ Priority │ │ Days before/after (+/-) 0 │ └──────────────────────────────────────────────────────────────────────────┘ The appointment text will appear in the to do item field. You may edit it or change it as you wish. You may also enter the to do category and priority. The last field, days before/after, allows you to create a to do item with a do by date that is either before, after or the same date as the appointment. If you want to remind yourself to do something before an appointment, enter a negative number (-7 for one week before). For reminders after the appointment, enter a positive number (7 for one week after). If you want the do by date to be the same as the appointment date, enter 0. - 14 - OTHER OPTIONS FROM MAIN MENU: The second group of choices from the main menu, OTHER, allows you to enter your name and address, set colors, reconfigure the program, jump to DOS, delete or copy databases, manage files, test ports or change the printer mode default. Calendar Other Quit ┌──────────────────────┐ │ Name │ │ Set Colors │ │ Reconfigure │ │ Jump to DOS │ │ Database Utilities │ │ File Functions │ │ Test Port │ │ Printer Mode Default │ └──────────────────────┘ NAME: Allows you to change the name you entered when configuring. SET COLORS: If you choose SET COLORS, you can choose simple or complex color setting. Simple allows you to pick preset combinations and complex allows you to change everything and create your own custom color sets. If in doubt, Black & White will run on anything. JUMP TO DOS: If you JUMP TO DOS, remember to return to the same directory before typing EXIT to return to the program. DATABASE UTILITIES: The DATABASE UTILITIES options allow you to delete databases, reindex the databases or reset the calendar start time. These choices affect the calendar and to do databases, not the name and address database. ┌Select Action or Escape──────┐ │Zap the calendar database │ │Zap the to do database │ │Reindex the databases │ │Copy the calendar database │ │Copy the to do database │ │Reset the calendar start time│ │Delete a range of records │ └─────────────────────────────┘ - 15 - FILE FUNCTIONS: The FILE FUNCTIONS option gives you a file manager that can be used to copy, move, delete, view or rename files. ┌──────────────────────────────────────┐╔════════════╤═════════╤═══════08:27:00╗ │ Growler Software - File Manager │║ Name │ Size │ Date │ Time ║ │ │║.. │>UP--DIR<│01/22/93│ 4:34p║ │ │║day cfg│ 8701│01/26/93│ 8:22a║ │ F2 - New drive │║day dbf│ 3823│01/26/93│ 8:26a║ │ F3 - View a file │║day dbt│ 6661│01/26/93│ 8:26a║ │ F4 - Edit a text file │║day exe│ 621568│01/21/93│11:22p║ │ F5 - Copy a file │║day msg│ 5535│01/21/93│11:22p║ │ F6 - Move or rename a file │║day ntx│ 2048│01/26/93│ 8:26a║ │ F8 - Create a new text file │║daybak cfg│ 8701│01/26/93│ 8:22a║ │ F9 - Delete a file │║dayfix txt│ 125│01/26/93│ 8:22a║ │ F10 or Esc - Exit the File Manager │║employee dfm│ 309│01/21/93│11:22p║ │ │║help dbf│ 2145│01/21/93│11:22p║ │ Current drive C: │║help dbt│ 60166│01/21/93│11:22p║ │ Current directory: │║help ntx│ 4096│01/26/93│ 8:22a║ │ \DAY │║home lbl│ 1034│01/21/93│11:22p║ │ │║printers dbf│ 40681│01/21/93│11:22p║ │ │║redbook dbf│ 931│01/26/93│ 8:22a║ │ │║redbook dbt│ 512│01/26/93│ 8:22a║ │ │║redcode ntx│ 2048│01/26/93│ 8:22a║ │ │╠════════════╧═════════╧════════╧══════╣ │ │║.. >UP--DIR< 01/22/93 4:34p║ └──────────────────────────────────────┘╚══════════════════════════════════════╝ 1 2Drive 3View 4Edit 5Copy 6RenMove7 8NewFile9Delete 10Exit TEST PORT: The TEST PORT option allows you to check your parallel and serial ports to see if the program recognizes them. Remember when testing ports that a device (printer or modem) must be attached to the port, turned on and on line. When testing COM3 and COM4, you will have the option to initialize them so DOS will recognize them. If you have a modem or printer installed as COM3 or COM4, test the port first and initialize and retest it if it shows not ready. If you are using another utility to intialize COM3 and/or COM4, this should not be necessary. The Daily Calendar writes to COM ports through low level DOS file services. If you install your printer and your modem both as the same COM port, you will have problems and probably bizarre results. If you have COM3 and COM4 available in an add-on board or directly by setting switches or jumpers on your modem to COM3 or COM4, DOS will probably not recognize the additional ports unless you run a separate utility program. (DOS only support COM1 and COM2. COM3 and COM4 support involve a little trickery.) There are a number of utilities that enable DOS to recognize COM3 and COM4. If you cannot find one or have problems, call the support number (619-435-2687) and we will try to - 16 - help. DOS reports parallel ports ready if there is a printer attached and on line or if there is no printer cabled to the port. PRINTER MODE DEFAULT: The PRINTER MODE DEFAULT option allows you to change the print mode for the calendar functions. QUIT: The last option from the main menu is QUIT. Calendar Other Quit ┌─────┐ │Quit │ └─────┘ NAMES AND ADDRESSES OPERATION: The NAMES AND ADDRESSES choice takes you into the name and address database program. You may append, edit and browse, and create lists, labels and form letters. This program is entirely menu driven and very simple to use. Names and Addresses Utilities Other Quit ┌───────────────────────────┐ │ Edit and Append │ │ Mailing Labels │ │ Lists │ │ Read File │ │ Form Letters │ │ Browse │ │ Wordprocessor Merge Files │ │ Search │ │ Change Index │ └───────────────────────────┘ The address book in use is REDBOOK.DBF indexed on NAME Entry screens are shown below. - 17 - EDIT AND APPEND: Record entry screen: ┌─────────────────────────────────────────────────────────────────────────────┐ │ │ │ Redbook Name and Address Database - Growler Software │ │ │ │ Last Name: No.: │ │ First Name: │ │ │ │ Home Address: │ │ City: State: Zip: │ │ Home Phone: ( )- - │ │ │ │ Company: │ │ Title: │ │ Work Address: │ │ City: State: Zip: │ │ Work Phone: ( )- - Ext.: FAX: ( )- - │ │ Email: Entry Date: / / Code: │ │ │ │ Birth Date: / / Spouse: │ │ Children: │ │ Comment: │ │ | F5 - Dial at work | F6 - Dial at home │ │ | PgUp/PgDn - Prior/Next | CtrlPgUp/CtrlPdDn - First/Last | F2 Lookup │ │ | Spacebar Edit | F10 Append | F9 Delete/Recall | F8 Edit Memo | Esc Exit │ └─────────────────────────────────────────────────────────────────────────────┘ - 18 - MAILING LABELS: Label definitions can be saved to disk, and you can customize label entries easily. When entering field information, follow the instructions given. You will probably want to edit inserted field data so that it formats properly. Use the form TRIM(FNAME)+" "+TRIM(LNAME) to print the first and last names separated by a single space. There are two sample label files that shows how to use this syntax to produce home (HOME) and work (WORK) address mailing labels. The samples are set for three-across labels and should be printed in 10CPI, 6LPI print mode. ┌──────────────────────────────────────────────────────────────────────────────┐ │┌───[Mailing Labels]─────────────────────────────┐ │ ││ Load Label from disk │ │ ││ Save Label to disk │ │ ││ Erase Label definition │ │ ││ Import from .LBL format │ │ ││ Dimensions of Label │ │ ││ Contents of Label │ │ ││ Output Test Pattern │ │ ││ Print Mailing Labels │ │ ││ Reset Printer Port. Now:LPT1 │ │ ││ Tag Records to Print │ │ ││ Build or Modify Query │ │ ││ About Using Laser Printers * │ │ ││ Use Single Sheet Options │ │ ││ Quit │ │ │└────────────────────────────────────────────────┘ │ │ │ │ │ │ │ │┌────────────────────────────────────────────────────────────────────────────┐│ ││Label in use : ││ ││Dbf file in use : REDBOOK ││ │└────────────────────────────────────────────────────────────────────────────┘│ └──────────────────────────────────────────────────────────────────────────────┘ - 19 - LISTS: You can create any type of lists you want. Examples are phone number lists, address lists, etc. You can use the query option to select the records you want and you can select records based on up to ten matches in the notes field. If you print the memo field, it will print a line below the other items for the record to avoid wrapping. List definitions can be saved to disk for later use. ┌──────────────────────────────────────────────────────────────────────────────┐ │┌───[List Builder]───────────────────────────────┐ │ ││ Pick fields to list - NOTES/MEMO must be last │ │ ││ Modify fields to list │ │ ││ Output list │ │ ││ Save list definition to disk │ │ ││ Restore list definition from disk │ │ ││ Delete stored definitions │ │ ││ Choose Printer Port (now LPT1) │ │ ││ Build Query (No Query ) │ │ ││ Layout Options │ │ ││ Quit │ │ │└────────────────────────────────────────────────┘ │ │ │ │ │ │┌────────────────────────────────────────────────────────────────────────────┐│ ││NO LIST ACTIVE │ │└────────────────────────────────────────────────────────────────────────────┘│ └──────────────────────────────────────────────────────────────────────────────┘ FORM LETTERS: You can create form letters with field replacement of information. Help is available from within the form letters utility and you can save forms to disk. BROWSE: This option allows a tabular browse and edit of the name and address database. WORDPROCESSOR MERGE FILES: This utility produces secondary merge files in WordPerfect, Microsoft Word or Wordstar format. If you prefer to mailmerge from your word processor, this utility will create the merge files of names, addresses, etc. you need. SEARCH: Brings up the following screen. Enter the name of the output file and the words/strings to locate. The program will scan the database and present you with each match. At each match, you may press F7 to save - 20 - the entry to the file, or Esc/F10 to proceed without saving. After pressing F7, press Esc or F10 to find the next match. When done, the file you have created will be ASCII text that may be used with any word processor. This is the same search function you have in the calendar database, but here it searches the notes fields of the name and address database. ┌────────────────────────────────────────────────────────────────────────┐ │ Name and Address Search - Escape to Exit │ │ The database contains records from / / to / / │ │ │ │ Enter filename for search results (Esc to exit): │ │ │ │ Enter words/strings to locate. Separate items with a semicolon (;) │ │ for OR searches. You may enter as many as will fit in the space below.│ │ Words/strings: │ └────────────────────────────────────────────────────────────────────────┘ CHANGE INDEX: The name and address database is indexed on name, code, number and company. You can switch between these three indexes with this choice. The index in use is shown at the bottom of the screen next to the name of the database in use. NAME AND ADDRESS UTILITIES: Names and Addresses Utilities Other Quit ┌──────────────────────────────────────────────┐ │ Pack - Remove Deleted Records │ │ Zap - Remove ALL Records │ │ Reindex │ │ Select Address Database │ │ Copy Records to a New Address Database │ │ Append Records from Another Address Database │ │ Field Replacement │ └──────────────────────────────────────────────┘ The address book in use is REDBOOK.DBF indexed on NAME PACK: This option permanently removes deleted records. ZAP: This option permanently removes ALL records. - 21 - REINDEX: The REINDEX option rebuilds your index files. SELECT ADDRESS DATABASE: The SELECT ADDRESS DATABASE option lets you switch from one address database to another. You may have as many as you like, but only one will be active at a time. The current address book is always shown at the bottom of the screens. COPY RECORDS TO A NEW DATABASE: The COPY RECORDS TO A NEW ADDRESS DATABASE allows you to copy some or all of the records in the current database to a new one or to create a new, blank database. You may choose all records, query matches or tagged records. APPEND RECORDS FROM ANOTHER DATABASE: The APPEND RECORDS FROM ANOTHER DATABASE allows you to add records to one database from another. You will be asked what database to append to and what database to append from. You can use this to bring records into the name and address database from another dBASE III type database by matching fields. You will then see the screens below: ┌──────────────────────────────────────────────────────────────────────────────┐ │┌───[To Append Records:]───────────────┐ │ ││ First : Select the import file │ │ ││ Second: Match the fields │ │ ││ Third : Import the records │ │ ││ Quit │ │ ││ │ │ ││ Tag records to append │ │ ││ Build or modify query │ │ │└──────────────────────────────────────┘ │ │ │ │ │ │┌────────────────────────────────────────────────────────────────────────────┐│ ││[Import into:] REDBOOK ││ ││[Import from:] ││ ││[Filter type:] None ││ ││ ││ │└────────────────────────────────────────────────────────────────────────────┘│ └──────────────────────────────────────────────────────────────────────────────┘ You will then be asked to match fields. If they are the same, just press F10. - 22 - ┌──────────────────────────────────────────────────────────────────────────────┐ │┌─[Match Fields]─────────────────────────────────────────────────────────────┐│ ││ Target File Fields Append From Import Fields ││ ││────────────────────────────────────────────────────────────────────────────││ ││ MARK => │MARK ││ ││ LNAME => │LNAME ││ ││ FNAME => │FNAME ││ ││ NUMBER => │NUMBER ││ ││ TITLE => │TITLE ││ ││ COMPANY => │COMPANY ││ ││ WADDRESS => │WADDRESS ││ ││ WCITY => │WCITY ││ ││ WSTATE => │WSTATE ││ ││ WZIP => │WZIP ││ ││ WPHONE => │WPHONE ││ ││ EXT => │EXT ││ ││ FAX => │FAX ││ ││ EMAIL => │EMAIL ││ ││ HADDRESS => │HADDRESS ││ ││ HCITY => │HCITY ││ │├────────────────────────────────────────────────────────────────────────────┤│ ││ < CR> Select Target Field IF FIELDS ARE THE SAME, JUST PRESS F10 NOW. ││ ││ <F2> Type In Import Value <F3> Complex Import Value <F10> Menu ││ │└────────────────────────────────────────────────────────────────────────────┘│ └──────────────────────────────────────────────────────────────────────────────┘ If you are appending from an address database you created in this program, simply press F10 to complete the append. If you want to append from any dBASEIII or Clipper database, this screen enables you to match up the fields and translate them into proper format. This is a powerful option to allow you to import databases created by other programs. If the other database cannot be opened because it is an incompatible form, you will see a message. This intelligent append works with dBASEIII and Clipper created databases, but not with dBASEIV databases. FIELD REPLACEMENT: The FIELD REPLACEMENT option is a powerful tool to change the contents of any fields in any databases. It was written to facilitate changing area codes as new area codes go into service, but is can be used to replace all or part of any field in any database, replacing all records or records matching a query. If you choose this option, you will be presented with screens to select the database, the field to replace, the choice of building a query and the option to replace all or part of the field. - 23 - NAME AND ADDRESS OTHER OPTIONS: Names and Addresses Utilities Other Quit ┌─────────────────────────────┐ │ Jump to DOS │ │ Fill Last Name with Company │ │ Reverse Last Name Fill │ │ Printer Default Mode │ └─────────────────────────────┘ JUMP TO DOS: You can JUMP TO DOS, as in the Calendar program. FILL LAST NAME FIELD WITH COMPANY: You can FILL LAST NAME FIELD WITH COMPANY. This option is useful if you have only the company name and no first or last name entered. Filling the last name field with the company name makes it easier to browse the database. REVERSE LAST NAME FILL: You can REVERSE LAST NAME FILL. This option undoes the FILL LAST NAME WITH COMPANY action. - 24 - THE QUERY FUNCTION: The query builder is available when creating lists, copying records or producing output. You will see an option that asks if you want all rercords, tagged records or records matching the query. If you choose the query option, you will enter the query builder. The query builder allows you to define a condition which a record must meet in order for the record to be included in the filter. While the query is active, only the records that meet the condition you have specified will be presented for viewing, editing, printing, etc. The other records in your database are still there, but they are temporarily filtered out. When the filter is turned off, all your records are available for use again. When you select the query builder, you will be presented with the following menu: ┌──────────────────────────────────────────────────────────────────────────────┐ │┌───[List Builder]───────────────────────────────┐ │ ││ Pick fields to list │ [Query Active] │ ││ Modify field┌[Online Query Builder]────────────┐ │ ││ Output list │ │ │ ││ Save list de│ Build a new Query │ │ ││ Restore list│ Add to current query │ │ ││ Delete store│ Count matching records │ │ ││ Choose Print│ Zap (remove) existing Query │ │ ││ Quit │ Save current Query to disk │ │ │└─────────────│ Restore Query from disk │ │ │ │ Delete stored queries │ │ │ │ What is current Query │ │ │ │ Edit current Query │ │ │ │ View records matching Query │ │ │ │ Quit │ │ │ │ │ │ │ │ Query Active │ │ │┌Current Field└──────────────────────────────────┘───────────────────────────┐│ ││ LNAME, ││ ││ ││ ││ ││ ││ ││ │└[ # of columns needed: 21]──────────────────────────────────────────┘│ └──────────────────────────────────────────────────────────────────────────────┘ - 25 - How to build a query: When you select Build a new Query, you will be presented with a list of the fields in the database you are working with. Here is an example: ┌──────────────────────────────────────────────────────────────────────────────┐ │┌───[List Builder]───────────────────────────────┐ │ ││ Pick fields to list │ [Query Active] │ ││ Modify field┌[Online Query Builder]────────────┐ │ ││ Output list │ │ │ ││ Save list de│ Build a new Query │ │ ││ Restore list│ Add to current query │ │ ││ Delete store│ Count matching records ┌[Database Field List]──┐ │ ││ Choose Print│ Zap (remove) existing Query│ < Deleted? > │ │ ││ Quit │ Save current Query to disk │ MARK │ │ │└─────────────│ Restore Query from disk │ LNAME │ │ │ │ Delete stored queries │ FNAME │ │ │ │ What is current Query │ TITLE │ │ │ │ Edit current Query │ COMPANY │ │ │ │ View records matching Query│ WADDRESS │ │ │ │ Quit │ WCITY │ │ │ │ │ WSTATE │ │ │ │ Query Active │ WZIP │ │ │┌Current Field└─────────────────────────────│ WPHONE │────────┐│ ││ LNAME,FNAME,TITLE,COMPANY,WADDRESS,WCITY,W│ HADDRESS │ ││ ││ │───────────────────────│ ││ ││ │ ENTER to select │ ││ ││ └───────────────────────┘ ││ │└[ # of columns needed: 175]──────────────────────────────────────────┘│ └──────────────────────────────────────────────────────────────────────────────┘ Place the lite bar over the field you want, and press Enter to select the field. Note: the Deleted option allows you to work with records you may have marked for deletion but have not yet purged from the database. When you select a field, you will be asked if you wish to further define the field you have selected. You will be asked: Extend field LNAME with EXPRESSION BUILDER ? No Yes Expression builder: The default answer in No. In most cases, this is what you will want. If you have some particular need to further refine the selection of data in the field you have chosen, you can answer Yes. If you answer Yes, you will be presented with a menu of choices appropriate to the type of field you have selected, i.e., character, numeric, date, logical, or memo field. - 26 - Here are the choices if the field type is character: E X P R E S S I O N B U I L D E R QUIT and return current expression TEST against database (WYSIWYG) UNDO last change HELP help with expression builder EXTRACT subset or rearrange JUSTIFY left right centered CASE uppercase lowercase proper MOVE spaces to end of string ADD or imbed characters SUBSTITUTE one value for another DIFFERENT change to date or numeric Select QUIT to leave the expression builder. Select TEST to test your expression against the current database. Select UNDO to undo your most recent change while using the expression builder. Select HELP for brief help on using the expression builder. Select EXTRACT if you wish to work with only those records that contain a desired portion of the data in the character field. For example, assume the character field you have selected contains a ten character code, and you want to work with only those codes that contain A99 in the first three spaces. You could select EXTRACT, then Left 3 characters on the next screen. The query expression would become LEFT(ITEM,3). After Quitting to the next screen, you would specify EXACTLY EQUAL TO, and then A99. If you then Viewed records matching the Query, you would see only records which contained A99 in the first three spaces of the item code field. When you return to the main menu, the query expression will be displayed in the Status box at the bottom of the screen to remind you that the only records that are active are those which meet the query expression. Select JUSTIFY if you wish the right justified, left justified, or centered field data to match some value you are going to specify. An example of a situation in which you might use this capability would be where you suspect blank spaces might have been entered in the field, e.g., " A99" instead of "A99". By specifying left justified here, and specifying EXACTLY EQUAL TO A99 at the next screen, you will get all the A99 records, even those where blanks might have been entered by mistake at the beginning of the field.\ Select CASE if you wish the upper-cased, lower-cased, or properized (first - 27 - letter capitalized) field data to match some value you are going to specify in the next step. Select MOVE to move all spaces, or all but single spaces to the end of a string. For example: "Merry Christmas to all" becomes "Merry Christmas to all " if you move all but single spaces to the end, and "MerryChristmastoall " if you move all spaces to the end. Select ADD if you wish to add or imbed particular characters in the query expression in order to compare that expression to some value you will specify in the next step. Select SUBSTITUTE if you want to have the filter substitute one string of characters for another string so that appropriate matching can take place against some value you will specify in the next step. Select DIFFERENT if you wish to have the filter convert characters to numeric or date format so that appropriate matching can take place against some value you will specify in the next step. Other appropriate options for expression building are presented when you select a numeric, date, logical, or memo field. The basic idea is that the expression builder allows you to further define the field data you want to match some value you are going to specify in the next step. - 28 - Whether you have used the Expression Builder or not, the next step in defining your query is presented with the following menu if the field you are working with is a character field: ┌──────────────────────────────────────────────────────────────────────────────┐ │┌───[List Builder]───────────────────────────────┐ │ ││ Pick fields to list │ [Query Active] │ ││ Modify field┌[Online Query Builder]────────────┐ │ ││ Output list │ │ │ ││ Save list de│ Build a new Query │ │ ││ Restore list│ Add to current query ┌────────────────────────────┐ │ ││ Delete store│ Count matching records │= (EXACTLY EQUAL TO) │ │ ││ Choose Print│ Zap (remove) existing Query│<> (NOT EQUAL TO) │ │ ││ Quit │ Save current Query to disk │< (LESS THAN) │ │ │└─────────────│ Restore Query from disk │> (GREATER THAN) │ │ │ │ Delete stored queries │<= (LESS THAN OR EQUAL TO) │ │ │ │ What is current Query │>= (GREATER OR EQUAL TO) │ │ │ │ Edit current Query │$ (CONTAINS) │ │ │ │ View records matching Query│!$ (DOES NOT CONTAIN) │ │ │ │ Quit │?* (WILDCARD MATCH) │ │ │ │ │S (IS SIMILIAR TO) │ │ │ │ Query Active │B (BEGINS WITH) │ │ │┌Current Field└─────────────────────────────│E (ENDS WITH) │───┐│ ││ LNAME,FNAME,TITLE,COMPANY,WADDRESS,WCITY,W│ │ ││ ││ └────────────────────────────┘ ││ ││ ││ ││ ││ │└[ # of columns needed: 175]──────────────────────────────────────────┘│ └──────────────────────────────────────────────────────────────────────────────┘ What you are being asked to do here is to tell the query builder how you want the field data (or the expression you defined in the expression builder) to be compared to some value. For example, if the field you selected is LNAME, you can tell the query builder here that the field contents must be exactly equal to SMITH, that the field contains JONES, that the field contents begin or end with some value, etc. Similar appropriate options for field content comparisons are presented when you select a numeric, date, logical, or memo field. - 29 - When you have finished defining the query expression for the field you selected, you will be presented with the following choices: ┌──────────────────────────────────────────────────────────────────────────────┐ │┌───[List Builder]───────────────────────────────┐ │ ││ Pick fields to list │ [Query Active] │ ││ Modify field┌[Online Query Builder]────────────┐ │ ││ Output list │ │ │ ││ Save list de│ Build a new Query │ │ ││ Restore list│ Add to current query │ │ ││ Delete store│ Count matching records │ │ ││ Choose Print│ Zap (remove) existing Query┌────────────┐ │ ││ Quit │ Save current Query to disk │ DONE │ │ │└─────────────│ Restore Query from disk │ AND │ │ │ │ Delete stored queries │ OR │ │ │ │ What is current Query │ AND NOT │ │ │ │ Edit current Query │ OR NOT │ │ │ │ View records matching Query└────────────┘ │ │ │ Quit │ │ │ │ │ │ │ │ Query Active │ │ │┌Current Field└──────────────────────────────────┘───────────────────────────┐│ ││ LNAME, ││ ││ ││ │└[ # of columns needed: 21]──────────────────────────────────────────┘│ └──────────────────────────────────────────────────────────────────────────────┘ If you are done, select DONE and you will be returned to the main query builder menu. If you wish to include other field specifications in the query expression, you can select one of the other options, as appropriate, and repeat the same procedure as above. For example, say your query expression at this point is something like LNAME = "SMITH", and you wanted to work with only those SMITHs who live in California. Assuming your database contains a two character STATE field, you would: 1. select AND instead of DONE. 2. select STATE from the field list. 3. select EXACTLY EQUAL TO or CONTAINS (CONTAINS is often better) 4. enter CA for the state name. 5. select DONE. Your query expression now contains the appropriate references to both fields. When you have created your query expression, Query Active will flash on the screen. You can now Quit the query builder and return to the main menu, or select another option from the query builder menu. If you Quit, you will return to the main menu where the query expression will be displayed in the Status box at the bottom of the screen to remind - 30 - you that the only records that are active are those which meet the query expression. You can toggle the filter (query expression) off by selecting Filter again from the main menu. The other query builder menu options are fairly self-explanatory. One of these options, Edit current Query, allows you to modify the query expression yourself. Any valid dBase or Clipper function may be used. For example, if you wanted to specify the trim (field data stripped of any trailing blanks) of a character field called LNAME, you could edit the query expression to include TRIM(LNAME). Querying memo fields: The NOTES field is a memo field and if you query it, you will see the screen below: You may choose CONTAINS, IS EMPTY or IS NOT EMPTY. ┌──────────────────────────────────────────────────────────────────────────────┐ │┌───[List Builder]───────────────────────────────┐ │ ││ Pick fields to list │ [Query Active] │ ││ Modify field┌[Online Query Builder]────────────┐ │ ││ Output list │ │ │ ││ Save list de│ Build a new Query │ │ ││ Restore list│ Add to current query ┌───────────────────┐ │ ││ Delete store│ Count matching records │$ (CONTAINS) │ │ ││ Choose Print│ Zap (remove) existing Query│E (IS EMPTY) │ │ ││ Quit │ Save current Query to disk │N (IS NOT EMPTY) │ │ │└─────────────│ Restore Query from disk │ │ │ │ │ Delete stored queries └───────────────────┘ │ │ │ What is current Query │ │ │ │ Edit current Query │ │ │ │ View records matching Query │ │ │ │ Quit │ │ │ │ │ │ │ │ Query Active │ │ │┌Current Field└──────────────────────────────────┘───────────────────────────┐│ ││ LNAME,FNAME,TITLE,COMPANY,WADDRESS,WCITY,WSTATE,WZIP, ││ ││ ││ ││ ││ ││ ││ │└[ # of columns needed: 175]──────────────────────────────────────────┘│ └──────────────────────────────────────────────────────────────────────────────┘ - 31 - If you choose CONTAINS, you will then see the next screen below. You may now enter up to ten words or items separated by the semicolon. The query will then separate records that contain any one (or more) of the words or items in the NOTES field. ┌──────────────────────────────────────────────────────────────────────────────┐ │┌───[List Builder]───────────────────────────────┐ │ ││ Pick fields to list │ [Query Active] │ ││ Modify field┌[Online Query Builder]────────────┐ │ ││ Output list │ │ │ ││ Save list de│ Build a new Query │ │ ││ Restore list│ Add to current query │ │ ││ Delete store│ Count matching records │ │ ││ Choose Print│ Zap (remove) existing Query │ │ ││ Quit │ Save current Query to disk │ │ │└─────────────│ Restore Query from disk │ │ │ │ Delete stored queries │ │ │ │ What is current Query │ │ │ │ Edit current Query │ │ │ │ View records matching Query │ │ │ │ Quit │ │ │ │ │ │ │ │ Query Active │ │ │┌Current┌────────────────────────────────────────────────────────────┐───────┐│ ││ LNAME,│Where NOTES Contains │ ││ ││ │ │ ││ ││ │Use ; to separate multiple items to check │ ││ ││ │i.e. Ralph;Fred;Joe;Eddie - up to 10 items │ ││ │└[ # of └────────────────────────────────────────────────────────────┘───────┘│ └──────────────────────────────────────────────────────────────────────────────┘ The query builder is a very powerful, flexible tool and can be used to produce labels, letters or lists with just the records you want. HP LASERJET FUNCTIONS: If you select the HP Laserjet *II/III (P/D), you will see the following message: ┌─────────────────────────────────────────────────────────────────┐ │ You will have advanced control of your HP LaserJet │ │ available whenever you print by pressing Alt L. This will │ │ bring up a menu to allow you to reset lines per inch, │ │ characters per inch, portrait or landcape, manual feed and │ │ tray selection. The default printing modes will stay in effect │ │ unless you press Alt L to change printing modes. │ │ │ │ Press a key... │ └─────────────────────────────────────────────────────────────────┘ If you press Alt L from within the program, you can change print modes on your Laserjet printer. The menu below will pop up and you can select the item you want. If you need to select multiple items, press Alt L again for - 32 - each choice. Calendar Other Quit ┌───────────────────┌HP LaserJet Utilities - Esc to exit┐ │Appointments │Reset laser printer │ │Print │Form feed │ │Search │Number of copies │ │Read File │Portrait │ │To Do List │Landscape │ │Names and Addresses│Simplex │ │Multiple Appointmen│Duplex - Vertical binding │ └───────────────────│Duplex - Horizontal binding │ │Select current tray │ │Manual envelop feed │ │10 cpi pitch │ │4 lines/inch │ │5 lines/inch │ │6 lines/inch │ │8 lines/inch │ │10 lines/inch │ │12 lines/inch │ └───────────────────────────────────┘ HISTORY: Version 3.0 - First commercial release. Written and compiled with Clipper 5.0 Version 3.1 - Enhancement and bug fix. Written and compiled with Clipper 5.01. Version 3.2 - Checks to see if COM ports are active, enhanced critical error handler, new function to check if index files are current. Also added intelligent append, mailmerge file creator and structure modification utility. Version 3.2B - Added feature to initialize COM3 and COM4 if needed. Fixed calendar printing error. Added a memory check diagnostic (press Ctrl-F1) for users who might have memory concerns. Changed designation of SET CLIPPER command to deal with Clipper 5.01's need to see this environment string as SET CLIPPER=//F75. Version 4.0 - Added a variety of features, including configuration checking, view notes in calendar entries, etc. Version 4.1 - A maintenance upgrade to reflect the new version of Clipper and fix bugs. Also added a new "item" index to the to do database. Version 5.0 - A major rewrite that uses 20K less memory. Dialer now works through low level file calls rather than by shelling to DOS, requiring about 60K less memory for dialing. Added Number field to - 33 - names and addresses, added indexes to names and addresses and to do databases. FOR ANY PROBLEMS OR ERRORS, please call the voice support number, 619-435-2687 or the bulletin board, 619-435-0036. You will receive a call back and prompt help. ERRORS: The program traps critical errors (DOS and system errors). If one of these occurs and the problem is not immediately apprarent (tried to write to an invalid drive, a write-protected disk, etc.), you will see any error screen. Print this screen with Shift-PrScr and call the support number (619-435-2687). If an error occurs, two files will be written to disk, CLIPn.ERR and CLIPn.MEM. These files contain error information. A sample error screen is shown below: ╔╡Error: TERM/2014╞══════════════════════════╗ ║ Code 20: Create error (retry 2) ║ ║ Filename: b:junk.PRN ║ ║ Called from: SET (0) ║ ║ PORF (1307) ║ ║ PRN_GCAL (497) ║ ║ DAY (150) ║ ║ Please notify the developer of this error. ║ ║ ┌────────────────────────────────┐ ║ ║ │ Retry Ignore Fail Screen Abort │ ║ ╚═════╧════════════════════════════════╧═════╝ COMMON QUESTIONS: Q. My calendar starts at 3:00 am, how do I change it? A. Selecting start time is a one time only choice at installation. If you skip past it accidentally or need to change it, you must choose the RESET CALENDAR START TIME option from the database utilities option. Q. The program is over 600,000 bytes. Don't I need 600K of free memory to run it? A. No. The program has a load size of 312K, which means that you should have no problem running it on a machine with 640K of memory and probably can run it on a machine with 512K of memory. The reason the program file is so large is because this file contains all the overlay files which are often separate files in other programs. If you are low on memory because you have a number of terminate and stay resident (TSR) programs loaded, you will see an error warning. If want to see how much memory is free after loading, press Ctrl-F1, which gives you a listing of memory available and memory installed. - 34 - If you receive a LOW MEMORY warning, you may need to check to see how many terminate-and-stay-resident (TSR or popup) programs you have, how large a disk cache is installed or whatever other memory-consuming options you have installed. Q. Why are there only about 100 printers listed? Mine isn't. A. The printers listed are those that contain basic command sets that enable the programs basic printer support. You shoud choose the printer closest to the one you have. As an example, if you have a Panasonic printer, the Panasonic K-XP1091 choice will most likely work. If you have a Panasonic 1124, it runs in a default Epson LQ mode, and the Epson LQ choice would be right. If you have a Hewlitt Packard Laserjet+, II, III, IIP or IIIP, the Laserjet +/II/III choice will work. Most newer printers have emulation mode that make them operate as Epsons if they are dot matrix and as Laserjet IIs if they are laser printers. This is much better standardization than used to exist, and if your printer will emulate and Epson FX or LQ or a Laserjet II, you can be guaranteed the program will work right. Many older printers are included in the list because their commands were not standardized and they rarely had emulation modes. They are included because there are a lot of them still in use. Remember that the program does not provide support for all the fonts and features your printer may offer. If you want to use these features, simply output your text to file and use your wordprocessor to add the enhancements. Q. This program doesn't work right on my good old AMSTRAD/TANDY/AT&T/etc. A. The program requires a high degree of IBM compatibility for video display because it writes directly to the screen. The program supports all IBM video modes, but some older, non-IBM equipment did not handle direct screen writes in an IBM manner. If you have problems, call the support number. In general, if you can run newer software satisfactorily without install special video drivers, DAILY CALENDAR should run as well. PROBLEMS: Unexplained errors - "cannot open file xxx", "out of environment". Check your config.sys file for a line that says files=75 and check your autoexec.bat file for a line that says SET CLIPPER=//F75. Not enough memory error - The actual load size of the program is 328K. The program has been tested and runs on 512K - 640K machines running under DOS 3.X, 4.01 and 5.0. If you see this error, check to see how many terminate and stay resident (TSR) programs are loaded. If you have a number of them, you may not have 415K of free memory. Reduce the number of TSRs and try again. If this fails, call 619-435-2687 with the following information - 35 - in hand: machine type, total RAM, TSRs in use, DOS version. Crashes - If the program crashes, look for a message at the top line of the screen or if you are thrown out to DOS, look for a message above the DOS prompt. Write down any messages you see and call the support number or the Bulletin Board. You may also see a screen like the one below. If this happens, try to PrtScr the screen or write down the information. Then call the support number. Printers - The printer support is not intended to take advantage of every font and feature your printer has, but is to enable you to produce basic printed output from the program. If you need fancy features, output to a text file and use your word processor to add the fine touches. The printer database does not include every printer ever made, but has enough choices to make it unlikely that your printer will not work. Port conflicts, COM3 and COM4 problems - The Daily Calendar writes to COM ports through DOS BIOS services. If you install your printer and your modem both as the same COM port, you will have problems and probably bizarre results. If you have COM3 and COM4 available in an add-on board or directly by setting switches or jumpers on your modem to COM3 or COM4, DOS will probably not recognize the additional ports unless you run a separate utility program or initialize the ports from the port test function. (DOS only support COM1 and COM2. COM3 and COM4 support involve a little trickery.) There are a number of utilities that enable DOS to recognize COM3 and COM4. In addition, the port test function allows you to initialize COM3 and/or COM4 before testing. If you have problems, call the support number (619-435-2687) and we will try to help. DIALING TROUBLE-SHOOTING: Problem: Dialing function does not work. Solution: If you are using a version of DAILY CALENDAR earlier than Version 5.3, call the support number and we will send you the new version. Version 3.2B and later versions have enhanced modem and port checking. Modems are anything but standard and the following are the most typical problems encountered: Port checking has been disabled. Press Alt-Q to turn it on. The hot key to disable/enable port checking was included for laptop users who did not want errors when the program tried to check non-existent printers and modems. When you press Alt-Q, you will see a message telling you whether port checking is ENABLED or DISABLED. It needs to be ENABLED for dialing to work. The modem set-up string is not correct. In the configuration, you need to specify three strings to be sent to your modem. The first is the modem reset command (ATZ) for Hayes-compatible modems. The second is the modem dialing command, ATDT for touch-tone lines and ATDP for pulse-only lines. The third is the modem initialization string. This should be in your modem manual. If in doubt, try the program with the default commands given at the time of - 36 - installation. These are generic Hayes AT command set strings and will work with 90% of modems. On some modems, you may need to add &F &C1 &D1 to the beginning of the set-up string. The modem command delay is too short. Some modems require as much as three seconds to process commands. You can set the modem command delay in the configuration. The default value should be adequate for most modems. The wrong communications port is selected. In the configuration, you need to specify what COM port your modem is connected to, and this is usually COM1 or COM2. For many internal modems, it is COM3, and this is a special case. For internal modems configured as COM3, run the port test option from the "Other" option of the main menu. For COM ports above COM2, you will have the option to test or to initialize and test. Try just testing first. If this does not work, try initializing and testing. If you install your modem as COM3-COM8, the program will automatically initialize the port when you start the program. The problems with dialing lie with DOS and modems, not the DAILY CALENDAR program, which was written to dial by using the simplest DOS calls to dial out, specifically to avoid as many modem problems as possible. If all else fails, call the support number and we will help you. In the most extreme cases, we have had to read the modem manual over the phone to find the right commands, but we have never failed to put the dialing feature into operation. Modems are anything but standard and we are happy to help you get yours working. KEY COMMANDS: These commands work anywhere within the program: F1 - Calls help, which is available at many points. Shift F1 - Brings documentation up on screen. Ctrl F1 - Memory check if you think you have memory problems. Alt F3 - Simple calculator. Alt L - Advanced LaserJet II/III control. Alt T - Pop up to do list. Ctrl Q - Toggles port checking. If you do not want the printer or modem ports checked and initialized, press Ctrl Q. You will see a message that port checking is disabled. To enable checking, press Ctrl Q again. You will see a message that port checking is ENABLED and the program will then initialize your printer. - 37 - Ctrl S - Saves a screen to a file. You are asked for a filename and the last filename you used this session is remembered. If you use the same filename or choose an existing filename, the screen will be appended to the end of the file. DATABASE BACKUP STRATEGY: Backup Databases: Daily Calendar assumes you rely on your data. You have a choice in configuration to set a backup interval and the more you rely on the program, the shorter the interval should be. The time to backup databases is usually only twenty to thirty seconds, but with large databases and/or slow machines (less than 386SX), this time may increase to one or two minutes. Whatever the time, it pays to set a backup interval that is short. For most users, three or four days is adequate, but if you live and die by this program, set the interval to one day. The backup routine creates copies of you calendar, primary name and address and to do database. Each database consists of two files, a DBF file and a DBT file. The DBF file hold the record information and the DBT file holds text you have entered. Both files are required for the program to work. The calendar database consists of DAY.DBF and DAY.DBT, and their backups are DAYBAK.DBF and DAYBAK.DBT. The primary name and address database consists of REDBOOK.DBF and REDBOOK.DBT, and their backups are REDBAK.DBF and REDBAK.DBT. The to do database consists of TODO.DBF and TODO.DBT, and their backups are TODOBAK.DBF and TODOBAK.DBT. The backup process also helps compress databases by rewriting databases and recreating index files. Restoring Corrupted Databases: Database corruption can be caused by turning off the machine while the program is running or by hard disk errors. Other causes are unlikely. If you have a corrupted file, you will be exited to DOS. To restore from backups, delete the database in question (DAY.DBF/DAY.DBT, REDBOOK.DBF/REDBOOK.DBT, TODO.DBF/TODO.DBT) and start the program over. The program will detect the missing database and ask if you want to restore it from the backup. Remember that the backup contains only the information present when the last backup was made, and if you have a long backup interval, you will be missing your most recent data. - 38 - Every time the program makes backup databases you will see the following message: ┌───────────────────────────────────────────────────────────────────────────┐ │ The backup database created are: Calendar database - DAYBAK.DBF │ │ and DAYBAK.DBT, Names and address database - REDBAK.DBF and REDBAK.DBT │ │ To do database - TODOBAK.DBF and TODOBAK.DBT. If you ever have a database │ │ corruption error in any of these databases, go to DOS, delete the │ │ corrupted files (DAY.DBF and DAY.DBT, or REDBOOK.DBF and REDBOOK.DBT, │ │ or TODO.DBF and TODO.DBT) and run Daily Calendar. You will be asked │ │ if you want to restore from the backup. This will restore your data │ │ as it existed on the date of your last backup. │ │ │ │ Press a key... │ └───────────────────────────────────────────────────────────────────────────┘ TRADEMARK ACKNOWLEDGMENTS: Trademark and corporate names are used in this documentation and these are the property of the respective corporations. - 39 - ADDENDUM: New features with Version 5.3: Registration: Daily Calendar now displays UNREGISTERED EVALUATION COPY on unregistered copies. This has become necessary because a large number of users who bought disks from software distribution services thought they had registered the program. When you register, you will receive a registration code that will write your name into the program. The new registration policy is that a one-time registration covers all future upgrades to Daily Calendar. Upgrades may be obtained from the Daily Calendar BBS at (619)-435-0036, from other bulletin boards carrying Daily Calendar or from software distribution services. Backup Databases: Version 5.3 now backs up all databases to the BAK subdirectory of the Daily Calendar directory. Backups are made automatically at the interval specied in configuration or are made on demand by selecting the Backup Databases option from Other on the main menu. To Do Database: A filter can now be set on the to do databases based on whether the item is completed or not (DONE=Yes or DONE=No). Programming: Version 5.3 was written and compiled with Clipper 5.2b and many sections of the program were rewritten to improve speed and to conform with new Clipper standards. - 40 - Version 5.3 - July, 1993 REGISTRATION FORM: Daily Calendar Elizabeth Copper 227 F Avenue Coronado, CA 92118 Bulletin Board (619)-435-0036 Voice Message (619)-435-2687 TO REGISTER: Print this form, complete it and send it with $40 to the address above. PLEASE MAKE THE CHECK PAYABLE TO ELIZABETH COPPER. Please use this for or be sure to let us know you are registering Version 5.3. Name (as you wish it to appear in registration)______________________ _____________________________________________________________________ Address______________________________________________________________ City______________________________________State_____Zip______________ Phone________________ Is 3½" HD disk size OK? ___Yes ___No, send 5¼" HD Registered users will receive the latest version of the Daily Calendar, your personal registration code, special registered user access to the Bulletin Board and reduced prices on other Growler Software products. Pricing: Single user..........................................$ 40.00 Single user, government and education................$ 35.00 Multiple copies: 2 - 5 copies......................................$ 35.00 each 6 - 10 copies.....................................$ 30.00 each 11 - 50 copies.....................................$ 25.00 each 51+ copies.........................................$ 20.00 each Government and education multiple copies, 10% off prices above. - 41 -