Topic: How to add whole collection with: "Collector number, qty , #foil"

[EDIT: A workaround helps to partially mark this as solved!!!  I still need an actual direct solution cuz it's not serious to not have it in-house.
See partial solution in reply. Everyone will know how to workaround]

Hello i am a new premium user, and new user, overall.
Trying to start adding my collection. I want to ad cards by typing collector number. I will not type names.
6 characters per card is ample enough and unique.

So let me know how to import my 15 full boxes list
"collector number" + quantity + qty foil. 
See small sample of duskmourn in attached file
wink I split my collector numbers in 2 parts, cuz I knew all websites would probably be dubious of "collector number" being the real "primary key" of any collecting cards, MTG included.

What I have currently found that seems like slow inferior repetitive options :
checklists of whole sets... on this page
https://deckbox.org/editions

This page : we need : quantity, qty foil... where is the foil number input?
The punch card format is not fun, just showing "my collection, normal, foil" is what i need,
maybe showing french and english for each would be fun
https://deckbox.org/editions/849-bloomburrow

Give me a text box where i can type my card collector#
if you cannot accept a file with : "Collector number" , "quantity".

Let's drop foil for now, just tell me this ultra basic entry process has been thought of by the coders of this website?
Who doesn't check a collection order in a unique key using the collector numbers of the cards?
Let me they ya they don't know what the unique key of their database should be wink
Here we're not talking having MTG with other TCGs. We talk MTG cards, so let me know cuz they cannot have forgotten this super necessary option wink What programmer forgets to allow users to use collector number as identifier to lookup a card?

Thanks in advance !
(sorry for all the questions.
i'm a database designer, data structure geek,
dissecting imperfect systems is a way of life, all are, moreso "mines")

Last edited by ThroughtonsHeir (2024-10-30 00:59:40)

Post's attachments

example.JPG 31.23 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

Re: How to add whole collection with: "Collector number, qty , #foil"

So until I see how to do it directly here and other websites (moxfield)
I'll list how to workaround this situation.

Since the basic collector number is constituted of a SET and a number,
we keep each separate in fields as I did, Set, Number, Qty,
then save the excel as a CSV,
import it on https://luckypaper.co/resources/list-formatter/
Click options,
in the drop list of "Lookup cards by:" SET & COLLECTOR NUMBER

which allows us to querry names for that CSV and output as file that the websites too basic to accept COllector numbers as basic entry formats to gobble up a ultra complex & error prone file including long complex names...

even if they incorrectly divide collector number into SET+Number,
how can all cards be unique in a MTG collection?
By Collector number (SET + number). Think it through.