EnterApp

Web Services Council

Enterprise Applications
User Guide

HPLIST

Introduction to HPLIST

Functions

One of the most useful packages available to HP clients is HPList. This software package provides a convenient way to create and maintain a simple data file.

  1. Allows creation of a 'card file' type data file.
  2. Allows information to be entered via screens that make it easy to change individual pieces (fields) of information directly.
  3. Easily inserts or deletes records and reorders the sequence of the information.
  4. Searches for records which meet criteria specified, and creates a separate file of qualifying records for further processing by other programs.
  5. Allows adjustment of the format of the file, including changing field sizes, adding new fields, and deleting old fields whenever necessary.
  6. Prints file information either horizontally, vertically, or in label format.
  7. Summarizes numeric fields with the ability to provide averages, totals, and minimum and maximum values.
  8. Can have a Quiz dictionary written for it so that it can be accessed by Quiz programs to report its data.

Restrictions

  1. A maximum of 255 field entries. Each field can be up to 992 characters in length. However, the maximum length of a record is 3,000 characters.
  2. Only two data types exist - Text (T) and Numeric (N).
  3. Does not edit data entries. For example, the code for a field labeled GENDER might be M or F. However, HPList will not check to see if the value you enter is M or F.
  4. All numbers are entered left justified, so leading zeros must be entered if data is to line up on the screen.
  5. A maximum of nine fields can be sorted simultaneously.
  6. A terminal that supports block mode, or an IBM-Compatible PC or Macintosh running Reflection software must be used. Contact your computer administrative support analyst if uncertain whether the terminal configuration meet the requirements.

Using HPLIST

Getting Started

  1. Log onto the HP3000 HP1 system in the normal fashion.
  2. Choose one of the following from the select menu.
    U HPLIST HPList - normal printouts.
    LABELS HPList Labels - for labels.

    Use HPList Labels when printing labels. This defers output so that labels may be placed on the printer before printing. The LABELS command will prompt for the number of copies of each label wanted. (Remember to send an Xpress work order when ordering labels. See Xpress Work Orders elsewhere in this guide.)

    There are a series of boxes at the bottom of the screen. They correspond to the function keys on the terminal (these keys are across the top or at the upper left side of the keyboard and are labeled F1, F2...etc.). Simply press the key that corresponds to the desired option.

  3. The first menu is the MAIN menu and it allows six options.

    F1-Introduction
    This is a help option that teaches the client about the system. Sample jobs are provided here for use in building files.

    F2-Create List
    Use this option when setting up a new list.

    F3-Directory
    Will list all of the HPList files in your group.

    F4-Copy/CHG
    Allows changes to the format of an existing list or copy an old format in order to create a new list.

    F5-Work on List
    From here the client can list, modify, sort, search for special fields, summarize numeric data, or print out the file. Before selecting this option, enter the name of an existing list file in the field provided.

    F6-Refresh
    Resets screen to the previous setting. Sometimes when a "goof up" in a screen is made the client can refresh and start over.

    F7-Help
    Offers a short description of each option on the current menu.

    F8-Exit HPLIST
    Use when the work is completed and leaving HPList.

Creating a New List

  1. From the main menu press F2, Create List, and the Create List menu will appear.
  2. Enter a file name in the appropriate box (up to 8 characters long - must begin with a letter and consist only of letters and numbers).
  3. Press the TAB key to get to the next field. (If the client has passed a field or wants to correct what has been entered, hold down the shift key and simultaneously press the TAB key; the cursor will back up one field).
  4. Enter a field heading. Try to keep headings the same width as the data, to facilitate horizontal printing. However, this is not a restriction and clarity is of primary importance.
  5. Tab to the next field and enter the length (width) of the field just described. (For example name = 30, social security number = 9 or 11) The length should include dashes, periods, slashes, etc., if they are to be entered in the data.
  6. Tab to the entry T/N. It is already set to T, since most of the data entered will be Text rather than Numeric. If this field is to be Text, press TAB again and the cursor will be at the next Field Heading box. If this field is to be numeric, type N.
  7. To define a record with more than 12 fields, press F4, Scroll Forward, after the 12th field and a new screen will appear.
  8. There is a box near the bottom of the screen where a List Description may be entered. This will print as a heading for the listing of the file. To get to this box press the TAB key until the cursor is in the field.
  9. There are seven options for this screen:

    F1-Perform Create
    This option sets up the file and displays a new screen for entering data.

    F2 -Sample List
    Use this option to view some standard lists which can be used for your file format.

    F3-Scroll Backward
    Use this option to view the previous screen (if more than one screen of field headings where entered).

    F4-Scroll Forward
    Use this option if needing to enter more than one screen of field headings (maximum of 255).

    F6-Refresh
    Resets screen to the previous setting; sometimes when a goof is made on a screen, a refresh lets the client start over.

    F7-Help
    This offers a short description of each option on the current menu.

    F8-HPLIST Main
    Return to the main menu.

