Site Forum

I have a Set that I can enter. I have the complete Checklist. Will the Create Set link give me a template for the Checklist, or do I create that myself and upload? I have a couple of guys that have helped me start to do some things to help, but I wanted to throw this out in the Forum. I am at Level 7.

The easiest way is to create your checklist in an excel spreadsheet.  Then upload it to the site. 

The Excel file requires the following columns:

A = Card Number
B = Name
C = Team
D = Note1 (if needed)
E = Note2 (if needed)

You'll be prompted about a header column (so it doesn't get inserted as a card) and the Note2 column (which will be ignored if you don't have one). There will also be a preview screen. Please confirm everything looks OK before submitting it once (don't double-click the button!) then wait for the system to process it and create the checklist, then check for any unlinked names/teams, notes in the wrong place, etc. One of the biggest issues is users putting Note2 info into Note1.

You can also enter the checklist using text. One card per line, with the format "CardNum Name - Team", and there's a place to add a Note1 if all cards have it.

OK. I have been aiming to give it a try. I haven't done a spreadsheet in quite some time. I am a truck driver so any tech outside of that is on a need to know/do basis. I will make sure it is done right, if I attempt it. Will it automatically link to teams/players, or will that be part of my process? My goal is to get the Set entered and the Complete Checklist in with all notes and images.

Teams and Players are automatically linked when there is only one of each per card.  When there are multiple players and teams on a card, an extra step has to be done to multi-link after the checklist has been submitted.

Fortunatly when you submit the checklist, you get a preview window before you actuall submit to make sure everything looks right in the first 20 or so rows.  At that point, you can cancel, correct your file, and re-upload.

When an individual player doesn't automatically link, either A) there is a typo or B) the player or team has not been given an ID, yet.  In the former case, you can edit the offending item and when you submit the change, it will usually auto-link.  In the latter, there is an option to "Add New".  In that case there is also the option to either create a whole new ID in the database, or link to something that the database shows as a partial match.

In this same thread, what is the proper procedure if a base set checklist has variations, but also has a number of parallel sets?  Since you can't copy set checklists to a parallel set if the base set has variations, should you upload the base checklist with no variations, then copy the base set to the parallels?  And then after that, put in an inaccuracy with the variations so those can be added to the base set?

Excellent question, because I think the main Topps base sets are being handled differently than how I handle the BBM base sets. 

For BBM, since the parallels are usually not the whole base checklist, I've been adding them as their own sets under the "Inserts and Parallel" as a parallel.  BBM has started doing photo variations, and I still do them as a separate "parallel" set, rather than including them as VARs in the main checklist.