Fred Slota

Myst hive hid e typpo...

Thanks. I had tried T.[], and ComicTitles. hadn't tried ComicTitles.[] Out of curiosity, why the difference between ComicTitles.AlphabetizedTitle and ComicTitles.[CustomCheck1]?

Want to find recent holes in series I'm interested in. This is the process I envisioned... Search for owned issues over the last year (Street Date), sort by ComicBase order. Walk through the list, deciding which titles have runs of issues I'm interested in verifying. Set a custom Title Checkbox for the titles I'm interested in checking. Search for all issues over the last year (Street Date) of Titles with the Custom Checkbox set, sort in ComicBase order. Walk through the list, setting Issue Wanted checkboxes of issues that I want. 1) It appears that there is no simple way to, from the grid of returned issues, to modify a Title Custom Checkbox. I have to choose to Modify an issue, then edit the Title Info, then Check the box, Save, Save. I'm I missing something? 2) Having set a Title Checkbox, how can I build a search for step 4, looking at Title Custom Checkbox? 3) Would there be a quick way to clear the various Title Custom Checkboxes when finished, preferably without editing each title info?

I believe so, which is why I posted a recipe that used it.

I added a bunch of issues with the app, adding the current date, "1/7/21" in the Notes field. After imported into ComicBase, searched for the issues in ComicBase order: Comics with "1/7/21" in the Notes field, sorted in ComicBase order Items Where... I.[Notes] LIKE "%1/7/21%" Order By ComicTitles.AlphabetizedTitle, I.[ItemType], I.[IssueNum], I.[Variation], I.[Printing]

Trying out the app for new issue entry. I have a stack. 1) Scan a barcode, wait for the buzz, issue information comes up. 2) Scroll up 3) Tap Add 4) Pop-up giving positive feedback. (I assume there is a version where it tells you if it fails?) 5) Tap Scan More 6) Black screen. Tap to turn on camera. Can we speed this up? Either add some configuration options, or add a more streamlined batch-add mode? a) For step 2, put a duplicate "Add" button at the top? Focus on the bottom of the page? Or, least liked, shrink the cover image to fit all on one screen? b) For steps 4-5, if addition succeeds, give feedback with a brief toast of a green check, that shows up and disappears on its own, without needing to be dismissed? c) For step 6, go straight to an operating camera, ready to scan the next book? For batch-add functionality, how about adding the ability to either auto-set a selected custom check, auto-fill a selected custom date, or auto-append either a timestamp or a user-entered string into either the Notes or a selected custom text field?

Is the AlphabetizedTitle field still accessible to Advanced Find, as that will put the titles in the same order as in ComicBase?

I agree. We have a setting for Mature Only, but not for Owned Only? While we're making suggestions, how about the option to have it display based on an Advanced Find search. Think of the flexible use... A store could display current issues, or sale issues, or... How about the option to choose between full screen single cover, collage, or both? How about the option for Full Screen Single Cover to include a caption, identifying the book, and maybe the notes?

Thank you for the prompt reply, but I think you missed the subtlety of my question. The canned "Released this week" search is not simply looking for I.[CoverDate] >= "2021-01-01" and I.[CoverDate] <= "2021-01-08". The canned "Released previous week" search is not simply looking for I.[CoverDate] >= "2020-12-25" and I.[CoverDate] <= "2020-12-31". They both return issues with Cover Dates that span more than a week. They both return some issues with blank Cover Date fields. So, what are the canned searches searching on? And can it be extended to find earlier release weeks?

Apologies if this is already in CB2021, upgrading tomorrow... When I conduct an Advanced Find, I can set the maximum returns. But, how do I know if I've hit the max or not? How do I know how many results I've found. If there is a pop-up with that information as it loads, it goes by so fast. Can a results count be shown somewhere more persistent? Also, could the "Items Where..." field be displayed to remind what has been searched?

Anyone want to supply an "Order By" syntax that sorts in ComicBook Order?

Released this week... check. Released last week... check. What if I want to find earlier weeks? How do the first two work? I search for this week, and I get books with Cover Dates of 3/1/21, 1/1/21, 11/1/20 and blank. I search for last week, and I get books with Cover Dates of 12/1/20, 2/1/21, 2/15/21, and blank. What is it searching on?

