Steven L. Dasinger

If you haven't already, try downloading the most current update to the program. Per the CB live-stream, Pete in increased the Printing from 500 to (I think) 10,000. That should fix your access problem. Hopefully the covers ill then be displayed (and if they do, I would 'Show Picture File' and see where they actually were.

First, I have not used any of these and don't print labels. So this is just information. Looking at the Label Report in CB, it has 5 Avery labels listed to select from. They are, along with Number of Labels per sheet and size, are: Label Labels/Sheet Size Avery 5160/5260 30 1" x 2 5/8" Avery 5161/5261 20 1" x 4" Avery 5162/5262 14 1 1/3" x 4" Avery 5163/5263 10 2" x 4" Avery 5164/5264 6 3 1/3" x 4" I would think any of these would work. The info on the Avery website indicates 'optimized for laser printers' but I think they should work in a inkjet printer.

Normally CB will NEVER delete any cover scans (it may, in certain situations overwrite one). If it did, this would be highly unusual as there shouldn't even be code in the program to do it.

You are correct. Need Advanced Find but it isn't something you can select. You have to type it in yourself. One more slightly off topic comment. When deciding on which Edition of CB to get, the Pro Edition indicates it has 50,000 covers. But what surprises some people is that is spread over 60,000+ Titles. This ends up with 1 (maybe 2) cover per most (but not all) Titles. You can add you own cover scans but most issues do not have covers. For that you would need the Archive Edition (or the 4K Archive Edition).

With Advance Find, yes. However... Not all Item #s have a Cover date. Annuals are hit and miss and most Books (especially modern ones) don't. So you may not get a complete list. NOTE: I have Custom Fields available and have set up one of the Custom Dates to be Publication Date so I could enter a date for all these problem Item #s. It uses an unsupported 'feature' called ComicTitles.Publisher. You can't select this from the Fields list as it isn't in the Issues Table. I included QtyInStock to just return Item #s that you own. If you want all, you can remove it. The date needs to be entered in ISO format (YYYY-MM-MM) and all values need to be used (i.e. 01 instead of just 1). For a Single Cover Date: I.QtyInStock >= 1 AND ComicTitles.Publisher = 'Marvel' AND I.CoverDate = '2021-01-01' For a Range of Cover Dates: I.QtyInStock >= 1 AND ComicTitles.Publisher = 'Marvel' AND I.Cover Date BETWEEN '2020-01-01' AND '2020-12-31' AND ComicTitles.Publisher = 'Marvel' Once you get the Find result, select everything (CTRL+A), then Right-click and from the pop-up menu select either Quick Reports or Report Select Titles As (then one of the Report types).

