Steven L. Dasinger

If there is no 'apostrophe s' then it is not a possessive and would not have '(Fred Perry…)' added to the title. It is a Treasure Vault of sketches by Fred Perry. It is not his 'Treasure Vault'. Since this is a pre-release, there is no real way to know that the actual title is. It could be 'Fred Perry Treasure Vault Sketchbook' or 'Treasure Vault Sketchbook' (or something else).

Not sure if this is the reason or not, but (if my memory is working correctly...) 'back in the day' one of the times the Content Update was not processed for a week was during SDCC.

The cover scan for 'Adventures of Miru, The' #1/B is incorrect. It is the cover for #Bk 1. (You can tell by the 'Volume 1' on the cover.) The cover scan above is for the #1/B issue in CB (Reno Msad cover).

No.

This one should return Issues with or without a Type and/or a Variation outside the supplied Issue number ranges while eliminating hard/soft cover books. This was accomplished by using IssueNum range OR IssueType NOT IN 'HC' or 'Bk' in both the first/last-title-name 'blocks'. (I didn't add Variation since it only appears the beginning of the Item # (i.e. Item Type) that causes a problem for the ranges of Issue Numbers) NOTE: I just filtered out 'HC' and 'Bk'. You can add other Type values if needed. First statements filters to Issues you Own AND Type/Variation NOT in 'Bk' or 'HC'. The 1st 'block' filters to Issues for the 'first-title'name' AND either Issue Number greater than or equal to supplied value OR Item Type NOT 'HC' or 'Bk' The 2nd 'block' filters to Issues for the 'last-title'name' AND either Issue Number less than or equal to supplied value OR Item Type NOT 'HC' or 'Bk' The 3rd 'block' filters to all Issues from titles greater than 'first-title-name' AND less than 'last-title-name'. NOTE: Need both the OR ItemType NOT IN for both the first/last-title-name 'blocks' along with ItemType and Variation NOT IN 'Bk' and 'HC' at the beginning because the first-last-title-name blocks need it to allow Types outside the supplied ranges (which would INCLUDE 'Bk' and 'HC') AND the first to filter out the unwanted 'Bk' and 'HC' issues. I.QtyInStock >= 1 AND I.ItemType NOT IN ('Bk', 'HC') AND I.Variation NOT IN ('Bk', 'HC') AND ( ( ComicTitles.AlphabetizedTitle = (SELECT AlphabetizedTitle FROM ComicTitles WHERE Title = 'Batman' ) AND ( I.IssueNum >= 11 OR I.ItemType NOT IN ('HC', 'BK') ) ) OR ( ComicTitles.AlphabetizedTitle = (SELECT AlphabetizedTitle FROM ComicTitles WHERE Title = 'Firefly (Boom!)' ) AND ( I.IssueNum <= 20 OR I.ItemType NOT IN ('HC','Bk') ) ) OR ( ComicTitles.AlphabetizedTitle > (SELECT AlphabetizedTitle FROM ComicTitles WHERE Title = 'Batman' ) AND ComicTitles.AlphabetizedTitle < (SELECT AlphabetizedTitle FROM ComicTitles WHERE Title = 'Firefly (Boom!)' ) ) )

To utilize AlphabetizedTitle indirectly, you will need to use a subquery. This will allow you to supply the first-title-name and last-title-name to return AlphabetizedTitle in the query. I.QtyInStock >= 1 AND I.ItemType NOT IN ('Bk', 'HC') AND I.Variation NOT IN ('Bk', 'HC') AND ( ( ComicTitles.AlphabetizedTitle = (SELECT AlphabetizedTitle FROM ComicTitles WHERE Title = 'Excalibur' ) AND I.IssueNum >= 11 ) OR ( ComicTitles.AlphabetizedTitle = (SELECT AlphabetizedTitle FROM ComicTitles WHERE Title = 'FF' ) AND I.IssueNum <= 20 ) OR ( ComicTitles.AlphabetizedTitle > (SELECT AlphabetizedTitle FROM ComicTitles WHERE Title = 'Excalibur' ) AND ComicTitles.AlphabetizedTitle < (SELECT AlphabetizedTitle FROM ComicTitles WHERE Title = 'FF' ) ) ) The first part filters for any issue you own AND ItemType NOT in BK or HC AND Variation NOT IN Bk or HC (to attempt to remove hard/soft cover books) (more can be added as needed) The second part filters for AphabetizedTitle from a subquery where first-title-name is supplied ('Excalibur' in this example') and IssueNum >= some-issue number. The third part filters for AlphabetizedTitle from a subquery where last-title-name is supplied ('FF' in this example) and IssueNum <= some-issue number. The forth part filters by Alphabetized title from a subquery where Title > first-title-name ('Excalibur') AND Title < last-title-name ('FF') NOTE: I used IssueNum instead of the composite ItemNumber as it is Numberic instead of Alpha so the returned numbers are more correct. (Text numbers sort or return values based and Text order and not Numeric order)

No. This is not displayed (since about V17, I think) nor can it be exported. And #2 is pretty much the same answer (no way to display/get the AlphabetizedTitle. The only way I can see to find the information is trial and error. But that would take a LONG time as you would have to try 'ComicTitles.AlphabetizedTitle = 'some-text' until it actually returned something (i.e. you got the AlphabetizedTitle correct and do this over and over just for 1st Title, then Repeat the process for the 2nd Title, etc. (Unless HC wants either supply a list or make it displayable as part of a Title Find result set grid.)

Another thing to consider is, if you are looking in boxes, you probably don't want Hard or soft cover books. Adding AND I.ItemType NOT IN('Bk', 'HC') Should remove most occurrences. If not, you can add to the list to Not include as you find other Types.

Here is my first guess at something that might work (or get you in the right direction: I.QtyInStock >= 1 AND ( I.Title = 'first-title-name' AND I.ItemNumber >= '20/A' AND I.Title = 'last-title-name' AND I.ItemNumber <= '100/C' AND I.Title > 'first-title-name' AND I.title < 'last-title-name') Theoretically, this should: Find all issues for the First-Title-Name starting at a specific Item # until the end of the owned issues AND Find all issues for the Last-Title-Name starting at a specific Item # until the beginning of the owned issues AND All owned issues for any Titles between the First Title Name and the Last Title Name. NOTE: For the last 'between' clause, it is just greater then / less than and not greater than or equal to / less than or equal to. But you are correct about the difference between Title Name AlphabetizedTitle value. I would play around with removing spaces and special characters and adding numbers for multiple Title series (Fantastic Four Vol 1, Vol 2, etc...). Also, I am not sure if unicode characters are part of the You may need to experiment with Item # (or possibly use the component parts (i.e. ItemType, IssueNum, Variation, Printing) for the Find.

If you have a backup on the HC server cloud, you can contact support (on Monday) and they 'may' be able to help you get data from it.

From what the Geek Squad indicated, while you have the SSD hard drive, it is not undamaged. This would explain why they couldn't get any data off of it. Maybe some on site (your son) can help. Otherwise, you may be out of luck.

An assumption and suggestions. You have a laptop in which the hard drive was swapped out with the new one. This is the only reason I can think of why the Geek Squad would not be able to transfer data. (but even then it should have been possible to copy some/all of the data off the old drive and add it to the new one). If you do have a laptop, do you have 1 or 2 hard drives? I know that older laptops had the space and connectors to add a second drive (don't know about newer ones). If you have the space, can you install the hard drive to your computer (this would also refer to a desktop computer if you have one)? If you do, you can simple install the drive and then copy the data from one drive to another. If you do not have the space and/or don't want to open the computer, you should be able to buy a drive enclosure (you would have to make sure it match the form factor of the drive and probably connect to you computer with a USB cable. Install the drive and connect to your computer and you can copy the data. Alternately, if you have another computer (or a friend with a computer) you could install the drive on that computer (internally or externally) and copy the data somewhere (options include making a copy the HC 'cloud' if they have CB installed, copy onto a USB drive (thumb drive), or connect to your home network (if you have one) and copy it over the network. (or take the drive and a USB drive (and your computer)to the Geek Squad and ask them if they can copy the database to the USB drive. NOTE: By default your database is located on your C Drive at either: \Users\<logon-id>\Documents\Human Computing\ComicBase Databases (old location) or \ComicBase\ComicBase Databases (newer location) (unless you changed to location)

Nope. That answers the question. Covers remain and the issues will be added back (hopefully). Thanks.

Thanks for the reply. My main concern is more about where, if any where, the Cover Scans should be renamed/moved to. Or should they just be deleted?

Would need more specific information: A) "Geek Squad could not transfer data from my old hard drive to my new hard drive." Why? Was the old hard drive destroyed? Unless you had a head crash, circuit failure or some catastrophic event, you should be able to get data off the hard drive. Do you still have the old hard drive? B) When using CB did you have it making backups (by default it does)? Where these backups on the save drive or a different drive? C) "After signing in to Comic Base I saw a download form 2023 which I downloaded." I assume you mean you went to the CB website and found a backup under 'My Account'? Are you talking about the CB Program or the actual Database? If it was a database file, you should be able to open it with the current version of CB. What steps are you taking?

I don't think I will be out of line to mention this. With the new release of CB (probably coming out soon (but that is an outsider observation and NOT from HC (Pete is making an announcement Thursday at SDCC))), there is some change to the compressing that may (or may not) help with this.

While it is not common, I have come across variants that were done by the same artist. I referring to two completely different artwork (not a B&W, Virgin, etc of the same artwork). Not sure if there was some other 'text' to tell them apart or not.

Try this. Open a word processor (Notepad would work). Then scan the issue into the word processor. This will allow you to see what is being scanned. If what you are scanning matches the UPC and it still is not finding it, then there is something wrong. At that point, I would attempt a Rebuild Lists with all but the last Picture information checked. If that still does not resolve the problem, you will probably need to contact support.

Justice League Vs. Godzilla Vs. Kong 2 has issues 2/A through 2/E Blood Type has issues 1/A through 1/I Robin & Batman: Jason Todd has issues 1/A through 1/E Dark Honor has issues 1/A and 1/B Fire & Ice: When Hell Freezes Over has issues 4/A and 4/B Hello Darkness has issues 12/A through 12/E It looks like all the titles/issues don't have a single number issue but instead are all listed as 'variants'. Going by the UPC, it looks like the 'A' Variation is the 'first' issue for all of them. Justice League Vs. Godzilla Vs. Kong 2 issue 2/A has UPC 76194138628700111 Blood Type issue 1/A has UPC 64985600842800111 Robin & Batman: Jason Todd issue 1/A has UPC 76194138389700111 Dark Honor issue 1/A has UPC 70985304315700111 Fire & Ice: When Hell Freezes Over issue 4/A has UPC 76194138937000411 Hello Darkness issues 12/A has UPC 84428401112912011

If you can supply specific issues, I can check my database and see if they exist there are not (or you can check Atomic Avenue). If AA (or I) have them that would indicate a problem on your end. If AA (or I) don't have them, that would indicate a problem at Human Computing.

Can you supply some specific titles? At a guess, the current mess with Diamond Bankruptcy may have something to do with it.

Delete or Move 1-DLX.jpg and 1-HC.jpg From: Pictures\I\IDW\Rocketeer, The- The Complete Collection To: Pictures\I\IDW\Rocketeer, The- The Complete Adventures Delete or Move HC.jpg From: Pictures\N\NESFA Press\A Lit Fuse- The Provocative Life of Harlan Ellison To: Pictures\N\NESFA\Lit Fuse, A- The Provocative Life of Harlan Ellison Delete or Move 1-A.jpg From: Pictures\A\Ahoy\Toxic Avenger Comics To: Pictures\A\Ahoy\Toxic Avenger (Ahoy, 2nd Series) Delete 1-V85.jpg From: Pictures\D\DC\D\Dark Knight III- The Master Race (duplicate of 1-V29) Delete 1-D.jpg From: Pictures\I\Image\I\I Hate Fairyland (duplicate of 1.jpg) Delete 2-C.jpg From: Pictures\B\Boom!\King of Nowhere NOTE: The following issues were deleted (moved?). I don't know the Heavy Metal titles well enough to know if these belong somewhere else: 1/N 1/O 1/P 1/Q 1/R 1/S 1/T 1/U 1/V 1/V27 1/W 1/X 1/Y 1/Z

PS While issues before (about) May 1977 may have other distributing methods like the direct market, it was decided to have a cutoff date. the earlier issues are left as (mostly) 'Whitman' variants for the ones that where sold at other places besides the traditional Newsstand stores.

Currently, the way CB is set up, when both Direct and Newsstand issues exist, the plain numbered issue is the Direct edition (i.e. 1) and the Newsstand has the NS variation (i.e 1/NS). It there is only a Direct edition OR only a Newsstand edition, it is just a plain number (i.e. 1). When first set up, CB added Newsstand Edition to the 'Item Description' column. So far, CB has been 'mass changed' to add NS Issues for Marvel and DC (from about May 1977 through Oct 2017) In generally, I would NOT use the DM variation (or change to using the DM variation) if CB does not already have it (some older issues may have use DM when there was some 'feature' that made using DM make sense at the time. Now it would not be used. As for the cover scans, they are 'linked' to the issue by the Item #. So if you change the Item #, you would have to open the picture folder for that title and rename the cover scan to match the change.

PS if you care, there is both a Direct variant (#SE 1) and a Newsstand variant (SE 1/NS). I found it by typing the Newsstand barcode into the Find box at the top of the window.