Archive for Integration

O365 Mail to Quickbase Integration Video

July 11 2016

The third in a series of demonstration videos, my coworker Ken Lamey shows our Microsoft Office365 and Quickbase integration services that PSC Group, LLC provides. Please enjoy the video - and feel free to contact me directly if you are interested in services like this with Quickbase! You can reach me at

Lotuphere2012: JMP304 - Master Class: Integration in the world of Social Business

January 18 2012

Jmp304View more presentations from John Head. You can get the Getting Started Database Here

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

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

August 3 2011

This is the integration session I gave at IamLUG 2011 IamLUG 2011: 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. "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!"

XPages and SharePoint working together? You Bet ... here is a video

February 17 2011

One of the best demos I saw at Lotusphere 2011 was an application that Stephan Wissel wrote. In preparation for my IdoSphere: Super Feats of Integration of XPages with Symphony, SharePoint, and Office session, I reached out to Stephan and asked if I could add his app to my demo warchest. To highlight the demo, here is a video: So what you can see is an XPages application consuming the SharePoint Lists web service that is standard in an SPS installation. Stephan than shows how you can display the data from the SharePoint list in the XPages application. This is not a rip and replace demo. This is the integration of these two technologies to build a killer application. Look for more in this space as the year progresses. Awsome work Stephan, thanks for letting me include your demo!

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

A shout out to some amazing coworkers at PSC

January 31 2011

I must take a moment from all of the Lotusphere 2011 craziness to thank some people at PSC who went out of their way to help Alex and I with our session demos yesterday. We do so many demos in our sessions (this year we did 26) that we ask the team back at PSC to help out. Since our integration demos reach across our IBM Lotus and Microsoft practices, there are a bunch of people to thank: Eric M. Andy S. Wil H. Tim M. Jimmy M. Andrew B. Rick P. Eric, Andy, and Wil spent hours and hours up until the session Sunday helping us get all of the advanced ODF and OOXML demos with .NET / C# and XPages. Tim and Jimmy worked on some of the demos we updated for this year. and Andrew and Rick supported their teams when Alex and I asked for help. I can not thank everyone on the team above enough. Alex and I need to do something special for Eric, Andy, and Wil - but I wanted to publically recognize all of them. Thanks guys!


January 30 2011

In our Lotusphere Session today, Alex Kassabov and myself announced a new PSC website that will be going live in the middle of Feburary. I started talking publically about integration topics in 1996 at Lotusphere. That message has been delivered for the past 15 years at Lotusphere, Advisor, View, and LUGs all over the world. It started with integration of Lotus Notes with Lotus SmartSuite. We added Microsoft Office integration in 2000 and and Lotus Symphony in the past 6 years. Alex joined me in 2003 at the sessions, but we always find a gap between conferences and articles. So what we are going to do is launch the site and record all of our existing demos over the past 15 years. Each demo will have a video, files to download, and a discussion area. That will take us to about 50 demos. And then the fun begins. We are going to put together demonstrations of integration that extend past the topics we can fit in a hour session or two hour jumpstart. XPages and Salesforce

John Speaks 2010: Integration Session at MWLUG

July 20 2010

August is a busy month for the user groups. On August 19th and 20th, MWLUG hits Cleveland. I will be doing one session “Kum Bah Yah” Meets “Let's Kick Butt”: The Integration of IBM Lotus Notes and Lotus Domino with Microsoft Office, .NET, and IBM Lotus Symphony: Welcome to 2010, where Lotus Notes and Domino are just part of your corporate toolset. This session will introduce you to integration of Lotus Notes and Domino 8.5 with Microsoft Office, .NET technologies,, & Lotus Symphony. We'll start with the basics and build up to mail merge, exporting to a spreadsheet, charting, presentations, and integration on the Web. Advanced topics such as Visual Studio Tools for Office, advanced development with C#, and integration with Lotus Domino Web Services are included. Integration with Xpages, Google Docs, Sharepoint, ODF, OOXML, and Windows Explorer will highlight the options available. Every sample is new or updated, so even past attendees will get something from this sess

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:

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

