Archive for office

MWLUG 2011: The Never Ending Integration Story: How to Integrate Your Lotus Notes, Domino, and LotusLive applications with Microsoft Office, .NET, and Lotus Symphony

August 26 2011

The Integration Story started in 1994, with the first ways to combine Lotus Notes and Lotus Ami Pro to create custom applications. In 2011, the Integration story is still going strong. This session will start with the basics and ramp up in skill and capabilities. We will show how to integrate Lotus Notes, Lotus Domino, XPages, and LotusLive applications with the tools on your user's machines: Microsoft Office, Microsoft .NET custom applications, , LibreOffice, Lotus Symphony, and more. We will look how the ODF and OOXML standards are changing the integration story and how they will impact you. You will walk out of the session with lots of sample code and extending your own integration story! MWLUG 2011: The Never Ending Integration Story View more presentations from John Head

IdoSphere: Super feats of integration: XPages with Symphony, SharePoint, and Office

February 16 2011

Super feats of integration x pages with symphony sharepoint and officeView more presentations from John Head. Demo files and more coming soon

JMP208 The Never Ending Integration Story: How to Integrate Your Lotus Notes, Domino, and LotusLive applications with Microsoft Office, .NET, and Lotus Symphony

January 30 2011

JMP208 The Never Ending Integration Story: How to Integrate Your Lotus Notes, Domino, and LotusLive applications with Microsoft Office, .NET, and Lotus SymphonyView more presentations from John Head. Downloads coming shortly

Yellow Day Release: Updated Contacts Experience

August 11 2010

In honor of Yellow Day, I am going to post a new version of the Contacts Experience. Here is what is new: - Support for Microsoft Office 2010 - Updates to Microsoft Office Label and Envelope Functionality - Started work on adding Label functionality - The beginnings of custom field functionality: The goal is to have custom templates that the user can select, but first we need custom fields. The first release just defines the basic fields and a way to customize them. More to come. I have also been working on the first release to support Symphony 3.X when it is embedded in Notes 8.5.2. While not coming on August 24th when Notes 8.5.2 ships, Symphony 3 will have an update toolkit for Notes. This will give us a bunch more functionality, including presentations and labels and envelopes. Enjoy Yellow Day!

OpenNTF Contacts Experience 8.5.1 V1 is available for download!

April 13 2010

You can get it here. For those curious, here is the Design Element listing of what is New and Updated from the default Contacts (pernames.ntf) template:

OpenNTF Contacts Experience Version 1.0 is coming ... and here is some proof!

April 12 2010

I swear, it's coming "Real Soon Now" ... Version 1.0 is just in final testing. And here is a preview of some of the features: Version 1.0 will be released here this week. I promise! :-) We won't be submitting this release to the catalog, we want to get some of the "Coming Soon" features done first.

PSC Getting Started Sample Database for Microsoft Office and Lotus Symphony Integration from Lotusphere 2010

February 8 2010

In both of my Lotusphere 2010 sessions, JMP106 “Kum Bah Yah” Meets “Lets Kick Butt” : The Integration of IBM Lotus Notes and Domino with Microsoft Office, .NET, and IBM Lotus Symphony and BP214 IBM Lotus Symphony : Finally, A Developer's Friend, we used the PSC Getting Started Sample Database. I promised to share it with everyone - and I apologize for the delay. This database has samples for the following technologies: Lotus Notes automating Microsoft Word Lotus Notes automating Microsoft Excel Lotus Notes automating Microsoft PowerPoint Lotus Notes automating Microsoft Project Lotus Notes automating Lotus Symphony Documents (UNO) Lotus Notes automating Lotus Symphony Spreadsheets (UNO) Lotus Notes automating Lotus Symphony Presentations (UNO) Lotus Notes automating Lotus Symphony Documents (LotusScript) Lotus Notes automating Lotus Symphony Spreadsheets (LotusScript) Lotus Notes automating Lotus Symphony Presentations (LotusScript) Visual Basic for Applications (VBA) reading Lotus

Doug Mahugh highlights the Microsoft Casestudy covering the OOXML Solution PSC built

November 18 2009

Doug Mahugh wrote some very nice things about myself and our new case study: PSC Group LLC is a Chicago-area professional services consulting firm, a Microsoft Gold Partner, an IBM partner, and active in a wide range of technology services and projects. I’ve gotten to know John Head, PSC’s Director of Enterprise Collaboration, fairly well through DII workshops and other activities, where he is a perennial force to be reckoned with. John’s a hands-on expert and is definitely not the kind of guy who ever leaves you wondering what he really thinks -- it’s great to get that kind of direct informed feedback when we participate in DII events. One of PSC’s clients is RDI (Research Director, Inc.), a Maryland-based radio-research consulting firm that analyzes, interprets and presents Arbitron audience research data for over 200 radio stations. RDI came to PSC with a problem: they had been using the same custom system for 10 years, and their needs had grown so much that it was taking three

