Thank you for your acquisition of BECKNERVISION VIDEO DATABASE MANAGER. We hope that it will be useful enough to you that you will register with BecknerVision. To register, send $20 to BecknerVision CMR Dept 17 P O Box 1541 Lumberton, NC 28359-1541 Your registration provides for the following: 1. You receive all future updates of the product for a 5-year period. 2. You may participate in the BecknerVision Product Owners special interest group on the BecknerVision Communications BBS. All product updates are available for downloading on this BBS, but the source files are available only to registered users. We ask that all users register, but it is not mandatory. Only if you find the software useful do we ask for your support. Regardless of whether you register or not, you may join BecknerVision Communications by having your communications parameters set to either "8-bit, no parity, 1 stop bit" or "7-bit, even parity, 1 stop bit". Both 300 and 1200 baud are supported. We recommend that you use PROCOMM for your communications, since it allows you to access the full-color menus and the full-screen system in the external programs ("doors"). PROCOMM is available from PC-SIG (disk #499), 1030 East Duane Avenue, suite D, Sunnyvale, CA 94086, or may be downloaded from our BBS. The program ----------- To load the program, enter the command "BVIDEO" at the system prompt. The program will start with the "User Supported" message. Press (or wait 60 seconds) to get to the main screen. The index files do not come with the program and are dynamically created when you first load the program. The main screen will appear and will look as follows: BecknerVision Video Database Manager Copyright (c)1987 John Wm Beckner . P O Box 1541 . Lumberton NC 28359-1541 ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ³ÉÍÍÍÍÍÍÍÍÍÍ»ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»³ ³º OPTIONS ºº VIDEO INFORMATION ºº MEMO º³ ³ºÄÄÄÄÄÄÄÄÄĺºÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄĺºÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄĺ³ ³ºSequence ºº Tape # ........... 1 ººExcellent film º³ ³ºGet video ºº Title ............ Rock & Roll - A Trilog ººdepicting the º³ ³ºAdd video ºº Start memory # ... 0 ººhistory of Rock º³ ³ºEdit curr ºº End memory # ..... 0 ºº& Roll. Was a º³ ³ºDelete ºº Machine # ........ 1 ºº6-part º³ ³º+/next ºº Category # ....... 1 ººmini-series. º³ ³º-/prior ºº Rating ........... G ººThe first º³ ³ºFilter ºº Date entered ..... 02/12/87 ººrecording made º³ ³ºÄÄÄÄÄÄÄÄÄĺº Tape type ........ B ººfrom TV. Uses º³ ³ºReports ºº Search parameters: Elvis, Buddy Holly, Li ººthe entire L-830 º³ ³ºMaintenancºº ººtape. º³ ³ºÄÄÄÄÄÄÄÄÄĺº ºº º³ ³ºQuit ºº ºº º³ ³ÈÍÍÍÍÍÍÍÍÍͼÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ³ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ SEQUENCE Tape # FILTER OFF Record # 1 Naturally, we already have tapes in our database, so the above is the first tape in "Tape #" sequence with no filter established (don't worry, "filter" and "sequence" will be discussed in detail later). First let's see what you see in the tape window: ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º VIDEO INFORMATION º ºÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄĺ (1) º Tape # ........... 1 º (2) º Title ............ Rock & Roll - A Trilog º (3) º Start memory # ... 0 º (4) º End memory # ..... 0 º (5) º Machine # ........ 1 º (6) º Category # ....... 1 º (7) º Rating ........... G º (8) º Date entered ..... 02/12/87 º (9) º Tape type ........ B º (10) º Search parameters: Elvis, Buddy Holly, Li º º º º º º º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ (1) The tape number is the number you assign to your videos. It may be any number in the range 1-9999. So you can have up to 9,999 tapes in your library! (If anyone has more, they can afford to send me the $20 registration fee telling me the maximum number of tapes they have, and I will increase it!) (2) The title is a 40-character field with the film title normally entered here. Though the field holds 40 characters, only 22 characters are displayed. If you edit this field, and the title is more than 40 characters, it will scroll horizontally (don't worry, its all there for the reports, though). You should keep your film names in alphabetical order, so that a film entitled "The Attack of the Mermaids" would be entered as "Attack of the Mermaids, The". On your reports, the computer will place it alphabetically, but will put the word "The" back in front. (3) Start memory is the memory number on your tape where the film starts. If you have more than one machine, you should use only one machine for memory numbers, or if you have a beta and a VHS, use the VHS memory number for VHS tapes and the beta memory number for the beta taps. (4) End memory is the next available memory number after this video where something can be (or has been) recorded. (5) Machine number indicates which machine you are using for the memory numbers above. For example, if you have 3 beta machines and 1 VHS machine, you might have them numbered (1) Beta #1, (2) Beta #2, (3) Beta #3 and (4) VHS. Since memory numbers differ on different machines, it is important to know which machine's numbers you used. If you only have 1 machine, enter a <1> here. (6) Categories are user-defined. Only 2 come defined on your system, COMEDY and DRAMA. You may change these and add to the file using the MAINTENANCE option. (7) Rating. This is user-defined, but should be uniform. We use the following: - "G"

- "PG" <3> - "PG13" - "R" - "X" (8) Date entered. The system places the current system date in this field when you add a new video. (9) Tape type. Another user-defined field, but we use the following: - VHS SLP ("Super-long play") - VHS LP ("Long play") - VHS SP ("Standard play") - Beta III <2> - Beta II (10) Search parameters are user-defined. Whatever you place in here will be the parameter checked (along with the title) when you choose to get a video by string (see the GET option). I usually place actors and actresses names, directors, producers, or anything that I will want to search for later and have it find this particular video. The options ----------- The option window is shown below: ÉÍÍÍÍÍÍÍÍÍÍ» º OPTIONS º ºÄÄÄÄÄÄÄÄÄĺ (1) ºSequence º (2) ºGet video º (3) ºAdd video º (4) ºEdit curr º (5) ºDelete º (6) º+/next º (7) º-/prior º (8) ºFilter º ºÄÄÄÄÄÄÄÄÄĺ (9) ºReports º (10) ºMaintenancº ºÄÄÄÄÄÄÄÄÄĺ (11) ºQuit º ÈÍÍÍÍÍÍÍÍÍͼ The options are chosen one of 2 ways. You may use you arrow keys to move from one option to the next, and press to choose the option, or you may simply press the first letter of the option to have it executed. The options are described below: (1) SEQUENCE. When you scan through the video records one at a time using the <+> and <-> options, they are accessed in a particular "sequence". The default sequence is "Tape #", so that as you scan through the videos you are scanning in order of their tape numbers. This option changes the current sequence based on the following chart: ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ³ Tape # ³ ÀÄÄÄÄÄÄÂÄÄÄÄÄÄÄÙ ³ ÚÄÄÄÄÄÄÁÄÄÄÄÄÄÄ¿ ³ Rating+Title ³ ÀÄÄÄÄÄÄÂÄÄÄÄÄÄÄÙ ³ ÚÄÄÄÄÄÄÁÄÄÄÄÄÄÄ¿ ³Category+Title³ ÀÄÄÄÄÄÄÂÄÄÄÄÄÄÄÙ ³ ÚÄÄÄÄÄÄÁÄÄÄÄÄÄÄ¿ ³ Title ³ ÀÄÄÄÄÄÄÂÄÄÄÄÄÄÄÙ ³ ÚÄÄÄÄÄÄÁÄÄÄÄÄÄÄ¿ ³ Record # ³ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ After record number, it returns to Tape # sequence. (2) GET VIDEO. The following menu window will appear: ÚÄÄÄÄÄÄÄ¿ ÉÍͳFIND BY³ÍÍÍÍ» º ÀÄÄÄÄÄÄÄÙ º (A) ºA. Record # º (B) ºB. Tape # º (C) ºC. Title º (D) ºD. String º (E) ºE. 1st rec º (F) ºF. Last rec º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ (A) RECORD #. The system will ask for the record number to search for. The system will not allow you to enter an invalid number. The default is the current record. (B) TAPE #. The system will search for the tape number you enter. If it isn't found, then the current record does not change. If found, the first video with that tape # will be displayed. (C) TITLE. Enter the exact title you want, or the left-most characters of it. For example, if you enter "Mermaids" then it can find "Mermaids of the Deep". Note that this option is "case- sensitive", meaning upper and lower-case characters are considered separate characters. If you had enter "MERMAIDS", it would NOT have found "Mermaids of the Deep". (D) STRING. You may enter up to 254 characters (this is another "horizontal-scroll" field) with which to search for. This option is NOT case-sensitive (as a matter of fact, you couldn't enter lower-case characters if you tried!). If you want to find the first video with John Doe, famous actor, and you had entered his name into the SEARCH field when you entered the video information, OR his name is in the title, then it will be found. (E) 1ST REC. This will find the first record in the database which matches the current filter and sequence (refer to the SEQUENCE and FILTER options for more information). (F) LAST REC. Same as (E), but will find the last record. (3) ADD VIDEO. This options lets you add a new video to your library. The fields described earlier are entered (except for DATE ENTERED, which is assigned by the system), then you are placed in the memo field. Refer to the MEMO section for more information. (4) EDIT CURR. Same as (3), except it lets you edit the current video instead of adding a new one. (5) DELETE. This option lets you delete the current video. Actually, it marks the current video for later deletion through the maintenance option OPTIMIZE SYSTEM. (6) +/NEXT. Gets the next record based on the sequence and filter. (7) -/PRIOR. Gets the prior record based on the sequence and filter. (8) FILTER. Like a coffee filter, this video filter lets you remove videos you don't want. Actually, nothing is removed from the system, it is merely screened out. For example, if you were interested in scanning through your videos with a "G" rating, you could set the filter to "RATING='G'". A filter is made up of an expression which must evaluate to true or false for each record. The following fieldnames may be used in filters: TAPE_NO numeric TITLE character START_NO numeric END_NO numeric MACHINE numeric CATEGORY numeric RATING character DATE date TYPE character SEARCH character The parameters are entered exactly like a dBase (a trademark of Ashton- Tate) FOR clause (which is what they become). If you aren't familiar with dBase, then you may acquire the book. This program was written in Clipper (a trademark of Nantucket). In any case, here are some practical examples for you: TAPE_NO >= 1 .AND. TAPE_NO <= 99 this would limit the scan to tapes number 1-99 RATING = "G" limit search to ratings of "G" DATE >= CTOD("01/01/87") limit to date entered January 1, 1987 or later RATING $ 'P3' limit to rating of "P" or "3" TYPE = "B" limit to Beta III type tapes RATING = "X" .AND. TYPE = "B" limit to Beta III and X-rated Valid relational operators are: = is equal to <> or != is not equal to > is greater than < is less than >= is greater than or equal to <= is less than or equal to $ is a substring of Functions may also be used in filters expressions; Including RECNO(), which is the record number of the video record. The next time you use this option, the filter will be disabled, and will show "FILTER OFF" on the status line, but the current record will not change. (9) REPORTS. The following menu window will appear: ÚÄÄÄÄÄÄÄ¿ ÉÍÍÍÍÍÍÍÍͳREPORTS³ÍÍÍÍÍÍÍÍÍÍÍÍ» º ÀÄÄÄÄÄÄÄÙ º (A) ºA. List Tapes by Category º (B) ºB. List Tapes by Rating º (C) ºC. List Tapes Alphabetically º (D) ºD. List Categories º (E) ºE. List Machine Types º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ The appropriate report will be printed when you choose it. The first 3 list the tapes. Report (A) subtitles the report by category while report (B) subtitles by rating. Report (C) prints the tapes alphabetically. (10) MAINTENANCE. The following menu window will appear: ÚÄÄÄÄÄÄÄÄÄÄÄ¿ ÉÍÍÍÍÍÍͳMAINTENANCE³ÍÍÍÍÍÍÍÍÍÍ» º ÀÄÄÄÄÄÄÄÄÄÄÄÙ º (A) ºA. Modify system file º (B) ºB. Optimize system º (C) ºC. Modify category file º (D) ºD. Modify VCR machine file º º º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ (A) MODIFY SYSTEM FILE. Lets you choose whether the program will output color or monochrome. (B) OPTIMIZE SYSTEM. Actually removes from the tape file the tapes you previously marked for deletion using the DELETE option. (C) MODIFY CATEGORY FILE. The first category is displayed on the bottom line of the screen, and the following menu window appears: ÚÄÄÄÄÄÄÄ¿ ÉÍÍÍͳOPTIONS³ÍÍÍÍÍÍÍ» º ÀÄÄÄÄÄÄÄÙ º ºGet category º º+/next category º º-/prior category º ºAdd new category º ºEdit category º ºQuit to main menu º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ These options are just about the same as for the tape file. (D) MODIFY VCR MACHINE FILE. The first machine is displayed. The options are the same as (C). (11) This quits the program and returns you to DOS. MEMO FIELD ---------- The memo field allows you to enter up to 5000 characters of description concerning each video. It is styled after word-processors and features automatic word-wrap. The following keys are available while in the MEMO field: or *Move up one line or *Move down one line or *Move left one character or *Move right one character or *Move left one word or *Move right one word *Move to beginning of current line *Move to end of current line Move to beginning of memo Move to end of memo Move up one window Move down one window Move to beginning of current window Move to end of current window *Save memo and done Abort edit and done *Delete the current line *Delete word right or *Delete current character or *Delete character to the left or *Toggle insert mode on or off * These keys are also used in regular fields. If you have any problems or questions, let us know! BecknerVision Dept 17 P O Box 1541 Lumberton, NC 28359-1541 BBS phone #1-919-739-1063 ENJOY!