iamlug 2011: the never ending integration story: how to integrate your lotus notes, domino, and...

The Never Ending Integration Story: How

to Integrate Your Lotus Notes, Domino,

and LotusLive applications with Microsoft

Office, .NET, and Lotus Symphony

© 2011 PSC Group, LLC

John Head, PSC Group, LLC

Agenda • Introductions

• “Getting Started” with Integration

• Advanced Integration

• From the Notes Client

• From other applications

• From the Web

• Looking Forward

• Q & A

John Head

[email protected]

1051 Perimeter Drive Suite 500 Schaumburg, IL 60173

(847) 517-7200

(847) 517-7600 fax

Facebook.com/PSCGroup

Twitter.com/PSCGroup

Linkedin.com/company/psc-group-llc

Slideshare.com/PSCGroup

Youtube.com/PSCGroup

Facebook.com/johndhead

Twitter.com/johnhead

LinkedIN.com/in/johndhead

Slideshare.com/johndhead

Youtube.com/johnhead

www.johndavidhead.com www.pscgroup.com

F O U N D E D I N 1 9 9 0

PSC

Ecosystem

Our

Clients

Our

Solutions

Our

People

Clients

Prospects Delivery

People

Direction

• Integration

• Workflow

• Rules Engines

• Collaboration

• SOA

• Portals/Websites

• Mobile Enablement

• Custom Applications

• Dashboards

• Process Improvement

• Agile/Sustainable Architectures

Our Partners

The Never Ending Story • Building on top of past 10 years of presentations on this topic

• More Content

• Every demo updated

• Brand New Demos

• Take Advantage of the modern software versions

• Notes 8.5.2 and 8.5.3

• Office 2010

• Symphony 1.3 & 3.0

• .NET 4.0

• Visual Studio 2010

• Much of the basics of integration have had to be left out …

• But you can access our presentations from previous years …

The Demo Databases Presentation example database

Contains all of the “Getting Started” Demos

Works in your Notes Client

Configurable for your environment

New UI for Rich Client, works in Standard client as well

OpenNTF.org Contacts Experience

Customized Notes 8.5.2 Contacts Template

Version on server for web and web services demos

Poll Results: PSC Sessions in 2010

Poll Results: WorldWide 2011

Let's Review how we got to 2011

1994

DDE with Ami Pro

1996

Notes R4

OLE

LotusScript

VBA

1997

SmartSuite with LotusScript (Word Pro)

1998

Notes R5 with COM support

2001

Notes Domino 6

2004

Notes Domino 6.5 with LS2J and DXL

2005

Notes Domino 7 with Web services

2007

2007 Office System

Lotus Notes/Domino 8

Lotus Symphony

2008

Visual Studio 2008

Notes/Domino 8.5

2009

Notes 8.5.1

Domino Designer in Eclipse

2010

Office 2010

Symphony 3.0

Otherwise known – How to Make John Feel Really Old!!!!

Integration History

The Good News We have entered the

“Industrial Revolution” period of the Integration Era

In the “Medieval Times”

DDE with Ami Pro

NotesSQL was used to get even the most basic of data

OLE embedding

Notes F/X

The Good News (continued) The Renaissance brought us new tools

OLE automation

COM automation

And much more

The Revolution brings us major changes

A true competitor to Office in Lotus Symphony

Visual Studio.NET 2010 and VSTO 4.0

Code begins to move from inside a document to complete applications






• From the Web

• Looking Forward

• Q & A

“Getting Started” Demos • Each demo is the equivalent of a “Hello World” sample

• They are self contained and as little code as possible

• No error trapping, etc

• This will get you started with Integration

Getting Started

• Word

• Excel

• PPT

• Project

• Visio

• VBA

● Symphony Documents (UNO)

● Symphony Spreadsheets (UNO)

● Symphony Presentations (UNO)

● Symphony Documents (LS API)

● Symphony Spreadsheets (LS API)

● Symphony Presentations (LS API)

● C#

Getting Started –

Microsoft Word

• “Getting Started” demo #1

• Demonstrates how to use

LotusScript to have Notes

automate Microsoft Word

Getting Started –

Microsoft Excel



LotusScript to have Notes

automate Microsoft Excel

Getting Started –

Microsoft PowerPoint • “Getting Started” demo #3


LotusScript to have Notes automate

Microsoft PowerPoint

Getting Started –

Microsoft Project • “Getting Started” demo #4



Microsoft Project

Getting Started –

Microsoft Visio




Microsoft Visio

