You are Here:
Categorizing & Inventorying Your Collection

Author (Read 36060 times)

Categorizing & Inventorying Your Collection
« on: July 04, 2013, 01:40:45 AM »
 

kdklown

  • 52 Plus Joker Member
  • Discourse Veteran
  • *
  • 302
    Posts
  • Reputation: 16

  • Twitter:
Do you keep a database on a spreadsheet?
Do you write in a my little pony composition book?
Do you pay a pilot to skywrite it outside your house every morning?
Do you not care what you have?

And if you do track your collection, what information do you include?

Just looking for some general thoughts and ideas.
 

Re: How do you track your collection?
« Reply #1 on: July 04, 2013, 03:59:54 AM »
 

MrMollusk

  • Extraordinaire
  • *
  • 975
    Posts
  • Reputation: 23
  • I like birds.

  • Kickstarter:
I don't.

I'm not too pedantic as to record all my decks on paper. I have them organized into a few categories: Ellusionist, Theory 11, Dan & Dave, Kickstarter, Bee casino decks, Misc. Red + Blue pairs, standard bees & Bikes, Misc. manufacturers & special decks, and an assload of cards I don't have enough room for.

I keep them organized in empty brick boxes sideways. Like books.
I need like 10 more boxes, though.
( ͡° ͜ʖ ͡°)
 

Re: How do you track your collection?
« Reply #2 on: July 04, 2013, 04:33:32 AM »
 

Curt


  • 52 Plus Joker Member
  • Frequent Flyer
  • *
  • 780
    Posts
  • Reputation: 74

  • Facebook:
I have tried doing spreadsheets and more detailed ways but for me, the most effective and easiest way is just to keep a photo record on tumblr. It takes two minutes to take a picture once I receive the decks and looks clean and simple ( plus it can be show anywhere with an internet connection.
 

Re: How do you track your collection?
« Reply #3 on: July 04, 2013, 01:26:16 PM »
 

Collector

  • Discourse Deity
  • *
  • 532
    Posts
  • Reputation: 23
  • I can be ironic, but I never outrage anyone.

  • Facebook:

  • Tumblr:

  • Twitter:
... what information do you include?

To young collectors:
I advise to record spent money. Summarize those costs in the end of each month. Than summarize them all in the end of each year (Christmas period). You will be able to compare those annual costs with prices of goods available at a discount during each Christmas period. It will help to be picky ... ;)
« Last Edit: July 06, 2013, 11:58:01 AM by Collector »


------------------------------------------------------------------------------------------------------------------------------------------------------
"Life consists not in holding good cards, but in collecting beautiful ones" ~ PlayingCardCollector.net
 

Re: How do you track your collection?
« Reply #4 on: July 04, 2013, 06:06:26 PM »
 

kdklown

  • 52 Plus Joker Member
  • Discourse Veteran
  • *
  • 302
    Posts
  • Reputation: 16

  • Twitter:
... what information do you include?

It will help to be picky much better than your posting about such necessity on forums  ;)

Thanks for the input, Collector.  You will, however, have to translate this sentence into English for me. 
 

Re: How do you track your collection?
« Reply #5 on: July 04, 2013, 10:57:03 PM »
 

phantom1412

  • Jack of Diamonds
  • *
  • 1,887
    Posts
  • Reputation: 78

  • Facebook:

  • Twitter:
I use excel to keep informations eg. the deck's designers or releasers, released date, initial price, where did I buy, how much I paid for, marketing price. and how many decks I have, both sealed and opened numbers.

And I use another iphone app to track down my payment about decks, and magic.
 

Re: How do you track your collection?
« Reply #6 on: July 05, 2013, 01:09:31 PM »
 

ruicorreia

  • Elite Member
  • *
  • 152
    Posts
  • Reputation: 17

  • Facebook:
In my case, because I store my collection in brick boxes, I organize the decks by producer (T11, Ellusionist, Kickstarters...) and I have a spreadsheet that tells me which decks I have and in which box he's in.
Organizing that for the first time can take some time but I've liked it. But then it's rather easy to keep your collection organized.
As additional info, I keep a record if the deck is sealed, or signed or printed in Ohio.
« Last Edit: July 05, 2013, 01:10:10 PM by ruicorreia »
Enthusiast collector
 

Re: How do you track your collection?
« Reply #7 on: July 05, 2013, 03:29:19 PM »
 

PrincessTrouble

  • 52 Plus Joker Member
  • Haven Citizen
  • *
  • 1,255
    Posts
  • Reputation: 23

  • Facebook:

  • Kickstarter:

  • Twitter:
I track my collection on a Pinterest board.
 

Re: How do you track your collection?
« Reply #8 on: July 05, 2013, 04:16:16 PM »
 

kdklown

  • 52 Plus Joker Member
  • Discourse Veteran
  • *
  • 302
    Posts
  • Reputation: 16

  • Twitter:
Great feedback gang!  I think I'm digging the Tumblr Idea from Curt. 
 

Re: How do you track your collection?
« Reply #9 on: July 06, 2013, 03:05:55 AM »
 

Don Boyer

  • VP/Dir. Club Forum/DAC Chair, 52 Plus Joker
  • Administrator
  • Forum Sentinel
  • *
  • 19,161
    Posts
  • Reputation: 415
  • Pick a card, any card...no, not THAT card!

  • Facebook:
... what information do you include?

It will help to be picky much better than your posting about such necessity on forums  ;)

Thanks for the input, Collector.  You will, however, have to translate this sentence into English for me.

He's saying that if you're more picky about what you buy, there's less to track in the first place!  I'll be writing a book on "Collector-to-English" soon, so I know these things...  :))