Entering Data

  1. After creating a new list (F2 -- Create List, F1 -- Perform Create) or choosing to work with an existing list (F5 -- Work on List, F2 -- Display), the DISPLAY screen appears. This screen allows entry of new data and modifying of existing information.
  2. Once the screen is filled while entering new data, press F4, Scroll Forward, and a new, blank screen appears so data entry can continue. Pressing F4 on an existing file will display the next set of records in the file. To scroll backwards, press F3. The client can control the number of records scrolled each time F3 or F4 is pressed by entering the desired number in the field at the top of the screen. For a file with a large number of existing records, Enter the number of the last record in this field and press F4, Scroll Forward, to reach the end of the file.
  3. Follow these steps to insert a new record between two existing entries:
    1. Place the cursor on the record to be moved down to make room for the new record
    2. Press F1, Insert record
    3. Type in the new record
  4. To delete a record, Place the cursor on the desired record and press F2, Delete. HPList prompts again to press F2 again to confirm.
  5. Once finished entering data, return to the main menu by pressing F8, or press F5, Work On List, to print, reorder, summarize, etc. the information in the current list. In either case HPList prompts to keep the file with the same name as the old one. If you do, press the key again. Otherwise, type a new list name in the field provided and press the key again.

Work On List Menu

F1-Other Keys
Gives access to the print, convert, choose display, or change passwords functions. After pressing F1, function keys F2, F3, F4 and F5 will change to the following:

F2-Print
Prints a copy of the list. See F1 below.

F3-Convert
This function is obsolete. (See Converting HPLIST Files in this document.)

F4-Choose Display
Allows the client to select which of all the fields in the record actually appear on the screen.

F5-Change Password
Adds, changes or deletes a list's password.

F2-Display
Press this key if adding, modifying, or simply looking at a list.

F3-Find
Searches the file for records with values matching the selection criteria entered.

F4-Reorder
Allows sorting of the file into a new sequence.

F5-Summarize
Allows computing of an average or total, or to find the largest or smallest value for one or more numeric fields.

Recovery Procedures

If, while running HPList, the (BREAK) key is accidentally pressed or an interruption by a power failure occurs, do the following:

If running HPList and the terminal is inactive for more than one hour (resulting in an automatic logoff), or if the session is lost for any other reason (such as a system failure), do the following:

Printing

Report

