Wanted features in a game collection database program?

[RockyRaccoon]

Yes. I'am going to attempt to make a Game Database Recordkeeping like program. I can't promise it'll LOOK Ultra Flashy (Unless someone who has the real artistic talent wants to do the User Interfaces. :P ). I do have the means to have this program made however. So don't go off telling me how much work it's gonna be and what not..blah-blah-blah, I know that already.

But what'd I'd LIKE to know is what features you want added...and support for what systems in general?

Lemme know so I can begin drafting an outline. :).

~Rocky



[ EDIT: OKAY AS OF RIGHT NOW, the following is drawn out. keep em coming guys.]

Features Wanted That are possible:

#1.) Pictures/Picture able to be attached to Each Entry.

#2.) Not just Game support, but Accessory / Misc. Support, such as

Controllers, Manuals... Tags that state if you beaten it.. it works or is

non/working, willing to trade? Etc.

#3.) Icons for each section.

#4.) Scales for Condition, on a 1 to 10 scale.. 1 being poor.. 10 being New

in Box/mint

#5.) Number of copies had / Tradelist

#6.) Rarity Field

#7.) Value Total of your collection overall.


Features Wanted that *Might* be possible, even if after first version

released to public:

#1.) Conversion to HTML Format.


Features that *probably* won't make it:

#1.) Conversion to Excel Format , another programs format.

[VACRMH]

You should be able to add info about if you have the manual or the box and such. Maybe even more, due to the fact that you can have a strategy guide, map, soundtrack and so forth.

Also, maybe be able to include if you've beaten the game, or if it's something you're willing to trade or sell?

[blissfulnoise]

Take a look at DVD profiler. I'll pay big for an application like that for video games.

EDIT: It looks like Game Collector has come some way since the last time I looked at it. Have to give it some additional testing, but I'd still like more scans and more details before I'd think about buying software I could pretty easily make on my own.

[girth305]

Good afternoon,

I have been using cart commander as of late to keep track of my collection. Not very robust, but it does have some good features. Something i would like to see is a section to save a pic of the game in the database entry, like a pic of the cart or the cover art.

I don't know if you are familiar with dvd profiler, but I like the way you can view your dvd cover in each entry.

Take Care!

[Oobgarm]

Go to collectorz.com and download the trial of their game collector. Make it like that and add hardware/accessory support and you've got a winner-especially if it's free or cheap. ;)

You should cover everything in the DP Guides and the current gen of systems too. Don't leave anything out at all.

[robotriot]

Either include icons for all systems at the beggining of the listing or let the user make their own ones :D I could help you out in that area graphics-wise if needed ^^

[Cauterize]

Great idea.. im jsut currently using Microsoft Access and a load of tables to catologe my stuff...

my ideas are...

Functions like

Area to add Game Name, Version (if possible), Release Year, Company, Notes about this game, also extras would be nice such as How much i paid for this game & its rarity!

Tick boxes for
Box
Manual
Cart
Inserts

Scales out of 10 for
Condition of Box, Manual, Cart & Inserts

The ability to add a image (of a box scan) to the data

A duplicate/trade list generator... (finds your duplicates by searching thru your database

A function to export database to excel/word (as i use a pocket pc when im out on finds and need to check what i have and dont have)

also export to html pages would be nice, therefore we can show off our collections in separate html pages divided into sections such as consoles/company/rarity

Nice little extras would be small icons for each system, which you can click on to change the system you are databsing for...

and what would be the ULTIMATE feature, is if you had a value-adder-upper, where it adds up all the values giving yopu a all together value of your collection!

and to add to that last point, do the same for the filed "How much i paid for this" adding up how much you spent, giving you the ability to see wether u are spendin more than they are worth or if you have a good investment!

hope this helps!

also i aint to bad at photoshop if you want some logos doing?

[RockyRaccoon]

Either include icons for all systems at the beggining of the listing or let the user make their own ones :D I could help you out in that area graphics-wise if needed ^^

Yes..I would need Icons for just about every system in the DP guide then. If you can help out with that. That'd be great.

--------

As for the Price? This program will also be Freeware. I don't intend to charge money for it.

~Rocky

[RockyRaccoon]

OKAY AS OF RIGHT NOW, the following is drawn out. keep em coming guys.

Features Wanted That are possible:

#1.) Pictures/Picture able to be attached to Each Entry.

#2.) Not just Game support, but Accessory / Misc. Support, such as

Controllers, Manuals... Tags that state if you beaten it.. it works or is

non/working, willing to trade? Etc.

#3.) Icons for each section.

#4.) Scales for Condition, on a 1 to 10 scale.. 1 being poor.. 10 being New

in Box/mint

#5.) Number of copies had / Tradelist

#6.) Rarity Field

#7.) Value Total of your collection overall.


Features Wanted that *Might* be possible, even if after first version

released to public:

#1.) Conversion to HTML Format.


Features that *probably* won't make it:

#1.) Conversion to Excel Format , another programs format.

[Cauterize]

sounds good to me!

get to work :P LOL :P 8-) LOL :P

