Search options (Page 10 of 18)

I agree -- it definitely took some troubleshooting the first couple times I tried it. This is a good suggestion!

That looks right to me, but keep in mind that how it displays in the program you're using to edit it versus how it actually looks in its raw form sometimes differs. Easiest way to see the latter is to open it in a basic text editor like Notepad. Sometimes the encoding it's saved in can also cause random error messages (again, like you said, all things that would be great to have documentation for!).

If you'd like, send a link to the CSV you're trying to import on something like Drive/Dropbox/etc. and I'll take a look.

Damn..... I wish I had $15k to just drop on a collection. This is the perfect collection for me! I sadly didn't start playing until around the 2011 era when you came back, so I've been slowly trying to collect past sets. How I wish I'd played as a kid when Magic was first coming out....

Anyways, enough daydreaming.    On to some tips.

First, even though you said you don't want to sell singles, don't be surprised if that's still the main advice people give you. It's by far the best way to get maximum value from your collection. But I agree with you -- time is valuable and not replaceable, so sometimes just selling en masse is preferable. However, I might still recommend selling the top 1% of your collection as singles, then sell the rest as one lot. Not only will this get you better value for your high-end cards, it'll also reduce the overall cost of the large lot, making it much more accessible for others and easier for you to move.

But let's say you truly don't want to bother with any single sales and want to move the whole collection....

===================================

We need to be realistic about value. As you already hinted at, Deckbox pricing is not helpful. At most, it shows you the relative value of your cards, helping you pick out those high-end cards if you wanted to. But there's three main things to consider here:

1. Deckbox values are almost always inflated compared to more competitive marketplaces like TCG Player and eBay. I have found that, as a general rule of thumb, if I subtract about 15% of the Deckbox-listed value, that's pretty close to a more realistic value. Obviously there's exceptions to this in both directions, and that's especially true once you're dealing with older cards. The ONLY reliable price source for old, high-end cards are eBay's sold listings. This is what people are actually paying for the particular card you have, including condition. But to get us in the ballpark, we can just apply my handy 15% rule across the board.

2. No one pays retail value for bulk. Now, everyone's definition of bulk varies depending on what they deal in. People who deal in $50-$100 cards will probably consider anything under $2 bulk, whereas someone who deals in $500-$2000 cards may not look at anything less than $10-$20. But regardless of where you set the threshold, you have to consider that the majority of the "value" quoted by Deckbox is from bulk. Even if their average price is only 50 cents, 10,000 cards will still claim to be worth $5k!! In reality, most places are only going to pay a penny per card. Maybe if they know there's $2-$5 cards among them, they'll pay more like 5 cents per card. But you're still looking at only $100-$500 for those 10k cards, not $5000.