I've tried a spreadsheet.  Never got far.  Now I just keep them organized in a shelving unit for the open decks, and giant sports-card collector boxes for sealed decks.  Best guess is over 900 sealed, over 700 opened, and over 200 magic decks of different kinds (over 50 are stripper decks).
Card Illusionist, NYC Area
Playing Card Design & Development Consultant
Deck Tailoring: Custom Alterations for Magicians and Card Mechanics
Services for Hire - http://thedecktailor.com/
Pre-Made Decks for Sale - http://donboyermagic.com/
 

Re: How do you track your collection?
« Reply #10 on: July 06, 2013, 03:32:55 AM »
 

verloren

  • Forum Regular
  • *
  • 78
    Posts
  • Reputation: 2
Excel for now.

I might end up doing something with Microsoft Access later this month.
 

Re: How do you track your collection?
« Reply #11 on: July 06, 2013, 12:29:24 PM »
 

Collector

  • Discourse Deity
  • *
  • 532
    Posts
  • Reputation: 23
  • I can be ironic, but I never outrage anyone.

  • Facebook:

  • Tumblr:

  • Twitter:

Thanks for the input, Collector.  You will, however, have to translate this sentence into English for me.

Easily. Be picky instead of saying how picky you should be.

I use excel to keep informations eg. the deck's designers or releasers, released date, initial price, where did I buy, how much I paid for, marketing price. and how many decks I have, both sealed and opened numbers.

And I use another iphone app to track down my payment about decks, and magic.

This is a professional approach.


------------------------------------------------------------------------------------------------------------------------------------------------------
"Life consists not in holding good cards, but in collecting beautiful ones" ~ PlayingCardCollector.net
 

Categorizing your collection
« Reply #12 on: October 16, 2013, 09:34:06 AM »
 

Anthony

  • 52 Plus Joker Member
  • Haven Citizen
  • *
  • 1,150
    Posts
  • Reputation: 140
  • Growing old is Mandatory, Growing up is optional

  • Facebook:

  • Twitter:
Just curious how or if you categorize your collection?

Is it a Custom, Non-Custom, Standard type of thing or more of a Bicycle, T11, D&D kind of list? Do you think one would be better than the other? I have a database for my Zippo's and want to add the playing card info as well, I'm just going back and forth on how best to separate these entries......or maybe we go Alphabetical and call it a day, lol

Thanks for your input  ;)
 

Re: Categorizing your collection
« Reply #13 on: October 16, 2013, 10:47:56 AM »
 

Sovereign

  • True Member
  • *
  • 70
    Posts
  • Reputation: 14
Just make a spreadsheet with fields for each option, then depending on your mood you could sort them alphabetically, date order, custom/semi/etc, or by manufacturer. Problem solved.

Phill
 

Re: Categorizing your collection
« Reply #14 on: October 16, 2013, 08:31:30 PM »
 

Don Boyer

  • VP/Dir. Club Forum/DAC Chair, 52 Plus Joker
  • Administrator
  • Forum Sentinel
  • *
  • 19,161
    Posts
  • Reputation: 415
  • Pick a card, any card...no, not THAT card!

  • Facebook:
I'd be interested in seeing that spreadsheet - I'm working on the issue of categorizing custom decks now.  There's many issues to take into account in terms of versions, print runs, etc. - I'm trying to strip it down to the minimum if possible.
Card Illusionist, NYC Area
Playing Card Design & Development Consultant
Deck Tailoring: Custom Alterations for Magicians and Card Mechanics
Services for Hire - http://thedecktailor.com/
Pre-Made Decks for Sale - http://donboyermagic.com/
 

Re: Categorizing your collection
« Reply #15 on: October 16, 2013, 09:07:02 PM »
 

Anthony

  • 52 Plus Joker Member
  • Haven Citizen
  • *
  • 1,150
    Posts
  • Reputation: 140
  • Growing old is Mandatory, Growing up is optional

  • Facebook:

  • Twitter:
Maybe I asked the question the wrong way. The spreadsheet isn't the real issue, you can make that do whatever you like, the information on the sheet I guess is what I'm interested in. Like you said Don, there are a lot of things to consider, but it depends on what information is important to you. That's kind of where I'm kind of struggling.

Don if you told me, I want "This" information available in a spread sheet I could build it, I'm just not sure what information to use.
 

Re: Categorizing your collection
« Reply #16 on: October 16, 2013, 10:14:24 PM »
 

Don Boyer

  • VP/Dir. Club Forum/DAC Chair, 52 Plus Joker
  • Administrator
  • Forum Sentinel
  • *
  • 19,161
    Posts
  • Reputation: 415
  • Pick a card, any card...no, not THAT card!

  • Facebook:
Maybe I asked the question the wrong way. The spreadsheet isn't the real issue, you can make that do whatever you like, the information on the sheet I guess is what I'm interested in. Like you said Don, there are a lot of things to consider, but it depends on what information is important to you. That's kind of where I'm kind of struggling.

Don if you told me, I want "This" information available in a spread sheet I could build it, I'm just not sure what information to use.

Consider all the different, important features of a deck of playing cards.  Seals, tuck boxes, the cards themselves.  Finishes, stocks.  Embossing, debossing, foil.  Metallic ink, organic ink.  Level of customization.  Type of cellophane seal, or the absence of cellophane altogether.  Designer, printer, producer, year of manufacture, plant of manufacture, size of print run, number of print runs, number of versions and variants with descriptions.  Images of the box and cards.  Each one of these elements represents at least one if not several possible variables one would take into account for a complete listing of a single deck of custom playing cards - and you need to determine which are significant enough for you to take into account for your own collection, not to mention that a collector will want to list quantities and condition, opened or sealed (or opened but unused).  But if you were making a general reference containing information about custom decks in general, that's where insanity lies...
Card Illusionist, NYC Area
Playing Card Design & Development Consultant
Deck Tailoring: Custom Alterations for Magicians and Card Mechanics
Services for Hire - http://thedecktailor.com/
Pre-Made Decks for Sale - http://donboyermagic.com/
 

Re: Categorizing your collection
« Reply #17 on: October 17, 2013, 01:13:40 AM »
 

