Jump to content
ComicBase User Community

Steven L. Dasinger

Moderators
 View Profile  See their activity

  • Posts

    1,530

  • Joined

  • Last visited

  • Days Won

    73

 Content Type 

Posts posted by Steven L. Dasinger

    We Don't Kill Spiders #1/Q

    in Content and Corrections

    Posted

    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).

    Cover Scan Maintenance 2023-02-23

    in Content and Corrections

    Posted

    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

    Recording a connecting cover

    in Content and Corrections

    Posted

    Item Description is just a text field. If you have more than one item (separated by semi-colon), the only way to ensure a certain sequence is programmatically.

    Which means someone (Pete) would have to write a process to try to identify a particular string, they manipulate the data to get a certain order.

    Not saying it can't be done, but it may not be worth the time an effort.

    Excel Hole Finder

    in News & General Discussion

    Posted

    Downloaded and followed steps.
    Encounter the following problems.
    When click on Refresh, Error Message:
    Initialization of the data source failed...

    A) Can you supply the steps/options to define a new Connection?
    OR
    B) It looks like Tab Item Checklist is a list of your data.
    Can I replace yours with copy/Paste?

     

    Manual comic titles disappear from collection

    in Tech Support

    Posted

    My guess is that in you Update options, you have 'Remove Obsolete Series' and/or 'Remove Obsolete Items' checked (in CB or in SideKick). See Attached.
    If you do, whenever you run an Update, CB will delete Issues or Titles if they are not in the Master Database. The exception is if you have QTY set to 1 or more. The is will NOT delete them.

    Update Options.JPG

    unable to duplicate in comics

    in Tech Support

    Posted

    That helps. I am able to recreate your problem. (I didn't save before since I didn't really want a duplicate).

    Select a row.

    Select Duplicate.

    Make a change (to create a another issue (i.e. Condition or, Type or Variation)).

    Click Save.

    Nothing happens. No issues is created.

    I have left the title and returned (to refresh) and still no new issue.

    I have run Rebuild lists Issue Information and still no new issue.

     

    unable to duplicate in comics

    in Tech Support

    Posted

    Unless you download the update to install it (as opposed to doing it through the program), I am not sure there is a way to roll back the change to the previous build.

    Do you use the Menu option (Edit->Duplicate), CTRL+D or Right-Click and select from the pop-up menu?

    Is the option 'grayed' out?

    Can you select it but nothing happens?

    (I will mention this, just to get it out of the way as it sounds like you have used Duplicate before, but you have to select/high-light the entire row to activate the Duplicate option.)

    And for comparison, I just updated to the same build and I can still use Duplicate.

    S/series

    in Content and Corrections

    Posted

    The following seems to respect the case of the search. It at least works to find ' series)'. Not sure how easy/difficult it is to alter it for general use in Case Sensitive finds.

    INSTR(I.Title, ' series)') > 0

    Returns 1,572 rows

    INSTR(I.Title, ' Series)') > 0

    Returns 122,658 rows

    INSTR searches the first parameter (I.Title in this example) for the second parameter (' series)' ) and returns either 0 if not found or the number of its position in the first parameter.

    Not sure why it works but it appears to.

    Grimm Fairy Tales P/presents...

    in Content and Corrections

    Posted

    23 minutes ago, Fred Slota said:

    Also, Grimm Fairy Tales Realm Wars Age of Darkness is the only title not using a subtitling ":", and so might properly be "Grimm Fairy Tales Realm Wars: Age of Darkness"

    The indicia does NOT use the colon ( : ) in the title for this one.

    Also, the several I spot-checked all had lower-case 'p' for 'presents'.

    Advanced Searches

    in Tech Support

    Posted

    This one will return only 1 Title/Issue per distinct named *ptych' name set.

     

    I.CustomField3 LIKE '%ptych%' AND
    I.Title || I.ItemNumber in (
          Select C.Title || C.ItemNumber
          From (Select B.Title , Min (B.ItemNumber) as ItemNumber
                From ComicIssues B
                WHERE B.CustomField3 LIKE '%ptych%'
                  AND B.Title in (
                                  SELECT Min(A.Title) as Title
                                  FROM ComicIssues A
                                  WHERE A.CustomField3 LIKE '%ptych%'
                                  Group by A.CustomField3
                                 )  
                Group by B.Title
               ) as C
             )

     

    Advanced Searches

    in Tech Support

    Posted

    This works with some restrictions.
    If you have multiple 'ptych' set of the same name, you will only get 1 row for that set name.
    For example
    9-ptych for Carnage titles.
    9-ptych for Fantastic Four titles

    You will ONLY get one of them (either Carnage or Fantastic Four) and not both.

    If you have multiple 'ptych' sets of different names, you will get 1 row for each of the different set names.
    For example
    9-ptych for Carnage titles
    4-ptych for Fantastic Four titles

    You will get 1 title for each of the sets (both Carnage and Fantastic Four) for a total of 2 rows.


    I.CustomField3 LIKE '%ptych%' AND
    I.Title in (
                SELECT Min(A.Title) as Title
                 FROM ComicIssues A
                 WHERE A.CustomField3 LIKE '%ptych%'
                 Group by A.CustomField3
                )

    Advanced Searches

    in Tech Support

    Posted

    Short answer is No. Every row in CB has a unique ID (which is why the Group By box was useless and removed).

    However, if you can be more specific with data, examples, and desired results, I may be able to find a way around this.

×
×
  • Create New...