Jump to content

Steven L. Dasinger

Moderators
  • Posts

    1,523
  • Joined

  • Last visited

  • Days Won

    72

Everything posted by Steven L. Dasinger

  1. Check to see what version of CB you are using (Help->About ComicBase). The most recent is v21.0.1.1516. This was a change that was made in one of the recent updates. If you are using the most recent update, then I am not sure how else to do this and will need to contact ComicBase Support.
  2. I think this is how you do it. Use File->Collection Statistics ( or F12) When the window is displayed, click the icon with an i on it (top right corner, see attachment). This will bring up a window that should let you change it.
  3. Since you have the Archive Edition, it shouldn't me a major problem, although there might be some minor ones. You can Export the data from any/all of the databases and Import the data back into the one database you want to keep (note if this is an active database, you don't have to Export from that one). Some minor issue are you might have some duplicate issue or Qty in Stock higher than expected. First you want to open each of the databases and run the most recent Update on all of them to get them (mostly) in sync. I say mostly because you might have some Titles/Issues that you own that CB would like to delete but can't. The new View Unrecognized data to clean these up. I think theses are the three databases you mentioned: ComicBase Database.cbdb (this one you want to keep). DBetancourt Comics.cbdb DBetancourt Comics 2021.cbdb Open Each database and run the Update. If the most recent update has already been run, that is fine. Just want them all to be at the same 'level'. You can use File->Open or File->Recent Databases. When you open each database, use File->Theme to change the color of each database so you can easily tell them apart (at this point the color you use doesn't matter. Maybe Green for the good one, Yellow and Red for the others.) After each update when the Content Update window is displayed, click on the View Unrecognized Items (bottom left) like to bring up a list of any Titles and/or Issues that are in the Master Database. Hopefully this will be empty. If it isn't, find the Titles/Issues and get your owned items moved to the correct locations. Again this is for each database. Next, as a safety measure, make a copy of all the databases. You can do this inside CB with File-> Save A Copy or with CB closed, go to the file location where the Databases are stored. This should be C:\Users\<your-logon-id>\Documents\Human Computing\ComicBase Databases. Copy the three database to some other location. This way is something goes 'horribly wrong', you can just copy a database back to that location and you will be back where you started from. Next, use File->Export. When the Export window comes up, Move the fields you want the data for to the right pane 'Fields to Export'. At a minimum, you need Title, Item #, Condition, and Qty in Stock. You can do there fields such as any of the Custom columns, Grading Note, etc. you may be using. I would not do the 'standard' fields like Artist, Writer, etc. as that will be the the database already. At the bottom select Export Only Items In Stock, and set Item Separator to TAB (you can use Comma, also. Just do this the same for all the Exports to keep it simple. Don't worry about Include Field Headers. NOTE: Make sure the Fields you select are in the same order for both Exports (they can be different but it is easier if they aren't). When ready, click the Export button and select the location and name of the Export files. Do the Export for two database: DBetancourt Comics DBetancourt Comics (since you want to keep ComicBase Database) Important!!! You will need to do an Export for Comic Books, Books, and Magazines separately. (if you don't have any of these you can skip it. So when you do the exports you should have up-to 6 files (2 database, 3 types each). Next you will Import each file you Exported into your 'real' database. NOTE: You DID make a backup copy of this database, correct? If not make one now (close CB first). Open ComicBase Database and use File->Import. Select one of the Export files (doesn't matter which one you do first). When the Import window comes up, it should already have the Fields to Import filled in and the Item Seperator set. If not change it to match what you Exported. Click the Import button. Do this for each type for the first database (up to 3 imports). After this first Import check for any publisher with a name of "Unknown Publisher" These will be ones that didn't find a matching Title to import to. If you synced the Updates and cleaned up any Unrecognized data, you should have any of these. Do a find where Qty in Stock > 1 (assuming you only have 1 item for each Issue). This will see if there was any items that 'doubled' the Qty in Stock. I am not sure you will find any but it doesn't hurt to check. When you are satisfied everything looks good, Import the second database export files (up to 3 of them). Do the same checkout. Try to check for anything strange (Qty in Stock to large, duplicate issues, "Unknown Publisher". Hopefully, everything will look fine. Summarized steps: Make backup copies. Export data from the two databases you don't want (Books, Comic Books, and/or Magazines, as needed). Import one set of files from one database. Check out results. Import second set of files from the other database. Check out results. ============ Once you have everything back like you want, temporarily, rename the old databases to something without a CBDB extension (this will keep them around if you need them later but CB won't 'see' them). NOTE: Since you have the backups, even if you mess up any of the above, you can always use them to 'start from the beginning' so this should be a safe process.
  4. Delete or Move ALL (1.jpg - 381.jpg) From: Pictures\T\Thorpe and Porter\MAD (Thorpe and Porter) To: Pictures\T\Thorpe & Porter\MAD (Thorpe and Porter) Delete or Move ALL (1.jpg - 21.jpg) From: Pictures\P\Planeta deAgostina\Muertos Vivientes, Los To: Pictures\P\Planeta DeAgostini\Muertos Vivientes, Los Delete or Move 1.jpg From: Pictures\P\Project-H\Ray's Days To: Pictures\P\Project H\Ray's Days Delete or Move 1.jpg From: Pictures\P\Project-H\Happy Girl's To: Pictures\P\Project H\Happy Girls Delete or Rename 1-B.jpg to 1-A.jpg & 1-C.jpg to 1-B.jpg, then Move ALL (1-A.jpg - Bk 1.jpg) From: Pictures\B\Boom!\Buffy the Vampire Slayer- The Chosen Ones To: Pictures\B\Boom!\Buffy the Vampire Slayer- Chosen Ones Rename Bk 1.jpg to TPB.jpg From: Pictures\H\Hero Games\Champions Presents Delete or Move ALL (2.jpg - 8.jpg) From: Pictures\B\Broccoli\Es To: Pictures\B\Broccoli\E'S Delete or Move ALL (1.jpg - 4.jpg) From: Pictures\H\Heavy Metal\Fish Kill To: Pictures\H\Heavy Metal\Fishkill Delete or Rename 1.jpg to TPB.jpg then Move From: Pictures\B\Boom!\Labryinth (Jim Henson's-) To: Pictures\A\Archaia\Labyrinth (Jim Henson's-) Delete or Move ALL (0.jpg - 1-U.jpg) From: Pictures\B\Big Dog Ink\Princess vs Zombies To: Pictures\B\Big Dog Ink\Princesses vs. Zombies Delete or Move ALL (1.jpg - 6.jpg) From: Pictures\B\Boom!\Unsound, The To: Pictures\B\Boom!\Unsound, The (Boom!) Delete or Move ALL (1.jpg - 15.jpg) From: Pictures\S\Starlog\Star Trek- The Next Generation- The Official Magazine To: Pictures\S\Starlog\Official Star Trek, The- The Next Generation Magazine Delete or Move 1.jpg From: Pictures\T\Titan\Star Wars Insider, The Best Of To: Pictures\T\Titan\Best of Star Wars Insider, The Delete or Move 1.jpg From: Pictures\M\Malibu\Mortal Kombat Special Edition To: Pictures\M\Midway\Mortal Kombat- The Comic Book Delete or Rename 2.jpg to 1.jpg then Move From: Pictures\M\Malibu\Mortal Kombat Special Edition To: Pictures\M\Midway\Mortal Kombat II- The Collector's Edition Comic Book Delete 22.jpg From: Pictures\V\Vertigo\House of Whispers Delete 42.jpg & 42.jpg From: Pictures\D\DC\S\Supergirl (6th Series)
  5. I was using the AA link to also display the cover as a visual check it was the correct issue. Just go to Action Comics. Since it is entered as a 5th printing of #1, it should be near the top of the display, 6th one from the top. (I scrolled down a bit to bring it to the top for a smaller scan
  6. This might be what you are looking for: https://atomicavenue.com/issue/22649/Action-Comics-15 It has ca. 1988 in the Notes with a 50 cent cover price.
  7. Yes, if you have the issue in hand and see the incorrect data, you can make changes and submit the corrections.
  8. It may not be in the database. Here is what I would do: Select the Item # (high-light it). Right click and select Duplicate from the pop-up menu. Use the Variation drop-down box to select 'Variation A' Change the Cover Price to 25 cents. Add to the Notes, something like '20 cent price variant' Save the issue. Right-click (high-light) the new /A variant. Right-click and select "Submit New or Corrected Data' from the pop-up menu.
  9. Flipbooks with both sides of the cover are already allowed (and appreciated). The proper display is as it would look with the back/left side, upside down (as if you opened and spread the book out to see both sides). Example can be seen here: https://atomicavenue.com/issue/485872/Chip-N-Dale-Rescue-RangersDarkwing-Duck-FCBD-1 However, I have seen flipbook covers in CB where the back cover was cut/flipped/stitched back with the front cover so both are 'right-side' up. Example can be seen here: https://atomicavenue.com/issue/102511/Dark-Horse-Presents-Anl-2000 Someone at HC may comment on which is the 'correct' method (either one or both).
  10. Can you supply the exact Advance Find values you used. I tried: I.[Title] LIKE '%Spider%' and I.[Storylines]= 'When Strikes Octopus!!' And I only get the 2 Items for #124 (regular and Mark Jeweler). What you have is not normal and I am trying to figure out what is happening but I need exact steps to follow.
  11. The Update has been fixed. Try again and it should work.
  12. Delete or Move ALL (1.jpg - 10.jpg) From: Pictures\W\Walty Disney Italia\Almanacco Topolino (2nd Series) To: Pictures\W\Walt Disney Italia\Almanacco Topolino (2nd Series) Delete or Move 1.jpg From: Pictures\P\Project-H\Embrace & Bloom To: Pictures\P\Project H\Embrace & Bloom Delete or Move 1.jpg From: Pictures\G\Gemstone Publishing\Kabuki- FAN Edition To: Pictures\G\Gemstone\Kabuki- FAN Edition Delete or Move 1.jpg From: Pictures\S\Soil & Water\Food and the Land To: Pictures\S\Soil and Water Conservation Society\Food and the Land Delete or Move 1971.jpg From: Pictures\S\Soil & Water Conservation Society\Wonder of Water, The To: Pictures\S\Soil and Water Conservation Society\Wonder of Water, The Delete or Move ALL (1.jpg - 6.jpg) From: Pictures\S\Scout Comics\Long Lost To: Pictures\S\Scout\Long Lost Delete or Move 1.jpg From: Pictures\S\Scout Comics\Ninja Nuns To: Pictures\S\Scout\Ninja Nuns Delete or Move ALL (1.jpg - Bk 1.jpg) From: Pictures\S\Scout Comics\Once Our Land To: Pictures\S\Scout\Once Our Land Delete or Move ALL (1.jpg - 3.jpg) From: Pictures\S\Scout Comics\Sabretooth Dan To: Pictures\S\Scout\Sabretooth Dan Delete or Move SE 1.jpg From: Pictures\P\Power!\Lorelei Returns! To: Pictures\P\Power\Lorelei Returns! Delete or Move ASh 1.jpg From: Pictures\W\Warner Bros\Pushing Daisies To: Pictures\W\Warner Brothers\Pushing Daisies Delete or Move 1.jpg From: Pictures\R\R. B. Leffingwell and Co\Topsy-Turvy Comics To: Pictures\R\R.B. Leffingwell and Co\Topsy-Turvy Comics Rename 1.jpg to TPB.jpg and 1-LE.jpg to TPB-LE.jpg From: Pictures\M\Moonstone\Captain Midnight Chronicles Rename Bk 1-A.jpg to TPB-B.jpg and Bk 1-B.jpg to TPB-A.jpg From: Pictures\M\Moonstone\Green Hornet Chronicles, The Rename 1.jpg to TPB 1.jpg 2.jpg to TPB 2.jpg 3.jpg to TPB 3.jpg From: Pictures\D\DrMaster\Junk Force Novel Rename 1.jpg to TPB.jpg From: Pictures\M\Moonstone\Kolchak- The Night Stalker- A Black and Evil Truth Rename 1-HC.jpg to HC.jpg From: Pictures\Q\Quirk\Legion of Regrettable Supervillains, The
  13. I think something about fixing the update caused this. To add, In addition to Junk Force Novel, mentioned, these Titles, which were moved to Books, left the Comic Books Titles instead of deleting them: Captain Midnight Chronicles Golden Amazon Green Hornet Chronicles, The Kolchak Night Stalker: Passages of the Macabre Kolchak: The Night Stalker: A Black and Evil Truth Legion of Regrettable Supervillains, The
  14. You can still edit the Title description. CTRL+T to bring up the Titles selection window, select a Title, then click Modify. I have no idea how you would hyperlink to another Title (not saying it can't be done, just I don't know).
  15. That is strange since The Spectacular Spider-Man (1976-1998) doesn't even have a 286 issue. Since you have a Search Results display, what did you use to run the Search? I would try File Tools->Rebuild Lists (Mainly Series Information but others won't hurt), then Optimize Database and see what happens.
  16. Try: For Checked: I.[CustomCheck2] = TRUE For Unchecked: I.[CustomCheck2] = FALSE PS You could use 1 instead of TRUE or 0 instead of FALSE (a checkbox is a binary choice) but TRUE and FALSE are a little clearer what you are doing.
  17. Yes, I had the same problem. After waiting a little longer, I successfully updated to the newest release. PS As you noted (and I learned), if you get the Modify, Repair, Delete box, that means it is trying to install the same version as you already have.
  18. Delete or Move 1.jpg From: Pictures\A\Andrew McMeel\Big Nate- Great Minds Think Alike To: Pictures\A\Andrews McMeel\Big Nate- Great Minds Think Alike Delete or Move ALL (1.jpg - 2-B.jpg) From: Pictures\M\Mike Wolfer Entertainment\Daughters Of The Dark Oracle- Orgy of the Vampires To: Pictures\M\Mike Wolfer\Daughters Of The Dark Oracle- Orgy of the Vampires Delete or Move ALL (1.jpg - 4.jpg) From: Pictures\B\Black Mask Comics\Disciples, The (Black Mask) To: Pictures\B\Black Mask\Disciples, The (Black Mask) Delete or Move ALL (0.jpg - 4.jpg) From: Pictures\B\Black Mask Comics\Toe Tag Riot To: Pictures\B\Black Mask\Toe Tag Riot Delete or Move ALL (1.jpg - Bk 2.jpg) From: Pictures\B\Black Lace Studios\Girl Presents- Body Heat To: Pictures\B\Black Lace\Girl Presents- Body Heat Delete or Move 1.jpg From: Pictures\B\Black Lace Studios\Girl Presents- Co-Ed Diaries To: Pictures\B\Black Lace\Girl Presents- Co-Ed Diaries Delete or Move 1-HC.jpg From Pictures\A\Atlas\123's for Superheroes To: Pictures\A\Angel Gate\Atlas- 123's for Superheroes Delete or Move 1.jpg From: Pictures\K\Kodansha\Eden's Zero To: Pictures\K\Kodansha\Edens Zero Delete or Move 1.jpg From: Pictures\T\Tragedy Strikes\Reactor Girl (Vol. 2) To: Pictures\T\Tragedy Strikes\Reactor Girl (Tragedy Strikes) Rename 3-C.jpg to 3-B.jpg From: Pictures\M\Marvel\B\Black Panther and the Agents of Wakanda Delete or Rename then Move Ash 1.jpg to 1-A.jpg Ash 1-B.jpg to 1-B.jpg Ash 1-A.jpg OR 0-SC.jpg to 1-C.jpg (delete the other) From: Pictures\B\Basement\Cavewoman- Pangaean Sea To: Pictures\B\Basement\Cavewoman- Pangaean Sea Prelude Delete or Rename From: Pictures\B\Basement\Cavewoman- Pangaean Sea 0-A.jpg to SE 0-B.jpg (Special Origin Jungle Green Foil) 0-C.jpg to SE 0-A.jpg (Gold Foil) 0-D.jpg to SE 0-C.jpg (Arthur Adams) (0.jpg and 0-B.jpg look the same and should probably have at least a SE 0/D but does not, at this time.) Delete or Rename 1-Z-5.jpg to 0-E.jpg From: Pictures\B\Boundless\Ember Rename 1.jpg to 1-HC.jpg From: Pictures\A\Abstract\Ever- The Way Out Delete or Rename then Move Bk 1.jpg to 1.jpg Bk 2.jpg to 2.jpg Bk 3.jpg to 3.jpg From: Pictures\D\Dark Horse\G\Gantz To: Pictures\D\Dark Horse\G\Gantz- G Rename 1.jpg to 1-A.jpg From: Pictures\I\Image\H\Home Sick Pilots Delete or Move ALL (1-A - 1-G) From: Pictures\C\Coffin\Lady Death Blasphemy Anthem To: Pictures\C\Coffin\Lady Death- Blasphemy Anthem Delete 4-I.jpg From: Pictures\Z\Zenescope\Robyn Hood- The Curse (Duplicate of 4-G.jpg) Delete 1-2.jpg From: Pictures\A\Absolute\White Widow (Duplicate of 1-A-2.jpg)
  19. Should be able to do a Find with Title Field Custom Check x IS Checked (where x is the one you are using).
  20. For #2, It took me a bit to figure out what you were doing, but I think I have it. Doing any Issue Find returns a Find Results grid which includes Title to the Right of the cover. See first attachment. With the Find Result still displayed, use Menu item. either Setup->Custom Fields or Set-up->Columns to View (it appears to be something that causes a screen refresh). When you select Custom Fields, it is on closing the windows the problem happens. When you select Columns to View, it happens when it opens. After one of the two actions mention, the Title column disappears from the grid view (of the Find Results). See second attachment.
  21. ComicTitles.[CustomCheck1] or ComicTitles.CustomCheck1 should have worked. I just did a quick test using both and the both returned what I expected. Normally the [] are needed when there is a space in the name of the field. if it had been Custom Check 1 then you would have to have it in []. (which is why smart database admins don't create fields with spaces...)
  22. 1) No, you are not missing anything. Currently, the only way to change the Title custom fields is per individual Title. 2) Try ComicTitles.[CustomCheck1] (changing 1 to 2 or 3 if needed). This is assuming an Advanced Find. You could use the normal Find with the Title Fields and selecting the custom check boxes but that is all you would be searching for. 3) No (see 1).
  23. Not officially. but try this: ComicTitles.AlphabetizedTitle Hope it works.
  24. According to this location: https://www.artstation.com/artwork/L3EZGA it is a Rafael Grassetti variant for Might Morphin Power Rangers (5th Series) #55 . Inside cover lists a Comic Tom Mystery Mail CAll Exclusive variant by him. Attached is what the inside cover of#55 lists as various covers.
×
×
  • Create New...