.. image:: https://img.shields.io/coveralls/gwax/mtg_ssm.svg :target: https://coveralls.io/r/gwax/mtg_ssm
.. image:: https://github.com/gwax/mtg_ssm/actions/workflows/run-tests.yml/badge.svg?branch=trunk :target: https://github.com/gwax/mtg_ssm/actions/workflows/run-tests.yml
.. image:: https://github.com/gwax/mtg_ssm/actions/workflows/pre-commit.yml/badge.svg?branch=trunk :target: https://github.com/gwax/mtg_ssm/actions/workflows/pre-commit.yml
.. image:: https://img.shields.io/pypi/v/mtg-ssm.svg :target: https://pypi.python.org/pypi/mtg-ssm/
.. image:: https://img.shields.io/pypi/pyversions/mtg-ssm.svg :target: https://pypi.python.org/pypi/mtg-ssm/
.. image:: https://img.shields.io/pypi/dm/mtg-ssm.svg :target: https://pypi.python.org/pypi/mtg-ssm/
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.
.. _mtg-ssm: https://github.com/gwax/mtg_ssm
As a matter of convenience, you can store the created spreadsheet in Dropbox, Google Drive, or the like and access your collection from anywhere.
Please also check out my other major Magic: the Gathering project,
Mana Pool_; buying your cards there helps support my morale.
.. _Mana Pool: https://manapool.com
mtg-ssm is available on PyPI so, if you have python (>=3.6) and pip installed on your system, you should be able to get mtg-ssm by entering the following into a terminal:
.. code:: bash
pip3 install mtg_ssm
Updates can be performed by entering:
.. code:: bash
pip3 install -U mtg_ssm
You can verify installation from the terminal by running:
.. code:: bash
mtg-ssm --help
For first time use, you will want to create an empty spreadsheet with card data:
.. code:: bash
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:
.. code:: bash
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:
.. code:: bash
mtg-ssm create input_data.csv
Then modify the template to match your counts and import into your spreadsheet:
.. code:: bash
mtg-ssm merge collection.xlsx input_data.csv
Certain unicode characters (such as U+2605 ★) may not be mapped correctly on Windows systems, causing errors when mtg-ssm tries to map data from Scryfall. This can occur in Command Prompt, Powershell, or other terminal emulators that rely on the system region settings (Such as MSYS2 MinGW). The below steps should help to resolve this issue.
#NAME?
LibreOffice has a different format from Excel for handling cross-worksheet
cell references (`=LEA.A7` instead of Excel's standard `=LEA!A7`). If you
open a mtg_ssm spreadsheet in LibreOffice, by default you will see `#NAME?`
in all of your have references (counts of cards from other sets).
To fix this, you need to tell LibreOffice to use the "Excel A1" format for
calculating formulas.
Bring up options/preferences
**Tools -> Options**
or on Mac
**LibreOffice -> Preferences**
Then configure the format to Excel A1:
**LibreOffice Calc -> Formula -> Formula syntax = Excel A1**
Contributions
=============
Pull requests are welcome and contributions are greatly appreciated. If you
would like to contribute, please be sure that all tests and lint checks
pass. Also consider running `python -m tests.gen_testdata` to ensure that
everything is up to date and works.
Issues can be reported via GitHub.
Acknowledgments
===============
- `Wizards of the Coast`_: For making Magic: the Gathering and continuing
to support it. Off and on, it's been my favorite hobby since the
early '90s.
- `Scryfall`_: Scryfall is a fantastic resource for anyone trying to lookup
cards or build software on top of up to date Magic card information.
- `MTGJSON`_: MTGJSON is an amazing resource for anyone looking to build
tools around magic card data. Before Scryfall, MTGJSON was my primary
source for card data and, without it, mtg-ssm would have died long ago.
.. _Wizards of the Coast: http://magic.wizards.com
.. _Scryfall: https://scryfall.com
.. _MTGJSON: http://mtgjson.com
Changelog
=========
Development
-----------
- ...
2.6.9
-----
- Fix sorting of cards with collector number prefixes (primarily PLST).
2.6.1
-----
- Minor Scryfall data changes.
2.6.0
-----
- Fix a bunch of tests for scryfall data changes, which change a number of
promo set card assignments.
- Add "minigame" to scryfall set type.
- Improved scryfall caching performance and decreased cache folder size
by moving to requests-cache from manual caching.
- Huge scryfall read performance improvements by converting deserialization
and validation to msgspec (previously pydantic).
2.5.2
-----
- Add prEDH legality to models.
2.5.1
-----
- Modify write behavior to return lxml to optional.
2.5.0
-----
- Drop the "non-bulk" column from the All Sets page due to issues with
the calculation when accounting for foil/non-foil cards.
- Modify the xlsx writer to use TEXTJOIN and SUM to calculate haverefs. This
should make the sheets slightly easier to read and resolve an annoying
trailing comma in the other card reference cells.
- Improve xlsx write performance via openpyxl write_only mode. As a side
effect, we now require lxml to be installed.
2.4.4
-----
- Fix issue where a number of promo sets with different card number
systems were being merged into an inappropriate parent set.
2.4.1
-----
- Fix the calculation for non-bulk in all-sets sheet to now be based on
the price of a single card being >=$1.
2.4.0
-----
- Fix filtering of digital only cards
- Switch from inclusion to exclusion for set types
- Add exclusion of card layouts (to catch tokens in non-token sets)
- Add (optional, default) exclusion of non-English cards/sets
(e.g. Renaissance)
- Add (optional, default) merging of set promos into their respective
sets
- Add support for Scryfall data migrations
2.3.0
-----
- Add card prices and totals
2.2.5
-----
- Officially support Python 3.11
2.2.4
-----
- Fixes for Scryfall model changes
2.2.3
-----
- Fix xlsx haverefs for sets with codes that begin with numbers
2.2.1
-----
- Create temporary file in same folder as target to avoid cross-volume link
issues. This solves an issue with storing collection files in Google Drive
now that Google Drive uses a mounted virtual volume instead of mirroring
files to your local machine.
2.2.0
-----
- Build and release using GitHub Actions
- Switch over to pydantic for Scryfall data deserialization
- Bug fixes for newer sets that do not include a numeric component to ther
collector numbers.
2.1.3
-----
- Update models to match scryfall as of 2020-09-09
- Cache failures on model change fixes
2.1.1
-----
- Fix Scryfall data fetching on Windows.
- Update models to match scryfall as of 2020-02-08
2.1.0
-----
- Add support for filtering card data by set type
- For example, `mtg_ssm --set-types token,emblem create tokens.xlsx` to
create a spreadsheet for tracking tokens and emblems.
2.0.1
-----
- Updated models to match scryfall as of 2019-09-10
2.0.0
-----
- Switched from mtgjson to Scryfall as a data source
- Broke existing spreadsheets
- ``update`` will rebuild / upgrade existing sheets
- rebuild lookup doesn't work very well for basic lands, double check
your counts
- rebuild lookup may result in double counting for Flip / split / DFC
cards, double-check your counts
- a number of cards count not reliably be remapped and will raise
exceptions; if you have any copies of these cards, you will need
to remove them from your existing spreadsheet and re-add them
after the update
- promo cards are particularly hard hit as Scryfall and MTGJSON model
promo sets very differently.
- Dropped deckbox serializer
- Removed support for Python 3.4, 3.5
1.3.6
-----
- Removed support for Python 3.3
- Test and bug fixes
- Handle newer versions of mtgjson
1.3.5
-----
- Remove profiling code. If we care, we can invoke profiling with:
.. code:: sh
python -m cProfile -o mtg_ssm.prof mtg_ssm/ssm.py create collection.xlsx
- Fix wheel generation to only build py3 wheels.
1.3.4
-----
- Increase in verbosity when looking up cards by heuristics (instead of id).
1.3.3
-----
- Fixed support for Ae/Æ
- Increased verbosity when searching for cards with a mismatched id
- Performance improvements
- Add tests to catch potential missing card issues
1.3.2
-----
- Changed the backup file naming convention; date is now before extension
- Minor tweaks and performance enhancements
1.3.1
-----
- Fix bug where were were never actually reading set names from xlsx
files.
1.3.0
-----
- Complete rework of cli (see `--help` for details)
- cli is **NOT** the same; old commands will **NOT** work
- new global argument flags and dialect selection mechanisms
- create: create a new collection
- update: update an existing collection
- merge: merge multiple collections
- diff: get a diff of two collections
- Lots of under the hood changes and performance improvements
- Files are still compatible
1.2.4
-----
- Remove workarounds introduced in 1.2.3
1.2.3
-----
- Hack to work around missing "releaseDate" and "type" in MTGJSON 3.3.14
1.2.2
-----
- Add "All Cards" page with index of all cards in XlsxSerializer.
1.2.1
-----
- Add support for deckbox.org import/export.
- Backend improvements.
1.2.0
-----
- Complete rework of the serialization architecture.
- Rebuild of the manager cli.
- Incompatible CLI interface changes. See help for new usage information.
1.1.0
-----
- Complete rework of the data model storage. Drop sqlite based data models in
favor of custom classes and dict based indexes.
- Switch to accepting all versions of MTGJSON instead of bumping for every
release.
1.0.2
-----
- Version bump MTGJSON support.
1.0.1
-----
- Fixed some PyPI related issues.
1.0.0
-----
- Initial stable release.
GsMtgJson
---------
Before mtg-ssm, this tool lived as a Google Apps Script project called
`GsMtgJson`_. As Magic added more cards, eventually the script became
too slow to function inside the constraints of Google Apps Script and
Google Sheets.
.. _GsMtgJson: https://github.com/gwax/GsMtgJson
FAQs
A tool to manage Magic: the Gathering collection spreadsheets
We found that mtg-ssm demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Research
The Socket Research Team breaks down a malicious wrapper package that uses obfuscation to harvest credentials and exfiltrate sensitive data.
Research
Security News
Attackers used a malicious npm package typosquatting a popular ESLint plugin to steal sensitive data, execute commands, and exploit developer systems.
Security News
The Ultralytics' PyPI Package was compromised four times in one weekend through GitHub Actions cache poisoning and failure to rotate previously compromised API tokens.