We buy toys! Learn more...
Board index » General » Transformerland.com Feedback It is currently Fri Sep 21, 2018 9:35 am




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Accessories Database
PostPosted: Sat Jun 15, 2013 1:55 pm 
Offline
Custom Rank 4 U! Ask an Admin!
User avatar

Joined: Sun Mar 08, 2009 9:17 pm
Posts: 1168
I've always LOVED the accessories database on TFL. And you have no idea how much I wish there was a similar thing for the mountain of power rangers accessories I'm trying to identify.

I keep thinking I should simply start my own. But I have no idea how feasible that is. Any information on the TFL one was put together?

_________________
Want List
New Sales List


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jun 24, 2013 11:09 pm 
Offline
Father Time (Admin)
User avatar

Joined: Mon Dec 29, 2003 1:12 am
Posts: 6312
Location: 90377 Sedna
I'll let Trance share any info about the backend of the TFL archive, but I can tell you it involves a gazillion SQL database entries. I think we have something like 60k or 70k "toyids", a unique number assigned to each part, figure, set, package, etc. all with data describing them.

We at Transformerland-North have sold a couple MMPR collections (through eBay), and were surprised at how poorly documented such a popular series is.

There are two axes of toy archiving: accuracy and completeness. At TFL, we hold the highest standards for both before going public with an archive section. Typically, we aim for 100% accuracy and 80-90% completeness before releasing a series archive.

What I mean by accuracy is that someone who does not know a toyline can look at your page and determine correctly if anything is missing from a set. Catalog pictures won't do- oftentimes a gun is in its holster, a figure stand isn't shown, or something of the like. Sometimes it takes a lot of work to figure out what an uncommon figure actually came with.

Completeness is something a lot of archive really lack: they have great pictures of the the first ten figures in the line, but no information for the later four figures. We ran in to this frequently when researching TNMT. Anyone can tell you what Splinter or Raph came with, but who has accurate identification of the accessories from Road Ready Mutations Splinter? Not many.

If you wanted to start your own MMPR archive, you could do it simply by taking clean, clear pictures of each toy with its accessories, and titling and categorizing it. If your content is good, it's better so sift through lists of pictures than have no info at all. TFL-style archiving requires a lot more steps and backend work. If you feel you can put together a really nice archive for MMPR or even some subseries within the brand, we could talk about cooperating with you on such a project.

_________________
Image


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jun 25, 2013 1:48 pm 
Offline
Custom Rank 4 U! Ask an Admin!
User avatar

Joined: Sun Mar 08, 2009 9:17 pm
Posts: 1168
Sadly, all the power rangers stuff I deal with is used. So really I have no idea how accurate my identifications have been. I've joined multiple power rangers forums. And even there people haven't been able to find IDs for a lot of the pieces I'm highly confident are power rangers. I have found some sites that can give me specific individual figure names, sometimes with photos of the original sealed package. Some accessories can be seen in the package. And sometimes the actual title does turn up some results with google.

I may start on the process of photoing all the accessories I have on hand. But it will be slow going. I have limited time to spend on that.

I have never done anything with sql databases. Is there a way I can title and tag the photos I do take so they can simply be imported to such a database once I have a useful number of them done?

_________________
Want List
New Sales List


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group
Americanized by Maƫl Soucaze.