Jump to content
ComicBase User Community

Fred Slota

Members
 View Profile  See their activity

  • Posts

    1,130

  • Joined

  • Last visited

  • Days Won

    16

 Content Type 

Posts posted by Fred Slota

    Fun with colons...

    in Content and Corrections

    Posted

    (I.[Title] LIKE "%:%") AND NOT(I.[Title] LIKE "%: %")

     

    The first item I found in ComicBooks is the title "11:59", which shows a partial explanation why this might not get noticed.  The font used for displaying the Title at the top of the screen has a whitespace kerning after the colon that makes it look like there is a space after the colon.  If you go to edit the title, you can see that there is no space.

    Captain Britain and MI:13 - The cover doesn't show the colon, wondering if it should be there

     

    Titles where the colon probably is a subtitle and should have a following space

     

    I Cavalieri dello Zodiaco-Episide G:Assassin

    Fate/Grand Order-Mortalis:stella

    Justice Leagues:Justice League of Arkham

    The League of Extraordinary Gentlemen:Nemo Trilogy Slipcase

    Nemi:Monstre

    Vikki Belle:The Palace of a Thousand Pleasures

     

    Fun with apostrophes

    in Content and Corrections

    Posted

    Comics, K-Z

     

    Kia Asamiya's Dojinshi Sketchbook

    Michael Neno's Dream

    Mike Zeck's Classic Marvel Stories Artist's Edition

    Mort Drucker's MAD Show-Stoppers

    Nicholson's Small Press Tirade and Other Works: 1983-1989

    Paul Terry's Comics

    R. Crumb's Carload O'Comics

    Ronald Searle's America

    Sam Glanzman's USS Stevens: The Collected Stories

    Schulz's Youth

    Shade's Cover Girls

    Shade's Goodtime Girls

    Shade's Superhero Sexcapades

    Virgil Finlay's Illustrations for Weird Tales

    Many "Walt Disney's" titles (as opposed to "Disney's")

    Walt Kelly's Pogo: The Complete Dell Comics

    Will Eisner's 3-D Classics: Spirit

    Will Eisner's Quarterly

    Will Eisner's The Spirit

    Woron's Worlds

     

    Screening for incorrect Title formats before pushing new titles in the weekly update

    in Feature Suggestions

    Posted

    I suggest that CB add a step to the process by which they generate weekly content updates, where they run a few screening tests on new titles, in an effort to prevent adding malformed titles.

    • Test for initial "A", "An", "The", etc.
    • Test for initial creator possessives, "Stan Lee's"
    • Test for proper/improper directional apostrophes, quotes, etc. 
    • Test for proper/improper dashes
    • Test for proper/improper spacing around punctuation

    Fun with apostrophes

    in Content and Corrections

    Posted

    Thought I'd do a search for possible initial possessive titles that might need retitling.

    My initial search gave way fewer results than I expected, and I realized that CB mostly uses ’ and not the ' directly typable from my keyboard.

     

    Search for I.[Title] LIKE "%'%" returns:

    • 11 results in Books
    • 502 results in Comic Books
    • 0 results in Magazines
    • 0 Results in Newspapers

     

    A couple of finds searching for (I.[Title] LIKE "%’s%") and not(I.[Title] LIKE "%(%’s%)%")   (typed by hand, probably has the wrong ', don't copy-and-paste)

     

    Comicbooks (searched through the J's...)

     

    Akira Toriama's Manga Theater

    Alberto Breccia's Dracula

    Andy Warner's Oddball Histories: Pests and Pets

    Anna Malle's Dirty Deeds

    Bill Stern's Sports Book

    Bobby Benson's B-Bar-B Riders

    Bobby Benson's B-Bar-B Riders (Magazine Enterprises)

    3 assorted that start with Bru-Hed's

    Captain Billy's Whiz Bang (Fawcett)

    Clive Barker's Nightbreed Archive

    Ed Wheelan's Joke Book

    Frank Brunner's Carnal Delights

    Frank Miller's Daredevil and the Ends of Heroism

    Frank Miller's Sin City: The Making of the Movie

    George Pal's Puppetoons

    Gris Grimly's Tales from the Brother's Grimm

    H.P. Lovecraft's Beauty and the Beast

    H.P. Lovecraft's Magazine of Horror

    Ippongi Bang's Canvas Diary

    Jack Kirby's Kamandi, The Last Boy on Earth

    Jack Kirby's Marvel Heroes and Monsters

    James Kochalka's Sketchbook Diaries

    James Lloyd's Other Stuff

    Jim Starlin's Dreadstar Omnibus

    Joe Matt's "Jam" Sketchbook: Feb. 1995to Ma 1998

    John Buscema's Marvel Heroes

    John Byrne's Marvel Classics Artifacts Edition

    Junji Ito's Cat Diary: Yon & Mu

     

     

     

     

     

     

     

     

     

    Speaking of misspellings...

    in Content and Corrections

    Posted

    My at minimum wasn't that the note, as a whole, should go in Item Title; just the cover misspelled title.

     

    In the example given, for that issue, Item Title would have "Marvel Calender"

     

    Isn't the point of "Item Title" to help direct the user into finding the correct title when the title on the cover isn't the official title?

    Speaking of misspellings...

    in Content and Corrections

    Posted

    At minimum, should notes about cover misspellings have the appropriate information carried into the new field for alternate title names (apologies I forget the field name)?

     

    Database purist that I am, assuming that info is carried into the new field, I would recommend that the note be removed from Notes...

    How to "Mark as Solution"

    in Tech Support

    Posted

    I just started getting them the other day, and given the volume of my postings, I was suspicious that I didn't remember seeing them before.

     

    So, to be clear, there is no "Mark as Solution" button available, and I should ignore e-mails referring to them?

    Roman Numerals are Upper Case

    in Content and Corrections

    Posted

    Finally got around to changing this manually.  The title now shows with fully-capitalized Roman Numbers in the Titles list, and as the Title on the screen when I am looking at Issues of that Title.

     

    Noticed someone had left a note to Comicbase about the capitalization in the Notes field of one of the issues.  Decided to search the database for any others, so I could clean them out and submit the cleaned issues.  Search only found 1 instance, so that's good.  However, I noticed that in the search results grid, the wrong capitalization is still showing in the Title field of the grid.  Would a list rebuild correct this?

    Report of Storylines I Own, Owned + Missing

    in Feature Suggestions

    Posted

    The ability to generate reports of all issues, owned and missing, of Titles that I Own, grouped by Title, sorted by Issue, is very useful at completing Titles.

     

    Wouldn't it be nice to generate reports of all issues, owned and missing, of Storylines that I own, grouped by Storyline, sorted by Part, to aid in completing Storylines?

     

    In order for this to work usefully, it would be helpful if the things reported in the Storyline field were separable between "This is the name of the multi-part Storyline Series", "This is the name of this chapter of the multi-part Storyline Series", "This is the name of this Issue's standalone Storyline"  and "These are the names of the individual tales in this anthology Issue".  You know me, I would love to separate this into separate fields.

     

    Thankfully, the current task can be mostly accomplished without this, by recognizing the difference between Storyline entries that are unique vs. those that are repeated in multiple different issue entries.  For example, the Storyline "Funeral for a Florist! (text story)" appears in a single issue, In the Days of the Mob #1, while the Storyline "Funeral for a Friend" occurs across 8 different issues (and is the shared with a 2-parter in Transformers, The (Marvel UK), not to be confused with the single issue Storyline "Funeral for a Friend!" in The Transformers #26).  Obviously, some editorialization would be needed.

     

    Export Select Titles

    in Tech Support

    Posted

    Clarify, for those listening to mid-conversation posts focusing on one detail or another, and thus helpfully providing incomplete answers.

     

    Ideally, I'd like to get at least

    Title, Publisher, Years, Issue, Quantity, Condition, Price, Cover Date, Street Date, Storyline, Wanted, Custom Check Boxes, each as separate fields

    For both Owned and Missing issues, of Titles that I Own.

     

    Cleanup of Years Published, 2023 vs. Present

    in Content and Corrections

    Posted

    2023 is for series that ended in 2023, while Present is for ongoing series, yes?

     

    I think some cleanup is needed.

     

    Partial list of false Presents

    Amazing Spider-Man (5th Series)/(6th Series)

    Black Widow (7th Series)/(8th Series)

    Iron Man (6th Sereis)/(7th Series)

    Justice League of America (2nd Series)/(5th Series)

    Teen Titans (5th Series)/(6th Series)

    Thor/Thor (6th Series)

    Uncanny X-Men (3rd Series)/(5th Series)

    Wolverine (6th Series)/(7th Series)

     

     

    Partial List of 2023 that might be Present?

    Batgirls

    Batman Incorporated (3rd Series)

    Deadpool (8th Series)

    Fantastic Four (7th Series)

    Gambit (8th Series)

    Ghost Rider (11th Series)

    Human Target (4th Series)

    I am Batman

    Immortal X-Men

    Iron Man (7th Series)

    Justice Society of America (3rd Series)

    Marauders (2nd Series)

    Savage Avengers (2nd Series)

    Spider-Man (4th Series)

    Star Wars (3rd Series)

    Strange (3rd Series)

    X-Force (6th Series)

    X-Men (6th Series)

    X-Treme X-Men (3rd Series)

     

    Prime Issues

    in Feature Suggestions

    Posted

    I think ComicBase should add the concept of Prime Issues.  

     

    Prime Issues are non-variant first print issues if they exist; if they don't then they are variant A first print issues.  This would exist for all types, whether Regular, Annual, Book, etc.

     

    Identifying Prime Issues would allow ComicBase to do a variety of things:

    • Titles can indicate how many issues are in a Title.
      • Titles can indicate if you have a complete set of Prime Issues.
      • Titles can indicate how many Qualified Issues are owned, how many are missing, and what percent of completeness you have.
      • You could generate reports of Title Completeness.
      • You could search based on "Titles >= 90% complete" or "Titles missing <= 3 Prime Issues"
      • You could add these to Wanted.
    • Additionally, Qualified Issue Ownership could have four levels
      • Prime only
      • Prime or any variant, first print only
      • Prime variant only, any print
      • Prime or any variant, any print
    • With Prime Issues and Qualified Issue Ownership levels, ComicBase can identify ownership holes
      • can search for "Prime not Qualified Owned run <= 3"
      • You could add these to Wanted.

     

     

×
×
  • Create New...