Request for Transformer Spreadsheets and/or Databases

[jaydisc]

Some of you might remember a discussion I sparked on the old board about databasing our collections and might remember me promising to do all these wonderful things regarding building a web application for collectors to use. You've probably since thought, "bah... that jaydisc overpromised and underdelivered..." You'd be partially right, but I'm happy to say that I've made great leaps and bounds and I'm hoping to open up a version for you guys to play around with and test in the next week or two.

The primary basis of the software is to maintain one central library of Transformers and collection-related items. Each user can then have their own collection and easily add items from this central library thus saving themselves a great amount of data entry.

For my first release, editing and adding to the library will NOT be made available to users. However, providing a mechanism for users to recommend and approve library changes is the first feature that will be added after the initial release.

So, because Library edits and additions will not be made available, I need to have this initial database as well populated as possible for the first round of testing. So, I am putting a request out to all of you who might use spreadsheets or databases to provide me with what you use so that I can filter through that to provide the initial contents of the library.

So, if you have a spreadsheet or a database that you can export and are happy to share it with me, please grab me on AIM or MSN (see my profile) or PM me for my email address.

Thank you!

[iceburn]

hihi....

i think this could be addressed to griffin, gok, demonac, dirge, tiby and other collectors that already have a massive database.

jay, paul and i were talking about it on Monday again and it's come to my mind that something needs to be done about it soon.

currently, i'm more than happy to get a simple list of toys/merchandise (be it Hasbro, Takara or whoever) that's been released since G1 till present day. i'll be happy to do a compilation of whoever has supplied it and come up with a generic one for starters.

please help as i'm sure this will benefit the community and who knows...it may be a point where we can use it as a standalone as well as shared software in Ozformers. It can also become a revenue (when fully developed) to maintain the board....

so pls pls email me your list (minus your expenditure on the item or other details that is deem as a privacy issue). thanks

[JuzMel]

I use an excel spreadsheet for the moment. Each category like G1, Movie, Animated, Classics etc is seperated by different worksheets in the same spreadsheet. Ah it's hard to explain, I can email you mine when I get home tonight...

[kup]

I am going to have to start with keeping records of not so much what figures do I have but what accessories I need/have.

I have made the mistake in the past of not buying something because I thought I already had it or buying something that I alread had particularly when it comes to combiner/Gestalt team accessories.

[GoktimusPrime]

Like mel I just use an excel spreadsheet. A whoppingly massive spreadsheet, but yeah... it's just a regular excel file.

[Soundwarp]

Wow, i have just done most of my collection on a spreadsheet.
I'd be more than happy to do it again if there was one for us all to use, only problem is i diddn't understand a word you said

[iceburn]

Like mel I just use an excel spreadsheet. A whoppingly massive spreadsheet, but yeah... it's just a regular excel file.

Wow, i have just done most of my collection on a spreadsheet.
I'd be more than happy to do it again if there was one for us all to use, only problem is i diddn't understand a word you said

haha...i just need a list of figures right from the beginning to create the database....so this request is about asking you guys to email me your excel spreadsheet (minus all the sensitive details) leaving those generic ones so that i can compile it all together.

Soundwarp..hope that helps..mind my language too
i talk Singlish you know

[Saintly]

how about just sharing an online spreadsheet via Google Docs?

http://spreadsheets.google.com

[Paulbot]

Iceburn, I sent Jaydisc a list of the US G1 toys. If you want I can send it on to you.

You could also the Checklist that the Hasbro have (had?) on their website which I think goes up to the first year of Cybertron.

Edit: List attached. Has some Beast Wars toys included too

[iceburn]

yeah...if you could send me yours...Demonac has send me his..so i'll just compare.
i've looked on the web and some list are reliable, some aren't. so i rather trust local fan's list.