Rob Wright

  • 52 Plus Joker Member
  • Aficionado
  • *
  • 1,363
    Posts
  • Reputation: 98

  • Kickstarter:
I think categorizing could be as easy or hard as you want it to be. If you wanted to include all the parameters Don listed. Then you could have 1 deck that is on 15-20 different list. The easiest would be just a simple alphabetical order. That would work great if you just need a list so you don't by a duplicate, or have a small collection. It just depends on what you expect to get out of it. If you have a collection the size of Don's, then you would need something a little more detailed. I would imagine in Don's case. It's more about categorizing for storage/use purposes.
For someone starting out, I think a list of wanted decks may be more important- Decks I must have, Decks I would really like to have(but only if I can get a good deal), Decks that are readily available(will by when I have some extra $) and so on.
Last night I stayed up late playing poker with Tarot cards. I got a full house and four people died.

 Steven Wright
http://neverforgotten.storenvy.com
Facebook- Never Forgotten Project

My Playing Card DB
 

Re: Categorizing your collection
« Reply #18 on: October 17, 2013, 01:21:33 AM »
 

kdklown

  • 52 Plus Joker Member
  • Discourse Veteran
  • *
  • 302
    Posts
  • Reputation: 16

  • Twitter:
Yup, you can put whatever you see fit.  Here are the columns on my spreadsheet...

Deck Name
Multiples
Production location
Date
Finish
Stock
Hyperlink to a review or Pictures of deck if no review is available
Maker/Designer
KickstarterDeck

I find this is enough info for me.  I could easily add a lot more or remove some if I wanted.  This is just what I find useful.
 

Re: Categorizing your collection
« Reply #19 on: October 17, 2013, 08:06:39 AM »
 

Anthony

  • 52 Plus Joker Member
  • Haven Citizen
  • *
  • 1,150
    Posts
  • Reputation: 140
  • Growing old is Mandatory, Growing up is optional

  • Facebook:

  • Twitter:
Ya I knew there were things I hadn't thought of and after reading Don's post I had to go breath into a paper bag for a while, lol

But seriously....I was looking for some "Basics" to go by and you guys filled that request, I thank you. I think kd's list is pretty good for what I was thinking.

Thanks!

....when I have too much time, this is what happens (Ignore the info, it was just filler)  ;)
https://lh5.googleusercontent.com/-yB8l5vlFQE0/Ul_QroQn34I/AAAAAAAAATc/ZJydWAmBZYo/w1305-h817-no/Card+Sheet.jpg
« Last Edit: October 17, 2013, 08:07:36 AM by Sparkz »
 

Re: Categorizing your collection
« Reply #20 on: October 17, 2013, 11:31:57 PM »
 

Anthony

  • 52 Plus Joker Member
  • Haven Citizen
  • *
  • 1,150
    Posts
  • Reputation: 140
  • Growing old is Mandatory, Growing up is optional

  • Facebook:

  • Twitter:
So I came up with a spreadsheet thanks to the info you guys offered up. If anyone likes it and would like the file just shoot me a PM and I'll be more than happy to send it to you.

The sheet consist of the following information:
Deck Name
Finish
Stock
Production Date
Production Location
Printing (1st, 2nd, etc...)
Version
Print Run
Metallic Ink
Embossed/Debossed
Foil Stamping
Seal
Maker/Designer
Kickstarter
Price Per Deck
On Order
Open
Sealed
Total Decks
Links

Obviously you can edit the fields or formulas if you like, just thought I would share  ;)
« Last Edit: October 17, 2013, 11:32:37 PM by Sparkz »
 

playing cards collector database of spreadsheet available?
« Reply #21 on: July 09, 2014, 01:14:14 PM »
 

jderouen

  • Newcomer
  • *
  • 3
    Posts
  • Reputation: 0
I'm starting to build a pretty big collection, as was curious: is there some sort of database or spreadsheet out there to help you keep track of your collection? I've searched but can't find anything. Of course, I can put together a spreadsheet in Excel, but didn't want to duplicate effort if something already existed. Thank you!
 

Re: playing cards collector database of spreadsheet available?
« Reply #22 on: July 09, 2014, 01:47:28 PM »
 

ecNate

  • 52 Plus Joker Member
  • Discourse Veteran
  • *
  • 253
    Posts
  • Reputation: 16

  • Kickstarter:
This has/had a lot of potential, but is still pretty much in beta and on/off development.  http://playingcarddb.com/
 

Re: playing cards collector database of spreadsheet available?
« Reply #23 on: July 09, 2014, 03:15:16 PM »
 

Anthony

  • 52 Plus Joker Member
  • Haven Citizen
  • *
  • 1,150
    Posts
  • Reputation: 140
  • Growing old is Mandatory, Growing up is optional

  • Facebook:

  • Twitter:
I'm starting to build a pretty big collection, as was curious: is there some sort of database or spreadsheet out there to help you keep track of your collection? I've searched but can't find anything. Of course, I can put together a spreadsheet in Excel, but didn't want to duplicate effort if something already existed. Thank you!

I have a spreadsheet I use for  my collection, I would be more than happy to share it. I'll send it to you this eveing, i"m currentley at work  ;)
« Last Edit: July 09, 2014, 03:15:41 PM by Sparkz »
 

Re: playing cards collector database of spreadsheet available?
« Reply #24 on: July 09, 2014, 04:04:09 PM »
 

ecNate

  • 52 Plus Joker Member
  • Discourse Veteran
  • *
  • 253
    Posts
  • Reputation: 16

  • Kickstarter:
Sparkz, can you also send to me?

Better yet, maybe we can start a shared google doc and allow multiple people to edit to make it a community source that you can then import/reference in your own private sheet.  With your permission I'm willing to take the lead on that if you don't have the time and could maybe insert some controls, automation and process around it.
 

Re: playing cards collector database of spreadsheet available?
« Reply #25 on: July 09, 2014, 05:34:03 PM »
 

