Jump to content

Brian J. Stewart

Members
  • Posts

    24
  • Joined

  • Last visited

Everything posted by Brian J. Stewart

  1. I saw a bagged issue at my store last week but did not pick it up. It looked exactly like this one https://www.ebay.com/itm/204153054927
  2. I should have been more specific. Since around 11/9 (Wed) my messages to support@comicbase.com are going out initially, but then I get that undeliverable alert from gmail the next day, it is not instant, at least 12+ hours after the send. I'll just keep firing out my usual feed of messages, but not sure anyone is getting anything especially since I have not had any replies since around the 9th either.
  3. I've been getting bounce backs for the last 2 days trying to send to support@comicbase.com -- anyone else? This is what my gmail web client message says: There was a temporary problem delivering your message to support@comicbase.com. Gmail will retry for 21 more hours. You'll be notified if the delivery fails permanently.
  4. 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. 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. ---BRIAN
  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. I then duplicate the found item showing QTY 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. 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. ---BRIAN
  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. Fred, See my comments i the old forum at https://atomicavenue.com/forum/topic.asp?TOPIC_ID=9342&SearchTerms=highlight about using the Themes. I have color-blind issues, and changing the theme got my row highlighting to the way i view better.
  14. 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.
  15. 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.
  16. 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. -BRIAN
  17. 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. -BRIAN
  18. 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.
  19. 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.
  20. 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.
  21. 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.
  22. O 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.
  23. So i was looking for a way to change grid view limit to what I own or not own. Well, had not see that during beta. Nice ... now my huge Detective Comics grid is back to manageable, at least until i fill in that small gap between issues 0 and 276. Now I just need one more item in this last drop down "Un-owned Items". -BRIAN
  24. yep. duplicate the issue and track the grading and cost independently. My Green Lantern collection is riff with multiple, as I upgraded my silver age collection over the years. dupe it, and all is simple after that.
×
×
  • Create New...