Jump to content

Steven L. Dasinger

Moderators
  • Posts

    1,517
  • Joined

  • Last visited

  • Days Won

    72

Everything posted by Steven L. Dasinger

  1. Here you go. Suggestion. If you multiply what you are doing that results in Cost by the Qty in Stock value, you will get 0.00 if Qty is 0 or the actual Cost if you have Qty of 1 (or more).
  2. Here is an example (although this is the case for most, if not all, of the Magazines). The Red circle shows Qty 0. The Blue circle shows the Price (what it is currently worth). The Black circle shows the item #'s 'Cost' me 1.80 and 2.25 for ! and 2, respectively. But, since I never bought them, the Cost should be 0.00 and NOT the Cover price * the Discount set in preferences. This is true for Books and Comic Books (although only for newer (i.e. updated) Comic Books), I think.
  3. Yashakiden: The Demon Princess (Digital Magna 2010) is a prose novel with some illustrations and should be moved to Books. At Amazon, https://www.amazon.com/Yashakiden-Demon-Princess-Novel/dp/1569701466/ref=sr_1_1?dchild=1&keywords=yashakiden%3A+the+demon+princess&qid=1592098752&s=books&sr=1-1 you can 'look inside' to see what it is like.
  4. For the most part, I think you have it. There have been 7 series of Vampirella published. 2 by Harris and 5 by Dynamite. I am not sure if they will adjust the names to be Harris, 1st & 2nd Series along with Dynamite 1st, 2nd, 3rd, 4th & 5th Series or not.
  5. Not sure about the freezing part but for the 'Cannot run 2 databases at once' part... Open Task manager, find the ComicBase 2020 (32 bit) app, right click on it and select End Task from the pop-up menu (or high-light it then click the End Task button at the bottom). This will terminate the already running process and allow you to (attempt) restating CB. Before restarting CB, if you don't have the latest version (v20.0.2.3433), I would download and install it. It may help. PS when I installed this version, when I opened CB, it was delayed while it did something regarding Items (can't recall exact message) but it had a progress bar and, even though it seemed to not be moving at times, it eventually finished and opened CB.
  6. Rename All (TPB 1.jpg - TPB 352.jpg) TPB x.jpg to x.jpg (where X is the number. ex: TPB 1.jpg to 1.jpg) From: Pictures\A\Alan Light\Buyer's Guide for Comic Fandom, The Rename 8.jpg to 202.jpg From: Pictures\B\Blake\Fantastic Films Delete or Move ALL (1.jpg - 6-B.jpg) From: Pictures\I\Idea + Design Works\Other Dead To: Pictures\I\Idea + Design Works\Other Dead, The Rename 1.jpg to TPB.jpg and TPB-A.jpg to .jpg From: Pictures\B\Ballantine\Shadow, The (Ballantine) Rename: 84.jpg to 1305.jpg 146.jpg to 2301.jpg 147.jpg to 2302.jpg 149.jpg to 2304.jpg 155.jpg to 2404.jpg From: Pictures\S\Sovereign\Sci-Fi- The Official Magazine of the Sci-Fi Network
  7. What does Cost represent? What an Item # Will Cost? or What you Paid for it? If it what you Paid for it, it should be 0 unless Qty in Stock is >=1.
  8. I think this is a "Feature" and I am not sure it is a good idea. If you a Find for last weeks new items in Comic Books, All ha a Cost entered (even if Qty is 0). The only ones that don't are ones that have a Cover prices of 0.00.) So it isn't just Magazines (or Books). If it is a Feature, what I am about to suggest may not last past the next update (and I would try on a copy of your database, just to be safe). And this will affect all items in a section (Magazines, Books, or Comic Books). Select menu item Items-><Mass Change (or CTRL + M) Make sure the drop-down box in top left corner is set to Magazines. Use Change drop-down box to select Cost. Click Radio button next to Value and then type in 0.00 in the box. At this point you can click the Apply To radio button for All Titles to get everything or Selected Titles to then select various Titles. Once ready, click Make Changes. Note: There will NOT be any Undo for this (hence the 'work with a copy warning I mentioned while testing to see if this does what you want). Again, the next update MAY set them all back OR set any new ones to have a Cost value other than 0.00. I am with you in that, if you don't Own any of these items, there should NOT be a Cost entered for them.
  9. CB has title Other Dead (Idea + Design Works 2013). The indicia Title and the Title on the cover is: The Other Dead.
  10. 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.
  11. 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.
  12. 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.
  13. 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
  14. 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.
  15. 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.
  16. 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.
  17. 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.
  18. 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.
  19. All three are listed under Books in my database, also.
  20. 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)
  21. 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.
  22. 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
  23. Thanks for the clarification. I should have been more specific.
  24. 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).
  25. 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.
×
×
  • Create New...