EnterApp

Web Services Council

Enterprise Applications
User Guide

Sheetmate

Sheetmate Features

SHEETMATE is a software package which makes mainframe information available to a PC. Sheetmate generates a variety of file types and will download the file automatically to the PC when the client indicates a PC drive on the request for the output file name.

A generic version of Sheetmate is available by selecting SYSHEETM from the menu or typing SYSHEETM while in Qedit. The program prompts for the following. (Information displayed in [ ] is the default if no value is entered).

Input Filename

The Input filename is the name of the file containing the data or records Sheetmate will convert into the desired format. The fully qualified HP filename should be used.

Note: * For list of available files type 'L' , For more information or help type '?' *

Example:
INFILE.PUB.ADMIN
INFILE.ACCOUNT
#O999
999

Conversion File Type/Format

Please Select from the Available Sheetmate File Types/Formats:

Select number
1 = Comma-delimited ASCII file (ASCII)
2 = Quattro Pro spreadsheet (QPRO)
3 = dBase III or IV .DBF file (DBASE)
4 = Excel 3.0 workspace file (EXCEL)
5 = WordPerfect 5.0 merge document (WP50)
6 = WordPerfect 5.1 merge document (WP51)
7 = WordPerfect 5.1 table (WPTABLE)
8 = WordPerfect primary document (WPDOC)
9 = Lotus worksheet version 1A (123)
10 = Lotus worksheet version 2.01, Symphony 1.1 (123/2)
11 = Lotus worksheet version 3 (123/3)
12 = Data Interchange Format file (DIF)
13 = Print image file (PRINTER)
(Specify $PRN output file to print to local printer)
Enter Desired Number for the File Type/Format [1]:

Output Filename

The Output filename is the name of the new output when Sheetmate converts it to the desired format. If the PC drive is included (ie. C:\WPFILES\OUTFILE), SHEETMATE downloads the file to the client's PC. (The client must be using a PC). If the drive is not included, the file will be kept in the client's HP logon.

Three different formats apply to entering output filename.

Note:
* The first 10 lines with column breaks *
* will be displayed on terminal screen. *
* For more information or help type '?'. *

