|
vartemis
|
 |
« on: November 18, 2005, 10:05:29 am » |
|
I was sitting in my room last night alphabetizing my collection (I was bored and there was nothing on tv, ok?) when I got to thinking about creating a database system for my collection.
Do any of you have any reccomendations on how to do this? Is magic suitcase a good program for getting raw data? I am looking to create something on my computer that I can just go to and see what I have, without having to go through my boxes to try and find it. I can also mark what decks my cards are in as well. I could also keep track of prices. It would also be useful to bring a list of my "unpopular" rares/uncommons with me. That way, if someone doesnt see what they are looking for in my trade binder, I can give em a list of what I have at home and take a mailing address with me.
j
|
|
|
|
|
Logged
|
|
|
|
BigMac
Full Members
Basic User
Posts: 553
|
|
« Reply #1 on: November 18, 2005, 10:29:07 am » |
|
I am unsure about any programs, but i would start by sorting them by series. Then by colour and then by alphabeth.
I have almost all cards and this system works for me as i always will find the cards i need unless they are in a pile on my desk. (I really need to clean that desk one of these days)
|
|
|
|
|
Logged
|
Ignorance is curable
Stupidity is forever
Member of team ISP
|
|
|
|
Dozer
|
|
« Reply #2 on: November 18, 2005, 12:26:15 pm » |
|
I think MWS offers some of the functionality you might be looking for, but I never use it for that, so I don't really know. The program itself is much more powerful than just MWSplay, but nobody I know actually uses MWS for anything else than playing. Check it out, though, it might work. Offhand, I can't think of another tool short of "real" database programs.
Dozer
/edit: MWS is Magic Workstation, obviously. Minor oversight on my part not to spell it out at least once...
|
|
|
|
« Last Edit: November 19, 2005, 11:11:50 am by Dozer »
|
Logged
|
a swashbuckling ninja Member of Team CAB, dozercat on MTGO MTG.com coverage reporter (Euro GPs) -- on hiatus, thanks to uni Associate Editor of www.planetmtg |
|
|
|
knickers
|
|
« Reply #3 on: November 18, 2005, 03:15:54 pm » |
|
I use to use Magic Workstation to keep track of my collection ...
From the worst Commons, to the best Rares ...
I haven't updated it in awhile though because it does get time consuming ...
|
|
|
|
|
Logged
|
If you don't write a book or go way off topic then its not a valid TMD post.
|
|
|
Matt
Post like a butterfly, Mod like a bee.
Adepts
Basic User
Posts: 2297
King of the Jews!
|
|
« Reply #4 on: November 18, 2005, 05:07:34 pm » |
|
essentialmagic.com can do this but it's really time consuming.
|
|
|
|
|
Logged
|
http://www.goodgamery.com/pmo/c025.GIF---------------------- SpenceForHire2k7: Its unessisary SpenceForHire2k7: only spelled right SpenceForHire2k7: <= world english teach evar ---------------------- noitcelfeRmaeT {Team Hindsight}
|
|
|
Tha Gunslinga
Full Members
Basic User
Posts: 1583
De-Errata Mystical Tutor!
|
|
« Reply #5 on: November 18, 2005, 06:22:56 pm » |
|
I just use Microsoft Works Database. I have a separate database for each binder, and I have fields for condition, number, language, foiliness, set, whether a card is decked, etc.
|
|
|
|
|
Logged
|
Don't tolerate splittin'
|
|
|
forests failed you
De Stijl
Adepts
Basic User
Posts: 2018
Venerable Saint
|
|
« Reply #6 on: November 18, 2005, 10:38:13 pm » |
|
I usually just accumulate junk and then sell it to Pete whenever I'm at an SCG power event. They take bulk stuff as well as bad rares, and they actually give a very fair price on that stuff. I'd rather have the cash or good cards, rather than try and find random people who are looking for Timesifters and Sway the Stars.
It is actually not worth the time and effort to sort out bad cards, it is just so much more practicle to bulk it off.
|
|
|
|
|
Logged
|
Grand Prix Boston 2012 Champion
Follow me on Twitter: @BrianDeMars1
|
|
|
ctthespian
Full Members
Basic User
Posts: 224
|
|
« Reply #7 on: November 19, 2005, 12:13:55 pm » |
|
MWS is great for keeping track of your collection. You just have to be mindful if you trade often to keep it updated.
I keep my colelction stored in a cabinet built to accomodate 1000ct boxes. The collection is sorted by color then set the alphabetically. I can find a card in under 20seconds.
|
|
|
|
|
Logged
|
Alpha Underground Sea = $200
Alpha Black Lotus = $1000
Knowing that I can build almost any deck in T1 and have it be black bordered. = Priceless
|
|
|
|
Dozer
|
|
« Reply #8 on: November 19, 2005, 01:41:53 pm » |
|
I can find a card in under 20seconds.
So can I, there's just no guarantee it'll be the one I'm looking for!  I just keep my smallish collection in some binders and boxes. I have just one shelf of cards, though, because I've always gone for quality more than quantity. That's fine by me, though. There is no need to accumulate 10,000 cards and then having to sort them. What forcefieldyou said sounds good, although you don't always find a place that buys cards by the pound. There's just too many cards noone ever needs... or wants. Dozer |
|
|
|
|
Logged
|
a swashbuckling ninja Member of Team CAB, dozercat on MTGO MTG.com coverage reporter (Euro GPs) -- on hiatus, thanks to uni Associate Editor of www.planetmtg |
|
|
Matt
Post like a butterfly, Mod like a bee.
Adepts
Basic User
Posts: 2297
King of the Jews!
|
|
« Reply #9 on: November 19, 2005, 03:28:16 pm » |
|
I sold off about 500 commons yesterday for $5. Mostly Ravnica and Darksteel. PLenty of good, playable stuff - I wouldn't rip anyone off!
That's how I keep my collection trim.
|
|
|
|
|
Logged
|
http://www.goodgamery.com/pmo/c025.GIF---------------------- SpenceForHire2k7: Its unessisary SpenceForHire2k7: only spelled right SpenceForHire2k7: <= world english teach evar ---------------------- noitcelfeRmaeT {Team Hindsight}
|
|
|
|
Lunar
|
|
« Reply #10 on: November 20, 2005, 03:12:42 pm » |
|
yeh, constantly unloading the chafe is a great way to keep things down to size...if I start accumulating a number of decent commons/uncommons that I already have a playset of (say dark rituals) ill go unload about 30-40 of them to get into a decent rare or two...there isnt too much of a need for 50 of a single card unless you are a dealer or its one of a FEW special cards you like to collect.
|
|
|
|
|
Logged
|
Dozer - "TMD is not a place where everyone can just post what was revealed to them in their latest wet dream"
Webster - "most of the deck is pimped, like my insane shirt, which exudes a level of pimpness only to be expressed as sublime."
|
|
|
|
vartemis
|
|
« Reply #11 on: November 20, 2005, 03:52:30 pm » |
|
http://www.a12c4magic.co.uk/free_downloads.phpI am trying out this site. I have slightly modified the database to include a foils section, a set section, and an "in deck" section. It seems to be working fairly well, except for the saviours set, which doesn't sort right for some reason, but I emailed them back and am awaiting a response. Every time a new set comes out, I can just go to the site and paste it at the bottom of the spreadsheet, and resort it into its proper place. j
|
|
|
|
|
Logged
|
|
|
|
|
cosineme
|
|
« Reply #12 on: November 21, 2005, 12:25:37 pm » |
|
excel is pretty good i heard...
especially since it was designed for this kind of endeavor.
who's pete? SCG pete hoefling (sp)?
|
|
|
|
|
Logged
|
Just moved from Ann Arbor to Chicago. Even had a chance to play a bit with some of the famed Ann Arbor players.
Help me find a magic store in downtown Chicago
AKA effang
|
|
|
Danzig
Basic User
Posts: 185
Coimhéad fearg fhear na foighde.
|
|
« Reply #13 on: November 22, 2005, 04:55:11 am » |
|
I use spreadsheet.
|
|
|
|
|
Logged
|
Team Broken - Waiting for Smmenen to return Dark Rituals since 2004.
|
|
|
|
