The Acaeum Dungeons & Dragons
Collecting Forums

Thinking about writing an online database for collectors...
Post new topic Reply to topic Page 1 of 21, 2
Poll: Do you want me to spend hours and hours writing a database app on the internet for your collection instead of sniping your bids on ebay?

Yes, this is a great idea and I would use it. 42%       42%  [ 10 ]
No, Some guy did this already. Google it noob. 17%       17%  [ 4 ]
Who are you? Is this a scam? I feel frightened. 4%       4%  [ 1 ]
Yes, but I say yes to everything and won't really use it. 38%       38%  [ 9 ]
Total votes : 24

Author

User avatar

Prolific Collector

Posts: 353
Joined: Feb 19, 2003
Last Visit: Oct 04, 2023
Location: CA

Post Posted: Wed Dec 16, 2009 1:49 am 
 

Hey all, as I am trying to re-acclimate myself to the pulse of D&D/Game collection after a LOONG hiatus, I realize my memory of what I have is flawed... great gaping holes of knowledge have fallen down the memory hole.  

Where I used to be able to quickly scan Ebay auctions and posts here and mentally tick off not only what I had but which printings, I'm 'rediscovering' my collection and realize I have almost no clue what I have any more.

So, to get myself organized, I was thinking about writing a little utility that would let me punch in basic info, product code, title, publisher, printing, condition and a link to a picture.  A 'checklist builder'

If I did this, I then realized, it would not be THAT much more work to let anyone use it over the internet, which brings me here.

Would this be useful for anyone besides me?

One 'network effect' I thought of is that we could cross reference dupes and holes in collections and create a mini-flurry of trading to complete collections.. and/or flush out new editions (I could take scans of specific items).

It would also be fun to be able to offer 'virtual tours' of other people's collections (and not to mention the 'E-Peen' of showing your massive stack of modules off to the adoring throngs of people who want to be your love slave because of the hot hot hobby of D&D collecting... right guys?)


Down the road, for rarities I could even envision a 'pedigree' of sorts for tracking who owned what and who they sold it to.

It's my opinion that even the biggest collection has only a few thousand items and I think I could also manage an image library function linked to entries to show the actual item.

If I did this, and it was something you wanted to use, any suggestions on fields that would be useful?

edit: 300th post! woot


-------------------------------------------------

  

User avatar

Long-Winded Collector

Posts: 3153
Joined: Nov 21, 2005
Last Visit: Feb 05, 2016
Location: UK

Post Posted: Wed Dec 16, 2009 4:22 am 
 

*resists temptation to hook 300* ;)

Hmm... a few thousand 'zines, was that? :)
*nods* Thanks for the post: I'm not sure whether some people might be reluctant to list what they have, though, since that's often a good way of giving away ones likelihood of bidding high to fill in those gaps.

Anyhow; if that scope extends beyond just the published material there may still be a niche since that would then go beyond the likes of RPG Geek's in-built collections database; e.g. http://rpg.geekdo.com/collection/user/gobbeg for a trivial example.

d.


"7.3 ORGANIZING THE PARTY: Always have a keg, even if it's BYOB...
7.4 TAKING THE GAME SERIOUSLY: Don't"

  


Sage Collector
JG Valuation Board
Acaeum Donor

Posts: 2111
Joined: Aug 28, 2006
Last Visit: Jun 26, 2025
Location: Vienna, Austria

Post Posted: Wed Dec 16, 2009 5:10 am 
 

For my own collection, I have a Microsoft Access dbase, but without visuals that is really just a way for me to keep track of my own collection, including its overall value and gradings of different items. I haven't really thought about putting it online.

We could possibly attach some feature to the Acaeum wiki. I'll look into it.


Last edited by HermitFromPluto on Wed Dec 16, 2009 5:34 pm, edited 1 time in total.
  

User avatar

Long-Winded Collector
Acaeum Donor

Posts: 3865
Joined: Feb 21, 2004
Last Visit: Jul 20, 2023
Location: Milford, Michigan

Post Posted: Wed Dec 16, 2009 7:22 am 
 

I like the overall idea. I use Excel right now. Maybe limit exposure to Acaeum members instead of the entire web. Just a thought.


And I could've bought these damn modules off the 1$ rack!!!

New modules for your Old School game http://pacesettergames.com/

Everything Pacesetter at http://pacesettergames.blog.com/

 WWW  

User avatar

** Banned **

Posts: 1213
Joined: Aug 04, 2009
Last Visit: Nov 02, 2013

Post Posted: Wed Dec 16, 2009 7:33 am 
 

bbarsh wrote:I like the overall idea. I use Excel right now. Maybe limit exposure to Acaeum members instead of the entire web. Just a thought.


I'd probably play around with it, but wouldn't likely use it seriously. For one, my memory is tremendous (this is not necessarily a blessing, but in this case it is). Also, to control my sometimes overwhelming collecting compulsions, I've instituted a "one bookcase" rule. i.e., I have one (largish) bookcase and, "If it don't fit it don't get bought." Occasionally something gets bumped in favor of a new acquisition, or I become creative with space and the display strategy. So mark me down as "Yes, but I say yes to everything."


