Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Software to manage a comicbook collection.
Java
branch: master

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
src/comicinventory
ComicInventory.db
README.md
sqlite-jdbc-3.7.2.jar

README.md

Overview

This software is designed to provide basic management of comicbook collections. It allows the user to input issues into a database through a graphical user interface and supports the ability to input 'runs' of issues. This means that in order to input issues 1-30, the user does not need to individually input issues 1,2,3...30, but rather can specify a beginning and an end to the run. In addition, the user is able to specify certain exclusions, such as if the user does not have issues 19 or 24, the user may specify issues 1-30 except 19,24.

This software also includes the ability to search the database, also through a graphical user interface. One supported feature is 'Series Collection Summary,' which returns a summary of which issues are owned for a given series. For example, requesting the 'Series Collection Summary' for The Amazing Spider-Man might return 'The Amazing Spider-Man Vol 1 Issues 104-209,424-641,670-700.'

Currently, this software does not support the ability to remove comics from the database nor does is support storing multiple copies of the same issue.

Instructions

This section aims to provide instruction on how to operate the software.

Inserting New Comics

There are two primary methods of inserting new comicbooks into the database: Individual issues and Runs.

From the initial screen, click the tab titled 'Insert'

First, type in the name of the series. It is recommended that the full series name is used here. (Example: 'The Amazing Spider-Man' rather than 'ASM').

Next type the volume number for the series. This will be useful for differentiating between two series of the same name. (Example: 'The Amazing Spider-Man Vol 1' versus 'The Amazing Spider-Man Vol 2'). This field is required.

From here, there is the choice between inserting a single issue or a range of issues. Click the corresponding radio button for the correct method.

In the case of Single Issue, simply type the current issue number into the box. This number can be either an integer (Ex: 3) or a decimal (Ex: 699.1).

In the case of Range of Issues, type the first issue in the range into the 'From Issue' field. Then type the last issue of the range into the 'To Issue' field. If some issues are missing from that range, type them into the 'Except' field, separated by commas.

Next, specify the quality of the comic. Currently, the options are 'Very Poor,' 'Poor,' 'Good,' 'Very Good,' and 'Near Mint.'

Finally, list any notes about the comic in the 'Notes' field. This field is not required.

Searching the Database

There are three ways to search the database: 'Search by Exact Terms,' 'Search by Keyword,' and 'Series Collection Summary.'

Search by Exact Terms

This option will use all fields, if specified. It will search for all series with all of the specifed qualities. For example, if 'The Amazing Spider-Man Vol 1 Issue 700' is searched, only that issue will be returned. However, if 'The Amazing Spider-Man Vol 1' is searched, all issues from that series will be returned. If a field is left blank, it will not be included in the search.

Search by Keyword

This option can only use the 'Series Name' field. It will search for all issues with any of the specified qualities. For example, searching 'The Amazing Spider-Man Vol 1 Issue 700' will return all issues with either 'The,' 'Amazing,' or 'Spider-Man' in the title. An empty search will return all issues in the database.

Series Collection Summary

This option will provide an overview of all issues in a series. It requires both 'Series Name' and 'Volume Number' fields. The search will return a line specifying which issues are in the series, using ranges where possible.

Something went wrong with that request. Please try again.