Announcing the Contacts Experience project!

November 18 2009

For those of you that have attended any of the integration sessions I have given this year (and years before), I have a demo database that has very specific feature demos for integration topics. I make sure the slides and demo numbers match the demo database. Attendees have told me they love the demo database because it is organized and each demo is self contained. So while I will not stop doing this demo database, I have wanted to do something a bit more usable for a while. So in an effort to rebuild the Integration and Symphony sessions at Lotusphere that I will be giving, we are going to take a new approach. So enters the Contacts Experience project. I have always wanted to extend the Contacts application with real world, usable features. I didn't got that route as the templates were not distributable (officially), but now they are. So for the Lotusphere sessions, we are going to build functionality that an end user can use AND highlight integration functionality. Advan

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

IamLUG 2009 - Integration and Coexistence: Leveraging Lotus and Microsoft products to build better solutions : Slides and Demo database

August 4 2009

In the real world, you use both Lotus and Microsoft technologies in your environment. You do not want to be in the middle of a product selection war, you want to solve your business problems. This session will show you how to integrate Lotus and Microsoft technologies, including: Lotus Notes Lotus Domino Lotus Symphony Microsoft Office Microsoft .NET Microsoft SharePoint You will go home with real world samples and lots of tips and techniques. Iam Lug 2009 Integration And Coexistence SessionView more documents from John Head. Download the demo database here.

PSC sponsoring IamLUG, John and Alex speaking on Integration

June 23 2009

I am happy to announce that PSC is one of the Gold sponsors for the first I am Lotus User Group (IamLUG) in St. Louis on August 3rd and 4th, 2009. PSC will have a booth and we hope to have some very cool friends joining us (more on that later). Alex and I are also doing an version of our Lotusphere presentation on Notes/Domino and Integration with Microsoft Technologies and Lotus Symphony: Integration and Coexistence: Leveraging Lotus and Microsoft products to build better solutions In the real world, you use both Lotus and Microsoft technologies in your environment. You do not want to be in the middle of a product selection war, you want to solve your business problems. This session will show you how to integrate Lotus and Microsoft technologies, including: - Lotus Notes - Lotus Domino - Lotus Symphony - Microsoft Office - Microsoft .NET - Microsoft SharePoint You will go home with real world samples and lots of tips and techniques. We are going to use this conference to debut s

Want a preview of our Integration Jumpstart at Lotusphere? Attend the Virtual User Group Meeting Wendesday!

January 13 2009

If you would like a preview of JumpStart 205 - Integration of IBM Lotus Notes and Lotus Domino with Microsoft Office, .NET, and IBM Lotus Symphony that Alex Kassabov and myself are giving at Lotusphere 2009 (twice) ... or you are not attending Lotusphere 2009 and want to hear all about Integration in the real world ... or can't get enough of myself and Alex talking about Microsoft Office,, and Lotus Symphony, please attend our Virtual User Group meeting on this Wednesday. The Real World of Integration: How Lotus Notes & Domino Can Work with Microsoft Office, Lotus Symphony and the Power of Integra for Notes Presentation: January 14, 2009 at 12:00 pm Eastern (-5 GMT) Presented by: Presented by John Head and Alex Kassabov Modertated Topic Forum: week of January 12, 2009 We are doing 6 demos and taking questions ... not just in the user meeting but also in the forum all week long. Look forward to seeing you on the meeting!

Integration Custom Development - Why are you not using a framework?

October 6 2008

At UKLUG, as people came to the Integra booth, the topic of custom development came up over and over. We call it 'in-applicaiton development' - where you the developer write code in Script Libraries and/or Agents that connects Notes to the third-party application. Over and over, the issues of proper Notes application development and how hard it was just to add a new column to a report. I know these issues well ... since I have experienced them since 1993! I have 15 years of battle scars on the pain that in-application can cause. Products like Integra make your integration development less of a burden. Instead of having all of your code within each Notes database, Integra locates all of the code, templates, and logic with the report Profile in the Integra database. They only impact to your application is an action button or hot spot that a user can use to trigger the report recreation (which is 100% optional). If you are interested in more information about how Integra can ease your i