jderouen

  • Newcomer
  • *
  • 3
    Posts
  • Reputation: 0
I would love to see it, thank you so much!!
 

Re: playing cards collector database of spreadsheet available?
« Reply #26 on: July 09, 2014, 08:47:59 PM »
 

Josh Blackmon

  • Forum Regular
  • *
  • 86
    Posts
  • Reputation: 7
  • L-I-V-I-N

  • Facebook:
This is just a side note for this thread, but it seems as good a place as any to mention it. There is a website for sports card collecting called Zistle (www.zistle.com) which I think sets a standard going forward for community driven, collection oriented databases. On the site, a collector can find sets, subsets, and photos of each individual card and add it to their collection online to eventually see analytics, variations, and reports of their entire collection. If the specific cards you are looking for aren't there, you can add them and their accompanying pictures yourself to be used by the community. Truly groundbreaking and free with only the advanced featured costing anything. If you have a sports card collection you are doing yourself a favor by checking it out. Just go check it out in general. Maybe it will inspire someone with more programming knowledge than me to adapt the system to playing card purposes.
Josh Blackmon
 

Re: playing cards collector database of spreadsheet available?
« Reply #27 on: July 09, 2014, 10:38:11 PM »
 

Anthony

  • 52 Plus Joker Member
  • Haven Citizen
  • *
  • 1,150
    Posts
  • Reputation: 140
  • Growing old is Mandatory, Growing up is optional

  • Facebook:

  • Twitter:
Well here's an image of the spreadsheet, if your interested you can email me and I'll be more then happy to send you the file  ;)
 

Re: playing cards collector database of spreadsheet available?
« Reply #28 on: July 09, 2014, 11:10:21 PM »
 

jderouen

  • Newcomer
  • *
  • 3
    Posts
  • Reputation: 0
PM sent, thanks so much!
 

Re: playing cards collector database of spreadsheet available?
« Reply #29 on: July 10, 2014, 12:42:12 AM »
 

DarkDerp

  • Discourse Veteran
  • *
  • 262
    Posts
  • Reputation: 36
http://en.wikicollecting.org/ this might be of some interest.
I like to call paper coatings a finish. It makes Don happy.
 

Re: playing cards collector database of spreadsheet available?
« Reply #30 on: July 10, 2014, 01:14:39 AM »
 

PurpleIce

  • 52 Plus Joker Member
  • Discourse Royalty
  • *
  • 485
    Posts
  • Reputation: 23
We actually have a lot of similar topics floating around here.

http://www.playingcardforum.com/playing-card-plethora/how-do-you-track-your-collection/msg75062/#msg75062
http://www.playingcardforum.com/playing-card-plethora/categorizing-your-collection/msg81369/#msg81369

Can we just put them all together? I'm sure there is more because i remember seeing them..just cant find it.

Sparkz, can you also send to me?

Better yet, maybe we can start a shared google doc and allow multiple people to edit to make it a community source that you can then import/reference in your own private sheet.  With your permission I'm willing to take the lead on that if you don't have the time and could maybe insert some controls, automation and process around it.

I'm actually all for this idea. We can create a spread sheet with all the information in it. All members can view it to update their own personal list but only certain few can update it (For accuracy sake). I believe many of us have our own lists, but not necessarily the full information of each deck in our collection from card finish to print date to print run and much more. This will be a good idea and members can contribute to any information they have when they see a "blank" or a mistake in the excel sheet.
 

Re: Categorizing & Inventorying Your Collection
« Reply #31 on: July 11, 2014, 03:45:21 PM »
 

Don Boyer

  • VP/Dir. Club Forum/DAC Chair, 52 Plus Joker
  • Administrator
  • Forum Sentinel
  • *
  • 19,161
    Posts
  • Reputation: 415
  • Pick a card, any card...no, not THAT card!

  • Facebook:
I've merged the topics and moved them to The Source - Card Collecting 101.  THIS is the category for all the best, most basic core elements of collecting.

No, you can't start a topic here, only an admin can, but you can post here.  If you start a topic elsewhere that is really THAT important to collecting cards, the staff puts it here.

http://en.wikicollecting.org/ this might be of some interest.

I tried this site, but they have so little information about playing cards and no information about tracking one's collection.  They mentioned the IPCS and WOPC, both in the UK.
Card Illusionist, NYC Area
Playing Card Design & Development Consultant
Deck Tailoring: Custom Alterations for Magicians and Card Mechanics
Services for Hire - http://thedecktailor.com/
Pre-Made Decks for Sale - http://donboyermagic.com/
 

Re: Categorizing & Inventorying Your Collection
« Reply #32 on: July 21, 2014, 11:11:06 AM »
 

aldazar

  • 52 Plus Joker Member
  • Elite Member
  • *
  • 149
    Posts
  • Reputation: 13
I've been meaning to track my collection via Excel since I started, but never quite got round to it...

One problem I have which I haven't figured out yet - anyone have a good/neat way to get picture(s) of the decks into a spreadsheet?
 

Re: Categorizing & Inventorying Your Collection
« Reply #33 on: July 21, 2014, 12:44:00 PM »
 

Don Boyer

  • VP/Dir. Club Forum/DAC Chair, 52 Plus Joker
  • Administrator
  • Forum Sentinel
  • *
  • 19,161
    Posts
  • Reputation: 415
  • Pick a card, any card...no, not THAT card!

  • Facebook:
I've been meaning to track my collection via Excel since I started, but never quite got round to it...

One problem I have which I haven't figured out yet - anyone have a good/neat way to get picture(s) of the decks into a spreadsheet?

Try some simple database software.  Bento for Mac is good, as is the "parent" program, FileMaker.  I found it an order of magnitude easier to use FileMaker rather than Microsoft Access for Windows.
Card Illusionist, NYC Area
Playing Card Design & Development Consultant
Deck Tailoring: Custom Alterations for Magicians and Card Mechanics
Services for Hire - http://thedecktailor.com/
Pre-Made Decks for Sale - http://donboyermagic.com/
 

