Topic: Import from Delverlens

Hi Community
I am trying to import my ~17.000 card collection that I scanned with Delver lens, but it keeps giving me a ton of errors.
Does any one have a good idea on how to avoid all these errors?
It's mainly the "EDITION" error that I see, but I would really like to keep the edition info.
"Tried to attach a file as an example but it doesnt work sad "
But here is an example text:

Count,Tradelist Count,Name,Edition,Card Number,Condition,Language,Foil,Signed,Artist Proof,Altered Art,Misprint,Promo,Textless,My Price
1,"","Reliquary Tower","Friday Night Magic 2013","2","","","foil","","","","","","",""
5,"","Lightning Greaves","Commander 2011","253","","","","","","","","","",""


Thanks smile
[mtg][/mtg]

Kenneth

Last edited by Goddk (2019-12-02 22:03:40)

Re: Import from Delverlens

Hello, Kenneth!

Yeah, the most common issue is always mismatching edition names. You don't need to lose all the edition info; instead, you need to rename all the editions to Deckbox-compatible ones within the DelverLens exported file.

I'd be happy to fix it for you, but I'd need the DelverLens file. I'm not sure why you couldn't get a CSV file to attach to your post.  :\  I've done it before! Maybe try again -- and make sure you click the "Add File" button after choosing the file. If that doesn't work, then you could share it via a share link from a cloud storage service like Dropbox, Google Drive, etc.

Let me know -- I'd be glad to help!

Re: Import from Delverlens

Hi Meldon44
Thank you for your answer. Not sure how to rename within delver. If you can help that would be really nice. smile

Still says server unable to save the uploaded file.
Here is a link to the file:
https://1drv.ms/u/s!Apq_jxAvUKDggfJf9w8 … Q?e=82gsWH

Thanks smile
-Kenneth

Re: Import from Delverlens

Alright, so got it converted for ya, with as much accuracy as I could! Try importing the attached CSV (edit: encountered same server error as you were, so here's a link: https://www.dropbox.com/s/twk74lz6lbiv9 … d.csv?dl=0 FILE REMOVED FROM MY DROPBOX) and let me know if there's any issues. Note that importing from CSV will add these cards to whatever cards you already have listed on Deckbox, rather than replacing them. If this CSV is meant to be your entire inventory, then you'll first want to "Remove Everything" from your inventory page (under Tools).


Mismatched Editions

As discussed, this was by far the biggest group. Below are all the changes I had to make to get Deckbox to recognize the edition.

  • Magic 2014 => Magic 2014 Core Set

  • Modern Masters 2015 => Modern Masters 2015 Edition (same with MM2017)

  • Commander 2011 => Commander

  • Intl. Collectors’ Edition => International Collectors' Edition

  • Ugin's Fate => Ugin's Fate Promos

  • RNA Guild Kit => Ravnica Allegiance Guild Kit (same with GRN)

  • Time Spiral Timeshifted => Time Spiral "Timeshifted"

  • Duel Decks Anthology: ... => Duel Decks Anthology, ... (comma instead of colon)

  • Summer Magic / Edgar => Summer Magic

  • Foreign Black Border => Foreign Black Bordered

  • Friday Night Magic ____ => Friday Night Magic (i.e. no year designation)

  • Wizards Play Network ____ => WPN/Gateway (also no year)

  • Magazine Inserts => Media Inserts (one card: Fireball)

  • Khans of Tarkir Promos => Media Inserts (one card: Sultai Charm)

Note that I made these changes in the "card.csv" file that I downloaded from the shared folder you linked to. I didn't make any changes within the raw DelverLens file, since there's no way to change edition names within DelverLens itself. All these changes have to be made to the CSV after it's been exported.


Double-Faced Card Names

The other major group of changes was mismatching names from ISD, DKA, SOI, and EMN. It seems like every single DFC from those sets were listed by DelverLens with their back-face names instead of the primary names on the front of the cards. So I went through and changed them all.


Other Notes

You'll want to double check your FBB cards, since Deckbox divides these into two editions — Foreign Black Bordered and Fourth Edition: Black Bordered — whereas other services just lump them into a single FBB set. I'm unfamiliar with DelverLens' approach, but if any of yours are supposed to be 4th Black Bordered, they're currently listed as Revised Black Bordered in the attached CSV.

I changed the collector numbers for the alternate arts from Alliances, Homelands, and Fallen Empires to ensure you had the correct card listed on Deckbox. Annoyingly, Deckbox actually uses its own numbering system for old sets (before official collector numbers were printed on the cards), one which doesn't make much sense. For one thing, DB doesn't order the cards in WUBRG order as they should be, so that e.g. Insidious Bookworms (a black card) actually has a lower collector number than Arcane Denial (blue). That's because DB orders the colors alphabetically: Black, Blue, Green, Red, White (followed by Artifact, Land, then Multicolored last??? what?!). It also assigns separate numbers to each variant, rather than using the better system of a single number per each English name, followed by a letter for variants. For example, Insidious Bookworms should be 51a and 51b, but DB has them at 12 and 13.

Speaking of art variants, I checked the few basic lands you had, and most were fine, but I did need to change the Portal 2nd Age Plains from 153 to 162 to match the art you intended. (I also happened to notice that you have an Alpha Plains set to foil somehow. It doesn't affect the price displayed on Deckbox, but I figured I'd mention it anyways!)

Tenth Edition foils (which lack reminder text in favor of flavor text) aren't properly represented on Deckbox. You can select 10th Edition and set the card to foil, but it won't show the correct artwork. But since there's not more than one foil version of a given card, the missing artwork shouldn't affect anything.

And lastly, there were a few cards that simply can't translate to Deckbox, as follows:

1    Blaze              118†  Portal
1    Hand of Death      96†   Portal
1    Arborback Stomper  142†  Kaladesh
3    Wind Drake         70†   Kaladesh
2    Terror             24    Rivals Quick Start Set
1    Vampire Bats       25    Rivals Quick Start Set

Deckbox doesn't have an edition for the Rivals box set, and the Portal / Kaladesh cards are from beginner decks that feature more reminder text than the normal versions found in boosters.

Last edited by meldon44 (2020-02-13 08:18:59)

Re: Import from Delverlens

@meldon44
That fixed it.  smile
Imported everything instantly.
Will fix any problems with foil or the few missing editions when I run into them.
Thank you so much for helping me out here.
All the rares and mythics were added manually through deckbox earlier, so now I have my entire collection and can start building decks etc.

Your the man! cool

Re: Import from Delverlens

You're very welcome! Converting CSVs is one thing I'm actually good at, so I like to contribute to the community in that way any time I see someone needing help with that.

Also, I'm curious about something: I took a peek at your new inventory to see what rares and mythics you had, especially the high end ones, so I sorted your inventory by price and noticed that all the high end Summer Magic / Alpha / Beta / etc. cards were no longer in it from the converted CSV.  Are you just wanting to leave those ones off of Deckbox? Sorry for being nosy! I was just really surprised to see all those cool cards gone!

Last edited by meldon44 (2019-12-04 21:22:35)

Re: Import from Delverlens

When I imported the list I did the same thing.
I think delverlens must have scanned them wrong.
I went looking for them in my actual collection, and found one by one that they were (for the most part) simply revised, 4th edition etc. cards that Delverlens had scanned and assigned a wrong edition to.
So I removed them one by one. Everytime delverlens detects bright light it automaticly adds a "Plains" card from a random series aswell, so had to remove a lot of those. Thats why i had/didn't have most of all those cool old cards smile