I've re-upped my subscription. I currently have ComicBase 2020 Archive Edition, specifically 20.0.2.3599. I plan on updating to CB2021. Is CB2021 it's own new animal, requiring an uninstall and new reinstall, or, in spite of the name change, is it implemented as more of an patch upgrade? I could not find an updater specifically for CB2020, or what the most recent version is; the current installer is for 2021, and the most recent legacy is for CB2017. Is the database format unchanged from CB202 to CB2021?

I was mainly wondering, since this is not a new book. My copy is still sealed in cardboard, and is apparently shrink wrapped inside the box, so I don't think I'll be reading from the indicia any time soon...

Appears to be similar to "Captain America: The 75th Anniversary Vibranium Collection" a MSRP $200 Hardcover collecting reprint. Packaged in a printed cardboard box. UPC 9 780785 193296 59999 Does it already exist? Should I enter it myself.

So, continuing my wraparound updating saga... How do I force thumbnail reloads, either on individual issues, titles, or the whole shebang? I've rerun all list rebuilds, I search for Height/Width ratios and find items with wide pictures... but not all the thumbnails show the wide pictures. Some show the original single-panel-sized scans. But, if you focus on the picture, it will show the full wide picture.

Book Pictures processed through 2244... Comic Pictures - 878799...1%...5%... Most of the time, processing runs at a rate where I can visibly follow the progression in the 10's digits. Occasionally, it runs at rates visible at the 100's or even 1,000's. 10%...20%...25%...50%...85%... done The same search now appears to find everything. As I was watching it go, I had to keep waking the screen up, which got me thinking... I think the past couple days when I ran this overnight, my power save would kick in 3 hours into the process, interrupting the process without warning or error. This time, I was watching it, and part-way through I changed my power settings to prevent it from cutting out. I'm guessing that the picture scan process runs in two parts because of the two types of file structures, with all the single-layer pictures run first, then the four deeper trees, and that my PC was shutting down early into the processing for those. Well, now I know,. And knowing is half the battle...

My math was getting 3 decimals of fractional precision out of integer math. I ran your version, and I'm getting the same results. I did a search looking for owned issues with PictureWidth > 1, and definitely no DC, Marvel, or Image, but yes for Dark Horse.... I've been doing all this on my tower, which I just updated the software, database and picture stores as a backup from my laptop. I had reperformed all the list processings after the updates. I tried running a similar search on my laptop, and it finds everything. I think that the picture index process is not operating to completion on the tower. I'll try the list rebuild again and try to pay more attention. I can say, I did not see any error messages pitched when I previously performed it.

I must be missing something here. (((I.[PictureHeight]*1000)/(I.[PictureWidth])) <= 1100) AND (I.[QtyInStock] >= 1) returned 23 results, way less than there should be, for example missing the X-Men (2nd Series) 1/E and 1/F, the first I could think of. Removed the QtyInStock, and added it to the OrderBy field, returned more, still the same 23 I own, and still missing many, many, including the above X-Men covers. Build 3599 I have already run Optimization and Rebuild All Lists, including pictures. I'm pointing at the official ComicBookScans directory. Possible hint... I don't think I see any Marvel or DC, and possibly Dark Horse or Image. Is it populating the database with data from the deeper ordered titles?

Searched for the Item Field PictureFileSize IS NULL showing only Items in stock, and it found nothing. Same for <100. Same for all items. Advanced Find Qty and FileSize does work.

It was 3433. Uping to 3599...

I've pointed the system at my personal cover scan directory tree, and that works, I see them in the program. I rebuilt all Lists, including picture files. I search for I.[PictureFileSize] is less than or equal 1000, List only items in stock, and am told no matching items were found. Same for greater than or equal 1000. Same thing for all issues, not just in stock. Same thing for PictureHeight and PictureWidth. I tried Advanced Search for I.[QtyInStock] > 0, sort by I.[PictureFileSize] with Max Results to 30000, and this looks promising. 21,848 results, showing 5,000 at a time. But... When I click the arrow to see the next 5,000, the numbers change, but the issue grid does not update-I still see the same 5,000 issues. So, I've got the following... 1) Searching in Picture fields don't appear to work. 2) Searches of more than 5,000 are not viewable 3) I still don't have the information I wanted to have.

We have #1, #3 and #4. Scooby #2, Where Are You?

Running 20.0.1.3085 Sidekick updated, Lock Notes checkbox unchecked. Issue #1 for me still has the notes "Pink Skies; The Joes; Blue Sky Background".

We might also want to allow a little user fine-tuning of what is included as "regular". Maybe someone wants to see lettered variants even when a regular issue exists...