NOT ALL COMICS UPLOADING

[Brian Whorton]

I have 1,555 comics but only 1,072 will load to my ComicBase database.  I have the express version.  I have tried everything on this forum about saving as a text delimited file, but still nothing. 

Anything else i can do?  I don't want this to be a waste of $59.99.

Brian

 

Complete comic collection.xlsx

[Steven L. Dasinger]

Can you explain a little bit more the steps you are taking and what you are trying to accomplish?

The more specific the better.

Also, the supplied file is not a text delimited file, if that is what you are using.

[Brian Whorton]

Sure, this is the file type i tried to upload. After saving this file to my desktop I open up the ComicBase program I just purchased.

File

Import

Select this text file then select open

Then select these four fields to import.  Title, Item #, Qty, Condition

I check to make sure the item separator is set to tab and not comma.

Then select import and hit enter.

Now, when I go to File, collection statistics, i get no comics in my collect but the file I imported contains 1555 copies.

Complete comic collection for upload.txt

[Steven L. Dasinger]

I took your file and Imported it into a New Database.
22 of the Titles had names that don't match the names in CB so, while Imported, they are put into "Unknown Publisher".

"A-Team, The"
"Avengers, The"
"Daredevil Chronicles, The"
"Defenders, The"
"Elektra Saga, The"
"Fantastic Four Chronicles, The"
"Further Adventures of Indiana Jones, The"
"Fury of Firestorm, The"
"Incredible Hulk, The"
"Incredible Hulk Versus Quasimodo, The"
"Kree-Skrull War Starring The Avengers, The"
Legion of Superheroes 1983
Moon Knight
"New Mutants, The"
"Omega Men, The"
"Saga of the Swamp Thing, The"
"Superman Movie Special, The"
"Thing, The"
"Transformers, The"
"Uncanny X-Men, The"
"Vigilante, The"
X-Men Special Edition

Since you are using TAB delimited instead of Comma delimited, I think the " " aroung the names are causing you some problems.
Whether it is by Design or a Bug, all the Titles that couldn't be found in CB, only had Titles created and NO Issues under them. This might be the missing issues that are causing your numbers to not match.

For the ones without the " " (there are only 3 Issues):

Legion of Superheroes 1983    An 2    1    NM
Moon Knight                              35        1    NM
X-Men Special Edition                1         1    NM

You need to either remove them and enter them manually, or correct them with the matching CB Title (and Issue # (i.e. An 2 doesn't look like a valid Issue number)).

Collection Statistics shows 1,162 Comics (789 Unique Isssues)

I Edited the file and changed all the " to nothing and ran the import again (on another new Database) and all but the 3 strange Titles imported successuflly.

Collection Statistics shows 1,552 comics (1,037 Unique issues)

PS it wouldn't hurt to run File->File Tools and use Rebuild Lists after the Import.
Series Information and List of Owned Series are the most relevant but it wouldn't hurt to do Item Information and Lists of Contributors, Storylines, and Notes.