Re: Categorizing & Inventorying Your Collection
« Reply #34 on: August 10, 2014, 09:36:17 PM »
 

ecNate

  • 52 Plus Joker Member
  • Discourse Veteran
  • *
  • 253
    Posts
  • Reputation: 16

  • Kickstarter:
I took the file that Sparkz sent me (Thanks!!!) that only contains the data, formatted it a bit for Google Docs and made a few minor updates, including adding columns for URLs.  This is a shared file that anybody can view and I will give any RESPONSIBLE party access to edit/update on request (just sent PM).  There are versions stored so we can go back if things get really messed up. View the spreadsheet.  My original plan was to use this as a way for myself and others to reference from a Google Site app or another Google Spreadsheet and 'add' a reference to any entry, thus creating a cobbled collecting app.  If the content took off then perhaps we could use the backend data for a future better solution. 

This may still be an option, but the PlayingCardDB.com that I mentioned before just had a MAJOR update today that lets people finally share their collections and the critical bug fixes taken care of.  It still has a way to go and the developer hasn't had time for a while before this (risk of slow future development), but I'm hopeful this will be everybody's go to solution going forward. For an example of what your collection can look like you can see mine here..  There's a few quirks and minor bugs, including you have to add to your collection from each brand listing (can at least do multiples at once - feature to add from individual listing being worked).  It's also missing some key fields and needs some garbage cleanup, but it has almost 800 decks added so far (mostly modern) and many with tuck scans.

I decided to go ahead and share this shared spreadsheet anyhow in case others wanted to contribute or build off it on their own.  Because the PlayingCardDB site is still early it doesn't have all the data attributes/fields listed in the spreadsheet so updating both in the short term may be a good idea.  I know I'll at least keep both updated as I add to my collection.
 

Re: Categorizing & Inventorying Your Collection
« Reply #35 on: September 07, 2014, 09:21:00 PM »
 

AndreCamp

  • Newcomer
  • *
  • 4
    Posts
  • Reputation: 1
Obv i'm using Excel, and it works well...
 

Re: Categorizing & Inventorying Your Collection
« Reply #36 on: September 08, 2014, 09:33:54 AM »
 

52plusjoker

  • Frequent Flyer
  • *
  • 887
    Posts
  • Reputation: 49
I suspect there are hundreds of programs that can deal with something that is, in the general scheme of things, a relatively simple application. I started about 20 odd years ago with IBM FileMaster, moved on to a more complicated DB program [name escapes me now] and when Microsoft came out with ACCESS database I switched to it as I also used it extensively at work. Access has become easier to use, especially in the context of adding card pictures to each record and it suits me fine. However if you don't have a more than basic suite of Office, it gets expensive.
Tom Dawson
52 Plus Joker Playing Card Collectors Club
 

Re: Categorizing & Inventorying Your Collection
« Reply #37 on: September 08, 2014, 09:47:05 PM »
 

Don Boyer

  • VP/Dir. Club Forum/DAC Chair, 52 Plus Joker
  • Administrator
  • Forum Sentinel
  • *
  • 19,161
    Posts
  • Reputation: 415
  • Pick a card, any card...no, not THAT card!

  • Facebook:
I suspect there are hundreds of programs that can deal with something that is, in the general scheme of things, a relatively simple application. I started about 20 odd years ago with IBM FileMaster, moved on to a more complicated DB program [name escapes me now] and when Microsoft came out with ACCESS database I switched to it as I also used it extensively at work. Access has become easier to use, especially in the context of adding card pictures to each record and it suits me fine. However if you don't have a more than basic suite of Office, it gets expensive.

On the Mac, I used to inventory a card game collection using FileMaker Pro - this was in the days before Mac OS X and Intel chips.  I found it extremely easy to use.  I've since tried the home version, Bento - it's not as flexible, but it's very simple.  It's also cheaper and has an iOS app as well.

Databases are the way to go.  You could use spreadsheets, even create calculations that cross to multiple sheets (on Excel, at the least, haven't tried it on Numbers yet), but eventually you'll reach a point where it's too much of a jury-rig, depending on the complexity of the data you're using.

Of course, if all you want is a simple list of "brand, maker, quantity", even Word is adequate for that...

Either way, MS Access for PC is a PAIN - I have to use it at work and I don't recommend it.
Card Illusionist, NYC Area
Playing Card Design & Development Consultant
Deck Tailoring: Custom Alterations for Magicians and Card Mechanics
Services for Hire - http://thedecktailor.com/
Pre-Made Decks for Sale - http://donboyermagic.com/
 

Re: Categorizing & Inventorying Your Collection
« Reply #38 on: September 14, 2014, 09:07:58 AM »
 

iDoctor

  • 52 Plus Joker Member
  • Junior Member
  • *
  • 32
    Posts
  • Reputation: 3
  • I'm card collector from Moscow, Russia.

  • Skype:

  • Twitter:
Yes, I do. I keep all my collection (about 600 decks) in Evernote. Quite comfortable, you may use any device to add a new item.
« Last Edit: October 20, 2014, 03:17:50 AM by iDoctor »
My card collection on PlayingCardDB http://playingcarddb.com/mycollection?u=6196
 

Re: Categorizing & Inventorying Your Collection
« Reply #39 on: September 15, 2014, 05:14:02 PM »
 

ecNate

  • 52 Plus Joker Member
  • Discourse Veteran
  • *
  • 253
    Posts
  • Reputation: 16

  • Kickstarter:
Yes, I do. I keep all my collection (about 300 decks) in Evernote. Quite comfortable, you may use any device to add a new item.

Do you list each deck as a separate note?  What do you include for details?  Do you have a basic template that you use each time?

I'm totally sold on the PlayingCardDatabase website as it also now has over 1,000 decks to pick from and add to your collection.  Here's my collection there: http://playingcarddb.com/mycollection?u=6134

Although I have some reservations of having it all outside of my control so I'll still keep updating my BGG entry and looking for other methods to manage the collection that I have full control over.  I also occasionally scrape the contents of my collection for historical and some kind of disaster recovery.
 

Re: Categorizing & Inventorying Your Collection
« Reply #40 on: September 16, 2014, 06:38:47 AM »
 

iDoctor

  • 52 Plus Joker Member
  • Junior Member
  • *
  • 32
    Posts
  • Reputation: 3
  • I'm card collector from Moscow, Russia.

  • Skype:

  • Twitter:
No, I don't. I keep them all in one note, it's much easier to manage. At the same time, it doesn't allow to contain all necessary info(.
I didn't know about the database mentioned in your post, it looks great. Is it easy in use? Probably I should try.
« Last Edit: October 10, 2014, 05:36:44 AM by iDoctor »
My card collection on PlayingCardDB http://playingcarddb.com/mycollection?u=6196
 

Re: Categorizing & Inventorying Your Collection
« Reply #41 on: September 16, 2014, 12:50:44 PM »
 

ecNate

  • 52 Plus Joker Member
  • Discourse Veteran
  • *
  • 253
    Posts
  • Reputation: 16

  • Kickstarter:
No, I don't. I keep them all in one note, it's much easier to manage. At the same time, it doesn't allow to contain all necessary info(.
I didn't know about the database mention in your post, it looks great. Is it easy in use? Probably I should try.

Just register and try it!   ;)