PSC project highlighted in a new Microsoft Case Study that features OOXML

November 11 2009

A new Microsoft Case Study has been published that talks about Research Director, Inc., one of our customers. The case study features a solution that uses Microsoft Open Office XML (OOXML) to drastically reduce the amount of time it takes to produce hundreds of PowerPoint presentations. Here is a snippet of the case study: RDI develops slide templates that can be quickly customized with customer logos, colors, and themes, and then merged with the data in Open XML to create the Office PowerPoint 2007 presentation on a server. The system then notifies the user that the presentation is available for review. Using the new system, RDI can significantly reduce the time it takes to produce a data presentation. “We were able to improve the application performance so drastically by not having to automate PowerPoint, because it’s not involved until the user actually opens the file,” says John Head, Director of Enterprise Collaboration at PSC Group, LLC. “We couldn’t have done that without Open

TriStateLUG 2009 - Integration and Coexistence Session Slides and Demo Database

November 9 2009

Tri State Lug 2009 - Integration And Coexistence SessionView more documents from John Head. Demo database available for download here

UKLUG 2009 - Lotus Symphony and You : How to stop giving Microsoft your Money!

October 12 2009

Here are the slides from my session at UKLUG 2009 in Edinburgh, Scotland, UK last week. Uklug 2009 Lotus SymphonyView more documents from John Head. Demo databases can be downloaded here

MWLUG 2009 - Integration and Coexistance Slides and Demo Database

August 27 2009

MMLUG 2009 Integration And Coexistence SessionView more documents from John Head. Download the Demo Database here

Finding the silver lining in every black cloud - and why the Anonymous Coward has no place

May 13 2009

It has been a fairly interesting week in my world - and I want to highlight 3 events and two threads that tie them together. Those events are: 1. The closing of 3D Realms and what seems to be the end of the line for Duke Nukem Forever (4) 2. The Office 2007 Service Pack 2 inclusion of Open Document Format (ODF) support and the fallout surrounding 3. The relaunch of and the reaction in the Lotus bubble You might look at those three things and wonder what could ever tie them together. Funny, I found two consistent thoughts that came into my head as I read various sites and comment threads about all three. When did we all decide everything was negative? So those reading the blog subject might see the reference to a highly anticipated album, but it really is a thought that has been in my head lately. No matter the issue or topic, it seems that most people start out looking for what is wrong. How this will impact me negatively. What can I do to find fault and then poin

"And in this corner ..." - can you hear Michael Buffer introducing ODF vs. OOXML in the boxing ring?

May 6 2009

Last week, Microsoft released 2007 Microsoft Office System Service Pack 2. And boy are the sharks swimming in the water. Before I go on, I want to state where I stand - I really do not care about what games anyone wants to play when it comes to interoperability. Period. I have always been the guy who played in both sandboxes - Lotus and Microsoft. It started out as being the guy who figured out how to make Ami Pro drive Excel via DDE. Then it was Word Pro and Access. Office and Notes. Visual Studio.NET and Domino Web Services. SharePoint and Lotus Symphony. VSTO and XPages (coming to a user conference this August). I love being someone who isn't pigeon holed into one technology or camp. So as application automation morphs into document generation in the next couple of years - I want to work with both OOXML and ODF. PSC is already working with OOXML and ODF with our customers. In the end, I do not care which 'wins' Since the release of SP2, both IBM and Adobe have come out and been

Microsoft Releases Office 2007 SP2 - with ODF 1.1 Support

April 28 2009

After almost a year of waiting, Microsoft released the 2007 Office System Service Pack 2 today, which includes Open Document Format (ODF) 1.1 support in Microsoft Word, Excel, and PowerPoint. Here is the details: Save as ODF 1.1 for Word, Excel, and PowerPoint Save as PDF and XPS File format converter API Charting Object Model for Word and PowerPoint Cryptographic Agility Outlook Performance Office Service Pack Uninstall Tool Other enhancements of possible significance: SmartArt® Graphics & Charting Better rendering performance Better printing fidelity Fixes issues in the object model to achieve better parity with Office 2003 Improves the Edit Points feature. This enables more accurate shape editing and increased interoperability with Office 2003 Microsoft Office Access Lets you export reports to Microsoft Office Excel Fixes issues that occur in the import data wizards, Fixes issues in report printing and previewing Fixes issues in macros, in Excel integration, and in date fi

Lotus Developer 2009 Sessions on-line ... and I will be presenting 3

February 2 2009

