Jump to content

Brian J. Stewart

  • Posts

  • Joined

  • Last visited

Posts posted by Brian J. Stewart

  1. On 12/29/2022 at 10:42 AM, Steven L. Dasinger said:

    The problem is the difference between what is actually stored in the table and what is displayed in the program.

    The table has the abbreviation (i.e. US) while the display is 'United States'

    PS In Advanced Find it would be (for Comic Books):

    ComicTitles.CountryCode IS NOT 'US'



    Thanks Steve, updated yours to the following to find non-USA books I owned without any hassles.

    ((ComicTitles.CountryCode IS NOT 'US') AND (I.QtyInStock > 0))

  2. I took a few stabs but never got anything to work in advanced, especially since I couldn't get a basic portion to work int he standard find.

    FIND SERIES where COUNTRY CODE is or not "WHATEVER".   The title edit field for a series shows publisher country as "United States [image of flag]" but I can't make it work in search.  Tried US, USA, United State, MERICA, etc.

    The below generic using "is not" and "list only my issues in stock" returns all my titles, if I say *is* for exact match I get nothing.    Looking for some working examples to make this work, so that I can then use advanced query to do similar fancier things.


  3. Yeah... build 2073 finally remembers my window position, including how i have it semi-centered (not fullscreen) on my 2nd vertical monitor layout.       Forever it has been just re-opening however it felt like after i close out CB, most of the time starting up in a weird position spanning my 2nd and 3rd monitors.

  4. On 10/28/2022 at 6:44 AM, Steven L. Dasinger said:

    Short answer is no. There are no 'Last User Date' type fields (that I know of).

    The closest I can find is DateModified. There are also LastQtyChangeDate and LastValueChangeDate but I am not sure how useful those two are.
    At the Title level there are ComicTitles.TitleCreatedDate and ComicTitles.TitleModifiedDate. (ComicTitles would change to BookTitles if you are looking at Books)

    A couple of points.
    For comparisons, use date format of YYYY-MM-DD. ex. I.DateModified >= '2022-10-01'

    Some of these fields may have 'date-time' values (something llike yyyy-mm-dd hh:mm:ss). However SQLite does not have a true Date-Time data type. If they are date-time, using the DATE function on the field to extract the Date part of the data. ex. DATE(I.DateModified) >= '2022-10-01'
    I am not sure which fields contain Date or Date-Time data. You may have to experiment to find what returns consistent results.

    PS DateModifed is are any changes. I would not recommending using on the day you ran the Update as it will modify a lot of rows.


    Hmm, i just tried

    (DATE(I.DateModified) >= '2022-10-21' AND (I.QtyInStock > 0))

    And this did show me issues that I own, that had been modified since Oct 21 unfortunately this field appears to be shared with the weekly content updates.   I was hoping for a I.UserDateModified, so that I could specifically find issues I had altered myself.

  5. Is there a data column something like "last edited by user", something to indiciate that I have personally modified an issue's row of data?


    Use cases:

    1. Build a list of titles/issues added into inventory for 2022.

    2. When you notice your inventory count is off, because you have been adding new series and books into the system that were missing but forgot to set QTY 0 before you were done, and now can't figure out where those books are hiding in your collection.


    query possibly similar to:

    (I.LAST_USER_EDIT BETWEEN '2022-01-01' AND '2022-12-31') 
  6. Is there a published changelog showing what was fixed/added during the interium build releases for CB23?       I've reported bugs, etc and I usually review those on other products to see if something has been fixed, or a new function has been added.

  7. CB23 is much faster for me, however I do notice that my comiccon laptop which pointed to a network drive for all the cover picture/thumbnails is noticeably slower than my desktop rig.   I blame that on network latency, but my laptop is still much faster on the new 64-bit than older versions.

    This tweak is based on your choice for personal security, but I did go into my antivirus (Windows Security/Defender) advanced settings and mark my PICTURES and THUMBNAILS folders as 100% excluded from anti-virus.    I noticed a speed-up on my laptop a bit after this.

  8. 16 hours ago, Steven L. Dasinger said:

    Well, that wasn't quite as hard as I thought.  Try this (if you need to only look for 'For Sale' and/or 'Marked' those can be added.

    I.Title || I.ItemNumber IN (
    (SELECT A.Title || A.ItemNumber
    FROM ComicIssues A
    WHERE A.QtyInStock>= 1
    AND I.Title = A.Title and I.ItemNumber = A.ItemNumber
    GROUP BY A.Title, A.ItemNumber
    HAVING COUNT(*) > 1

    Worked great Steven, I just added a ORDER BY I.Title ASC.    Came back with less than 1000 books which kind of surprised me, but I think is accurate.   I can then tweak this further later on to eliminate items marked for-sale already, or my items set with reserve quanity protection.


  9. Thanks Steve.  MinimumQty did work to find the "Reserve Quantity" field.    I am using that to help find my dupes, that have not yet been broken out for-sale.

    #using this advanced query

    (I.[ForSale] IS False) AND (I.QtyInStock > 1) AND (I.[Marked] IS True) AND (I.MinimumQty < 1)        
    I.QtyInStock DESC,I.Title ASC

    This gives me a rough-and-dirty list of duplicate issues I have not flagged for sale. 

    1. I then duplicate the found item showing QTY 2+
    2. Now I mark the new item with the exact QTY I want for sale, so that it is kept in a separate row in my database.
    3. then the original row gets updated to lower quantity (my keeper copies)
      • and I also set the "Reserve Quantity" to the same value.   
      • My extra safe-guard to not sell these, when i run some safety queries later.

    I do realize I could just flag the whole issue as for-sale, and then use the reserve quantity for sale --- but I tend to err on the side of caution to ensure I don't sell books by mistake.  

    And this query does not help when I have (6) copies of a single book in varying grades, a good place for me to start.   I'll have to scour the forums for some adv.find examples to help me find those where ISSUE has QTY > 1 spanning multiple grades later.



  10. I did some casual searching but could not find a list of all the fields used in the database.   Has data dictionary been published somewhere listing all the item/title field names and date types?      I got here trying to find the "Reserve Quantity" field.     I made educated guess for I.ReserveQuantity and I.ReserveQty but the adv.find did like them.

  11. You can blame ASOMBRO on me, as I put in the request to fix the title name.   I figured (errr assumed) the weekly updater would have some magic flag for renamed titles and auto-magically resolve.  I guess not.

    Dear CB techies, can this be done?   If a title gets renamed, or anything that impacts the folder path a flag be set so the updater can do that work and solve all these file dir naming issues?

  12. If this was implemented the interface would have to allow you to define your home language/country (English or just United States), that way the definition of foreign could be applied properly.     Or maybe a checklist of languages you only want, or not want; whitelist vs. blacklist mentality.

  13. Peter / Mark / CB crew:

    Hopefully this is not an insane request, but can the edit issue dialog box be revised to allow you to update (save in place), and also provide Next  + Previous issue navigation buttons as i have demonstrated in the picture below?


    When I get in mass edit mental mode, I am churning through data in bulk.  Having to save and then select the next issue to edit really is much slower.   I will admit this interface request is mimic'd from what I first saw within then ServiceNow ticketing system, which I use daily at work.    I can update (save-in-place) an edit, then hit next record to get within the same workflow.

    I already make heavy usage of the Ctrl+G (quick change) feature, but that only helps when the data is the same. Whereas this update/next/previous modification would be for churning through data that varies, like cover dates, ISBNs, etc.  when I have an entire box of comics in my lap and chugging through book after book consecutively.

    Thanks for listening.

  14. I can't figure out how to bulk insert new issues with blank dates?

    I create a new title, from Spain in this example.   I then create issues 1-52, and set the cover date to blank because I have to pull them from indicia later.   CB2020 then creates issues 1-52, with #1 getting a blank date like I wanted, however the rest start their cover date as 1/1/1900 and increment one month forward.

    I then try to bulk edit 2-52 to set them back to blank, except the wiz-bang interface won't let me because it has the very nice calendar widget but in this case blocks what I am trying to do.



    Does anyone have a work around for either of these items?

    1. how to enter new issues and get the dates to be blank like i want

    2. how to fix multiple issues and set the date back to blank.


  15. Yes, I have this same problem on my #3 (middle) monitor which is running in portrait mode at 1440x2560.   


    The portrait monitor is my default/primary/main window, aka "Make this my main display" option in windows.    However I have yet to find any window size while CB2020 runs on portrait screen that will survive a restart, it always comes back full screen.    I still think this is a bug in the new CB.


  16. Kaleb,

    Glad to hear it.  You can also find my very cheap .bat file solution I use to send my database to all my cloud backups when I exit CB2020, over in the old forums at https://atomicavenue.com/forum/topic.asp?TOPIC_ID=9359 

    Nothing special, but it gets the job done.   I shovel backups of my CB data everywhere because, no way am I going to re-enter 16000+ books again.   I even have my very last backup of data from every version of CB going back for the last 10 years, just in case i need a reference.  Disk storage is cheap, time and data entry is not.     I even copy a file onto my Android phone's SD card every now and then.


  17. If you had already configured database file backups under the preferences options, you have a backup you .cbdb you could restore, then try starting CB with that copy.   Not sure if it by default makes auto-backups.  

    Look in your folder to see if there are, below is my example directory.   rename bad file, then copy last backup to the file name and open it.   


  18. 3 hours ago, Steven L. Dasinger said:

    One thing to try is run Rebuild Lists for Series Information (for the specific problem you are having).

    Yes, "Rebuild series list"  crashes for me, some of the other rebuild options do not crash.  I've reported this to tech support since beta days.   So I can't tell if that will help if it won't complete with throwing a .net DBNull error.

  19. Okay, the 2nd picture from my post was supposed to show the failure from my main laptop... my goof.     So let me try again, this what happens when i use the Find option.    I just type, and nothing auto-magically matches and display anymore, used to work, but stopped on this machine. 


  20. My main PC with CB20 (build 2743) now longer does psychic typing in the Find dialog, and I'm not sure why unless I accidentally disabled it.      But it works fine on my convention 2-n-1 tablet, and the screen capture below is an example just to make sure everyone gets understands my context.


    Any ideas on how to get this back to working?    When I type it matches nothing, but I can type a full or partial name and hit enter, and the find box loads the closet match just nothing displays like my working example above.




  21. O

    21 hours ago, Michael R. Wagner said:

    Steven, I understand, but since I threw away the image and emptied the trashcan, I don't have the answer.  I offered the image size in hopes that might lead to some insight - apologies for sending you information you didn't need.  Thanks for the help.



    I can't make any profile picture image fail for me.   Even my custom GIF i made years ago works for this forum's profile.   I'll blame Friday the 13th on your issues, even if it was yesterday the 12th.

  • Create New...