New Whitepaper: Off-the-Shelf or Custom Development

May 27 2008

I am releasing a new white paper I wrote that covers the reasons on why I have been endorsing the move from being an advocate of pure custom development to supporting the use of a framework and/or a product. This white paper discusses my journey to find Integra for Notes and my personal experiences with the world of integrating IBM Lotus Notes and Domino with Microsoft Office,, and Lotus Symphony. You can download the PDF of the white paper here: Off-the-Shelf or Custom Development: How Frameworks Can Save the Day I look forward to feedback and thoughts! Printed copies will be available at ILUG 2008 next week.

PAC and how Rocky and I pushed the Notes Integration world forward

April 16 2008

One of the things that I remember fondly from my time at Synergistics (read here for that story) was working on the Prevail Correspondence Engine and the Prevail Application Connector, or PAC. In fall of 1999, Synergistics decided they needed to add a real mail merge, envelope, and label engine to their SFA/CRM tool. Rocky and I knew each other from the Ami Pro forums on CompuServe. Both had seen or heard of me speaking at Lotusphere on Notes and SmartSuite integration, and I was just getting into integration with Microsoft Office. I was at Boom Vang, so they hired me to do a consulting project. Rocky and I built what I believe was the first commercial, real-world Notes to Microsoft Word integration tool. It was all soft-coded and super fast. We were doing testing of tens of thousands of contacts. While there were a couple of iterations of it, we really hit that first release solid. I was, and to this day, am very proud of that code. Now, Integra for Notes does all of the mail merge an

Integra thought for the Week: No impact to your applications

March 17 2008

One of the features of Integra for Notes that seems to really impress people (including one of the major bloggers in the Lotus community last week) is the fact that Integra has no impact on your applications. What does this mean? First, Integra is a single Notes application/database that gets installed on your server. You create that application/database from the supplied template. You setup the ACL and you are good to go. One the desktop, if desired, you can push out an icon that gets added to the toolbar. This is not a necessary feature, but many use it. No client install, but a process that sends a link to the users that they click. Next time the start Notes, the Integra Icon is added to their toolbar. Administrator function within Integra for Notes to send an email to users to install the Toolbar icon What the user sees when they click the URL link ... Integra Icon added to Notes 8.0.X toolbar The other aspect of this is the entire Integra report, called a Profile, is se

Why Integra?

March 10 2008

