Steven L. Dasinger

I just tried an Advanced Find using ComicTitles.AlphabetizedTitle in the ORDER BY and it worked with no problem Can you supply a screen print of the SQL error message? One possibility is if you are in a different Type. For example, Book Types require BookTitles instead of ComicBookTitles. PS the Use of the Title Columns in Advanced Find is unsupported and could stop working at any time without any warning. PPS I just finished reading both of the lengthy posts and see you already figured out that the Types were being mixed.

The following Reports have a problem with CBCS 10.0 Collection Report (Basic and Summary) Item Checklists Price Labels Price List (Basic, Detailed) (screen prints in same order as list above)

Delete or Move 1.jpg From: Pictures\A\Acme Ink\Charley & Humphrey To: Pictures\#\10 Ton\Charley and Humphrey Comics (However, this appears to be a preliminary cover) Delete 1-D.jpg From: Pictures\M\Marvel\A\Avengers, The (Duplicate of 1-C.jpg)

Unless you own that issue, try to delete it. Hopefully, whatever is causing the problem (if it is associated with that issues) will be removed and the Update can replace it. PS it wouldn't hurt to run Rebuild lists after the deletion but that may not be necessary.

When entering / editing the issue, the Type drop-down box has a Winter Special. Select that and use Number 2012.

Walt, if you want, when you create the new Titles, you could add a Title Comments like: Series continues in <title-name> #<issue-num> See 'Wonder Woman (3rd Series) for an example.

Two different items are being conflated. 1) Changing Titles due to typographical errors (this would include many things. misspellings, extra spaces where they shouldn't be, articles at the beginning of titles, to name a few). 2) Changing Titles to something that is more consistent base on some peoples suggestions. (Note that these suggestions may not be the same with different opinions on what and how to name something.) For #1, this is correcting mistakes. For #2, this is based on subjective opinion. #1 should always be corrected (with maybe some rare exceptions I can't think of at the moment). #2 may be corrected if the situation really calls for it. (NOTE: I am not taking sides on the issue (but I lean towards better naming.) #2 is what most of this thread is about. But to bring up #1 as 'proof' or 'evidence' that since they are changed, that #2 type of titles have to change, also, isn't a good argument. I use to be a Database Administrator. I prefer consistency but also realize when something gets into production, it is hard to get that consistency when the benefits don't out-weigh the time/cost to do the work.

Since you seem to have problems with connections, I went ahead and added the title 'Weird Western Tales (UK Edition) with issues 45-47 and 50-70 (not sure that 48 or 49 exists or not. Two sources I checked did list either). Hopefully, it will be in the next Update.

The title did actually change because there should not have been a space between the ellipsis and the closing parenthesis. There were also title name changes due to an Article being at the beginning (for example: 'The Mighty Utahn' and 'A Midsummer Night’s Dream (Manga Classics)' ) instead of at the end (for example: The Mighty Utahn, The and 'Midsummer Night’s Dream, A (Manga Classics)' ) In both cases, they were syntax / formatting errors that went against the standards.

At this point, it would be best if you contact support. All of the problems I have read seem to connection issues.

I can't answer the question but I will mention that there are a few keywords that cause a line of text to remain in Item Description (or be moved from Notes to Item Description). If the text doesn't have any of them, it will be removed during a Rebuild list process (which HC runs before posting an Update). This would cause the text to be removed/deleted from Item Description in your database at the next content update.

