Archive for Lotus Notes

Lotus Notes to Quickbase Migration Video

July 7 2016

The second in a series of demonstration videos, my coworker Ken Lamey shows our IBM/Lotus Notes to Quickbase migration 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

Lotus User Group Virtual User Group Meeting - Real World Integration - Slides and Demo dbs

January 14 2009

Here are the slides and the demo files for the Virtual User Group meeting that took place today on the Real World Integration topic. We had over 150 people attend and had some great questions. Slides Virtual User Group Meeting - The Real World IntegrationView SlideShare presentation or Upload your own. (tags: integra4notes) Download the demo database There will be a replay available sometime tomorrow. Alex and I will answer the questions we could not get to in the moderated forum. Thanks for attending!

Prediction: I see the end of Application Automation

July 9 2008

How many times in your life can you say you have seen the demise of your best skill set and had a chance to react ... before that happened. I believe that situation is upon me, and I wanted to share some of my thoughts. For the past 15 years or so, I have focused my technical skills on using one piece of software to automate another. Starting with Ami Pro macros that wrote data to an Excel spreadsheet, this has evolved. SmartSuite and Notes. Microsoft Office. Lotus Symphony. Microsoft Project and Visio. And many more applications. I focused on direct automation (where one application controls another, like Notes using COM and OLE to generate a Word document) and indirect automation (where Word would call a web service to display and generate information, and that web service was from a Domino server). I saw this as a niche I could become the expert on. I believe I have done that and still find new and interesting things I can do for customers and pass along to folks at

XPages idea sparks world domination? hmmmmm

June 25 2008

Yesterday, I had an idea hit me between the eyes as I was thinking about XPages. Some background ... Last week, while out to dinner with the XPages group in Westford, Nathan Freeman and I were talking about possible ideas for submitting sessions at Lotusphere. Yeah, I know, a bit early, but not really. Nathan and I have talked about doing a session together ... and if we both survive working with each other, it might be a killer experience :-) So I called Nathan, told him about my idea .. and it ties almost perfectly into something he is working on. When I talked thru the entire idea, Nathan finally saw the end game. I think he is jazzed about it. As he said, if we hit our "500 million" goal, this could be a major application we build. So I am not going to reveal what it is ... I know, I hate that too. Sorry. But you will hear about it as the work to see if we can do this transpires. Hopefully this will push others to go out there and totally geek out on XPages. What a fun time the

IBM - XPages puts more pressure on ...

June 20 2008

This is an open comment to IBM ... After seeing XPages kick major ass in Westford this week, IBM has some work to do. First, they need to get the LotusScript editor done in DDE. They know this, and I trust it will get done and in a reasonable time. But with the sex appeal of XPages, people doing anything with LotusScript are going to be jealous. They need to see that their toolset is expanding. The pressure is on to make this rock. Second, DXL round-trip import and export is even more important. At least for the design element side. DXL is going to be an important part of our toolkit when it comes to making XPages apps that get resold by the BP and ISV community. Last, the moment that XPages works in the client, the explosion of XPages applications will begin. And, it will help protect the Notes mail shops in ways like never before. If they do it right, it could also be the push to make Composite Applications and Expeditor apps really take off. IBM has done outstanding work taking

XPages Comes of Age - 6.17.2008 - Remember that date

June 20 2008

Everyone should remember the date of 6.17.2008. And not because the Celtics beat the snot out of the Lakers to claim the NBA title. Why should you remember that date? XPages came of age that day. I was one of the folks invited to Westford by IBM to get some XPages training. IBM thought they had something 'special' (to use Bill Hume's word) in XPages, but you could tell they were a bit scared that the Design Partners, Managed Beta, and general beta users were not noticing. I told a group of folks Monday night that I had not had my "ah ha" moment with XPages yet, and that is why I was going to the training. Talk about an 'ah ha' moment! More like a major ass kicking on why XPages are the future! So, before I give you my thoughts, let me recap what other people there thought: Andrew Pollack: So a bunch of Notes guys walk into a bar..... XPages continues to impress the heck out of me Tabs, tabs, tabs, tabs ....wonderful tabs... -- Will most XPages sites use tabbed navigation? A s

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.

How I got started with Lotus Notes

April 6 2008

To continue the meme, here is my story (taken from the About John page): I was working at an engineering firm called Artron Products my last year of high school part time. I went away to college to the University of New Mexico at Albuquerque. After a year of more skiing then studying, I decided to come home and went back to work for Artron. To make a long story short, I was asked by the owner to build a solution to make our internal documents (Quotes, Orders, Invoices) streamlined and integrate with a spreadsheet. We happened to have 2 pieces of software in house (Artron did not spend money), Ami Pro and Excel. Guess which software we used :) I wrote the entire system in Ami Pro, and linked it to Excel using DDE. I spent considerable time on the old Compuserve Ami Pro forums, asking questions and finally answering them as an L-Team member. Someone caught wind of this, and pointed 2 people in the SmartSuite group, Karen Clay and Amiee Kane, at Artron. Artron became a Lotus Business Par

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