Since Lotusphere and the announcements between Integra and PSC came out, I have gotten quite a few questions that boil down to "John, why do you like Integra for Notes?" So I figured this was perfect blog fodder. It gives me something to write about on a regular basis and its a topic (integration of Notes with Office and Symphony/ that I can really provide value. So the goal going forward will be to have a new post every Monday. Let's see how well I can do on this. So to kick this off, one of the man reasons I like Integra for Notes, and why you should be using it as your integration framework, is that it provides reporting and integration almost everywhere. Not only does it integrate with Microsoft Word and Microsoft Excel (or Lotus Symphony Spreadsheets for the Integra for Notes Symphony Edition), it also provides Export and Import support for CSV and text files, as well as Export for XML. These Export and Import report profiles run on the Notes client, scheduled

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.

Listen to me on Taking Notes

February 16 2008

Listen to myself, along with John de Gorgio talk with Bruce and Julian on the Taking Notes podcast: Taking Notes Episode 76: 2008.02.16 - Reporting and Notes integration with MS Office and Lotus Symphony with Integra and PSC February 16th, 2008 Bruce and Julian talk with John Head from The PSC Group and John de Gorgio from Integra4Notes where we talked about: * Using Integra4Notes to generaated pixel perfect reports from Notes * Integra4Notes Personal Edition - FREE * Lotus Symphony * Some predictions about Lotus Symphony * and much more This podcast was sponsored by Instant Technologies. It is 20.7mb and runs 45:08 minutes at 64kps. Thanks for chatting with us guys. Podcast sounds really great!

Integra and PSC plan to target the US and Candian market

February 12 2008

I am super excited to share this: PSC Becomes Integra for Notes Premier Partner for the United States and Canada CONTACT: David Hough 847.517.7200 Chicago, IL & Malta - February 6, 2008 PSC Group, LLC. (PSC) and Shireburn Software Ltd announced today that PSC has been appointed the Premier Partner of the Integra for Notes line of products for the United States and Canada. Integra for Notes is the leading Lotus Notes® to Microsoft Office® Integration solution. PSC will be providing sales and support as well as integration services to new and existing customers. "Integra for Notes, is already widely used in the USA with customers including Behr America, the US Navy, Air Force & Army, CB&I, Hertz and VF Corporation. By combining the Integra for Notes platform with services from PSC, an organization with great experience in Notes-to-Office integration, jointly, we bring the broadest platform for implementation of Notes-to-Office integration o

BP215 Integration of IBM Lotus Notes 8 with IBM Lotus Symphony and

January 22 2008

BP215 Integration of IBM Lotus Notes 8 with IBM Lotus Symphony and Speaker: John Head SW Osprey - Tuesday 1:30pm - 2:30pm The inclusion of Lotus Symphony (productivity editors) with IBM Lotus Notes 8 and the release of the IBM Lotus Symphony product bring new and exciting integration options for Lotus Notes users and developers. This session will cover the integration options available today, including client provisioning of the Lotus Symphony editors. Inclusion of the editors in Composite Applications will demonstrate the programmatic options. This session will also cover integration of with Lotus Notes 8 and the development options available. Applications such as export, charting, and mail merge will be explored. This session will wrap up with a preview of integration options with Lotus Notes 8 and the editors as well as Lotus Symphony coming in future versions of Lotus Notes! Expect lots of code and take-home applications. | View | Upload your own

Visual Studio 2008 and .NET Framework 3.5 to ship November 2007

November 5 2007

I just read that Microsoft announced that Visual Studio 2008 and the .NET Framework 3.5 will finally ship this month. While the updates to the core development environment are greatly anticipated .. I mean, VS.NET is the standard that all IDEs need to live up too. The real impact of this release is Visual Studio Tools for Office (VSTO) 3.0. No separate download. No halfass (cough VSTO 2 cough) implementation. This is full support for Office 2003 and the 2007 Office platform. Office development is about to change forever. While not the complete removal of VBA development inside an Office application, this is the beginning of the move. This will fundamentally change Office Business Applications (OBA). It also has direct impact on those of us that integrate Office, Sharepoint, and other Microsoft technologies with Lotus Notes and Domino. Want to learn the details of those changes? Come to the Jumpstart that Alex Kassabov and I are giving at Lotusphere. VB.NET 2008 and VSTO 3 will be disc

John Speaks 2008: Lotusphere 2008 Sessions

November 2 2007

Today the official emails went out for Lotusphere2008 Session abstract approvals. I do not see any statement where I can not announce these, so here we go :-) I have three sessions this year: Jumpstart: Introduction to IBM Lotus Notes and IBM Lotus Domino Integration with Desktop Applications (which includes Office, Symphony,, and some other things like BIRT) Best Practices: Integration of IBM Lotus Notes 8 with the IBM Lotus Symphony and Best Practices: IBM Lotus Notes 8 and IBM Lotus Expeditor Customization for LotusScript Developers (which will include Composite Applications, Sidebar, and Menu Plug-ins) I am excited to be joined by Alex Kassabov, Vice President of Collaboration, on the Jumpstart and the Expeditor Customization sessions. See you in Orlando in January!

Integra 4.5 has been released!

October 3 2007

