Steven L. Dasinger

It is best when doing Finds to leave off the insignificant articles. CB stores them at the end of the name. Typing 'Call t' brings up the ones you want in the top 5 of the list.

I checked with a usually reliable source (Midtown Comics) and they also 'skipped ...21 and ...31 (at least they have none listed for those UPCs) so cancelling could make sense.

Or, for #1, you could just each of the 4 Updates selecting only 1 Type each time (with the optimize database) and not have to do math.

For #1, you can get the current size by running 4 Updates. 1) Create a New database. 2) Run Update (making sure to check ALL for types). 3) Run File Tools, Optimize Database (to endure the database is as small as it can get) 4) Use File Explorer to find the size of the Database with all 4 types and record it some where Repeat Steps 2-4 but remove one type from the Update (i.e. Newspapers, then Books, then Magazines) each time you process an update. After the fourth Update you should have a list of database size with Just Comic Books Comic Books and Books Comic Books, Books and Magazines All 4 Types. A little subtraction will get you the size needed for each Type (for example All 4 Types Size minus 3 Types (Comic Books, Books, Magazines) = Newspaper size). PS If not know, you can force an Update by holding down the SHIFT key while checking for Updates. As for #2, I am not sure if A) they want to supply the information or B) they don't have time to try to figure all that out from all the various tables/indexes. What I can tell you is the actual data tables are relative small (1/10 the size of the database?). But there are a LOT of indexes to speed up process, accommodate Psychic Typing and drop-down boxes. There is also space needed to store all the queries needed for reports and regular finds but they should take up much space.

