Steven L. Dasinger

You can try deleting the Thumbnail folders located at: C:\Users\Public\Documents\Human Computing\Thumbnails. (they are recreated by CB as needed). You can either delete the whole directory (there are different ones per cover Icon size that has been used) or drill down and delete the Title folder or the individual thumbnail.

Not sure what you formula is doing but this seems to work for me. Note: I am multiplying Height and Width by 1.0 because the columns seem to be defined as Integer (no decimal value) and Integer / Integer results in an integer value. By multiplying by a decimal, it turns all the output into decimal. I.[QtyInStock] >= 1 AND ( I.[PictureWidth] * 1.0) / ( I.[PictureHeight] * 1.0) > 1 Also, there are some books that are wider than they are high and are not wraparound or gate-fold which will also show up with this query. If you want to fine tune it a little, you can change > 1 to something like 1.2 to control how much wider than high the cover is.

Rename TPB.jpg to TPB 2.jpg From: Pictures\I\Idea + Design Works\Art of John Byrne's Next Men, The Rename TPB.jpg to TPB 18.jpg From: Pictures\D\Dark Horse\B\Bettie Page- Queen of Hearts Rename TPB 1.jpg to TPB.jpg & TPB 1-A.jpg to TPB-A From: Pictures\B\Ballantine\Shadow, The (Ballantine)

Hmm... The only thing I can think that I might have done differently is I ran Optimize Database after the Rebuild Lists Picture info. Since the Picture columns can't be displayed, I have to determine what is stored there. Using The Phantom (1st Series) #3.jpg as a test, multiple finds with Between shows the value for this is 3149. This matches the Property values for the file which has the value for Size: 3.07 KB (3,149 bytes). So try using Byte values instead of KB values. Keep in mind that if NULL is stored there NULL is not < (or equal) to anything.

By the way, on my computer, I ran into a problem when displaying a Find result that has more items than rows to display in a Grid (causing the < number - number > at the bottom of the page). For now, to get around that, you can use Preferences to set Rows to display in Grid to more than 5000 (I have mine set to 100000).

After about 1 hour , the Pictures files list rebuild completed. After that an Advanced Find using: I.[QtyInStock] >= 1 AND I.[PictureHeight] IS NULL Seems to have found Items I own that do not have a picture.

What version of CB are you using? A new version (v3599) was just posted today. Until this version, using File Tools->Rebuild lists and checking the box regarding pictures actually didn't work. This have been fixed with the newest version. I have downloaded / installed this and am currently running the process which will take a LONG time. How long depends on where you pictures are located and how many you have. I have mine on an M2 drive which should run faster than if on a Solid State Drive which should be faster than on a regular hard drive. Once this has completed, the various Picture columns 'should' be updated and then your Finds should work (at least I hope so...).

Mine does the same thing but doesn't take near as long. About 10 seconds. My database is on a M2 drive, however.

I believe HC doesn't have a problem with installing CB on two computer (home and laptop) but they will have to let you know that (I think the question has come up before). As for the app, I don't think it allows you to access you home computer database directly. You have to save a copy (or a report?) to the cloud and then the app reads that, I think. Never having done this, I will let other explain in more detail and how to do this.

Rename 1-HC.jpg to HC 1.jpg From: Pictures\D\Dynamite\Art of Dejah Thoris and The Worlds of Mars, The Rename 1.jpg to TPB.jpg From: Pictures\I\Idea + Design Works\Art of John Byrne's Next Men, The Rename 1.jpg to TPB.jpg From: Pictures\D\Dark Horse\B\Bettie Page- Queen of Hearts Delete or Move 1.jpg From: Pictures\W\Whitman\Big Little Book To: Pictures\W\Whitman\Tailspin Tommy (Whitman) Rename TPB.jpg to TPB 1.jpg & TPB-A.jpg to TPB 1-A.jpg From: Pictures\B\Ballantine\Shadow, The (Ballantine) Rename 2.jpg to 2-A.jpg From: Pictures\V\Vault\Finger Guns

I guess we will have to agree to disagree. To me, Cost is what I Paid for an Issue. I don't own it, then the Cost is 0.00. If I ever change Qty to 1 or more then Cost would be some value. If you handle cost differently, then that is your choice. I will just have to set discount to Zero to get the Cost to act the way I expect.

CB currently has Title "World's Finest: The Guardians of Earth". The actual Title (on cover and indicia) is "World's Finest: Guardians of Earth".

Except, it isn't behaving the way it should. Any new Item added that has a Qty of 0 should have a Cost of 0.00. Since these appear to be newly entered Items, with Qty = 0, the Cost should be 0.00, but the Update is setting it to Cover Price * Discount % for every new item the update adds to the database. Cost should only be set if Qty is set to 1 (or more).

It isn't really anything we do. It is what the program does. This is probably with the weekly update. From last weeks update log: New Magazines: 007 Magazine Omnibus 4 If you go to 007 Magazine Omnibus, Item #'s 1, 2, and 3 all have a Cost of 0.00. But, the newly added Item #4 has a Cost of 23.59. This was added by the weekly update and not me. Randomly checking other New Magazine Item #'s, most have a Cost value set other than 0.00. The few that don't may have been moved from Comic Books instead of added as new (at a guess). Also notice that 1, 2, and 3 were Modified prior to CB 2020. PS The same thing is happening for Books and Comic Books.

Here you go. Suggestion. If you multiply what you are doing that results in Cost by the Qty in Stock value, you will get 0.00 if Qty is 0 or the actual Cost if you have Qty of 1 (or more).

