PCBUpDn.Com, Version 0.1
P. L. Olympia, Darwin BBS
01/24/90
What is it?
~~~~~~~~~~~
PCBUpDn is a PCBoard utility program that reads Download.Txt (a log of
PCBoard upload/download activity) and creates (or appends to) a dBASE
III-compatible .dbf/.dbt file sorted by user name. Then, it creates
a text file showing the contents of the database file in a format like
this:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
AMECHE, DON Last on 10/21/89 Uplds = 0 Dnlds = 3
Dnloads
-------
LIST70A.ZIP 10/21/89 08:35
DDJ1189.ZIP 10/21/89 08:42
VOL8N19.ZIP 10/21/89 08:51
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ANKA, PAUL Last on 10/18/89 Uplds = 2 Dnlds = 3
Uploads
-------
GRAB54.EXE 10/15/89 20:47
LIST70A.ZIP 10/18/89 19:09
Dnloads
-------
RTM101.ZIP 10/15/89 20:29
SHEZ481.ZIP 10/15/89 20:59
JADU13.ZIP 10/18/89 19:16
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Here is the structure of the data file it creates:
Structure for database : PCBUPDN.DBF
Number of data records : 630
Date of last update : 1/22/90
Field Field Name Type Width Dec
1 NAME Character 20 (Lastname, Firstname)
2 LASTON Date 8
3 NUMUPLD Numeric 5
4 NUMDNLD Numeric 5
5 UPLD Memo 10
6 DNLD Memo 10
** Total ** 59
For you dBASE enthusiasts, the Memo fields Upld and Dnld contain the
file activity of each user. This is the data file used to generate
the report.
How to Use
~~~~~~~~~~
Syntax: PCBUpDn [<name of Download.txt file>]
where name may include a path. If you invoke the program
without a filename, it will look for DOWNLOAD.TXT in the
default subdirectory.
Examples: 1) PCBUpDn d:\pcb\download.txt
2) PCBUpDn
Files Used or Created
~~~~~~~~~~~~~~~~~~~~~
PCBUpDn.Dbf -- the dBASE III-compatible database
PCBUpDn.Dbt -- dBASE III-compatible memo field file
PCBUpDn.Fdx -- Index file (may be deleted after the run)
PCBUpDn.Txt -- The report file shown above.
The program will create any file it needs if it can't find them.
All files will be written in the default directory.
Note: Due to the inefficient way that dBASE III & compatibles
handle memo fields, this program would need a very large amount
of scratch space, sometimes 10 times the size of Download.txt.
This may or may not be fixed in the next release (if ever).
Notes
~~~~~
The program was written in Force, the compiler that was born when
C and dBASE got married. Force is marketed by Sophco of Boulder, CO.
If you have any suggestions for improving the program, leave a
message on my BBS, 301-251-9206, Hayes V.42.