User:Ahasuerus

From ISFDB

Jump to: navigation, search

Current status: Active. Please feel free to leave a message on my Talk page or, in case of technical difficulties, e-mail me at (user name:) ahasuerus (domain:) email.com.

Contents

Background

I began helping Al von Ruff with ISFDB design in 1995. I also helped with the original ISFDB testing/data entry and provided bibliographic data for John Clute/John Grant (1949-)'s The Encyclopedia of Fantasy in the mid-1990s, but gafiated in the late 1990s-early 2000s. After re-emerging in mid-2005 and upgrading numerous SF articles on Wikipedia, I have been active as an ISFDB moderator, administrator and tester since moderator editing was enabled on May 1, 2006. I wrote the original ISFDB:Policy and created the Sources of Bibliographic Information page back in 2006.

Current responsibilities

I have been the acting ISFDB administrator responsible for software development, server maintenance, the backups and so on since 2009. I also maintain User:Fixer, a data cleanup/import robot.

In the mid-late 2000s I worked on verifying my collection of some 20,000 speculative fiction books and magazines. Unfortunately, many of my verified publications are currently in boxes and hard to access.

To Do List

Long Term

Data Cleanup and Scripting

  • Convert the Bulgarian titles in Orphia #1 - March 1990 to Cyrillic
  • Change "Locus Poll Award" to "Locus Poll" and "British Science Fiction Award" to "British Science Fiction Association Award"
  • Extract the invisible author biographies from the database and post them on the Wiki for review
  • Find all Titles whose Synopsis and/or Note fields contain %%, a remnant of the pre-ISFDB-2 days
  • Write a script to cache cover scans
  • Find all titles that differ from similar titles for the same author due to capitalization
  • Replicate Contento's list of most frequently reprinted stories?
  • In each magazine issue, find all fiction titles whose title_title is identical - will help identify suspected Interior art titles entered as fiction
  • Post a list of bad prices, starting with "None" and including the name of the Verifier
  • Find all VTs whose title records are identical
  • Find all Titles whose date is after the Author's death date
  • Find all Magazine Titles that have more than 1 Publication record associated with them
  • Find all Publications whose contents do not match the Publication type:
    • Anthology/Collection/Omnibus Pubs with 0 or 2+ Anthology/Collection/Omnibus Title records
    • Novel Publications with 0 or 2+ Novel Title records
    • Novel Publications with <100 pages
    • Publications with 2+ occurrences of the same Title ID
    • Publications with 0 Title records
    • Magazines and Fanzines with zero or 2+ Editor record
  • Check Author names - canonical and legal - for formatting problems
  • Check Titles and Publications for more than 1 capital letter in a row
  • Find Awards pointing to Titles with no Pubs
  • Find identical Titles and Publications

Coding

  • Moderator warnings column in the approval screen:
    • Changes to Contents titles that will affect multiple pubs
    • Missing spaces (e.g. "X.Y.Author") in author names
    • Irregular page numbers (ampersands etc)
    • Merging different title types, e.g. Essay and Collection
  • Double quotes to single quotes: Edit Title, Edit Pub, Clone Pub (pub level only?), Edit Award (currently inactive). Change regular and advanced Author searches to display a warning when trying to search using double quotes
  • Unhide container Titles during Publication editing?
  • Prevent the Series display logic from displaying variant titles
  • Change the Storylen field into a dropdown list in Edit Title

Possible Additional Data Elements

  • Printing number
  • A new "fixup" relationship similar to the "Contents" relationship
  • Separate catalog IDs and ISBNs to better support post-1970s books
  • "Roles" for non-anthology/magazine editors, dust jacket designers, translators, etc.
  • Separate city and publisher
  • Jvn and nvz (do it via tags?)
  • "Bibliography of XYZ"
  • Character names (requested on rec.arts.sf.written)

