Keeping track of your collection

[Codeman]

I hope Im posting this in the right section.

I have a modest collection of about 600 video games, and I found it hard to organize my own collection due to the increasing amount of new games.

Like most people, I started with a modest TXT file, upgraded to an Excell spreadsheet and as the collection increased and eventually became more anal about my games I figured I needed a better solution.

One day I found this website from a collector where he made available for download a simple database which he used to keep track of his own collection.
I used his database as a starting point and heavily modified it to suit my needs and I still use it today and keep adding new features every other day.
Im "auditing" my own collection at the moment, I have accounted about 600 games so far, about 34% done.

Since these boards are frequented by lots of hardcore collectors I think It would be nice to know and share some ways of organizing and keeping track of our collections.

I cant imagine someone like Adol keeping track of his collection in a simple 2GB txt file :D

[alphagamer]

my collection is rather small and i have a good overview.
excel is enough for the time being.

[dulledblade]

Excel will have to do until I get an app that lets me search a database that I make. It's getting on the brink of annoying though, I wish there was a simpler way.

[michal99]

I hope Im posting this in the right section.

I have a modest collection of about 600 video games, and I found it hard to organize my own collection due to the increasing amount of new games.

Like most people, I started with a modest TXT file, upgraded to an Excell spreadsheet and as the collection increased and eventually became more anal about my games I figured I needed a better solution.

One day I found this website from a collector where he made available for download a simple database which he used to keep track of his own collection.
I used his database as a starting point and heavily modified it to suit my needs and I still use it today and keep adding new features every other day.
Im "auditing" my own collection at the moment, I have accounted about 600 games so far, about 34% done.

Since these boards are frequented by lots of hardcore collectors I think It would be nice to know and share some ways of organizing and keeping track of our collections.

I cant imagine someone like Adol keeping track of his collection in a simple 2GB txt file :D
I also still use Excel, but would be interestet in some kind of database as my collection is going bigger. Would be nice if you could share your program or the link to the original.

[DrDoaK]

I've tried allsorts of different methods in the past: simple text file, excel, online databases, even the Video Game Collector software. None of these really worked for me, as I wanted to see the actual games I owned wherever I was so I could make a split second decision whether to buy something or not.

So I made this:

http://ninjabearhug.webs.com/games.htm

It's still work in progress, but basically it's a list of all the games I own with a photograph of every single game on there. I still have loads more to add, DC and all my Sony games for a start, but I've kept this list more up to date than any other I've ever made. It works a treat though. Whenever I'm in a Game shop and I'm not sure if a game I have is complete or not, I just get my mobile out, connect to the site and check the photo :icon_bigg

[Tchoin]

For now I'm cool with an excel spreadsheet with details such as condition, manuals, box, quantity, color, serial no., model no., etc.

Last year I started making an online database with PHP & mySQL but never finished it as I don't need such thing right now because my collection is rather small.

[Johnny]

I use spreadsheets as well (not that i have a lot of stuff anyway)

Wish someone could actually make a good program for it though.

[Aypok]

I hacked together a quick PHP solution about three years ago (so the code is terrible, but it works). See: http://games.aypok.co.uk/. I released the source code, so others can run/modify it as they choose.</plug>

[3do]

There is a program called Collectorz which has one for games - http://www.collectorz.com/game/


Game Collector Automatically Catalogs Your Game Collection.
Just Enter Game Titles or Scan Box Barcodes.
Instantly Download All Game Details and Cover Images.


supported platforms
PC
Playstation 3
Xbox 360
PSP
Wii
GameCube
Nintendo 64
Playstation 2
Game Boy Advance
Nintendo DS
Playstation 1
Xbox
Super Nintendo
NES
Game Boy
TurboGrafx-16
Sega Genesis
Sega Saturn
Sega Dreamcast
Atari 2600
Commodore 64
and way more...

[Tchoin]

Sounds cool, gonna try that one 3do, if it works by scanning bar codes it would be great for people with very large collections.
I'll download the trial to take a look.

[DrDoaK]

I have collectorz, it's the best offline one I've come across, but it's still missing LOADS of games, especially for the SMS which is one of my main collections. That's the only reason I never really used it properly TBH though. All the features of the software are great though and you can spend hours just messing around with some of them.

[virtual alan]

I use spreadsheets as well (not that i have a lot of stuff anyway)

Wish someone could actually make a good program for it though.

I did pick up in some store ages ago a programme for collectors, but never got around to using it