ForumFriday: Lotus Symphony: Does it need a Document Library template?

February 15 2008

I had answered James Regenold's post earlier this week: Subject Symphony / MS Doc Library Is there a Symphony Equivalent to the MS Document Library Template. My clients use that extensively, but now want to get of MS Office and use Symphony. They want to be able to save their Symphony files directly into a Lotus Notes DB. Subject there is not some of what the Doc Library requires from an API stance is not in Lotus Symphony. I am also not sure they have it on their to-do list since most people want things like Quickr integration vs a Doc Library. Would be a good request to put in thru your official channel. So I wonder, do we need a Document Library for Symphony? Do people really use them? I ask this because the Document Library template uses some really nasty OLE techniques to provide the functionality it does. Without quite a bit of work, the documents generated in there are locked into that database. Is Quickr not the right place for this? Without OLE support inside Sym

How do we make IdeaJam have a bigger impact?

February 13 2008

Before I go into my thought here, I want to be clear. I love IdeaJam. Bruce, Matt, and Sean have built a wonderful tool. PSC is damn proud to host it and I have nothing to say but praise for the site. I am so happy that Bruce has found a market for the solution. Alex and I talked about IdeaJam in every session we gave at Lotusphere. I have turned customers and IBMers on to the site. I support IdeaJam 1000000%. This is not a negative comment about the site in any manner. Can I be more clear? One of the things I have been thinking about since Lotusphere is how we can take the impact the community makes on IBM at Lotusphere and figure out how we can do that the other 51 weeks of the year. Here are some of my thoughts. My goal here is to brainstorm. IdeaJam has given many people hope of a collaborative environment. My question is, does a post on IdeaJam really have enough weight to make an impact on average. Sure, Mary Beth and Bob and others have said they read and follow IdeaJam. Bruce

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

JMP201 - Introduction to IBM Lotus Notes and IBM Lotus Domino Integration with Desktop Applications

January 20 2008

JMP201 Introduction to IBM Lotus Notes and IBM Lotus Domino Integration with Desktop Applications Speakers: John Head, Alex Kassabov SW 5-6 - Sunday 1:30pm - 3:30pm Repeats: SW 7-10 - Sunday 4:00pm - 6:00pm Welcome to the real world, where Lotus Notes and Lotus Domino are just part of your corporate toolset. This session will introduce you to integration of Lotus Notes and Domino 8 with Microsoft Office,, and Lotus Symphony. We'll start with the basics and gradually build up to advanced integration. Mail Merge, exporting to a spreadsheet, charting, presentation building, and integration on the Web will all be covered. Advanced topics such as Visual Studio Tools for Office, use of BIRT for reporting and integration with Lotus Domino Web Services will round out the session. You'll walk away with sample applications and code you can use immediately! (Participation in the "Kum Bah Yah" sing-along is optional) | View | Upload your own Download Updated Slides here Do

Integra for Notes Personal Edition Announced ... FREE

January 16 2008

The word is out, and I am happy to be able to blog about the forthcoming Integra for Notes Personal Edition. Here are the details: Integra for Notes Personal Edition is a free version of Integra which allows users to generate the following from their Lotus Notes personal address book contacts: mail merge letters to Microsoft Word View Video of Mail Merge Letter e-mailshots to Notes mail labels to Microsoft Word View Video of Labels export to Excel of contact detailsIntegra Personal Edition ships with a number of ready made letters and label formats as well as reports while also allowing the user to create their own mail merge letters, labels and Excel reports. These reports also allow users to simply create Excel pivot tables, graphs etc. from their personal address book contacts. Integra Personal Edition contains the functionality of both the Integra for Notes product, used for predefined reporting, as well as the Integra Quick Reports product, used for ad-hoc reporting