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”
Do you find it very difficult to engage in conversation with forum members and build trust? Are you facing the same problem that almost everyone faces with effective participation in forums?
Forums are a great way to gain trust, build readership to your blog and do almost anything to improve your business. You can now easily become friends with almost every forum member if you follow the 5 ways that are listed below.
1. Answer Questions
The best way you can build a relationship with forum members is by answering questions. Everyone likes to receive help. Check out the top forums. They have many questions that need answers. People are waiting to get help from someone. Why can’t it be you? Read the questions that are asked and answer them clearly. Don’t make it like a tweet with 140 characters. Please elaborate your answer. Make sure you are clear enough for the person to understand.
Continue reading “The Secrets to Building Relationship with Forum Members”
These days, many companies are devoting full time resources to monitoring and participating in social networks. As social sites grow in both size and quantity, it becomes increasingly difficult to keep up with the conversations that matter to your business. Six Apart, makers of the Movable Type blogging platform, are hoping their new Motion software is your solution to this problem.
Continue reading “Bring Social Network Back by Movable Type Motion”
You can lose a lot of money quickly with pay-per-click marketing if you don’t know what you’re doing. So following are a couple of things to consider. If both of them fall into place, then by all means, try PPC marketing.
2 Things to Consider Before Starting a Pay Per Click Campaign
Your Ad Budget: The beautiful thing about PPC marketing is that you don’t have to spend a lot to see results. In fact, you can start a PPC campaign for way less than a hundred bucks; really $50. A lot depends on your niche though. But if you learn the nuances of how to bid, you can get great results from a modest budget.
Before you dive into PPC, take the time to read Google’s Cost and Payment section. It is brief and is a great starting point (you should do more in-depth research if you’re new to PPC) to learning about how to price, bid, set a budget, etc.
Marketing Tip: No matter which type of marketing you indulge in, remember to only do marketing you can afford to repeat. Prospects have to see your ad 7 to 28 times, depending on which source you read, before they will act. So, if you run a PPC campaign for a week or even a month, it might not be long enough to assess whether it’s a good marketing option for you.
Whenever I buy advertising, I try to do at least three months. That’s usually long enough to give me some concrete stats to make some reasonable assessments.
Continue reading “2 Things to Consider Before Starting Pay Per Click Campaign”
While it is possible to find Office documents and PDF ebooks on the web using the filetype search operator of Google, this method has two drawbacks:
1. You need to download the document in order to view the contents as Google, for some reason, doesn’t provide the “View as HTML” function for all documents in search results.
2. The search syntax may sometimes get a bit complex especially when you want to search documents of multiple file extensions in the same query (example: invoice template filetype:doc OR filetype:pdf OR filetype:xls).
Enter DocJax – it’s a new document search engine built on top of search results aggregated from Yahoo and Google. DocJax will simultaneously search for documents of all popular formats (PDF, DOC, XLS and PPT) or you may limit results to any one of these file formats.
Continue reading “Search Documents with DocJax”
A new Firefox extension aptly named Flash Game Maximizer is a must-have for any Flash game enthusiast. It does one thing, and does it well: letting you toggle between standard- and full-screen modes on any gameâ€“regardless of whether it has been coded with such an option.
Considering that Flash games are hosted all over the place, and rarely with a ubiquitous user interface, you’re likely to run into a good number of them that must be played in whatever space they’ve been given on a Web page. With Flash Game Maximizer, however, you don’t have to worry about this at all.
Continue reading “Firefox Add-ons – Flash Game Maximizer”