[comp.os.cpm] SIMTEL20 CPM DATABASE

COLSA@SIMTEL20.ARPA (Larry Armijo) (12/03/87)

The  one-line  descriptions  contained  in  the  files  SIMCPM.ARK  or
SIMCPM.IDX with  format as  described in  SIMCPM.INF in  the  SIMTEL20
directory PD1:<CPM.FILEDOCS> are  ideally suited for  DBASE II.   Only
one minor correction is necessary to construct a DBASE II database for
the files: the Description field  mentioned in SIMCPM.INF should be  a
character field of length  40 rather than  30.  After the  appropriate
structure has  been  entered via  the  CREATE command,  the  DBASE  II
command APPEND FROM SIMCPM.IDX DELIMITED loads the database.  The file
SIMCPM.IDX requires only one modification.  The beginning of each line
should be modified by replacing "PD:" by "PD1:".

The full power of DBASE II is now available for searching through  the
CPM archives on SIMTEL20.   Many thanks to  Keith Petersen for  making
this tool available.

Larry

W8SDZ@SIMTEL20.ARPA.UUCP (12/06/87)

Thanks for the information on how to use SIMCPM.IDX with dBASEII.  I
have added an edited version of your message to that directory, and
SIMCPM.ARK, as SIMCPM.DB2.

The corrections you noted have now been made to SIMCPM.IDX and
SIMCPM.INF, thus making it unnecessary for users to have to edit these
files.

Thanks for your significant contribution, Larry, in telling us how to
use SIMCPM.IDX with dBASEII.

I'd like to take this opportunity to remind everyone that
PD1:<CPM>FILES.IDX is created everytime a new CPM.CRCLST is made.
This is usually done at least once per day and sometimes several times
per day on weekends as new files are added to the archives.

--Keith Petersen
Arpa: W8SDZ@SIMTEL20.ARPA
Uucp: {bellcore,decwrl,harvard,lll-crg,ucbvax,uw-beaver}!simtel20.arpa!w8sdz
GEnie: W8SDZ
RCP/M Royal Oak: 313-759-6569 - 300, 1200, 2400 (V.22bis) or 9600 (USR HST)