It's still pretty early, but it's been pretty functional for a while now.  As a new user you'll only have the option to add existing decks in the database to your collection (can't add new decks to the database), but with over 1,000 decks most of yours should be represented.  PM me if you need a new one added so you can add to your collection.
 

Re: Categorizing & Inventorying Your Collection
« Reply #42 on: September 16, 2014, 03:20:12 PM »
 

iDoctor

  • 52 Plus Joker Member
  • Junior Member
  • *
  • 32
    Posts
  • Reputation: 3
  • I'm card collector from Moscow, Russia.

  • Skype:

  • Twitter:
Ok, I've registered and begun  ;)
My card collection on PlayingCardDB http://playingcarddb.com/mycollection?u=6196
 

Re: Categorizing & Inventorying Your Collection
« Reply #43 on: September 19, 2014, 01:32:54 AM »
 

iDoctor

  • 52 Plus Joker Member
  • Junior Member
  • *
  • 32
    Posts
  • Reputation: 3
  • I'm card collector from Moscow, Russia.

  • Skype:

  • Twitter:
[quote author=ecNate link=topic=4832.msg103930#msg103930 date=1410886244

It's still pretty early, but it's been pretty functional for a while now.  As a new user you'll only have the option to add existing decks in the database to your collection (can't add new decks to the database), but with over 1,000 decks most of yours should be represented.  PM me if you need a new one added so you can add to your collection.
[/quote]

Wow, it's works great. And my collection looks not bad in the database   ;D
You were right, I really have some decks not presented in the database at the moment (including my favorite vintage Vegas decks). I PM you the list of them when complete the process.
At the same time, many of presented decks have no scans. Will you please let me know, either I may help you with these scans or not yet. If yes, please info me about the process. I'll be glad to assist.
« Last Edit: September 19, 2014, 01:37:54 AM by iDoctor »
My card collection on PlayingCardDB http://playingcarddb.com/mycollection?u=6196
 

Re: Categorizing & Inventorying Your Collection
« Reply #44 on: September 19, 2014, 12:53:50 PM »
 

ecNate

  • 52 Plus Joker Member
  • Discourse Veteran
  • *
  • 253
    Posts
  • Reputation: 16

  • Kickstarter:
Wow, it's works great. And my collection looks not bad in the database   ;D
You were right, I really have some decks not presented in the database at the moment (including my favorite vintage Vegas decks). I PM you the list of them when complete the process.
At the same time, many of presented decks have no scans. Will you please let me know, either I may help you with these scans or not yet. If yes, please info me about the process. I'll be glad to assist.

I would be willing to add a few for you, but if you have a bunch of decks then perhaps you should see if you can get access eventually. See here..  Since it's so new rhu is being cautious about who gets access to add/edit, etc, although as the site and code improves that should open up more easily.  Basically you get added if you can be trusted, whatever that means.  I think it may be related to your investment so having a large collection would mean you have a vested interested in not screwing things up.

Anyhow, I'm pretty sure that you can get access to add new decks and then at the same time that gives you ability to edit those decks and also add images to that deck.  I could be wrong about the details though.  Just ask for access from that link above and let me know what access you get and what that means so I can update the FAQ around access levels.
 

Re: Categorizing & Inventorying Your Collection
« Reply #45 on: September 21, 2014, 01:54:24 AM »
 

iDoctor

  • 52 Plus Joker Member
  • Junior Member
  • *
  • 32
    Posts
  • Reputation: 3
  • I'm card collector from Moscow, Russia.

  • Skype:

  • Twitter:
Hi, thanks.
I've contacted to rhu and have got the access. I've already added a couple of dozens scans from my personal database. So everithing is going on well.
Yours, iDoctor
My card collection on PlayingCardDB http://playingcarddb.com/mycollection?u=6196
 

Re: Categorizing & Inventorying Your Collection
« Reply #46 on: October 07, 2014, 09:47:26 AM »
 

iDoctor

  • 52 Plus Joker Member
  • Junior Member
  • *
  • 32
    Posts
  • Reputation: 3
  • I'm card collector from Moscow, Russia.

  • Skype:

  • Twitter:
Sparkz, the spreadsheet is really cool. Even too detailed for me at the moment..
These days I've spent all my free time adding my collection in the PlayingCardDB and trying to do something good for the DataBase itself. As this work is more or less completed, I'm going to investigate your spreadsheet. Thanks!
My card collection on PlayingCardDB http://playingcarddb.com/mycollection?u=6196
 