Ithaca Dragon
-==(UDIC)==-

  


Prolific Collector

Posts: 721
Joined: Aug 28, 2007
Last Visit: Dec 31, 2021
Location: Brooklyn

Post Posted: Wed Dec 16, 2009 10:52 am 
 

I would use it.

Limit to Acaeum would be good.

hopefully I could import my excel list into it.

Are you saying that the app would find ebay auctions for you?


“Remember that generosity can be contagious…”  - Dave Sutherland III

eBay ID: themilford
Hidden Ebay ID: t***o

 WWW  

User avatar

Sage Collector

Posts: 2589
Joined: Aug 02, 2006
Last Visit: Mar 11, 2023
Location: Seattle, WA

Post Posted: Wed Dec 16, 2009 11:47 am 
 

D&D checklists exist.

Could you create a better one with all the different pics/versions?  I suppose.  But you'd presumably be grabbing all the info from here and ToT to do it, which is questionable.

I have a spreadsheet that combines my want and have lists, and keep my want list as a separate text file.  That's plenty handy for my needs.

  


Prolific Collector

Posts: 697
Joined: Nov 05, 2008
Last Visit: Sep 25, 2015

Post Posted: Wed Dec 16, 2009 1:33 pm 
 

A consolidated checklist would be awesome.  But, are you thinking of doing everything (and variations) for 35+ years of d&d?  

In addition to the ones here at acaeum, there are checklists scattered across the internet for subsets of d&d collecting.  There is a site that does LJN toys, sites with databases where you can list (plastic) minis and trade them, lists devoted to Greyhawk, Forgotten Realms, etc.

The lists for second+ edition ad&D that I have found are fairly weak regarding promotional items, employee and executive items, etc.  And, even the best of the metal minis sites (even older) still have big holes in terms of pics of actual items.  I haven't explored the Chainmail minis line much at all yet, either.

Does acaeum have links to various other checklists?  If not, that might be of use, even though much of what I brought up is later than Acaeum's mission, certainly many of us collect in later areas and would find it useful.


Pipswich Peddles (and trades) for his collection!  
http://stores.ebay.com/Pipswich-Peddles

  


Prolific Collector

Posts: 721
Joined: Aug 28, 2007
Last Visit: Dec 31, 2021
Location: Brooklyn

Post Posted: Wed Dec 16, 2009 8:53 pm 
 

A coupla things would be great... that the Acaeum is lacking form the descriptions:

Have a publication date for each item... I can't believe that this site doesn't have at least the original copyright date for every item... let alone one for each printing.

Also Acaeum is lacking the TSR Stock # for each product...

Am I crazy?

TOT has these things... but why wouldn't this site?

I think the best start would be TSR from 1974 to 1989 (right before 2nd ed.) Including ALL non-D&D games like Gamma World, Empire of the Petal Throne, etc. and all the war games and boardgames.

Then once the format is perfected you can start adding beyond and other companies.

I only collect TSR up 'til 1985/6. I currently have 147 TSR Items cataloged, only 109 are D&D related with the rest being other Pre-1983 TSR products. I will be photographing them 5-10 per week over the next few months until I have every one documented with Front, Back, title page and Catalog page plus any unique pages or items.

I would be happy to contribute in any way I can.


“Remember that generosity can be contagious…”  - Dave Sutherland III

eBay ID: themilford
Hidden Ebay ID: t***o

 WWW  

User avatar

Long-Winded Collector
Acaeum Donor

Posts: 3865
Joined: Feb 21, 2004
Last Visit: Jul 20, 2023
Location: Milford, Michigan

Post Posted: Wed Dec 16, 2009 11:06 pm 
 

TheMilford wrote:
Also Acaeum is lacking the TSR Stock # for each product...

Am I crazy?

TOT has these things... but why wouldn't this site?


http://acaeum.com/library/stocklist.html


And I could've bought these damn modules off the 1$ rack!!!

New modules for your Old School game http://pacesettergames.com/

Everything Pacesetter at http://pacesettergames.blog.com/

 WWW  


Prolific Collector

Posts: 721
Joined: Aug 28, 2007
Last Visit: Dec 31, 2021
Location: Brooklyn

Post Posted: Wed Dec 16, 2009 11:11 pm 
 



Right but why not put that tiny 4 to 5 digit code right in the item descriptions? I don't even know how to access that page through the front door here... I've had to bookmark it the last time I googled to find it.


“Remember that generosity can be contagious…”  - Dave Sutherland III

eBay ID: themilford
Hidden Ebay ID: t***o

 WWW  

User avatar

Long-Winded Collector
Acaeum Donor

Posts: 3865
Joined: Feb 21, 2004
Last Visit: Jul 20, 2023
Location: Milford, Michigan

Post Posted: Wed Dec 16, 2009 11:55 pm 
 

