How do you keep track of your famicom and other games? Program?

Started by DowntimeinJapan, June 19, 2012, 10:12:25 pm

Previous topic - Next topic

fredJ

I have mine in an online database.
Databases are superior to an excel document if you know how use them

I have my sorted first by year, and then by the order it was release in.
The columns are:
state of game -- order it was released in that year -- Japanese name -- other names -- region code  -- date (it got a bit incorrect), publisher / developer (not quite organized) -- genre (based on Japanese classification) -- commentary -- my grade (1-5) -- year published -- short game description
Selling  Japanese games in Sweden since 2011 (as "japanspel").
blog: http://japanspel.blogspot.com

DowntimeinJapan

Nice! Mods if you can should make a database that is linked to our profiles! We could check off ones we have, etc and others could see. Also could mark what we want or selling perhaps? That would be awesome!!!

MasterDisk

Quote from: DowntimeinJapan on June 20, 2012, 09:28:40 pm
Nice! Mods if you can should make a database that is linked to our profiles! We could check off ones we have, etc and others could see. Also could mark what we want or selling perhaps? That would be awesome!!!


I have an Excel file. Too lazy to make a database and I think it is enough for my 100 games :D

Oreanor

I made an XML file and a shell in Flash for my carts.
http://oreanor.narod.ru/
this is quite enough for me.

PS: can tune it for everyone who wants like I did for Masterdisk
http://www.masterdisk.byethost15.com/collection/index.html

famifan

Quote from: DowntimeinJapan on June 20, 2012, 05:21:39 pm
Saying you can and actually doing is different. I could out together some simple script but an actual program is different. if you can then please share the app, even a windows program then. Have you seen the gba or wii managers that exist? Or Nes? Those type of programs are wha I'm looking for. Not a simple one.

for me the script is better than some app. The data format is human-readable and easy editable by your favourite text editor (vim or emacs) because it is a plain text, and the data consistency is ensured by version control system and stored at the remote git repo.

i prefer a bunch of simple adjustable scripts, thas is always better than one huge overcomplicated buggy application.

so, my typical workflow is like that:
1) add new title with id to the list by hand
2) run script that generate JSON database (yeah, it hardly depends on bootgod; so if bootdog went to deaf i can modify it for using another database)
3) upload 2 files (database, and the html that will view the database content properly) on a web-hosting (well, i'm doing that manually, but that can be automated easily for a proper web-hosting)

Remember not to use any shitty unknown binary data formats like MS Excel and so on, because nobody guarantees that new version of excel app will read previous data format properly. The history proves that. Want to save your database over the time just use simple plain text format. Or don't cry when new M$ excel 2025 has nothing to do with your old database format.

Quote from: DowntimeinJapan on June 20, 2012, 05:21:39 pm
However they do not list the Japanese names(not in Japanese only romaji). I'd like a database that lists that as well (I'll have to enter the names) and shows box art.

bootgod is doing the first and partially doing the second. Well, it depends on database content.

Duke.Togo

Why not just use RF Generation? www.rfgeneration.com

It's free, user supported and maintained, and there is a free Android app. A great community to boot.

2A03

Quote from: Duke.Togo on June 21, 2012, 09:51:40 am
Why not just use RF Generation? www.rfgeneration.com

It's free, user supported and maintained, and there is a free Android app. A great community to boot.

This is what I use too, aside from the fact I happen to be a staff member there!

famifan

Quote from: Duke.Togo on June 21, 2012, 09:51:40 am
Why not just use RF Generation? www.rfgeneration.com

It's free, user supported and maintained, and there is a free Android app. A great community to boot.

3 questions about it:
does it support exporting to a regular file?
can i edit this file with my favourite editor?
can i upload edited file back?

Duke.Togo

Yes, you can export your collection data to a .csv file.

Of course you can edit a .csv in any editor you like since it is plain text.

No, they do not support upload for data integrity reasons.

tonev

Quote from: fredJ on June 20, 2012, 06:24:53 pm
I have mine in an online database.
Databases are superior to an excel document if you know how use them

I have my sorted first by year, and then by the order it was release in.
The columns are:
state of game -- order it was released in that year -- Japanese name -- other names -- region code  -- date (it got a bit incorrect), publisher / developer (not quite organized) -- genre (based on Japanese classification) -- commentary -- my grade (1-5) -- year published -- short game description


Nice you are using Msql  ;D so you have a php page with search and everything?
I am back everyone :)

DowntimeinJapan

So I went with excel since it can be imported into google documents and be viewable through that. Links in my signature :) I gotta get around to doing my super fam and genesis games but the famicom one took so damn long so x.x

NintendoKing

There is a thread, I just use it and list new games when I buy them. And when I sell one, I remove it from the list. Simple as that.

DowntimeinJapan

That works well for reselling purposes I suppose :) or of you want a simple list that's good~

NintendoKing

Yea, it's efficient enough to keep me on track of what I own. If the cartridge is a Multicart I always list what games it contains.

Cheetahmen

Quote from: The Uninvited Gremlin on July 02, 2012, 07:37:10 am
Yea, it's efficient enough to keep me on track of what I own. If the cartridge is a Multicart I always list what games it contains.
Same here. :) Personally, I always specify whether the game I have is on a single cart, multicart or both.
Life is too short to be little.
Twitter | DeviantArt | Youtube | Twitch