I am excited to announce here on my blog that I will be doing three presentations at Lotus Developer 2009 in Boston on April 15th thru 17th, 2009. Get your taxes done early and come learn all about the Lotus product portfolio at Lotus Developer 2009 and Admin 2009. Here are the sessions I am giving: Integrating Lotus Symphony,, and Google Docs with Lotus Notes and Domino Go behind the scenes of Lotus Symphony and and learn how the Universal Network Objects (UNO) API provides development opportunities for very customized integration with external applications and data sources. Get the lowdown on using the new LotusScript LSX for Lotus Symphony, and see how to build additional functionality into Notes applications that provide access to Symphony objects, such as using Notes as the data source for a Lotus Symphony document Mail Merge. Walk through integration of web based document tools such as Google Docs and investigate how AJAX and Web 2.0 technologie

BP305: The Document Format Dance

January 21 2009

No matter your preference for OOXML, ODF, or PDF … the document standard requirements are going to become a fact of life for users of IBM Lotus Notes & IBM Lotus Domino in the next year. This sessoin will review the technical capabilities of all three formats and how they work with Lotus Software. We will check the format debate at the door and look at which format will provide you the functionality you need. We will then look at how you can generate all three documents from your applications using third-party tools and custom code. You will take home samples that allow you to export Lotus Notes data to OOXML, ODF, and PDF in LotusScript and Java – be prepared for a deep dive into code! Swan 1-2 : Wednesday, 1/21/2008 : 11:15 AM to 12:15 PM BP305: The Document Format DanceView more presentations or upload your own. (tags: ibm lotus)

Lotusphere 2009 Approved!

November 13 2008

I am a bit late to the blogging about these, but I had three Lotusphere 2009 session abstracts approved! First, we have the Jumpstart that Alex and I have given the past couple years Introduction to integration of Lotus Notes and Lotus Domino with Microsoft Office, .NET, and Lotus Symphony. The session has been completely revamped with all new demos and new technology demos including the integration of Google Docs with Notes and Domino applications and some intro samples around creating OOXML and ODF documents. This session has been popular in the past with a back to back repeat pre-scheduled. That is 4 hours of integration demos Sunday afternoon in Orlando to kick off the week. If we do that again this year and you see my Sunday night at the party or eating Ed's sushi at Kimono's after, you will understand why I am punchy :-) Second, I will be giving Lotus Symphony and You - A Developer's Perspective, which is a revamped version of my Irish Lotus User's Group session with less Execut

Thoughts on the Microsoft Office ODF Workshop

August 1 2008

This past Wednesday I attended the Microsoft Office ODF Workshop in Redmond, Washington. Microsoft called this workshop to have a public review of the work they are doing to implement the Open Document Format (ODF) 1.1 standard into Microsoft Office 2007 Service Pack 2. Before I go into some observations, I have to commend Microsoft on the level of technical detail and openness at this event provided. None of the executive marketing speak was present nor the 'there are no droids here' hand waving that I have gotten from Office PM's in the past at Microsoft events. We had a great conversation and got hands on access to the current ODF implementation. Two key things I walked away with from the event: 1. Microsoft is going to implement ODF to the letter of the spec (minus one public change which will be a custom namespace in Excel to handle macros). While multiple people admitted they wanted to make recommendations to enhance ODF in the future, the first implementation will be as exact

Shame on IBM - No presence at the Microsoft Office ODF Workshop

July 30 2008

One of the many shocks of the day at the Microsoft Office ODF Workshop is that no one from IBM is here. I know they were invited as the entire ODF Technical Council and OASIS groups were invited. I see folks from Novell and other companies. But not official IBM presence. Now, this might have just been a scheduling issue, but someone should have been here. Microsoft is running an event showing off Alpha code of Office 2007 SP2 without a NDA. They are being incredibly open (maybe more open than I have ever seen them) and IBM has no part in the conversation. Shame on you IBM.

At the Microsoft Office ODF Workshop today

July 30 2008

I am out in the Seattle area this week, and the main reason is that I am attending the Microsoft Office ODF Workshop today. The event should be interesting, as I will hear about the strategy of Microsoft Interoperability and the ability to play with the Office 2007 SP2 ODF beta hands on. The event is not covered by a NDA, so I will blog in detail about it tonight/tomorrow. Anyone have anything they would like me to ask or check?

I am humbled and honored ... Integra calls me the Leading Expert on Office Integration

February 27 2008

I think everyone gets that Integra and PSC are working very close together, but I have to say this shocked me. I did not write it and only had an editorial review once it was posted. I am honored and humbled by this sidebar on their web page: I started my path in the Notes world in 1993 with the integration of Notes with Ami Pro. That transitioned to SmartSuite. Then Office ... 5 versions and counting. Recently and Lotus Symphony. I look back at this journey and am very proud of the work I have done. Being called the "leading expert" and "Notes veteran" and being only 33 always makes me laugh. 2008 is all about taking this "leading expert" position and really turning that into a viable business. Integra is just the foundation that makes the integration projects and solutions easier to manage and build. This year is going to be very interesting ... To the Integra folks ... thank you very much for the kind words.