Apr 01

Love it or hate it (hint: you should hate it), Transformers: Revenge of The Fallen was one of the most successful films of last year – having earned around $800 million at the time of writing. And it would probably never have happened, had it not been for a bunch of young men talking about toys on the internet in the mid 1990s.

Want to own every Optimus Prime ever made? You’ll need a few thousand pounds and a garage to keep them in. Picture: Ryan Yzquierdo, Seibertron.com

The precedent was set by enthusiastic discussion in the letters pages of the official Transformers comic, published by Marvel from 1984 until 1991. From this sprang unofficial fanclubs, gatherings and trading circles, all resolutely passionate about an ever-growing line of toys that changed from robots to vehicles (and assorted technology). How to obtain the rare ones, how to reconcile the huge contradictions between the storylines of the various comics and cartoon series, whether Grimlock could possibly beat Galvatron in a fair fight… Many of these enthusiasts also proved to be early adopters of internet discussion, creating a raft of fansites and bulletin boards in the mid-to-late 90s that finally allowed the global Transformers community to get together. Today, that’s grown into a clutch of professional, commercial sites that provide a growing army of fans with up-to-the-minute news about new figures or movie rumours, and extensive photo galleries of the rare toys they yearn to own. ” The fan websites themselves are very competitive in nature and we all strive to make the best sites available,” says Ryan Yzquierdo, owner of the enormous and award-winning US fansite Seibertron.com. “The online community consumes the information we provide as fast as possible and is extremely active.” From the outside looking in, it’s a bizarre phenomenon – so why did it happen?

Fanboy origins

“As its simplest concept Transformers aims at various things that boys, and indeed men, like: Robots, aliens, cars, planes,” thinks Steve Mapes, owner of www.transformertoys.co.uk, a respected British fansite that’s been active since 1999. “It then takes these interests and produces, in a toy form, basically two toys in one. Rather than buying a toy robot and a car, kids can have one toy that is both and changes between the two. This isn’t enough by itself though. There have been, and indeed still are, plenty of other transforming robot lines out there, none of which have been as popular or successfully marketed as the Transformers. A large part of this is the characters and fictional universe that has been shaped over the past 25 years.”

Comics, cartoons, most recently films have all contributed to a vast backstory for the entire range of toys. “It was really smart of the people involved with Transformers way back at the beginning to create stories and personalities for the individual Transformers,” thinks Yzquierdo. “These weren’t just ‘robots’… each of them was a living machine with a personality and abilities and skills. This allowed for people to connect to these unique characters in a way that wasn’t common with robot characters at the time. Because of this, people really bonded with the characters which creates a special loyalty to the characters, the products and ultimately the brand as a whole.”

Even though the brand regularly changed enormously, forever seeking to avoid the retail death that claims most toylines eventually. The blocky vehicles of the 80s became the more complicated but controversial bio-mechanical animals of the mid-90s Beast Wars, then a welcome return to vehicles with R.I.D., Armada and beyond, and now the hyper-realistic, hyper-detailed movie line toys. There isn’t any other action figure line that’s been as consistently successful, or that has drawn the attention of so many adults as well as children.

Classic characters like Megatron are regularly redesigned and updated, often purely to please old-school fans. Picture: Ryan Yzquierdo, Seibertron.com

Who, in turn, wanted to share their knowledge, opinions and collections with like-minded souls. It was in the Beast Wars era that the online community first really sprouted, but not always that happily. There was a deep division between a new generation of Transformers fans who loved the Beast-based toys and the surprisingly smart animated series, and the old guard who were outraged at the change from Optimus Prime to Optimus Primal. “Truck not monkey!” went the battlecry, referring to the hero Autobot leader’s reimagined ‘alt-mode’. Anger being one of the cornerstones of internet discussion, such conflict only grew – and to this day, some fansites refuse to acknowledge the existence of others. “Yeah, there’s still some of the typical internet drama from time-to-time, but for the most part I’d say that the community is pretty good natured,” says Seibertron.com’s Ryan Yzquierdo. “Except for when pics leak from the next new Transformers series. We all think it’s going to be the end of the brand, but then fully accept whatever the latest thing is after we realize just how cool it is.”

Fan collaboration

Indeed, the throughline of passion for the toys remained, however, and the Beast Wars era even saw the animated show’s creators fraternising with and seeking advice from long-term fans on forums. As the millennium ended, fandom boomed – and changed. “My brother and I created our first website Transformers At The Moon back in October 1999, a few months after getting internet access at home”, says Mapes. ” At the time we decided that there was a distinct lack of websites with photographs of the Transformers toys especially many that we owned at the time. One of the main things we would use the internet for at that time was to search for toys that we did have in our collection, especially the much sort after Japanese figures.” This is crucial to the continuance and rise of the random – without the internet, obtaining out-of-print or international-only Transformers was crushingly difficult. Suddenly, there was an easy way to obtain the impossible, and for collectors to thus have collections.

