Jump to content

Steven L. Dasinger

Moderators
  • Posts

    1,526
  • Joined

  • Last visited

  • Days Won

    72

Posts posted by Steven L. Dasinger

  1. Using Excel 2013, the instructions don't match exactly.

    What I can follow got a connection and the data imported.

    After that, refresh / recalculate does nothing and there are a lot of broken links.

    Hopefully, someone with a new version can get this to work.

  2. Not really.

    If what you want to find has something common among all rows at the end, you could try to replace it with itself and the extra. For example, if all the Notes had  'abc efg', you could find ' efg' and replace it with ' efg; xyz' (but the chance of all of the notes having the same text at the end with nothing else after it, is not very good).

    You could do a Find (regular or advanced), select and copy out the data in the column you want to change, paste to Excel, make the changes, the copy paste it back into CB. Or use export / make changes / import.

     

  3. 2 hours ago, Fred Slota said:

    Is there anyone who has won the ComicBase version of an EGOT, a WAILECaCoCi (tm)?

    Since you asked...

    There are 52 creators has a credit in the WAILECaCoCi credits of a single issue (in 61 different titles):

    Adam Hughes

    Al Hartley

    Al Wiesner

    Alan James Hanley

    Alan M. Baker

    Anthony Sica

    Ben Seto

    Bob Burden

    Budd Root

    Chris Levy

    Dustin Craig

    Fred Hembeck

    Fred Perry

    Gene Fawcette

    Gilbert Shelton

    Henry Kujawa

    Holly Golightly

    Jake Roth

    Jason Asala

    Jason Waltrip

    Jay Hosler

    Jeff Smith

    Jerry Ordway

    Joe Kubert

    John Patrick Green

    Jonathan David Moreno

    Jorge Medina

    Joseph Michael Linsner

    Josh Sheppard

    Joshua Warner

    Karl Stephan

    Kenneth Smith

    Kyle Baker

    Mark Crilley

    Mark Hartman

    Mark Murphy

    Mark Smylie

    Matt Kindt

    Meg Golding

    Nathan M. Rosario

    Ralph Cosentino

    Rod Espinosa

    Roger Langridge

    Ruben Bolling

    Shade

    Shane Milner

    Stan Lynde

    Stephen Blue

    Stephen R. Bissette

    Ted Nomura

    Terry Moore

    William Edward Gordon Johnson

  4. Oh, also, unlike the Find changes, you can't submit the changes you make with Find/Replace.

    You can do a Find then Mark the issues that you find before you use the Find and Replace to find and submit them afterwards.

  5. Menu item Edit-Find and Replace (or CTRL+H) will allow you to search and/or replace in either one of many (text?) columns, or, if you like to live dangerously (and have a backup...), you Find and/or Replace in ALL the columns at once (but you will NOT get a preview before the change (hence, the 'live dangerously)).

    This will do single items in a multi-item field (ex. any of the creator fields, Appearances, Storylines, etc.)

  6. I am following the information correctly, for certain covers to be ordered, they must be 'unlocked' by first ordering a certain number or percentage of another cover or issue (or whatever parameter the publisher decides to 'unlock' the ability to order).

  7. Covers are displayed as the comic would be held when being read. They are not rotated just they may look better that way.

    At least that used to be the process. I was going to use the 'Sins of Youth' books as an example, however, all but one has been rotated on it's side to 'look better' (Sins of Your: JLA, Jr. being the only 'correct' one).

    I wonder if HC has changed their policy or if they 'got through' the submit process.

  8. I wouldn't consider them connecting covers but several sites seems to do so. As you pointed out, only D and E have any image crossover and the others that could have (A, left side of D and F) don't have any cross over.
    I would consider these more a set of similar covers (sort of like the 'Face' covers Marvel and DC did several years ago) where each issue was done in the same style (some border, main character head shot, etc) then a true '*ptych' cover.

  9. Recently, cover scans that include the back cover of non-wraparound covers have been allowed (or at least not rejected) because they can supply useful information for identification (especially variant covers which are only identified there).

    This particular cover is too small to read anything so I can't say if it does have that information or not (but the UPC may be considered useful).

    I will let HC make the final decision, however.

  10. For those that don't know the 'C.A.T. in WIldC.A.T.s stands for Cover Action Team (or Teams).

    Technically, the creators should have made the title 'WildC.A.Ts.' but they didn't.

    Per the indicia and cover, 'WildC.A.Ts. (6th Series)' should be 'WildC.A.T.s' (period after 'T' but not after 's').

    I can't verify 'Absolute WildC.A.T.S. but I would be very surprised if there is actually a period after the 's'.

    For all the rest, the 's' should be lower-case. (this can be confusing since a lot of covers and most indicia use all upper-case).

     

  11. First, I will say just because something looks like it might have a connecting cover doesn't mean there is one.

    However, in this case it is part of a triptych.

    If you go 'The One Stop Shop' web site here ( https://tosscomics.com/search?q=we+don't+kill+spiders&type=product&product_cat=all ) and scroll to the bottom, it looks like Ben Bishop did do a triptych set of 3 covers but they are not connecting covers. (they are not in order but are labeled correctly (2 of 3, 1 of 3, 3 of 3).

  12. Delete or Move TPB-LE.jpg
    From: Pictures\B\Big Wow\Eduardo Risso. Black. White
    To: Pictures\B\Big Wow! Art\Eduardo Risso. Black. White

    Delete or Move MMPB.jpg
    From: Pictures\M\Magnum\First Men in the Moon, The
    To: Pictures\M\Magnum Books\First Men in the Moon, The

    Delete or Move HC.jpg
    From: Pictures\B\Big Wow Art\Mata Hari Escapes
    To: Pictures\B\Big Wow! Art\Mata Hari Escapes

    Delete or Move HC.jpg
    From: Pictures\B\Big Wow Art\Mercenary- The Freelance Illustration of Dan Brereton
    To: Pictures\B\Big Wow! Art\Mercenary- The Freelance Illustration of Dan Brereton

    Delete or Move ALL (TPB 1.jpg - TPB.jpg)
    From: Pictures\A\Avon Books\Overstreet Comic Book Companion, The
    To: Pictures\A\Avon\Overstreet Comic Book Companion, The

    Delete or Move TPB.jpg
    From: Pictures\B\Big Wow Art\Sanjulian- Master of Fantasy Art
    To: Pictures\B\Big Wow! Art\Sanjulian- Master of Fantasy Art

    Delete or Move HC.jpg
    From: Pictures\B\Big Wow Art\Siren- The Bewitching Art of Dan Brereton
    To: Pictures\B\Big Wow! Art\Siren- The Bewitching Art of Dan Brereton

    Delete or Move 1-LE.jpg
    From: Pictures\B\Biomeckazoik\100% Biodegradable Comic Collection
    To: Pictures\B\Biomekazoik\100% Biodegradable Comic Collection

    Delete or Move ALL (1.jpg - 3.jpg)
    From: Pictures\M\Marvel\A\Amazing Spider-Man, The (Pocket Books, 1st Series)
    To: Pictures\P\Pocket\Amazing Spider-Man, The (Pocket Books, 1st Series)

    Delete or Move Bk 1.jpg
    From: Pictures\M\Marvel\C\Captain America (Pocket Books)
    To: Pictures\P\Pocket\Captain America (Pocket Books)

    Delete or Move 1-A.jpg
    From: Pictures\A\Artists Writers & Artisans\Grendel (AWA)
    To: Pictures\A\AWA\Grendel (AWA)

    Delete or Move 1.jpg
    From: Pictures\B\B. F. Goodrich\Johnson Makes The Team
    To: Pictures\B\B.F. Goodrich\Johnson Makes The Team

    Delete or Move Bk 1-LE.jpg
    From: Pictures\G\Graphiti\Madman- Two Trilogies
    To: Pictures\G\Graphitti\Madman- Two Trilogies

    Delete or Move ALL (1.jpg - 1-H.jpg)
    From: Pictures\#\78\Modir
    To: Pictures\#\78Squid\Modir

    Delete or Move 1.jpg
    From: Pictures\A\Automoton Press\Monuments, The
    To: Pictures\A\Automaton Press\Monuments, The

    Delete or Move 1.jpg
    From: Pictures\B\Bricker Down\Other Worlds
    To: Pictures\B\Bricker-Down\Other Worlds

    Delete or Move 1-HC.jpog
    From: Pictures\K\Knockabout\Rime of the Ancient Mariner, The
    To: Pictures\K\Knockabout\Rime of the Ancient Mariner, The (Knockabout)

    Delete or Move ALL (1.jpg - CP 1.jpg)
    From: Pictures\B\BlauArt\Staunch Ambition
    To: Pictures\B\BLauArts\Staunch Ambition

    Delete or Move 1.jpg
    From: Pictures\B\B. F. Goodrich\Tommy Looks at Farming
    To: Pictures\B\B.F. Goodrich\Tommy Looks at Farming

    Delete or Move ALL (1.jpg - 2.jpg)
    From: Pictures\B\B. F. Goodrich\Wonder Book of Rubber
    To: Pictures\B\B.F. Goodrich\Wonder Book of Rubber

    Delete or Move ALL (1.jpg - 10.jpg)
    From: Pictures\Z\Ziff-Davis\Bill Stern's Sports Book
    To: Pictures\Z\Ziff-Davis\Sports Book (Bill Stern's-)

    Delete or Move 1-HC.jpg
    From: Pictures\B\Boom!\Clive Barker's Nightbreed Archive
    To: Pictures\B\Boom!\Nightbreed Archive (Clive Barker's-)

    Delete or Move Bk 1.jpg and Bk 2.jpg
    From: Pictures\M\Marvel\D\Doctor Strange (Mass-Market Paperbacks)
    To: Pictures\P\Pocket\Doctor Strange (Pocket Books)

    Delete or Move ALL (1.jpg - Bk 5.jpg)
    From: Pictures\A\Aredit\Defenseurs, Les (Aredit)
    To: Pictures\A\Aredit-Artima\Defenseurs, Les (Aredit-Artima)

    Delete or Move ALL (1.jpg - 11.jpg)
    From: Pictures\A\Aredit-Artima\Defenseurs, Les (Aredit, 2nd Series)
    To: Pictures\A\Aredit-Artima\Defenseurs, Les (Aredit-Artima, 2nd Series)

    Delete or Move 1.jpg
    From: Pictures\D\DC\E\Ed Wheelan's Joke Book
    To: Pictures\D\DC\J\Joke Book (Ed Wheelan's-)

    Delete or Move 1.jpg and 1-A.jpg
    From: Pictures\C\Carnal Comics\Frank Brunner's Carnal Delights
    To: Pictures\C\Carnal Comics\Carnal Delights (Frank Brunner's-)

    Delete or Move 1.jpg
    From: Pictures\R\Rutgers University\Frank Miller's Daredevil and the Ends of Heroism
    To: Pictures\R\Rutgers University\Daredevil and the Ends of Heroism (Frank Miller's-)

    Delete or Move ALL (1.jpg - 19.jpg)
    From: Pictures\F\Fawcett\George Pal's Puppetoons
    To: Pictures\F\Fawcett\Puppetoons (George Pal's-)

    Delete or Move 1-HC.jpg
    From: Pictures\B\Balzer + Bray\Gris Grimly's Tales From The Brothers Grimm
    To: Pictures\B\Balzer + Bray\Tales From The Brothers Grimm (Gris Gimly's-)

    Delete or Move ALL (1.jpg - 4.jpg)
    From: Pictures\M\Morbid\H.P. Lovecraft's Beauty and the Beast
    To: Pictures\M\Morbid\Beauty and the Beast (H.P. Lovecraft's-)

    Delete or Move Bk 1.jpg and Bk 2.jpg
    From: Pictures\M\Marvel\I\Incredible Hulk, The (Mass-Market Paperback)
    To: Pictures\P\Pocket\Incredible Hulk, The (Pocket Books)

    Delete or Move Bk 1.jpg
    From: Pictures\M\Marvel\I\Infinity Wars- Two-in-One
    To: Pictures\M\Marvel\I\Infinity Warps- Two-in-One

    Delete or Move 1.jpg
    From: Pictures\A\Antarctic\Ippongi Bang's Canvas Diary
    To: Pictures\A\Antarctic\Canvas Diary (Ippongi Bang's-)

    Delete or Move 1-HC.jpg
    From: Pictures\I\Idea + Design Works\Jack Kirby's Marvel Heroes and Monsters
    To: Pictures\I\Idea + Design Works\Marvel Heroes and Monsters (Jack Kirby's-)

    Delete or Move ALL (1.jpg - 4.jpg)
    From: Pictures\T\Top Shelf\James Kochalka's Sketchbook Diaries
    To: Pictures\T\Top Shelf\Sketchbook Diaries (James Kochalka's-)

    Delete or Move 1-HC.jpg
    From: Pictures\D\Dark Horse\J\Jerry and the Joker- Adventures and Comic Art by Jerry Robinson
    To: Pictures\D\Dark Horse\J\Jerry and the Joker- Adventures and Comic Art

    Delete or Move MC 1.jpg
    From: Pictures\J\Joe Matt\Joe Matt's 'Jam' Sketchbook- Feb. 1995 to May 1998
    To: Pictures\J\Joe Matt\'Jam' Sketchbook- Feb. 1995 to May 1998 (Joe Matt's-)

    Delete or Move 1-HC.jpg
    From: Pictures\I\Idea + Design Works\John Buscema's Marvel Heroes
    To: Pictures\I\Idea + Design Works\Marvel Heroes (John Buscema's-)

    Delete or Move 1-HC.jpg
    From: Pictures\I\Idea + Design Works\John Byrne's Marvel Classics Artifacts Edition
    To: Pictures\I\Idea + Design Works\Marvel Classics Artifacts Edition (John Byrne's-)

    Delete or Move 1.jpg
    From: Pictures\K\Kodansha\Junji Ito's Cat Diary- Yon & Mu
    To: Pictures\K\Kodansha\Cat Diary- Yon & Mu (Junji Ito's-)

    Delete or Move 1.jpg
    From: Pictures\C\CPM\Kia Asamiya's Dojinshi Sketchbook
    To: Pictures\C\CPM\Dojinshi Sketchbook (Kia Asamiya's-)

    Delete or Rename 1-A.jpg to 1.jpg then Move
    From: Pictures\B\Big Dog Ink\Let there be Darkness
    To: Pictures\B\Big Dog Ink\Goth-Day- Let there be Darkness
    (NOTE: Not sure if 1-E.jpg in the From: folder is part of this series (not listed in the To: folder) or belongs somewhere else.)

    Delete or Move MC 1.jpg
    From: Pictures\M\Michael Neno\Michael Neno's Dream
    To: Pictures\M\Michael Neno\Dream (Michael Neno's-)

    Delete or Move ALL (1.jpg - 1-C.jpg)
    From: Pictures\I\Idea + Design Works\Mike Zeck's Classic Marvel Stories Artist's Edition
    To: Pictures\I\Idea + Design Works\Classic Marvel Stories Artist's Edition (Mike Zeck's-)


    Delete or Move Bk 1.jpg
    From: Pictures\E\E.C\Mort Drucker's MAD Show-Stoppers
    To: Pictures\E\E.C\MAD Show-Stoppers (Mort Drucker's-)

    Delete or Move 1.jpg
    From: Pictures\B\Bad Habit\Nicholson's Small Press Tirade And Other Works- 1983-1989
    To: Pictures\B\Bad Habit\Small Press Tirade And Other Works- 1983-1989 (Nicholson's-)

    Delete or Move 1.jpg and 1-A.jpg
    From: Pictures\M\Marvel\N\Nightcrawlers (5th Series)
    To: Pictures\M\Marvel\N\Nightcrawlers (Marvel)

    Delete or Move 1.jpg
    From: Pictures\B\Belier\R. Crumb's Carload O'Comics
    To: Pictures\B\Belier\Carload O'Comics (R. Crumb's-)

    Delete or Move 1-HC.jpg
    From: Pictures\F\Fantagraphics\Ronald Searle's America
    To: Pictures\F\Fantagraphics\America (Ronalda Searle's-)

    Delete or Move 1.jpg
    From: Pictures\D\Dover\Sam Glanzman's Attu- The Collected Volumes
    To: Pictures\D\Dover\Attu- The Collected Volumes (Sam Glanzman's-)

    Delete or Move 1.jpg and 1-HC.jpg
    From: Pictures\A\About Comics\Schulz's Youth
    To: Pictures\A\About Comics\Youth (Schulz's-)

    Delete or Rename 1-HC.jpg to HC.jpg
    From: Pictures\M\Marvel\S\Spider-Man- No Way Home-The Art of the Movie

    Delete or Rename 1.jpg to TPB.jpg and 1-A.jpg to TPB-A.jpg
    From: Pictures\M\Marvel\S\Star Wars- The Empire Strikes Back-The 40th Anniversary Covers by Chris Sprouse

    Delete or Move 2-HC.jpg
    From: Pictures\H\Hermes\Walt Kelly's Pogo- The Complete Dell Comics
    To: Pictures\H\Hermes\Pogo- The Complete Dell Comics (Walt Kelly's-)

    Delete or Move 1.jpg
    From: Pictures\K\Kitchen Sink\Will Eisner's 3-D Classics- Spirit
    To: Pictures\K\Kitchen Sink\3-D Classics- Spirit (Will Eisner's-)

    Delete or Move 1.jpg
    From: Pictures\S\Showcase Art\Virgil Finlay's Illustrations for Weird Tales
    To: Pictures\S\Showcase Art\Illustrations for Weird Tales (Virgil Finlay's-)

    Delete or Rename 1-HC.jpg to HC.jpg
    From: Pictures\A\Abstract\Terry Moore 25th Anniversary Sketchbook- 8,888 Days of Blondes, Brunettes, and Bozos

    Rename
    1-A.jpg to 1-B.jpg then 1.jpg to 1-A.jpg
    Delete 2-A.jpg then Rename 2.jpg to 2-A.jpg
    (or Delete 2-B.jpg then Rename 2-A.jpg if it is larger)
    From: Pictures\I\Image\C\Carbon Grey Origins

    Delete or Rename 1.jpg to 1-A.jpg
    From: Pictures\B\Bad Bug\His Name Is Wrath

    Delete 50-D.jpg
    From: Pictures\B\Boom!\Lumberjanes

    Either
    Delete 1-A.jpg
    or
    Delete 1.jpg then Rename 1-A.jpg to 1.jpg
    From: Pictures\M\Marvel\M\Marvel and DC Present
    (the option is with or without the wrap-around cover.)

    Delete 3.jpg - 11.jpg
    From: Pictures\C\Crow\Meanwhile-
    (duplicates of more correct covers at Pictures\S\Soaring Penguin\Meanwhile- (Soaring Penguin) )

    Delete or Rename 3.jpg to 3-A.jpg
    From: Pictures\B\Bad Bug\Midnight Highway

    Rename 2.jpg to 2-A.jpg
    From: Pictures\O\Oni\Rick and Morty Vs. Cthulhu

×
×
  • Create New...