Import PSA Submission
complete
D
Daniel Simon Sports
As a user, I should be able to import existing PSA submission(s) into both my Submission database and Cards database. Once a valid PSA submission number and ID are provided, Whuppit would make a call to the PSA API and import all available order details. As PSA's submission process already requires users to manually add card details, this integration would eliminate the redundancy in the Whuppit platform.
Log In
Tim
marked this post as
complete
Tim
The PSA API does not allow for this, but I did come up with a solution for importing older PSA orders that do not exist in whuppit.
Each PSA order has a CSV that you can export that contains the cards in the order, their grades and certificate numbers.
The whuppit bulk import page now lets you upload a PSA CSV. It tries to retrieve any details it can about each card—the player, set, sport, etc automatically. You then have the ability to bulk edit the purchase details for each card in the order as well. The combination makes it possibly to very quickly import older PSA orders for tracking. I'm gonna mark this as closed, but will be monitoring the PSA API in hopes that someday I can just automatically bring those grades in.
Tim
This is VERY high on my list. Unfortunately I talked to PSA and there is no way to use their API to do this today. :( I've told them how useful it would be and it sounds like it is at least on their radar, but I don't get the sense it's at the top of their list.
I'm toying around to see if there's some other way of at least simplifying that process a little bit. Even if I could figure out a way to get an order's information as a CSV and allow a CSV import on whuppit, that alone would ease some of that pain.
D
Daniel Simon Sports
Tim thanks for the reply. I saw your comment on YT about the API not performing well; very disappointing. If I may offer an alternative that could speed up item entry...
Create a db that you could query using elastic search. You could use SQL or GCP to maintain a database of all known sets and players. Then you could use dropdowns or responsive search to help make the data entry faster.
Tim
Daniel Simon Sports I like this suggestion. I had tried to find an existing database, but let's just say everyone I found would bankrupt me in a month. :D
I think I can definitely work on putting this together and building it up.
D
Daniel Simon Sports
Tim If I'm not mistaken, some of the existing checklist posters (Beckett, Cardpedia) allow you to export .csv which would make an import considerably easier for you. Would be cumbersome first time out, but creating the player and parallel universe could be universal and a seperate set db could be used to query the card specifics (number, name, insert, parallel). Good luck either way! You have the makings of a nice product