Jump to content

Steven L. Dasinger

Moderators
  • Posts

    1,859
  • Joined

  • Last visited

  • Days Won

    94

Everything posted by Steven L. Dasinger

  1. I will let HC comment an the ability to customize reports (my guess is that Crystal Reports doesn't lend itself to that). In the mean time, to get a report of books of $20.00 or more, do this: Run a Find (CTRL+F). In Find drop-down box, select Item Fields->Price In the next drop-down box, select Is Greater Than or Equal To. In the Box type 20.00 (or just 20 since it is an even dollar amount). (make sure the List Only Items In Stock check-box is Checked) Then click Find button. When the result set is displayed, use CTRL+A to select all the rows. Right-click to bring up the pop-up menu and select Quick Report (or press F7) This will create a Report. This may or may not be what you are looking for but it may be close enough until something better comes along. ============ You can't 'print' a Report to Excel but you can Export it. If you run a regular Report (using the Menu option), click on the Preview button to generate the Report. If you use the Quick Report, it automatically goes into Preview. In the top left corner, the first icon (circled in Red in the attachment) is to Export Report. Click on it and a save dialog box will be displayed. Use the drop-down box to change Save as Type to an Excel format (the part circled in Blue).
  2. Delete or Move ALL (1.jpg - 3.jpg) From: Pictures\A\Antarctic\Horror Comics in Black and White To: Pictures\A\Antarctic\Horror Comics (2nd Series) Delete or Move ALL (1.jpg - 1-E.jpg) From: Pictures\D\DC\J\Joker (3rd Series) To: Pictures\D\DC\J\Joker, The (3rd Series) Delete or Move 1.jpg From: Pictures\S\Scout\Midnight Western Theater To: Pictures\S\Scout\Midnight Western Theatre
  3. First, what Edition of CB are you using (Free, Express, Pro, or Archive) and what are you running it on (Windows or Apple (with a Windows emulator like Parallels)? As far as CB crashing goes, I can't help you. CB runs fine for me (Archive Edition on Windows) and I can't recall the last time it has crashed. As for using CB, the basics are relatively easy. Assuming you have never used CB before (have no existing database), when you first run it it will as you to Create/Name a Database. (I am going from memory here as it has been a long time since I have installed on a new computer without an existing database but this should be really close to what is needed). Once that is done, you should see some Title and the Issues in that Title. To 'add' one of you issues, you need to Find that Title which can be done in a few ways. 1) click on the icon between the two arrows in the top right corner or press CTRL+T to bring up the Titles window. At the top are two radio buttons; One for All Titles and the other for Titles in Stock (you own). Initially if you click the Titles in Stock, nothing will show up as you haven't entered any, yet. In the box below the radio buttons, Type in the name of a Title. NOTE: With this method, it will be looking for a Title Title, exactly as you type it. Leave off the leading artitlces (mostly 'The'). 2) On the main window, at the top center is a box where you can type in a Title. The grayed out text in the box should be Title name or barcode. If it isn't use the drop-down arrow to the left to select Title or barcode. NOTE: This Find will look for what you type anywhere in the Title so you get a greater chance of finding the Title without the exact name. This makes it the better choice when trying to find a Title. Type in enough of the name to get a small list of possible Titles. Try for what would make it distinct. You can type Superman but will get a lot of Titles listed. Also a particular Title may have different Series or Volume numbers. for example, Superman has 1st Series, 2nd Series, 3rd Series, 4th Series, and 5 Series along with two Canadian Series. You can use the down arrow on your keyboard to scroll through the list and a little information will be displayed showing the Year range for the series. Once you find the Title, scroll to the Issue number for the issue you have. Then Change value in the QTY column from 0 to 1 (or more if you have multiple copies). At that point, you have 1 Issue in the Database that you own (or have Quantity in Stock for). You can change other values such as Condition (Grade) and Cost (what you paid) as need. NOTE A potentially easier way to find the Issue is to use the Barcode on the issue (assuming it is a comic published after 1970's). Either scan it into the Find box at the top center of the window (if you have a barcode scanner) or type in the numbers. This will usually take you right to the correct Title / Issue. That is the basics for entering your issue into CB. There is a better way if you have a barcode scanner (or like to type in barcodes) and the is with the menu Items->Add by Barcode (or CTRL+I). When the Add by Barcode window is displayed you can scan each comic and it will be added to the list. Once finished scanning, click Save and all the scanned items will be added to the database by changing the Qty to 1. Note: Before clicking Save, you can change the Add Qty, Condition, Cost or Selling Price for any or all of the issues scanned. Note 2: By clicking the check box Display Items After Saving in the bottom left corner, when you click save, a find is automatically done and all the issues entered will be displayed. Hopefully this will help you get your issues entered. PS Some issues are either not in CB (while it has a lot, it doesn't have everything ever printed) or are in CB but not where you thing they might be. Asking in the forum and you will probably get help finding issues. I am not addressing the download to Excel here as this is already a little long. you can explain the exact steps you are doing I can see if you can help with that.
  4. Mine is using IOS 14.4.1 on IPhone 12 Pro Max.
  5. Delete or Move ALL (1.jpg - 4.jpg) From: Pictures\W\WildStorm\Astro City- Dark Ages-Book Two To: Pictures\W\WildStorm\Astro City- Dark Age-Book Two Delete or Move 1-A.jpg From: Pictures\Z\Zenescope\Belle- Ghost & Goblins One-Shot To: Pictures\Z\Zenescope\Belle- Ghosts & Goblins One-Shot Delete or Move 1-B.jpg From: Pictures\Z\Zenescope\Belle Ghost & Goblins To: Pictures\Z\Zenescope\Belle- Ghosts & Goblins One-Shot Delete or Move 1.jpg From: Pictures\D\DC\D\DC Beach Blanket Bad Guys Special To: Pictures\D\DC\D\DC's Beach Blanket Bad Guys Summer Special Delete 1.1-B.jpg, 1.1-C.jpg, 1.1-D.jpg & 1.1-D-2.jpg From: Pictures\M\Marvel\C\Champions Rename 1-HC.jpg to 1.jpg From: Pictures\A\Abstract\Ever- The Way Out Delete 3.jpg From: Pictures\J\JLS\Luna Rename TPB 1.jpg to MMPB 1.jgp TPB 1-A-2.jpg to MMPB 1-A-2.jgp TPB 2.jpg to MMPB 2.jgp TPB 2-A.jpg to MMPB 2-A.jgp TPB 3.jpg to MMPB 3.jgp TPB 4.jpg to MMPB 4.jgp TPB 5.jpg to MMPB 5.jgp TPB 6.jpg to MMPB 6.jgp TPB 6-A.jpg to MMPB 6-A.jgp TPB 7.jpg to MMPB 7.jgp TPB 8.jpg to MMPB 8.jgp TPB 9.jpg to MMPB 9.jgp TPB 10.jpg to MMPB 10.jgp TPB 11.jpg to MMPB 11.jgp From: Pictures\M\Marvel\M\Marvel Comics Novel (Pocket)
  6. I just downloaded the app and am also having a problem logging in.
  7. That issue can be found in The Amazing Spider-Man (Public Service Series) #1 ( on Atomic Avenue: https://atomicavenue.com/issue/265107/Amazing-SpiderMan-The-Public-Service-Series-1) I found this by doing a Find on Storyline Skating on Thin Ice. NOTE: Be sure to run File->File Tools->Rebuild Lists (Advanced Lists of Contributors, Storylines, and Notes).
  8. Also, don't miss the colon after Belle (Belle: Ghosts & Goblins One-Shot). (personally, I am fifty-fifty on whether One-Shot should be in the Title but either way could work.
  9. Using the Grading Wizard, It does look like it is a little off when it comes to Paper Whiteness. Here are the choices and the resulting Grades: White/Like New MT 10.0 Off White NM 9.4 Cream VF/NM 9.0 Cream/Tan G/VG 3.0 Tan VF 8.0 Tan/Brown FN/VF 7.0 Brown FN 6.0 At a guess, it looks like the G/VG 3.0 Grade should be the last (Brown) and the ones below moved up. This makes more sense: White/Like New MT 10.0 Off White NM 9.4 Cream VF/NM 9.0 Cream/Tan VF 8.0 Tan FN/VF 7.0 Tan/Brown FN 6.0 Brown G/VG 3.0
  10. Delete ALL (1.jpg - Bk 1.jpg) From: Pictures\F\Fantagraphics\Angry Youth Comix (Vol. 1) (duplicates of cover in Pictures\F\Fantagraphics\Angry Youth Comix (Vol. 2) Title changed Publisher to Johnny Ryan) Rename 1.jpg to TPB.jpg From: Pictures\S\SQP\Art Of Arantza, The Delete or Move 1.jpg From: Pictures\J\Jabberwocky\Chuck Chicken & Bruin Bear (Mike Turvill's-) To: Pictures\J\Jabberwocky\Chuck Chicken & Bruin Bear (Mike Turville's-) Rename 1.jpg to TPB 1.jpg From: Pictures\D\DH\Ghost in the Shell- Stand Alone Complex-The Lost Memory Delete or Move 1.jpg From: Pictures\G\General Foods\Jell-O Man and Wobbly To: Pictures\W\Welsh\Adventures of Jell-o Man and Wobbly, The Rename 1.jpg to TPB.jpg From: Pictures\K\Kodansha\Manga! Manga! The World of Japanese Comics Delete or Move 1.jpg From: Pictures\T\TwoMorrows\Superheroes In My Pants To: Pictures\T\TwoMorrows\Superheroes In My Pants! Delete 26.jpg From: Pictures\B\Boom!\Firefly (Boom!) (Duplicate of 26-A.jpg) Delete 1-C.jpg From: Pictures\A\American Mythology\Land That Time Forgot, The- Fearless Delete 1.jpg From: Pictures\V\Vertigo\Unexpected, The (2nd Series)
  11. Thanks for posting this. I should have went back and added this. The original post was before this feature was added and was a workaround until it did appear. (actually, it was instrumental to getting this feature added...). Now that it is available, the new feature should be used as it is much easier.
  12. Delete or Move 2.jpg and 2.5.jpg From: Pictures\S\Shroud\Gory Stories Quarterly To: Pictures\S\Shroud\Gory Story Quarterly, The and/or Delete or Rename 2.5-A.jpg to 1-A.jpg Then Move From: Pictures\S\Shroud\Gory Stories Quarterly, The To: Pictures\S\Shroud\Gory Story Quarterly, The (Between the two, you should end up with 2.jpg, 2-A.jpg, and 2.5.jpg (see AA for covers as refernce, if needed)) Delete or Move 1.jpg From: Pictures\F\Fawcett\B.C. Life is a Sollar Seventy-Five Cent Paperback To: Pictures\F\Fawcett\B.C. Life is a Dollar Seventy-Five Cent Paperback
  13. There shouldn't be a limit (other than disk space). I just added over 100 digital comics to a Title and all 109 of them have the play button next to them. If you not already done so, try to leave and come back to the Title (so it can refresh the display). If they still do not show up, check the names of the files and ensure they match the Item #. If you still can't see them, I would contact support.
  14. The file name would be just like a cover file (with a different extension). For example for Item # 1/A, the file would be 1-A.cbr (or cbz). On disk, they will be in the Media folder. This is the same location as the Pictures folder, by default. You can Change the location of the Media folder using Manage Pictures and Movies (part of File Tools). In CB, they would 'show up' as a 'play' icon in the box to the left of the covers. Click on this and the digital comics should 'play'.
  15. Joe, I think I follow what you are wanting (Navigate to only Titles you have at least 1 owned Issue but display all (or at least non-variants) when that Title is displayed. If this is correct, then are are correct in that it can't (currently) be done. The Find Title window list of Titles and the View settings are unrelated (One is just a filtered list to select from and the other is a preference setting for display). I think I remember what you are describing. The navigation arrows (top right corner) used to have some additional functionality where you could right-click on them and select some action (like go to next title without covers) one of which was to display only Titles you owned (going by memory here so I could be mistaken...). You should probably create a thread under Feature Suggestions and mention that you would like the ability to Navigate between only Titles you have one or more Issues and to display only Owned and Regular Issues for those Titles.
  16. Delete or Move ALL (1.jpg - 2.jpg) From:Pictures\S\Source Point\Salvagers To: Pictures\D\Dirty Planet\Salvagers Delete 1-A.jpg Then Rename 1-B.jpg to 1-A.jpg From: Pictures\A\American Mythology\American Mythology Monsters (1-A is a duplicate of 1.jpg) Delete 7.jpg From: Pictures\S\Stanmor\Navy Task Force (duplicate of 1.jpg) Delete 2.jpg Then Rename 2-A.jpg to 2.jpg From: Pictures\A\Ahoy\Penultiman (2.jpg and 2-A.jpg are duplicates but 2-A has the barcode so 2.jpg if probably a preliminary cover.) Delete 1-F.jpg From: Pictures\B\Boom!\Unkindness of Ravens, An (duplicate of 1-B.jpg) Delete 12-B.jpg, 12-C.jpg, 12-D.jpg and 12-E.jpg From: Pictures\M\Marvel\X\X-Men (5th Series) Delete or Move ALL (1.jpg - YB 6.jpg) From: Pictures\O\O'Quinn\Starlog To: Pictures\S\Starlog\Starlog
  17. Since I can't see your database, I checked to see what mine has. Collection Statistics 20,855 Comics (total) and 20,452 Unique Collection Report 20,855 Total Find Qty in Stock > 0 20,452 issues (I don't have separate issues for duplicates, so this is the Unique issue count) Total Cost, Total Value, and Total Price also (almost) match. The Total Value and Total Price are off by 3 and 5 cents, respectively (probably a rounding error). So, for me, everything matches. Then why are your numbers off? I am not sure. First, make sure to upgrade to the newest release (1577). I was having some problems getting numbers until I did this. Then run a File->File Tools->Rebuild LIsts checking Series Information, and (especially) List of Owned Series (you can check the others but they shouldn't affect what you are having a problem with). After that completes, run an Optimize Database (because it can't hurt...). Next, Make sure you are comparing Total to Total and Unique to Unique. By that I mean, the Collection Report returns Total Issues while the Find returns Unique Issues. Next, depends on what you have. Find Where Qty in Stock > 2. check to see if any of there values don't look correct (i.e. you only have 2 of some issues but CB indicates 3 or more). This 'shouldn't' happen but conversions, imports, user error, etc., can get stray incorrect information into the database. (not common but not unheard of). The last thing I can think of (and the least fun...) is to spot check various Titles and see if you can see anything strange (hopefully the Find for Qty in Stock > 2 (or so) will have found this already. Okay, the very last thing is to do a complete inventory of your comics comparing this to CB.
  18. What do you mean by 'get CB to recognize second prints'?
  19. Yes. I sent him my database but I am not sure if he pulled it off Dropbox or not. I can send it again if he needs it.
  20. Mark, I have reported the same problem. I am using the most recent version of CB 2021.
  21. Also, you might try File Tools-> Optimize Database and see if that clears up any problems.
  22. This doesn't answer your question directly, but... If you have a Title in Comic Books and it needs to be moved to Books, you can use menu item Edit->Change Title Media Type to let the system move it for you.
  23. I took your file and Imported it into a New Database. 22 of the Titles had names that don't match the names in CB so, while Imported, they are put into "Unknown Publisher". "A-Team, The" "Avengers, The" "Daredevil Chronicles, The" "Defenders, The" "Elektra Saga, The" "Fantastic Four Chronicles, The" "Further Adventures of Indiana Jones, The" "Fury of Firestorm, The" "Incredible Hulk, The" "Incredible Hulk Versus Quasimodo, The" "Kree-Skrull War Starring The Avengers, The" Legion of Superheroes 1983 Moon Knight "New Mutants, The" "Omega Men, The" "Saga of the Swamp Thing, The" "Superman Movie Special, The" "Thing, The" "Transformers, The" "Uncanny X-Men, The" "Vigilante, The" X-Men Special Edition Since you are using TAB delimited instead of Comma delimited, I think the " " aroung the names are causing you some problems. Whether it is by Design or a Bug, all the Titles that couldn't be found in CB, only had Titles created and NO Issues under them. This might be the missing issues that are causing your numbers to not match. For the ones without the " " (there are only 3 Issues): Legion of Superheroes 1983 An 2 1 NM Moon Knight 35 1 NM X-Men Special Edition 1 1 NM You need to either remove them and enter them manually, or correct them with the matching CB Title (and Issue # (i.e. An 2 doesn't look like a valid Issue number)). Collection Statistics shows 1,162 Comics (789 Unique Isssues) I Edited the file and changed all the " to nothing and ran the import again (on another new Database) and all but the 3 strange Titles imported successuflly. Collection Statistics shows 1,552 comics (1,037 Unique issues) PS it wouldn't hurt to run File->File Tools and use Rebuild Lists after the Import. Series Information and List of Owned Series are the most relevant but it wouldn't hurt to do Item Information and Lists of Contributors, Storylines, and Notes.
  24. Can you explain a little bit more the steps you are taking and what you are trying to accomplish? The more specific the better. Also, the supplied file is not a text delimited file, if that is what you are using.
×
×
  • Create New...