Tuesday, May 19, 2009

OffiSync - Integrate Google Docs with Microsoft Office

OffiSync is a plug-in for Microsoft Office 2003/2007 that integrates the office suite with Google Docs. You can open documents, spreadsheets and presentations already saved in Google Docs, edit them in Microsoft Office and save the files in Google Docs. The add-on creates a new revision of the document when you save it, but there's no option to automatically save the document periodically.


You can view the files from multiple Google accounts and Google Apps accounts, so the add-on is a good option to virtually merge your accounts. Since the plug-in doesn't offer all the features available in Google Docs, you'll still need to open the online interface to publish a document, to use gadgets in Google Spreadsheets or to collaborate with other users. While you can manage the collaborators in Microsoft Office, you can't collaborate in real-time and your changes will overwrite the changes made by your collaborators.


Despite its name, OffiSync doesn't actually sync Google Docs with your computer and it doesn't even show the most current version of a document, assuming that other people edited it after you opened the document in Microsoft Office.

It could be an option for those who aren't comfortable with using an online office application, but they want to backup the documents online. It's probably not a good idea to use it this way since Google Docs doesn't have all the features that are available in Microsoft Office and the documents won't look the same. In its current incarnation, the plug-in isn't very useful for those who use the collaboration features from Google Docs.

Here are some potential uses:

* create a document in Microsoft Word and quickly import it in Google Docs, without using the online interface
* open a document created in Google Docs to improve the layout before printing it
* use some functions from Microsoft Excel that aren't available in Google Spreadsheets

Monday, May 18, 2009

How to Use Google Docs Folders as Labels

Google Docs has a flexible system of organizing documents. While initially Google Docs used a labeling system similar to the one from Gmail, the current version combines the benefits of labels with the simplicity of folders. The interface names them folders, but they're actually hierarchical labels.

You can add a document to multiple folders without creating copies. Just go to "all items" and drag the document to more than one folder. Since the sidebar doesn't show subfolders, you can't drag the document to a subfolder.

What if you want to remove one of the labels? There's no interface option for this, but you can use this workaround: click on the label you want to remove in the sidebar and drag the document to one of the other labels. To remove all the labels, drag the document to "Items not in folders".


Google's hybrid between folders and labels still needs some improvement: subfolders are not displayed in the sidebar, you can't add multiple labels in a single step and it's not obvious that folders are actually labels.

Saturday, May 16, 2009

What's in Store for Google Search?

Google experiments with a lot of interesting new features, but not all of them are publicly available. A post from Google's blog inadvertently revealed some experiments, by showing a list of iterations for the "search options" feature released this week.

The initial concepts for the "search options" panel included a lot of interesting enhancements:

* grouping search results by topic
* grouping search results by people
* showing page previews for search results
* showing only pages that you've seen or pages you haven't seen before


Google has previously tested an interface that grouped search results in predefined categories like reference or reviews, but it's not clear if "group by topic" works in a similar way or it's a different approach. To search pages you've seen before, there's Google Web History, but it's very slow and the ranking algorithm needs a lot of improvement.

Wolfram Alpha, the Answer Engine

Wolfram|Alpha launched yesterday and it's an useful complement to a general-purpose search engine like Google. Wolfram|Alpha doesn't search the web, it uses data from authoritative databases and an engine powered by Mathematica to obtain the results.

"Wolfram|Alpha aims to bring expert-level knowledge and capabilities to the broadest possible range of people—spanning all professions and education levels. Our goal is to accept completely free-form input, and to serve as a knowledge engine that generates powerful results and presents them with maximum clarity," explains the "about" page.

Even if the homepage's simplicity reminds you of Google, it's a good idea to check the examples page before entering a query. Alpha can't handle any kind of query, so it's important to know its strengths: advanced Math calculations (graphs, equations, prime numbers computations, matrix operations), conversions, facts about weather, population, food, minerals, people, places.

You can enter simple things like numbers, dates, words, HTML color codes, chemical formulas and you'll get a lot of interesting information. The service shows intuitive visualizations and comparisons to better understand the information.





Wolfram|Alpha could be a great way to expand Google Calculator and other Google OneBoxes.

Friday, May 15, 2009

How to Customize or Disable Google Update

For regular users, having a silent application that constantly updates the browser is a good thing. There's no annoying interface that interrupts you to ask your permission before updating the application and you no longer have to manually check for updates. Unfortunately, Google Chrome's automatic updater is not a great feature if you have limited bandwidth or in an enterprise environment, since you can't customize it.

Now you can use the Group Policy Editor from Windows or add some Registry keys to customize Google Update. Google Update for Enterprise explains how you can import an administrative template in the Local Group Policy Editor (gpedit.msc) and change the auto-update check period or even disable the auto-updater.


You can configure separate policies for different Google applications, allow only manual updates and even prevent the applications from installing on your computer.

If your operating doesn't include a policy editor (Windows XP Home, Windows Vista Home), edit the Registry directly. Just create the following key:

HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Google\Update

and add two DWORD values:

AutoUpdateCheckPeriodMinutes - auto-update check interval (for example: 1440 to check for updates once a day)
DisableAutoUpdateChecksCheckboxValue - 1, if you want to disable the auto-updater; 0, if you want to enable it.

"We work hard to keep our users safe and secure when using our applications, and we believe that making sure users have the latest software available using automatic updates is a key component of that. However, we realize that there are situations where automatic updates may not be desirable so we wanted to provide the ability to control updates when necessary," says David Dorwin, from the Google Update Team.

Thursday, May 14, 2009

Google News Redesign

One year after testing a new interface for Google News, the Mountain View-based Internet giant Google launched the redesign. It's more cheerful and visually-rich than the previous design, section pages include more videos and photos, while most of the clutter has been removed.

Google News homepage


Sci-Tech section of Google News

The project that allowed people involved in a news story to post comments has been abandoned, but you can still read the last comments. It didn't scale, it was difficult to automate and the number of comments was too small to matter.

The last Google News comments

Wednesday, May 13, 2009

Migrate to Gmail from Hotmail, Yahoo Mail, AOL Mail

So you've finally decided to change your webmail service and migrate to Gmail, but you don't want to lose your old messages and the address book. Gmail offers a mail fetcher feature that works with all mail services that support POP, including Hotmail, but you can't use it for regular Yahoo Mail accounts.

As previously anticipated, Google released a tool that lets you import contacts and mail from popular services like Yahoo Mail, Hotmail, AOL Mail and from ISPs like Verizon, Comcast, Earthlink. If you don't see a tab titled "Accounts and import" in Gmail's settings, you need to wait until the new features are enabled in your account.



"It's much easier to make the transition now that you can bring along all your old email and contacts. You can even have your messages forwarded from your old account for 30 days, giving you time to take Gmail for a test drive while you make up your mind," suggests Google's blog.

The service is powered by TrueSwitch, which offers similar migration wizards for Hotmail and Yahoo Mail. Depending on the number of messages that are imported, the migration may take up to 2 days.