#1345 Cleanup report to find NONFICTION not about SF

[Ahasuerus]

Create a cleanup report to find NONFICTION titles that are not about SF. From http://www.isfdb.org/wiki/index.php/ISFDB:Community_Portal#Cleaning_up_ineligible_NONFICTION_titles_which_exist_due_to_reviews :

(Based on [http://www.isfdb.org/wiki/index.php/User_talk:Biomassbob#Ineligible_titles this discussion] and [http://www.isfdb.org/wiki/index.php/User_talk:Ahasuerus#Ineligible_titles this followup discussion].)

Many SF magazines -- going back to the middle of the 20th century -- have a habit of reviewing popular science books. Our original policy was to enter reviews of non-fiction books, non-genre fiction, and other ineligible titles as REVIEWs. We then created title records for reviewed books. The result was the creation of hundreds of NONFICTION titles that wouldn't have been eligible otherwise.

Much later we changed the policy to enter reviews of ineligible works [http://www.isfdb.org/wiki/index.php/ISFDB:Policy#Contents_always_included as ESSAYs as opposed to REVIEWs]:

• Reviews of ... books that are not eligible for inclusion in the database (graphic novels, nongenre novels by authors that are below the threshold, nonassociational nonfiction works), should '''not''' be entered into the "Reviews" section of the data entry form. A record should be created in the "Regular Titles" section typed as ESSAY.

As I recall, we were going to go back, convert pre-existing REVIEWs to ESSAYs and delete the ineligible title records, but we never did.

We already have a [http://www.isfdb.org/cgi-bin/edit/cleanup_report.cgi?42 cleanup report] that looks for "reviews of CHAPBOOK, COVERART, INTERIORART, INTERVIEW and REVIEW records". I think we need another one for "reviews of NONFICTION". I could easily create one, but please note that we have almost 5,500 reviewed NONFICTION titles and a bit over 9,500 reviews of NONFICTION titles. Reviewing 9,500+ reviews and their associated NONFICTION titles is likely to be time-consuming, so I would like to gauge the interest first. We may also need to limit access to the report to moderators because each change would require multiple steps. [[User:Ahasuerus|Ahasuerus]] 16:47, 17 April 2020 (EDT)

[Ahasuerus]

Implemented in:

edit/cleanup_lib.py
edit/cleanup_report.py
nightly/nightly_job.py

Installed in SVN 521 on 2020-05-06. Closing the FR.