Re: Categorizing & Inventorying Your Collection
« Reply #47 on: October 07, 2014, 02:36:27 PM »
 

Anthony

  • 52 Plus Joker Member
  • Haven Citizen
  • *
  • 1,150
    Posts
  • Reputation: 140
  • Growing old is Mandatory, Growing up is optional

  • Facebook:

  • Twitter:
ah no worries, the spreadsheet was pre-PCDB.

The PCDB is actually a great option for those wanting to catolog their collection, Rhu and Nate have done a real nice job with it.  :)
« Last Edit: October 07, 2014, 02:37:34 PM by Anthony »
 

Re: Categorizing & Inventorying Your Collection
« Reply #48 on: October 07, 2014, 03:11:16 PM »
 

iDoctor

  • 52 Plus Joker Member
  • Junior Member
  • *
  • 32
    Posts
  • Reputation: 3
  • I'm card collector from Moscow, Russia.

  • Skype:

  • Twitter:
Yes, I absoluthely agree with you. Welldone! And it is improving every day!
« Last Edit: October 07, 2014, 03:18:37 PM by iDoctor »
My card collection on PlayingCardDB http://playingcarddb.com/mycollection?u=6196
 

Re: Categorizing & Inventorying Your Collection
« Reply #49 on: October 07, 2014, 03:32:51 PM »
 

ecNate

  • 52 Plus Joker Member
  • Discourse Veteran
  • *
  • 253
    Posts
  • Reputation: 16

  • Kickstarter:
The PCDB is actually a great option for those wanting to catolog their collection, Rhu and Nate have done a real nice job with it.  :)

Thanks, but I just help with feature suggestions, documentation and promotion.  Rhu is the sole coder and real worker behind it.  It's really come a long way and iDoctor has been contributing a TON since joining!  There's now almost 1,500 decks in the database!  :D
 

Re: Categorizing & Inventorying Your Collection
« Reply #50 on: November 04, 2014, 01:23:38 AM »
 

Rob Wright

  • 52 Plus Joker Member
  • Aficionado
  • *
  • 1,363
    Posts
  • Reputation: 98

  • Kickstarter:
So I spent a good part of my weekend categorizing my collection. I've only done most of my modern decks. I've probably have another 100 vintage and assorted promo/advertising decks. So far listed 484 Decks(254 different).


19 1/2 bricks in back + a 6 brick & 10 brick(almost full) collector boxes + another box full of decks.

........and in the mail today



...........and a few emails of pending deliveries!
Last night I stayed up late playing poker with Tarot cards. I got a full house and four people died.

 Steven Wright
http://neverforgotten.storenvy.com
Facebook- Never Forgotten Project

My Playing Card DB
 

Re: Categorizing & Inventorying Your Collection
« Reply #51 on: November 04, 2014, 06:53:40 AM »
 

Anthony

  • 52 Plus Joker Member
  • Haven Citizen
  • *
  • 1,150
    Posts
  • Reputation: 140
  • Growing old is Mandatory, Growing up is optional

  • Facebook:

  • Twitter:
I feel your pain Rob.........but isn't it fun  :D
 

Re: Categorizing & Inventorying Your Collection
« Reply #52 on: November 04, 2014, 02:01:38 PM »
 

Don Boyer

  • VP/Dir. Club Forum/DAC Chair, 52 Plus Joker
  • Administrator
  • Forum Sentinel
  • *
  • 19,161
    Posts
  • Reputation: 415
  • Pick a card, any card...no, not THAT card!

  • Facebook:
I feel your pain Rob.........but isn't it fun  :D

I'm a bit overdue to re-sort mine.  All 1,700+ decks...yeesh.
« Last Edit: November 04, 2014, 02:01:48 PM by Don Boyer »
Card Illusionist, NYC Area
Playing Card Design & Development Consultant
Deck Tailoring: Custom Alterations for Magicians and Card Mechanics
Services for Hire - http://thedecktailor.com/
Pre-Made Decks for Sale - http://donboyermagic.com/
 

Re: Categorizing & Inventorying Your Collection
« Reply #53 on: January 23, 2015, 08:04:21 AM »
 

Magasaki

  • 52 Plus Joker Member
  • Discourse Lover
  • *
  • 244
    Posts
  • Reputation: 9
Ok I mentioned this a while ago and I have finally had time to do some work on inventorying.

My plan was fairly simple, set up a site that I could use as an inventory and then scan the artwork from the cards in and begin to form a sort of online 'museum' of my personal collection. You may remember me discussing the legalities of scanning images into the site in the middle of last year.

So the site is up and built at www.magasaki.com but is very much in beta stage. It only has part of the collection up so far and far less completely scanned decks. However, it's providing a great place to store information I find on certain decks and keep a record of things I learn. There is also a small blog on the site I'll be updating with information as things change and grow.

Please have a browse if you get time and be as critical as you want - I won't take offence! I know the 'look' of the site is a bit lame at the minute so I need to work on that. When browsing the deck collection you'll notice that you can click on some images which will take you onto a page with more information and scans of the artwork. If you have any suggestions on improvements then please throw them my way. This year I'm mainly going to be working on gathering information so it might actually become a useful resource for people one day.

Check out some examples
http://www.magasaki.com/#!correspondances/c12yo
http://www.magasaki.com/#!les-montgolfieres/c1grj
http://www.magasaki.com/#!aves/cvve

I'll keep the link in my sig from now on and let you guys know if there are any significant updates.

Thanks

Tom

Collection and Blog - www.magasaki.com
Studio - www.designsharp.co.uk
Blog Facebook - www.facebook.com/magasakicards
Personal Facebook - www.facebook.com/tommajski
 

Re: Categorizing & Inventorying Your Collection
« Reply #54 on: September 29, 2016, 01:30:52 PM »
 

