The spreadsheet component of Google Docs provides some useful functions for importing web data into your online documents. For instance, you can use the importFeeds function to manipulate RSS in Google Docs while the importHTML function helps you fetch information from a live web page into Google Docs.
The following Google Spreadsheet demonstrates how one can use these import functions in Google Docs to convert web addresses into tiny URLs on the fly. You may have to create a copy of this spreadsheet into your own Google Account for entering new data or for modifying the cell formulas.
This spreadsheet, written by bit.ly developers, makes a call to the bit.ly API as soon as a URL is entered by the user and displays the API response in the short URL column. Internally, it uses the importData function which is normally used to display CSV data in Google Docs.
Cell A1 (input field): User enters a URL
Cell B1 (result) =importData(concatenate(“http://api.bit.ly/shorten?longUrl=”,A1))
Continue reading “Google Docs convert web addresses into Tiny URLs”
Creating a video slideshow from photos is easy. Import your image collection into Photo Story (or Windows Movie Maker), choose a music track to play alongside the slideshow and render. Photo Story can even add that famous Ken Burns Effect that you may seen in some documentary videos on the History Channel.
The other alternative is to use a web application like Animoto that creates impressive MTV style videos in seconds. All it requires is a web browser and, unlike Photo Story that works only with local pictures, Animoto can even pull images directly from Flickr, Facebook, and other online photo sites.
The Problem with Photo Slideshow Software
While creating slideshows from scratch is simple, things get complex when you need to edit an existing photos slideshow. For instance, it might take lot of effort if you need to make small edits like changing the transition from fade to dissolve or replacing a couple of pictures with another set and so on.
Enter Stupeflix – it’s an online service that makes the task of creating and editing photo slideshows almost as simple as writing a basic HTML web page.
To get started, first upload all the images to Stupeflix and then add text captions (optional). Click generate and your slideshow video is ready for download in QuickTime MP4 format.
Continue reading “Stupeflix Photo Slideshows in Notepad”
As Microsoft prepare to release their Windows Mobile 6.5 OS update, they are also putting the final touches on the Windows Marketplace App store which should release at the same time as the 6.5 update.
As reported from Intomobile, Microsoft hope that their Marketplace will be a direct competitor to Apple’s App store. We reckon it will be sometime before Microsoft manage to achieve the same levels of success as Apple.
Continue reading “Looking for Microsoft Products? Go to Microsoft Marketplace”
It’s been reported that a developer has submitted a Adobe Mobile Flash Plug-in for use on the iPhone. Fans hoping for the plug-in to stay though might be disappointed as it breaks all kinds of agreements and may not get a public release.
As reported from PCMag, developer Jonah Grant submitted the Flash plug-in on Friday April 24th. One of the main problems that lies with his Flash plug-in is that the Apple developer agreements forbids the use of separate download code.
Continue reading “Adobe Mobile Flash Plugin for iPhone”
WordPress is a fantastically versatile blogging platform. It is fully capable of not only providing everything you need in a blog, but can be pushed even further to provide everything you need in a website, CMS, social network and all-in-one convection oven. Okay, maybe that last one was pushing it.
There are a lot of options available to you if you are looking to add some social media aspects to your WordPress blog or further extend the capabilities of WordPress as a social network. It is worth mentioning that the makers of WordPress have introduced a plugin for WPMU called buddypress which is geared towards building a social network with WordPress. But WordPress MU requires dedicated hosting and not all of us can afford that.
OpenId – If you want your users to register in order to post comments you may have an easier time getting users to sign up with an existing OpenId. OpenID is a universal authentication protocol that you can obtain from many major providers like WordPress.com and Yahoo. This plugin allows users to login with an Open ID to manage the blog or simply post a comment. The plugin also allows you to use your own WordPress blog as an Open ID provider so you can use it for other Open ID enabled sites.
Continue reading “Build interactive online community with WordPress plugins”