Dec 092017
 
Record album catalog system.
File AC1.ZIP from The Programmer’s Corner in
Category Databases and related files
Record album catalog system.
File Name File Size Zip Size Zip Type
AC.DBF 162 75 deflated
AC.DOC 11476 3839 deflated
AC.EXE 175200 79850 deflated

Download File AC1.ZIP Here

Contents of the AC.DOC file





+---------------------------------+
| ALBUM COLLECTOR |
| |
| Version 1.0 |
| June 1988 |
+---------------------------------+




INTRODUCTION

ALBUM COLLECTOR was originally written in dbase III as a way to keep
track of my ever growing album and CD collection. As time went by I
kept adding features that I felt were needed or convenient. This
version was compiled with CLIPPER to speed execution and aid in
portability. This is my first attempt at a shareware program so any
suggestions are greatly appreciated.


SYSTEM REQUIREMENTS

System requirements are 256K memory, 2 disk drives or a hard drive.
Either a monochrome or a color monitor will work, although the program
was written for a color system and produces a more pleasing screen.
This program has run under dos versions 2.XX and 3.XX and on various
IBM clones with no problems.


FILES

The files that should be included with the program package are:

AC.EXE - the ALBUM COLLECTOR program
AC.DBF - the database file that holds the records
AC.DOC - this file you are reading

When the program is run for the first time it creates four index files
that are used by AC.DBF. These files are:

CAT.NTX - index file for category
ART.NTX - index file for artist
TIT.NTX - index file for title
FMT.NTX - index file for format


INSTALLATION

2 DRIVE SYSTEM: Format a diskette with the system installed (/S option)
and copy the file AC.EXE to it. Format another diskette without the
system and copy the file AC.DBF to it. Place the disk with the file
AC.EXE on it into drive A:, place the disk with the file AC.DBF on it
into drive B:. With A: as your default drive (the prompt A:> will be
present) type AC and press return. The screen will ask you to stand by
while the four index files are being created. Once the index files are
created the MAIN MENU will appear.

HARD DRIVE SYSTEM: Create a subdirectory (any name will do) and copy
the files AC.EXE and AC.DBF onto it. With this directory as your
default type AC and press return. The screen will ask you to stand by
while the four index files are being created. Once the index files are
created the MAIN MENU will appear.

Note: Every time the program is run it checks the default drive for
the file AC.DBF. If it is not found the program assigns drive B:
as the default drive. If you have a high density drive (1.2 meg)
or a small album collection, the program will run on a single
floppy.


GETTING STARTED

Once you have installed the program and run the initial setup each time
you run the program the screen will clear and the MAIN MENU will appear
with 5 choices:

A - ACCESS SCREEN (add,edit,find,delete single records)
L - LISTING SCREEN (list multiple records to screen)
R - REPORT MENU (print reports)
F - FILE MAINTENANCE (re-index and pack records)
X - EXIT (exit to DOS)


ADDING RECORDS

While at the MAIN MENU press [A] and the ACCESS SCREEN will appear with
the first record displayed (if any). On the bottom of the screen is a
menu of options.In those options you will see [A] for append. Press [A]
and the fields will blank, the cursor will rest in the first field,
ready for input. You are now in the APPEND MODE. You may use your cursor
arrows (up or down arrows on the numeric keypad) or the return key to
move between fields. The 4 fields are:

ARTIST - name of the artist or group (25 characters wide)

TITLE - title of the album (35 characters wide)

CATEGORY - what type of music (12 characters wide)
(ex. rock,soul,blues,etc.)

FORMAT - what format the music is on (2 characters wides)
(album,cd,tape,etc)

This is a 2 character field, you may use any code you
wish. Just as an example, I use LP=long play album,
EP=extended play album, CD=compact disc, TP=cassette
tape, RR=reel to reel, 45=45 rpm single

You may exit the APPEND MODE 3 ways. First; by entering data in all the
fields (a blank field is considered data), second; by pressing the
[PgDn] key (which will exit the append mode and save any entries you may
have made) or third; by pressing the [Esc] key (which will exit the
append mode ignoring any entries you may have made).


BROWSING THROUGH RECORDS (DETAIL SCREEN)

While at the MAIN MENU press [A] and the ACCESS SCREEN will appear with
the first record displayed (if any). On the bottom of the screen is a
menu of options. In those options you will see [N] and [P] which stands
for NEXT and PREVIOUS respectively. Pressing [N] will display the next
record while pressing [P] will display the previous record. At any time
the bottom menu is displayed you may edit or delete the displayed record
by pressing either [E] (for edit) or [D] (for delete). Also at the
bottom menu are the options [B] and [T]. These stand for BOTTOM of file
and TOP of file respectively. Pressing [B] will display the last record
while pressing [T] will display the first record.


