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 [] 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.