Integra for Notes 4.5 has been annouced. Here is the press release: Integra4Notes releases new version 4.5 Inline with ND8 Functionality, Embedded PDF Creator and Enhanced GUI and Integra Quick Reports Gets Major Productivity Enhancements Integra4Notes, the award winning Notes to Office integration and reporting product, has released version 4.5 which delivers ND8 compatibility, further enhancements to reporting across multiple databases and other productivity improvements for users that wish to extract data from their Lotus Notes applications to the Microsoft Office suite. Full features and benefits and a free 15-day download of the product is available immediately. This version is compatible with IBM Lotus Notes 8 and Office 2007 and new features include an integral PDF writer and improvements to the DbLookup wizard in the Integra profile. New functionality in Integra Quick Reports delivers the ability to generate ad-hoc reports from multiple databases. The products have been deve

IBM needs to stop kidding themselves about Notes and ISV relations

July 12 2007

Today I read something that made me react so strongly I had to write here about. I read a comment that Volker Weber wrote on Ed Brill 's blog. And I found something I completely agree with. With email, c&s, contacts I also see other reasons, to name only one: ubiquitous support for Outlook/Exchange in mobile devices or CRM applications Volker is 1000% correct. IBM has had their heads buried in the sand with this issue for years. Sales says its an ISV issue. The IBM ISV team is so focused on Anti-virus and Backup that they forget the other stuff. There are so many companies out there that have products and software and have no or horrible support for Notes. Cardscan, Plaxo, LinkedIn, OpenTable, and the list goes on. They have Outlook importing and/or synching right on their pages. These products even build Outlook integration points that bring the two close together. None of that for Notes. This is hurting and causing IBM to lose Notes customers. I have personally witnessed this.

Lotus Developer 2007 Demo Databases

June 12 2007

All of the demo databases from my 3 sessions at last week's Lotus Developer 2007 have been posted. Please find them at the links below: Unlock the Power of the Desktop with Microsoft Office/Lotus Notes Integration Give your Notes users functionality and capabilities that they depend on including: mail merge, charting, exporting, pdf generation, and reporting all within a familiar interface. This session will provide you with a solid introduction to working with Microsoft Office as well as different uses of the unique Office Integration capabilities available to Domino developers. Learn new techniques to organize Mail Merges for the Personal Name & Address Book, chart any view with a single click. For those that prefer to use supported applications in their environment, we will review products that provide Office Integration to easy reporting and document generation. In addition, leave this session equipped with a functioning Mail Merge Application, a charting of any Notes View ap

ILUG 2007 Presentation - the Lotus Geek Version

May 21 2007

I would like to take a moment and thank Rocky Oliver, our communities Lotus Geek, for stepping in to present my session on Friday afternoon at ILUG2007. Rocky and I have co presented on this subject a couple times. If I could ask for anyone to fill in my shoes, Rock is the man. Due to a couple of limitations (like the version of Microsoft Office he has installed), he will not be showing two of the demos in the presentation. The Microsoft Project and XML and Excel demos will be skipped. What I will do for those users is to write blog articles about each one after the Lotus Developer 2007 seminar. This way you will still get the info. If anyone is at the session, please make sure to pass that information along. Also, on Friday I will post the slides and demo file. Thanks again Rocky ... I owe you one!

Integra for Notes - Some great demos!

May 7 2007

The folks over at Integra have put together some great demos on how Integra for Notes works and what you can do with the product. I get asked quite often about the capabilities of the product and why did I and PSC pick to endorse and sell Integra. These give just a glimpse into the decision If you see me speak at ILUG or Lotus Developer 2007, those reasons will become more obvious. I plan on blogging about Integra much more as we get closer to those events. For now, enjoy these demos: Short Demo End-User perspective. How to Time - Link - Launch Reports (SmartIcon - no design changes) 1.02 Click here Launch Reports with Action Button 1.08 Click here "Send Customer Statement" - Example Report / Workflow - New 1.17 Click here "Make Quotation" - Example Report / Workflow - New 0.59 Click here Create Ad-Hoc reports (With Integra Quick Reports) 2.57 Click here Create Ad-Hoc reports (With Integra Quick Reports via Web) 2.23 Click here Do a Mail Merge, on-the-fly

Determining the version of Microsoft Office from LotusScript

April 21 2007

