SLICE\SLICE.DOC  ·  DOC  ·  8.4 KB  ·  1991-01-01  ·  from PCPlus_Issue-52_Jan-1991_FluxEngine-360Kb
SLICE (c 1989 Lightning Word Corp & Volkswriter Ltd)
  The Easy Way to Integrate
                  from VOLKSWRITER Ltd, The Sanderson Centre,
                       Lees Lane, Gosport, Hants  PO12 3UL
                       telephone (0705) 511679  FAX (0705) 502176

 (This version of SLICE has a limited lifetime: it will not work after
  the end of February 1991;  if you find it useful and wish to purchase
  SLICE, contact Volkswriter to obtain the full version, including manual).

SLICE is a large (over 64k) TSR (Terminate/Stay Resident) program: when it has
been loaded, it remains resident even after you load the next program.  This
can drastically reduce the amount of memory available to you: it may be
impossible to load some programs (e.g. a desktop publisher) subsequently
without first unloading SLICE by the method described below.

SLICE acts like a data exchange between your word processor, your
spreadsheet (1-2-3 format) and your database programs (dBase format).
Information from spreadsheet or database files comes into SLICE and is
then funnelled out to your word processor, spreadsheet or database.
SLICE eliminates time-consuming cut-and-paste operations - you just
slice information from one format into the other.    Since SLICE works
from the files themselves, you do not need to load the spreadsheet or
database programs to get at the information.  The operation is simple:
        1. stay in your destination program (word processor, database or
            spreadsheet);
        2. use a simple keystroke to bring SLICE into action
        3. mark the data you need - and then transfer it at a keystroke.

Your CONFIG.SYS file should allow for at least FILES=20 and BUFFERS=20.
If you would like to be able to start SLICE from any directory, copy its files
into a permanent place (like C:\SLICE), and add this to your PATH.  Once SLICE
is in memory, it is awakened by keying CTRL and 5 (from the numeric pad).
To remove it from memory, key CTRL and DEL.

While in SLICE itself, the following keys are useful:

        TAB and shift-TAB scroll the screen right and left
        PgUP and PgDN scroll the screen up and down
        F1 provides HELP

        F2 selects a single ROW from the screen
        CTRL-F2 selects ALL rows from the screen

        F3 allows you to specify input criteria
        F4 actually does the slice - transferring data to your active program

        F6 selects a single COLUMN from the screen
        CTRL-F6 selects ALL columns from the screen

        F7 starts a search within a dBase column
        F8 continues a search (search next) within a dBase column
        F9 or ESC exits from SLICE - putting it to sleep
        F10 displays your active program's screen

If you are using a MOUSE, you can click on the function key icons with the
LEFT button.  Selecting a row (F2) or column (F6) is done by positioning on the
selected row or column, press the LEFT button and drag horizontally (for the
row) or vertically (for the column).  The RIGHT button will escape from SLICE.

The \SLICE directory on SuperDisk has some sample files of the various types
available so that you can test the abilites of this program: if you wish to use
them, make sure they are on the same physical disk that you are logged onto
when you load your destination program (e.g. your word processor): SLICE is
able to change directories, but not able to change drives when looking for the
source files from which it will transfer data.    (To load a source from
another drive, you must EXPLICITLY key the path to it, rather than select from
the list of nominees that SLICE will automatically provide).

File formats here offered:
        .WKS are for Words & Figures, Lotus 1-2-3 or Symphony
        .WRK and .WK1 (also .WR1) are for Lotus 1-2-3 or Symphony
        .DBF is for dBase


SUMMARY OF SAMPLE

1. Position to the SLICE directory, and key SLICE [ENTER]
2. Load your favourite word processor (almost any will do).
3. Load the sample file called SAMPLE.TXT - which should be in the
    \SLICE directory, anyway.
4. Move the cursor to the end of the file, at the left margin on a blank line.
    (SLICE will move data to wherever the cursor is).  Put your word processor
    into INSERT mode (rather than TYPEOVER or REPLACE).
5. Wake up SLICE by keying CTRL and 5 (numeric pad); from the menu that now
    appears, choose 1 or 2 (Words & Figures / Lotus Worksheet); now you will
    see a list of available files (of that format) if any exist.
6. Using the cursor keys (or mouse), move the selection bar over the name of
    the file from which you want to select data; the names of subdirectories
    and .. (the parent directory) are available as well, to move to other
    places on the disk.  For example, select PROPERTY.WK1 and press [ENTER].
    Alternatively, you may KEY a filename (if needed, including the drive
    and the path to it) followed by [ENTER].
7. The information from this file is displayed on the screen, with SLICE
    commands summarised at the bottom.  Keep in mind that your word processor
    is still running. (You can confirm this by peeking with F10 - the next
    keystroke will bring you back into SLICE).
8. Now select the information to be transferred from this spreadsheet file into
    your word processing document: using cursor keys (or mouse), move the bar
    over the ADDRESS (for example); press F2 - which will highlight the entire
    column heading row, and the cursor moves down to the first address line.
9. For each row within this column, you may highlight examples by pressing F2,
    or bypass each by pressing the cursor down key.
10.Select the column itself by pressing the F6 key: the items chosen within the
    column should now be underlined (mono monitor) or displayed in red.
11.Move to any other column - for example, COST: press F6 again, and note that
    costs will be highlighted only from rows previously selected: what is now
    highlighted is a SELECTION of data from the original table - a mini-table
    in effect.  We are now ready to transfer this mini-table into our word
    processing document.
12.Press F4 to start the transfer operation: a box appears, permitting various
    formats for the actual transfer: it is simplest to choose 1.    Those data
    portions you selected from the table will be copied into the word processor
    just as if you had keyed it.  After the transfer is complete, SLICE will
    redisplay the spreadsheet in case you wish to select more data.  Press F9
    or ESC to return to your word processor.

Other features you may wish to know about are:
        (1) TEMPLATES, which allow you to customise how marked data will be
            formatted when the transfer takes place: templates are written into
            files (which you would keep for future slicing) with the
            extension name .TPL.    Documenting and demonstrating these is
            beyond the scope of this experimental version: please contact
            the authors of SLICE for further information.
        (2) SEARCHING (for dBase files): employed by keying F7 and then a
            search string.  For numeric fields, inequality searches can be
            made: for example =50 would search for a value of 50, but <50
            would search for any value lower than 50.  Conditions allowed are
            <, =, >, <= (less or equal), >= (greater or equal), and
            != (not equal).    Keying F8 will resume a search for the NEXT
            string or value matching the search criterion.  This will enable
            you better to determine rows/columns that are desired for transfer.
        (3) INPUT CRITERIA: you may limit which records are being displayed
            from the source document (if it is Lotus or dBase format) by
            specifying criteria (conditions): pressing F3 will bring up a
            separate screen, inviting you to list conditions that must apply
            before a record is displayed.  If you would like to experiment
            with this, press F3 - this will talk you through the options
            available.  If you wish to ensure that this feature works as you
            require before you buy, please contact the authors of SLICE.

            SPECIAL MAIL ORDER:
            SLICE retails at £68.95, but note in our Mail Order pages that
            you can now obtain it at the SPECIAL price of £34.50.