I am not an expert at this but looking at all the covers that MyComicShop has for Canadian Incredible Hulk, I did find a common theme. All of the covers had a single Price (75￠). The US series has multiple prices (75￠US, 95￠Can) I did find a couple of exceptions but in those cases the Canadian prices were more (US Issue #295 60￠, Canadian issue #295 75￠) If it is true (and I am just basing this on the cover), then yours would be US newsstand versions. (possible the Canadian ones have a slightly different indicia but I don't have any to check.)

Just to clarify this statement a little bit, It defaults to the lowest number in a TEXT sort order. If it was a NUMERIC sort order and you had covers for issues 2 - 20, the cover displayed would be 2. But with the TEXT sort order in CB, if you had covers for Issues 2 - 20, the cover displayed would be 10 (i.e 10, 11, 12, 13, 14, 15, 16. 17. 18, 19, 2, 20 (note position of #2)) Even stranger, if you had a set of covers for 2-9, 20-100 (skipping all the other issues that have a 1 at the beginning), the displayed cover would be 100. This also means, if you had -2 and 1 with covers, 1 would be the displayed cover and not -2. This makes no difference to your Feature suggestion. Just explaining what CB is really doing.

To do that, just click in any cell in the grid. That will remove the focus and the Title info will be displayed.

I believe it only goes by Width and Height not size. I am not sure how much bigger it has to be to allow replacement. You will probably have to wait until Pete gets back from vacation to get specifics.

The grid does allow for a drop-down box and currently has them for Condition and Currency. They don't show up until you click in the cell.

I think you are fine. As I said, there was a problem with the automatic options replacing any cover (regardless of size) but I think it was fixed. Just haven't tested it out recently.

There, sort of, already is. Instead of clicking the Find down-down box to the left of the Find text box, click on the Magnifying glass icon to the right. This will bring you your last Find (whether Regular or Advanced).

Interesting option. Currently, there is nothing like this in CB so you are missing something.

The Update Options (when you manually start an Update in CB or in Sidekick) there is a check box 'Replace smaller existing pictures'. If you Uncheck this, it shouldn't replace any covers. If you Check it, it should only replace covers that are smaller in your database than the one the Update has. (Also, the Update only has covers for that particular Update and not the entire database.) However, if you manually select one or more issues, right-click and select Download covers, it will download and replace (regardless of size) the current one in the database. NOTE: This may or may not still be the case. There was some discussion about it and I don't recall the specifics. Additionally, in ComicBase Preferences, there is a check box for 'Automatically download larger pictures when viewing them'. This is mainly for those who chose the Quick Start Picture install (a process that only loads thumbnail size covers saving time and space. Then, when you view a cover it will automatically download and display the full size cover). However, it, too, had some issues about downloading and replacing any cover (regardless of size). Again, this may have been fixed but I don't use this process to be sure. PS to ensure this process work for the best, you should run the Rebuild Lists for Picture files to ensure all the picture size information is populated.

If the same updates were applied to two different databases, they 'could' have the same Ids as they should be applied in the same order in both updates. But it is not guaranteed. Barcode or QRCode in your database wouldn't make a difference. Both would uniquely identify an issue in a single database or could have problems over multiple databases. The only way to get a 'common' unique code for an issue regardless of which database would be for HC to add a new column and store this unique identifier in the master database which would then Update everyone's databases with the same unique number. Even then, due to human error, there could be problems with that method. The only real way to use barcodes with multiple databases is to print the barcode labels from both databases.

CB generates the UPC for each issue and doesn't use the UPC any issue may have. Correct. IDs are only relevant to a single database. However, if you make a copy (or use a backup) of a database, then the Ids will be the same (at the time of the copy or backup). The various Unique Ids in a database are generated by that database and are not populated through the update process. It depends. If you add/delete issues to different databases, then you can't be sure the same Ids will be assigned to the same issues. But if you only add/delete issues to a single database then make copy/backups, then the ids would be the same across all databases. Theoretically, if you start with identical databases, and added Issues in the same order to them, then they should generate the same Id for the issues in each database. I would need to know more about how you work with you databases to be more specific.

While waiting for this feature, a work-around is: Use Add by Barcode Change the Qty value to 0 With the 'Display items after saving' checked, you will get a list of the scanned in items that you can do Quick Change on and it won't change the Qty value already in the database.

Use Report->Price Labels In the list of check-boxes, there is 'Include barcodes' This will include a CB generated barcode on the label. Not sure of the exact composition. Here is what the scanner sees on the one I just generated: B4600003D The number is the unique issue id (even if you have mulitple issue for the same number, each will be unique). I think the first letter can be 'A' for Books, 'B' for Comic Books, 'C' for Magazines and 'D' for Newspapers. Not sure what the last letter represents. PS My barcode scanner read the generated barcode with no problem.

All of these have qualify for Comic Books after seeing inside them: 'Mad about Mad!' 'MAD as the Devil!' 'MAD’s Don Martin Cooks Up More Tales' 'MAD’s Don Martin Steps Further Out' 'MAD’s Maddest Artist Don Martin Drops 13 Stories' 'Kittycat’s Motor Is Running' 'Oops! We’re Out of Juice!' 'Pick Up What Things?' 'Pick Up What Things?' 'Wanna Be Smiled At?' 'Who Invented Rain?' And so does 'Large and Lovable Marmaduke' I couldn't see inside this one but it is just like all the other MAD books and should also qualify for Comic Books: 'MAD Marginals'

The problem is the difference between what is actually stored in the table and what is displayed in the program. The table has the abbreviation (i.e. US) while the display is 'United States' PS In Advanced Find it would be (for Comic Books): ComicTitles.CountryCode IS NOT 'US'

Delete or Rename Dlx 1-HC.jpg to then Move From: Pictures\M\Marvel\S\Spectacular Spider-Man, The To: Pictures\M\Marvel\S\Spectacular Spider-Man Omnibus, The Delete or Move HC.jpg From: Pictures\T\Tor\Apex (Tor) To: Pictures\H\Hyperion\Apex (Hyperion) Delete or Move HC.jpg From: Pictures\T\Tor\Elite (Tor) To: Pictures\H\Hyperion\Elite (Hyperion) Delete or Rename 1.jpg to TPB.jpg then Move From: Pictures\N\Necronomicon Press\Index To The Fiction & Poetry Of H. P. LovecraFT To: Pictures\N\Necronomicon Press\Index to the Fiction & Poetry of H. P. Lovecraft, An Delete or rename HC.jpg to 1-HC.jpg then Move From: Pictures\L\Lucus\Star Wars Darth Vader and Son To: Pictures\C\Chronicle\Darth Vader and Son Delete or Rename HC.jpg to 1-HC.jpg then Move From:Pictures\C\Chronicle\Star Wars Vader Family Sithmas To: Pictures\C\Chronicle\Star Wars Vader Family Sithmas, A Delete or Rename HC.jpg to 1-HC.jpg then Move From: Pictures\L\Lucus\Star Wars Vader's Little Princess To: Pictures\C\Chronicle\Vader's Little Princess Delete or Move ALL (1.jpg - 1-G.jpg) From: Pictures\C\Codex\Ace & Starlet To: Pictures\C\Codex Entertainment\Ace & Starlet Delete or Move 1-A.jpg From: Pictures\C\Codex\Nebula Pearl To: Pictures\C\Codex Entertainment\Nebula Pearl Delete or Move 1.jpg From: Pictures\C\Cat Head\BugHouse From the Top- The Complete BugHouse To: Pictures\C\Cat-Head\BugHouse From the Top- The Complete BugHouse Delete or Move 1.jpg From: Pictures\C\Cat Head\Category Zero- Conflict To: Pictures\S\Scout\Category Zero- Conflict Delete or Move 1-HC.jpg From: Pictures\C\Cat Head\Cat Suit- Comix Stories by Steve Lafler To: Pictures\C\Cat-Head\Cat Suit- Comix Stories by Steve Lafler Delete or Move 1-HC.jpg From: Pictures\C\Canterbury Classics\Call of Cthulhu and Dagon, The (H.P. Lovecraft's-) To: Pictures\C\Canterbury\Call of Cthulhu and Dagon, The (H.P. Lovecraft's-) Delete or Move 1.jpg From: Pictures\C\Catachetical Guild\Jude, the Forgotten Saint To: Pictures\C\Catechetical Guild\Jude, the Forgotten Saint Delete or Move 1.jpg From: Pictures\C\Catachetical Guild\Labor is a Partner To: Pictures\C\Catechetical Guild\Labor is a Partner Delete or Move 1.jpg From: Pictures\C\Casssava Republic Press\On Ajayi Crowther Street To: Pictures\C\Cassava Republic\On Ajayi Crowther Street Delete or Move ALL (1.jpg - 2-6.jpg) From: Pictures\C\Chick Publications\Sword Series To: Pictures\C\Chick\Sword Series Delete or Move ALL (1.jpg - SE 1990.jpg) From: Pictures\C\CPL-Gang Publications\Witzend To: Pictures\W\Wallace Wood\Witzend Delete or Move ALL (15.jpg - 53.jpg) From: Pictures\C\Cost of Paper Comics\YEET Presents To: Pictures\C\Cost of Paper\YEET Presents Delete or Move 1.jpg From: Pictures\C\Cat-Head\40 Forty Man To: Pictures\C\Cat-Head\40 Hour Man Delete or Move 1-HC.jpg and 2-HC.jpg From: Pictures\D\DC\A\Absolute Swamp Thing To: Pictures\D\DC\A\Absolute Swamp Thing by Alan Moore Delete or Move ALL (1.jpg - 45.jpg) From: Pictures\A\Aredit-Artima\Big Boy (Aredit -Artima) To: Pictures\A\Aredit-Artima\Big Boy (Aredit-Artima) Delete or Move 1.jpg and 2.jpg From: Pictures\C\Comico\Jam Super Cool Color-Injected Turbo Adventure from Hell To: Pictures\C\Comico\Jam, The- Super Cool Color-Injected Turbo Adventure from Hell! Delete or Move 1.jpg and 1-A.jpg From: Pictures\C\Coffin\Lady Death Enhancments To: Pictures\C\Coffin\Lady Death- Enchantments Delete or Move 1-A.jpg and 1-B.jpg From: Pictures\D\DC\N\Nubia and the Justice League Special To: Pictures\D\DC\N\Nubia & the Justice League Special Delete or Move ALL (25.jpg - 81.jpg) From: Pictures\C\Cap\SexBulles To: Pictures\C\Cap\Sex Bulles Delete or Move ALL (1.jpg - 1721.jpg) From: Pictures\H\Hello Limited\Hello! To: Pictures\H\Hello Limited\Hello! (Hello Limited) Delete or Rename TPB 2.jpg to Staple 1.jpg then Move From: Pictures\U\Unknown\Magic of Frank Frazetta, The To: Pictures\R\Russ Cochran\Magic of Frank Frazetta, The Delete or Rename TPB.jpg to Staple.jpg then Move From: Pictures\F\Frank Frazetta\More Magic of Frank Frazetta To: Pictures\R\Russ Cochran\More Magic of Frank Frazetta Delete or rename Rename 1.jpg to TPB.jpg From: Pictures\B\Bantam\BlackMark Delete or Rename 1.jpg to TPB.jpg From: Pictures\F\Fantagraphics\Blackmark 30th Anniversary Edition Delete or Rename HC.jpg to 1-HC.jpg From: Pictures\C\Chronicle\Goodnight Darth Vader Delete or Rename MMPB.jpg to 1.jpg From: Pictures\F\Fawcett\I Could Hear Chewing Delete or Rename MMPB.jpg to 1.jpg From: Pictures\F\Fawcett\It's Muddy Out Today Delete or Rename 1.jpg to TPB.jpg From: Pictures\C\Coffin\Art of Hellwitch vs. Lady Death, The- Wargasm Delete or Rename 1.jpg to TPB.jpg From: Pictures\S\Signet\Cycle of the Werewolf Delete or Rename 1-HC.jpg to HC.jpg From: Pictures\C\Clover\Diablo House (Clover) Delete or Rename Bk 1.jpg to MMPB 1.jpg Bk 2.jpg to MMPB 2.jpg Bk 3.jpg to MMPB 3.jpg From: Pictures\B\Boulevard\Doom's Day Delete or Rename Bk 1.jpg to MMPB.jpg From: Pictures\B\Boulevard\Fantastic Four- Countdown to Chaos Delete or Rename 1-HC.jpg to HC.jpg From: Pictures\C\Clover\Fishhead- The Art of Ray Troll Delete or Rename Bk 1-HC.jpg to HC.jpg From: Pictures\B\Boulevard\Incredible Hulk- What Savage Beast Delete or Rename 1.jpg to TPB.jpg From: Pictures\C\Chicago Review Press\Investigating Lois Lane Delete or Rename 1-HC.jpg to HC.jpg From: Pictures\C\Coffin\Lady Death- Homages! Delete or Rename Bk 1.jpg to MMPB.jpg From: Pictures\B\Boulevard\Spider-Man- Goblin's Revenge Delete or Rename 1.jpg to TPB.jpg From: Pictures\B\Boulevard\Untold Tales of Spider-Man (Boulevard) Delete or Rename TPB.jpg to MMPB.jpg From: Pictures\B\Boulevard\X-Men- Empire's End Delete or Rename TPB.jpg to MMPB.jpg From: Pictures\B\Boulevard\Iron Man- Operation A.I.M Delete or Rename TPB.jpg to MMPB.jpg From: Pictures\B\Boulevard\Iron Man- The Armor Trap Delete or Rename TPB.jpg to MMPB.jpg From: Pictures\B\Boulevard\Spider-Man- Goblin Moon Delete or Rename TPB.jpg to MMPB.jpg From: Pictures\B\Boulevard\Spider-Man- Wanted Dead or Alive Delete 1-A.jpg From: Pictures\C\Claypool\Elvira, Mistress of the Dark Delete 1-V27.jpg From: Pictures\C\Coffin\Lady Death- Scorched Earth (Duplicate of 1-Z-2.jpg)

These all appear to be the same title with the 'shoe' variants': GCD https://www.comics.org/series/20230/ Comicbook Realm https://comicbookrealm.com/series/25828/0/charlton-comics-black-fury-blue-bird-shoe-comics MyComicShop https://www.mycomicshop.com/search?TID=529281 I don't know that any one of them is a complete set but merged to together, it should be a good start.

I found a list here ( http://tickcomics.com/comic_con.html) of what looks like most (if not all) of the Tick comics for convention exclusives (as well as listing a LOT of Tick issues. Maybe it will help getting them into CB.

Part 2 (must have been too early with my update and a another version became available. Delete TPB.jpg From: Pictures\B\Berkley\Generation X- Genogoths Delete TPB.jpg From: Pictures\B\Berkley\Lost Valley of Iskander, The (Berkley) Delete TPB.jpg From: Pictures\B\Berkley\Marchers of Valhalla (Berkley) Delete TPB.jpg From: Pictures\B\Berkley\Second Book of Robert E. Howard, The Delete TPB.jpg From: Pictures\B\Berkley\Skull-Face (Berkley) Delete TPB.jpg From: Pictures\S\Scholastic\Star Wars Episode I Adventures (Scholastic) Aslo, the 'Doctor Who and the Zarbi' title have been fixed to just have a MMPB issue.

Delete or Move 1.jpg From: Pictures\B\Balzer & Bray\Becoming Brianna To: Pictures\B\Balzer + Bray\Becoming Brianna Delete or Move 1-HC.jpg From: Pictures\B\Balzer & Bray\Gris Grimly's Tales From The Brothers Grimm To: Pictures\B\Balzer + Bray\Gris Grimly's Tales From The Brothers Grimm Delete or Move 1.jpg From: Pictures\B\Balzer & Bray\Invisible Emmie To: Pictures\B\Balzer + Bray\Invisible Emmie Delete or Move 1.jpg From: Pictures\B\Balzer & Bray\Just Jaime To: Pictures\B\Balzer + Bray\Just Jaime Delete or Move 1-HC.jpg From: Pictures\B\Balzer & Bray\Sir Ladybug To: Pictures\B\Balzer + Bray\Sir Ladybug Delete or Move 1-A.jpg & 1-B.jpg From: Pictures\A\American Mythology\Zorro- A Century of Swashbuckling To: Pictures\A\American Mythology\Zorro Masters (Vol. 2) Rename 1-D.jpg to 1-E.jpg 1-A.jpg to 1-B.jpg 1.jpg to 1-A.jpg 2.jpg to 2-A.jpg From: Pictures\D\Dark Horse\O\Ones, The For the rest it would probably be best to delete the current cover and download the corrected ones. If not All the title had all issues changed from TPB to MMPB issue except one. 'Doctor Who The Scripts' issues change from MMPB to TPB Additionally, 'Doctor Who and the Zarbi' should have just MMPB but mistakenly got changed (or missed) to TPB 1. This should be corrected to MMPB with next update. Doctor Who and the Dinosaur Invasion Doctor Who and the Web of Fear Doctor Who BBC Books Novelizations Doctor Who Eighth Doctor Adventures Novelizations Doctor Who Find Your Fate Doctor Who Make Your Own Adventure Doctor Who Missing Adventures Doctor Who Past Doctors Adventures Novelizations Doctor Who Pinnacle Novelizations Doctor Who Quiz Book Series Doctor Who Target Books Activity Books Doctor Who Target Books Junior Doctor Who Target Books Miscellaneous Books Doctor Who Target Books Novelizations Doctor Who Target Books Reference Books Doctor Who Target Books The Companions Novelizations Doctor Who Target Books The Missing Episodes Novelizations Doctor Who Target Non-Fiction Doctor Who Target Novelisations Doctor Who The Handbook Doctor Who The Missing Adventures Novelizations Doctor Who The New Adventures Doctor Who The New Adventures Novelizations Doctor Who The Novel of the Film Doctor Who The Script of the Film Doctor Who: Battlefield Doctor Who: Genesis of the Daleks Doctor Who: The Visitation Doctor Who: Vengeance on Varos PS You may notice some duplication and other problems (lumping non-numbered (or unrelated) books in to a single title (i.e. 'Doctor Who Target Books Miscellaneous Books')) which I didn't attempt to correct at this time.

Can you attach a cover scan (or a link to the cover)? I 'think' it might be in 'Tick 2017, The) as #0 (or 0/A). This looks like a mis-used title. #0 has a cover date of 2018, #1 2017 (and a B variant with 2018), #2 2017, #3 and #4 2018. Based on the progression, I would l think #0 should be 2016 but with this Title I can't be sure.