So I saw a posting on the LDD Notes 6 & 7 forum on how to determine the version of Microsoft Office installed on the user's machine via LotusScript. The way that I do it is with a custom function I wrote: .lotusscript { font-family: sans-serif; font-size: 9pt; color: black; } .ls-comment { color: green; } .ls-quote { color: black; } .ls-datatype { color: black; } .ls-operator { color: blue; } .ls-keyword { color: blue; } .ls-statement { color: blue; } .ls-function { color: blue; } .ls-class { color: black; } .ls-constant { color: purple; } Function OfficeVersion As String On Error Goto ErrorHandling Dim hwd as variant Print "Checking Version of Microsoft Office ..." Set hwd = CreateObject("Word.Application") If hwd.version = "9.0" Then OfficeVersion = "2000" Elseif hwd.version = "10.0" Then OfficeVersion = "XP" Elseif hwd.version = "11.0" Th 2.2 Released

March 30 2007

From the website ... Press Release - 2.2 29 March 13:00 UTC The Community announce the release of 2.2, the latest version of the leading open-source office suite. With upgrades to its word processor, spreadsheet, presentations, and database software, the free software package provides a real alternative to Microsoft's recently-released Office 2007 product - and an easier upgrade path for existing Microsoft Office users. 2.2 also protects users from newly discovered vulnerabilities, where users' PCs could be open to attack if they opened documents from, or accessed web sites set up by, malicious individuals. In version 2.2, users will immediately notice the improvement in the quality of text display in all parts of The reason for this is that the previously optional support for kerning, a technique to improve the appearance of text written in proportional fonts, has now been enabled by defaul

Big Announcement - PSC and Integra4Notes announce Partnership

February 28 2007

I am so pleased to be able to make this announcement: Integra4Notes Partners Up With PSC Group CONTACT: David Hough 847.517.7200 Chicago, IL - February 28, 2007 Integra4Notes, the Microsoft Office integration and reporting tool for IBM’s Lotus Notes environment, has announced the forming of a strategic and commercial partnership with PSC Group LLC, the IT and professional services consultancy and Lotus Award 2007 winners, to introduce Integra4Notes to its existing and potential customer base. Integra4Notes delivers automated integration with Microsoft Office and enhances printing, reporting and analysis of data contained within the Lotus Notes environment allowing users, developers and administrators to generate reports to Office without modifying the design of their databases and without the need to install files on Domino servers or local machines. John D. Head, development manager at PSC and globally respected expert in Microsoft Office inte

"John Speaks 2007" - Irish Lotus User Group

February 19 2007

The first of many annoucments of the "John Speaks 2007" tour is the amazing Irish Lotus User Group in Dublin on May 24th and 25th. I am proud to be one of the speakers at the event, at the request of Paul Mooney, on the following topic: Session: The Magic of Integration and the revealing of what's behind the curtain : Microsoft Office and IBM Lotus Notes and Domino integration Microsoft Office 2007 and Lotus Notes 8 will bring a new level of integration possibilities to the Lotus Notes and Domino world. This session will look at the new functionality in Office 2007, such as the Office Ribbon and OpenXML file formats. We will discuss the impact on Mail Merge, data transfer, and how this will impact your applications and development. We will also look at the updated Visual Studio Tools for Office 2007. This session will also look at Lotus Notes 8 and it's impact on integration. The session starts at the beginning ... and then dives deep into the integration possiblities. While this

BP205: The Integration Revolution - Microsoft Office with IBM Lotus Notes and Domino

January 24 2007

I really enjoyed this session ... I hope all of you did as well. I covered integration with Notes and Microsoft Word, Mail Merge, Microsoft Excel, Microsoft PowerPoint, Microsoft Project, XML, Web Services, Microsoft InfoPath, and Microsoft Visual Studio Tools for Office. You can find the slides and demo files below: Presentation Demo Databases

My Lotusphere 2007 sessions

November 9 2006

