Kurt D. Koester

I'm receiving the same error message.

Okay, so I think I submitted both these missing issues for review. Hopefully whomever checks them out feels free to correct/modify anything I did wrong or is incorrect.

I can also add that as a new item, too.

Thank you Adam and Steve. I will read up on how to submit it as a new entry. Any ideas on that "free" Pizza Hut X-Men issue?

It is a treasury-sized comic, and it is "exactly" the same one in the link Steven posted.

Rather than start a new topic, here's another title I'm stumped on. It's a Pizza Hut Giveaway, but it's not one of the #'s 1-4 listed in CB. No cover price, published 1/1/1993. I tried searching on 'Atomic Avenue' and couldn't find it. Any other search suggestions for CB? Thanks. Issue Notes Giveaway mini-comic with centerfold coupons; Distributed in tandem with the X-Men Collectors Edition #1-4 giveaway comics from Pizza Hut; Comic has no indicia; Title taken from the cover.

Thanks for the suggestions. I'll give them a try.

I'm having a very difficult time finding the correct spot in CB for this treasury-size edition of the "Special Collectors Edition!" of Marvel Special Edition - Star Wars: The Empire Strikes Back. The publication date is 3/1/1980. I've tried searching "star wars", "Marvel Special Edition", and "Empire Strikes Back" to no avail. Anyone think of anything else? Thanks in advance.

Ugh! I'm seeing the problems of when a title is classified as one thing and possibly another, but being the same title. The title I'm referring to is "Avengers Chronicles, The" (not "Avenger Chronicles, The"). The situation is that it is actually "Fantaco's Chronicles Series" in CB as issue #4. To make things even MORE confusing, "X-Men Chronicles, The" is listed as issue #1, but also as a totally separate title as "X-Men Chronicles (FantaCo) in CB. Both are the exact same book. "face-palm"

You are so AWESOME! Thank you for helping me all of this. I will work on the modifications you listed and let you know how it goes. Thank you again VERY much! 🙂

I've attached a sample of the export to a .csv and changed to a .txt file. Thank you SO much for your help with this! I sincerely appreciate it because otherwise, I'd be lost. CSVWorking File 01-02-2020.txt

I just tried an experiment. I opened a copy of my exported .txt file and did a "find & replace" finding the "tab" and replacing it with a ",". I then imported that file into CB and made sure to select the "Separator" as "comma" instead of "tab" in the bottom right corner of the CB import window. I thought it worked, but all of the "Qty" and "Cost" fields are all 0 (zeroes). That doesn't seem to be working either. I'm stumped!

I'll again expose my ignorance by saying I don't know how to export out of Excel to a comma separated .txt file. The only option I saw would be saved as a .csv file, and CB only looks for .txt files. I tried exporting out of Excel as a Unicode Text .txt, and also the Text (MS-DOS) .txt, and neither of those two .txt files imported into CB correctly. With the Text (Tab delimited) .txt, at least "most" of my collection imported into CB properly. It was just anything with the , in the title that didn't work. I may just be completely dumb, but if there's a way to export out of Excel as a comma separation instead of tab, how would I do that/what type would I choose?

The odd thing I noticed when I exported from my spreadsheet to the text file is that some of the titles show up with " " marks around them, and those are the titles that don't import into CB. I did a test of removing the " " marks around "2001, A Space Odyssey" and also "Avengers, The" but that didn't seem to make a difference. They still did not import. Why are the " " marks showing up for some titles, but not others, and why would they possibly be the reason the titles with the " " marks not import? Thanks as always for your hlep.

Okay, so I finally finished modifying my spreadsheet to match the fields as recommended. I created a new DB and imported the spreadsheet that I converted as tab delimited text, and it appears it imported it all - mostly. I have some odd examples of what did and did not get imported. 2001, A Space Odyssey did not import, but 2010 did. None of my Avengers, The were imported, either. I tried a test with adjusting Avengers, The to The Avengers, but that didn't work either. Is there a text list of "exactly" how the titles need to be for them to import? Any suggestions?