Delete or Move 1.jpg From: Pictures\S\Scout\Pentagram of Horror! To: Pictures\B\Black Caravan\Pentagram of Horror! Delete or Move ALL (1.jpg - 6.jpg From: Pictures\P\Popzero\Typewriter 6 To: Pictures\P\Popzero\Typewriter (NOTE: 1.jpg and 6.jpg appear to be the same cover. Not sure which is correct) Delete 1.jpg From: Pictures\U\Underground\Mountain (back of flipbook 'All New Underground Comix' #3) Delete 1.jpg From: Pictures\S\Scout\Sabretooth Dan Versus Brunch Delete 0.jpg From: Pictures\R\Rip Off\Give Me Liberty! (Rip Off) (Duplicate of 1.jpg) Delete Ash 1.jpg From: Pictures\A\Alternative\Tykes (Duplicate of 1.jpg) Delete or Move ALL (1-A.jpg - 5-B.jpg) From: Pictures\D\Dark Horse\A\Alien 3 (William Gibson's- ) To: Pictures\D\Dark Horse\A\Alien 3 (William Gibson's-) Delete or Move ALL (1.jpg - FCBD 2016.jpg) From: Pictures\G\Graphic India\Avatarex (Grant Morrison's- ) To: Pictures\G\Graphic India\Avatarex (Grant Morrison's-) Delete or Move 1.jpg From: Pictures\S\Scoot\Battle of the Super Powers (Scoot McMahon's- ) To: Pictures\S\Scoot\Battle of the Super Powers (Scoot McMahon's-) Delete or Move 1-HC.jpg From: Pictures\T\Titan\Century's End (Bilal's- ) To: Pictures\T\Titan\Century's End (Bilal's-) Delete or Move Bk 1.jpg From: Pictures\A\Archaia\Fraggle Rock- Down At Fraggle Rock (Jim Henson's- ) To: Pictures\A\Archaia\Fraggle Rock- Down At Fraggle Rock (Jim Henson's-) Delete or Move ALL (1.jpg - 8.jpg) From: Pictures\J\Joe\Frozen (Disney's- ) To: Pictures\J\Joe\Frozen (Disney's-) Delete or Move ALL (1-A.jpg - 1-HC.jpg) From: Pictures\H\Hermes\Ghita, an Erotic Treasury Archival Edition (Frank Thorne's- ) To: Pictures\H\Hermes\Ghita, an Erotic Treasury Archival Edition (Frank Thorne's-) Delete or Move Bk 1.jpg From: Pictures\Z\Z2\Holy Diver (Dio's- ) To: Pictures\Z\Z2\Holy Diver (Dio's-) Delete or Move ALL (1.jpg - 5-A.jpg) From: Pictures\I\Idea + Design Works\Killer Inside Me, The (Jim Thompson's- ) To: Pictures\I\Idea + Design Works\Killer Inside Me, The (Jim Thompson's-) Delete or Move ALL (1.jpg - 1-E.jpg) From: Pictures\A\Archaia\Labyrinth 30th Anniversary Special (Jim Henson's- ) To: Pictures\A\Archaia\Labyrinth 30th Anniversary Special (Jim Henson's-) Delete or Move 1.jpg From: Pictures\D\Dark Horse\L\Lion King, The- Wild Schemes and Catastrophes (Disney's- ) To: Pictures\D\Dark Horse\L\Lion King, The- Wild Schemes and Catastrophes (Disney's-) Delete or Move 1-HC.jpg From: Pictures\I\Idea + Design Works\Little Joe- The Sunday Comics (Ed Leffingwell's- ) To: Pictures\I\Idea + Design Works\Little Joe- The Sunday Comics (Ed Leffingwell's-) Delete or Move 1.jpg From: Pictures\F\Fantagraphics\Mystery of Wolverine Woo-Bait, The To: Pictures\F\Fantagraphics\Mystery of Woolverine Woo-Bait, The Delete or Move ALL (1.jpg - 4.jpg) From: Pictures\J\Joe\Pirates of the Caribbean (Disney's- ) To: Pictures\J\Joe\Pirates of the Caribbean (Disney's-) Delete or Move 1-HC.jpg From: Pictures\I\Idea + Design Works\X-Men Artifact Edition (Dave Cockrum's- ) To: Pictures\I\Idea + Design Works\X-Men Artifact Edition (Dave Cockrum's-) Delete or Move ALL (1.jpg - Bk 1.jpg) From: Pictures\A\Avatar\Yuggoth Cultures and Other Growths (Alan Moore's- ) To: Pictures\A\Avatar\Yuggoth Cultures and Other Growths (Alan Moore's-) Delete or Move ALL (1.jpg - 1-B.jpg) From: Pictures\A\Avatar\Yuggoth Cultures NecroComicon (Alan Moore's- ) To: Pictures\A\Avatar\Yuggoth Cultures NecroComicon (Alan Moore's-) Delete or Move TPB.jpg From: Pictures\I\Impact\Ultimate Book of Drawing Hands (Mark Crilley's- ) To: Pictures\I\Impact\Ultimate Book of Drawing Hands (Mark Crilley's-) Delete or Rename 1.jpg to LL.jpg From: Pictures\S\SQP\Batman Portfolio, The Delete or Rename 1.jpg to LL.jpg From: Pictures\S\SQP\Cody Starbuck Portfolio Delete or Rename 1.jpg to LL.jpg From: Pictures\L\Linsner.com\Dawn Portfolio Petite Delete or Rename 2.jpg to LL 2.jpg & 3.jpg to LL 3.jpg From: Pictures\S\Schanes and Schanes\Elfquest Portfolio Delete or Rename 1.jpg to LL.jpg From: Pictures\D\DC\H\History of the DC Universe Portfolio Delete or Rename 1.jpg to LL.jpg From: Pictures\S\SQP\Malevolent Maidens Portfolio Delete or Rename 1.jpg to LL.jpg From: Pictures\S\SQP\Marvel Super Hero Portfolios- The Incredible Hulk Delete or Rename 1.jpg to LL.jpg From: Pictures\S\SQP\Marvel Super Hero Portfolios- The Uncanny X-Men Delete or Rename 1.jpg to LL.jpg From: Pictures\M\Main Enterprises\Michael Roden Benefit Portfolio Delete or Rename 1.jpg to LL..jpg From: Pictures\P\Paragon\Paragon Pretty Girl Portfolio, The Delete or Rename 1.jpg to LL.jpg From: Pictures\S\Schanes and Schanes\Portfolio of Underground Art, The Delete or Rename 1.jpg to LL.jpg From: Pictures\D\DC\S\Superman 400 Portfolio

Since you mentioned spreadsheets, here is another option. Select the cells in the grid, use CTRL+C to copy the data, then, up CTRL+V to paste it into a spreadsheet. You can either delete the extra columns you don't want in the spreadsheet. or You can move the Custom Field 1 column as far to the Left as possible, cause fewer columns you don't want being copied or You can use the Press and Hold the CTRL key, select all the cells in the Item # column, then in the Qty Column, and finally the Custom Field 1 column. The Copy from CB and Paste to the spreadsheet (this is probably more work than just copying extra columns and deleting them in the spreadsheet but just mentioning it as an option).

Hmm. Here is what mine looks like. What appears to be different is the Column heading includes Custom Field 1 while yours doesn't appear to have this hading. Also, I am not sure what the < / td > in yours are (other than HTML tags, I think) but I don't have them. I will assume SB11, Mark01, SB70, and LB14 are the Location values.) I just used generic A, B, C, D... for testing.

This isn't exactly what you want but it is close. Go to the Title you want the report for. (this is the easiest way but you can manually select the one title in the report if want) Select Report->Item Checklists Titles to Print: Select 'Current Title' Report Items: Check 'Items in My Collection' Custom Items to include: Check 'Custom Field 1' (or Location, if that is what you named it) Run the report. The Report will include: Issue # Condition Quantity Cost NM Value Notes Custom Field 1

Okay. What happens when you right-click on the large cover image in the top left corner of the CB window? Do you have an option to 'Show Picture File'? If you do, you can use that to find the file path for the covers. If not, I think the default path is C:\Users\Public\Documents\Human Computing. It that folder exists on you laptop, you can copy the Picture file folder from your external hard drive to this folder.

No, you don't have to do it the 'long way'. Just copy the entire Picture folder from the external drive to the new drive location on the laptop. After that, use File tools->Manage Pictures and Movies to make sure the file path to the folder that CONTAINS the picture folder (not the actual Picture folder) is correct.

Do you still have them on another computer? If you can share a drive over a network, do have a thumb-drive you could copy them to to transfer to the new laptop?

Sorry. I didn't realize you had the Express version. I think only the Pro and Archive editions have picture disks.

At that point click the green arrow under Download at the top of the list. (the one with the Subscription Expires date of 5/24/2023). That will take you to the next page to either download the Quick start version or click the Other radio button to get the full size covers.

On the ComicBase website, select My Account, then Registrations. Click the green download arrow next to your active subscription. If you want the Quick Star Version (thumbnail sized to start), it should be listed. However, if you want the full size pictures (which I would suggest), click the Other radio button. You should see several links to down load the picture files. Once all are downloaded, use CB to Install the.

You can either download the Picture file ( s ) from the CB website. or If you have the pictures on another computer that is connected to a network, you can use Window to copy them to the new computer.

To make a shorter list, these are what I believe are the correct Titles. Except for the, probably, incorrect 2 extra issues in the 5th Series, I think this is all of them. CB Title Publisher Date Range Issue #s Cover dates Elf Lord (Night Wynd) 'Night Wynd (1980-1982) Issues 1-15 from Jun 1980 - ??? 1982 'Elflord' Aircel (1986) Issues 1-6 from Feb 1986 - Jul 1986 'Elflord (2nd Series)' 'Aircel (1986-1989) Issues 1-31 from Oct 1986 - Oct 1989 'Elflord (3rd Series)' 'Night Wynd (1992) Issues 1-4 from ??? 1992 - ??? 1992 (The Return of the King mini-series) 'Elflord (4th Series)' 'Night Wynd (1993) Issues 1-4 from ??? 1993 - ??? 1993 (The Summer's Magic mini-series) 'Elflord (5th Series)' 'Night Wynd (1993) Issues 1 from ??? 1993 (The Dragon's Eye one-shot (there should only be the 1 issue, I believe) 'Elflord (6th Series)' 'WaRP (1997) Issues 1-4 from Jan 1997 - Apr 1997 'Elflord (7th Series)' 'WaRP (1997-1998) Issues 1-7 from Sep 1997 - Mar 1998

This is the information I found and sent to Mark on March 10. It is a little long and can be confusing but the most of the Elflord titles need major work to them. ==================== Currently (as of Mar 10) in CB are: 'Elflord' Published by Aircel (1986) Issues 1 - 6 Cover Dates Feb 1986 - Jul 1986 'Elflord (2nd Series)' Published by Aircel (1986-1989) Issues 1 - 31 Cover Dates Oct 1986 - Oct 1989 'Elflord (3rd Series)' Published by Night Wynd (1993) Issues 1 - 4 Cover Dates (not listed) 'Elflord (4th Series)' Published by Night Wynd (1993) Issues 1 - 4 Cover Dates Jan 1997 - Apr 1997 'Elflord (5th Series)' Published by Night Wynd (1993) Issues 1 - 7 Cover Dates Sep 1997 - Apr 1988 (other than Publisher, same as deleted 7th series) 'Elflord (6th Series)' Published by WaRP (1997) Issues 1 - 4 Cover Dates Jan 1997 - Apr 1997 (deleted with the Update) 'Elflord (7th Series)' Published by WaRP (1993) Issues 1 - 7 Cover Dates Sep 1997 - Apr 1998 GCD has the following: 'Elflord' Night Wynd (1980) Issues 1 - 15 Cover Date Jun 1980 - 1982? 'Elflord' Aircel (1986) Issues 1 - 6 Cover Date Mar 1986 - Aug 1986) --Matches 'Elflord' 'Elflord' Aircel (1986) Issues 1 - 22 Cover Date Sep 1986 - Sep 1988 --Matches part of 'Elflord (2nd Series)' 'Elflord' Malibu (1988 ) Issues 23 - 31 Cover Date Oct 1988 - Oct 1989 --Matches the rest of 'Elflord (2nd Series)' (Aircel became a imprint of Malibu but with Aircel logo on all covers) 'Elflord' WaRP (1997) Issues 1 - 4 Cover Date ??? --Matches 'Elflord (6th Series)' 'Elflord' WaRP (1997) Issues 1 - 7 Cover Date ???? --Matches 'Elflord (7th Series)' which was deleted. MyComicShop has the following: 'Elflord (1st Series)' Aircel (1986) Issues 1 - 6 Cover Date Feb 1986 - Jul 1986 --Matches 'Elflord' 'Elflord (2nd Series)' Aircel (1986) Issues 1 - 31 Cover Date Oct 1986 - Apr 1990 --Matches 'Elflord (2nd Series)' 'Elflord Return of the King' Night Wynd (1992) Issues 1 - 4 Cover Date 1992 --Matches 'Elflord (3rd Series)' 'Elflord Summer's Magic' Night Wynd (1993) Issues 1 - 4 Cover Date 1993 --Matches 'Elflord (4th Series)' 'Elflord Dragon's Eye' Night Wynd (1993) Issue 1 Cover Date 1993 --Either not in CB or actual Elflord 5th series. 'Elflord' WaRP (1997) Issues 1 - 4 Cover Date Jan 1997 - Apr 1997 --Matches 'Elflord (6th Series)' 'Elflord Cuts Loose' WaRP (1997) Issues 1 - 7 Cover Date Sep 1997 - Mar 1998 --Matched 'Elflord (7th Series)' which was deleted. (NOTE: for the 3 published by Night Wynd and the last one from WaRP, the mini-series 'name' is on the cover. Don't know if they are the official title or not) Here are what appears to be the complete(?) list. I only called them 'Elflord' as I don't know what the actual titles will be: CB Title (not sure) Publisher Date Range Issue #s Cover dates (not in CB) 'Elflord' Night Wynd (1980-1982) Issues 1-15 from Jun 1980 - ??? 1982 'Elflord' 'Elflord' Aircel (1986) Issues 1-6 from Feb 1986 - Jul 1986 'Elflord (2nd Series)' 'Elflord' Aircel (1986-1989) Issues 1-31 from Oct 1986 - Oct 1989 'Elflord (3rd Series)' 'Elflord' (1) Night Wynd (1992) Issues 1-4 from ??? 1992 - ??? 1992 'Elflord (4th Series)' 'Elflord' (2) Night Wynd (1993) Issues 1-4 from ??? 1993 - ??? 1993 'Elflord (5th Series)' 'Elflord' (3) Night Wynd (1993) Issues 1 from ??? 1993 'Elflord (6th Series)' 'Elflord' WaRP (1997) Issues 1-4 from Jan 1997 - Apr 1997 ''Elflord (7th Series)' 'Elflord' (4) WaRP (1997-1998) Issues 1-7 from Sep 1997 - Mar 1998 (1) MyComicShop lists the Title as 'Elflord Return of the King'. (2) MyComicShop lists the Title as 'Elflord Summer's Magic'. (3) MyComicShop lists the Title as 'Elflord Dragon's Eye'. (4) MyComicShop lists the Title as 'Elflord Cuts Loose'. =============== PS Currently CB has 'Elflord (5th Series)' with 3 issues, I think that #2 and #3 shouldn't be there as the 'Dragon's Eye' was just one issue.

This looks more like a Windows problem. Try this: In the search box on the task bar, type: Folder Options and select File Explorer Options. Click on the View tab. In the list of options in the Advanced Settings box, the 'Always Show Icons, Never Thumbnails' should NOT be checked.