Leaderboard

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

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

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

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.

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

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

The current CB value is $11,500. Mostly due to a Fine issue offered for sale at $4,300 on AA. Right now on eBay you can buy a CGC 9.6 for $250. This is EXACTLY why you shouldn't use an 'offered for sale' price on a thinly traded issue. It completely skews the value of the comic for everyone. Can you fix this pricing issue? https://atomicavenue.com/atomic/item/249771/1/Weird-War-Tales-64

Correct. I like functions and was glad you posted about it. I was just writing something up on that... While the Year component may not be as efficient, it can be used for Month, Day of Month, and (possibly) Day of Week. For example If you want all items put out in a particular Month (January in the example): strftime('%m', I.CoverDate) = '01' You can also constrain it to a Year range (Month January between 2010 and 2019): strftime('%m', I.CoverDate) = '01' and I.CoverDate Between '2010-01-01' and '2019-01-01' The Day of Month and Day of Week are probably most use

While strftime('%Y',I.[CoverDate]) = '2022' does work, using: I.CoverDate BETWEEN '2022-01-01' AND '2022-12-31' is easier to remember and more efficient. Query with function strftime takes 23 seconds to process while Between takes 1.75 seconds. (Ran each query several times and got the same results each time. For those interested, the reason is the function has to be applied to every row before the comparison is made. The Between just has to compare.) PS In case someone hasn't found it, there is an Advanced Find Guide/Manual (work in progress) for those who need a little

Look at 'Wizard World Chicago Convention Program' or 'Baltimore Comic-Con Program' to see an example of what you could do.

Until this feature is implemented (if it is), here is one work-around. Do a Find for Qty in Stock >= 1. Once the results are displayed, select / hi-light multiple issues. Right-Click and select Download covers from the pop-up menu. NOTE: There is a limit (not sure what it is) on how many covers you can download at one time. Depending on the number of Items you have, you may have to do this several time.

Also, in the screen shot where you type 'WEB', the drop down list of suggestions are NOT Titles (they are characters). Assuming the gray text in the box before you typed had 'Title name or barcode', try using the Find drop-down next to the box and select another item (i.e. Publisher) then select 'Title name or barcode'. (sometimes it loses what it is set for. PS The list of suggestion makes it appear that you have one of the appearances selected.

That would work. If you have an example of a case where it didn't go through or get accepted, send in a correction then email our team at support@comicbase.com and we'll take look at it.

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.

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

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.

If the variants have different paper, usually that also resulted in a different cover price and that would automatically qualify those variants as trackable in CB as separate items. Personally, even if the cover price was the same, I would recommend that the variants be tracked separately if the paper stock is different. Maybe it is worth bringing this up at this week's Livestream?

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

When entering credits with multiple names, please don't use 'and' to join them together. For example: The cover of a book has 'Judith and Garfield Reeves-Stevens' Incorrect: Judith and Garfield Reeves-Stevens Correct: Judith Reeves-Stevens, Garfield Reeves-Stevens Multiple people are listed: Incorrect: Ross Andru and Dick Giordano Correct: Ross Andru, Dick Giordano Incorrect: John Buscema, Gil Kane, Neal Adams, and Boris Vallejo Correct: John Buscema, Gil Kane, Neal Adams, Boris Vallejo Also, just enter names. For example Incorrect: John Buscem

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.

and we, the god-fearing citizens of Rock Ridge...

uninstall your CB2021 edition AND the CB2021 resource file from your App list Next, refer to this article on what to do next:

you need to fully highlight the issues so any greyed out options become select-able.

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

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

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

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

Sounds like this will be addressed at this week's ComicBase Livestream!

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.

I third the motion...

I second, this suggestion.

That's a lot of Lego! Bet you could build something really cool with 49,003,621 Lego pieces!

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.

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?

One thing you can try, is to go to the CB website and change your password. It might 'refresh' or clear some cache. Not sure if this is the same but when the recent Mobile app came out, I could not log in with my correct Userid/Password (similar to you). Changing the password seemed to clear 'something' up as I could then log in to the mobile app.

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.

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

Haven't had a chance to make the actual submissions on this one yet. Hoping to get to that tomorrow.

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?

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

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.

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*

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.

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

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.

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.

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

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?

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

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