Example:
OUTFILE.PUB.ADMIN [to HP3000]
A:OUTFILE [to floppy disk]
C:\WPFILES\OUTFILE.WP [to hard drive]
F:\OUTFILE.WK1 [to network drive]
$PRN [to PC's local/network printer, see help]
(only if using PRINTER file format)

Enter Desired Name of Output File (filename,$PRN,?) [OUTFILE]:

Sheetmate then runs and converts the file. If a drive was specified, Sheetmate automatically runs a file transfer program and downloads the converted file to the PC. If no drive is specified the file is created on the HP3000.

If there is a need for more complex processing the following is basic information about Sheetmate. Commands can be run for more detailed processing (ie. downshift of columns, left or right justify etc.) Choose SHEETMAT on the menu or type SHEETMAT in Qedit to run Sheetmate. Press F8 for command mode and type help at the $ prompt. The following information displays.

SHEETMATE Help Text, Versing 5.1

Information is available on the following commands :

ALTSPOOLFILE (AL)
ANALYZE (A)
COLUMN (C)
DATABASE (D)
DISABLE (DI)
FORMAT (F)
HIGHLIGHT (HI)
IF (IF)
INPUT (I)
LANGUAGE (LA)
LIST (L)
MODIFY (M)
NOVICE (N)
OPTION (OP)
OUTPUT (O)
POSTSPACE (P)
PRESPACE (PR)
QUIT (Q)
SAVE (SA)
SECTORS (S)
SHOW (SH)
SINGLESPACE (SI)
SWITCH (SW)
USE (U)
VERIFY (V)
XPERT (X)

... and on the other subjects.
KEYWORDS: ANY COMMAND OR "OTHER"
>

When COLUMN Is Entered At The > Prompt Following On-line Help Information Displays

1. $COLUMN

Defines the attributes of a single column of a spreadsheet. If no $COLUMN commands are entered, Sheetmate automatically enters analysis mode and calculates column specifications dependent upon the $INPUT file. $COLUMN commands may be given after $ANALYZE to modify the calculated specifications.

SYNTAX 1 - $COLUMN column #

SYNTAX 2 - $COLUMN nn SELECT
[ IN=tab pos [: width ] ]
[ OUT=output width ]
[ LEFT | RIGHT | CENTER ]
[ TEXT | NUMERIC | MIXED ]
[ DP=decimal positions ]
[ IMPLIED=implied decimals ]
[ NAME=column name ]
[ DOWNSHIFT | DOWNALL | UPSHIFT ]

KEYWORDS: PARMS,OPERATION,EXAMPLES
>
KEYWORDS: PARMS,OPERATION,EXAMPLES
>

2. PARAMETERS

Column #
The output column number. Up to 99 columns are allowed, starting with 1. There is no default for this parameter which must be supplied.

Tab pos
The starting character position for this column. Typically, this ranges from 1 to 132. Tab positions default to 1, 11, 21, 32 etc.

Width
The number of characters to be processed when calculating the contents of this column. The default is 10.

Output width
The width of the resulting spreadsheet column. The default value is the input width for each column.

LEFT
Indicates that numbers and labels are to be aligned against the left side of this column. Labels will not be re-justified when the input and output column widths are equal.

RIGHT
Indicates that numbers and labels are to be right aligned. This is the default value for all Visicalc cells. Lotus 123 labels default to LEFT.

CENTER
Numbers and labels are to be centered in this column.

TEXT
Each cell in this column is to be processed as a label; no attempt is made to interpret data as numeric values.

NUMERIC
This column contains numbers only. Any data (including headings) which are not valid numbers will result in a blank cell.

MIXED
Sheetmate attempts to interpret cells as values. If contents of a cell are not numeric, a label is generated. This is the default condition and is most useful when a column contains both numbers and headings or other text.

Decimal positions
Values are to be output with a fixed number of decimals in this column. This can be useful to eliminate rounding errors. The default is a variable number of decimal positions.

Implied decimals
Sheetmate assumes a decimal point in the number. This is useful when reading integer values from an image database which cannot specify decimals. For example, when reading currency values, one normally specifies IMPLIED=2.

Column name
Sheetmate allows the client to name columns. Column names may be up to 23 characters long; must begin with an alphabetic character and may contain letters, digits hyphens, apostrophes and underscores in any combination.

Field name
When reading from a database, Sheetmate requires specified input field names. These should be as displayed by QUERY. Multiple occurrences of a field are concatenated, so that a field X10 behaves just as one described 10X1. This means subscripts cannot be used.

DOWNSHIFT
Intelligently downshifts. It leaves the first letter of each word capitalized and has special logic for words which are sliced by column breaks. It does not upshift initial letters which are lower case. DOWNSHIFT is a good option for names and addresses.

DOWNALL
Forces EVERY letter to lower case.

UPSHIFT
Forces every letter to upper case.

OPERATION
The $COLUMN command is used repeatedly to define the characteristics of each column in the spreadsheet. The number of columns output to the spreadsheet will be equal to the highest column number encountered in all $COLUMN commands. The sequence of $COLUMN commands is immaterial.

3. EXAMPLES

$COLUMN 4 IN=1:10 NAME=PART-NUMBER

$COLUMN 3 in=:5 TEXT

$COLUMN 16 IN=56:12 OUT=9 DP=2 NUMERIC NAME=INVOICEAMT

$COLUMN 5 TEXT
(leaves all other attributes at their previous values which can be either their defaults, or the result of a $ANALYZE command.)

$COLUMN 4 SELECT QUANTITY-ONHAND

$COLUMN 5 SEL QTY4 NAME = UNITS'SHIPPED

>
---------------------------------------------------------

By entering any of the other commands the client is able to view on-line detail help about that command. Sheetmate prompts for the input file name, output file name, and file format to be created. Press F8 to enter command mode if desired customized processing for the file is required. Contact your analyst for additional help.