Steven L. Dasinger

Rename: 1.jpg to TPB 1.jpg 1-2.jpg to TPB 1-2.jpg 2.jpg to TPB 2.jpg 3.jpg to TPB 3.jpg 4.jpg to TPB 4.jpg From: Pictures\T\TwoMorrows\All-Star Companion, The Rename 1.jpg to TPB 1.jpg From: Pictures\T\TwoMorrows\Batcave Companion, The Rename 1.jpg to TPB 3.jpg From: Pictures\T\TwoMorrows\Comic Book Fever- A Celebration of Comics 1976-1986 Rename 1.jpg to TPB 3.jpg From: Pictures\T\TwoMorrows\Comics Gone Ape- The Missing Link to Primates in Comics Rename 1.jpg to TPB 1.jpg From: Pictures\T\TwoMorrows\I Have To Live With This Guy Delete or Move FCBD 2020.jpg From: Pictures\B\Boom!\Lumberjanes- Farwell to Summer To: Pictures\B\Boom!\Lumberjanes- Farewell to Summer Delete or Rename 1.jpg to CS 1.jpg then Move From: Pictures\M\Marvel\M\Marvel Must Haves- Halo Uprising To: Pictures\M\Marvel\H\Halo- Uprising (NOTE: this is an un-cropped image that should be fixed for deleted) Rename HC.jpg to HC 2.jpg From: Pictures\I\Idea + Design Works\Art of the Pulps, The- An Illustrated History Rename HC.jpg to HC 2.jpg From: Pictures\A\Active Images\Tim Sale- Black and White Rename 22-C.jpg to 22-A.jpg From: Pictures\M\Marvel\F\Fantastic Four (6th Series) Rename 9.jpg to 9-A.jpg From: Pictures\S\Scout\Stabbity Bunny (Scout)

Yes. For the most part, individuals need to correct the errors and submit them. It may take awhile for the corrections to be reviewed / updated. Until then, the mistakes will come back with the next update. You can run File->File Tools - Rebuild Lists, Item Information to update the indexes after you have made changes to remove them from searches.

Paul, CB 2020 was a complete rewrite in a different programming language and database system. So it is possible there is some difference between CB 2017 and CB 2020.

Delete or Move 43.jpg From: Pictures\D\Disney\Donald Duck Adventures (Disney) To: Pictures\G\Gladstone\Donald Duck Adventures (Gladstone)