Library Topics to search

  • Alien abduction -- Juvenile fiction. 180 2008-04-13
  • Alien abduction -- Fiction. 1450 2008-04-10
  • Alternative histories (Fiction). 18579 2008-0413
  • Androids - Fiction 2841 (2341?) 2008-0426
  • Animals, Mythical -- Juvenile fiction. 5160 2008-04-13
  • Anti-Utopias. 21 2008-04-14
  • Apocalyptic fantasies. 931 2008-04-15
  • Area 51 (Nev.) -- Juvenile fiction.
  • Area 51 (Nev.) -- Fiction. 521 2008-07-12
  • Artemis (Greek deity) -- Juvenile fiction.
  • Astral projection -- Fiction. 1233 2008-04-24
  • Atlantis -- Fiction. 3198 2008-04-21
  • Atlantis (Legendary place) -- Fiction. 10399 2008-04-22
  • Cartoons and comics -- Fiction.
  • Dragons -- Fiction. 49582 2008-04-23
  • Dystopias 22075 2008-04-25
  • Dystopian fiction 15 2008-04-25
  • End-of-the-world fantasies 206 2008-05-01
  • End of the world -- Fiction. 10677 2008-05-04
  • Epic fiction.
  • Extrasensory perception -- Juvenile fiction. 3409 2008-04-28
  • Extrasensory perception -- Fiction. 9793 2008-04-28
  • Extraterrestrial anthropology -- Fiction.
  • Extraterrestrial beings -- Fiction. 16341 2008-04-28
  • Extraterrestrial beings -- Juvenile Fiction.
  • Fairies -- Fiction. 30974 2008-04-27
  • Fairies -- Juvenile literature.
  • Fantastic fiction. Python
  • Fantasy Fiction. Python
  • Fantasy fiction, American -- History and criticism. 10248 2008-07-13
  • Ghosts -- Fiction 41536 2008-04-16
  • Ghost stories Python
  • Ghost stories, English History and criticism. 1242 2008-04-28
  • God -- Proof -- Fiction.
  • Hades (Greek deity) -- Fiction.
  • Haunted Houses -- Fiction. 13437 2008-05-07
  • Horror fiction Python
  • Human-alien encounters -- Juvenile fiction.
  • Human-alien encounters -- Fiction. 17974 2008-05-05
  • Human evolution -- Fiction. 2787 2008-05-08
  • Imaginary creatures -- Fiction. 1488 2008-04-17
  • Imaginary creatures -- Juvenile Fiction.
  • Imaginary places -- Fiction. 5998 2008-04-17
  • Imaginary wars and battles -- Fiction. 17958 2008-04-30.
  • Interplanetary voyages -- Fiction. 18983 2008-04-29
  • Interstellar communication -- Fiction.
  • Jinn -- Juvenile fiction.
  • Jupiter (Planet) -- Fiction. 1745 2008-04-10
  • Life on other planets -- Fiction. 60090 2008-04-30
  • Magic -- Fiction. 5927 2008-05-08 Partial, needs Pyhton
  • Magicians -- Fiction.
  • Manned space flight -- Fiction.
  • Monsters -- Fiction.
  • Monsters -- Juvenile fiction.
  • Mythology, Greek -- Juvenile fiction.
  • Mythology, Greek -- Fiction.
  • Nanotechnology -- Fiction.
  • Occult Fiction 57120 2004-04-18
  • Poseidon (Greek deity) -- Fiction.
  • Psychic ability -- Fiction.
  • Rejuvenation -- Fiction.
  • Robots -- Fiction.
  • Saturn (Planet) -- Fiction
  • Science fiction. Python
  • Science fiction -- Authorship.
  • Science fiction, American.
  • Space and time -- Fiction. 29302 2008-04-26
  • Space colonies -- Fiction.
  • Space ships -- Fiction.
  • Space warfare -- Fiction.
  • Star Trek fiction.
  • Talismans - Fiction
  • Time travel -- Fiction.
  • Titans (Mythology) -- Juvenile fiction.
  • Utopian fiction
  • Vampires -- Fiction
  • Voyages, Imaginary. 49213 2008-07-12
  • Witches -- Fiction. 26935 2008-05-09 Partial, needs Python
  • Zeus (Greek deity) -- Fiction.

Amazon categories to monitor

  • Books › Romance › Fantasy, Futuristic & Ghost
  • Books › Romance › Gothic
  • Books › Romance › Time Travel
  • Books › Romance › Vampires
  • Children's Books › Ages 9-12 › Series › Fantasy & Adventure
  • Children's Books › Ages 9-12 › Series › Horror
  • Children's Books › Ages 9-12 › Series › Science Fiction
  • Children's Books > Literature > Fairy Tales, Folk Tales & Myths > Greek & Roman
  • Children's Books › Literature › Fairy Tales, Folk Tales & Myths › Stories
  • Children's Books > Literature > Science Fiction, Fantasy, Mystery & Horror > Science Fiction, Fantasy, & Magic
  • Children's Books > Literature > Science Fiction, Fantasy, Mystery & Horror > Spine-Chilling Horror
  • Children's Books > Literature > Science Fiction, Fantasy, Mystery & Horror > Superheroes
  • Children's Books › Series › Fantasy & Adventure
  • Children's Books › Series › Horror
  • Children's Books › Series › Science Fiction
  • Literature & Fiction › Genre Fiction › Horror › Dark Fantasy
  • Literature & Fiction › Genre Fiction › Horror › Ghosts
  • Literature & Fiction › Genre Fiction › Horror › Erotic
  • Literature & Fiction › Genre Fiction › Horror › Occult
  • Literature & Fiction › Genre Fiction › Horror › Vampires
  • Literature & Fiction > World Literature > Mythology > Children's Books > Greek & Roman
  • Teens > Literature & Fiction > Adventure & Thrillers (a lot of SF)
  • Teens > Science Fiction & Fantasy > Fantasy
  • Teens > Science Fiction & Fantasy > Horror
  • Teens > Science Fiction & Fantasy > Science Fiction

Amazon subjects to monitor

  • Fantasy fiction
  • Romance - Fantasy
  • Romance: Gothic
  • Romance - Gothic
  • Romance - Paranormal
  • Vampires

Recurring Activities

Personal tools