Bulk Adding of cards/sets for contributors

Avatar
Anonymous
  • updated
  • Under review

As a contributor I would love to add cards to the database but doing so one card at a time is extremely tedious especially considering sets nowadays each card has multiple color variations, as well as autos (each with multiple colors), inserts (with colors), etc.  I checked 2020 Prizm WNBA and without doing precise calculations, it was at least 2500+ cards.  I just checked the Beckett XLSX file for Panini Select Football [1] that comes out this week, and its over 21,500 cards.  That would take forever to do individually. 

I would suggest creating an import utility that can pull in a CSV, which could be easily generated from the checklist XLSX files that are on the Beckett.com for each of the products released.  Given the standard format of those XLSX checklists, it would be relatively easy to parse those files and depending on how the API's are written to pull data from the web form into the database, I would imaging it would be easy to pull the exact same data that someone would manually be inputting on the web form from these XSLX checklists converted to a CSV.

Creating such a utility would enable contributors to quickly build up the database, which would be highly beneficial for baseball, as well as keeping up with all of the new releases.

[1] https://beckett-www.s3.amazonaws.com/news/news-content/uploads/2021/04/2020-Select-Football-Checklist.xlsx

Replies 10
Avatar
1
Anonymous
Quote from jj

Every set should be in the database, but not all sets have cards in them.  We've added cards for the most popular sets and continue to add cards all the time.  We have over 2.6 million cards in the database.

If you let me know of particular sets that are missing I will work to add those sets and the cards too.

Always coming across sets that aren't listed in the add missing card function with all proper information included on my end. For example ones I added today to my person collection but can't add to my sportscardpro collection. 2023 Leaf DRAFT and signatures. Only one listed is Leaf Signature Series which isnt what I'm trying to add. I never mind helping add to this wonderful thing we utilize but seems like we shouldn't have to wait to add them to our collection if we are a trusted contributor. Can you please assist me or guide me in the right direction if I'm missing something. 

Avatar
3
Anonymous

In my previous business i helped my on staff programmer set up something very similar for our vendors and clients. We achieved sucess in 2 methods one with xml and running scheduled pulls and pishes and the other with this posted suggestion using an excel file. Ecsel is far easy for most of us to use and understand. Typically we would have the client download a sample excel file preloaded with the field names. In addtition they would download a file definition and instruction pdf. The pdf would list the field, rhe type of field i.e. currency 2 decimal, text, number, etc. It also descibed how to upload, what  to do if we rejected the file and how to  format their file correctly. The pdf could also contain a list of sets, their year, subsets and range of card #s. On the sserver side we created a script that ran we they hit the submit button while upload the excel file. The script walked thru the file to be sure all formating was correct, if their were errors it would return a list of the errors and an indication as what needed to be corrected. Not sure if that helps at all but thats how we achieved similar needs. A GUI interface that would show a row for each card in a specific set that the use could just insert the qty, in that  cards row and grader, grade,cost,note, picture field for front and back could also be included. A drag and drop feature or link could be used and when uploaded the pics could be sized to conform to standards. Well hope this helps. I have 50,000 cards id like to upload but it takes to long. Also there is often no place holder for a cars and ill waste an hour looking for it. It would be nice to have all cards in a set have a place already as the previous poster suggested, regardless if rhere is any sales history. But, You guys are doing a really good job putting the site together, Its going ro keep getting better and better. Thank you!

Avatar
1
jj
Quote from john stefancin

What is the formatting with CSV? I know with modern sets, a way to choose a set then add multiple cards for that set probably wouldnt be possible with all the parallels and such, but a way to bulk add on older sets that arent loaded with parallels would be nice. Copy and pasting a set number doesn't work, so adding a bunch of cards gets really tedious and after a few cards the "i'll come back to this later" mindset kicks in. even if we could send in complete CSVs that the system would auto reject duplicates. 

We just need the full set name in one column (2021 Panini Prizm), player name in another column (Kobe Bryant), and card number in the last column (18).  We can then make any small changes we need before uploading.  Each sheet should be for one set.

Avatar
1
john stefancin
Quote from jj

Great suggestion.  We have tools on backend for admin to do this very thing.  CSV uploads based on spreadsheets.  

I'm not sure we can make it public though because there is lots of quality control needed to format those sheets so they match our database format, naming convention, and set/insert placement.  But it might be possible.

If you want to email me (jj@sportscardpro.com) about a particular set I would be happy to do a trial to see how it goes with a user changing the Beckett file into the correct format and then I'll upload it.  That might be a good middle step to make sure everything is formatted correctly.

What is the formatting with CSV? I know with modern sets, a way to choose a set then add multiple cards for that set probably wouldnt be possible with all the parallels and such, but a way to bulk add on older sets that arent loaded with parallels would be nice. Copy and pasting a set number doesn't work, so adding a bunch of cards gets really tedious and after a few cards the "i'll come back to this later" mindset kicks in. even if we could send in complete CSVs that the system would auto reject duplicates. 

Avatar
1
jj
Quote from Anonymous

Absolutely do not have all sets. I’ve had around 10 sets that I could not edit/add new card no matter how I typed set in.  This is a great website I just wish the cards could be entered and properly!

Please let me know the sets we are missing and I'll add those now so you can add cards for them.  Thank you

Avatar
0
Anonymous

Absolutely do not have all sets. I’ve had around 10 sets that I could not edit/add new card no matter how I typed set in.  This is a great website I just wish the cards could be entered and properly!

Avatar
2
jj
  • Under review
Quote from Anonymous

i am wondering why your platform cant have all sets like becket does?? this is why i signed up  ?? 

Every set should be in the database, but not all sets have cards in them.  We've added cards for the most popular sets and continue to add cards all the time.  We have over 2.6 million cards in the database.

If you let me know of particular sets that are missing I will work to add those sets and the cards too.

Avatar
0
Anonymous

i am wondering why your platform cant have all sets like becket does?? this is why i signed up  ?? 

Avatar
2
jj
Avatar
3
jj
  • Under review

Great suggestion.  We have tools on backend for admin to do this very thing.  CSV uploads based on spreadsheets.  

I'm not sure we can make it public though because there is lots of quality control needed to format those sheets so they match our database format, naming convention, and set/insert placement.  But it might be possible.

If you want to email me (jj@sportscardpro.com) about a particular set I would be happy to do a trial to see how it goes with a user changing the Beckett file into the correct format and then I'll upload it.  That might be a good middle step to make sure everything is formatted correctly.


Reply to
Customer support portal powered by UserEcho