Jump to content

Steven L. Dasinger

Moderators
  • Posts

    1,096
  • Joined

  • Last visited

  • Days Won

    55

Everything posted by Steven L. Dasinger

  1. Delete 1-D.jpg From: Pictures\D\DC\B\Blood Syndicate- Season One (duplicate of 1-C.jpg) (the following are all low resolution versions and should probably just be deleted but...) Delete or Rename 1.jpg to 740.jpg 2.jpg to 852.jpg 3.jpg to 967.jpg 4.jpg to 1017.jpg 5.jpg to 1074.jpg 6.jpg to 1122.jpg 7.jpg to 1177.jpg 8.jpg to 1212.jpg 9.jpg to 1281.jpg then Move From: Pictures\D\Dell\Chilly Willy (Walter Lantz) To: Pictures\D\Dell\Four Color Comics (2nd Series)
  2. I am not so sure that is how Item Title is meant to be used. I think it is mainly for individual issues who's Title name on the cover doesn't match what the CB Title is. Usually in an Anthology type series. See 'Four Color Comics' (1st and 2nd series), maybe Classics Illustrated, Eclipse Graphic Album Series, etc. I don't think its intent for when Titles changes name. But, I could be wrong. I am sure the editors will respond with guidance.
  3. The suggestion limited in the number of suggestions. It puts the most likely matches first (note they all begin with 'Spider-Man'). Another way you can to this to get a complete list is to do a Find (click the little magnifying glass to right of the box). Then use either the Item Fields or Series Field and select Title (Item Field will return all issues in the Titles it finds with Series Field will return just the Title names). How you search is up to you, but if you are not sure of a name, I would suggest 'Contains' the type in what you are looking for. In your example, that would be 'Spider-Man'. Or you can try 'Parker' or 'Peter Parker'.
  4. 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.
  5. Delete or Rename HC 0.jpg to HC.jpg MMPB 0.jpg to TPB.jpg MMPB 0-A.jpg to CD.jpg MMPB 0-B.jpg to HC-A.jpg MMPB 0-C.jpg to MMPB.jpg (Note: MMPB and TPB should be in next week's update) From: Pictures\T\Tor\Battlestar Galactica (Tor) Delete or Rename HC 3.jpg to HC.jpg MMPB 2-A.jpg to MMPB.jpg MMPB 3.jpg to TPB.jpg then Move From: Pictures\T\Tor\Battlestar Galactica (Tor) To: Pictures\T\Tor\Sagittarius Is Bleeding (Tor) Delete or Rename HC 1.jpg to HC.jpg MMPB 1-A.jpg to CD.jpg MMPB 1-B.jpg to HC-A.jpg MMPB 1-C.jpg to MMPB.jpg Then Move From: Pictures\T\Tor\Battlestar Galactica (Tor) To: Pictures\T\Tor\Cylons' Secret, The (Tor) Delete HC 2.jpg and MMPB 2.jpg From: Pictures\T\Tor\Battlestar Galactica (Tor) (duplicate/incorrect covers) Delete or Rename MMPB 3.jpg to MMPB.jpg then Move From: Pictures\L\Lancer\Elric (Lancer) To: Pictures\L\Lancer\Stealer of Souls, The (Lancer) Delete or Rename MMPB 4.jpg to MMPB.jpg then Move From: Pictures\L\Lancer\Elric (Lancer) To: Pictures\L\Lancer\Sleeping Sorceress, The (Lancer) Rename MMPB 1.jpg to MMPB 1-2.jpg and MMPB 3.jpg to MMPB 3-2.jpg From: Pictures\D\DAW\Diadem Series, The Delete or Rename MMPB 2-2.jpg to MMPB-2 then Move From: Pictures\B\Berkley\Thongor (Berkley) To: Pictures\B\Berkley\Thongor and the Dragon City (Berkley) Delete or Rename MMPB 4.jpg to MMPB then Move From: Pictures\B\Berkley\Thongor (Berkley) To: Pictures\P\Paperback-Warner\Thongor in the City of Magicians (Paperback-Warner) Delete or Move 1.jpg, 2.jpg and 3.jpg From: Pictures\A\Action Lab\Samurai 2.0 (Antarctic) To: Pictures\A\Antarctic\Samurai 2.0 (Antarctic) Delete or Move ALL (1.jpg - 947.jpg) From: Pictures\E\Editorial Novaro\Aventura (Serie aguila) To: Pictures\E\Editorial Novaro\Aventura (Novaro) Delete or Move 529.jpg From: Pictures\E\Editorial Novaro, S. A\Aventura (Editorial Novaro) To: Pictures\E\Editorial Novaro\Aventura (Novaro) Delete or Move 1.jpg From: Pictures\M\MU\Champion of Katara, The To: Pictures\C\Crack O'Dawn\Champion of Katara (Crack O'Dawn) Delete or Rename 2.jpg to 1.jpg then Move From: Pictures\M\MU\Champion of Katara, The To: Pictures\M\MU\Champion of Katara, The (MU) Delete or Rename All from x.jpg to Anl x.jpg (where x is the number/variant) Then Move From: Pictures\A\Avatar\Escape of the Living Dead Annual To: Pictures\A\Avatar\Escape of the Living Dead (Note Anl 1-A.jpg (Body Count) is replacing incorrect (and duplicte of Anl 1-C.jpg (Rotting)) cover scan) Delete or Move 1.jpg From: Pictures\C\Center for Cartoon Studies\Health and Wealth To: Pictures\C\Center for Cartoon Studies\Health and Wealth, A Graphic Guide to the US Healthcare System Delete or Rename Bk 1.jpg to TPB.jpg From: Pictures\M\Marvel\M\Mighty Marvel Superheroes' Cookbook Delete or Move 1.jpg From: Pictures\M\Marvel\S\Strange Academy (2nd Series) To: Pictures\M\Marvel\S\Strange Academy- Finals (Note: This is a preliminary cover) Delete or Move 1.jpg From: Pictures\D\Different Rules\The Return of Mark Hamill To: Pictures\D\Different Rules\Return of Mark Hamill, The Delete or Move 1.jpg From: Pictures\S\Scout\West Moon Chronicles, The To: Pictures\S\Scout\West Moon Chronicle, The Delete or Move 12.jpg From: Pictures\S\Starlog\Star Trek- Voyager (Magazine) To: Pictures\S\Starlog\Official Star Trek, The- Voyager Magazine Delete 2-H.jpg From: Pictures\A\Avatar\Escape of the Living Dead- Airborne (Duplicate of 2-E.jpg)
  6. Delete or Move 1.jpg From: Pictures\R\Rebellion\August- Purgatory Underground To: Pictures\R\Red 5\August- Purgatory Underground Delete or Move 1.jpg From: Pictures\F\Forbidden Fruit\Subterra To: Pictures\#\4Winds\Subterra Delete or Move 1.jpg From: Pictures\H\History Channel\Josh Bernstein and the Search for Shangri-La- A Digging for the Truth Adventure To: Pictures\H\History Channel\Digging for the Truth Delete or Rename 1.jpg to TPB.jpg From: Pictures\I\Image\P\Powers Scriptbook
  7. I believe that feature was removed to fix other problems with CB 2023 development. What you can do is select the cell with the Title name. Use CTRL+C to copy, then, in the Find Box (top center of wiindow), use CTRL+V to paste the Title name. Not as easy as double-clicking but it does work.
  8. 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 ) )
  9. By the way, if you want to do a little work, and you want to be really safe, you could have 2 databases. You personal (not for sale) database and your For Sale Database.
  10. I will save you some time. There is not way (or at least not easy and even then probably not) to find multiple 'duplicate issues) that are enter entered as separate issues. The cut down version of the SQL that is the advanced find isn't really able to do that. I will give it some thought and see if I can figure out a way. PS The main reason is you would need to 'Group By' go consolidate those issues into one unique item. Advanced Find does not have a Group By.
  11. By the way, Reserve Qty is in the drop-down fields list.
  12. I am not sure if this is the correct column or not but try: MinimumQty
  13. Not sure I got the exact reason. My guess is that using generic Variations A-Z and Vxx is the direction they want to go. The other way of coming up with 'named' variants (which have to be relatively short wasn't working very well over time. There could be other reasons.
  14. Not sure if this will help (but it can't hurt). Try running File->File Tools, Optimize Database. Not sure what version you are on. The most current is v23.0.0.1876. If yours is not there, I would try updating. If you have 'Check for interim updates' checked in Setup->Preferences, just use Internet->Check for Updates to install. If not, go to the ComicBase website, and under My Account->Registrations, click on the green arrow next to your most current registered product, then download/install. (for the download/option, you could uninstall CB and CB Resources before the Install. NOTE: this will NOT affect you database or picture/media files.)
  15. I sort of agree with you but when i asked, they said no. Entering Science Fiction Book Club Edition and(if available) Cover Catalog Number: xxxx was what they agreed to allow.
  16. Delete or Move HC.jpg From: Pictures\S\SelfMadeHero\Agatha- The Real Life of Agatha Christie To: Pictures\N\Night Shade\Agatha H. and the Airship City Delete or Move TPB.jpg From: Pictures\D\DC\B\Batman- Dead White To: Pictures\D\Del Rey\Batman- Dead White Delete or Move TPB.jpg From: Pictures\D\DC\B\Batman- Knightfall and Beyond (Bantam) To: Pictures\B\Bantam\Batman- Knightfall and Beyond (Bantam) Delete or Move HC.jpg and TPB.jpg From: Pictures\D\DC\B\Batman- The Complete History To: Pictures\C\Chronicle\Batman- The Complete History Delete or Move HC.jpg From: Pictures\D\DC\B\Batman- No Man's Land (Pocket Books) To: Pictures\P\Pocket\Batman- No Man's Land (Pocket) Rename MMPB 3.jpg to MMPB 1.jpg From: Pictures\P\Paperback\Brak (Paperback Library) Delete 1-A.jpg then Rename 1.jpg to 1-A.jpg From: Pictures\I\It's Alive\Battle for Britain- From the Pages of Combat Delete 1-A.jpg, then Rename 1.jpg to 1-A.jpg From: Pictures\I\It's Alive\D-Day- From the Pages of Combat Delte 1.jpg and 1-A-2.jpg From: Pictures\I\It's Alive\Dunkirk- From the Pages of Combat Delete 1.jpg From: Pictures\C\Comics Experience\Egged Delete 1-A.jpg then Rename 1.jpg to 1-A.jpg From: Pictures\I\It's Alive\Midway From the Pages of Combat Delete 492-B.jpg and 492-C.jpg From: Pictures\M\Marvel\U\Uncanny X-Men, The
  17. PS If you have multiple Types (Books, Comic Books, Magazines, and/or Newspapers), you will need to do this for each Type.
  18. No. Mass Change doesn't have any filtering capability. But you can do this with Regular or Advanced Find. Advanced Find: I.[QtyInStock] >= 1 AND Price >= 5.00 Regular Find: Start a Find. In the Find drop-down box, select Item Fields->Price Change the drop down box to Is Greater Than or Equal To. In the input box, type 5.00 Make sure the List Only Items IN Stock is checked. For both: When you have the results, select all the rows (CTRL+A). Right-Click and select Quick Change from the pop-up menu. Change: For Sale To IS Checked.
  19. Here is one way: Use Find (regular or Advanced) and use 'For Sale' IS Checked. Once you have the results, use CTRL+A to select all. The Right-click and select Quick Report from the pop-up menu (or use F7). Notes: 1) If you want a different report, from the pop-up menu, select Report Selected Titles As, then the report you want to use. 2) If you have different Types (Books, Comic Books, Magazines, and/or Newspapers) for sale, you will need to do a Find for each Type separately.
  20. The first thing I would try is use File->File Tools and run Optimize database. If that doesn't help, you can try to Uninstall / Reinstall CB: Use Window Apps to uninstall ComicBase and ComicBase Resources. From CB website, use My Accounts->Registrations then click the green arrow next to your active version of CB to get to the download. After downloading, install it, NOTE: Uninstalling/Reinstalling does NOT affect your Database or the Pictures/Media you have. PS You can check on you C drive in Users\Public\Documents\Human Computing\Flags to ensure you have the country flags.
  21. I have a way that is a little easier (a variation of option 1, copy then paste to spreadsheet). Use File->Collection Statistics Use Show drop-down box to select 'Comic Books' (or whatever type you want the information for) Use Show Breakdown By: drop-down box to select 'Cover Price' Use CTRL+A to select all rows in the display. Use CTRL+C to copy the information. Then Paste into a spreadsheet. After that, you just need to multiply Cover Price by Total Qty and sum this amount to get cover price of your entire collection (with duplicates accounted for).
  22. Not a problem. I find myself 'over-thinking' on some entries, also.
  23. I am not sure how you could print this information out (that does not mean it can't be done, just that I don't know). I don't know what is being using for a comparison to determine what the text color. If it is something that could be worked into a Find (probably an Advanced Find), then you could print what is found.
  24. Not sure if this is what you need or not but... If you use menu item Setup->Preferences and, near the bottom set 'Item Value Change Grid' to something other than None, you can see if a Price changed by the color. For Classic (Hot/Cold), the text of an issue will be Black (no change), Red (changed lower higher), or Blue (changed higher lower). For Financial (Shads of Gain/Loss), the text will be Black (no change) or two different shade, each for little or a lot of change either Higher or Lower.
  25. Delete or Rename TPB x.jpg to MMPB x.jpg then Move From: Pictures\P\Pocket\Marvel Novel Series To: Pictures\P\Pocket\Marvel Comics Novel (Pocket) Delete or Move ALL (1.jpg - 1-K.jpg) From: Pictures\M\Marvel\A\AXE- Eve of Judgement To: Pictures\M\Marvel\A\AXE- Eve of Judgment Delete or Rename 9-A.jpg to 1-A.jpg then Move From: Pictures\Z\Zenescope\Grimm Fairy Tales Myths & Legends Quarterly- Wonderland To: Pictures\Z\Zenescope\Grimm Fairy Tales Myths & Legends Quarterly- Wonderland- War of Madness Delete or Move 1.jpg From: Pictures\L\Leaf Candy\Secret Origins of Aquaman To: Pictures\L\Leaf Candy\Secret Origin of Aquaman, The Delete or Move 1.jpg From: Pictures\L\Leaf Candy\Secret Origins of Batman To: Pictures\L\Leaf Candy\Secret Origin of Batman, The Delete or Move 1.jpg From: Pictures\L\Leaf Candy\Secret Origins of Flash To: Pictures\L\Leaf Candy\Secret Origin of the Flash, The Delete or Move 1.jpg From: Pictures\L\Leaf Candy\Secret Origins of Green Lantern To: Pictures\L\Leaf Candy\Secret Origin of Green Lantern, The Delete or Move 1.jpg From: Pictures\L\Leaf Candy\Secret Origins of Hawkman To: Pictures\L\Leaf Candy\Secret Origin of the Hawkman, The Delete or Move 1.jpg From: Pictures\L\Leaf Candy\Secret Origins of Superman To: Pictures\L\Leaf Candy\Secret Origin of Superman, The Delete or Move 1.jpg From: Pictures\L\Leaf Candy\Secret Origins of Justice League of America To: Pictures\L\Leaf Candy\Secret Origin of the Justice League of America, The Delete 1-SC.jpg From: Pictures\D\Dark Horse\B\Bang! (duplicte of 1-C.jpg) Delete 6-A.jpg From: Pictures\I\Image\L\Loaded Bible- Blood of My Blood (duplicate of 6-B.jpg) Delete or Move 1-HC.jpg From: Pictures\D\Dark Horse\T\Tarzan of the Apes (Edgar Rice Burroughs'-) To: Pictures\D\Dark Horse\T\Tarzan of the Apes (Edgar Rice Burroughs'-, 2nd Series)
×
×
  • Create New...