Crazy Gizmo

  • Junior Member
  • *
  • 16
    Posts
  • Reputation: 1
I use Google Photos its fast free n theres a comprehensive sreach that will find similar decks without making any tags for your photos.
You can organize them down even farther by creating albums of certain brands names Etc.
 

Re: Categorizing & Inventorying Your Collection
« Reply #55 on: September 30, 2016, 10:38:19 AM »
 

ecNate

  • 52 Plus Joker Member
  • Discourse Veteran
  • *
  • 253
    Posts
  • Reputation: 16

  • Kickstarter:
Since it's been a few years since PCDB was mentioned, I should mention for future reference and for the few that don't know about it:   Now called Portfolio52 since Alex Chin of Seasons Playing Cards took ownership/control, is my method to manage my inventory and also for many others.  With over 4,000 decks in the database, the 1,000+ members have a total of over 250,000 decks in their combined collections, it's certainly the most popular solution out there.

It includes deck scans and details for each deck, plus ways to categorize/view by artist, brand, manufacturer, publisher, etc.  One of the best features is the trade/wish lists and a match process to help you find decks you want.  Alex is also in the process of yet another major new version and revamp of the system which hopefully will be available in the coming months, fixing some lingering issues and a ton of new improvements.

http://www.portfolio52.com/
https://www.facebook.com/Portfolio52
 

Re: Categorizing & Inventorying Your Collection
« Reply #56 on: December 07, 2016, 01:17:44 PM »
 

akicer

  • Junior Member
  • *
  • 25
    Posts
  • Reputation: 3
I usually try to categorize my deck using both spreadsheet and labels on boxes I store the decks. I usually write what I have on the box... but it's getting harder and harder if I keep adding and removing decks form the boxes.

I must admit it's super hard when number of decks start to grow too fast...
 

Re: Categorizing & Inventorying Your Collection
« Reply #57 on: January 12, 2017, 09:33:27 PM »
 

pokereaq

  • 52 Plus Joker Member
  • Junior Member
  • *
  • 32
    Posts
  • Reputation: 2

  • Facebook:
I use a spreadsheet.  I include the brand, a Brief Description of the Deck, the year made if I know it, opened or unopened, and a couple other columns.  It is over 300 pages long, very interesting to look at.  At the bottom of the spreadsheet it keeps three totals for me:  Total Number of Decks, Total Number of Opened Decks, & Total Number of Unopened Decks.  I also save the list on two flash sticks just incase something happens...   
Lee Donelson
 

Re: Categorizing & Inventorying Your Collection
« Reply #58 on: February 22, 2017, 05:24:21 PM »
 

Kruser

  • 52 Plus Joker Member
  • True Member
  • *
  • 63
    Posts
  • Reputation: 4
  • Erlanger or Bust!!
As usual, tons of cool ideas on this thread!

As my collection has expanded, I too have been wondering how best to catalogue my collection! 

To this end, I made an investment: a digital document scanner! ... As it turns out, this was a great idea: now, I make digital scans of my cards and add any extra info to the title or description.

I found this to be a great solution to the categorizing issue - a picture can replace a lot of descriptors!

Also, once I have digital versions of my cards, I can 'cast' them to my 60-inch TV via Bluetooth as a slideshow - a great way to walk newbies through my collection without having to break out every single card or deck: if people are super-interested, I'll bring out the actual cards for closer examination.

BTW, the scanner I bought was an Epson - less than $100 on Amazon. Here's the link to the Canadian listing (probably cheaper in the US!)

 https://www.amazon.ca/gp/product/B00SSXQ7Q2/ref=oh_aui_detailpage_o00_s00?ie=UTF8&psc=1

Happy collecting!

Kruser



« Last Edit: February 22, 2017, 06:04:09 PM by Kruser »
"The mind is like a parachute - It works best when it's open." - Frank Zappa
 

Re: Categorizing & Inventorying Your Collection
« Reply #59 on: February 23, 2017, 10:03:52 AM »
 

Eddie Hughlett

  • 52 Plus Joker Member
  • Elite Member
  • *
  • 144
    Posts
  • Reputation: 6
Great idea Kruser!  Thanks for sharing.

-eh
"...almost every ruse in the game is more or less dependent upon another one."

 - S.W. Erdnase
 

Re: Categorizing & Inventorying Your Collection
« Reply #60 on: February 24, 2017, 04:36:18 AM »
 

Soochinator

  • 52 Plus Joker Member
  • Newcomer
  • *
  • 10
    Posts
  • Reputation: 1
I built an excel spreadsheet that I use for now. I joined Portfolio52, but I find it too basic for any productive use. Yeah, you can see what you have an how many at a glance, but it doesn't specify open vs sealed, cost, value, date acquired, etc. Too many things it doesn't have to list. I think it's a cool idea and I hope it continues to succeed, but I want more out my collection database/inventory. I want to be able to produce reports based on defined entries as I see fit. That being said, I'm now in the process of learning Access, so I can have a database that satisfies my need for lots of information.

As far as photos go, I don't bother taking my own photos. I download the KS photos or whatever each company provides online and have them all backed up and categorized in Google Drive. I considered taking my own photos, but there are decks that I'm not willing to open, so there would always be some missing.
 

Re: Categorizing & Inventorying Your Collection
« Reply #61 on: August 07, 2018, 11:55:06 PM »
 

Kevin Dixler

  • 52 Plus Joker Member
  • Newcomer
  • *
  • 8
    Posts
  • Reputation: 0

  • Facebook:
I have another hobby that suddenly took off.  I think that most of us want to share what we have and post what we can trade.  www.whiskybase.com is an excellent format for whisky collectors.  I think that the template can be modified.  Perhaps, the owners will share the sourcecode to those of us with obscure but interesting hobbies.  I am willing to assist to the extent possible in creating a user friendly database to share with the public to encourage playing card collecting.