Thursday, July 25, 2013

Integrating Apache OpenOffice 4.0 with GMail using MAPI

Legend Netscape and Mozilla programmer Jamie Zawinski (aka JWZ) has  humorously stated in his Law on Software Development that "Every program attempts to expand until it can read mail. Those programs which cannot so expand are replaced by ones which can."

While the popular OpenOffice open source office suite did not yet "expand to do e-mail", it allows sending documents from the program interface using whatever e-mail client program is configured on your system, be it Mozilla's Thunderbird, or Microsoft's bundled Windows Mail, or the former Outlook Express, on Lotus Notes, or Eudora, you name it.

The problem comes, as one AOO user recently pointed, when you expect apps that can fire your e-mail client to "work with GMail". The problem is that GMail is not an application. GMail is a web site. You can have an application like Open Office call your default web browser, and even tell it to load GMail with a compose window opened, but you still can't tell the browser to attach a given file to your new composed e-mail. At least not without some "glue code".

Rob Weir explained: "there is an industry standard for accessing email:  MAPI(Messaging Application Programming Interface).  OpenOffice works with any application that supports MAPI.   Most email clients support MAPI.  GMail does not.  That is their choice.  We can't force them to support MAPI.  But we're not writing custom support for every email client in existence.  We support the standard. "

Thats where "TVHGoogleMAPI" comes in. It is an Apache-license open source project that makes GMail a registered "Simple MAPI" protocol handler on Windows. I have tested it with Windows 7 (64-bit edition) and I confirm that it works.



You can download this app from its Google Code project page at:
http://code.google.com/p/tvhgooglemapi/downloads/detail?name=tvhgooglemapisetup-0.4.exe

The install was painless to me. Just follow the dialogs and it configures itself automatically. It just places an icon available from the Start button to uninstall it. Other than that it seems to work automagically. ;)

Screenshots are included below:


1. You load a document on AOO 4.0 and click on File-Send-Send document as E-Mail

2. The TVHGoogleMAPI program will ask for your GMail account credentials. See the disclaimer at the end of this post about security concerns.

3. GMail opens up with your system default web browser with a GMail email compose window, and the AOO document attached to it.

4. If you have GMail configured to use the new UGLY GMail COMPOSE WINDOW this is what you will see.

5. The other user receives your attached AOO 4.0 document in his e-mail.


A SPECIAL NOTE ABOUT SECURITY:
This APP, AS ANY INTEMEDIARY APP, REQUESTS YOUR GOOGLE ACOUNT CREDENTIALS, AND OFERS TO SAVE THE DATA SO YOU ARE NOT PROMPTED EVERY TIME. THIS COULD BE A SECURITY CONCERN FOR SOME.

 I did test this app with a new GMail account, not using my main one. I am not the author of this linked application and I have not audited its source code. If you are concerned about this, you might want to create a secondary GMail account just for this use, or enable two-step authentication. Use the app at your own risk.

I hope this helps people wishing to integrate Apache Open Office with GMail.
FC

Thursday, July 11, 2013

Less is more

It should be an easy concept to grasp:
LESS LINES OF CODE EXECUTE FASTER THAN MORE LINES OF CODE

Yet, some people still need to see proof:

0. Win7 5x slower than XP
http://channel9.msdn.com/Forums/Coffeehouse/Test-shows-Windows-7-is-5x-slower-than-XP-in-UI-and-apps-load-slower-than-in-Vista

1. Vista: 25% slower than Windows XP
http://www.guardian.co.uk/technology/2007/dec/06/microsoft

" We did informal tests, booting both Vista and XP on the same hardware, and Vista was between 15% and 25% slower than XP in benchmarks"

2. Inforworld: WInXP slower than Windows 2000

"Waiting for Windows XP"
http://web.archive.org/web/20071012211343rn_1/www.infoworld.com/articles/tc/xml/01/10/29/011029tcwinxp.html


" as indicated by results of independent testing performed by CSA Research and confirmed by our work in the InfoWorld Test Center. Our tests of the multitasking capabilities of Windows XP and Windows 2000 demonstrated that under the same heavy load on identical hardware, Windows 2000 significantly outperformed Windows XP. In the most extreme scenario, our Windows XP system took nearly twice as long to complete a workload as did the Windows 2000 client"

3. Win2k slower than NT4...

Microsoft looks to bury test results that show NT is faster than Win2000
http://web.archive.org/web/20061022093046/www.infoworld.com/articles/op/xml/01/03/05/010305opcringely.html

"Microsoft recently threw around its weight -- and its fat wallet --
to squash an independent testing lab from publishing benchmark results
that the lab ran for InfoWorld's sister publication NetworkWorld. The test
demonstrated that SQL Server 7 runs nearly twice as fast on Windows NT
4.0 than it does on Windows 2000
."

FC