BROWSING THROUGH RECORDS (LISTING SCREEN)

While at the MAIN MENU press [L], the LISTING SCREEN will appear with
the first fifteen records displayed. On the bottom of the screen is a
menu of options. In those options you will see [N] and [P] which stands
for NEXT and PREVIOUS respectively. Pressing [N] will display the next
fifteen records while pressing [P] will display the previous fifteen
records. Also at the bottom menu are the options [B] and [T]. These
stand for BOTTOM of file and TOP of file respectively. Pressing [B] will
display the last fifteen records while pressing [T] will display the
first fifteen records.

FINDING RECORDS

With the options menu displayed at the bottom of the screen, in either
the ACCESS SCREEN or LISTING SCREEN, you may press [F]. This will
produce a prompt which will vary, depending upon which field your
records are indexed on at this time. Enter the information the program
prompts you for. If a match is found, the record will appear on the
screen. If no match if found, a message will appear at the bottom of the
screen telling you the record does not exist. Once a record is displayed
you may skip over, edit, or delete it.

note: the find option is case sensitive (watch your caps lock)


EDITING RECORDS

There are two ways to edit a record:

1. FROM THE ACCESS SCREEN.

With the options menu displayed at the bottom of the screen you may
press [E] to edit the displayed record. You will be in the EDIT
SCREEN. Once in the EDIT SCREEN changes are made identical to the
way information was added in the ACCESS SCREEN.

2. FROM THE LISTING SCREEN.

With the options menu displayed at the bottom of the screen you may
select a record to edit by pressing [S]. Your cursor will appear at
the top record in the left column. You may then move your cursor
(with the up and down arrows on the numeric keypad) to the record
you wish to edit and press either [E] to edit or [Esc] to exit. If
you choose [E], the EDIT SCREEN will appear, with all the fields
present. Changes are made identical to the way you added information
in the ACCESS.


DELETING RECORDS

To delete a record you must be in the ACCESS SCREEN with the options
menu displayed on the bottom of the screen. To delete the displayed
record press [D]. A prompt will appear asking if you wish to delete this
record. Press [Y] to delete or [N] to ignore.

CHANGING RECORD INDEXES

Records can be indexed on 4 different fields:

ARTIST
FORMAT
CATEGORY
TITLE

Indexing is simply the way the records are listed to the screen. An
example would be, if you wished to find all the records in a certain
category, you would index on CATEGORY and use the FIND command to locate
the first record under that category. To know at a glance which field is
indexed, two arrows will be at the top of the indexed column.

To index the records, you must be in the LISTING SCREEN. With the menu
at the bottom of the screen press [I] and a box will appear similar to
the box below.

+--------------------------------------+
| PRESS "A" TO INDEX ON ARTIST |
| PRESS "C" TO INDEX ON CATEGORY |
| PRESS "F" TO INDEX ON FORMAT |
| PRESS "T" TO INDEX ON TITLE |
+--------------------------------------+

With the box on the screen press one of the four choices in the box and
the records will be indexed and displayed in that order.


REPORTS

From the MAIN MENU press [R] and the REPORT MENU will appear with 4
choices:

A - Artist Listing
C - Category Listing
F - Format Listing
X - Exit to Main menu

Each report gives a full database listing grouped by the field chosen.
An example would be if you had chosen [C] for category listing. Each
category would be presented with the list of alphabetized artists which
fell under that category.

When a report is generated, it is first written to disk and then copied
to the printer. This way, the latest copy is always on disk and there is
no need to run another report (which is time consuming) when you wish to
print another copy.


FILE MAINTENANCE

This is a housekeeping option. It is used to re-index records that may
have inadvertently become de-indexed. You would use this option if your
records or printouts appear strange or not in order. You cannot hurt the
files by choosing these options, so do not hesitate to try these. To
choose FILE MAINTENANCE press [F] while at the MAIN MENU. The FILE
MAINTENANCE SCREEN will appear with 3 options.

1. REINDEX RECORDS
2. PACK RECORDS
X. EXIT TO MAIN MENU

1. REINDEX FILES - If records appear not to be in order of the
index you chose or the printouts appear strange you may reindex your
records with this option.

2. PACK FILES - When records are deleted they are only marked for
deletion but not physically removed from the files, they still take up
space on the disk. Packing removes deleted files thus freeing up disk
space and speeding up disk access.


A BRIEF PLEA FOR MONEY

If you find this program useful please send a $10.00 contribution to:

Ken Green
4322 NW 20th St.
Gainesville, FL 32605

Also any suggestions for future versions would be appreciated.


 December 9, 2017  Add comments

Leave a Reply