I just received word that I will be doing two sessions at Lotusphere 2007. They are: The Integration Revolution: Microsoft Office 2007 with IBM Lotus Notes and Domino Integration of OpenOffice and IBM Lotus Notes and Domino The Office 2007 session is all new content ... lots of Microsoft Project and Visual Studio Tools for Office SE stuff in there. The OpenOffice session will be a collaboration of myself and Alan Bell. We both are excited about new content and there is a surprise piece at the end ... I hope to share more about that before the conference! See you there!

SnTT: The ins and outs of ILDDM Binder and Document Security

October 26 2006

I have not done a SnTT post in a while, but I figured this one was something people could use. For the past couple of months, I have been waging a war against IBM Lotus Domino Document Manager ... otherwise known and Domino.Doc. I am working on a client project that is built around the New Product submission idea, but using ILDDM as the way to store the documents. We have lots of documents in the system, from Office to editable PDFs to artwork designed on the Mac to Autocad drawings. Our system allows for the attachments to be put thru workflow (for comments, editing, and approval), but we store everything in ILDDM. Because of the lack of robust workflow in ILDDM, we are using our own enTouch.workflow product. What that means is that we have a document stub that goes thru our workflow, which links to the ILDDM document. Because of the nature of this process, security is very tight. Add in the difficulty of no ILDDM API on the Mac (today) and the lack of any good way to set security o

Lotus Advisor Summit - SIL315 - Integrate OpenOffice with Lotus Notes/Domino

August 31 2006

SIL315 - Integrate OpenOffice with Lotus Notes/Domino With OpenOffice, you can give users word processing, spreadsheet, presentation applications, and more, for free! And, you can integrate OpenOffice with Lotus Notes and Domino for powerful productivity. In this session you'll begin with the basics. Then you'll look at LotusScript and Java techniques to include OpenOffice in your applications. You'll demystify the process of using OpenOffice API via COM. You'll take away examples of form building, mail merge, and charting. You'll also learn about IBM productivity applications and what the future might deliver. Slides Demo Files

Lotus Advisor Summit - SIL308 - Microsoft Office Integration with Lotus Notes/Domino

August 30 2006

SIL308 - Microsoft Office Integration with Lotus Notes/Domino When users require more functionality than Lotus Notes can provide, integrating Notes, Domino and Microsoft Office can be the solution. In this session you'll learn how to start an integration project and put in place the beginning pieces. You'll see how to add mail merge functionality to Notes' Personal Name and Address Book. You'll move on to more complex integration with Microsoft Excel and PowerPoint. You'll see how to use Domino 7 Web Services with Microsoft Office to build a new generation of applications. This session is for those experienced in LotusScript; expect lots of code! Slides Demo Database

Knee Deep in MS Project Integration

July 13 2006

One of the many projects I am juggling these days is adding import and export to Microsoft Project to PSC's enTouch.project application. Besides Microsoft Visio, working with MS Project is one of the hardest applications to integrate with Notes. I find the API for MS Project to be quirky at best. Just creating a new, blank project is more work than it should be. Today, what is driving me a bit batty is making the predecessors functionality in our application and MS Project synch up. I have to do a couple passes thru the data to get it all working correctly. What this means outside of this client project is that I will finally have some great MS Project code to talk about in my Integration presentations. I will also be posting some of that on here for everyone to read. I am thinking of building an example that would export and import Tasks in a user's mail file into MS Project. That seems to be a demo that everyone could work with ... we all have a mail file. Any other ideas? T

I finally post an Project ...

April 18 2006

So after an announcement at Lotusphere and lots of prodding by Bruce, I have finally gotten my first project for published. You would think that hosting the server would be enough ... but NO! :) Since I showed a version that I am willing to distribute at Advisor Summit last week, time to share :) Template Installer for Office and OpenOffice stores all of your Office and OpenOffice templates. It provides administrator control of those templates and an easy way to a user to install them. The first version only supports templates that a user installs on their machine. The goal is to also allow the database to be the central repository for application templates, such as mail merge letters and label templates. Please check it out and let me know what you think. I have another version coming pretty soon. I am also working on the beginnings of another project. Export Tools will be a rewrite of the Excel Export application I have shown the past two years. It w