TheMilford wrote:
Right but why not put that tiny 4 to 5 digit code right in the item descriptions? I don't even know how to access that page through the front door here... I've had to bookmark it the last time I googled to find it.


Go to the home page. Hit the Library tab and scroll down to References. You will find all kinds of good stuff there.


And I could've bought these damn modules off the 1$ rack!!!

New modules for your Old School game http://pacesettergames.com/

Everything Pacesetter at http://pacesettergames.blog.com/

 WWW  

User avatar

Prolific Collector

Posts: 353
Joined: Feb 19, 2003
Last Visit: Oct 04, 2023
Location: CA

Post Posted: Thu Dec 17, 2009 12:08 am 
 

I think I could build it 'wiki-ish' so that as people put stuff in, we could update the content and build a good database.

If you want to add notes about printing differences, who did the art..etc.. it could probably be accounted for.

Plus, I think I'd just start with the TSR classic AD&D 1st and earlier and let people add stuff as we went forward.

I definitely do not have the time to do all the data loading up front, but I think we could do a 'stone soup' approach and chip away at it over time.

I've got a busy few days ahead of me work wise but this really isn't too far off base of a project I'm building for an insurance company that wants to track who's got what forms in stock at their offices.

Swap out "Actuary Tables for Non-Smokers Over 60" to "Against the Slave Lords" and we're almost there! (I hope I don't mix those up!)

edit:
TheMilford wrote:I would use it.

hopefully I could import my excel list into it.

Are you saying that the app would find ebay auctions for you?


You raise a good point... importing Excel or CSV would be a good way to gain participation.

Wasn't thinking about auto-magically searching Ebay for gaps but it's a good idea.  Down the road though, assuming this gets off the ground.


-------------------------------------------------

  


Prolific Collector
Acaeum Donor

Posts: 145
Joined: Dec 16, 2009
Last Visit: Jul 23, 2010
Location: Boston, MA

Post Posted: Thu Dec 17, 2009 9:55 am 
 

At the risk (or is it an assurance!) of being bashed, the RPG Geek does have a strong set of checklist features for collections. Here is a cut of a half dozen items out of the 319 that I own:

http://images.boardgamegeek.com/images/pic625795.jpg

I track which version (printing, edition, etc) that I own, the price I paid for it and where I got it. There are a number of other fields - some of which I don't use. I don't currently track overall condition but I probably should. The database hyperlinks let me see who else owns the book, who has it for sale, who has it for trade. The "Private Info" field is actually a large number of fields which only aggregate to this view if I populate them (and nobody except me can see them - though I let you peek in this screen shot!). Other information is public by default. There are filters to let me see all current auctions on ebay for a given item (useful for items marked as "want to have" as opposed to "owned"). I can export my collection to a CSV file for import into excel. Just like the BGG App for the iPhone/iTouch, I'll soon have the ability to view my collection live streamed to my iTouch when I'm out at the thrift stores.

Our printing history information is not nearly as complete, accurate or sophisticated as the Acaeum's but we hope to at least be able to track down to accurate version/printings someday with a bit of help.

Plus... I just love the small icon view:

http://images.boardgamegeek.com/images/pic625804.jpg

-Dave

 WWW  

User avatar

Prolific Collector

Posts: 353
Joined: Feb 19, 2003
Last Visit: Oct 04, 2023
Location: CA

Post Posted: Thu Dec 17, 2009 9:47 pm 
 

319 items... NOOB! :D

Just kidding.

Hey man, I don't mind your project at all.. I think it's cool.

It may have some 'junk data' in it but you're trying to clean it up and frankly, it looks like you built what I was considering building but I had a more esoteric focus on collecting.

Hmm...


-------------------------------------------------

  


Prolific Collector

Posts: 721
Joined: Aug 28, 2007
Last Visit: Dec 31, 2021
Location: Brooklyn

Post Posted: Thu Dec 17, 2009 10:14 pm 
 

Hey!

I only have 150 or so TSR items... does that make me a a super-green-noob?

I guess if I counted the Role-aids and grenadier figs it would be MAYBE 200 or so items.

I feel like a loser now...  :oops:


“Remember that generosity can be contagious…”  - Dave Sutherland III

eBay ID: themilford
Hidden Ebay ID: t***o

 WWW  

User avatar

Prolific Collector

Posts: 353
Joined: Feb 19, 2003
Last Visit: Oct 04, 2023
Location: CA

Post Posted: Thu Dec 17, 2009 11:31 pm 
 

Believe me, it's more fun being a NOOB at the start of collecting than have thousands of things and all that's left is stuff that will cost you hundreds or thousands of dollars.


-------------------------------------------------

  


Long-Winded Collector

Posts: 3549
Joined: Oct 10, 2006
Last Visit: May 16, 2026
Location: Wandering aimlessly on the 8th level down...

Post Posted: Fri Dec 18, 2009 12:30 am 
 

with the size of my 'collection' I put the OO in NOOB!!
Although, I read once that size is disproportionate....  :lol:


Rolls a '3'

"Did I hit.....?"

  
Next
Post new topic Reply to topic Page 1 of 21, 2