A tool to manage Magic: the Gathering collection spreadsheets.
mtg-ssm is a tool for creating/updating user-friendly spreadsheets with Magic: the Gathering collection information. The tool can also import/export data to/from these spreadsheets to other formats, such as CSV files.
As a matter of convenience, you can store the created spreadsheet in Dropbox, Google Drive, or the like and access your collection from anywhere.
mtg-ssm is available on PyPI so, if you have python (>=3.3) and pip installed on your system, you should be able to get mtg-ssm by entering the following into a terminal:
pip3 install mtg_ssm
Updates can be performed by entering:
pip3 install -U mtg_ssm
You can verify installation from the terminal by running:
For first time use, you will want to create an empty spreadsheet with card data:
mtg-ssm create collection.xlsx
In the future, when new sets are released, you will want to update your collection spreadsheet while keeping existing counts:
mtg-ssm update collection.xlsx
If you already have your cards in another collection store, you might want to import that collection into your card spreadsheet.
First create an input csv file:
mtg-ssm create input_data.csv
Then modify the template to match your counts and import into your spreadsheet:
mtg-ssm merge collection.xlsx input_data.csv
If you already have your cards entered into Deckbox, you can export a csv from deckbox and import the contents into a spreadsheet just as you might merge from an existing collection using the “deckbox” import format:
mtg-ssm --dialect csv deckbox merge collection.xlsx Inventory_username_2016.March.10.csv
Alternatively, if you have your collection in a spreadsheet already and would like to load your data into deckbox to check prices or share with other people, just go the other direction.
mtg-ssm --dialect csv deckbox merge inventory.csv collection.xlsx
MTG JSON, which we use for card data doesn’t always map 1-to-1 to cards in Deckbox. This means that data can lose granularity in going from one form to the other, or back. If you intend to use both native mtg-ssm spreadsheets and Deckbox, I encourage you to choose one to be authoritative and always export to the other; going back and forth is probably not a good idea.
The following conversion issues are known to exist:
Pull requests are welcome and contributions are greatly appreciated.
Issues can be reported via GitHub.
Remove profiling code. If we care, we can invoke profiling with:
python -m cProfile -o mtg_ssm.prof mtg_ssm/ssm.py create collection.xlsx
Fix wheel generation to only build py3 wheels.
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
|File Name & Checksum SHA256 Checksum Help||Version||File Type||Upload Date|
|mtg_ssm-1.3.5-py3-none-any.whl (23.2 kB) Copy SHA256 Checksum SHA256||py3||Wheel||May 28, 2017|
|mtg_ssm-1.3.5.tar.gz (15.9 kB) Copy SHA256 Checksum SHA256||–||Source||May 28, 2017|