Delete or Move 1.jpg From: Pictures\A\Amigo\Ezequiel Himes- Zombie Hunter To: Pictures\A\Amigo\Ezequiel Hime, Zombie Hunter Rename 1.jpg to HC 1.jpg From: Pictures\V\Vanguard\Mythos- Fantasy Art Realms of Frank Brunner Rename 1.jpg to HC 15.jpg From: Pictures\I\Image\S\Studio Space (NOTE: I think the HC and TPB versions have the same cover so this could be the TPB cover instead) Rename 1.jpg to 1-A.jpg From: Pictures\M\Marvel\E\Emma Frost Delete 2.jpg From: Pictures\S\Source Point\Skylin (Not sure why the Item # was deleted. May be a prelim cover for unpublished item.) Delete or Move 1.jpg From: Pictures\S\Source Point\Sol Survivor To: Pictures\C\Charon\Sol Survivor (Charon)

It isn't easy to catch when the Publisher of a Title changes and I missed this one when The Phantom (1st Series) changed from Charlton to Gold key. So... Delete or Move ALL From: Pictures\C\Charlton\Phantom, The (1st Series) To: Pictures\G\Gold Key\Phantom, The (1st Series)

Delete or Move 2-A.jpg & 3-A.jpg From: Pictures\O\Oni\Agretsuko To: Pictures\O\Oni\Aggretsuko Rename 1.jpg to Bk 1.jpg, 2.jpg to Bk 2.jpg, & 3.jpg to Bk 3.jpg then Move From: Pictures\P\Poison\Cavalcade of Boys To: Ten Minute Cartoons\Cavalcade of Boys, The (Ten Minute Cartoons) Delete 1121.jpg From: Pictures\D\Dell\Hercules Unchained (Duplicate of item # in Pictures\D\Dell\Four Color Comics (2nd Series) ) Rename HC.jpg to Dlx.jpg From: Pictures\D\Del Rey\Complete Star Wars Encyclopedia, The Delete 10.jpg From: Pictures\J\Jeremy Dale\Skyward (looks like a pre-production cover for a cancelled issue)

A couple of things you can look at. Is Sidekick running? Right-click on the Task bar (or use CTRL+ALT+DEL) and select Task Manager Click on the Startup tab. See if Sidekick is listed and Status is Enabled. If not, Right-Click on it and select Enable. This will start Sidekick the next time you start your computer. If it IS Enabled, then you may just may need to display the icon in the Tray area. Click on Start, then Settings. Then select Personalization. Then select Taskbar. Part way down under Notification Area, click on the hyperlink 'Select which icons appear on the Taskbar'. If Sidekick is in the list, select the button to turn it ON. If Sidekick isn't running... Click on Start. Scroll down to ComicBase 2020... and expand it. Right-click on ComicBase Sidekick and select More > Open File Location. Right-click on ComicBase Sidekick shortcut and select Open File Location. Double click on ComicBase Sidekick.

According to Pete in Wednesday's ComicBase Livestream (https://www.youtube.com/watch?v=eSplMPZH9Vk) it doesn't look like they will have a SDCC sale as there is not SDCC this year. You can watch the video and confirm if I heard it correctly.

When using Quick Change on Fields that contain multiple values is you have to list all the values. For example if the Artist field has J. Scott Cambell, Jack Kirby. If you do a Quick Change to correct Cambell, and just typed J. Scott Campbell, the Artist would just contain J. Scott Campbell. The Jack Kirby entry would be erased. You could try to change it to J. Scott Campbell, Jack Kirby if you just had the one row. But if you have multiple rows, then they would all be set to the same value you entered (either just J. Scott Campbell or J. Scott C\ampbell, Jack Kirby. For the most part, the names with typos only occur a just one or a few rows. The best, easiest way I have found is to just type in the correction manually and then submit the corrections. PS when manually changing, I then to use Paste to insert the missing value as it would cause other names after it to be erased. Or I would copy the rest of the row, type the changes, then paste the info back. Or you could just copy the whole set of values to Notepad, make changes then paste it all back.

Delete or Move 1.jpg From: Pictures\S\Source Point\Comic For Flint Hope, A To: Pictures\S\Source Point\Comic For Flint, A- Hope Delete 1.jpg From: Pictures\B\Black Mask\Space Riders- Vortex of Darkness (duplicate of 1-A.jpg)

What edition of CB do you have? I have the Archive Edition (v3663) and Popular Comics #103 has a cover in my database. I removed it from the folder and attempted to down load it which it did successfully.

Sorry, you are right. I mistook the 'we don't have one' for the upload instead of on the download as we clearly stated...

If you were presented the dialog box of "Do you Want to Submit Your Cover" (not exact text but close enough) and you clicked Yes, the the cover was submitted. In CB 2017 there was an additional dialog box after letting you know how many covers were sent. CB 2020 doesn't have this additional dialog box.

Delete or Move 1.jpg From: Pictures\W\Warren\Horror of Party Beach, The To: Pictures\W\Warren\Famous Films Delete or Move ALL (1.jpg - 1-I.jpg) From: Pictures\D\DC\J\Joker 80th Anniversary 100-Page Super Spectacular To: Pictures\D\DC\J\Joker 80th Anniversary 100-Page Super Spectacular, The Delete or Move 1-A.jpg From: Pictures\O\Oni\Rick and Morty Presents Council of Ricks To: Pictures\O\Oni\Rick and Morty Presents- Council of Ricks Delete 1.jpg From: Pictures\R\Red Giant\Duel Identity

It has been awhile but I don't recall any major problems. Pay to upgrade to Archive Edition. Down the Archive Edition. You can either Un-Install the Pro Edition and then install the Archive Edition (probably safest) or (possibly) just install the Archive Edition (which should do the un-install for you). The only thing I can think of that could give a problem is if the Serial # of the Archive Edition is different from your Pro Edition Serial #. You can check in you account act ComicBase.com by looking at the Registrations. If it is different, you will need to enter it somewhere ( I can't seem to find where but you may be prompted for it when installing or first opening the database. If you have problems send an email to Support@comicbase.com. Also, either order the disks to get all the covers or download all the picture files then install them from inside CB. You will use the same database as it is not deleted during any install process.

Delete or Move 1.jpg From: Pictures\I\It's Alive\Battle for Britain To: Pictures\I\It's Alive\Battle for Britain- From the Pages of Combat Rename Bk 1.jpg to Bk 1-HC.jpg From: Pictures\D\DC\B\Batman Who Laughs Rename Bk 1-LE.jpg to Bk 2-LE.jpg From: Pictures\D\Dark Horse\U\Umbrella Academy, The- Dallas

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.