Jump to content

Fred Slota

  • Posts

  • Joined

  • Last visited

  • Days Won


Posts posted by Fred Slota

  1. Yup, that's the one.


    Okay.  Maybe I'll get around to entering it tomorrow.


    Question: Are there additionally separate entries for the individual books in other box sets, if you were to find the book on its own?  Should I try and make 1 entry for the boxed set, and 11 entries for each individual book?

  2. Just picked up from a local discount store chain.


    It is a boxed set of 11 hardcover Avengers compilations.  The box has a magnetically secured hinged front cover that opens to show the 11 spines which form a continuous image across the top of the spines reading "The Avengers: Earth's Mightiest Heroes", with each book having an individual title on the bottom of the spines.


    The Box has UPC 9-784615-916312-59999, ISBN 978-1-302-91631-2 and 'cover pricing' of $500 US, $575 CAN.


    The books have no external UPC or ISBN and are all invidually shrink-wrapped, so I can't see if there is any indicia.


    I can provide pictures and individual book titles, if necessary.


    Any ideas what this might be?

  3. Yeah, it's not reeeeealy wrong...  Comicbase follows it's own logic - Search has its own memory of which media it is focused on, and its own widget for changing the media.. It starts focused on whatever media you were browsing, but after that it goes its own way, regardless of how you change when browsing.  It's fools like me, who spend nearly all the time thinking about Comics Books and just assume everything defaults to Comics all the time, or that the Search will always follow the Browse, well, which one of us is wrong, me or the software?

  4. And the saga continues.....  One problem on me, and two more problems on ComicBase...


    I replace ComicTitles.AlphabetizedTitle with I.[Title] and no more errors...   But no books found.  ???


    Okay, maybe I entered the month without a leading 0, let's try that.  Still no books found.

    So, I search for one of the added books.  Yup, it's there.  Quantity 1.  What's in the note field?   Well, today is my birthday, and instead of putting today's dat in the Notes field, I entered it with my birth year.   Duh.



    So, I correct the year in the search, and rerun the search.   Still no books found.  What is going on now?

    I search for just the two digit year, let's say I.[Notes] LIKE "%89%" (Similar to Dragnet, the Years have been changed to protect the old).  Okay, that returns a lot of books, my newly added books, books where the notes mention that year, books where the note mention a matching issue number.

    So, let's expand, and I try a search for the month and year, "%10/89%".  No books found.  What's up with the '/' character, which has been part of my usual search test for years?

    And lastly, I try a wildcard.  I.[Notes] LIKE "%10_89%".  Again, no books found.  What's up with the wildcard, or is it the wildcard for '/'?

    I figure I'll sidestep all this with ANDing LIKEs for "%07%", "%10%" and "%89%".  Well, that returned items.  I see references to issue #1071 and the like.





    Aaaaaaand, it is at this point that I realize what is going on.

    Because, I notice that the Title of the first returned item isn't a Comic Book.  It's a magazine.

    My collection is at least 99.999% Comic Books.  I'm almost always manipulating Comic Books.  Buuuut, the last thing I had previously done was enter an issues of Marvel Previews, which is....  a Magazine.

    So, when I launched ComicBase today, I was starting up looking at a Magazine.  And when I launched Find, it started out on Magazine.  Which, of course, does not have a ComicTitles.AlphabetizedTitle field. And even when I looked up a specific Comic Book I had entered, to verify what was typed in the Notes filed, of course that doesn't change the focus of the Find window when I reopen it.   And of course, Magazines did not have any issues with my birthdate in the Notes field, as I hadn't entered any new Magazines.  And of course, searches for the date with a "/", or a wildcard, wouldn't find any.


    Find on Comic Books, Load my saved Advanced Find, fill in the correct date, as I entered, and everything works as should, like it has been doing for years.



    Congratulations, ComicBase.  You have made me feel old on my birthday.






  5. Scanned new books with the App.

    Added the current date in the Notes field for each book.

    Imported into ComicBase with New Sales and Purchases.

    Load up the Advanced Find I've been using for a couple of years to pull up the new issues, so I can verify the quantities and scan the covers. 

    Put in the correct date, press find, and... Error?


    My Advanced Find does a custom sort to put list the Issues in ComicBase order, as that is how my collection is organized.  The first field in the sort order is ComicTitles.AlphabetizedTitle.  This is now being reported as an SQL error, that the column no longer exists.


    Has this been renamed?  Has this been hidden from access via Advanced Find?


    Help would be appreciated.  Thank you.

  6. You misunderstand entirely...  Not saying it's a user problem...  More a realization that there are multiple users, with multiple different opinions on what they want, and a solution that simultaneously supports both a fixed official title so CB can update official entries, with official descriptions and valuations, and a flexible alternative/addition set of fields that supports as many different users' views on how to name, group, sort and describe, would satisfy most users.

  7. Okay, it happens...  A comic title gets entered with a wrong punctuation, or the title is changed between solicitation and publication, or a particular oddball book get's entered as one thing, but later reevaluation moves it as another.  And so, new titles and issues are added to the official database, old titles and issues are deleted from the official database, and the content updater ripples these additions and attempts these subtractions, leaving many users who already entered inventory into their databases with unrecognized titles and issues.  Okay, yes, we have the report of unrecognized titles and issues to help us find the orphans, but it's then a process of finding each new title, verifying each matching issue, and then transcribing your quantities, custom fields, grading notes and possibly other information.


    Suggestion - add a numeric Migration field.  Each migrated old and new issue will have a unique Migration number assigned to it, negative for the old and positive for the new..  When the updater tries to delete an old issue, if you have inventory and the updater can't delete the issue, then the negative Migration number is added to that issue's Migration field.  The software can now add a feature to search the database for negative Migration numbers and their matching positive Migration numbers.  This could be used to generate a list or report that shows which old issues you have and where they should be moved to.  Better still, this could be used to produce a ComicBase tool that shows these pairings, let's you review them, select from them, and automate the migration of your inventory from old entries to new entries.  And you can select which other fields to copy over with the quantity; custom fields, grading notes.  With a little behind-the-scenes work, this tool could even cross the ComicBook/Book/Magazine divide and help with the shifting of entries across those categories as well.


    I would imagine this system would not be backfilled with historical information about older issue migrations (although that would be increasingly helpful for people who haven't reconciled their unrecognizables), but going forward I'd guess this would be very helpful.  


    I would also suggest that this tool also open the Unrecognized Items list, for those issues that won't be supported by Migration numbers.

    1. Add an option to auto-generate a Wanted Report when Sidekick Save to Cloud.
    2. Add support for Wanted status, or Wanted lists, to the other existing reports. Item Checklist already has "List only wanted issues", but what about filtering on or reporting status of Wanted issues for Collection Overview, Collection Report, etc.?
  8. Thanks Mark, but, that's what I did on 4/26, when I was first told Crystal Reports had a problem.  And that resolved the problem. 


    And then I installed the newest update, and it broke again.  


    Are you not concerned that this has happened?  Is there anything I can look at and report back to help with understanding how it is broken and how it happened?  I thought that this was a recently resolved issue and was not expected to happen with current updates?

  9. So, I've been playing around with an Excel Workbook to find Holes.  In the process of, about a week ago I went to update my Cloud Saved Wanted report, and was told there was a problem with my Crystal Reports.  I didn't think anything of it, as there had been recent discussions about this problem, so, I followed the directions, uninstalled, removed SAP CR, reinstalled, and everything was happy.  I produced a new Wanted Report, saved it to the cloud, with a 4/26/2022 date.


    A couple days later, through Check for Updates, a new version of ComicBase was found,  I installed this.  I noticed that during the update, it said it was doing something with SAP CR.  I didn't think anything of it at the time.

    With the help of my Excel tool, I started adding some Wanted issues.  I then decided to generate a new Wanted report.  I am now, again, being told that there is a problem with Crystal Reports.  This is 5 days and 1 CB program update after I had successfully repaired Crystal Reports.  Before I go through the process of uninstalling/reinstalling, is there any other advice you could give or information you would want to know?

  10. I'm working on an Excel-based tool to support Hole Hunting, similar to Adam Sternberg's Collection Hole Finder. Ultimately, the goal is to update the Wanted status on issues in ComicBase, for Wanted List Reports and AtomicAvenue Wish Lists.

    The intended flow is

    1. Output from ComicBase a CSV Item Checklist of Owned and Missing issues in Owned Titles
    2. Load Item Checklist data into the spreadsheet
    3. Generate a listing of missing issues in holes
    4. Research/decide which issues in the listing you want/don't want on the spreadsheet
    5. Update the Wanted status of issues in ComicBase.
    6. Additional Research/decisions of which issues you want or don't want in ComicBase

    There are two features that I don't think are in ComicBase currently that would streamline this process.

    • Add an option to include "Wanted" as a field included in the Item Checklist.  (I could copy Wanted to a Custom Checkbox and output the Custom Checkbox, or I could generate a separate report of Only Wanted issues, but the ability to directly output Wanted Status would simplify the process.)
    • Add an Import option that doesn't effect Quantity, but can Set/Clear Wanted, Marked or Custom Checkbox state for issues.
  11. This item appears to currently be listed as variant 1/Q of the title "Demon Days: X-Men".  I'm not sure this is the right place...

    Content-wise, I can see the similarity, as it contains the inked-but-unwatercolored contents of the source book, "Demon Days: X-Men", but this book is twice as long, as it also contains a creator note, character studies and raw pencil-art for most of the book as well. 

    Having said that, the Indicia reads "Demon Days: X-Men Creator's Cut" and the book has a UPC that is different (75960620312300111) from those of the others (for example, 1/O listed as 75960620105100130), clearly indicating Marvel's intention that this is a non-variant #1 issue of a separate title.

  • Create New...