3. Finally, if you plan to sell en masse, be prepared to accept only 50%-75% of the collection's value, depending on where you go and how you're paid (for instance, some stores offer higher percents if you get paid in store credit... though I'm guessing that's not something you want, as it seems you're cashing out of the game entirely). That's the price you pay for selling fast. Think of it as the time you didn't spend selling singles.

Given all that, I went through your collection and found the following:

Bulk              Value of
threshold  Cards  high-end    Bulk    Bulk value  Total Value
---------  -----  ----------  ------  ----------  -----------
>= $2      849    $22,018.30  13,732  $  274.64   $22,292.94 
>= $5      401    $20,611.78  14,180  $  709.00   $21,320.78 
>= $10     229    $19,374.62  14,352  $1,435.20   $20,809.82 
>= $20     121    $17,871.45  14,460  $2,892.00   $20,763.45 

So I first converted all prices to 85% of Deckbox, then used different thresholds to give you some guestimates for different routes you might take.

The way I handled bulk is I priced it per-card at a value equal to 1% of the threshold. So when your bulk threshold is $2, you're getting 0.02 per card, while when the threshold is $10, you're getting 0.10 per card.

Lastly, remember #3 from above. As you can see, your collection's value is somewhere around $21k to $22k, depending on how you proceed. But you're only going to get $11k to $16k, depending on who you're working with.

===================================

So assuming you're cool with getting ~$13k for your collection by selling it all at once, where should you go? Well, individual collectors are probably going to give you more value than stores (remember that stores then need to be able to turn around and make a profit), but they're also riskier to deal with.

The only specific recommendation I can make is Rudy from Alpha Investments (he has a large YouTube channel you can easily find). He has an established public record of being reputable and good to work with (despite a lot of early on hate he received). As one of his patrons, I can attest to the fact that he takes care of his people, no matter what. He'll be particularly interested in your vintage cards, as that's what he deals in (he doesn't have much interest in newer stuff, so you might just sell him your vintage and save the newer part of your collection for another buyer). And if you're game, he might even feature your collection on his channel. Email: AlphaInvestmentsLLC@gmail.com

Can't believe I'm actually recommending him. I'm kinda sick of all the vintage cards getting forever locked away in his vault! LoL. Can't he just let the rest of us have a few of those cards???

Anyways, he's a good guy. Fully support and recommend.

It's there when you select a default edition or when you select an edition for a specific card in your inventory, as well as on that card's details page. He apparently just forgot to add a link to it on the main Editions page! I'm sure he'll add the link soon, but in the meantime, you can add the cards from that edition to your inventory as normal.

That's interesting. The ones you describe are for the C20 set (specifically the Symbiotic Swarm deck). Since Indestructible and Double-strike don't feature in the main IKO set, it's weird they'd include them in the prerelease kits.

#003 -- https://scryfall.com/card/tc20/20/ability-punchcard
#004 -- https://scryfall.com/card/tc20/21/ability-punchcard

That one's in there, listed as Soldier // Elemental. Sebi just has the wrong collector number info listed in the card note, but if you check its card page, it shows the correct artwork on the reverse side.

I took a look at the CSV and figured out the issue. Here's what a proper CSV is supposed to look like:

Count, Name                  , Edition              , Card Number[,etc]
4    , Young Wolf            , Dark Ascension       , 134
1    , Youthful Knight       , Stronghold           , 25
1    , "Yukora, the Prisoner", Betrayers of Kamigawa, 90

Notice how the only values that have quotation marks around them are ones with commas IN them, such as Yukora's name. In cases like Yukora, quotation marks are necessary for the parser to know which commas separate values versus which commas are part of the values. They "escape" the commas, to use programmer lingo.

But here's what yours looks like in a text editor (not Excel):

Count, Tradelist Count  ,  Name                    ,  Edition                  ,  Card Number
"4,"   ""              "," "Young Wolf"           "," "Dark Ascension"        "," "134"
"1,"   ""              "," "Youthful Knight"      "," "Stronghold"            "," "25"
"1,"   ""              "," "Yukora, the Prisoner" "," "Betrayers of Kamigawa" "," "90"

((Note that I've spaced everything out more so it's easier to see the issue.))

Notice how every single value is surrounded by quotation marks, and importantly, all the commas that are supposed to be separating values are instead surrounded by quotation marks and thus considered part of the value. This is why the Name column appears blank in the Deckbox error during import -- the value literally is blank, since there were no unescaped commas to help designate which column the name values were supposed to be in.

Now, the reason it doesn't look like that in Excel is because Excel is rendering the CSV content in a visually more meaningful way. So it removes all the extra quotation marks. But what you CAN observe in Excel is that everything is just in column A, instead of each value being in its own column.

So with all the under-the-hood background knowledge out of the way, a couple questions: Does DelverLens a) export a CSV directly, or b) just present you with a bunch of text that you have to copy-and-paste into a CSV file yourself? If it does a) and exports a CSV directly, have you tried importing using that file without ever opening and saving it in Excel? If b) and you have to save it as a CSV file yourself, then try saving it in a basic text editor like Notepad or something.

Basically, either DelverLens isn't giving you a useful export, or something in your process steps altered it to its current form. We need to figure out which so this doesn't happen to you in the future.

======================================

EDIT: So an easy fix within the already-created Excel file was to use the "Text to Columns" tool in the Data tab. I selected all of the values in column A, started the tool, chose "Delimited", under Delimiters unchecked Tab and checked Comma, left the Text Qualifier as the quotation mark, then pressed Finish. This separated all the values into individual columns, which can now import into DB.