Press F2 on the WorkOn List menu to display the print menu. Below is an explanation of the information needed to enter in order to print the list. In addition to the following information, the Print Menu screen also provides a brief description of what is required:

  1. At the top of the screen there is a box that designates Vertical (fields print one on top of the other down the left side of the page) or Horizontal (fields print left to right across the page) printing. When printing in Vertical mode more than one field can be printed on the same line (see Order vs. Sequence in #2 below). Select Vertical when printing labels.
  2. Select the fields to print and the order in which they are to print by entering the order number in the ORDER field. If leaving an order field blank, that field will not be printed UNLESS all ORDER fields are left blank; in this case, all the fields are printed in the order they appear on the screen.

    Order vs. Sequence
    If printing the list vertically, the may assign two or more fields the same order number indicating they are to print on the same line. Then determine in what sequence these fields are to print by entering a sequence number.

  3. A title for the list may be entered in the box at the bottom of the screen.
  4. Press F1, Printer keys. There are four printer options available.

    F1-Local Printer
    Attached to the terminal (slaved printer).

    F2-Line Printer
    The Laser Printer located in the Computer Center.

    F3-Ported Printer
    Connected directly to the HP3000 through a serial port. There are very few of these printers on campus. If uncertain about what printer type you have, call your computer support analyst.

    F4-Page Printer
    The Laser Printer located in the Computer Center.

  5. Select the appropriate printer, and either the Horizontal or Vertical print screen will appear, depending on the selection. Additionally a field at the top of the screen titled Environment File Name may appear; ignore this field; the other fields may be changed as needed. For non-label listings, adjustments are not usually needed. (When printing labels, see PRINTING LABELS later in this chapter).
  6. If selecting Page Printer, Press F1, Perform Print, to send the list on the laser printer. If selecting Local printer, press F1, Serial, to begin printing if the slaved printer is connected serially. Press F4, HPIB, to begin printing if the slaved printer has an HPIB connection. If not sure which connection is available, call your computer support analyst.
  7. Press F8, HPLIST Main, to return to the main menu
  8. Press F8, Exit, to exit Hplist

To get multiple copies of an Hplist file, type the following command before getting into Hplist (not required when printing labels)

:FILE LISTOP;DEV=PP,2,# of copies;CCTL

Labels

Follow these steps to print labels,

  1. Create the file to accommodate label printing. A maximum of four lines will print well on labels. Thirty-two (32) characters is the maximum field (or combined field) width for each label line.
  2. Select U LABELS Hplist labels from the menu, and answer the prompt for the number of copies.
  3. Enter the list file name and press F5, Work On List.
  4. Press F1, Other keys.
  5. Press F2, Print.
  6. Select Vertical print and enter the order of the fields to be printed.
  7. Press F1, Printer keys.
  8. Press F4, Page Printer.
  9. Type:
    'Y' to print labels
    '3' labels across page
    '36' characters from beginning of one label to the next
    '6' lines from the top of one label to the next
  10. Press F1, Perform Print.
  11. Press F8, HPLIST Main, to return to the main menu.
  12. Press F8, Exit, to exit Hplist
  13. Type :SHOWME. Something similar to the following will display:
    USER: #S984,USER.ACCOUNT,GROUP  (NOT IN BREAK)
    RELEASE: B.40.00   MPE/iX HP31900 B.30.45   
    USER VERSION: B.40.00
    CURRENT: THU, MAR 30, 1994, 1:51 PM
    LOGON:   THU, MAR 30, 1994, 1:51 PM
    CPU SECONDS: 3   CONNECT MINUTES: 1
    $STDIN LDEV: 25  $STDLIST LDEV: 25
    
    Write down the number next to the word USER: (in this case, #S984). Include this on an XPRESS work order requesting that the output file be printed on labels.

  14. 14. Create an XPRESS work order (see XPRESS Work Orders elsewhere in this manual).

Converting HPLIST Files

Converting a Standard MPE/iX File

  1. Create a new Hplist file:
    1. Select Hplist from the menu.
    2. Create a new list with field lengths identical to the MPE/iX file. Fields should appear in the same order as they appear in the MPE/iX file. Add one dummy record to the new Hplist file.
    3. Exit Hplist.
  2. Join the MPE/iX file into the new Hplist file:
    1. Type :EDITOR or :RUN EDITOR.PUB.SYS
    2. /TEXT new HPLIST file name (from step 1.b above)
    3. /LIST ALL (the one dummy record added in step 1.b should also be in the list)
    4. /JOINQ MPE/iX file name, UNN
    5. /DELETE 1 (to delete the dummy record created in step 1.b above)
    6. /KEEP (respond yes when asked if it is OK to purge old file)
    7. /EXIT (now work on the new file in Hplist)


Joining two HPLIST files together

  1. Set up a third file:
    1. Type :FCOPY
    2. >:File file3;DISC=nnnn (nnnn=total number of records in both files to be joined)
    3. >FROM=file1;TO=*file3;NEW
    4. >FROM=file2;TO=*
    5. EXIT
  2. Now work with the new Hplist file. Files 1 & 2 may also be purged.

Converting an HPLIST file to an MPE/iX File

  1. Select the Qedit File Editor from the menu or type :QED
  2. /TEXT HPLIST file
  3. /SET KEEP CODE=0
  4. /KEEP new file name
  5. Now access the new file using QEDIT or TDP as you do any standard MPE/iX file.

Converting from HPLIST to MPE/iX and back to HPLIST

If entering data on a Hplist file that was redundant from record to record, that data must be re-entered each time because there is no provision for replicating the fields. However by using both Hplist and Qedit some effort can be saved:

  1. Convert Hplist to an MPE/iX file (see above).
  2. Text the file into QEDIT: /TEXT filename
  3. Using the column replace command, enter the redundant values in all records. See Qedit chapter elsewhere in this manual for instructions on the column replace command.
  4. Convert MPE/iX file to an Hplist file (see above).

Converting an HPLIST File to a WordPerfect Merge File

To merge an Hplist file with WordPerfect refer to Converting Hplist Files To WordPerfect Merge elsewhere in this manual.

Using QUIZ With HPLIST Files

The reporting facility provided by Hplist has limitations which Quiz can help overcome. Hplist requires that separate files be built in which to place subsets of the file for reporting purposes. With Quiz access to the file, reporting selections can be made from the original file thus reducing the disc requirements and the need for redundant information. With Quiz, data may be retained in the order needed for entry and updating yet sorted at run time in different orders, headings, counts, and subtotals. Partial fields may be reported or links created to existing databases.

To use an Hplist file with Quiz, a Quiz dictionary must be created that defines how Quiz will access the file. There is a menu item that will create this dictionary automatically. Choose System Utilities and Programs from the menu. Choose the option that reads: Hplist to Quiz. The program asks for three pieces of information: the Hplist file name, a dictionary title, and a dictionary name. The Hplist file name is the name given to the list when it was created in Hplist. The dictionary title is a title that Quiz will use to generate default page headings. The dictionary name is the name that will be used by Quiz to access the Hplist file.

An example is included below (Italics indicate information that must be typed in):

HPLIST to Powerhouse Dictionary Converter

Please enter the name of the HPLIST file to be converted (Type EXIT to quit)

MYLIST

Please enter a title for this list (Type EXIT to end program)

John's Data File

Please enter name to be used as output file (Data dictionary used to access the file)

MYQUIZ

Data dictionary is created!

The program will then compile the Quiz dictionary into the internal machine format. The compiling is seen as it occurs. When compilation is complete the following message displays: HPLIST to Powerhouse Dictionary Generator Done.)

Then go into Quiz and access the Hplist file as follows:

:QUIZ

SET DICTIONARY MYQUIZ

ACCESS MYLIST

SHOW ITEMS

. . .

. . . (The items in the Hplist file would show up here.)

. . .

SORT ON ...

REPORT ALL

GO

EXIT

HPLIST Merge

Hplist files can be converted to WordPerfect Merge format. See the section on Sheetmate in this manual.