Getting Started –

Symphony Documents UNO • “Getting Started” demo #8



Lotus Symphony Documents via

UNO

Getting Started –

Symphony Spreadsheets UNO • “Getting Started” demo #9



Lotus Symphony Spreadsheets via

UNO

Getting Started –

Symphony Presentations UNO • “Getting Started” demo #10



Lotus Symphony Presentations via

UNO

Getting Started –

Symphony Documents LotusScript • “Getting Started” demo #111



Lotus Symphony Documents via the

new LS API

Getting Started –

Symphony Spreadsheets LotusScript • “Getting Started” demo #12



Lotus Symphony Spreadsheets via

the new LS API

Getting Started –

Symphony Presentations LotusScript • “Getting Started” demo #13



Lotus Symphony Presentations via

the new LS API

Getting Started –

VBA • “Getting Started” demo #14

• Demonstrates how to use Visual

Basic for Applications (from within

Microsoft Word) to access Lotus

Notes

Getting Started –

C# • “Getting Started” demo #16

• Demonstrates how to use C# (from

within Visual Studio.net 2010) to

access Lotus Notes

Use the Microsoft Constants Database

• Provides a listing of all Microsoft

• Office variables and their converted

constants

• Extraction of constants by John

Collidge

• Database built by Tom Duff

• Now an OpenNTF.org project

• Supports Microsoft Office 2000, XP,

2003, and 2007

http://www.openntf.org/internal/home.nsf/project.xsp?action=openDocument&documentId=1F6C5C7B16317E218625726D004A31A9






• From the Web

• Looking Forward

• Q & A

Advanced integration from the Notes Client

From your Contacts application:

• Create Letter

• Create Envelope

• Mass Mail Merge

• Export

• Create Presentation

• Labels

• Templates

• Custom Fields

This requires that you replace the design of your Contacts

application with the OpenNTF.org Contacts Experience template

OpenNTF.org Contacts Experience

• Free template on OpenNTF.org

• Release 2.0

• Works with 8.0 and above

• Microsoft Office

• Works with 8.5.1 and above

• Lotus Symphony

http://www.openntf.org/internal/home.nsf/project.xsp?action=openDocument&name=OpenNTF.org%20Contacts%20Experience


Create Letter – Microsoft Word • From your Contacts, create a

new letter for the selected

contact in Microsoft Word.

• Allow the user to select from

custom templates


Create Letter – Symphony Documents • From your Contacts, create a

new letter for the selected

contact in Lotus Symphony

Documents.


custom templates


Create Envelope– Microsoft Word • From your Contacts, create a

new envelope for the selected

contact in Microsoft Word.


Create Envelope – Symphony Documents • From your Contacts, create a

new envelope for the selected

contact in Lotus Symphony

Documents.


Mass Mail Merge– Microsoft Word • From your Contacts, create a

mass mail merge for the selected

contacts in Microsoft Word.


custom templates


Mass Mail Merge – Symphony Documents • From your Contacts, create a

mass mail merge for the selected

contacts in Lotus Symphony

Documents.


custom templates


Create Labels – Microsoft Word

• From your Contacts, create a

labels for the selected contacts in

Microsoft Word.


custom templates


Create Labels – Symphony Documents

• From your Contacts, create a

labels for the selected contacts in

Lotus Symphony Documents.


custom templates


Export – Microsoft Excel

• From your Contacts, export

selected fields for the selected

contacts in Microsoft Excel.


Export – Symphony Spreadsheets

• From your Contacts, export

selected fields for the selected

contacts in Microsoft Excel.


Create Presentation – Microsoft PowerPoint • From your Contacts, create a

presentation for the selected

contact in Microsoft PowerPoint.


custom templates


Create Presentation – Symphony Presentations • From your Contacts, create a

presentation for the selected

contact in Microsoft PowerPoint.


custom templates






• From the Web

• Looking Forward

• Q & A

Advanced Integration from other applications

• Easy Spreadsheets using Notes Data

• Insert Image

• Insert Slide

• Notes Explorer

• Document Automation vs. Generation

• OOXML

• ODF

Advanced Integration from other Applications

Easy Spreadsheets using Notes Data • Create spreadsheets that import

Contact data

• Auto Refresh

• Generate Charts

• Get data via a XML Agent


Insert Image – Microsoft Word

• Using a custom VSTO solution,

add an Insert Image Ribbon,

menu item, and sidebar that

allows for easy image insertion

from a Notes repository.


Insert Image – Symphony Documents • Using a custom Symphony Plug-

