Steven L. Dasinger

I am not sure if you still have a problem or not with the greyed out items. If you are, what you need to do is select the issue by clicking on the first box on the row (the far left) which should high-light the row. (you can select multiple rows at one time, also). Once that is done, it previously greyed out items should be available.

Run File Tools->Rebuild Lists Series Information. I think the way CB works now is using 'static' lists (at least this is the easiest way to explain). Just adding a new Title doesn't automatically update these static lists. Rebuilding Series information appears to update them.

You can always use Street Date for this. If it is currently empty, you can put what you think is a good 'cover date' in the column. If an actual street date is added, it should replace your estimated date without much difference.

Yes, any column requires data to be useful. Some of this is the Publishers fault as far as Books go. In the past most all books had a Published date in them. However, for the last several years, this information has been removed. Without this information, there is no Cover date data to add to the Issue. For current items, Street Date can be used (but, again, only if that information is known and entered). Getting Street Date for old issues is problematic. To get around this, to some extent, I use one of my Custom Date columns to store dates (I call it Pub Date) for items that don't have data (actually, I store it for all the items I own). This allows me to do some of the date searches you are probably trying to do.

The new database has apparently had some redesign of some of the Tables. Not sure there are individual Titles and Issues tables anymore. I have no knowledge of the actual Tables/Columns and structures than any other user of CB. I can just see little glimpses from the failed SQL statements that are printed in the error messages. However, with SQL there are two ways to qualify column names (normally to distinguish between the same column name in more than one table). One is if the Table is given a reference name. An example is FROM TITLES T where columns in TITLES can be reference with T. i.e. T.Publisher. Two is the actual Table name. An example is FROM TITLES where columns in Titles can be referenced with TITLES. i.e. TITLES.PUBLISHER. I have worked with Databases and SQL for almost 30 years so I can sort of figure some of this stuff out. It is not easy to pass that on when so much is just guess work on a tiny view into the database.

Try this: ComicTitles.Publisher = 'Marvel' AND [ItemNumber] LIKE 'Anl %'

1) If you misidentify you issues variation, you have problems not matter what. 2) Unless your scans are relatively small, the update process shouldn't overwrite the existing cover. Also, since you (should) have your cover scans in a separate directory, you shouldn't permanently lose any of your cover scans. You can just copy them back in, if needed. On my old 24" monitor I created cover scans with a pixel height of around 1,500 for my new, larger monitor, I use 2,000. At those sizes they haven't been overwritten by anything in an update. But everyone's situation is different (smaller screen sizes (especially laptops)) so the way I do it may not work for you.

Just a suggestion as I do something similar (keep my scans in a different directory). What is different is I don't switch directories. I leave CB pointing to a CB Pictures folder and when I create a new scan in my directory, I copy it into CB, letting it replace the cover scan. When you do this, it will delete the old one and replace it with the new one (including the thumbnail).

Everything Fred posted and: If Street Date (or Cover Date) does not have any values, those issues won't be found. However, if you have the Professional (or higher) Edition (and a barcode scanner), you can use Menu Items->Add By Barcode to enter all your new comics without having to use Find to get them in a list.