However, just like in that other forum post you linked to, there were a bunch of mismatching edition names. I went ahead and helped you out by listing all of the ones you need to change and what to change them to.

Normal sets:

DELVERLENS NAME                           DROPBOX NAME
Commander 2011                            Commander
Duel Decks Anthology: Divine vs. Demonic  Duel Decks Anthology, Divine vs. Demonic
Duel Decks Anthology: Jace vs. Chandra    Duel Decks Anthology, Jace vs. Chandra
Foreign Black Border                      Foreign Black Bordered
Fourth Edition Foreign Black Border       Fourth Edition: Black Bordered
GRN Guild Kit                             Guilds of Ravnica Guild Kit
Intl. Collectors’ Edition                 International Collectors' Edition
Modern Masters Edition                    Modern Masters
Return to Ravnica Tokens*                 Extras: Return to Ravnica
Rivals Quick Start Set                    Introductory Two-Player Set
Summer Magic / Edgar                      Summer Magic
Time Spiral Timeshifted                   Time Spiral "Timeshifted"

* On this one, the card name also had to change by removing the word "token".

I recommmend double-checking all the ones marked as FBB, Summer Magic, Intro 2-Player, and Int'l Collectors. According to the guy from the other forum post, DelverLens has a harder time identifying those older cards, and all the ones he had that it marked as Summer Magic and the like ended up being normal versions of the card.

Promo sets:

CARD NAME             DELVERLENS SET NAME                DECKBOX SET NAME
Arbiter of the Ideal  Born of the Gods Promos            Prerelease Events
Temur War Shaman      Fate Reforged Promos               Intro Pack Alternate Art
Sin Collector         Friday Night Magic 2013            Friday Night Magic
Zameck Guildmage      Gatecrash Promos                   Magic Game Day Cards
Skarrg Goliath        Gatecrash Promos                   Launch Parties
Giant Growth          Junior Super Series                Super Series
Xathrid Gorgon        Magic 2013 Promos                  Prerelease Events
Jeering Instigator    Ugin's Fate                        Ugin's Fate Promos
Serra Angel           Wizards of the Coast Online Store  WotC Online Store
Sprouting Thrinax     Wizards Play Network 2008          WPN/Gateway
Master's Call         Wizards Play Network 2011          WPN/Gateway

Promos are the trickiest, because there is no standardized system for naming promo editions, nor even for grouping promos into editions. Notice how the DelverLens edition "Gatecrash Promos" turned into two different Deckbox editions, while two different DelverLens editions turned into the Deckbox edition "Prerelease Events". With promos, you just have to check them card-by-card on Deckbox. I'm not looking at all your cards, obviously, so double check that these Deckbox versions do indeed line up with what you own.

MAJOR UPDATE

I completely revamped the coding of the webpage to improve its usefulness. While it won't look much different, everything has been rewritten to use more browser-compatible code, as I know it broke on some browsers (such as all versions of Internet Explorer). I'm still working to improve the mobile experience, but it should at least WORK on modern browsers. Please let me know if you encounter something that doesn't seem to work.

I've also decided to streamline my process of adding new decks by no longer adding CSV download links to the original post in this thread and attempting to keep it up-to-date and organized. I will always post a new comment when a CSV is available, with direct links to the CSV. But otherwise, all CSVs must be accessed from the webpage (which is linked in the original post): bit.ly/MTGprecons (note that capitalization matters with Bitly links!).

Along the lines of cleaning up the forum, I went through and deleted a whole bunch of my comments that merely announced new CSVs. That information has been added to a changelog on the webpage for anyone that cares, but now this forum thread is shorter and more open to general discussion.

Ah, you're right! I hadn't tried adding it via the Add Cards widget. I just imported Gavi from a decklist CSV with the Oversized edition set, which works fine. You can also add the oversized version of Gavi by using the "Add from a list" option and setting the oversized edition as the default. Temp workaround till Sebi fixes the bug!

Not only is it not an available edition to select in the Add Cards widget, but opening up the Edit dialog of an Oversized Gavi shows the edition as "undefined"! I'm assuming fixing one will fix the other, but just mentioning for completeness' sake.

