Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 12/6/2019 in all areas

  1. 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
    3 points
  2. I would put your collection in some kind of order first. It can alphabetical, divided by publisher, divided by character, whatever works for you. Putting the books into CB won't be an overnight process and having some system in place will make it a lot easier to step away whether it is for a day or two or a few months and get right back into the groove when you return. Creating a space is a great thing to do if you can. Setting up on the dining room table is fine until you have to clear it off for dinner. If you can have some little corner to yourself, you can bring in a box at a ti
    2 points
  3. Store variants and online store variants are tricky for us because our solicitation data mainly comes from Diamond and Lunar distribution who don't care them. Thank goodness for our user community who send in data for variants we aren't aware of. Unfortunately, we can have users assign different store variants than others possibly messing up what you might have set yourself for a variant. Not sure there's a good way to get around this, you might want to email support@comicbase.com about a store variant you might have assigned just so we know not override it if a different store varia
    2 points
  4. If it is an older comic, the odds that two missing variants would be submitted in the same week are probably low. But for new and fairly recent comics, I can see this as a concern. You can always post on these boards or email support, that gives Marc, Pete, or somebody else at HC to communicate back to you if they will be using a different variant designation than the one that you selected.
    2 points
  5. For deletions, the best bet would be to either email support or post on these boards. The correction submission function from your database doesn't really handle deletions... and deletions often require some sort of explanation anyway, so best to do that via email or public board posting. Generally speaking, go ahead and create the entry in CB and submit. But, if you are entering something that is complicated for some reason, then posting to the boards can generate some helpful discussion. Also, if you can't find a fairly common title, it might be best to pos
    2 points
  6. It would be interesting (to me at least) to have a better understanding of how database corrections are processed when they are submitted through CB via the "Submit New or Corrected Data" feature. Filling in an empty field seems pretty straightforward, but what if the correction is deleting duplicate or extraneous information? If someone thinks they have found a new title, is it appropriate to create an entry in CB first and submit it that way, or would that be better for the message board? How much headache do I cause when I upload a correction, immediately realize that I left something out o
    2 points
  7. Not sure if it's feasable, but how about a button for, download covers for all titles in stock/in collection?
    2 points
  8. I can't comment intelligently on the cause of value changes without knowing your collection--all we really do is compute rolling averages on market pricing (a couple million data points each week). That said, one of the features we're looking to incorporate soon is to automatically generate a list of top dollar and percent gainers each week for your collection as it does the update, as well as other reporting tools. Watch for it as we get underway by checking the interim builds page on comicbase.com > support -Pete
    2 points
  9. It might be a good idea to add the Mark/Unmark back to the context menu as well. We omitted it since the menu seemed to be getting awfully long, but it'd likely be a good idea to put it back. (You never really know how much some features are being used until you try omitting them from a version!) -Pete
    2 points
  10. By the way, if you use the Find box (top middle of the window) and change it to Publisher, you can start typing a Publisher name and see what shows up. Since the part left off of the Publisher is on the end, this should find any you are looking for that are already in the database. Don't trust the Setup->Publisher listing as not all Publishers are in there (not sure why). For example, I checked there for Dream Weaver and didn't see it. But the Find DID find the Titles that are using it.
    1 point
  11. First, I would be careful about adding Publishers. For example, 'Dream Weaver Press' would just be 'Dream Weaver' CB usually leaves of common endings for a Publisher. These include (but are not limited to) Press, Meida, Publishing, ext. Sometimes they are added if there are Publishers with similar names. If you do enter an 'incorrect' (from HC's perspective), and they catch it, they well change it. What this means is the next Update will add a New Title in your database with the 'correct' publisher which will be a duplicate of the one you entered. This should show up on the Unmatched I
    1 point
  12. I had an issue after updating to 2021 (build 1240) where, upon the first startup when it got updating the media file, an error would occur saying the Database was locked. I canceled the startup and made sure Comicbase was no longer running (via Task Manager) Then I started Sidekick and did an optimization of the database. Once done, I tried launching the main ComicBase again and successfully got past the lock point. Hope this is helpful to anyone else who encounters this issue
    1 point
  13. I think the glitch regarding AA searches only turning up comics and not books or magazines has been fixed.
    1 point
  14. and we, the god-fearing citizens of Rock Ridge...
    1 point
  15. When entering Books into CB the Binding Type needs to be considered. For this post, I am only addressing MMPB (Mass Market Paperback) and TPB (Paperback) in the United States. NOTE: HC should have used Trade Paperback instead of just Paperback in the drop-down box to be less of a problem. MMPB are smaller in size. Generally around 4.25 x 6.75 inches. TPB are larger. Around 5.5 x 8.5 or 6 x 9 or even 8.5 x 11 inches. Most of what most people thing of as Paperback books are MMPB. Go to any drug store of grocery and just about all the softcover books you see are MMPB. TP
    1 point
  16. I am assuming that these comics from the 1980's or so. At that time, Marvel comics were distributed to the newsstands on a returnable basis and to comic shops on a non-returnable basis (aka "direct sale"). Newsstands could get credit for copies that weren't sold, but to prove that the comics weren't sold they had to send back the covers (in earlier times, they had to send back the entire comic, but sending back just the covers made that less expensive). Direct sales had a bigger discount, but if the retailer didn't sell all of their copies, they couldn't return them. To prevent
    1 point
  17. I second, this suggestion.
    1 point
  18. For new items, use Menu item Setup->Preferences... Near the bottom, change Standard Cost from Zero to Cover Price and Discount to 0%. NOTE: You can, of course, use other settings but the above will set Cost to Cover Price. For the following, make a copy or backup before proceeding, just in case 'something' goes horribly wrong... This will change ALL Issues and not just the ones you own (although you can limit it to just Titles you own). For existing items, I you can try Menu item Items->Mass Change. Select Mass Change. Set Change to COST Set To to Field, Cover Pr
    1 point
  19. If you have a copy of Fantastic Four #1 in your collection and then you add a second copy of FF #1, that will change your count of total issues but NOT your count of unique issues (you already had a copy of FF #1 before you acquired the second copy). So I think that your problem really is that at least one issue in your collection has an unusual number entered into the Quantity In Stock field. To find the issues with an excess quantity, do the following: Go to any Comic Book title (not a Book or Magazine title). Click on "Find" and select "Other" You should now have a s
    1 point
  20. I'd also like to have the ability to use the original UPC barcode...A number of comics either don't include the barcode (older direct sales) or have the barcode on the back of the issue, which is obviously not visible when bagged.
    1 point
  21. Pete's currently working on a problem with our automated report processor for the past few days that's been very troublesome. No real time table when it'll be fixed but hoping things get rectified asap.
    1 point
  22. I manually backup Collection Overview to the cloud weekly. Sometimes it takes days for my reports to show up under "My Comics" on CB Website and in the mobile app. I did it twice today andi t's still showing me May 4 as latest Collection Overview. I can see my latest Backup on the CB Weebsite. Anyone else having this problem?
    1 point
  23. Just finished watching the livestream #43 where Pete asks for ideas for the picture for the front of the next version of comicbase. Previous covers have covered golden age horror, crime, sci fi, and super hero genres. The one category missing is romance. Many of the golden age publishers did romance titles. For example a cover based on for example any of the issues of Secret Love by Ajax or similar would be my shout. Take care folks.
    1 point
  24. For the mark Jewelers issues they are in higher demand and also getting more collector attention because the mark jeweler inserts are a thicker insert which helps maintain the comic to maintain a better more desirable condition. Mark Jewelers insert comic issues were primarily distributed on a limited basis near military installations. These Comics were the same as all the other Comics except they had the mark Jewelers insert. I've checked several resources my comicshop.com I've checked eBay I've checked Comic Vine I've checked other sources in most cases Mark Jewelers have a usual $8 to $15 p
    1 point
  25. Haven't had a chance to make the actual submissions on this one yet. Hoping to get to that tomorrow.
    1 point
  26. I noticed that there isn't a new Livestream announcement on the ComicBase homepage for today. Does this mean that Pete is taking a break from the Livestream this week?
    1 point
  27. Until HC figures out an official way to way to check for any Titles that you have in your Database but are NOT in the Master Database HC maintains, here are steps to get the same (and better) information. It is better because the old method only found Titles. This method will find Titles OR Issues. 1) Make a copy of your database. Use Menu item File->Save a Copy and give it a new name. 2) Switch to the new copy. Use Menu item File->Open... 2.1) Optional. Change Theme. Use Menu item File-Theme... Using a color that is NOT your normal Theme will let you know this is
    1 point
  28. I know I can find duplicates now by going to: Items > Find > "Qty In Stock" > "is greater than" > "1" and it will identify the multiple copies (2+) of comics of the same issue and the same grade. There in lies the problem as for example I have an Amazing Spider-Man #194 in CGC 9.6, CG 9.0 and an ungraded copy and to me, I have two duplicates of issue #194 that I may wish to sell and just keep the highest graded copy. It would be very handy to identify duplicates of the same comic issue, regardless of the grade. This would be extremely useful for collectors in MHO. Thanks for consid
    1 point
  29. Yes, I had the same problem. After waiting a little longer, I successfully updated to the newest release. PS As you noted (and I learned), if you get the Modify, Repair, Delete box, that means it is trying to install the same version as you already have.
    1 point
  30. Short answer. No. Longer answer. No way. Even longer answer.... Uh, I better not post it... (A, you don't have direct access to the database and B, you can't open 2 databases at the same time) ======= After think about this I came up with a better answer. It is still NO but the reason is... There is no direct connection between the two databases. They can't see each other. The reason my solution above was possible is there IS a connection between the database and the HC Master Database via the Update process. Without that, the only option is to export the data to another p
    1 point
  31. at the moment, auto-reports are generated for all media categories. I will mention to our programming team if that can be tweaked in the future.
    1 point
  32. Build 1200 (released now) changes the algorithm for appearance indexing to no longer strip off parentheticals. To take advantage of the change, you'll need to (1) Update to build 1200 (out now) and run through File > File Tools > Rebuild Lists > Lists of contributors, storylines, and notes. (The latter step is not needed if you're upgrading from a previous version of ComicBase directly to build 21.0.0.1200 or later, as the upgrade from a previous version forces a rebuild of those contributor lists anyway in order to enable Psychic Typing 2.0 -Pete
    1 point
  33. i got the same andrew,ill try and re download it again and ill let you know if it worked or not
    1 point
  34. when comicbase 2021 is installed (the program doesnt run my databases as above) - but go to screensavers (in windows settings)and select the comicbase screensaver (archive edition only). To see it in action use the preview button.
    1 point
  35. I have the same problem. Reinstalling 2020 now for the third time
    1 point
  36. For this type of problem, it is probably best to contact support@comicbase.com.
    1 point
  37. The Solomon Kane: The Original Marvel Years Omnibus, like many of Marvel's omnibus books, has a regular edition and a direct market variant. The database lists these as Book #1 and Book #1/HC, respectively. To be consistent with other Marvel hardcovers that have regular and DM variants, these should really be listed as Book #1/HC and Book #1/A, respectively. This would require changing the existing Book #1 to Book #1/HC and changing the existing Book #1/HC to Book #1/A. Thanks!
    1 point
  38. make sure you are using the latest build for CB2020 (v20.0.3.3829), you can download/install the latest CB2020 program installer from your online account here: https://www.comicbase.com/mycb/Registrations.aspx Next, make sure in Sidekick's settings, that in the General Tab you have the desired database listed. If you don't see it, feel free to add it. Subtract any database from the list you don't use. Also, in the Schedule Tab, review what is set there. Ideally you want to schedule any of the options at a time when your computer is on and you're not using the main ComicBase software. Try
    1 point
  39. The basics to adding an Item # (Issue) that is not in CB are: Go to the Title you want to add the missing Item # to. Click on the + button (located above the grid on the right side of the window) By default, it will be filled in with the next Item #. You can change this for the Item # that you are adding the variant. For a first Variant, you would normally just need to change the Variation to the next available letter. ex. If there are no variants listed, you could choose Variation A. If there are already Variations A, B, and C, you can choose Variation D. You can change/add
    1 point
  40. Hi Mark -- *Usually* you simply add the issue using the next variant letter in the alphabet. Sometimes, however, there are so many variants for a particular issue that ComicBase runs out of letters of the alphabet for the variants. (See the infamous "Crisis of Infinite Godzillas" thread over on the old message boards for more info on that.) For which specific comic book issue are you trying to add a variant? EDITED TO ADD: The mechanics of adding the issue and scan etc to your database are covered in ComicBase Livestream #14 starting at roughly the 30 minute mark.
    1 point
  41. There's enough new issues and pictures now in Comic Base It might be nice for the next release to fix all the obvious/glaring mistakes in the data such as writer =. ,Artist is 56, barcodes in the wrong field, Wrong cover dates (when you add issues it calculates the date by adding a month), mis-spelling of names (big no no), missing cover prices when we have a picture etc. It's probably a days work for the obvious ones (I'd even volunteer) and would make the database so much more easier and save time. Just a thought
    1 point
  42. 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.
    1 point
  43. Each issue should be listed as a variant of the issue it is reprinting.
    1 point
  44. Success! I reset my scanner and programed it as I had before but also added "CODABAR SEND START/STOP CHARS-ENABLE" and now it works! Thanks so much for the tip! Incidentally, I finally found that old thread where this barcode scanner was recommended.
    1 point
  45. An Item number is composed of up to 4 items. Type, Issue_Number, Variation, Printing. If all 4 are used it would be: Type Number/Variation-Printing Example using all four: Bk 1/A-2 Not all need to be used. 1 Issue Number only 1/A Issue Number with Variation 1-2 Issue Number with Printing 1/A-2 Issue Number with Variation and Printing 1-2 Issue Number with Printing Bk 1 Type with Issue Number Bk 1/A Type with Issue Number and Variation Bk 1/A-2 Type with Issue Number and Variation and Printing
    1 point
  46. will adjust for the next content update. thanks.
    1 point
  47. I had the same problem except I was using 3 custom check boxes, 4 custom fields and one custom date field. Only the custom check boxes retained any information. So I am switching back to the 2017 Archive edition until I can get a couple of days off to try and fix this. But if there's Gary's problem, John Pelszynski's problem as well as mine, maybe there's a bug?
    1 point
  48. Have a look at build 20.0.1.2874 (just posted). It should address this issue for you. If you have any trouble, please contact me directly. -Pete
    1 point
  49. Just like on our old message boards, we would like folks to follow a few basic, common-sense rules to make things fun and reasonably polite for everyone. If you have any questions or problems, please feel free to send a note to the moderators or administrators. General Rules: Respect the netiquette: this is common sense. Just as society has rules for how to interact in real life, the 'Net has rules for proper conduct on the web. No ALL CAPS yelling, no spamming, and no flaming. Lurk around and get to know the forums and how to post if you're unsure about the conventions. Post
    1 point
×
×
  • Create New...