Category : Databases and related files
Archive   : SPLUS300.ZIP
Filename : CH7.DBF

 
Output of file : CH7.DBF contained in archive : SPLUS300.ZIP
X
—aRTEXT1C
ˆqOTEST1N\ˆq
@2 2 @6 6 In this chapter, we will examine 2 of the 6 report/display options 0 available to you in the Appointments menu. As part of the exercise 0 you'll create a report for the 11 appointments that were set up in 0 the Test Data from the activities file. 0 - 0 In the next chapter, you'll create 2 appointments for truck NBF199 0 and view the new reports. 0 0 0 ÄÄÄÄÄÄÄÄÄÄÄÄ Maintenance and Service Call Activity Tracking System ÄÄÄÄÄÄÄÄÄÄÄÄ 0 0 ACS 0 Main Program Menu 0 0 ÚÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ 0 ³ 03/11/87 ³ ³ Please Choose One ³ ³ 17:01:27 ³ 0 ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÙ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ 0 0 0 1) Master file options 0 0 0 2) Other Options 0 0 0 3) Select Category 0 0 0 X) Exit System 0 0 Category of Maintenance: ALL 0 @27 27 1 0 At the Main Program Menu, enter a '1'. 0 0 0 Dallas Truck Maintenance Tracking System 0 ÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜ 0 ÕÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ͸ 0 ³ Master File Menu and Other Primary Functions ³ 0 ÃÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ´ 0 ³ ³ 0 ³ A to ADD data--Master file ³ 0 ³ G to GET/EDIT data--Master file ³ 0 ³ 1 for Activity file. ³ 0 ³ 2 for Search through Service Call data ³ 0 ³ 3 for Billings reports. ³ 0 ³ 4 for Appointments ³ 0 ³ 5 for Service Call and Activity reports ³ 0 ³ 6 for automatically creating future Activities. ³ 0 ³ H for Help. ³ 0 ³ ³ 0 ³ R to RETURN to prior menu. ³ 0 ³ ³ 0 ÔÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ; 0 0 Category of Maintenance (defaults to ALL): ALL 0 @27 27 4 0 To branch off to the Appointments menu, enter a '4'. 0 0 0 ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ Dallas Truck Maintenance Tracking System ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ 0 0 Appointments Menu 0 ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ 0 ³ Please Choose One ³ 0 ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ 0 1) List out all prior Appointments 0 (Occurring prior to today) 0 0 2) Produce today's Appointments 0 0 3) Print all future Appointments, excluding today's 0 0 4) Print all future Appointments, including today's 0 0 5) Display a graphics image of any 14 day period of Appointments 0 6) Select your start/stop date for Appointments, then print out 0 H) Help Screen for Appointments Menu 0 0 0 R) Return to prior menu 0 @27 27 6 0 This is the Appointments menu. In it, you have 6 report/display options. 0 Reports 1 through 4 could be viewed as 'canned' or predefined reports. 0 The Help option ('H') gives you a definition of every option. 0 When you are running the actual program, you can select option 'H' 0 anytime to identify the options or to refresh your memory. 0 For now, we want a report for the appointments scheduled on or 0 after Jan 2, 1986, in the Test Data. Enter a '6'. 0 0 @6 6 Notes on viewing reports 0 - 0 Throughout this program, you'll observe that all screens are self 0 contained. When you are looking at a menu, you see the complete menu 0 within the 24 lines of your monitor. Any time you enter a key to 0 indicate your selection in a menu, you then branch to a new menu. 0 - 0 In this program, however, there are two exceptions to this rule of 0 everything fitting into one screen. Whenever you print a report, the 0 program asks you if you wish to save that report to a text file. If 0 you elect to save it, you will then be asked if you wish to view it 0 then. If you answer yes, you will then see on the screen the top 24 0 lines of your report. Since each page of the report has 66 lines and 0 you may have many pages to any one report, the program allows you to 0 'scroll' through the report 24 lines at a time. To do this, use the 0 'Pg Up' and 'Pg Dn' keys on your keyboard (located under '9' and '3'). 0 When you are finished scrolling, enter Escape to return to the prior menu. 0 0 @6 6 - 0 The second exception is the Help screen option contained in most 0 menus. When you select this, you must also 'scroll' through the Help 0 file, using 'Pg Up' and 'Pg Dn' keys. When finished reading the Help 0 file, enter Escape to return to the prior menu. 0 - 0 For now, we'll select all appointments in the Test Data that occurred 0 on or after Jan 2, 1986 0 0 ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ Dallas Truck Maintenance Tracking System ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ 0 INPUT SCREEN FOR BEGINNING AND ENDING DATES 0 0 ENTER THE STARTING DATE OF YOUR APPOINTMENT 0 0 01/02/1901 0 0 0 0 0 0 0 0 ENTER THE ENDING DATE OF YOUR DESIRED APPOINTMENT 0 0 12/30/2999 0 0 @11 11 At this screen, you can select the start and stop dates for your 0 report. The dates default to 1901 to 2999. Let's enter the start 0 data of Jan 2, 1986. 0 0 @30 30 1 0 6 0 20 0 11 0 01/02/1986 0 @2 2 @6 6 At this point, the program would have prompted us either 0 to send the report to the printer or to your screen. 0 Let's say that we had selected a screen display. 0 0 0 Page No. 1 Dallas Truck Maintenance Tracking System 0 Appointments Report, Category = ALL 0 01/02/1986 TO 12/30/2999 0 0 0 ** DATE : 01/02/1986 0 0 January 2, STW366, 55823WSE90321, Mack Truck, #R-685, Order fan belts for 0 this truck. Check with parts distributor tomorrow. 0 0 ** DATE : 01/03/1986 0 0 January 3, STW366, 55823WSE90321, Mack Truck, #R-685, Schedule this truck 0 for state inspection in 2 days. 0 0 January 3, WRX332, 3356UST217431, Peterbilt, #362, Schedule yearly 0 preventive maintenance. 0 0 ** DATE : 01/04/1986 0 ACS HELP Keys: PgUp PgDn Arrows ESC=exit 0 @17 17 3 0 This is screen 1. It takes 3 screens to display the 2 page report. 0 Observe that the first activity has a date of 01/02/1986. 0 Each activity being printed out also has all 3 IDs, as well as 0 the comment entered into the activity file for that activity. 0 Note that Jan 2, 1986 has one activity. In the next chapter, 0 we'll change this. 0 When you are ready to 'scroll' to the next page, enter 'PgDn' 0 on your numeric keypad 0 0 0 January 4, UTR399, GR45339264T50, Kenworth K100, Schedule driver to drop off 0 truck in 3 days for service. 0 0 ** DATE : 01/06/1986 0 0 January 6, UTR399, GR45339264T50, Kenworth K100, Perform the state vehicle 0 inspection in 5 days. 0 0 ** DATE : 01/08/1986 0 January 8, WRX332, 3356UST217431, Peterbilt, #362, Contact parts distributor 0 in one week for new tires for this truck. 0 0 ** DATE : 01/09/1986 0 January 9, WRX332, 3356UST217431, Peterbilt, #362, Perform state inspection 0 on vehicle in 1 week. 0 0 ** DATE : 01/10/1986 0 0 January 10, STW366, 55823WSE90321, Mack Truck, #R-685, Check toe-in, toe-out 0 in 9 days. 0 ACS HELP Keys: PgUp PgDn Arrows ESC=exit 0 0 @17 17 3 0 This is screen 2. 0 When you are ready to 'scroll' to the next page, enter 'PgDn' 0 on your numeric keypad 0 0 0 ** DATE : 01/11/1986 0 0 January 11, UTR399, GR45339264T50, Kenworth K100, Schedule yearly preventive 0 maintenance in 11 days. 0 0 0 0 0 0 0 ACS HELP *** End-of-file *** Keys: PgUp PgDn Arrows ESC=exit 0 0 @7 7 This is screen 3. 0 When you are ready to return to the prior menu, enter Escape. 0 0 0 ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ Dallas Truck Maintenance Tracking System ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ 0 0 Appointments Menu 0 ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ 0 ³ Please Choose One ³ 0 ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ 0 1) List out all prior Appointments 0 (Occurring prior to today) 0 0 2) Produce today's Appointments 0 0 3) Print all future Appointments, excluding today's 0 0 4) Print all future Appointments, including today's 0 0 5) Display a graphics image of any 14 day period of Appointments 0 6) Select your start/stop date for Appointments, then print out 0 H) Help Screen for Appointments Menu 0 0 0 R) Return to prior menu 0 @27 27 5 0 Now that we've finished reviewing the report created by the 0 Test Data, let's look at a graphics image for that same data. 0 Enter '5'. 0 0 ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ Dallas Truck Maintenance Tracking System ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ 0 Enter the starting date for your Appointment 0 To use as the starting point for this Graphics chart. 0 0 03/11/1987 0 0 0 Enter the scale you wish to use for the Leftmost vertical axis. 0 It defaults to 1, but you can use a decimal (such as .75) if 0 you wish to zoom in on your Appointments. 0 To zoom backwards, use a number larger than 1.0, such as 2.0 or 2.5. 0 0 Scale: 1.00 0 0 0 @11 11 At this menu, enter a start date of '01/02/1986' 0 0 @30 30 1 0 5 0 5 0 11 0 01/02/1986 0 @2 2 0 0 Ã17 0 Ã16 0 Ã15 0 Ã14 0 Ã13 0 Ã12 0 Ã11 0 Ã10 0 à 9 0 à 8 0 à 7 0 à 6 0 à 5 0 à 4 0 à 3 0 à 2 ÉÍÍ» 0 à 1 ÉÍÍ» º º ÉÍÍ» ÉÍÍ» ÉÍÍ» ÉÍÍ» ÉÍÍ» ÉÍÍ» 0 à ÈÍͼ ÈÍͼ ÈÍͼ ÍÍÍ ÈÍͼ ÍÍÍ ÈÍͼ ÈÍͼ ÈÍͼ ÈÍͼ ÍÍÍ ÍÍÍ ÍÍÍ ÍÍÍ 0 Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed 0 Appointments for 14 days 0 Starting from 01/02/1986, Thursday, January 2 0 [Leftmost column is # of Appointments] 0 Dallas Truck Maintenance Tracking System 0 @7 7 This is a graphical representation of all appointments that had been 0 scheduled starting Jan 2, 1986. The leftmost column is the number 0 of appointments. See that the leftmost 'Thursday' shows one appointment. 0 From this menu, you can select any two week period, 0 past or future, to review your work load. Also, this analysis 0 is presented to you automatically everytime you invoke this program 0 if you have at least one appointment for today. 0 0 0 ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ Dallas Truck Maintenance Tracking System ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ 0 0 Appointments Menu 0 ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ 0 ³ Please Choose One ³ 0 ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ 0 1) List out all prior Appointments 0 (Occurring prior to today) 0 0 2) Produce today's Appointments 0 0 3) Print all future Appointments, excluding today's 0 0 4) Print all future Appointments, including today's 0 0 5) Display a graphics image of any 14 day period of Appointments 0 6) Select your start/stop date for Appointments, then print out 0 H) Help Screen for Appointments Menu 0 0 0 R) Return to prior menu 0 @27 27 R 0 We're now back to the Appointments Menu. Enter an 'R' to return. 0 0 0 Dallas Truck Maintenance Tracking System 0 ÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜ 0 ÕÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ͸ 0 ³ Master File Menu and Other Primary Functions ³ 0 ÃÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ´ 0 ³ ³ 0 ³ A to ADD data--Master file ³ 0 ³ G to GET/EDIT data--Master file ³ 0 ³ 1 for Activity file. ³ 0 ³ 2 for Search through Service Call data ³ 0 ³ 3 for Billings reports. ³ 0 ³ 4 for Appointments ³ 0 ³ 5 for Service Call and Activity reports ³ 0 ³ 6 for automatically creating future Activities. ³ 0 ³ H for Help. ³ 0 ³ ³ 0 ³ R to RETURN to prior menu. ³ 0 ³ ³ 0 ÔÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ; 0 0 Category of Maintenance (defaults to ALL): ALL 0 @27 27 R 0 From this Master File Menu, enter an 'R' to return to the Main Program Menu. 0 0 0 ÄÄÄÄÄÄÄÄÄÄÄÄ Maintenance and Service Call Activity Tracking System ÄÄÄÄÄÄÄÄÄÄÄÄ 0 0 ACS 0 Main Program Menu 0 0 ÚÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ 0 ³ 03/11/87 ³ ³ Please Choose One ³ ³ 17:04:19 ³ 0 ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÙ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ 0 0 0 1) Master file options 0 0 0 2) Other Options 0 0 0 3) Select Category 0 0 0 X) Exit System 0 0 Category of Maintenance: ALL 0 @27 27 X 0 Enter an 'X' to exit the program 0 0 @6 6 This concludes Chapter 7. 0 0 0 @5 5 0 0 @5 5

  3 Responses to “Category : Databases and related files
Archive   : SPLUS300.ZIP
Filename : CH7.DBF

  1. Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!

  2. This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.

  3. But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/