Oops! This is my fault. I used unboxing videos in order to add the token info to the MTG Wiki pages for the C20 decks. I personally added all the token info to the wiki for every deck except Ruthless Regiment. That one was submitted by another user, but since they utilized the same unboxing video channel, I just assumed they added the tokens correctly and I passed that same data on to Sebi. Apparently I'll need to double-check their work next time! (I just got done updating the wiki page accordingly.)

Sebi - Token #23 should be Human // Treasure instead of Soldier // Treasure. Since there's no other version of either of those token combinations on Deckbox, just changing the name in the database and updating the token artwork shouldn't affect anyone.

(Ideally, it should also become token #22 and moved before Soldier // Elemental, which would then be #23, if you don't think that would negatively affect anyone's inventory. I don't see how it would.)

Thank you!!

Hey Sebi! I was able to verify all of the C20 double-sided tokens.

There are two different versions each of Elementals, Insects, and Beasts, and there are 3 artwork variants for the Human Soldier. Also, those Human Soldiers, as well as one of the Beasts and a Kraken, are token faces from Ikoria rather than C20 (and thus bear the IKO set symbol). All of these details are noted in the list below:

1. Angel — {R} 3/1 Elemental (C20 #010)

2. Bird — Dinosaur Cat

3. {W} 4/4 Elemental (C20 #003) — Soldier

4. Soldier — Treasure

5. Spirit — {G} 1/1 Insect (C20 #013)

6. Spirit — Treasure

7. Bird Illusion — {G} 4/4 Beast (C20 #11)

8. Drake — Goblin Warrior

9. Drake — {U/R} 1/1 Insect (C20 #018)

10. Drake — Human Soldier (IKO #005)

11. Zombie — Human Soldier (IKO #003)

12. Zombie — Human Soldier (IKO #004)

13. Zombie — Human Soldier (IKO #005)

14. {R} 3/1 Elemental (C20 #010) — Kraken (IKO #006)

15. Hydra — {G} 3/3 Beast (IKO #010)

16. Saproling — Treasure

17. Snake — {G} 3/3 Beast (IKO #010)

For the ordering, in each case, I listed the token face with the lower collector # as the front face (though in the case of Ikoria tokens, they were always the back token). Then I ordered the set by their front faces.

Also, wanted to remind you to add the oversized C20 cards! 

I know you're wanting a reply from Sebi, and probably won't appreciate one from anyone else, especially a dissenting view. But I'll provide my 2 cents anyways, for the sake of general discussion, or "debate" as you say.

What did you want to add it to? Your inventory or a deck? Because if you're wanting to add it to your inventory, then the double-sided token being the only option is correct—that's the only card that physically exists.

Now, if you want to use it in your deck as simply an Angel, then you've already stated the solution! 

List Angel // Saproling tokens in your inventory (because that's what you actually own, regardless of how you sleeve them), then add it to your deck with a note explaining which face is currently being used in that deck.

This is no different than if you were to slip a Mountain into your Dimir Zombie deck to represent a Cavern of Souls you don't have yet—your Mountain doesn't suddenly become a Cavern of Souls simply because you're using it that way. You can sleeve a card any way you want, but it doesn't change the physical card you truly own. And that's what the Inventory (and Trades and the Marketplace) is designed to represent—your actual physical cards. You can't trade or sell/buy a single-sided Angel token from Planechase Anthology, because it doesn't exist. Neither can you own one. And the Inventory represents what you own, not how you sleeve it.

TL;DR — How you sleeve and how you use cards in decks is different than what the card actually is. And the tools on Deckbox need to reflect that difference.

So you're wanting Sebi to do extra work when he already has plenty to deal with and is sometimes delayed when adding new sets to the database as it is?

Here's the thing: You're pretty much the only user I ever saw asking for this edge case, whereas I saw many MANY users begging for the double-sided tokens (particularly from the Commander sets) to be added. Even considering that there might be a few more users who would agree with you, a nonstandard and inaccurate usage of an inventory system that a small subset of users wants, when they have a viable method of achieving their goals elsewise, is not significant enough of a justification for introducing inaccuracy and confusion into the database and marketplace.