If you have it, to get to Advanced Find, start a Search (CTRL+F, or click on the magnifying glass in the top center of the window or use Items->Find... In the Find drop-down box, when you click it, Advanced Find should be at the bottom. See Attached. If it doesn't show up, then you don't have the correct Edition to use it (I think only Pro and Archive have it).

A Douglas mentioned, the only thing you have to do to indicate 'ownership' is change Qty (Quantity in Stock) to 1 (or more if you have multiple copies). You can do this in the grid without opening anything. Just double-click the cell and type a 1. At that point, the Item # will be high-lighted to make it easier to see what you have. For a little more advanced process, for a single Title, you can select multiple Item #s at one time (using the standard Windows keys of Shift for consecutive rows or CTRL for non-consecutive rows) while pressing/holding the left mouse button. Once the are all high-lighted, Right-click and select Quick Change form the pop-up menu. The the window what appears, select Qty In Stock and set the To: value to 1. After clicking Make Changes, all the selected Item #s will be set to 1 (or whatever value you entered. Also, if you have or want to get a Barcode scanner (and you are entering comics from late 1970's to now), you can use the Items->Add By Barcode. This will allow you to scan many comics at one time and have them entered into CB. (you can type in the barcode if you don't have a scanner but that is a little bit of work). I am not sure if Custom Fields are in the Free Edition. If the are, that is great but the are only in the Pro / Archive Editions. The are NOT in the Express Edition.

I am by no means an expert, but I think the value of a signed cover is whatever someone will pay for it. I don't think there is any kind of system where Creator A is worth x% more while Creator B is worth Y% more. If you are a seller, you will just have to make your best guess (and it looks like you have thought about this), set a price and see if it sells. If you are a buyer, you have to determine if what is being asked is something you are willing to pay. Then there are the people (like me) who consider any writing on the cover a down-grade and would only pay less because of it. There is no easy answer and that is probably one of the reason CB doesn't have any signed issues (other than with a COA).

First, the images are (probably) NOT deleted. It is just having a problem matching the cover image number with the now non-valid Item # (due to printing high value limit). Or possibly your Picture file location got changed. Go to the Secret City title, then Right click on the large cover scan area (top left corner) and select Show Picture File. See if the cover is there but just doesn't have a matching Item # in CB. You can also see the location of the Picture folder to see if it is where you expected. You can also check a Title with a (now) out of range Printing to see if the covers are still there. Second, current, the highest value for Printing appears to be 500 (I tired to enter a Printing of 1023 and the system 'defaulted' it back to 500). I would contact support and see if this was a mistake and will be fixed or if was a decision that can be changed. If either of those happens you database and cover images should be fine without doing anything. Then Change all the Item # Printings to something between the 1-500 range. NOTE: You will also have to rename each and every cover image with out of range Printing values to match what you changed them to. This is true for any of the methods I mention below. However, if HC doesn't fix this, you have a few possibilities (none of them are easy and will take time and effort (especially time)). One, do you have an older copy of CB that can be installed (prior to the Printing being max value being changed). If you do, I would A) Make a backup copy of your database (just in case), then B) install the older version of CB. At that point, you should be able to open/work with the large Printing values. Two, If you can Export / Import data, I would Export your data, open it in a Spreadsheet (you could use a Notes or something but that is a little more difficult). In the Spreadsheet, change all the Item # Printing values to something withing the 1-500 range that seems to be the current limit. Once done, I would open CB, Create aa New Database, run the most current Update, and then Import your corrected data. Three (and this is an even longer process), Create a new Item # for each of the out of range Printings and set it to something between the 1-500 range. Once you have the new Item #, copy/paste any information you entered from the 'bad' one to the new one (Notes, Custom Fields, etc.). When done, delete the 'bad' Item #. Repeat this process for every out of range Item #. Hopefully, this is something that HC can fix so you won't have to do any of the above. PS There were changes made for Variations with the latest update. This may have accidentally impacted Printings so hopefully, it is an error that can be fixed without you having to make changes.

Timothy. You don't delete the Title directly (unfortunately). Instead, just delete all the Item #s (issues) and the Title will automatically be deleted. You can do this by going to the Title (in Magazines), use CTRL+A to select all the Item #'s, then Right-click the mouse and select Delete from the pop-up menu. Technically, you just need to delete the potential duplicate Item #s, so if you only have 1 or 2, it might be easier to just delete the couple of Item #'s. But if you have a lot (or a lot on non-consecutive ones), deleting all is probably easier.

Delete or Move ALL (2-A.jpg - 4-K.jpg) From: Pictures\S\SQPINC\Vampirella Versus Purgatori To: Pictures\D\Dynamite\Vampirella Versus Purgatori Rename 2001.jpg to TPB 2001.jpg From: Pictures\M\Monkey Boy\Sketchbook (Frank Cho's-) Delete or Move ALL (1.jpg - 2-A.jpg) From: Pictures\D\DC\S\Static (Season One) To: Pictures\D\DC\S\Static- Season One Delete or Rename 1.jpg to 3.jpg then Move From: Pictures\S\SQP\Teach Me XXX To: Pictures\S\SQP\Teach Me Delete or Move TPB.jpg From: Pictures\D\DK\Animated Series Guide, The- Batman To: Pictures\D\DK\Batman- The Animated Series Guide Delete or Move HC.jpg From: Pictures\D\DK\Animated Series Guide, The- Batman Beyond To: Pictures\D\DK\Batman Beyond- The Animated Series Guide Delete or Rename TPB.jpg to HC.jpg then Move From: Pictures\D\DK\Animated Series Guide, The- Superman To: Pictures\D\DK\Superman- The Animated Series Guide Delete or Move MMPB 9.jpg From: Pictures\A\Avon\Phantom, The (Avon) To: \Pictures\A\Avon\Story of the Phantom, The Rename 18-B.jpg to 18-A.jpg From: Pictures\A\Acme Ink\Rock & Roll Biographies Publisher Changed (It may be easier just to move the folders from one Publisher to the other) Aaaargh! changed to Aaargh! Delete or Move ALL (1.jpg - 9.jpg) From: Pictures\A\Aaaargh!\Bug & Stump To: Pictures\A\Aaargh!\Bug & Stump Delete or Move 1.jpg From: Pictures\A\Aaaargh!\Crypt, The To: Pictures\A\Aaargh!\Crypt, The Delete or Move ALL (1.jpg - 4.jpg) From: Pictures\A\Aaaargh!\Desperate Times (Vol. 2) To: Pictures\A\Aaargh!\Desperate Times (Vol. 2) Delete or Move 1.jpg From: Pictures\A\Aaaargh!\Prince Nightmare To: Pictures\A\Aaargh!\Prince Nightmare AMP changed to Andrews McMeel AMP! changed to Andrew McMeel (NOTE: Shades of Blues stays in AMP) Delete or Move 1.jpg From: Pictures\A\AMP\Big Nate- Game On To: Pictures\A\Andrews McMeel\Big Nate- Game On Delete or Move 1.jpg From: Pictures\A\AMP\Big Nate- Hug It Out! To: Pictures\A\Andrews McMeel\Big Nate- Hug It Out! Delete or Move 1.jpg From: Pictures\A\AMP\Big Nate- Payback Time To: Pictures\A\Andrews McMeel\Big Nate- Payback Time Delete or Move 1.jpg From: Pictures\A\AMP\Big Nate- Say Good Bye To Dork City To: Pictures\A\Andrews McMeel\Big Nate- Say Good Bye To Dork City Delete or Move 1.jpg From: Pictures\A\AMP\Big Nate- Silent But Deadly To: Pictures\A\Andrews McMeel\Big Nate- Silent But Deadly Delete or Move 1.jpg From: Pictures\A\AMP\Big Nate- Thunka, Thunka, Thunka To: Pictures\A\Andrews McMeel\Big Nate- Thunka, Thunka, Thunka Delete or Move 1.jpg From: Pictures\A\AMP\Big Nate- What's A Little Noogie Between Friends- To: Pictures\A\Andrews McMeel\Big Nate- What's A Little Noogie Between Friends- Delete or Move 1.jpg From: Pictures\A\AMP\Bloodlust & Bonnets To: Pictures\A\Andrews McMeel\Bloodlust & Bonnets Delete or Move 1.jpg From: Pictures\A\AMP\Foxtrot Kids Edition To: Pictures\A\Andrews McMeel\Foxtrot Kids Edition Delete or Move ALL (1.jpg - 8.jpg) From: Pictures\A\AMP\Heavenly Nostrils Chronicle To: Pictures\A\Andrews McMeel\Heavenly Nostrils Chronicle Delete or Move 1-HC.jpg From: Pictures\A\AMP\Li'l Rip Haywire Adventures To: Pictures\A\Andrews McMeel\Li'l Rip Haywire Adventures Delete or Move 1.jpg From: Pictures\A\Amp!\Laser Moose and Rabbit Boy To: Pictures\A\Andrews McMeel\Laser Moose and Rabbit Boy Chronicle Books changed to Chronicle Delete or Move 1.jpg From: Pictures\C\Chronicle Books\ACME Catalog To: Pictures\C\Chronicle\ACME Catalog Delete or Move HC.jpg From: Pictures\C\Chronicle Books\Art Of McSweeny's To: Pictures\C\Chronicle\Art of McSweeny's Delete or Move 1.jpg From: Pictures\C\Chronicle Books\Dawn Of The Dreadfuls To: Pictures\C\Chronicle\Dawn Of The Dreadfuls Delete or Move 1.jpg From: Pictures\C\Chronicle Books\Does This Cape Make Me Look Fat- To: Pictures\C\Chronicle\Does This Cape Make Me Look Fat- Delete or Move 1.jpg and 1-HC.jpg From: Pictures\C\Chronicle Books\Robota To: Pictures\C\Chronicle\Robota Delete or Move TPB.jpg From: Pictures\C\Chronicle Books\Streetfighter- The Complete History To: Pictures\C\Chronicle\Streetfighter- The Complete History Delete or Move TPB.jpg From: Pictures\C\Chronicle Books\Super Heroes- The DC Comics Universe of Alex Ross- 30 Postcards To: Pictures\C\Chronicle\Super Heroes- The DC Comics Universe of Alex Ross- 30 Postcards Delete or Move 1-HC.jpg From: Pictures\C\Chronicle Books\Why She Wrote To: Pictures\C\Chronicle\Why She Wrote Comic Book Legal Defense Fund changed to CBLDF Delete or Move ALL (2.jpg - 21.jpg) From: Pictures\C\Comic Book Legal Defense Fund\Busted! (vol. 2) To: Pictures\C\CBLDF\Busted! (Vol. 2) Delete or Move ALL (1.jpg - 8.jpg) From: Pictures\C\Comic Book Legal Defense Fund\CBLDF Defender To: Pictures\C\CBLDF\CBLDF Defender Delete or Move 1.jpg, 2.jpg, and 3.jpg From: Pictures\C\Comic Book Legal Defense Fund\CBLDF Defender (Vol. 2) To: Pictures\C\CBLDF\CBLDF Defender (Vol. 2) Delete or Move 1.jpg From: Pictures\C\Comic Book Legal Defense Fund\CBLDF Defender (Vol. 3) To: Pictures\C\CBLDF\CBLDF Defender (Vol. 3) Delete or Move FCBD 2014.jpg From: Pictures\C\Comic Book Legal Defense Fund\Raising a Reader! To: Pictures\C\CBLDF\Raising a Reader! Dorling Kindersley Limited changed to DK Delete or Move 1.jpg From: Pictures\D\Dorling Kindersley Limited\Lego DC Comics Super Heroes Collection To: Pictures\D\DK\Lego DC Comics Super Heroes Collection Delete or Move 1.jpg From: Pictures\D\Dorling Kindersley Limited\Spy-Catcher Gang, The To: Pictures\D\DK\Spy-Catcher Gang, The Delete or Move 1.jpg From: Pictures\D\Dorling Kindersley Limited\Wagon Train Adventure To: Pictures\D\DK\Wagon Train Adventure Hashtag Comics changed to Hashtag Delete or Move ALL (1.jpg - 6.jpg) From: Pictures\H\Hashtag Comics\Carpe Noctem To: Pictures\H\Hashtag\Carpe Noctem Delete or Move ALL (1.jpg - 4.jpg) From: Pictures\H\Hashtag Comics\Cloud Riders- Princess Thais and the Rain Dancers To: Pictures\H\Hashtag\Cloud Riders- Princess Thais and the Rain Dancers Mike Wolfer Entertainment changed to Mike Wolfer Delete or Move ALL (1.jpg - Bk 1.jpg) From: Pictures\M\Mike Wolfer Entertainment\Daughters of the Dark Oracle- The Curse of Ragdoll To: Pictures\M\Mike Wolfer\Daughters of the Dark Oracle- The Curse of Ragdoll Delete or Move 1.jpg and 1-B.jpg From: Pictures\M\Mike Wolfer Entertainment\Gallery of Horror To: Pictures\M\Mike Wolfer\Gallery of Horror Delete or Move ALL (1.jpg - Bk 1-B.jpg) From: Pictures\M\Mike Wolfer Entertainment\Widow- Progeny (2nd Series) To: Pictures\M\Mike Wolfer\Widow- Progeny (2nd Series) Northwest Press changed to Northwest Delete or Move 1.jpg From: Pictures\N\Northwest Press\Hard to Swallow To: Pictures\N\Northwest\Hard to Swallow SQPINC changed to SQP Delete or Move TPB.jpg From: Pictures\S\SQPINC\Bare It All! Revealing Pin-Ups by Barbara Jensen To: Pictures\S\SQP\Bare It All! Revealing Pin-Ups by Barbara Jensen (Probably delete as it appears it was a pre-production cover image) Delete or Move TPB.jpg From: Pictures\S\SQPINC\Fastner & Larsons- Sexy Dreams To: Pictures\S\SQP\Fastner & Larsons- Sexy Dreams First Second changed to :01 First Second. Delete or Move 1.jpg From: Pictures\F\First Second\Adventures and Activities Ahoy! To: Pictures\#\-01 First Second\Adventures and Activities Ahoy! Delete or Move 1.jpg From: Pictures\F\First Second\Adventures in Cartooning To: Pictures\#\-01 First Second\Adventures in Cartooning Delete or Move 1.jpg From: Pictures\F\First Second\A.L.I.E.E.E.N To: Pictures\#\-01 First Second\A.L.I.E.E.E.N Delete or Move 1.jpg From: Pictures\F\First Second\Amazing Remarkable Monsieur Leotard, The To: Pictures\#\-01 First Second\Amazing Remarkable Monsieur Leotard, The Delete or Move 1.jpg, 1-3.jpg, and 1-HC-3.jpg From: Pictures\F\First Second\American Born Chinese To: Pictures\#\-01 First Second\American Born Chinese Delete or Moe 1.jpg From: Pictures\F\First Second\Americus To: Pictures\#\-01 First Second\Americus Delete or Move 1.jpg From: Pictures\F\First Second\Bake Sale To: Pictures\#\-01 First Second\Bake Sale Delete or Move 1.jpg From: Pictures\F\First Second\Ball Peen Hammer To: Pictures\#\-01 First Second\Ball Peen Hammer Delete or Move 1.jpg and 1-HC.jpg From: Pictures\F\First Second\Battling Boy To: Pictures\#\-01 First Second\Battling Boy Delete or Move 2.jpg From: Pictures\F\First Second\Battling Boy- The Rise of Aurora West To: Pictures\#\-01 First Second\Battling Boy- The Rise of Aurora West (However, it looks like this cover is for a different title that is not yet in CB) Delete or Move 1.jpg, 1-HC.jpg, and FCBD 2007.jpg From:Pictures\F\First Second\Black Diamond Detective Agency, The To: Pictures\#\-01 First Second\Black Diamond Detective Agency, The Delete or Move 1.jpg From: Pictures\F\First Second\Booth To: Pictures\#\-01 First Second\Booth Delete or Move 1.jpg From: Pictures\F\First Second\Bourbon Island 1730 To: Pictures\#\-01 First Second\Bourbon Island 1730 Delete or Move Bk 1.jpg From: Pictures\F\First Second\Boxers To: Pictures\#\-01 First Second\Boxers Delete or Move 1.jpg From: Pictures\F\First Second\Brain Camp To: Pictures\#\-01 First Second\Brain Camp Delete or Move 1.jpg From: Pictures\F\First Second\City Of Spies To: Pictures\#\-01 First Second\City Of Spies Delete or Move 1.jpg From: Pictures\F\First Second\Color of Earth, The To: Pictures\#\-01 First Second\Color of Earth, The Delete or Move 2.jpg From: Pictures\F\First Second\Curses, Foiled Again To: Pictures\#\-01 First Second\Curses, Foiled Again Delete or Move 1.jpg From: Pictures\F\First Second\Dawn Land To: Pictures\#\-01 First Second\Dawn Land Delete or Move 1.jpg From: Pictures\F\First Second\Delilah Dirk and the Turkish Lieutenant To: Pictures\#\-01 First Second\Delilah Dirk and the Turkish Lieutenant Delete or Move 1.jpg From: Pictures\F\First Second\Deogratias, a tale of Rwanda To: Pictures\#\-01 First Second\Deogratias, a tale of Rwanda Delete or Move 1.jpg From: Pictures\F\First Second\Divine To: Pictures\#\-01 First Second\Divine Delete or Move 1.jpg From: Pictures\F\First Second\Eternal Smile, The- Three Stories To: Pictures\#\-01 First Second\Eternal Smile, The- Three Stories Delete or Move Bk 1-HC.jpg From: Pictures\F\First Second\Exquisite Corpse (First Second) To: Pictures\#\-01 First Second\Exquisite Corpse (First Second) Delete or Move 1.jpg and 1-HC.jpg From: Pictures\F\First Second\Fate of the Artist, The (Eddie Campbell-) To: Pictures\#\-01 First Second\Fate of the Artist, The (Eddie Campbell-) Delete or Move 1.jpg and 1-HC.jpg From: Pictures\F\First Second\Feynman To: Pictures\#\-01 First Second\Feynman Delete or Move 1.jpg From: Pictures\F\First Second\Foiled To: Pictures\#\-01 First Second\Foiled Delete or Move 1.jpg From: Pictures\F\First Second\Garage Band To: Pictures\#\-01 First Second\Garage Band Delete or Move 1.jpg From: Pictures\F\First Second\Genius To: Pictures\#\-01 First Second\Genius Delete or Move 1-HC.jpg, 2-HC.jpg, and 3-HC.jpg From: Pictures\F\First Second\Glorkian Warrior To: Pictures\#\-01 First Second\Glorkian Warrior Delete or Move 1.jpg From: Pictures\F\First Second\Gus & His Gang To: Pictures\#\-01 First Second\Gus & His Gang Delete or Move 1.jpg From: Pictures\F\First Second\Himawari House To: Pictures\#\-01 First Second\Himawari House Delete or Move 1.jpg From: Pictures\F\First Second\History Comics- The Great Chicago Fire- Rising from the Ashes To: Pictures\#\-01 First Second\History Comics- The Great Chicago Fire- Rising from the Ashes Delete or Move GN 1.jpg From: Pictures\F\First Second\History Comics- The Roanoke Colony- America's First Mystery To: Pictures\#\-01 First Second\History Comics- The Roanoke Colony- America's First Mystery Delete or Move 1.jpg From: Pictures\F\First Second\Human Body Theater To: Pictures\#\-01 First Second\Human Body Theater Delete or Move 1.jpg From: Pictures\F\First Second\In Real Life To: Pictures\#\-01 First Second\In Real Life Delete or Move 101.jpg From: Pictures\F\First Second\Invincible Haggard West, The To: Pictures\#\-01 First Second\Invincible Haggard West, The Delete or Move 1.jpg From: Pictures\F\First Second\Kaput and Zosky (First Second) To: Pictures\#\-01 First Second\Kaput and Zosky (First Second) Delete or Move 1.jpg From: Pictures\F\First Second\Klezmer To: Pictures\#\-01 First Second\Klezmer Delete or Move 1.jpg and 1-HC.jpg From: Pictures\F\First Second\Laika To: Pictures\#\-01 First Second\Laika Delete or Move ALL (1.jpg - 6.jpg) From: Pictures\F\First Second\Last Man To: Pictures\#\-01 First Second\Last Man Delete or Move 1.jpg From: Pictures\F\First Second\Last of the Sandwalkers To: Pictures\#\-01 First Second\Last of the Sandwalkers Delete or Move Bk 1.jpg From: Pictures\F\First Second\Legends of Zita the Spacegirl To: Pictures\#\-01 First Second\Legends of Zita the Spacegirl Delete or Move 1.jpg From: Pictures\F\First Second\Lewis & Clark To: Pictures\#\-01 First Second\Lewis & Clark Delete or Move 1.jpg From: Pictures\F\First Second\Life Sucks To: Pictures\#\-01 First Second\Life Sucks Delete or Move 1.jpg From: Pictures\F\First Second\Little Vampire To: Pictures\#\-01 First Second\Little Vampire Delete or Move 1.jpg 1-HC.jpg, and 2.jpg From: Pictures\F\First Second\Lost Colony, The To: Pictures\#\-01 First Second\Lost Colony, The Delete 1.jpg From: Pictures\F\First Second\Missouri Boy To: Pictures\#\-01 First Second\Missouri Boy Delete or Move 1.jpg and 1-HC.jpg From: Pictures\F\First Second\My Own World To: Pictures\#\-01 First Second\My Own World Delete or Move 1.jpg From: Pictures\F\First Second\Notes For A War Story To: Pictures\#\-01 First Second\Notes For A War Story Delete or Move ALL (1.jpg - 10.jpg) From: Pictures\F\First Second\Olympians (First Second) To: Pictures\#\-01 First Second\Olympians (First Second) Delete or Move 1.jpg From: Pictures\F\First Second\Orcs To: Pictures\#\-01 First Second\Orcs Delete or Move 1.jpg From: Pictures\F\First Second\Prime Baby To: Pictures\#\-01 First Second\Prime Baby Delete or Move 1.jpg From: Pictures\F\First Second\Prince of Persia To: Pictures\#\-01 First Second\Prince of Persia Delete or Move 1.jpg From: Pictures\F\First Second\Professor's Daughter, The To: Pictures\#\-01 First Second\Professor's Daughter, The Delete or Move 1.jpg From: Pictures\F\First Second\Refresh Refresh To: Pictures\#\-01 First Second\Refresh Refresh Delete or Move 1.jpg From: Pictures\F\First Second\Relish- My Life In The Kitchen To: Pictures\#\-01 First Second\Relish- My Life In The Kitchen Delete or Move 1.jpg From: Pictures\F\First Second\Resistance (First Second) To: Pictures\#\-01 First Second\Resistance (First Second) Delete or Move 1.jpg From: Pictures\F\First Second\Robot Dreams To: Pictures\#\-01 First Second\Robot Dreams Delete or Move Bk 1.jpg From: Pictures\F\First Second\Saints (First Second) To: Pictures\#\-01 First Second\Saints (First Second) Delete or Move ALL (1.jpg - 6.jpg) From: Pictures\F\First Second\Sardine in Outer Space To: Pictures\#\-01 First Second\Sardine in Outer Space Delete or Move FCBD 2016.jpg From: Pictures\F\First Second\Science Comics (First Second) To: Pictures\#\-01 First Second\Science Comics (First Second) Delete or Move 1.jpg and 2.jpg From: Pictures\F\First Second\Secret Coders To: Pictures\#\-01 First Second\Secret Coders Delete or Move 1.jpg From: Pictures\F\First Second\Slow Storm To: Pictures\#\-01 First Second\Slow Storm Delete or Move FCBD 2017.jpg From: Pictures\F\First Second\Spill Night To: Pictures\#\-01 First Second\Spill Night Delete or Move 1.jpg and 2.jpg From: Pictures\F\First Second\Star Scouts To: Pictures\#\-01 First Second\Star Scouts Delete or Move 1.jpg From: Pictures\F\First Second\Tetris- The Games People Play To: Pictures\#\-01 First Second\Tetris- The Games People Play Delete 1.jpg From: Pictures\F\First Second\Three Shadows To: Pictures\#\-01 First Second\Three Shadows Delete or Move 1.jpg and 2.jpg From: Pictures\F\First Second\Tiny Tyrant To: Pictures\#\-01 First Second\Tiny Tyrant Delete or Move 1.jpg From: Pictures\F\First Second\Town Boy To: Pictures\#\-01 First Second\Town Boy Delete or Move 1.jpg From: Pictures\F\First Second\Tune To: Pictures\#\-01 First Second\Tune Delete or Move 1.jpg From: Pictures\F\First Second\Unsinkable Walker Bean, The To: Pictures\#\-01 First Second\Unsinkable Walker Bean, The Delete or Move 1.jpg From: Pictures\F\First Second\Vampire Loves To: Pictures\#\-01 First Second\Vampire Loves Delete or Move 1.jpg From: Pictures\F\First Second\Wrenchies To: Pictures\#\-01 First Second\Wrenchies Delete or Move 1.jpg From: Pictures\F\First Second\Zabime Sisters, The To: Pictures\#\-01 First Second\Zabime Sisters, The Delete or Move TPB.jpg From: Pictures\F\First Second\Drawing Words, Writing Pictures- Making Comics From Manga to Graphic Novels To: Pictures\#\-01 First Second\Drawing Words, Writing Pictures- Making Comics From Manga to Graphic Novels

See this post for the difference: https://forums.comicbase.com/index.php?/topic/833-mmpb-mass-market-paperback-vs-tpb-paperback/&tab=comments#comment-2898

Books are different. The Comic Title Elementals (Vol. 1 was already created. For these books you would have to 'make up' some Title to place them under. Then what do you do for Item #. Can't really use 1, 2, 3. Even Year may not work as multiple books could come out in one year. Here is Pete's actual reply to my question:

What you ask is a little different then what I asked. My question was: For a set of books that are meant to be read in sequence (to make the most sense) but, could be read by itself, should they be listed under one Title (to keep them all together) or separately (NOTE: The are NOT numbered)? The answer was to list each of them under their own Title. To try to apply this to what you have... Looking at the covers on Amazon, the first nine are the list do not have any number on the cover (I can't see the spine). The others DO have numbers on them. My guess is you would create 9 separate Titles for the first 9 non-numbered books. Not sure about the Titles. could be either 'Star Trek, the Next Generation: Descent' or just 'Descent' (I would lean towards the StNG:Decent one and just change Descent to the other names) Then create 1 Title, with a possible name of 'Star Trek: The Next Generation (Pocket)', and list all the others (currently, Amazon has it as 65 books) as part of a numbered series.

Yes. I only had one cover downloaded (and it was preliminary art, at that (even though I have it checked NOT to download them but this is an on-going problem...)). I think, for the most part, what I listed is mostly correct as I go off the Titles Updated and Deleted. Updated Titles didn't have any Publisher changes and all the deleted ones didn't have any covers (and since they were being deleted, really shouldn't have had any covers downloaded for them). However, in weeks going forward, those missing covers may lead me to miss something. Since I have two database, I am going to wait a few days to see if the cover problem can be fixed. If it is, I will update this second database and download covers at that point (they share the same picture folder).

Delete or Move 3.jpg From: Pictures\O\One Peace\I Hear the Sunspot To: Pictures\O\One Peace\I Hear the Sunspot- Limit

Despite the 'p' added to Infinity Wars on the cover, the indicia does NOT have it. For example: The indicia is 'Infinity Wars: Iron Hammer'

After Importing data, if a publisher is listed as 'Unknown Publisher', that means that CB could not find a matching Title to add the issues to. What you need to do is get a list of the Titles (do a Find where Publisher is "Unknown Publisher'. Use the list and try to match up with Titles already in CB (they are most likely there but it is possible to have something not yet in CB). Note: Some of the Titles in Comic Books might have been moved to Books or Magazines. If the Title the same and it is in a different Media, use Edit->Change Title Media Type to move it to the correct media. If the Titles is the same Media, you can select any/all issues in the incorrect Title and use Edit->Transfer Issues to a Different Title...

Delete or Move 1.jpg From: Pictures\M\Markus Publishing\Draculangela To: Pictures\M\Markus\Draculangela- Angel of Darkness Delete or Move 1-HC.jpg From: Pictures\D\DC\F\Fourth World Omnibus (Jack Kirby's-, 2nd Series) To: Pictures\D\DC\F\Fourth World by John Byrne Omnibus Delete 1.jpg From: Pictures\A\aardwolf\God's 15 Minutes (or, if you don't have a TPB.jpg, Rename 1.jpg to TPB.jpg) Delete or Move 1.jpg From: Pictures\B\Binge\Heroes Union To: Pictures\B\Binge\Sitcomics Presents The Heroes Union Binge Book Delete or Move 1-A.jpg From: Pictures\O\Oni\Invader ZIM- Dookie Loop Horror To: Pictures\O\Oni\Invader Zim- The Dookie Loop Horror Rename 1.jpg to 1-A.jpg From: Pictures\S\Second Sight\Edge, The (Second Sight) Delete or Rename 2021-B.jpg to 2021.jpg then Move From: Pictures\V\Viz\Free Comic Book Day (Viz) To: Pictures\I\Idea + Design Works\Free Comic Book Day (IDW) Rename Give 1.jpg to 2.jpg From: Pictures\M\Mad Cave\Mad cave Ones

There are a couple of Options. But you will need to know where to move the 'Unknown Publisher' Titles/Issues to. Step one is to list all the 'Unknown Publisher Titles. You can This with a Find where Publisher is 'Unknown Publisher'. When the lists is displayed, you can hi-light the list (you really just need the Title but Publisher and Years Published won't hurt). CTRL+A will select everything. Then you can Copy and Paste into your Spreadsheet. Step Two would be to Identify All these Titles with ones that CB uses. This can either be easy or difficult depending on what you have. Once you have this cross-reference list, you can use Edit->Transfer Items to a Different Title. Go to the First Title from the list of Unknown Publisher. Hi-light just the Issues you want to transfer (or select all of them), then use the Transfer option. You will get a Titles window to the Title you want to move them to. Repeat this process for all the Unknown Publishers. One more thing. Some of the Titles you imported may not be in Comic Books. They may be in the Books or Magazine section. If this is the case, You can use Edit->Change Title Media Type.

What Edition of CB do you have? (Free, Express, Pro, or Archive)? You need at least Professional to Export/Import data. Express may let you do one of these (but not both, I think) but I can't find any info on the CB website. If you do have them, they should be under menu item File->Import or File->Export.

Can you supply a screen print of the collection report options for the one that only has a few being shown? Ii am mostly interested in what is shown in Red in the attachment.

So, you are saying, on you computer, one Report sohws them but one doesn't? Have you gone to the actual Titles and seen if they are entered correctly there? (should have Qty of 1)? If all the items are actually in the database, then the problem could just be with the report. If the items are not in the database, then that is a different problem. Assuming the items are actually in the database, you can try running File->File Tools Rebuilds lists (you might as well select all but the Pictures File List). After that run Optimize Database (same location).

Where are the 135 located? Have they been entered into the database? Or scanned in with your phone?

Here is a first draft of information about the Advanced Find. Let me know if something needs to be added, deleted, modified, or explained better. ******************************************** I believe the database currently used by CB is SQLite. Here is a link to the SQL (Structured Query Language) for SQLite Select. https://www.sqlite.org/lang_select.html Here is a link to the Built-in Scalar SQL Functions https://www.sqlite.org/lang_corefunc.html Because of the limits put on Advance Find, a lot (most) of the SQLite documentation is of no use but it will get you the syntax for the ones you would use. (NOTE: I am supplying these links in case they help someone. Personally, I would use them as examples of how NOT to write a manual. I know what I am doing with SQL and I find these (while accurate) are to read/follow.) ******************************************** The Query functionality in the Advanced Find is limited to just the WHERE clause. You can't control the Select (what columns are returned), the From (the tables involved), or the Group By (used with Aggregate Functions like Sum, Count, Average, etc.). The main reason for this business decision is that every row returned has to be unique to allow them to be updated (changed) individually. Below are sections that are explained in more detail below: Data Types Comparisons Order By Random Notes ******************************************** DATA TYPES: To make it simple, there are just four Data Types (there are actually sub-types for some of these). Text: This is character data and can contain any alpha/numeric/special characters. All Text searches are case-insensitive (ignores case of letters). The constant compare value needs to be contained in single 'tick' marks (double 'tick' marks also work but single is the more standard way). I.[Title] = 'batman' This will return just the one Title 'Batman" as it is an exact match (and shows that Case doesn't matter) Date: This contains Date information. It has to be a valid date. (i.e. Feb 31, 2021 is NOT a valid date). Despite the display of the date in CB as m/d/YYY, the date in SQLite is in ISO standard format of YYYY-MM-DD. This is important because... I.CoverDate = '2020-12-01' will return rows (assuming there is data with that value). I.CoverDate = '12/1/2020' will NOT return any rows. Also it has to be an exact match as all the digits are important: I.CoverDate = '2020-12-1' will NOT return any rows. And like Text, Date constants need to be contained in single 'tick' marks. Number: This contains Numeric information (Integer or Decimal). I.QtyInStock = 2 I.IssueNum = 0.5 I.IssueNum = -1 Binary: This is represented by a Check-box. It is a True/False or 1/0 value. As you can see it has two states. Basically, it translates to 'Is Checked' or 'Is Not Checked'. These are equivalent and will return rows where the CustomCheck2 check-box IS Checked I.[CustomCheck2] IS True I.[CustomCheck2] = 1 And, as you might guess, change to False or 0 to find if a check-box Is Not Checked. ******************************************** COMPARISONS: When using the Where clause, you are normally comparing a Column value to a constant to find something. Some comparison operators are: = Equal To <> Not Equal To < Less Than > Greater Than <= Less Than or Equal To >= Greater Than or Equal To These work as you would expect: I.Title = 'Batman' (Finds Only exact match) I.Title <> 'Batman' (Finds All except 'Batman') I.Title < 'Batman' (Finds All from !Gag! (Harrier) to Baticomic) I.Title > 'Batman' (Finds ALL from 'Batman & Robin (Panini Deutschland)' to '…One to Go') I.Title <= 'Batman' (Same as < but also includes 'Batman') I.Title >= 'Batman' (Same as > but also includes 'Batman') BETWEEN: Syntax is BETWEEN x AND y It is inclusive (meaning the value of X and Y will be included in the results). It is equivalent to using the >= and <= together. For example, these produce the same results: I.IssueNum BETWEEN 5 and 10 I.IssueNum >= 5 AND I.IssueNum <= 10 Either of these will find all IssueNum values of 5, 6, 7, 8, 9, and 10 (assuming only integer values and the value exists). Note: X has to be Less than (or equal) to Y for it to work. This is easier to see if you use the >= and <= I.IssueNum BETWEEN 10 and 5 is equivalent to I.IssueNum >= 10 and I.IssueNum <= 5 There can't be a value that is both Greater than 10 and Less than 5 IN: Syntax is IN (value1, value2,...) Searches for a list of possible value instead of just one. It is equivalent to using multiple = comparisons. For example, these produce the same results: I.IssueNum IN (5, 8, 25, 32) (Note: the values can be in any order) I.IssueNum = 5 OR I.IssueNum = 8 OR I.IssueNum = 25 OR I.IssueNum = 32 Either will find all IssueNum values of 5, 8, 25 and 32. IS: This one is a little different it only has a couple formats: IS True IS False It is mainly used for Binary Data Types. (NOTE: there is also an IS NULL but that should rarely be needed. What is does is check to see if a column contains NULL. NULL is nothing. It is not a 'space' or an empty-string. Rarely, you may need it if a column in CB allows NULL and you need to find them.) LIKE: Syntax is I.Title LIKE 'Batman%' This will find values but uses wild-card symbols to allow finding non-exact matches. The wild-card values are Percent ( % ) and Underscore ( _ ) where a % represents zero to many characters and _ is one and only one character. (NOTE: You can use multiple _ in a row to indicate a specific number of characters.) Examples: I.Title LIKE '%Batman%' will find anything that contains 'Batman' in it (NOTE: Just because % is at the beginning doesn't mean that there has to be something in from of 'Batman' in the Title.) I.Title LIKE 'Bat%Man' will find anything that starts with 'BAT' and ends with 'MAN' and may or may not have other values between them. I.Title LIKE '_Batman' will find anything that that starts with a single character before 'Batman' (NOTE: There has to be a value as this will NOT return just 'Batman') I.Title LIKE '_atman' (one underscore) will return anything that starts with some single character and ends with 'atman' (i.e. 'Batman', 'Catman, 'Ratman') I.Title LIKE '__man' (two underscores) will return anything that starts with two characters and ends with 'tman' (i.e. 'Batman', 'Catman', 'Hitman', 'Ratman') I.Title LIKE '______' (six underscores) will return anything with 6 characters (i.e. '10 Gen','Action', Batman', 'Zordon', etc.) (There are also some NOT versions, like NOT BETWEEN, NOT IN, and IS NOT but NOT logic is best left to Expert Advanced users (or insane ones...). Having said that, they can be useful on occasion so I am at least mentioning them) Boolean Logic Expressions: The Where clause uses Boolean Logic Expressions. Besides the more familiar operators (<, >, =, etc.), it also includes AND, OR, and NOT. They are used to concatenate single comparisons into more complex comparisons. For the Where clause, the comparisons have to end up as TRUE to return rows. With AND, all comparisons have to be True for the Where clause to evaluate as True and return a row. With OR, at lest one comparison has to be True for the Where clause to evaluate as True and return a row. Here is a list to show how this works (the values True and False are being used as the comparisons to emulate the result of comparisons): AND- All have to be True: 'True' AND 'True' evaluates to TRUE , row returned. 'True' AND 'False' evaluates to FALSE, row NOT returned. 'False' AND 'True' evaluates to FALSE, row NOT returned. 'False' AND 'False' evaluates to FALSE, row NOT returned. OR- At least One has to be True: 'True' OR 'True' evaluates to TRUE , row returned. 'True' OR 'False' evaluates to TRUE , row returned. 'False' OR 'True' evaluates to TRUE , row returned. 'False' OR 'False' evaluates to FALSE, row NOT returned. This is also the case for more that two comparisons: 'True' AND 'True' AND 'True' evaluates to TRUE, row returned. 'True' AND 'True' AND 'False' evaluates to FALSE, row NOT returned 'True' OR 'False' OR 'True' evaluates to TRUE, row returned. 'False' OR 'False' OR 'False' evaluates to FALSE, row NOT returned. You can use both AND and OR in the same Where clause but you need to be aware of the Order of Precedence (the order the expressions are evaluated in). AND is processed before OR. To make it easier on you, it is best to use Parenthesis to control the order the comparisons are done. Consider this: I.Title = 'Batman' OR I.IssueNum = 2 AND I.Printing = 2 OR I.Variation = 'HC' I.Title = 'Batman' OR (I.IssueNum = 2 AND I.Printing = 2) OR I.Variation = 'HC' At first glance, the first one is hard to tell what is going to happen. The second one, with parenthesis, is what it actually being done. With the parenthesis, it is easier to see that it will return Any Batman rows, along with Any rows with IssueNum 2 & Printing 2, along with Any rows that have a Variation of HC. While it is still a complex query, it should be easier to understand what will happen. Here is another similar comparison where the only difference is the ANDs and ORs: I.Title = 'Batman' AND I.IssueNum = 2 OR I.Printing = 2 AND I.Variation = 'HC' (I.Title = 'Batman' AND I.IssueNum = 2) OR (I.Printing = 2 AND I.Variation = 'HC') Again, while both will return the same rows, with the parenthesis, it is easier to see that this will return Any Batman with IssueNum 2, along with Any row that has Printing 2 and Variation HC. ******************************************** ORDER BY: There isn't much to say about the Order By clause. It pretty much does what you would expect. Sorts the resutls as requested. The one thing not obvious is you can control the direction of the ordering with ASC (the default value) or DESC. I.Title ASC would sort A-Z and/or 0-100 (ASC is the default and you don't need to add it) I.Title DESC would sort Z-A and/or 100-0 You can mix and match the use of ASC and DESC I.Title ASC, I.IssueNum Desc I.Title Desc, I.IssueNum Desc, I.Variation ASC Keep in mind the Data types when doing sorts. Number and Dates sort as you would expect. Text sorts characters from left to Right. If you have what looks like numbers in a Text field, the sort order would be 1, 10, 100, 2, 20, 200, etc. It would not be 1, 2, 10, 20, 100, 200. The following will sort the results the same way (or at least very similar) to the way CB sorts its display: I.Title, I.IssueNum, I.ItemType, I.Variation, I.Printing ******************************************** [start 2022-01-14 addition] DATA TYPES: Strftime: Strftime allows you to access a date in different ways. The basic syntax is: strftime(format, column-name) Some of the more useful formats are: %m month: 01-12 %d day of month: 00 %w day of week 0-6 with Sunday=0, Saturday=6 %Y year: 0000-9999 NOTE: the format character is case-sensitive. Use upper/lower case as shown. The Month format is probably the most useful as it can be used with both CoverDate and StreetDate. While Day of Month and Day of Week can be used with either, most CoverDate Day values are 1 (excepting items put out multiple times a month) and wont' really get you useful results. While the Year function does work, it is not as efficient as using BETWEEN: strftime('%Y', I.CoverDate) = '2002' takes 23 seconds to process I.CoverDate BETWEEN '2022-01-01' and '2022-12-31' takes 1.75 seconds to process You can also combine this with the BETWEEN function to limit the year ranges for a result. Some examples: Find all items with a day of '15': strftime('%d', I.StreetDate) = '15' Find all items with a day of '15' for years 2000-2009: strftime('%d', I.StreetDate) = '15' AND I.CoverDate BETWEEN '2000-01-01' AND '2009-12-31' Find all items with a day of Wednesday': strftime ('%w', I.StreetDate) = '03' [end 2022-01-14 addition] ******************************************** RANDOM NOTES: What is Item # and why not to use it in Order By: While Item # is the displayed value, it isn't the best field to do Finds with, in most cases. Item # is composed of 4 other columns. They are, in order, ItemType, IssueNum, Variation, and Printing. Item # 1/HC-2 is composed of: ItemType: none used (or regular issue but don't try to find regular issue in ItemType as it is only a display item) IssueNum: 1 Variation: HC Printing: 2 If you try to use Item # in the Order by, it will sort all ItemTypes first. Also, Item # is a Text field and NOT a numeric. You will also get 1, 10, 100-109, 11, 110-119, 12, 120-... This is why it is better to use the various components of the Item # instead of Item # itself when sorting to match CB order: I.Title, I.IssueNum, I.ItemType, I.Variation, I.Printing ====== Use of [] in Column names: Some of you may be curious what the brackets ( [] ) around column names are for (and why I don't use them). If the creator of a Table use a column name with a space (i.e. 'Issue Number') then it is required to enclose it in brackets ( [Issue Number] ) when referencing it so the database sees it has a 'single' name. If there is no space (i.e. IssueNumber), then the brackets are optional. Since the SQL processor adding the columns doesn't know if there are spaces or it, it defaults using brackets, just in case. It doesn't hurt to have them and not need them. However, to me, they just clutter up the display of the query (the less I have to look at and ignore, the better) so I never type them in when I write a query. A similar point could be made for parenthesis. Most SQL processors put way too many, unnecessary parenthesis in their statement. Don't get me wrong. As I showed above, parenthesis can (and sometimes must) be used to make the query either easier to understand or do what you want. But the over-use of them can make for a cluttered query. (Okay, my pet peeve part of this manual is over (for now...)) ====== [end 2021-12-30 addition to cover different Types and Columns] How to use Publisher Title columns in Advanced Find: One thing you may notice, is that only ISSUE columns are available in Advanced Find in the drop-down box. In the old days (pre-CB 2020) there used to be "I" (Issue tables) and "T" (Title tables) where you could access Publisher in Advanced Find. The "I" and "T" were qualifiers to indicate which table a column is in. --- Quick aside (geek alert)... The "I" in I.Title is the qualifier (or identifier) of a Table as defined in a From clause (since the From clause has not been displayed, you can see it directly). It is only really needed if you have more than one Table in the From and you Join them together (i.e. Issue table and Title table). The syntax would look like this: From Issue_Table I inner join Title_Table T on I.Title = T.Title The only thing you need to get from this is that the column Title is in both Tables. Because of this it needs to be qualified when reference (i.e. I.Title for the one int the Title_Table) --- Sadly, with CB 2020, only "I" table columns are (readily) available. However, there is a second way to qualify a column and that is with the actual Table name. So, while you can't select Publisher from the drop-down box, you CAN use it by qualifying it with the actual table name like this: ComicTitles.Publisher = 'Marvel' BookTitles.Publisher = 'Ballantine' MagazineTitles.Publisher = 'Time' ComicTitles.[CustomCheck1] IS TRUE BookTitles.[CustomCheck1] IS TRUE MagazineTitles.[CustomCheck1] IS TRUE NOTE: This is a non-supported feature which may or may not work in future releases of CB. (Maybe HC will make Title columns available in the Advanced Find in the future (hint, hint, hint, please...?) [start 2021-12-30 addition to cover different Types and Columns]