I know there are some on-line collectors site`s, but most of these are for the relatively normal, not some / most of the odd shit we all tend to have :nod:

Surely someone here can knock something up in a few hours ;-) , I am sure we would all contribute to the cause

[Codeman]

I forgot to mention one of my favorite sites that I use to check the game's details is vgrebirth, and I also contribute whenever I have some unlisted title or missing detail. This site has an awesome database.

It would be great if with the info and suggestions in this thread we could build the ultimate app/database!

Some of the features and characteristics of my database:

For each title I have a:
ID (numerical value unique to each game)
Main title (CJK characters suported)
Alt. title (translated title or just used as keywords when searching a game by title)
Genre (List of game genres like action, shooter etc and HARDWARE if its a piece of hardware instead of a game)
System (Here I have a list of possible systems)
Publisher (Here I have a list of possible publishers)
Developer (Uses the same list of Publishers)
Condition (here I have another list, going from Terrible to Mint and Sealed)
Media (List with types of media like CD or cartridge)
Box, manual and spine checkboxes
Year (of release)
Number of players
Product code (the game code, most games have it, like the PSx titles SLES-12345)
Barcode
Vendor (list of places where I usually get my games, Private* for private purchases, and put any additional information about the seller in the Comments box)
Area code (J/U/E etc)
Comments (box to put any sort of additional info about the game)
Price (Price I PAID for the game, not the original retail price
Date of purchase (When I aquired the game)
Available (checkbox+text desription box, if a game is borrowed to someone or somehow missing this box gets unchecked and a small text description is added about what happened and when it happened)
Repeated and Repeated ID (if it's a repeated title I just mark this checkbox and fill in the ID from the "original" title
Audit date (date when the game was last audited, good to do periodic checks of your games to avoid missing or sold titles, can also be used to track the last time a battery-backed-up cart was power on)
Maintenance (checkbox for games that will need some maintenance, like boxes with glue residues and stickers, dirty carts etc)


As you can see some of these features are pretty commons, others are very "personal" and useful to me.

Some examples of what I can do with all this data:

Generate all sorts of game lists like complete lists of all systems, sorted by platform with total of titles per platform and grand total
Any of these lists can be easily exported to pdf, excel, html

I can search games by title or barcodes, get a list of audited titles and see which titles havent been audited in a long period of time.
I can also see how much games I got this month (or any period of time) or how much money I spent on games this month (or in any period of time), the grand total is always scary :D

These are only some examples of the lists and query's which I find most useful, since this is a simple MS access database I can easily make any query I want.
However my MS access skillz are very limited, there are some features, like adding pictures, that I would love to implement but still haven't figured out how.

[Tchoin]

And still you have not linked us to that website :110:

[ASSEMbler]

impossible, I must have tens of thousands of items...

[Hawanja]

My collection is totally out of control. I have no idea really what I have scattered in several different places. Not the thousands of items that some of you guys have, but enough that when someone asks me if I have a particular game I have to think about it.

[Codeman]

My collection is totally out of control. I have no idea really what I have scattered in several different places. Not the thousands of items that some of you guys have, but enough that when someone asks me if I have a particular game I have to think about it.
That was sort of my situation, but I started wondering what was the point off having and collecting all this stuff if I cant even remember what I have?

I wish I started doing this sooner, this is sort of how I started listing and organizing my games.

The best way to start organizing IMO is to get a sheet of paper and go to every shelf and start writing down every title you have on there.
Or even better, take some high res pics of your shelves :D

Then start inserting the titles on your list/database/app and you will get a rough list of what you have.

And then the toughest part is grabbing your games one by one and filling in the remaining details (condition, manual? box? barcode etc).
Things like release dates, publishers, etc can be obtained from sites like vgrebirth so you can fill these in whenever you want.

And my last step, when one of my games has all the data correctly inserted in my database I fill in the audit date, I put the respective game in a protective baggie and put a small sticker with its ID.
This helps distinguished whichs games have been listed and which ones haven't.

[Johnny]

Great "guide". I have to re-check my stuff soon, and i'll follow those steps.

[ave]

Excel does the job except you really need additional information for each game - I don't. My collection isn't that big anyways, I just prefer to keep it simple and Excel is exactly what I want: a simple solution to organize my games.

As for guys like Assembler I'd well say it's impossible to make a complete list without having a free month of holidays and Adol would rather make a list of what he does NOT own :lol:

[Dark Seraph91]

For me Excel has always been good for small things. When You start having Alot of Columns and Rows and multiple everything and start making your excel spreadsheets bigger and bigger. Excel seems to slow down. Alot.

[Skaarg]

I've used rfgeneration's lists for a lot of my stuff. It makes it pretty easy to organize things.

[alecjahn]

I just keep all my stuff on one side of the room, and I put myself on the other.

[CoinCollector]

I've used rfgeneration's lists for a lot of my stuff. It makes it pretty easy to organize things.
Yeah, I really like RF Generation. It's very easy to use and works great!

[WanganRunner]

You can easily maintain your data in Excel and search / categorize it via Access.

I just use straight-up Excel. I don't have enough stuff to make a DB worth my while.

[mrmark0673]

I've used rfgeneration's lists for a lot of my stuff. It makes it pretty easy to organize things.

I've been using rfgeneration for years, definitely recommend it. If you're just looking to catalog retail games (and instructions/boxes) and systems, there isn't a better system out there.

Many people love their excel sheets, but I like the fact that I can access the tool from any comp when I'm not at home. Makes it easy to reference my collection before making a purchase.

[Druid II]

I use Excel, it works fine, although I don't need all kinds of fancy custom sorting.

I do run 4-5 files listing seperate stuff, I need to "unify" my lists once...

[sonik]

Is there any program or site to catalog with support for our own pictures of every game disc/cart, box and manual?

[Adol]

I don't use anything else than my brain. No list of what i own. Well,yes,some lists: the missing titles on a system for making the fullset. Like "i need that,that,and that title to end my factory sealed PCE fullset"..i work oppositely to many other collectors ^^

[jimpachi]

i keep all my games, dvds, cds in those big aluminium cd cases. got a 2000 disc case for dvds and a 1000 disc case for games and cds.

each disc is numbered and i made a mysql database which i query with a php page to find where a disc is

[ave]

@Adol

I just have to quote my prior posting in this thread.


[...] and Adol would rather make a list of what he does NOT own
:thumbsup:

Actually I wouldn't need an Excel list for my games as I know exactly what I own and in what condition the item is, but I want to know whatever I paid for the item w/shipping so I have some kind of statistics about the cost of my "passion". ^^
Gifts are declared as 0 EUR (even the games I got when I was well under 10yrs old are listed like that) and I've listed most of my Xbox games for 60 Euro each. It's the only way to estimate the price of a collection in my opinion, not that crappy IGN value shit that calculates 20$ for any loose NES cart.

[Adol]

Adol would rather make a list of what he does NOT own :lol:

:lol:

[michal99]

Is there any program or site to catalog with support for our own pictures of every game disc/cart, box and manual?

I just try collectorz.com and the program is quite advanced. You can add the game from their database or you can add them manualy or both add basic informations from their database and then personalize them. It can keep track of loan, missing, wanted etc. You can add scans, informations, and all sorts of field about anything.

[Storm]

I just try collectorz.com and the program is quite advanced. You can add the game from their database or you can add them manualy or both add basic informations from their database and then personalize them. It can keep track of loan, missing, wanted etc. You can add scans, informations, and all sorts of field about anything.

Just remember to submit missing games and scans to their master database so I don't have to. ;-)

collectorz.com is nice, and I'm halfway into converting my homegrown database to their system. The downside is that their central database has very little in the form of older games. It's also a bit awkward to keep track of doublets.

[OatBob]

I know I'm digging up an old topic here, but I use the free online checklists available at RF Generation (http://www.rfgeneration.com). The site is ad-free and user supported (much like ASSEMbler). If there something is missing from the database, there is a form submission tool to add new titles (pending staff approval). Entries are checked by staff for accuracy and consistency (and stolen scans), but are generally approved within a day. In addition, ALL SUBMISSIONS are credited to whomever added the info.

Its completely free so I highly recommend trying it out.* If you already have a good solution, it is also a good to have redundancy and to show off what you've got.


*I should mention I'm currently on staff at RFGen, so this is indeed a shameless plug. We do not advertise, and most users join by word-of-mouth.

[I and I]

as you can see in our profile (and sig too I think), we use a website to keep track of our collection
I coded it so it'll suits our every need :)
it used PHP and a MySQL database
if people want one, you can always contact me ^^

[Juste]

I use TextEdit but only have a collection list for things I'd like to collect in the future (I don't have a big collection to keep track of). :(

[Reverend Hammer]

I've been playing around a bit with RF Generation, and so far I have to say I like it. I do wish I could get it to return more than 40 results per page, though. Would make it easier when starting new lists.

[Digital Conservationist]

i have found rf generation to be completely incomplete on most systems -- especially on the hardware portion.

www.digitpress.com (http://www.digitpress.com) -- click the rarity guide then click the easy printable lists section. choose your console, choose us released games, choose your options below, generate!

if youre looking for NES specific and REALLY REALLY indepth, check out
http://www.nationalgamedepot.zoomshare.com/1.html

[Panzer Mike]

If you're a Mac user you can use "Game Hunter (http://www.apple.com/downloads/macosx/home_learning/gamehunter.html)". It's a free app that let's you catalogue your game and hardware collection and it's interface looks a lot like iTunes, including the cool "coverflow" option.

Just fill in the fields and add your own covers, make lists, keep track of their location, export to PDF, backup to a network, etc... For the more recent platforms it has a handy auto-complete function which fills in the fields for you by connection to several databases. It's really great.

http://farm5.static.flickr.com/4078/4793017108_d4350d43be_o.jpg

[SuperPlay]

I use a mix of pcedaisakusen.net and collectorz for my PCE collection.

[Marriott_Guy]

+1 For RF Generation's collection tool (http://www.rfgeneration.com)

[Tchoin]

Bump!

It looks like the guys from Collectorz.com released an upgrade for their Game Collector app, which FINALLY lets us catalog gaming hardware and peripherals and not only software.

I used version 3.2 Pro for cataloging my software and an Excel spreadsheet for hardware and peripherals, will probably upgrade to version 4.0.2 and merge that spreadsheet and have everything on Game Collector.