[Flack]

#1.) Conversion to Excel Format , another programs format.

What you might try is allowing users to export into a tab delimited text file. A delimited text file can be imported into Excel, and should be easy to code.

I also like fields where I can track the value of games, and what I paid for them.

[robotriot]

Either include icons for all systems at the beggining of the listing or let the user make their own ones :D I could help you out in that area graphics-wise if needed ^^

Yes..I would need Icons for just about every system in the DP guide then. If you can help out with that. That'd be great.

--------

As for the Price? This program will also be Freeware. I don't intend to charge money for it.

~Rocky

Ok, I just need to know what size they'll have to be.

[Speedy]

Perhaps you can include consoles aswell? (like you are willing to do games and accessory), like you have 2 versions of the saturn etc.

[RockyRaccoon]

Either include icons for all systems at the beggining of the listing or let the user make their own ones :D I could help you out in that area graphics-wise if needed ^^

Yes..I would need Icons for just about every system in the DP guide then. If you can help out with that. That'd be great.

--------

As for the Price? This program will also be Freeware. I don't intend to charge money for it.

~Rocky

Ok, I just need to know what size they'll have to be.

Standard Windows Size Icons dude. like.. thats... 30 by 30 or something?

[morphx]

I like to use check boxes for parts of the game/package...(i.e. box, manual, case, sleeve, map, inserts)

[robotriot]

Here's the first set of icons, I hope more will follow soon (I will export them as .ico when all of them are finished) ^^ It might be that I didn't get the original system logo for some of them, if so, I'd be glad if somebody could supply me with just that :)

http://omr.planet-d.net/img/console_icons/32x.gifhttp://omr.planet-d.net/img/console_icons/3do.gifhttp://omr.planet-d.net/img/console_icons/adventurevision.gifhttp://omr.planet-d.net/img/console_icons/apf.gifhttp://omr.planet-d.net/img/console_icons/arcadia2001.gifhttp://omr.planet-d.net/img/console_icons/atari_2600.gifhttp://omr.planet-d.net/img/console_icons/atari_5200.gifhttp://omr.planet-d.net/img/console_icons/atari_7800.gifhttp://omr.planet-d.net/img/console_icons/atari_xe.gifhttp://omr.planet-d.net/img/console_icons/cd-i.gifhttp://omr.planet-d.net/img/console_icons/cd32.gifhttp://omr.planet-d.net/img/console_icons/cdtv.gifhttp://omr.planet-d.net/img/console_icons/channel_f.gifhttp://omr.planet-d.net/img/console_icons/colecoadam.gifhttp://omr.planet-d.net/img/console_icons/colecovision.gifhttp://omr.planet-d.net/img/console_icons/commodore64.gifhttp://omr.planet-d.net/img/console_icons/creativision.gifhttp://omr.planet-d.net/img/console_icons/discovery_system.gifhttp://omr.planet-d.net/img/console_icons/dragon32.gifhttp://omr.planet-d.net/img/console_icons/dreamcast.gifhttp://omr.planet-d.net/img/console_icons/fm_towns_marty.gifhttp://omr.planet-d.net/img/console_icons/game_watch.gif
http://omr.planet-d.net/img/console_icons/gameboy.gifhttp://omr.planet-d.net/img/console_icons/gameboyadvance.gifhttp://omr.planet-d.net/img/console_icons/gameboycolor.gifhttp://omr.planet-d.net/img/console_icons/gamecube.gifhttp://omr.planet-d.net/img/console_icons/gamegear.gifhttp://omr.planet-d.net/img/console_icons/genesis.gifhttp://omr.planet-d.net/img/console_icons/gp32.gifhttp://omr.planet-d.net/img/console_icons/halcyon.gifhttp://omr.planet-d.net/img/console_icons/intellivision.gifhttp://omr.planet-d.net/img/console_icons/interactivevision.gifhttp://omr.planet-d.net/img/console_icons/interton_vc4000.gifhttp://omr.planet-d.net/img/console_icons/jaguar.gifhttp://omr.planet-d.net/img/console_icons/laseractive.gifhttp://omr.planet-d.net/img/console_icons/lynx.gifhttp://omr.planet-d.net/img/console_icons/matell_aquarius.gifhttp://omr.planet-d.net/img/console_icons/memorex_vis.gifhttp://omr.planet-d.net/img/console_icons/microvision.gifhttp://omr.planet-d.net/img/console_icons/msx.gifhttp://omr.planet-d.net/img/console_icons/n64.gifhttp://omr.planet-d.net/img/console_icons/neogeo.gifhttp://omr.planet-d.net/img/console_icons/neogeo_pocket.gifhttp://omr.planet-d.net/img/console_icons/nes.gif
http://omr.planet-d.net/img/console_icons/nuon.gifhttp://omr.planet-d.net/img/console_icons/odyssey.gifhttp://omr.planet-d.net/img/console_icons/odyssey2.gifhttp://omr.planet-d.net/img/console_icons/pc-fx.gifhttp://omr.planet-d.net/img/console_icons/pcjr.gifhttp://omr.planet-d.net/img/console_icons/pico.gifhttp://omr.planet-d.net/img/console_icons/pippin.gifhttp://omr.planet-d.net/img/console_icons/playstation.gifhttp://omr.planet-d.net/img/console_icons/playstation2.gifhttp://omr.planet-d.net/img/console_icons/rca_studio_ii.gifhttp://omr.planet-d.net/img/console_icons/r-zone.gifhttp://omr.planet-d.net/img/console_icons/saturn.gifhttp://omr.planet-d.net/img/console_icons/sega_master_system.gifhttp://omr.planet-d.net/img/console_icons/segacd.gifhttp://omr.planet-d.net/img/console_icons/select-a-game.gifhttp://omr.planet-d.net/img/console_icons/sg-1000.gifhttp://omr.planet-d.net/img/console_icons/sinclair_spectrum.gifhttp://omr.planet-d.net/img/console_icons/snes.gifhttp://omr.planet-d.net/img/console_icons/super_grafx.gifhttp://omr.planet-d.net/img/console_icons/supervision.gifhttp://omr.planet-d.net/img/console_icons/telstar_arcade.gifhttp://omr.planet-d.net/img/console_icons/timex_sinclair.gif
http://omr.planet-d.net/img/console_icons/timex_sinclair_2068.gifhttp://omr.planet-d.net/img/console_icons/tomy_tutor.gifhttp://omr.planet-d.net/img/console_icons/total_control.gifhttp://omr.planet-d.net/img/console_icons/trs_80.gifhttp://omr.planet-d.net/img/console_icons/turbografx_16.gifhttp://omr.planet-d.net/img/console_icons/vectrex.gifhttp://omr.planet-d.net/img/console_icons/vic_20.gifhttp://omr.planet-d.net/img/console_icons/videobrain.gifhttp://omr.planet-d.net/img/console_icons/virtualboy.gifhttp://omr.planet-d.net/img/console_icons/xbox.gifhttp://omr.planet-d.net/img/console_icons/windows.gifhttp://omr.planet-d.net/img/console_icons/msdos.gifhttp://omr.planet-d.net/img/console_icons/nintendo_ds.gifhttp://omr.planet-d.net/img/console_icons/amiga.gifhttp://omr.planet-d.net/img/console_icons/atari_st.gifhttp://omr.planet-d.net/img/console_icons/apple.gifhttp://omr.planet-d.net/img/console_icons/linux.gif