in, add an Insert Image menu

item and sidebar that allows for

easy image insertion from a

Notes repository.


Insert Slide – Microsoft PowerPoint • Using a custom VSTO solution,






Notes Explorer • A C# and .NET solution that extends

Microsoft Explorer to allow

navigation of Domino applications

from within Explorer. Notes Explorer

is the combination of the Lotus

Connectors and DNFS (Domino

Network Files Services) from the

Notes 5.x time frame.


Notes Explorer • Using a custom VSTO solution,





Automation vs. Generation • Document Generation is starting to become a viable option

• Using the standard formats of OOXML, ODF, and PDF

• Instead of requiring the application to be present, this is done with

no interaction of any application

• Tools

• C# and the OOXML Toolkit for Office

• Java and the Simple Java API for ODF for Symphony

• Numerous PDF APIs and Toolkits for both .NET and Java

• Can generate server side in a fraction of the time

OOXML • Default format of Office 2007 and

Office 2010

• Ok, ok … there are three versions

1) Office 2007 OOXML

2) ECMA-376

3) ISO/IEC 29500:2008

4) Office 2010 OOXML

• Allows XML exploration of files for

• Word

• Excel

• PowerPoint

• Allows for document manipulation

• ZIP container of text, images, etc.

• Open XML SDK 1.0

• Allows for handling container

• Open XML SDK 2.0

ODF • Open Document Format

• Used by OpenOffice.org and

Lotus Symphony

• Open Document 1.0

• ISO/IEC 26300:200



• We are using the Simple Java

API for ODF created by IBM

• http://odftoolkit.org/projects/simpl

e/pages/Home

Document Generation Demo • A custom developed C# application

that uses the Open XML SDK 2.0

and the Simple Java API for ODF

created by IBM. We are also using

an opensource PDF toolkit.






• From the Web

• Looking Forward

• Q & A

Advanced Integration from the web

• Integration with Microsoft Web Technologies

• Integration with IBM Lotus XPages

Advanced Integration from the Web

IBM Lotus XPages

• A demo of an IBM Lotus XPages application using the

IBM ODF Toolkit to generate documents






• From the Web

• Looking Forward

• Q & A

2011 and Beyond We finally have great tools

VS.NET 2010 and DDE

Great Changes Coming

• Productivity Tools are moving to the web

▬ Google Docs

▬ Lotus Symphony On-line and LotusLive

▬ Microsoft Office On-line and Microsoft 365

• End User Device Shift

▬ How many of you have tablets today? Next year?

We have multiple options

Office, Symphony, OpenOffice.org, Google Docs, iWork, etc.

Competition will be good for us … if we can deal with all the changes

PSC's Effort to Shape the

Integration Market in 2011

• Our goal in 2011 is

• Provide 24/7 education about the integration market

• Education and extend in the Automation space

• Bring new developers to the Document Generation Space

• Continue a leader in ODF and OOXML usage in the Lotus community

• To achieve these goals … We introduce integrationdestination.com

• Launching mid Sept 2011

• We will start with recording videos with every automation demo we

have done … ever (52)

• Every version of Office still supported

• All of the extra stuff

• Far more to come!

Resources LDD Discussions (Notes.Net)

http://www-130.ibm.com/developerworks/lotus

OpenOffice.org

http://www.openoffice.org

OpenOffice Developers Guide

http://api.openoffice.org/DevelopersGuide/DevelopersGuide.html

Programming OpenOffice with Visual Basic

http://www.kalitech.fr/clients/doc/VB_APIOOo_en.html

Microsoft Office developer’s Web site

http://msdn2.microsoft.com/en-us/office/default.aspx

Microsoft Developer Network

http://msdn.microsoft.com









Resources (cont.) Microsoft Office blog listing

http://msdn2.microsoft.com/en-us/office/aa905342.aspx

OpenNTF.org — the open source Web site for Notes

www.openntf.org

Integra4Notes Web site

www.integra4notes.com

Slides and content available from http://www.johndavidhead.com http://www.psclistens.com

http://www.openntf.org/

http://www.openntf.org/

http://www.integra4notes.com/

http://www.integra4notes.com/

http://www.johndavidhead.com/

http://www.psclistens.com/

http://www.psclistens.com/

iamlug 2011: the never ending integration story: how to integrate your lotus notes, domino, and...

Technology

started symphony documents

started microsoft word

started microsoft project

started microsoft visio

started microsoft excel

started microsoft powerpoint

customized notes

notes r4