www.Blackborder.com www.Blackborder.com www.Blackborder.com
www.Blackborder.com

Navigation

Small orders ship for just 60 cents!

RSS

Subscribe to Syndicate

Hot Products

Hot Buylist Offers

You are here

Building a Collection Database

5 posts / 0 new
Last post
Offline
Last seen: 2 years 2 days ago
Joined: 12/04/2012 - 06:07
Building a Collection Database

So it dawned on me that i need to organize my Magic collection so I know what I've got and how many. After some google work I found a site that allows you to download lists of each set as an Excel spreadsheet and my work began. So far I've only used core sets and block sets, I haven't touched on limited sets etc yet as I don't have any cards from any.

Would anyone be interested in me uploading a copy to a file share site for their own use? I'll also be updating it as new sets are released, starting with M2014 in a few days time.

5
Offline
Last seen: 2 years 2 days ago
Joined: 12/04/2012 - 06:07

Ok so now that the set list for M2014 is available I've updated and now uploaded the database on mediafire for those of you that would like a copy. Feel free to make your own changes or suggest changes for me to make and I'll upload new versions.

http://www.mediafire.com/download/10178vyo4pbqbpp/MTG_Collection_Checklist.xlsx 

0
Offline
Last seen: 2 years 2 days ago
Joined: 12/04/2012 - 06:07

Making some further tweets to the database with a total cards in collection count and playing with links to each cards gatherer page as well as a deck page for keeping a log of your deck/s. 

Anything anyone else can think of? 

0
Offline
Last seen: 2 years 2 days ago
Joined: 12/04/2012 - 06:07

I've ended up giving up on the card links as I can't find an easily repeatable method for creating the links and individual hyperlinks will take a couple life times.

I haven't gotten round to the Decks page yet but that shouldn't be too difficult to implement once I sit down to it.

For now its just the basics with card counts on each page and a total on the Home page.

I decided to give mediafire the flick and go with Skydrive https://skydrive.live.com/redir?resid=BC7DF22E09AC6956!200&authkey=!ACz6ZFVjLCAEIDY 

0
Offline
Last seen: 2 years 2 days ago
Joined: 12/04/2012 - 06:07

Ok so after spending a while trying to box Excel into submission I've given up on the Deck Page as a current impossibility. Now it's time to focus on catalogueing my collection now that I've finished organising and filing it all.

I'll post a copy of my collection for anyone to look at when I'm done.

0
All trademarks and copyrights are acknowledged and are the property of their respective owners. This website is not produced by Wizards of the Coast TM. As an Authorized Internet Retailer of Wizards of the Coast, adventuresON.com may only ship sealed Magic: the Gathering products within the United States. As an Authorized Internet Retailer of Wizards of the Coast, adventuresON.com cannot sell sealed Magic: the Gathering products business to business. Authorized Internet Retailer for Wizards of the Coast