Archive for Integra

PSC and Integra sponsor Virtual User Group Meeting

December 15 2008

PSC and Integra are pleased to be sponsoring a virtual user group meeting on Jan 14th, 2009 at 12 PM Eastern Standard Time. The topic is: The Real World of Integration: How Lotus Notes & Domino Can Work with Microsoft Office, Lotus Symphony and the Power of Integra for Notes Welcome to the real world, where Lotus Notes and Lotus Domino are just part of your corporate toolset. This live, online presentation will introduce you to some unique and time saving techniques for the integration of Lotus Notes and Domino with Microsoft Office, .NET technologies, and Lotus Symphony. No matter what version of Notes you're running (even 8.5) all the way back to 6.5, you'll come away with a solid plan for Mail Merge, exporting to a spreadsheet, charting, presentation building, and integration on the Web. You'll learn some advanced topics such as Visual Studio Tools for Office integration with Lotus Domino Web Services. Plus, we'll show you live demos on how to use Notes & Domino 8

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

Integra Thought of the Week - Centralizing your Business Application Reporting

August 4 2008

As I was demonstrating Integra to a couple of potential clients the past couple weeks, I have been seeing a greater demand for a centralized business application reporting solution. Customers want more and more reporting for their applications. What they do not want is multiple reporting applications or reporting functionality that is located all over the back office. One of the many advantages of the Integra solution is that all of your reports for the Notes and Domino platform live in a single place. You can even build reports that work on other platforms using the Integra framework. All of this reporting is stored in the Integra application on a Domino server and has no impact to any of the applications it reports on. I am going to be putting together a couple of blog entries on the impact of business reporting when your Notes clients and Domino servers go thru the upgrade process. Look at those over the next couple of weeks. For more information about Integra for Notes and

Integra Thought of the Week - Integra Quick Reports Feature Preview

July 28 2008

With the release of Integra Quick Reports 4.6, users in the Notes client got a whole new level of ad hoc reporting functionality with the addition of virtual fields. Today, I am pleased to preview that an upcoming release of Integra will bring the virtual fields and the link functionality to the web version of Integra Quick Reports. Here are some screen shots of the functionality Integra Quick Reports on the web with a Virtual Field being used in the Form field list Integra Quickr Reports on the web showing the Field Link (@DBLookup for the end user) Integra customers under maintenance will get these great features in an upcoming release. I will post more details as they become available! For more information about Integra for Notes and Integra Quick Reports, please visit Those that wish to learn more about Integra version 4.6, visit the upgrade page at As the US Premier Partner for Integra, PSC has a dedicated section

Integra Thought of the Week - Integra at Admin 2008 makes The Malta Times

July 21 2008

Integra made The Malta Times with a picture of the booth at Admin 2008. You can next see Integra at UKLUG in September! For more information about Integra for Notes and Integra Quick Reports, please visit Those that wish to learn more about Integra version 4.6, visit the upgrade page at As the US Premier Partner for Integra, PSC has a dedicated section of our website for all things Integra. This includes our Integra Quickstart Offering and Integra Report Writing Packages. You can also read my white paper on Off-the-shelf or Custom Development and the value of Frameworks.

Integra Thought of the Week - Why Virtual Fields changes ad hoc reporting in Notes for the better

July 7 2008

With the shipping of Integra Quick Reports 4.6, end users will see a big change when doing ad hoc reporting. Instead of seeing a listing of fields that mean nothing to the end user, they get a listing of fields in plain English. So what does this really mean? Most developers build field names that mean something to them. For instance, we use a prefix on a field name for the form or function. I have seen so many field names that are along the lines of "fldSFWF_01" or "coAdd01_City". Can we really expect the end user to figure out what those mean? Virtual Fields in Integra Quick Reports 4.6 solves this problem. A field mapping for each form can be created, which will replace the real field names with a more end user friendly label. So instead of "coAdd01_City" the end user sees "Company Address - City". The real power in Virtual Fields comes from the ability to apply reader and author fields to the Virtual Fields mapping documents. You can have different mappings for the same for

Integra Quick Reports 4.6 with Virtual Field Mapping

May 28 2008

Integra Quick Reports 4.6 has been announced, with Virtual Field Mapping. New Product Simplifies Notes to Office Integration and Reporting Process And Secures Integra As Incomparable Solution to be launched at ILUG and DNUG Integra Quick Reports, the leading tool for end-users to integrate Lotus Notes with Microsoft Word and Excel, has today announced Virtual Field Mapping functionality. This enhancement increases the usability and enables the delivery of more complex ad-hoc reports, Word mail merges and Excel exports without the need to escalate to a developer. “Integra allows point & click access to columns in views, and enables access to fields on forms with a full preview of the form,” explained John de Giorgio, CEO, Integra for Notes. “ Many times however, the design of a database involves complex field names and lookups to other views providing a challenge to end-users. “Integra Quick Reports’ new Virtual Field Maps allows a developer or super-user to configure 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.

Integra Thought of the Week - Integra for Domino Administrators

May 6 2008

Most of the time when I talk about Integra, I talk about the reporting and office integration with Integra for Notes and Integra Quick Reports functionality. At The View Admin 2008 / Lotus Developer 2008, Integra had a booth that I was pleased to help with. Talking with many of the administrators there, they really loved the Integra for Domino Administrators product. Integra for Domino Administrators focuses on providing pre-made reports for Domino Administrator, allowing them to anyalze and report on their Domino infrastructure inside Microsoft Excel. It allows the administrator the ability to chart performance, statistics, and provide information to others in a graphical format. Available reports include: Access Control settings – audit ACL settings of users or groups across databases. Derive effective ACL rights of users and/or groups considering the user's membership in groups including nesting of groups. Identify orphaned ACL entries in databases for users or groups no lon

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

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