Here is an example (although this is the case for most, if not all, of the Magazines). The Red circle shows Qty 0. The Blue circle shows the Price (what it is currently worth). The Black circle shows the item #'s 'Cost' me 1.80 and 2.25 for ! and 2, respectively. But, since I never bought them, the Cost should be 0.00 and NOT the Cover price * the Discount set in preferences. This is true for Books and Comic Books (although only for newer (i.e. updated) Comic Books), I think.

Yashakiden: The Demon Princess (Digital Magna 2010) is a prose novel with some illustrations and should be moved to Books. At Amazon, https://www.amazon.com/Yashakiden-Demon-Princess-Novel/dp/1569701466/ref=sr_1_1?dchild=1&keywords=yashakiden%3A+the+demon+princess&qid=1592098752&s=books&sr=1-1 you can 'look inside' to see what it is like.

For the most part, I think you have it. There have been 7 series of Vampirella published. 2 by Harris and 5 by Dynamite. I am not sure if they will adjust the names to be Harris, 1st & 2nd Series along with Dynamite 1st, 2nd, 3rd, 4th & 5th Series or not.

Not sure about the freezing part but for the 'Cannot run 2 databases at once' part... Open Task manager, find the ComicBase 2020 (32 bit) app, right click on it and select End Task from the pop-up menu (or high-light it then click the End Task button at the bottom). This will terminate the already running process and allow you to (attempt) restating CB. Before restarting CB, if you don't have the latest version (v20.0.2.3433), I would download and install it. It may help. PS when I installed this version, when I opened CB, it was delayed while it did something regarding Items (can't recall exact message) but it had a progress bar and, even though it seemed to not be moving at times, it eventually finished and opened CB.

Rename All (TPB 1.jpg - TPB 352.jpg) TPB x.jpg to x.jpg (where X is the number. ex: TPB 1.jpg to 1.jpg) From: Pictures\A\Alan Light\Buyer's Guide for Comic Fandom, The Rename 8.jpg to 202.jpg From: Pictures\B\Blake\Fantastic Films Delete or Move ALL (1.jpg - 6-B.jpg) From: Pictures\I\Idea + Design Works\Other Dead To: Pictures\I\Idea + Design Works\Other Dead, The Rename 1.jpg to TPB.jpg and TPB-A.jpg to .jpg From: Pictures\B\Ballantine\Shadow, The (Ballantine) Rename: 84.jpg to 1305.jpg 146.jpg to 2301.jpg 147.jpg to 2302.jpg 149.jpg to 2304.jpg 155.jpg to 2404.jpg From: Pictures\S\Sovereign\Sci-Fi- The Official Magazine of the Sci-Fi Network

What does Cost represent? What an Item # Will Cost? or What you Paid for it? If it what you Paid for it, it should be 0 unless Qty in Stock is >=1.

I think this is a "Feature" and I am not sure it is a good idea. If you a Find for last weeks new items in Comic Books, All ha a Cost entered (even if Qty is 0). The only ones that don't are ones that have a Cover prices of 0.00.) So it isn't just Magazines (or Books). If it is a Feature, what I am about to suggest may not last past the next update (and I would try on a copy of your database, just to be safe). And this will affect all items in a section (Magazines, Books, or Comic Books). Select menu item Items-><Mass Change (or CTRL + M) Make sure the drop-down box in top left corner is set to Magazines. Use Change drop-down box to select Cost. Click Radio button next to Value and then type in 0.00 in the box. At this point you can click the Apply To radio button for All Titles to get everything or Selected Titles to then select various Titles. Once ready, click Make Changes. Note: There will NOT be any Undo for this (hence the 'work with a copy warning I mentioned while testing to see if this does what you want). Again, the next update MAY set them all back OR set any new ones to have a Cost value other than 0.00. I am with you in that, if you don't Own any of these items, there should NOT be a Cost entered for them.

CB has title Other Dead (Idea + Design Works 2013). The indicia Title and the Title on the cover is: The Other Dead.

If you are careful you might try doing them in batches (one per different condition). Step 1: Make sure there are NO Marked comics (Find where Marked is Checked). Step 2: Find all the Good To Very Good conditions. Step 3a: In the Find result for that Condition, Select all the Issues and Quick Change Marked to Checked (so you can find these specific ones and change them back later). Step 3b: In the same Find Result, Select all the Issues and Quick Change Condition to one of the standard ones (doesn't really matter as long as it matches what you are importing). Step 3c: In the same Find Result, Select all Issues and Quick Change Qty In Stock to 0. Step 4: With a file that ONLY contains the issues that correspond with the Condition you are working with ( Good to Very Good in this example), Import the rows. Step 5: Find all Marked issues and verify that the Custom Field 4 values got added. Step 6a: Assuming everything looks good, with the Find result, Quick Change Condition back to what it was originally (Good to Very Good for this example). (You shouldn't have to change Qty In Stock as the Import file should set that to 1 (or whatever number you need). Step 6b: If everything looks good, change all the Marked Issues to Unchecked. Repeat steps 1 to 6b for each different condition. Alternately, if you are good with Excel or a Database, you could export the CB 2020 database and use Excel, a Database to Merge the rows you want then Import into a new database. This would depend on how familiar you are with doing this type of thing.

Yes. I understand. Existing CB 2020 database with current data is missing Custom Field 4 data. Trying to populate with old CB 2017 data. Good new is setting Qty in Stock to 0 in the existing 2020 database works successfully to import the file of CB 2017 data without duplication and with the Custom Field 4 data applied. (I have tested and verified this). Bad new is this appears to only work for the standard CB Grades (MT, NM, VF-NM, VF, FN, VG, G, FA, P (and maybe Ungraded)). (I have also tested and verified this problem). The Import Duplicates the issues for any Custom Grades you create (i.e. Good to Very Good), or any of the 'slabbed' grades (PGX, CGC, CBSC, ets.). This may be a bug in the Import process.