[thehistorian]

If this were my application I'd make it all web based...

Upload a CSV file that matches the required fields and it would auto update your list.

Images could be stored online and pulled from the server as needed. Add in user ratings/reviews and FAQs

Export to HTML, XML(GameXML "RSS" type feed?) or Excel would be a breeze.

Using the user's supplied data we could start an average price/cost system that would auto update everyone's Collection value. This could also be used to determine Replacement Value (typically what an insurance company would use), Average Cost (by Country, City, State, Zip, Province, etc.) and Equivilent trade values across systems( 10 pac-man 2600 = 1 mary-kate and ashley GBA).

It could also start to really track how many copies of games are out there, creating a self updating rarity guide (again by Country, City, State, Zip, Province, etc.).

When you dream... Dream big...

The really sad thing is....

I could do this if only I had more time...

[RockyRaccoon]

Here's the first set of icons, I hope more will follow soon (I will export them as .ico when all of them are finished) ^^ It might be that I didn't get the original system logo for some of them, if so, I'd be glad if somebody could supply me with just that :)


I Love these man! they're awesome!

BTW...PM me your credit info... Name / E-mail if wanted..so I can unclude proper credit in credits and special thanks. :P

[SkiDragon]

So yeah, sounds neat. Im not sure if it was mentioned, but it should have support for individual entry of prices, not just a total. Also, price and date of original purchase would be very nice, since I keep records of that myself already. Also, if it could automatically look up DP prices and rarities, and scan your collection for most rare/valuable, that would be nice.

Oh yeah, it was mentioned before, but support for actual systems is a necessity.

[Ruudos]

Value and the actual amount of money you've paid for an item.

[robotriot]

I've updated the post above with all the remaining icons (plus some missing ones, like PC operating systems and the DS), and here (http://omr.planet-d.net/img/console_icons/icos.zip) are the .ico files :)

[morphx]

You could go insane with barcode/serial #'s if you want super detailed info.