Home of the original IBM PC emulator for browsers.
[PCjs Machine "ibm5170"]
Waiting for machine "ibm5170" to load....
SIDEFILE is a memory-based database manager that works with relatively
small to medium sized files. These files can be subjected to extremely
fast manipulation because all of the data is stored in memory,
eliminating the constant slow down of accessing the disk for
information.
SIDEFILE is also a disk-based data manager that can operate on large
numbers of records in a manner similar to larger programs. In this
filing mode, SIDEFILE retains its easy to use interface and
spreadsheet-like screens while affording disk-based usage.
SIDEFILE is a fast, easy, and very forgiving program that attempts to
make life easier for all who regularly use small business or personal
data files for nearly any purpose. SIDEFILE lets you to manipulate
your many notes, lists and files with a flexibility approaching,
sometimes surpassing the talents of larger systems. You can also keep
some of your small spreadsheet-type applications in SIDEFILE instead of
in an expensive spreadsheet program. You can even do small editing
jobs right within SIDEFILE instead of having to find and load yet
another program such as a word processor or editor. Of course, all of
your SIDEFILE files will still be compatible with those other programs
should you choose to use them.
SIDEFILE uses two types of files: those with a built-in header line
(data file), and those without a built-in header line (text file). You
can perform all available commands with a data file, but not with a
text file. Text file manipulation is mostly for convenience.
SIDEFILE has proven to be one of the most flexible database programs
available for the IBM PC.
System Requirements: None.
How to Start: To start the SIDEFILE program, put your working disk in
one of your disk drives and type SF (press enter). You may type the
name of the data file you wish SIDEFILE to load right on the command
line -- SF DATAFILE (press enter).
File Descriptions:
??????? SF Example database file (11 files).
EXAMPLES DOC Documentation file explaining example files.
SF DOC Documentation file.
SF EXE Main program.
SF HLP Help file used by SF.EXE.
PADLOCK ADD Advertisement for another of the author's programs.
SideFile (tm) Examples Documentation
This file provides a short description of the example files
provided with the SideFile distribution disk.
ACCOUNTS.SF - A file to keep information on all of your accounts
up to date. Includes the companies address, telephone, and
your account number.
ADDRESS.SF - Very similar to the accounts.sf file, except this
one is for your friends and close contacts.
CHKBOOK.SF - This particular file is a check book for one bank,
one account. Every time you write a check or deposit money
into the account, enter into SideFile. You can get a total
of the Amount field at any time to find your current
balance. If you enter it in on the day you did the
transaction, the date field will come up with the right date
for you. When it comes time to balance your account, you
need to do only three things:
1. Delete all checks and deposits that cleared your
account. You do not need to add a line for service
charge because it will have 'cleared' your account.
2. Edit the 'Last BANK balance' record and put in the new
bank balance. Any line entries now left in the file
are checks and/or deposits that are already outstanding
for the next month (they did not clear this time).
3. Total the Amount field to see your new balance with
remaining entries.
Remember to add any new debits or credits as they occur,
just as you would keep your paper checkbook up to date.
The space before the 'Last BANK balance' entry is so that if
you sort on that field, the balance line will end up on top
of the list. Of course you can also sort or re-sort on the
date field.
CHKBOOK2.SF - This is another example of a check book system,
however this file uses two different accounts - banking and
checking. Try sorting on different fields while in the
EDITOR (with <F5>) to see the different affects. Use <Alt-
F9> to total the columns.
CONTACTS.SF - This list is for a person that works at Acme, a
large company with lots of departments. The employee also
has kept some of his personal, non-work related contacts,
separating them by description in the first field.
HOUSECAT.SF - Exactly like the computer catalog; this one is on
household items. Great for an insurance listing.
INVENTRY.SF - A short and simple example of an inventory.
NUMBERS.SF - A place to keep all of the numbers in your life - no
matter what the number, serial number, account number, etc.
belongs to, it can be kept with all the other numbers right
here in this list.
PHONE.SF - A little phone list for home. Print it out now and
then and tape it to the kitchen cabinet for the family to
use. As more numbers become important for the home, update
the list and print it out again.
PORTFOLO.SF - A busy file containing lots of information on
someone's 'money' accounts. Total the Amount field to get
green with envy (it's not ours!). All his accounts, the
why's, where's, when's, and the totals, it's all here.
The neat thing about this file is that when you receive a
report or statement from one of the accounts on the list,
get into SideFile and update the list. Then make sure to
edit the date field associated with that record. just press
<enter> when the date field appears in the edit block and
the current date will be added to the record. If you are
simply doing some file maintenance editing, then do not edit
that date field and the old date will be preserved. In the
EDITOR, just use the <arrow keys> to leave the date field
unchanged, or the <enter> key to leave it with the new date.
TODO.SF - Everyone needs a 'to do' list. You may be the type of
person that only wants to keep a list of long term projects,
or you may want a daily list. Whatever you want, you can
make a file like this work for you. Separate your notes out
by category, and then sort the list as you add to it for a
pictorial view of what's up. Print the list out and take it
with you. But be forewarned, you may become dependent upon
it.
Disk No #799
Program name: SIDEFILE version 2.33
PC-SIG version 1.1
SIDEFILE is a memory-based database manager that works with relatively
small to medium sized files. These files can be subjected to extremely
fast manipulation because all of the data is stored in memory, eliminating
the constant slow down of accessing the disk for information.
SIDEFILE is also a disk-based data manager that can operate on large
numbers of records in a manner similar to larger programs. In this filing
mode, SIDEFILE retains its easy to use interface and spreadsheet-like
screens while affording disk-based usage.
SIDEFILE is a fast, easy, and very forgiving program that attempts to make
life easier for all who regularly use small business or personal data
files for nearly any purpose. SIDEFILE allows you to manipulate your many
notes, lists and files with a flexibility approaching, sometimes
surpassing the talents of larger systems. You can also keep some of your
small spreadsheet-type applications in SIDEFILE instead of in an expensive
spreadsheet program. You can even do small editing jobs right within
SIDEFILE instead of having to find and load yet another program such as a
word processor or editor. Of course, all of your SIDEFILE files will
still be compatible with those other programs should you choose to use
them.
SIDEFILE uses two types of files: those with a built-in header line (data
file), and those without a built-in header line (text file). You can
perform all available commands with a data file, but not with a text file.
Text file manipulation is mostly for convenience.
SIDEFILE has proven to be one of the most flexible database programs
available for the IBM PC.
Usage: Database.
System Requirements: None.
How to Start: To start the SIDEFILE program, put your working disk in one
of your disk drives and type SF (press enter). You may type the name of
the data file you wish SIDEFILE to load right on the command line -- SF
DATAFILE (press enter).
Suggested Registration: $29.95
File Descriptions:
??????? SF Example database file (11 files).
EXAMPLES DOC Documentation file explaining example files.
SF DOC Documentation file.
SF EXE Main program.
SF HLP Help file used by SF.EXE.
PADLOCK ADD Advertisement for another of the author's programs.
PC-SIG
1030D E Duane Avenue
Sunnyvale Ca. 94086
(408) 730-9291
(c) Copyright 1987 PC-SIG Inc.
╔═════════════════════════════════════════════════════════════════════════╗
║ <<<< Disk #799 SIDEFILE >>>> ║
╠═════════════════════════════════════════════════════════════════════════╣
║ To copy the documentation to your printer type: ║
║ COPY SF.DOC PRN (press enter) ║
╚═════════════════════════════════════════════════════════════════════════╝
SIDEFILE (tm) - SHAREWARE VERSION
---------------------------------
This version of SideFile is distributed to you under the share-
ware marketing concept. Therefore this shareware distribution
diskette may be freely copied and shared with your friends. It
is not a full version of the SideFile program, although nearly
all of the functions work exactly like the registered version.
To obtain the fully operational registered version of SideFile,
simply fill out the order blank below and send it along with a
check for $29.95 to Security Software ($34.95 if you
would like the program on a 3 1/2 inch disk). The very latest
version will be sent to you promptly. A sample order blank is
provided below.
The shareware concept is being used to market SideFile for the
following reasons:
1. It allows people to try out a product before deciding to
invest money into it.
2. It allows software developers to be supported directly
by the end users.
3. Liberal distribution allows for large cuts in adver-
tising costs, thereby passing these savings onto the user.
If you are still using a shareware program after a couple of
weeks, or if you have developed an application for the product
for your use, then it should be obvious to you that the software
is worth something to you, and you should register with the
company who made it. We believe that this should certainly not
be too difficult a decision when you weigh the uses of SideFile
against its price.
Only by supporting the shareware concept can authors continue to
bring you useful software products at below market prices.
shareware allows everyone to benefit; the end user by allowing
software to be 'test driven' and by low price offerings, and the
maker by providing an inexpensive way to advertise a product.
Please remember three things when using this shareware version of
SideFile:
1. It is a partial version intended to acquaint you with the
program. You may use it as you wish. When you find a feature
that does not work with this version (all restrictions are listed
below), please remember that this was only done to prompt you to
buy our fully supported version.
2. A full version is available to you at any time. If you
elect to buy a supported version of SideFile from us, you will
obtain the following:
a. The most recent full version of the SideFile package
without any of the restrictions present in this shareware
version.
b. Automatic notice of SideFile updates and the right
to purchase such for a small maintenance fee.
c. Support for the program in the form of written (or
telephonic) responses to any questions you might have.
d. You will be supporting the concept that allowed you
to receive SideFile in the first place. Only with user support
can we continue to improve the product and perhaps offer you new
products.
3. THE FOLLOWING RESTRICTIONS ARE PRESENT IN THIS SHAREWARE
VERSION OF SIDEFILE:
a. File usage is restricted to the MEMORY-based mode
only. DISK-based mode is not available. A maximum of 1000
records can be used in MEMORY-based mode (depending on record
size). This should be more than enough for you to accomplish
small lists, banking accounts, and data lists, etc. The full
version allows up to 30000 records in it's DISK-based mode.
b. Conversion of dBASE II files and ASCII delimited
files through the SideTran Conversion Utility is not allowed.
The full SideFile package allows conversion of these types of
files to and from SideFile as long as they conform to SideFile's
maximum limits. However, SideFile's ASCII file format will still
allow transfer of data to and from many programs such as dBASE II
and III, Lotus 1-2-3, NutShell, BASIC.
c. Printer specification files may not be loaded into
SideFile. The default generic mode must be used. The full
version allows loading of printer specific files, which are
included on the registered distribution disk.
d. Access to DOS and the ability to run DOS programs or
enter DOS commands from within SideFile is not allowed. The full
version allows complete interfacing with DOS.
e. The opening screen contains a shareware sign-on
message that is not present in the full version. This screen may
not be over-ridden in the shareware version. The full version
allows this through command line sequences and default settings.
f. Filenames may not be entered on the DOS command line
when loading SideFile. The full version allows you to name a
data file for SideFile to load on startup.
g. The SideFile help file (SF.HLP) must be located on
the same drive/directory that is active when you start SideFile.
In the registered version, the DOS environment table may be used
to set the drive/directory where SF.HLP will always be located.
h. SideFile defaults may not be entered into the DOS
environment table. However, most defaults are still changeable
from the command line.
This list is fairly minor because SideFile is loaded with fea-
tures that will allow you to do things with your data files that
you may not be used to doing with other programs. Please read
the rest of this on-disk documentation for more about the
capabilities of the SideFile program.
We thank you for your interest in SideFile and hope to hear from
you for an upgrade to the registered version. But if we don't,
Please enjoy this shareware version with our complements.
By the way, please feel free to give your shareware version of
SideFile to your friends for their use and experimentation. But
please give it to them in its complete, unaltered form as you
received it on the shareware distribution diskette. If you
received an older or altered copy of the shareware version, and
would like an updated one, simply send a check for $5.00 to the
address below.
Order Blank:
You may call 512/860-2697 to order with Visa or MasterCard
24 hours daily, 7 days a week
=================================================================
NAME:
_________________________________________________________________
COMPANY:
_________________________________________________________________
ADDRESS:
_________________________________________________________________
CITY:
_________________________________________________________________
ST:
_________________________________________________________________
ZIP:
_________________________________________________________________
How did you learn about SideFile?
_________________________________________________________________
What comments can you share with us?
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
=================================================================
MAIL THIS FORM AND A CHECK FOR $29.95 TO:
Security Software
P.O Box 161922
Austin, Texas 78761
($34.95 for 3 1/2 inch media)
Your new updated copy and registered extras will be sent
immediately upon receipt of this order.
Memory/Disk-based Data Manager
ver 2.33
by Skip Bremer
(C)Copyright 1988 Security Software Company
Shareware
Reference
(Abidged)
DISCLAIMER
----------
Security Software Company makes no representation or warran-
ties with respect to the contents hereof and specifically dis-
claims any implied warranties to the suitability of this program
for any particular purpose. You must determine that yourself.
In addition, you should understand that using a program of this
type on an IBM-PC series machine or compatible has inherent risks
and that you may inadvertently damage or destroy valuable pro-
grams or data. Security Software Company expressly declines
to assume liability for any use of this program by you, and your
use of this program constitutes your agreement to hold us
blameless.
Security Software Company reserves the right to make changes
from time to time in the context hereof without obligation to
notify any person or persons of such changes.
TRADEMARKS
----------
MS-DOS is a registered trademark of Microsoft Corporation.
PC-DOS is a registered trademark of International Business
Machines Corporation.
1-2-3 is a registered trademark of Lotus Data Corporation.
dBASE II and dBASE III are registered trademarks of Ashton-Tate.
Nutshell is a registered trademark of Leading Edge Software
Products Inc.
Reflex is a registered trademark of Borland International Inc.
SideKick is a registered trademark of Borland International Inc.
WordStar and MailMerge are trademarks of Micropro International
Corporation.
Epson is a trademark of Epson America Inc.
INTRODUCTION
------------
"Data is but data which can be manipulated into yet more data."
-Old technical proverb
Have you ever wished you could manipulate small to medium sized
data bases or listings without the constant disk access (and the
resultant slowness) required of most database managers available
today. Let's face it. We don't all need a dBASE II or III to
take care of most of our personal data needs. There are many,
many often overlooked uses for a quick, easy-to-use data manager.
SideFile allows you to manipulate your many notes, lists and
files with a flexibility approaching and sometimes surpassing the
talents of larger systems. You can also keep some of your small
spreadsheet-type applications in SideFile instead of in an
expensive spreadsheet program. And you can even do our small
editing jobs right within SideFile instead of having to find and
load yet another program such as a word processor or editor. Of
course, all of your SideFile files will still be compatible with
those other programs should you choose to use them.
SYNOPSIS
--------
First, SideFile is a MEMORY-based data manager that works with
relatively small to medium sized files in memory. These files
can be subjected to maximum manipulation because of the inherent
advantages to MEMORY-based work. SideFile is a fast, easy, very
forgiving program that attempts to make life easier for all who
regularly use small business or personal data files for nearly
any purpose.
Second, SideFile is also a DISK-based data manager (should you
choose) that can operate on large numbers records in a fashion
similar to larger programs. In this filing mode, SideFile
retains its easy to use interface and spreadsheet-like screens
while affording DISK-based (random access) usage.
SideFile uses two types of files: those with a built-in header
line (data file) and those without a built-in header line (text
file). You can perform all available commands with a data file,
but not with a text file. Data files are the norm for SideFile,
while text file manipulation is mostly for convenience.
FEATURES
--------
SideFile manipulates your data in one of two ways (your choice):
MEMORY-based mode. In this mode SideFile loads your data
file entirely into memory with the following benefits - quick
file access, minimum disk access, great flexibility. Files are
limited to 1000 records (depending on record size).
DISK-based mode. In this mode, large files may be utilized
in a more traditional fashion. Files are limited to 30000
records.
SideFile uses pure ASCII files, allowing your files to be used by
almost any other program, be it a word processor, spreadsheet,
memory resident editor such as SideKick, or another data manager.
SideFile is a program unto itself. It requires no additional
overlay files (with the exception of its help file, SF.HLP, which
is optional). It requires no additional startup files either.
SideFile does not create additional files required of most data
managers when creating a formatted data file. No header files,
index files, temporary files or sort files are produced
permanently that must be kept. The only file that is ever needed
is the data file itself, be it formatted or not.
SideFile does common functions like adding, deleting, listing,
sorting, printing, finding, replacing, merging, editing, etc.
But SideFile also has functions reminiscent of more powerful
spreadsheet type applications, such as changing field widths,
totaling fields, and viewing and editing your data in column
format. It has functions not found in many other programs like
changing case, moving fields, multiple date formats, and
splitting and combining files.
SideFile lets you perform limited editing on non-formatted files,
similar to a line editor or word processor (without word wrap).
SideFile lets you look at your data in multiple ways. From
within the spreadsheet-like column format, you can choose to view
and add data in the traditional field oriented format, and you
can even view your data in "raw" format.
In all, SideFile has over 50 commands available for manipulating
your data as you see fit.
REQUIREMENTS
------------
SideFile requires the following to operate successfully:
Any version of IBM-PC (PC, XT, AT, Jr, Convertible), or any
computer compatible to this line.
Any 80 column display screen.
Any MS/PC-DOS disk drive (1 floppy, micro-floppy, or hard disk
drive).
Any version of MS/PC-DOS from version 2.0.
256K of memory.
Optionally - any 80 column printer.
In other words ... SideFile should work fine on your computer.
THE DISTRIBUTION DISK
---------------------
The following programs are contained on the shareware version
SideFile distribution disk:
SF.EXE - The SideFile program.
SF.DOC - The shareware (abridged) documentation on disk,
(Shareware disks only)
SF.HLP - The SideFile help file. Not required, but recommended
until you are used to the program. This file should not be
altered.
ST.EXE - The SideTran conversion utility for SideFile that allows
you to transfer dBASE II files and ASCII delimited files to
and from SideFile. (Registered disks only)
*.SF - Various short SideFile example files to help you to gain
ideas on how to use SideFile. All of these files are pure
ASCII files that may be loaded into almost any other
program. Note that file extensions like '.SF' are not a
SideFile requirement. Choose any extension that you like,
or no extension at all, for your own files.
EXAMPLES.DOC - A short explanation of the example files (*.SF).
PADLOCK.ADD - INFORMATION ON NEW PROGRAM!
ST.EXE - S Disk Catalog Utility (Registered Versions Only)
SIDEFILE USES
-------------
Some of the possible uses for SideFile are listed below. This
list is certainly not all inclusive, but it should give you an
idea of the ingenuity of its design. Many short examples are
located on the distribution disk. Simply load them into SideFile
and look at and experiment with them.
Maintain checking, credit card, and saving accounts. Keep an on-
going list of all your banking activities for different
banking accounts, savings accounts, credit unions, etc. You
won't need your checkbook any more. (See CHKBOOK.SF and
CHKBOOK2.SF example files)
Maintain a reminder/tickler file. Keep grocery lists, to-do
lists, to-buy lists, must-do-before lists, any kind of list
you want. (See TODO.SF example file)
Maintain simple portfolio management. Maintain a listing with
the current holdings of all your financial accounts for
instant retrieval and/or reporting. Or simply keep a list
of all your accounts. (See PORTFOLO.SF example file)
Maintain a list of accounts. Keep the specifics on all of your
accounts at your fingertips, such as type, purpose, total,
interest, etc. (See ACCOUNTS.SF example file)
Maintain name and address files. Or maintain business contacts,
accounts, phone numbers, whatever you wish. (See ADDRESS.SF
example file)
Maintain a work contacts list. Keep track of all those offices,
companies, and people contacts you have throughout your
business and the community, like a computerized rolex file.
(See CONTACTS.SF example file)
Maintain catalogs. Keep as many catalogs as you wish any way you
like, and keep totals on the items. (See CMPTRCAT.SF and
HOUSECAT.SF example files)
Maintain simple inventories. Maintain a simple inventory system;
set it up as you wish. Track on-hand supplies, keep current
costs up to date, etc. (See INVENTRY.SF example file)
Maintain telephone directories. Keep telephone numbers, names,
and addresses. (See PHONE.SF example file)
Maintain a numbers list. Keep a list on the hundreds of import-
ant numbers in your life, from lock combinations to bank
accounts, social security numbers to mutual fund account
numbers, from your television serial number to your car
registration number. (See NUMBERS.SF example file)
Maintain dBASE II files. Work with your dBASE II files in
SideFile; you may find it much easier. Also SideFile is an
excellent vehicle to use when first planning a dBASE data
file because of its forgiveness and changing flexibility.
After you are satisfied with the layout and have entered and
experimented with a number of records, you may then easily
convert the file to a dBASE II file. Later if you decide
you need to make changes in field order and/or sizes, use
SideTran to convert the file back to SideFile, and make the
changes. But be careful - you may decide to leave your data
in SideFile full time!
There are many more uses that you will find, such as project
tracking, member lists, doctor expense records, etc.
The bottom line is that SideFile does what it was designed to do
quite well, much easier than larger, more complicated programs,
all of which contain a lot more overhead.
GETTING STARTED
---------------
MAKING A BACKUP
---------------
The first thing you should do is make a backup copy of the
distribution disk. Then put your original away in a safe place.
Consult your DOS manual, if necessary, on how to use the DISKCOPY
command. Next you should copy the SideFile and SideTran programs
to whatever working disk you will be using it on, along with the
example files for your experimentation. Consult your DOS manual,
if necessary, on how to use the COPY command.
STARTING SIDEFILE
-----------------
To start the SideFile program, put your working disk in one of
your disk drives and type SF<enter>. You may type the name of
the data file you wish SideFile to load right on the command line
-- SF DATAFILE<enter>.
THE FILER
---------
Once inside SideFile, if you did not give the data file name on
the command line, you will enter the FILER. Use the <F1> Help
key to obtain guidelines on how to use this screen. You will be
presented with a directory of the current drive and directory
that SideFile started up in. A maximum of 100 files may be seen
in the file name box. Use the <Up/Down> arrow keys and the
<PgUp/PgDn> keys to see more of the files. The following
choices are available in the FILER:
1. Load a file: Use the arrow keys to highlight the file you
wish to load, or enter a filename into the edit block
(reverse video answer block). File extensions are allowed
but not mandatory for SideFile files. SideFile files cannot
have the extensions [.DBF], [.COM], or [.EXE]. The file
must be on the current drive and directory shown. Use the
choices below to change these. The file will be loaded if
it exists, or a new one will then be created by your choice.
The following are examples of valid filenames:
TEST.FLE
TEST
TEST.SF
If SideFile finds the file you entered, it will load it, and
then you are free to manipulate the data as you wish, as
described in the commands section below. If SideFile does
not find the file you entered, then it will ask you if you
wish to create a new one. For this procedure, see the FILE
Load command in the commands section below.
2. Get a directory: Entering an asterisk '*' somewhere in a
file specification will give you a directory of those files.
Examples:
*.*
*
TEST.*
3. Change the current drive: Press <F3> to move the active
edit block to the drive indicator, and enter the letter of
the drive you wish to view and use. SideFile will change to
the root directory of that drive.
4. Change the current directory: Press <F4> to move the active
edit block to the directory indicator, and enter the new
directory you wish to view and use. Do not enter a trailing
backslash '\', a preceding drive and colon 'A:', or a trail-
ing file name or file directory specification '*.*, etc'
here, but only the actual subdirectory name. Use the other
edit blocks for those purposes.
5. Return to SideFile's initial drive/directory: You may, any
time you are in the FILER, return to SideFile's initial
drive/directory by pressing the <F2> key. This may be
useful if you have been working on another drive and/or in
another directory, and want to return to where you started
before you quit SideFile.
6. See (view) highlighted file: You may look at the
highlighted file simply by pressing <F5> while in the FILER.
If the file is not a text file, you will probably see a lot
of garbage, and should not try to load these type of files.
Use <Alt-F5> to see a WordStar formatted file.
7. Move highlighted file: You can move the highlighted file to
another subdirectory on the SAME disk. The file is not
actually copied, but the name is simply changed to show its
new location (just as DOS does). When using this command,
be sure to enter only the directory and the name (which can
be changed in the process if you wish). Do not enter a
drive specification like 'B:'. For example, to move the
file test to the subdirectory WORK, you would enter this:
\WORK\TEST. Users without hard disks have little need for
this command.
8. Rename highlighted file: Similar to the MOVE command,
except that only the filename is given. The file will be
renamed but not moved.
9. Delete highlighted file: If you choose this command,
SideFile will prompt you to be sure. The command (as in
DOS) is not reversible.
10. Run a program: You can run the same programs that DOS can
directly from SideFile by simply pointing to the filename
and pressing <F9>. Keep in mind that SideFile must find
COMMAND.COM in order to do this. Also there must be enough
memory available to keep SideFile in memory and run the
program, or DOS will issue an error message. Users of DOS
3.x can have COMMAND.COM as specified in their COMSPEC table
(see your DOS book). Users of 2.x DOS must have COMMAND.COM
on the active disk drive before issuing this command (or the
DOS command). Even then, it is possible that DOS related
commands may not work due to a bug in the earlier versions
of DOS (and not through any fault of SideFile).
11. Choose MEMORY or DISK-based filing mode: Press <F0> to
select the mode you wish to load your file under, MEMORY-
based or DISK-based. A high-pitched or low-pitched
sound will accompany the change.
12. DOS: Press <Alt-F1> to go directly but temporarily to DOS
from within SideFile. SideFile must find a copy of
COMMAND.COM on your work disk or in the DOS COMSPEC (see DOS
manual for an explanation of this). If you have problems
with the DOS manual, then try this command first. If its
works, fine. If it doesn't, copy the file COMMAND.COM to
your work disk and then it should work. This will also give
you the capability of running other programs that end with
[.COM], [.EXE], or [.BAT] simply by pointing to them while
in the FILER. This can be very convenient, especially in a
hard disk environment.
13. Quit and return to DOS: You may press <esc> to quit.
SideFile will ask you if you wish to quit; answer 'Y' or
'N'. If you pressed <esc> while you were entering a
response into one of the edit blocks, then it will simply
return whatever the edit block said before you changed it.
In this case you will have to press <esc> again to quit.
You may also use <Alt-F0> to quit.
There are other choices you will learn about in the section
covering SideFile's commands that concern file loading and
saving. They include reading and writing files or partial files.
All of these commands will take you to the FILER. Only the <F2>
quick save command will not bring you here.
COMMANDS
--------
Command discussions will indicate what mode the command is avail-
able in with a note such as '(MEMORY only)'.
Some of the commands explained below are accessed with the
function keys (normal or alternate).
You may cancel any of the below listed commands at the beginning
prompt (and sometimes at the second or third prompt) by pressing
<esc>. In the case of a number prompt, leaving or entering a '0'
into the edit block will also cancel the command normally.
Most commands 'remember' the last data entered when you were in
that command, and will display it for you to either accept or to
change. If you enter anything in the very first character posi-
tion of the edit block, then the old data will disappear, just as
if it had never been there at all.
All references to 'columns' can be read as 'fields'. All refer-
ences to 'rows' can be read as 'records'.
HELP MENU
---------
HELP General - How to use the pop-up menus, and a listing of
function keys.
HELP Navigating - How to move around the file.
HELP Editing - How to edit the data.
HELP Headers - All about header/non-header file types.
HELP Fields - All about character/date/number data fields.
HELP Modes - All about MEMORY/DISK modes.
HELP Reporting - All about VIEW parameter affects on reports.
HELP Defaults - All about SideFile default switches.
HELP SideTran - All about additional import/export procedures
available with with SideTran, SideFile's on-disk conversion
utility.
FILE MENU
---------
FILE Load - Use this command to load a new or existing file into
SideFile from disk. The current file in use will be
discarded. If it has been changed since it was loaded, you
will be asked if you are sure you wish to discard it (if it
was loaded in MEMORY-based mode). If not, you may answer
'N' and then use the FILE Save command to save it. Then you
may reissue the FILE Load command without this safety prompt
occurring. Of course, if you answer 'Y' to the discard
prompt, the current file will be cleared from memory at that
time (if loaded in MEMORY-based mode) and any changed data
will not be permanently saved to disk. Be careful. There
is no way to undo the FILE Load command once you decide to
discard a file.
You will be put into the FILER, just as you would for the
other filing commands. When you attempt to FILE Load a file
that does not exist, SideFile will ask you for field types,
lengths, and names. After the new file has been created,
add or delete columns with COLUMN Insert, COLUMN Append, and
COLUMN Delete. Remember to use the '@' or '#' symbols
instead of a number for the width when creating or adding
date or number fields. Use COLUMN Delete and COLUMN Insert
to move a column, and COLUMN Width to change the width.
COLUMN Name will rename a column for you. When you have the
file the way you want it to be, don't forget to FILE Save
it, because the new file process will automatically put you
into MEMORY-based mode, if you were not already there.
If you define only one field, you will be creating a no-
header file, basically a simple text file, for editing.
On the other hand, if your new file does exist, then it will
be loaded just like the first file was when you entered
SideFile. The file will be checked for limits such as
maximum line length, minimum/maximum number of fields, only
one date field, etc.
FILE Save - (MEMORY only) Use this command to save the file
loaded in MEMORY-based mode and then continue operation. It
is recommended that you use the FILE Save command often. It
is conveniently located as function key <F2>, which is
similar to SideKick and some other programs. Whenever you
make a change to your file that you are sure that you wish
to keep, you should consider saving the file by pressing the
<F2> key. More importantly, if you are about to issue a
command that could change the data in your file
considerably, such as COLUMN Sort, COLUMN Insert, COLUMN
Delete, VIEW Replace, etc., and if you already have changes
made in the data that are not saved, save them first. This
way, if the command does not do what you wish, or you regret
the change accomplished by the command, then you can simply
reload the freshly saved file with the FILE Load command.
The FILE Save command always saves to the original file name
that was loaded, the true working file shown on the FILE
Type screen.
FILE Squeeze - (DISK only) Saving is not necessary in DISK-based
mode, because records are constantly being written to disk.
FILE Squeeze is a convenience command that will remove all
blank records from your file, sort of like packing the file.
You should use it now and then if you have made deletions to
the file in DISK-based mode. Squeezing is automatic for
files written to disk using the FILE Write command.
SideFile will check to be sure there is enough disk free
space remaining on the disk the current file came from to
perform the FILE Squeeze operation. There must be disk free
space of at least the size of the current file or SideFile
will issue an error message. As an example, to FILE Squeeze
a 30K file, there must be over 30K free space remaining on
the disk.
FILE Write - Use this command to save all or part of the current
file to a file name of your choice, and not necessarily the
'remembered' file name as with FILE Save. You may save the
current file to any disk drive you have on line, and to any
proper file name. Be careful of the file name you choose,
however, because FILE Write does not, repeat does NOT, check
to see if it over-writing an existing file. You have three
choices when writing a file with this command. You may save
all of it, part of it by a FIND criteria, or part of it by a
record number range. In any case, the current header will
always be saved with the file. This command is SideFile's
vehicle for splitting up large files into smaller ones. The
opposite of this command is the FILE Read command.
FILE Read - Use this command to merge another file from disk to
the file in use. The file you choose to merge should have
the exact same field layout as the current file, or you will
end up with a mess. This is not true, however, with no-
header text files. The commands are similar to those you
get when first loading a file into SideFile. You may join a
file from any other disk that you have on line. A small
delay after the FILE Read command has been completed is
normal. This is SideFile's vehicle for combining smaller
files into large ones. Read files will have their header
line removed as they are added to the file in use. If you
plan to make a large file with this command, you should
enter the current file in the DISK-based mode first. The
opposite of this command is the FILE Write command.
FILE Print - Use this command to print records in your file to
your printer. You can print all of the records in your file
or you may print only records that fit a certain FIND
specification. This operates just like the VIEW Find
command. The records will also be printed with the same
axis format that is in affect for viewing, listing, etc.
See the VIEW ?-axis commands. If printing to the printer,
continuous feed is assumed and required unless you have
changed the default. You may press <enter> to stop and
restart the printing command. If you press <esc>, the
printing will be stopped as soon as your printer buffer
clears.
SideFile will first ask you for a 'title' for your report.
If you give one, it will be centered at the top of the first
page, with the date right-aligned on the next line.
If the file is multi-field, and the VIEW Kut switch is ON,
and the VIEW X-axis view is active, the field names will be
printed at the top of the report.
All number fields will be totaled at the end
of the report. The same criteria used for field names will
be used to determine if the totals are to be printed at the
bottom of the totaled column or separately at the end of the
report. Additionally, the length of the printed record with
dividers must be less than 75 characters for the totals to
be printed at the bottom of each number column.
FILE Image - This command will print your file (all or part) to a
disk file using the exact same format as the FILE Print
command, except that print attributes such as bold face and
form feeds are stripped from the report. The file name you
choose will be over-written if it exists.
FILE Filer - Use this command to go to the FILER to perform disk
procedures. You can change the active disk drive and/or
subdirectory from this screen. While in the FILER via this
command, you cannot press <enter> to do something with a
file. The prompt will read 'File to F1-F9', denoting that
you must press the appropriate function key after pointing
to the file to perform the desired function. Pressing <esc>
will take you back to the EDITOR.
FILE Type - Use this command to obtain a quick file structure
summary of the current file in use from SideFile. It will
display the current available (free) memory if in MEMORY-
based mode or the available (free) disk space on the file
disk in DISK mode. The free memory can be useful to you if
your file is getting large, and you are taking steps to
reduce its size. Notice that the free memory will increase
as you delete records or size down columns with the COLUMN
Width command, or delete columns with the COLUMN Delete
command. You should start considering a DISK-based load if
available memory approaches zero bytes left. Use disk free
space as an indicator of how big your file can be, and as an
input when deciding to SORT or SQUEEZE your file (see those
commands for more on disk space).
FILE DOS - Use this command to exit SideFile temporarily to DOS.
You are given a choice of entering the command from within
SideFile (which allows SideFile to return immediately after
the command is finished) or to go to DOS to enter your
commands. SideFile will not quit, but will instead load a
copy of your command processor (COMMAND.COM) so that you may
essentially perform DOS commands or run other programs while
in SideFile without having to quit and restart SideFile.
This option's effectiveness depends on how much memory you
have available. If you have too little, DOS will tell you.
Also a copy of COMMAND.COM must be available on your
SideFile disk in the subdirectory in which you started
SideFile. If you are using DOS 3.x, then COMMAND.COM may be
specified with the COMSPEC function and be located on
another disk (see your DOS manual for an explanation of the
COMSPEC function). If it is not found, SideFile will give
you an error message. If in the FILER, you may point to a
file that ends in [.COM], [.EXE], or [.BAT] and SideFile
will use DOS to run that file from within SideFile after
pressing <F9>, depending on memory available. Be sure you
do not run any programs that become memory resident
(terminate and stay resident) from SideFile or from any
other program that allows this feature.
FILE Quit - Use this command to end the SideFile program and
return to DOS. If you have made changes to your MEMORY-
based file, you will be reminded of such and asked whether
you still wish to quit SideFile. If you do not answer with
'Y', you will remain in SideFile with your data in tact.
You may then issue the FILE Save or FILE Write command to
save your data first. If you answer 'Y', you will be
returned to DOS and any changes made to the file in use will
be lost and not saved to disk. If you issue the FILE Quit
command with no changes made to your file or your file is
DISK-based, you will be immediately returned to DOS without
further prompting.
HELP MENU HELP
HELP General - About the pop-up menu, function keys.
HELP Navigating - About moving around the file.
HELP Editing - About editing the data.
HELP Headers - About header/non-header file types.
HELP Fields - About character/date/number data fields.
HELP Modes - About MEMORY/DISK modes.
HELP Reporting - About VIEW parameter affects on reports.
HELP Defaults - About SideFile default switches.
HELP SideTran - About additional import/export procedures
available with with SideTran, SideFile's on-disk conversion
utility.
FILE MENU HELP
FILE Load - Load new or existing SF file from disk. Current file
is discarded if in MEMORY mode. DISK mode files are always
current.
FILE Save - (MEMORY only) Save current file to disk and continue
operation. DISK mode files are always up-to-date.
FILE Squeeze - (DISK only) Remove all blank records from current
file. Acts like a file packer.
FILE Write - Save current file to disk as another SF format file
with new name. Can save all or part of file (by record
numbers or FIND criteria).
FILE Read - Read SF format file from disk, appending it to
current file. Can rejoin smaller files to one large file
while in DISK mode.
FILE Print - Print current file to printer in current VIEW
format. Can print all or part of file (by record numbers or
FIND criteria).
FILE Image - Print current file to disk in current VIEW format
(like printing). Can include all or part of file (by record
numbers or with FIND).
FILE Filer - Returns to the FILER to allow disk and/or
subdirectory changes and other DOS commands. Use <esc> to
return to the EDITOR.
FILE Type - Display structure of current file.
FILE DOS - Go temporarily to the system to run DOS commands
and/or other programs (memory permitting). COMMAND.COM must
be found.
FILE Quit - Quit SideFile program to DOS permanently. End of
session. If in MEMORY mode, SAVE current file first.
RECORD MENU HELP
RECORD Insert - Insert blank record just before current record.
In DISK mode APPEND may be more desirable due to excessive
disk access.
RECORD Delete - Delete current record (NOT undo-able in DISK
mode). BLANK (DISK only) may be more desirable due to
excessive disk access.
RECORD Append - Insert blank record at end of file. Consider
VIEW APPEND for appending multiple records.
RECORD Undo - (MEMORY only) Insert last deleted record just
before current record. Becomes BLANK in DISK mode (UNDO not
available).
RECORD Blank - (DISK only) Blank record at cursor position. Can
later SQUEEZE file. Becomes UNDO in MEMORY mode.
RECORD Show - (headers only) Display entire current record in
view temporarily. For those files with records longer than
screen length.
RECORD Goto - Goto specified record number. Can later use LAST
to go back to current record.
RECORD Last - Goto previous record. Can use after a GOTO command
to jump back and forth between two sections of the file.
COLUMN MENU HELP
COLUMN Insert - (MEMORY with headers only) Insert blank column
just before current column. Enter @ or # as length for date
or number columns.
COLUMN Delete - (MEMORY with headers only) Delete current column.
Will be kept in column buffer if memory permits. Restore
later with UNDO.
COLUMN Append - (MEMORY with headers only) Insert blank column at
end of file. Enter @ or # as length for date or number
columns.
COLUMN Undo - (MEMORY with headers only) Insert last deleted
column.
COLUMN Sort - Sort records on current cursor position. In DISK
mode a longer DISK sort will be performed, followed by a
SQUEEZE.
COLUMN Width - (MEMORY with headers only) Change current column
width. WARNING! Clipped data is NOT recoverable.
Character columns only.
COLUMN Name - (headers only) Change current column name. Can not
use with columns having thickness of only one character.
COLUMN Order - (MEMORY with headers only) Insert a temporary
'order' column to preserve current order before new SORT.
Good for <1000 records.
COLUMN Case - Change current column to upper/lower case. Entire
column will be affected. Character columns only.
COLUMN Redate - Reverse date format, Switch date edit block
default, or Change date spacer. Must be pointing at a Date
column.
COLUMN Total - (headers only) Total current column. Multi-column
total is displayed with (=). Number columns only.
COLUMN Kut - (headers only) Toggle display of columns to multiple
or single.
SEARCH MENU HELP
SEARCH Find - Find non-case-sensitive text starting at current
record. VIEW FIND also available.
SEARCH Next - Find next occurrence of non-case-sensitive text.
SEARCH Absolute - Find case-sensitive text starting at current
record.
SEARCH Replace - Replace case-sensitive text starting at current
record. VIEW REPLACE also available.
SEARCH Continue - Replace next occurrence of case-sensitive text.
SEARCH Global - Replace case-sensitive text from current record
to end of file.
VIEW MENU HELP
VIEW List - List records depending on current VIEW format. See
HELP for more on how VIEW switches affect print/screen/disk
reporting.
VIEW Find - Find non-case-sensitive text in current VIEW format
for all records. SEARCH FIND also available.
VIEW Replace - Replace case-sensitive text in current VIEW format
for all records. SEARCH REPLACE also available.
VIEW Append - (headers only) Insert multiple records and
associated data at end of file.
VIEW X-axis - Turn X-axis VIEW mode on (each record lists from
left to right).
VIEW Y-axis - Turn Y-axis VIEW mode on (each record lists from
top to bottom).
VIEW Z-axis - Turn Z-axis VIEW mode on (each record lists exactly
as on disk).
VIEW Kut - Turn Kut VIEW mode on/off (each record lists/may not
list one per line).
VIEW Status - Status of AXIS and KUT switches. See HELP for more
on how these switches affect print/screen/disk reporting.
FILE HEADERS
------------
SideFile manages to keep files in a particular file structure
without keeping a separate header file by putting the
required information on the first line of the file. The
file remains pure ASCII, and by keeping all the data at the
top in one line, the header becomes very easy to make,
change, or delete. Headers are only kept for multi-field
files . The header retains four types of information --
the number of fields, the names of fields, the size of fields,
and the types of fields.
The following example has three fields:
First |Last |Date @|
FIRST LAST DATE
This header line may be created, changed, or deleted at any time
with a text editor, such as SideKick, or by changing the
specifications from within SideFile by changing widths,
adding columns, or deleting columns.
The '|' characters define the last position of a field in the
record. The record length is defined by the position of the
last field ending '|'. Date fields are defined by a '@'
just prior to the field end character. Number fields are
the same but use a '#' character. Date and number fields
must have 9 and 11 spaces in the file respectively. To add
this header to an existing text file, simply make a blank
line at the top and 'paint' this line in. This can also be
done to a text file while in SideFile if the header will be
79 characters or less. Then, save it and reload it.
SideFile will see the header and treat it as a data file.
This header concept is the key to making SideFile useful with
other programs such as SideKick. It retains all the data
necessary to keep the file formatted as a data file (with
fields, etc.) while keeping it useful for other programs.
If a file does not contain a header, then it is a one-field
text file as far as SideFile is concerned, as explained
below.
DATA/TEXT FILES
---------------
SideFile sees files in one of two ways -- with a header line and
multiple fields (more than one) or without a header line and
one field (each line is the one and only field of that line
or record - basically a text file). Files that have only
one field have no need to have a header line (and in fact
may not), because SideFile has no information to obtain.
Here is an example of a one-field file with no header line and
three records:
The largest ocean is the Pacific.
The best country is the US.
The largest state in is Texas.
Here is an example of the same file with a header line applied
(three records, three fields):
Fld one |Fld two |Fld three |
The largest ocean is the Pacific. |
The best country is the US. |
The largest state is Texas. |
When this file is loaded into SideFile, the data on the second
line, ' state is Texa', is the second field of the third
record. Note that if a file is defined with fields,
SideFile automatically adds spaces to the right if necessary
to make all the records the same size. SideKick, on the
other hand, ignores these spaces when loading and saving
such a file. Therefore SideFile is one of the few programs
that can deal with this end of line problem automatically,
and you don't have to worry about it. Your data is not
really changed, and the dexterity of using the file with any
program is maintained. Simple but very useful. If you,
however, look at a file with SideKick and then save it, you
MUST load it into SideFile with the MEMORY-based mode first
and then save it so that the record lengths can be reset by
SideFile if you intend to use the file in DISK-based mode.
When loading no-header files, if a line is found to be longer
than 79 characters, then the file will be aborted.
Any data file or list that you may have will work very nicely in
SideFile, as long as it is kept within the bounds imposed by
SideFile, such as maximum record length (see technical
specifications). Play with the examples on disk
for more explanation on this subject.
TECHNICAL SPECS/LIMITS
----------------------
Maximum number of records/rows:
MEMORY-based mode - 1000 (depends on memory and record size)
DISK-based mode - 30000
Maximum number of fields/columns - 16
Maximum length of records/rows - 250 characters
Maximum length of fields - 65 characters (unless a no-header
'text' file, then 250 characters)
Maximum length of line in no-header text files - 79 characters
Maximum number for formatting purposes - from 9999999.99 to -
999999.99
Required file types - pure ASCII, ASCII comma/quote/carriage
return delimited, and dBASE II
Volume in drive A has no label
Directory of A:\
ACCOUNTS SF 2449 3-22-87 9:08p
ADDRESS SF 2953 3-22-87 9:08p
CHKBOOK SF 2191 3-22-87 9:08p
CHKBOOK2 SF 1563 3-22-87 9:08p
CONTACTS SF 3409 3-22-87 9:08p
EXAMPLES DOC 5168 8-13-88 11:13a
FILES799 TXT 2491 8-31-88 10:11a
GO BAT 38 7-02-87 12:53p
GO TXT 463 8-22-88 10:52a
HOUSECAT SF 7129 3-22-87 9:08p
INVENTRY SF 1441 3-22-87 9:08p
NUMBERS SF 3521 3-22-87 9:08p
PADLOCK ADD 4288 8-15-88 8:41p
PHONE SF 1067 3-22-87 9:08p
PORTFOLO SF 2437 3-22-87 9:08p
SF DOC 58989 8-16-88 11:46a
SF EXE 128958 8-12-88 1:52p
SF HLP 70912 8-12-88 1:53p
TODO SF 1585 3-22-87 9:08p
19 file(s) 301052 bytes
10240 bytes free