LotusUserGroup.Org Topic Forum: Microsoft Integration

February 28 2006

I am hosting a topic forum over at this week on Microsoft Integration: Notes/Domino integration with Microsoft Office - moderated week of February 27, 2006 The two companies may compete, but you and your users need these applications to work together. This week feel free to ask questions about the built-in Microsoft Office integration with Notes and Domino, as well as programmability options and techniques. Feel free to join me over there and ask questions!

MS Office Constants Database Redux

January 31 2006

I demonstrated this during the Lotusphere 2006 Jumpstart session I did on Integration, and a gentleman by the name of John Coolidge was in the front row. He commented he worked with Tom Duff to make the database. The version I had (and Tom is linking to) only had Office 2000 and Office XP (2002) constants in the database. John read my blog comment and we emailed. I volunteered to host the current version (its really big now ... 5+ megs zipped). This version adds Office 2003 constants and another neat feature. Go to the LSS view and click the Export button. You will get a MS Excel listing of all of the constants in a manner you can use as an Include file in LotusScript. I have a couple ideas of how to improve this, but this is a great start. Thanks John! MS Office Constants Database - 1.31.2006

My first project - Template Control

January 27 2006

Bruce has been nagging me for quite a while to get with the OpenNTF program (I figured hosting it was enough), so here goes. At Lotusphere in my BP309 session, I showed off a Notes application that allows for the management of Microsoft Office and template files. The first version has a user initiated action to install the templates. My goal is to have it be that the database will detect what a user has, and update the templates via an agent. Basically a way to control all of these templates. It will also serve as a template repository for anyone doing development that requires files, such as my mail merge demos. The first version will go up next week. It will just support Microsoft Office and an Install button. More versions will follow over the next couple of weeks. You can access the project here. Anyone want to provide a good name and logo? I am not an artist by any means :) If you use the app, I would love to hear about it!

Excel Export Database

January 27 2006

Alex and I demonstrated a Notes application that allowed for easy, end user driven, exporting of Notes data to Excel. The database is not ours, just one we found and love to use. I am trying to locate the author to make sure that posting it here is OK with him. Once I do, I will post a link in this space. As we talked about, there has been some discussion on making this work from Excel to Notes and using it with XML. Anyone interested in that?

Microsoft Office Constant Databases

January 27 2006

During my presentations at Lotusphere, I showed off a database that has all of the Microsoft Constants and the raw values. As I demonstrated, you must translate the Constants to the raw values to be able to save the code in LotusScript. Here are the links to the databases that contain Office 2000 and Office XP/2002: R5 R6 anyone have one for Office 2003?

BP309: Extreme Integration - Techniques for Advanced Integration of Office and OpenOffice with IBM Lotus Notes and Domino

January 25 2006

My session is over, and I think it was one of my best ever. I showed a Word solution, built once with COM and a second time with Web Services. Same result, completely different technologies. I showed how Excel can consume XML from a Domino agent. I displayed how a WinForm application, built in Visual Studio.NET can work with the same data via a web service. I then moved on to show how VSTO has issues (anyone from Microsoft want to help fix it?). I also showed mail merge with OpenOffice Writer and the Notes Personal Address Book. Last, I introduced my soon to be released project which will allow Office and OpenOffice templates to be pushed to users. When I do this session, I typically fill the room and the overflow rooms. This year, they gave me the biggest room at the Swan. It was filled and people were on the floor. But no one was in an overflow room. I hate overflows. You hear the speaker and see the slides, but you do not see the speaker. So I am very gl

OpenOffice 2.0 Preview

December 20 2004

OpenOffice 2.0 is coming along nicely ... read the features list here and check out screenshots here. Some of the features that caught my attention are: new application "Base" which will provide Access-like functionality to OpenOffice focus on MS Office filters focus on MS Office interoperability new enhancements for developers As users and companies decide not to upgrade to new versions of office, OpenOffice begins to look like a much better alternative. I am even demoing OpenOffice integration with IBM Lotus Notes/Domino at one of my Lotusphere sessions.