In Progress List


This “In Progress List” software is used to check Project Gutenberg (PG) copyright clearances. It currently does this in two ways. First, it checks the current clearance database for clearances that are either “open” or “submitted”. If a clearance is “open,” someone has already cleared that book and may be working on preparing it for submission to PG. If a clearance is “submitted,” then that book has already been posted. A link to the posted book is provided if available.

The software also searches a recent snapshot of the catalog database. A search for a title or an author (or both) is made against posted books. Due to inconsistencies in the clearance and catalog databases, a search of the catalog database supplements the clearance database. For example, a book may show as posted without an apparent clearance.

The overall scenario is simple: a user has a book they would like to prepare and submit to PG. They typically have a title and an author. The will use the “Title” and “Author” search fields for a clearance search. Results will appear on the same form, so the search terms can be refined, if necessary, to determine if their book has already been cleared or posted. Results are sortable by clicking on the column header; click a second time on a column header reverses the search order.

Note that this software relies on both internal and external search algorithms. Searches of DP Canada and fadedpage, for example, use wildcarding such that ‘ford’ matches ‘Oxford’ and ‘Stanford’. This code cannot control an external search engine’s search algorithm. Other searches, including the local clearance database search, may be coded differently. For example, an “Author” search for “Fitzhugh, Percy” will find “Percy Keese Fitzhugh” and “Percy K. Fitzhugh” in the clearance database. It will find another correct variation, “Fitzhugh, Percy Keese,” in the PG Catalog. But it will find nothing in the Fadedpage search, when indeed searching for just “Fitzhugh” will show there are about 80 books in their catalog by this author. Please choose your search term carefully and perhaps try more than one variation.

Frequently Asked Questions

  1. How “up to date” are the databases used by the In Progress tool?
    The clearance database is “live”; the catalog databse is updated daily. The DPC and fadedpage results depend on the refresh interval of external sites.

  2. Does the IP tool handle clearances that have been returned or cancelled?
    Yes. In some cases, users have returned clearances that they do not intend to use.

  3. Can I use the IP tool to manage my clearances?
    No. Clearance management is provided by a separate tool. Visit this site to manage your clearances.

  4. Can I rely solely on the information provided by a search on this site?
    No. The information returned by this script relies on several external databases and sites such that accuracy cannot be assured.

  5. What are the controls under some tables?
    If a result table has more than five rows, a small pagination widget appears. Left to right, it provides (1) click to go to start of results, (2) click to go to previous page, (3) a description of the rows that are being displayed, (4) click to go to next page, (5) click to go to last page in result, (6) select how many results per page are shown, (7) go directly to the selected page within the results.

  6. What does it mean when only the title/author line shows in the “PG Clearance Database” section and no books are shown?
    This tells you there is an earlier clearance before the cutoff date you specified. If you want to see it, change the cutoff to further back, such as “all,” and search again.


Contact copyright2022 at for help or feedback.