Yes. Use menu item Setup->Columns to View. You can: 1) Rearrange the order of the columns by selecting an already check one and use the Move Up/Down buttons. 2) Remove displaying a column by unchecking it. 3) Add columns by checking the column( s ) (and then clicking on the field column to activate the Move buttons) then use the Move Up/Down buttons to place them where you like (one a a time. Note, If you check multiple columns, the first click on the Move button will place all the newly checked columns up to the bottom of the already checked columns.

That'll teach me to scroll down... When I typed, Firefly in the search box, the last entry on my screen was the incorrect Firefly: Sting. Just a little scrolling would have shown me the correct Title... Thanks.

All I can say is I haven't experienced anything like this. Running Rebuild Lists and Optimize Database (both under File->File Tools) my help.

Firefly: Sting is not the correct title. The actual title is Firefly: The Sting.

Moved to Books: Rename 1-HC.jpg to HC.jpg From: Pictures\N\Night Shade\Agatha H. and the Airship City Rename 1-HC.jpg to HC.jpg From: Pictures\N\Night Shade\Agatha H. and the Clockwork Princess Rename 1-HC.jpg to HC.jpg From: Pictures\N\Night Shade\Agatha H. and the Voice of the Castle Rename 1-HC.jpg to HC.jpg From: Pictures\T\TwoMorrows\American Comic Book Chronicles- The 1970's Title Name Change: Delete or Move ALL (1-A.jpg - 3-A.jpg) From: Pictures\D\Dynamite\Red Sonja-Vampirella To: Pictures\D\Dynamite\Vampirella-Red Sonja Issue Deleted: Delete 1-A.jpg From: Pictures\M\Marvel\E\Eternals, The (This looks like a legitamete price variant so I am not sure why it was deleted) Move 20.jpg From: Pictures\I\Image\R\Rat Queens To: Pictures\I\Image\R\Rat Queens (2nd Series) Rename 2.jpg to 2-A.jpg From: Pictures\I\Image\U\Undiscovered Country

I may have typed too soon... The test Title I was using seemed to bring up suggestions. However, a closer examination reveals some weird behavior. Here is what I had to do to (apparently) fix it. click the Find drop-down box (to the right of the input box, and select Title Name or Barcode. (Yes, it appears it is already checked but select it anyway. After I did this, it started working as I expect. For some unknown reason, the initial display is acting (for me) as if Storylines was selected.

Just passing on information. I just downloaded and installed 20.0.01.2764 and the psychic typing in the Find box is working for me. Doesn't really help you but at least it isn't a common bug that is affecting everyone.

Try running Rebuild Lists for Series Information.

Brett, ComicBase 2020 Pro Edition does not come with the ability to download covers (that is in the Archive Edition). However, it should not get an error message as you describe. Also, even with the Archive Edition, downloaded covers can and do have watermarks. You can add your own covers. You just have to name them to match the Item #. Basically leave any Alpha-Numeric and replace any other characters with a dash. 1 would be 1.jpg Bk 1/B would be Bk 1-B.jpg After naming you can drag drop them over the Grid area for a Title to add them.

No, you are doing nothing wrong. This process was changed in CB 2020 to just add issues and not merge them.

I am not sure I follow you but... If you mean clicking on the large Cover in the top right corner, you can still do this. Right-click and select Show Picture File and windows explorer window will open with all the *.jpg files for that Title in it. At that point, just select what you want to delete and delete them as you would in Windows..

The Item Checklists report is the only one I see that has the List Only Wanted Items check box. With that checked, you can: Under Titles to Print, click on Selected Titles, then the Choose button. in the next window, make sure All Titles is checked (at the top). Then scroll up to the top of the list and click on the first Title, then scroll down to the bottom, Press and hold the Shift key and click on the last Title. (the should all be high-lighted). Then click OK. At this point you should have x number chosen (currently mine has 58,284) and the report will generated any Wanted items from this list.

Select the Issues by clicking on the left most column. Once the Issues are all high-lighted, right-click and select Quick Change from the pop-up menu. Select Quantity in Stock for the item to change and enter 1.

I can't quite follow the problem. Per the two attached images, it looks like it is working (I get the same list as show when I type the displayed text). One thing to try is run Rebuild Lists for Series Information (for the specific problem you are having). For some information, I have noticed that just making a change doesn't mean it is available for Find. It is like the database information is scanned to make the Find information and the Find information is 'static' (meaning the database info can change but doesn't automatically update the find information). Running Rebuild Lists seems to refresh the find information.

Approximately what size do you create cover scans (normal sized comic) for a 4K Monitor?

Move 1-HC.jpg From: Pictures\T\TwoMorrows\American Comic Book Chronicles- The 1970s To: Pictures\T\TwoMorrows\American Comic Book Chronicles- The 1970's Move 1.jpg From: Pictures\A\Aardvark-Vanaheim\Color Your Own Cerebus in Hell- To: Pictures\A\Aardvark-Vanaheim\Colour Your Own Cerebus in Hell- ?Delete 1-W.jpg From: Pictures\D\Dynamite\Vampirella (7th Series) (Not sure what this is but the issue was deleted. I don't see the cover listed at other sites.)