Jump to content

Steven L. Dasinger

Moderators
  • Posts

    1,533
  • Joined

  • Last visited

  • Days Won

    73

Everything posted by Steven L. Dasinger

  1. If you are careful you might try doing them in batches (one per different condition). Step 1: Make sure there are NO Marked comics (Find where Marked is Checked). Step 2: Find all the Good To Very Good conditions. Step 3a: In the Find result for that Condition, Select all the Issues and Quick Change Marked to Checked (so you can find these specific ones and change them back later). Step 3b: In the same Find Result, Select all the Issues and Quick Change Condition to one of the standard ones (doesn't really matter as long as it matches what you are importing). Step 3c: In the same Find Result, Select all Issues and Quick Change Qty In Stock to 0. Step 4: With a file that ONLY contains the issues that correspond with the Condition you are working with ( Good to Very Good in this example), Import the rows. Step 5: Find all Marked issues and verify that the Custom Field 4 values got added. Step 6a: Assuming everything looks good, with the Find result, Quick Change Condition back to what it was originally (Good to Very Good for this example). (You shouldn't have to change Qty In Stock as the Import file should set that to 1 (or whatever number you need). Step 6b: If everything looks good, change all the Marked Issues to Unchecked. Repeat steps 1 to 6b for each different condition. Alternately, if you are good with Excel or a Database, you could export the CB 2020 database and use Excel, a Database to Merge the rows you want then Import into a new database. This would depend on how familiar you are with doing this type of thing.
  2. Yes. I understand. Existing CB 2020 database with current data is missing Custom Field 4 data. Trying to populate with old CB 2017 data. Good new is setting Qty in Stock to 0 in the existing 2020 database works successfully to import the file of CB 2017 data without duplication and with the Custom Field 4 data applied. (I have tested and verified this). Bad new is this appears to only work for the standard CB Grades (MT, NM, VF-NM, VF, FN, VG, G, FA, P (and maybe Ungraded)). (I have also tested and verified this problem). The Import Duplicates the issues for any Custom Grades you create (i.e. Good to Very Good), or any of the 'slabbed' grades (PGX, CGC, CBSC, ets.). This may be a bug in the Import process.
  3. I just tested this and it should work. I would still do this on a copy of the CB 2020 database, just to be on the save side. Export from CB 2017: Title, Issue Num, Condition, Qty in Stock and Custom Field 4. In CB 2020, set all the Item # Qty In Stock to 0. Import the CB 2017 file into CB 2020. Since the Qty in Stock in the CB 2020 database are 0, they will NOT cause duplicate issues and Custom Field 4 values WILL be present.
  4. Rename HC.jpg to 1-HC.jpg From: Pictures\W\Wizard\Wizard Spider-Man Masterpiece Edition Rename Bk 1.jpg to TPB 1.jpg From: Pictures\B\Bantam Books\Fantastic Art of Frank Frazetta, The Delete or Move 1-B.jg, 1-C.jpg & 1-D.jpg From: Pictures\D\Dynamite\Nancy Drew & the Hardy Boys- The Death of Nancy Drew Rename 1-HC.jpg to HC 1.jpg From: Pictures\S\Spectrum Fantastic Art\Spectrum Presents- Rough Work by Frank Frazetta Rename HC 1-A.jpg to HC-A.jpg & TPB 1.jpg to TPB.jpg From: Pictures\F\Fireside\Excelsior!- The Amazing Life of Stan Lee Rename HC 1.jpg to HC.jpg From: Pictures\M\Marvel\G\Guardians of the Galaxy- Rocket Raccoon & Groot-Steal the Galaxy! Rename TPB.jpg to TPB 2.jpg From: Pictures\M\Moonstone\Kolchak The Night Stalker Casebook Rename TPB.jpg to TPB 2.jpg From: Pictures\M\Moonstone\Kolchak The Night Stalker- The Lovecraftian Horror Rename HC 1.jpg to HC.jpg & TPB 1-A.jpg to TPB-A.jpg From: Pictures\M\Marvel\M\Marvel Encyclopedia (2nd Series) Rename HC 1.jpg to HC.jpg & HC 1-4.jpg to HC-4.jpg From: Pictures\M\Marvel\M\Marvel- The Characters and Their Universe Rename HC.jpg to HC 1.jpg From: Pictures\F\Fantagraphics\Pirates and the Mouse, The Rename TPB.jpg to TPB.2.jpg From: Pictures\M\Moonstone\Vampires- Dracula & the Undead Legions Rename TPB.jpg to TPB 1.jpg From: Pictures\M\Moonstone\Werewolves- Dead Moon Rising Rename TPB 1.jpg to TPB.jpg From: Pictures\M\Marvel\W\World of Reading- This Is Thor
  5. By the way, you can have both CB 2017 and CB 2020 installed at the same time. You would NOT have to uninstall CB 2020 to reinstall CB 2017.
  6. Currently, you can't. Last I heard, there was a technical reason (something about size of data being transmitted). I hope this is being looked into as it was useful before but really needed now that items are moving between Comic Books, Books, and Magazines.
  7. Using v3418 I seem to have the same problem. Collection Report Click Selected Title. Click Choose... Click All Titles. Highlight all Titles and click OK (59, 498 chosen) Click List Only Wanted Items. Click Preview Nothing is found. If I use Find->Issue Item Wanted, All the items with Wanted Checked are found.
  8. There is a little bit of a trick when the Title you are entering is so close it brings up an existing Title. This should work: Start to add a New Magazine. Type Title as Monsterscene then press the space bar once followed by the backspace (this de-selects the Aurora Monster Scenes title that was high-lighted). Click OK You should now have a Title entry window for Monsterscene. Continue to fill in the information for the Title (at least Publisher) and continue to the Issue entry window.
  9. Something to keep in mind, is that you renewal ADDs to your subscription end date. For example: Your subscription ends on 1 Dec 2020. If a Sale comes up on, say 1 July 2020, you can renew at that time ( 6 months before it expires) and your subscription will then end on 1 Dec 2021 (1 year from the end of your subscription and NOT 1 year from purchase date. i.e. it doesn't overlap). So if a sale comes around but you still have a month or two (or six...) go ahead and take advantage of the sale as you aren't losing any of your subscription time.
  10. All three are listed under Books in my database, also.
  11. Rename 1.jpg to TPB.jpg 1-2.jpg to TPB-2.jpg 1-HC.jpg to HC.jpg 1-HC-2.jpg to HC-2.jpg From: Pictures\A\Arlington House\All In Color For A Dime Rename Bk 1.jpg to TPB 1.jpg and Bk 2.jpg to TPB 2.jpg From: Pictures\C\Cinemaker\Kolchak Papers, The Rename 1.jpg to TPB.jpg From: Pictures\M\Moonstone\Kolchak The Night Stalker Casebook Rename 1.jpg to TPB.jpg From: Pictures\M\Moonstone\Kolchak The Night Stalker- The Lovecraftian Horror Rename 1.jpg to TPB 1.jpg and 1-2.jpg to TPB 1-2.jpg From: Pictures\M\Moonstone\Kolchak- The Night Stalker Chronicles Rename 1-HC.jpg to HC.jpg From: Pictures\F\Fantagraphics\Pirates and the Mouse, The Rename Bk 1-HC.jpg to HC 1.jpg Bk 2-HC.jpg to HC 2.jpg Bk 1.jpg to TPB 1.jpg Bk 2.jpg to TPB 2.jpg Bk 3.jpg to TPB 3.jpg Bk 4.jpg to TPB 4.jpg From: Pictures\K\Krause\Standard Catalog of Comic Books, The Delete or Move 1.jpg From: Pictures\C\Checker\Templar, The To: Pictures\C\Checker\Templar (Checker) Delete or Rename 1.jpg to TPB.jpg then Move From: Pictures\M\Moonstone\Vampires- Dracula & Undead Legions To: Pictures\M\Moonstone\Vampires- Dracula & the Undead Legions Rename 1.jpg to TPB.jpg From: Pictures\M\Moonstone\Werewolves- Dead Moon Rising Rename HC-A.jpg to HC 1-A.jpg and TPB to TPB 1.jpg From: Pictures\F\Fireside\Excelsior!- The Amazing Life of Stan Lee Rename HC.jpg to HC 1.jpg From: Pictures\M\Marvel\G\Guardians of the Galaxy- Rocket Raccoon & Groot-Steal the Galaxy! Rename HC.jpg to HC 1.jpg and TPB-A.jpg to TPB 1-A.jpg From: Pictures\M\Marvel\M\Marvel Encyclopedia (2nd Series) Rename HC.jpg to HC 1.jpg and HC-4.jpg to HC 1-4.jpg From: Pictures\M\Marvel\M\Marvel- The Characters and Their Universe Rename TPB.jpg to TPB 1.jpg From: Pictures\M\Marvel\W\World of Reading- This Is Thor Delete or Rename 1.jpg to 27-A.jpg then Move From: Pictures\D\DC\B\Batman vs. the Incredible Hulk To:Pictures\D\DC\D\DC Special Series Then Rename 1-2.jpg to 1.jpg From: Pictures\D\DC\B\Batman vs. the Incredible Hulk Delete 1-E.jpg From: Pictures\D\Dreamwave\Duel Masters (Duplicate of 1-A.jpg)
  12. Not sure if this helps or not but I just downloaded the most recent version (v3418 for the Archive Edition) and when I display Grading Sets (on my 4k monitor), the check boxes show up.
  13. Here is a list of most (if not all) of the remaining prose books published by Moonstone that are currently in CB as Comic Books: Domino Lady: Sex as a Weapon The Kolchak Papers Kolchak: The Lost World Kolchak the Night Stalker Casebook Kolchak: The Night Stalker Chronicles Kolchak the Night Stalker: The Lovecraftian Horror Vampires: Dracula & Undead Legions (actual name is Vampires: Dracula & the Undead Legions) Werewolves: Dead Moon Rising More Tales of Zorro
  14. Thanks for the clarification. I should have been more specific.
  15. There is a difference between what the people at HC can write (no limitation) and what we (the end user) can write or do. The reports are made of of 'canned' SQL with a limited amount of modification supplied by the check boxes. Getting Counts with full access to the database with SQL is possible (and pretty easy). However, because of limitations, we can't write the SQL that would allow the type of counts you want (inside CB).
  16. I believe all the signed issues in CB have a COA (Certificate of Authenticity). This normally comes when you buy the signed issue from a company that supplies it at the time of the sale. For the randomly signed issues (i.e. someone took issues to a convention and an artist just signed it without any COA), they are not supposed to be entered into CB. There may be some service you can send you issue to and have them verify (and issue a COA?) but I don't know of any.
  17. Since every issue in CB is assigned a unique identifying number, there is no way to do any kind of count function in CB. The only way I can imagine doing this is to export your data (if you have and Edition of CB that allows exporting) and put it into a database (Access, SQL, etc) or possibly a Spreadsheet and do the count functionality outside of CB.
  18. CB has Title "The Templar" (Checker, 1998). The actual Title appears to be "Templar" as shown at Amazon at https://www.amazon.com/Templar-No-1-Mark-Thompson/dp/B005YCZCR0 MyComicShop also has it as just Templar (but with a 2007 date for some reason) at: https://www.mycomicshop.com/search?TID=412311
  19. CB "Title Shining Beacon" (Idea + Design Works, 2019) appears to actually have the Title "A Shining Beacon" as shown at Amazon here https://www.amazon.com/Shining-Beacon-James-Albon/dp/1603094458 It has the same ISBN-10 number.
  20. Rename 1.jpg to TPB.jpg & 1-HC.jpg to HC-A.jpg From: Pictures\F\Fireside\Excelsior!- The Amazing Life of Stan Lee Rename 1-HC.jpg to HC.jpg From: Pictures\M\Marvel\G\Guardians of the Galaxy- Rocket Raccoon & Groot-Steal the Galaxy! Rename 1.jpg to TPB-A.jpg & 2.jpg to HC.jpg From: Pictures\M\Marvel\M\Marvel Encyclopedia (2nd Series) Rename 1-DLX.jpg to HC.jpg & 1-HC.jpg to HC-A.jpg From: Pictures\M\Marvel\M\Marvel- The Characters and Their Universe Rename Bk 1-HC.jpg to HC.jpg From: Pictures\B\Boulevard\Spider-Man- Goblin Moon Rename Bk 1.jpg to TPB.jpg From: Pictures\B\Boulevard\Spider-Man- Wanted Dead or Alive Rename Bk 1.jpg to TPB 1.jpg & Bk 3.jpg to TPB 3.jpg From: Pictures\B\Boulevard\Time's Arrow Delete or Rename then Move Bk 1.jpg to 1.jpg & Bk 1-HC.jpg to 1-HC.jpg From: Pictures\S\Sterling Publishing\Superman- Sunday Classics To: Pictures\D\DC\S\Superman- The Sunday Classics Delete or Move 21.jpg From: Pictures\I\Image\R\Rat Queens To: Pictures\I\Image\R\Rat Queens (2nd Series) Delete or Rename Bk 14.jpg to Dlx 3.jpg, Bk 15.jpg to Dlx 4.jpg, & Bk 18.jpg to Dlx 2.jpg From: Pictures\D\DC\S\Superman-Batman
  21. Transformers Collector's Club is more of a magazine than comic book. While it does have a couple of short comic stories (about 7 pages each), it is mostly articles/interviews.
  22. I remember that, too, but that was a long time ago. It was removed once weekly updates became a thing (since it would always replace missing Titles).
  23. FYI The words Free Comic Book Day 2009 appears in the Notes of 38 of the issues for 2009. Not sure if that is all or not but it seems like it. HC tries to add this to all the Free Comic Book Day issues (but I won't guarantee it).
  24. A decision was made to drop things like Publication and Comics (to name a few), from the publisher name, so K.K. Publications is in CB as K.K. and Pacific Comics is just Pacific. I am not saying I agree or disagree with this decision but it has been this way for a very long time and I doubt it will be changing. PS I see several covers with Gold Key on the cover but with publisher of K.K. so you would probably enter it with K.K. as the publisher.
  25. Delete or Move All (1.jpg - 5.jpg) From: Pictures\M\Marvel\G\Gamerverse Spider-Man- Velocity To:Pictures\M\Marvel\M\Marvel's Spider-Man- Velocity Delete or Move 1.jpg From: Pictures\G\Gemstone\Mickey Mouse and Blotman To: Pictures\G\Gemstone\Walt Disney's Mickey Mouse and Blotman in Blotman Returns Rename 1.jpg to TPB 1.jpg From: Pictures\M\Moonstone\Tales of Zorro Rename 1.jpg to TPB.jpg From: Pictures\M\Marvel\W\World of Reading- This Is Thor Rename TPB 4.jpg to TPB.jpg From: Pictures\R\Random House\DC Super Friends- Wonder Woman to the Rescue!
×
×
  • Create New...