“eBay allowed people the opportunity to easily find desired products which they might have previously only been able to find at specialty shows” explains Ryan Yzquierdo. “It also allowed people to connect from all over the world. It made it easy for a guy in Canada to purchase a toy from someone in the Netherlands. I’ve always thought that accessibility to a product helps increase one’s loyalty to a product. If you can’t find what you want, you move on to something else. If you can easily buy something which interests you, it only encourages that person-to-product relationship, which I’m sure has helped out the Transformers brand over the years.”

Optimus Primal, figurehead of the Beast Wars line, did not satisfy many hardcore enthusiasts. Picture: Ryan Yzquierdo, Seibertron.com

There are layers and layers of figure rarity, meaning there are absurd treasure hunts where everyday collectors fear to tread. Steve Mapes is an particular aficionado of the Lucky Draw Transformers, a very limited, usually gold or silver chrome-coated toy variant that is produced in Japan exclusively as competition prizes – he runs another site specifically dedicated to these at www.luckydrawtransformers.com. “The figures themselves tend to turn up in Japan first and are then quickly snapped up by either Hong Kong or US collectors. Some find their way onto the Japanese Yahoo Auctions website where they are normally won by overseas bidders using bidding service accounts, however others are sold in stores in places like Akihabara. Due to the limited quantity, some can be limited to 3 in the world – these figures can fetch into four figures and so the dealers tend to contact people directly who they have dealt with in the past to see if they are interested in those items. If they are not, then they tend to end up on eBay. A lot of the time it is a case of contacting the right person at the right time and building up a good relationship with them.”

Changing faces

That’s the deepest depths of fandom, however, where it turns into industry as well as enthusiasm. What about the general online community? “It consists of all sorts of people now”, claims Ryan Yzquierdo. “I am fascinated at each annual Transformers convention at how the ‘face’ of the community has changed over the past 15 years. At one time, it consisted mostly of young men, maybe 18 to 25. Now, I see women, families, middle-aged people, tweens, and even some grandparents partaking in this hobby. Sure, it is still dominated by men in their 20s, but that majority has slipped dramatically over the past decade.” Mapes agrees that the demographic stereotypes are gradually eroding: “With people interacting more at a social networking levels real-world friendships are also on the rise and there have been relationships and indeed marriages that have come out of people meeting on message boards around the world with a common interest of Transformers.”

The Michael Bay films might have outraged critics, but they’ve certainly accelerated the growth of this online Transformers community. They’ve also changed it – change forever being a double-edged sword. “There is no denying that that have had a huge impact in changing what was, for many, a secret hobby or interest, into something that is perhaps a little more socially accepted” thinks Mapes. “You can walk down the street and see people walking around with Transformers symbols on their T-shirts, find merchandise in many more stores and see a line that was simply viewed as a kids’ line be discussed by people of a huge age range on message board and forums that are not specially related to Transformers.” The existing fans are split down the middle about this – half overjoyed that their hobby has been essentially validated by the mainstream (with a resultant explosion in available Transformers products), and half feeling it’s diminished and undermined, both by Bay’s insect-like redesigns of the characters they love, and by now having to share their special interest with the rest of the world.

Hasbro’s tendency to repaint and remodel its figures keeps completist fans out of pocket. Picture: Ryan Yzquierdo, Seibertron.com

At the same time, the 1980s ‘Generation One’ characters are regularly referenced and redesigned in new toys and comics, a direct result of Transformers owners Hasbro being well aware of the size and passion of the online community. They’re not just a bunch of silly, annoying men on the internet: they’re a force that has a large disposable income and that will spread hype for free. They’ve even managed to attract the attention of Michael Bay. The explosion-obsessed director largely seems unconcerned about honoring Transformers’ quarter-century history, but was swayed enough by online appeals to let Peter Cullen, the voice of Optimus Prime in the 1980s cartoon series, reprise the role in the two 21st century live-action movies. It may be easy to sneer at people who remain this fascinated by transforming robot toys even in adulthood – but there’s no denying the sheer potency of the online community they’ve created.

Mar 01

Spoiler warning – two of my least favourite words in the English language, not including phlogiston and topiary. They remind me of those signs that soulless bureaucrats put up in their windows; the kind with ‘Polite Notice’ written on them in the hope that passers-by will be robotic enough to file the inevitable pettiness that follows into the desired brain receptacle. In both cases, the qualifier is added for one reason alone: that deep down, the person knows that in a fair and just world, what they’re writing would earn them a well-deserved slap in the kisser.

Then they write it anyway.

