Steven L. Dasinger

Ronald, this is good and should be useful. But I think Fred is looking for both Missing and Owned issues in the Titles he owns.

Try this in the Where of an Advanced Find: I.Title IN ( SELECT A.Title FROM ComicIssues A WHERE A.QtyInStock>= 1 GROUP BY A.Title ) This is a basic query to find ALL Titles that you have at least 1 owned Issued and return ALL Issues for those Titles. More can be added and you can Order By whatever you like.

One possibility is to use the Marked check box on the Title edit window and check all of your Owned Titles. Unfortunately, you have to do this one at a time. (If I find time, I may be able to come up with a Advanced Find that will get around this. Will need to test it.) Once that is done, you can use Advanced Find to retrieve all the issues you need. On the Find result grid, you can select some or all of the cells, use CTRL+C to copy the information, then CTRL+V to paste into Excel. From what I am reading from your post, you want ALL Issues from ALL Titles that you own at least 1 issue in. Is this correct? PS for selecting the information you want, it is easier if all the columns you want are close together. If not, you would just delete what you don't want in Excel.

Delete or Move MMPB.jpg and TPB.jpg From: Pictures\B\Byron Preiss\Generation X (Byron) To: Pictures\B\Boulevard\Generation X (Byron) Delete or Move HC>jpg and TPB.jpg From: Pictures\B\Byron Preiss\X-Men- Codename Wolverine To: Pictures\B\Berkley\X-Men- Codename Wolverine Delete or Move MMPB.jpg From: Pictures\B\Byron\X-Men- Law of the Jungle To: Pictures\B\Berkley\X-Men- Law of the Jungle Delete or Move ALL (HC 1.jpg - MMPB 3.jpg) From: Pictures\B\Byron Preiss\X-Men- Mutant Empire To: Pictures\B\Berkley\X-Men- Mutant Empire Delete or Move MMPB.jpg From: Pictures\B\Byron Preiss\X-Men- The Jewels of Cyttorak To: Pictures\B\Boulevard\X-Men- The Jewels of Cyttorak Delete or Rename MMPB.jpg to 1.jpg From: Pictures\F\Fawcett\Kittycat's Motor Is Running Delete or Rename MMPB.jpg to 1.jpg From: Pictures\S\Signet\MAD About MAD! Delete or Rename MMPB.jpg to 1.jpg From: Pictures\W\Warner\MAD as the Devil! Delete or Rename MMPB.jpg to 1.jpg From: Pictures\W\Warner\MAD Marginals Delete or Rename MMPB.jpg to 1.jpg From: Pictures\S\Signet\MAD's Don Martin Cooks Up More Tales Delete or Rename MMPB.jpg to 1.jpg From: Pictures\W\Warner\MAD's Don Martin Steps Further Out Delete or Rename MMPB.jpg to 1.jpg From: Pictures\S\Signet\MAD's Maddest Artist Don Martin Drops 13 Stories Delete or Rename MMPB.jpg to 1.jpg From: Pictures\F\Fawcett\Oops! We're Out of Juice! Delete or Rename MMPB.jpg to 1.jpg From: Pictures\F\Fawcett\Pick Up What Things- Delete or Rename MMPB.jpg to 1.jpg From: Pictures\S\Signet\Viva MAD! Delete or Rename MMPB.jpg to 1.jpg From: Pictures\F\Fawcett\Wanna Be Smiled At- Delete or Rename MMPB.jpg to 1.jpg From: Pictures\F\Fawcett\Who Invented Rain- Delete or Move 1.jpg From: Pictures\C\Classical\Christmas Carol, A To: Pictures\C\Classical Comics\Christmas Carol, A Delete or Move 1.jpg From: Pictures\C\Classic\Dondi To: Pictures\C\Classic Comics\Dondi Delete or Move ALL (1.jpg - 704.jpg) From: Pictures\#\1982-1994\Fuego To: Pictures\E\Editora Cinco\Fuego Delete or Move ALL (Bk 1.jpg - Bk 3.jpg) From: Pictures\C\CreateSpace\Galacticat To: Pictures\C\CreateSpace Independent\Galacticat Delete or Move ALL (1.jpg - 3.jpg) From: Pictures\B\Buenaventura Press\Injury Comics To: Pictures\B\Buenaventura\Injury Comics Delete or Move 1-HC.jpg From: Pictures\C\Classic\Lance- The Complete Collection To: Pictures\C\Classic Comics\Lance- The Complete Collection Delete or Move 1.jpg From: Pictures\C\CreateSpace\Mr. Awkward To: Pictures\C\CreateSpace Independent\Mr. Awkward Delete or Move 1.jpg From: Pictures\B\Burcham Studios\Stargators To: Pictures\B\Burcham\Stargators Delete or Move ALL (1.jpg - 1-L.jpg) From: Pictures\M\Marvel\A\AXE- Eve of Judgment To: Pictures\M\Marvel\A\A.X.E.- Eve of Judgment Delete or Move 1.jpg From: Pictures\D\DC\B\Batman- The Penguin To: Pictures\D\DC\B\Batman Arkham- Penguin Delete or Rename 1.jpg to 33/A.jpg then Move From: Pictures\C\Charlton\Beetle Bailey Complimentary Copy (1970 Cerebral Palsy Giveaway) To: Pictures\C\Charlton\Beetle Bailey (Vol. 1) Delete or Move Bk 1.jpg and Bk 1-2.jpg From: Pictures\D\Dark Horse\C\Concrete- Short Stories 1986-1989 To: Pictures\D\Dark Horse\C\Concrete- Complete Short Stories 1986-1989 Delete or Rename 1-LE.jpg to Bk 1-LE.jpg then Move From: Pictures\D\Dark Horse\C\Concrete- The Complete Short Stories To: Pictures\D\Dark Horse\C\Concrete- Complete Short Stories 1986-1989 Delete or Move 1-HC.jpg From: Pictures\D\Dark Horse\E\E.C. Archives, The- Valor To: Pictures\D\Dark Horse\E\EC Archives, The- Valor Delete or Move 1-HC.jpg From: Pictures\D\Dark Horse\E\E.C. Archives- Aces High To: Pictures\D\Dark Horse\E\EC Archives, The- Aces High Delete or Rename 1-HC.jpg to HC.jpg From: Pictures\D\Dark Horse\E\E.C. Archives- Crime Illustrated Delete or Move 1-HC.jpg From: Pictures\D\Dark Horse\E\E.C. Archives- Impact To: Pictures\D\Dark Horse\E\EC Archives, The- Impact Delete or Move 1-HC.jpg From: Pictures\D\Dark Horse\E\E.C. Archives- Incredible Science Fiction To: Pictures\D\Dark Horse\E\EC Archives, The- Incredible Science Fiction Delete or Move 1-HC.jpg From: Pictures\D\Dark Horse\E\E.C. Archives- Modern Love To: Pictures\D\Dark Horse\E\EC Archives, The- Modern Love Delete or Move 1-HC.jpg and 2-HC.jpg From: Pictures\D\Dark Horse\E\E.C. Archives- Panic To: Pictures\D\Dark Horse\E\EC Archives, The- Panic Delete or Move 1-HC.jpg From: Pictures\D\Dark Horse\E\E.C. Archives- Piracy To: Pictures\D\Dark Horse\E\EC Archives, The- Piracy Delete or Move 1-HC.jpg From: Pictures\D\Dark Horse\E\E.C. Archives- Psychoanalysis To: Pictures\D\Dark Horse\E\EC Archives, The- Psychoanalysis Delete or Move 1-HC.jpg From: Pictures\D\Dark Horse\E\E.C. Archives- Saddle Justice To: Pictures\D\Dark Horse\E\EC Archives, The- Saddle Justice Delete or Rename 1-HC.jpg to HC.jpg From: Pictures\D\Dark Horse\E\E.C. Archives- Shock Illustrated Delete or Move ALL (1.jpg - 5-HC.jpg) From: Pictures\D\Dark Horse\E\E.C. Archives- The Haunt of Fear To: Pictures\D\Dark Horse\E\EC Archives, The- The Haunt of Fear Delete or Move 1.jpg and 2.jpg From: Pictures\D\Dark Horse\E\E.C. Archives- The Vault of Horror (2nd Series) To: Pictures\D\Dark Horse\E\EC Archives, The- The Vault of Horror (2nd Series) Delete or Move 1-HC.jpg and 2-HC.jpg From: Pictures\D\Dark Horse\E\E.C. Archives- War Against Crime To: Pictures\D\Dark Horse\E\EC Archives, The- War Against Crime Delete or Move ALL (1-HC.jpg - 4-HC.jpg) From: Pictures\D\Dark Horse\E\E.C. Archives- Weird Fantasy To: Pictures\D\Dark Horse\E\EC Archives, The- Weird Fantasy Delete or Rename 1-HC.jpg to HC.jpg then Move From: Pictures\D\Dark Horse\E\EC Archives, The- Confessions Illustrated To: Pictures\D\Dark Horse\E\E.C. Archives, The- Confessions Illustrated Delete or Rename Bk 1.jpg to Bk 1-LE.jpg then Move From: Pictures\B\Byron Preiss\Empire (Byron Preiss) To: Pictures\B\Berkley\Empire (Berkley) Delete or Move ALL (1-HC.jpg - 3-HC.jpg) From: Pictures\D\Dark Horse\I\Inside Moebius To: Pictures\D\Dark Horse\M\Moebius Library- Inside Moebius Delete or Move 1.jpg From: Pictures\D\DC\S\Sandman Presents, The- Dead Boy Detectives (2nd Series) To: Pictures\D\DC\S\Sandman Universe, The- Dead Boy Detectives Delete or Move 2.jpg From: Pictures\C\Creators\Scary Gary To: Pictures\C\Creators\More Jokes About Violence and Food- A Scary Gary Collection Delete or Move 1-HC.jpg From: Pictures\C\Chronicle\Star Wars Vader Family Sithmas, A To: Pictures\C\Chronicle\Vader Family Sithmas, A Rename TPB-A.jpg to HC-A.jpg and TPB-B.jpg to HC-B.jpg From: Pictures\A\American Fantasy\Collector's Book of Virgil Finlay, The Rename TPB.jpg to Staple.jpg From: Pictures\N\Necronomicon Press\Index to the Fiction & Poetry of H. P. Lovecraft, An Rename TPB.jpg to HC.jpg From: Pictures\C\Cider Mill\Lois Lane's Dating Handbook Rename Staple 1.jpg to Staple.jpg From: Pictures\R\Russ Cochran\Magic of Frank Frazetta, The Delete 1.jpg From: Pictures\D\DC\B\Batman Begins (duplicate of MC 1.jpg) Delete or Rename 1.jpg to 1-A.jpg and 2.jpg to 2-HC.jpg From: Pictures\M\Marvel\F\Fantastic Four by John Byrne Omnibus Delete or Rename 1.jpg to 1-A.jpg From: Pictures\B\Black Mask\Rogue State Delete or Rename 1.jpg to 1-A.jpg From: Pictures\A\AfterShock\Tales of Mother F. Goose

Can you give exact steps and options used?

I will add a little more detail. With Series I Own selected and ONLY Missing Items checked, when you click Preview, the window just closes and nothing happens. With Select Series selected, a few series manually selected (doesn't matter if you own any issues in them or not), and Items in My Collection and /or Missing Items checked, when you click Preview, it works and you get what you would expect. Only when you select the radio button 'Series I Own' does the Missing Items NOT get displayed or process if that is the only box checked).

I agree. I have come across on several series. Currently it would have to be in the one field. Not sure if that would make Finds harder or not.

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'