Integrating Data (overlaying as developer's call it ) onto maps (Google, yahoo) has become a fad these days, the applications range from trivial to Interesting.
By opening up their Mapping platforms Google and Yahoo, have given Interesting framework on which developers can build their applications.
In the same manner, Zoho creator offers end users a brand new way to perform basic CRUD operations using the web both as a database and for processing data.
Here I will briefly describe how I used Google Maps to Integrate with Zoho Creator,Using simple transformations with Yahoo pipes.
The application and its uses:
This Integration i.e Creator +Maps can be used in many ways
Tracking Inventory, tracking Human resources, Basic Travel maps or even geographic maps of movie theatres where a current movie is playing.
This application overlays Zoho creator data onto a Google Map i.e in this case Movie Theatres where a particular movie is playing shown on a Google map.
Zoho creator is used to update movie info using the UI or even Bulk upload and Google maps is used to overlay the data.
I also used the cool technology of Yahoo Pipes to basically transform the Feed generated by Zoho Creator.
Well let me just cut the nonsense and jump into nitty gritties…….
How I Built it.
Build a simple data entry application as shown i.e. which takes the theatre Name, Description and most importantly, a field called Latitude Longitude (point)
Allow the user to punch in the data, usually a movie fan or theatre owner using the ZOHO creator app UI, or even bulk upload an excel sheet ……
Copy the RSS feed generated, go to Yahoo pipes
Yahoo pipes gives users a very simple interface to transform RSS feeds here, simply add the feed generated by zoho creator and add the location extract module.
So that The RSS generated is GEO compatible i.e GEO RSS.
Please use the rename module to rename point as "georss:point"
Feel free to access the pipe :
You can see the GEO RSS specific data added to the feed in the debugger
Get the RSS feed from yahoo pipes
Generate a tinyurl using services like Tiny.cc for this RSS feed
Use this RSS feed as an Overlay for a google map i.e q= <>,or simply type the url as shown below
Here is the result
Enhancements that can be made:
PS: I honestly do not know whether ,any movie is playing in these theater's,Just a sample :)
Please comment .....