TCG-to-Deckbox

Python script to convert TCGPlayer app's export file into the proper format for deckbox.org's import. Tested with python 3.10.12

Why this is useful

https://deckbox.org/ is a popular tool for cataloging one's Magic: the Gathering collection. Card entry can be tedious, which is why many users are turning to scanning apps, such as TCGplayer's card scanning app. However, the export format of TCGplayer's app is incompatible with deckbox.org's import format. This tool is designed to reformat the TCGplayer csv export into a valid deckbox csv import.

Additionally, this tool now contains some basic replacement logic based on how TCGPlayer and deckbox differ in their categorization of cards. The short version: TCG player likes to append things like (borderless), (showcase) etc to the cards, whereas deckbox just uses the collector number. There are two replacement types: generic, and manual. The generic ones are handled in code, doing things like stripping out parentheses. The specific ones are mostly handled via the replacements.config file, which lists a mapping of translated values .

How to use.

To use the CLI, provide the path to your TCGplayer csv file:

python3 tcg-to-deckbox.py "~/bin/sample_input.csv"

It will give you a new csv, named deckbox_import.csv in the directory from which the script was run.

As part of its process, the script will query https://scryfall.com to get a list of double-faced cards, as these can be tricky when it comes to matching with deckbox. Additionally, it grabs a list of buy-a-box cards, as those are categorized completely differently on the TCGPlayer scanner app. The script is configured to only download this once a week so as not to be excessive. If you have actually scanned any double faced cards, it does double check their name by querying deckbox.org directly.

Limitations

1. Card names - I found some card names that are just formatted differently between the two. I manually adjust these card names in my replacements file, however, this was limited to the cards I hit. Of particular note were the Throne of Eldraine Adventure cards, which only used the Creature's name. Another oddity was Tamiyo's journal, which could have different flavor text. If you hit any of these in your collection, you don't need to be a programmer to fix it, just add another entry in src/replacements.config and rerun the script. Be sure to let me know so I can add it here too!

2. Showcase and extended art cards - TCGplayer suffixes these with (Extended Art) or (Showcase). If the script finds these terms, it just deletes them. They're unnecessary as they have different collector's numbers.

3. Odd sets from Magic's history - I did my best here, but some of the older sets didn't quite line up. Some I just didn't have enough information on, some looked like categories of multiple sets, and some actually look like they map to multiple different sets in deckbox. If you hit some of these, manual correction is probably the best bet for now, but if you have a solution, feel free to share!

Contributing

Feel free to fork the project and submit suggested fixes