The problem with a spoiler warning is that, almost by definition, it’s an admission that you’re in a place where readers shouldn’t have to worry about them. If you actively hunt them out, of course, you’ll get no sympathy from me. I don’t care how exciting the show or game is, you make your click, you make your choice. What annoys me to the point of absolute spitting fury is having an experience randomly ruined. Once, long ago, when dragons roamed the Earth and 56.6k modems had only just been invented, enjoying the latest shows, movies, games and novels the way their creators intended was as easy as avoiding forums for a while, or making it clear that any friends incapable of keeping their mouths shut would be having themselves a hot date with the business end of a blunt needle and length of black thread. Now, however, there’s always something exciting on the way, and avoiding unwanted info is next to impossible. The statute of limitations for spoilers seems to be roughly five picoseconds, especially for net-friendly shows like Lost. With Twitter, events can be spoiled in real-time.

Or faster, if The Pirate Bay’s minions are on the ball.

It doesn’t take much, and usually the guilty party isn’t even aware they’re doing it. They think that by writing ‘Spoiler Warning’ they’re doing their duty, oblivious to the fact that the eye doesn’t magically blank out everything except the currently focused word. Yes, the warning’s there, but like finding the words ‘Do not drink’ at the bottom of what turns out to be a tall glass of cool urine on a hot summer day, you’re still left with a foul taste in your mouth.

Personally speaking, when I’m looking forward to something, I like to go in knowing as little as possible. Something that sounds terrible in summary can work brilliantly when you have all the facts, and simply not knowing what to expect adds that all-important Christmas Eve excitement to getting your hands on something new. True, sometimes I crack; sometimes the nature of my job makes it impossible to know as little as I want to about what’s coming up over the next few months. But all things considered, ignorance is usually bliss. Last month, for instance, I dodged the spoiler gauntlet for both Mass Effect 2 and BioShock 2. The worlds, reveals, plot points, mechanics… all of them unfolded at the pace the creators intended. It wasn’t easy, but holding out was worth the effort.

What’s ironic is that it’s rarely the good bits that get directly spoiled. If someone really loves a twist, chances are they’ll hide it so everyone else has the same moment of realisation or discovery. True, you might find out that there’s a That Bit in the game/show/movie, or that (to borrow an IT Crowd line) There’s A Twist, but generally nothing specific, and nothing that ruins the experience. It’s when someone’s disappointed that you tend to get the dismissive, back-handed ‘Spoiler Warning: I was so cross when I found out it was Earth’ level variety.

These are spoilers in the purest sense – not just ruining the moment, but poisoning the whole experience. Even if it turns out to be great, that old saying about only having one chance to make a first impression is every bit as true for media as people. And of course, with people, you don’t have to spend up to £50 a shot to talk to them.

Not most people, anyway.

Until we have a magic helmet capable of zapping very specific memories, or some form of trebuchet-based justice system for dealing with persistent spoiler offenders, there’s really nothing that can be done about all this. If the occasional big release means becoming a temporary online hermit, so be it.

Still, I would politely urge that the next time you’re about to wax lyrical, check you’re in a spoiler-friendly place, and if not, don’t say anything you wouldn’t have wanted to read in advance yourself. The people you’re talking to have a right to enjoy things at the same pace. They may also have knives. Just a thought.

Oct 16

Data Mapping – Any-to-any Transformations Between Different Data Formats
Author: dinesh gupta

Data mappings can be done in a multiple ways using procedural code, creating XSLT transforms or by using graphical data mapping tools that robotically create executable transformation programs. Data Transformation is critical for data mapping and process integration. Data mapping engine in data transformation server to transform data between data source and destination.

Data mapping engage concurrently evaluating valid data values in two data formats using heuristics and statistics to automatically determine the complex mappings between two data sets. Data mapping engine in data transformation server includes complex data functions such as string, math, and conditional operations as well as DB and XML file look-up.

Data mapper, a graphical tool that enables visual and rapid specification of complex business rules in easy to understand English rather than code. It converts the code directly in to the pdf formats and supports handling and processing the large data files. Data mapper is very helpful in data mapping process to transform and synchronies the data in any formats.

Data mapping software maps data between any format of XML, database, flat file, EDI, Excel 2007 and any other Web services, It also offers a powerful middleware application to document, automate and perform critical data processes specially for creating and populating data marts from different internal or external data sources.

Data mapping software is capable to build so much information interactive is that it edge with so many interactive data mapping tools typically used by business organization to improve the business process. These data mapping tools helps organization to integrate, transport and organize the data in a very simple way.

About the Author:

Author is Internet Marketing professional, presently working with Adeptia, one of the leading enterprise software company offering business process management (BPM) software, data integration, data mapping, software over the globe.

For more information about data mapping Please download free data mapping software

Article Source: ArticlesBase.comData Mapping – Any-to-any Transformations Between Different Data Formats