Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 12/1/2020 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. 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
  8. Last week was Hell Week for the message board servers and a few other things, so there was no livestream while those things received maintenance. I haven’t heard anything about this week’s livestream, but I *assume* that it isn’t happening since no link has posted yet only 12 minutes before the usual showtime.
    1 point
  9. I've had all the variants listed above in my collection for years and they are only now showing up as unrecognised items. From a collector's point of view, the kind of paper a comic is printed on makes a difference to me. I would would much rather have the glossy paper than newsprint as the glossy paper ages much better. I know that if I bought a comic off of Atomic Avenue with the expectation that it was printed on glossy paper and instead received one printed on newsprint, I would not be happy. And for what it's worth, I bought all the newsstand editions from mycomicshop.com, an
    1 point
  10. 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
  11. The "Titles" pop-up is the window that I think you are looking for. Does it have a "Modify" button in it? If so, then that is what you are looking for.
    1 point
  12. I think the glitch regarding AA searches only turning up comics and not books or magazines has been fixed.
    1 point
  13. and we, the god-fearing citizens of Rock Ridge...
    1 point
  14. uninstall your CB2021 edition AND the CB2021 resource file from your App list Next, refer to this article on what to do next:
    1 point
  15. Not sure what you mean by scan books to a list, but there is a way to make a change to multiple items at one time. That is with Quick Change (CTRL + G). However, to be able to use Quick Change you need to be able to select multiple items. You can do this this with a Find. If you have a way to do a Find to select all the items, that would be the easiest but isn't always possible. In those cases you can use the Marked column (you may have to use Setup->Columns to View to see it. Once you have it displayed you can click on the box to Mark it. Continue by Marking all the ite
    1 point
  16. 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
  17. 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
  18. I would suggest getting a barcode scanner (assuming you don't have one or that you can afford one). Barcodes started in the mid-70's. However, at the beginning, they used the same numbers over every year (i.e. the number used for Feb 1978 would be the same number used for Feb 1979). By the 80's, I believe, they were using the longer, more unique codes. CB has a lot of these already in the system (but not all, by any means). By using a barcode scanner, assuming the number is already in CB, with the 'Add by Barcode' menu item, it will find the issue being scanned, even if it is a non-intuiti
    1 point
  19. Sounds like this will be addressed at this week's ComicBase Livestream!
    1 point
  20. On the "Add by barcode" window, can it be changed - or have added - the total cost of books being added? Currently, it has total cover price. I like to make sure I've got the price paid entered correctly, and being able to compare the cost on my sales receipt to this screen would be *very* helpful. It was there in previous versions, BTW.
    1 point
  21. I third the motion...
    1 point
  22. I second, this suggestion.
    1 point
  23. I think that it ended up as Fables Book #22.
    1 point
  24. That's a lot of Lego! Bet you could build something really cool with 49,003,621 Lego pieces!
    1 point
  25. 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
  26. 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
  27. 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
  28. 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
  29. Haven't had a chance to make the actual submissions on this one yet. Hoping to get to that tomorrow.
    1 point
  30. 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
  31. 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
  32. Sales data is collected for Atomic Avenue and from Heritage. If you ever notice a price for a listing in the database that should be looked into, use the 'Request Price Check' option under ComicBase's internet menu; our editorial team will look into it further and adjust if needed.
    1 point
  33. You can add custom grades and percentages. ComicBase makes valuations based on a % of their NM pricing. For instance, CGC 9.0 is 160% of the value of a NM non-graded book. If you want to add a SS grade, simply go to Setup/Grading, and click on the green + to add a new grade. Example is for a 25% premium for SS over the CGC Universal grade. You'll have to do some math, but it should give you what you want. FYI: The percentages that CB uses for 9.8 grades can be wildly off base. My 9.8 NM 98 shows a price of $6,800, which is 1200% of the NM price they list of $570 for the book. I *wish*
    1 point
  34. 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
  35. All our data for Dynamite future releases come from Diamond solicitations. The variants they provided to Diamond also isn't always organized in a way the cover gallery might state inside the printed issue. Another problem is that they don't get all the variant cover info for a given issue like store variants, convention variants, etc. We typically learn of a issue's complete cover gallery on its release day when we have a physical copy to reference and/or a user sends us a correction for a variant we don't know about.
    1 point
  36. A good example of the problems that can be created is this past week's Die!namite #4. That issue (similar to other Dynamite and IDW comics) often have a cover gallery that will explicitly give a cover letter (Die!namite 4 lists "peanuts homage cover art" as cover H, but it wasn't listed in the database, and variant H was already used for one of the exclusives. In that case, I'll list the letter from the cover gallery in the notes when I submit, and leave the variant letter alone.
    1 point
  37. A more in-depth discussion of UPC's, Alt-UPC's, ISBN's (including difference between ISBN-10 and ISBN-13) might help clear up some confusion. In addition to the newsstand vs direct market UPC differences for the same issue (perhaps not a universal thing for all publishers, but definitely there for post-"Spidey face box" Marvel for instance), it appears a large number of floppy comics in the database show ISBN's which I would expect to apply only to books, or at least comics bound in a book format. Are these auto-generated based on the UPC input? Also, it appears the ISBN-10 format is generally
    1 point
  38. Thanks for your detailed information. I reached out to Pete and he informed me that he uses the Dymo LabelWriter with the Dymo Address Labels as you mentioned as well. I'm behind on the LiveStreams but hoping to catch up as they are very informative. Will be checking out Label City and the Dymo LabelWriter, thanks again.
    1 point
  39. Try: For Checked: I.[CustomCheck2] = TRUE For Unchecked: I.[CustomCheck2] = FALSE PS You could use 1 instead of TRUE or 0 instead of FALSE (a checkbox is a binary choice) but TRUE and FALSE are a little clearer what you are doing.
    1 point
  40. 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
  41. program updater file may have been still syncing to the server when you tried to download it. try again. If you still have trouble, please let our team know at support@comicbase.com
    1 point
  42. Strange. Try it this way, bring up a Find window (CTRL+F or click the Magnifying glass icon). Select MyComics in the Find drop-down box. Optional (and should be redundant), click the List Only Items In Stock check box in the bottom left corner. When I run this I get a result of all my comics.
    1 point
  43. 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
  44. 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
  45. Find All My Owned With Cover Date For A Year (2017) & Sorted By Value Items Where... I.[CoverDate] >= "2017-01-01" and I.[CoverDate] <= "2017-12-31" and I.[QtyInStock] > 0 Order By I.[Price] desc Owned Platinum Age Comics & Sorted By Value Items Where... I.[CoverDate] > "1897-01-01" and I.[CoverDate] < "1938-03-31" and I.[QtyInStock] > 0 Order By I.[Price] desc Owned Golden Age Comics & Sorted By Value Items Where... I.[CoverDate] > "1938-04-01" and I.[CoverDate] < "1956-08-31" and I.[QtyInStock] > 0 Order By I.[Price] de
    1 point
  46. Actually, now that I actually bring up the install window, the option is to Replace Matching Files (which should, pretty much, do the same thing (unless you have your own, larger, covers)).
    1 point
  47. 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
  48. Not sure if it's feasable, but how about a button for, download covers for all titles in stock/in collection?
    1 point
  49. I love being able to check my collection on the go using the app, but I have a pretty long wish list and a ton of titles in my collection so sometimes I really need to scroll a lot to get to the title I am interested in. A drop-down list allowing you to jump directly to a title or being able to search would make the reports much easier to use. Is this doable?
    1 point
  50. 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
    1 point
×
×
  • Create New...