Archive for Microsoft

OneNote vs. Evernote - no, make that OneNote AND Evernote

March 18 2014

Yesterday, Microsoft made quite a few announcements around OneNote. Here is a list of what is new: OneNote for the Mac OneNote is free! OneNote API and a bunch of apps - including IFTTT! OneNote email address Web Clipper OneNote Eye Lens for Windows phone - and I would love to see this on the iPhone That is a long list of stuff! This excites me. I use both OneNote and Evernote. Yes, both. Why? Great question. For work stuff, I mostly use OneNote. It connects to my ecosystem that I use daily like nothing else I have seen. Tied together with Outlook, Office, Sharepoint, and Lync. That connect is really powerful - but the real power is in the group sharing of notebooks. Using OneDrive or SharePoint, the power of group notebooks is amazing. PSC has teams using OneNote for our projects and the amount of data in there is out of control and head spinning. Yes, Evernote has the ability to share notebooks - but it requires everyone have a premium version. And I find the synching and team col

SharePoint 2013 Creates A Cost-Effective Solution For Managing Employee Reviews

December 16 2013

PSC Group has released a brand new video customer testimonial on our work with TCA Holdings, LLC and our SharePoint 2013 work. You can learn more about the solution and the experience our customers have with PSC Group by watching it here: You can read more about the solution here If you are interested in any more information about the solution, or how PSC Group can help your company achieve results such as these, please contact me!

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, OpenOffice.org , 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

MWLUG 2011: The Notes/Domino Application Development Competitive Advantage

August 26 2011

Speaker: John Head - PSC Group, LLC, Director of Enterprise Collaboration, David Via - IBM Corporation, BUE, WW Messaging and Collaboration Sales Some organizations are neglecting or under-utilizing one of the greatest IT assets in their portfolio today - the Notes/Domino application platform. Some are even considering re-coding Domino applications in other languages and development tools. In this session we present the business case and technical merits of Notes and Domino in direct comparison to other tools such as Microsoft SharePoint. Based on data collected from real-world engagements we will demonstrate the positive return on investment of the Notes platform. We will also discuss PSC's "Application Modernization" strategy and how it helps move customers from merely maintaining Notes applications to increasing their value with XPages and advanced collaboration functionality. MWLUG 2011: Notes/Domino Application Development Competitive Advantage View more presentations from J

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

IdoSphere: Domino Application Development Competitive Advantage

February 15 2011

Domino app dev competitive advantage finalView more presentations from John Head. This is the presentation that David Via of IBM and myself gave today.

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

PSC built BarillaUS.com featured on topsharepoint.com

August 16 2010

PSC's Microsoft practice has gotten a great accolade: the Barilla website (www.barillaus.com) has been featured on topsharepoint.com Congratulations to the team at PSC for developing such a great site and being selected for topsharepoint.com!

Yellow Day Release: Updated OpenNTF.org Contacts Experience

August 11 2010

In honor of Yellow Day, I am going to post a new version of the OpenNTF.org 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!

IamLUG 2010 - The Collaboration Agenda – Putting It to Work in your Organization - Slides Posted

August 2 2010

The Collaboration Agenda – Putting It to Work in your OrganizationView more presentations from John Head.

IBM: Please follow in Microsoft’s BPOS footsteps here ...

July 21 2010

I saw this on Karen Hobert's blog: Microsoft showcased at the show this week a number of its partners who’ve already jumped on the BPOS bandwagon. To encourage others to start selling the suite, Microsoft announced that it will offer partners 250 BPOS seats for their own use. You can read all the details on Microsoft's Partner Network page. Lots of fine print. For instance, here who is eligable: Certified Partners Gold Certified Partners Microsoft Action Pack subscribers Empower for Independent Software Vendors (ISVs) members Registered Members who have signed the Microsoft Online Services Partner Agreement (that is, who have enrolled in QuickStart) So this is not available to everyone - you have to put some skin in the game to play. But, Microsoft is clearly saying to it's partners "BPOS is a big deal, go use it yourself, sell what you know" ... and I want IBM to do the same thing. I would like to see IBM offer complete LotusLive packages to every partner. Require some level of s

Blogging from Enterprise 2.0 - Microsoft Social Computing (SharePoint) Panel

June 16 2010

Here are the notes I took from the panel "Enterprise 2.0, Real World Edition: Microsoft customers and partners sharing real world stories and advice" yesterday at Enterprise 2.0: Moderator: Christian Finn Director of Product Management SharePoint Microsoft Corporation Panelists: Dan Pontefract - TELUS Brad Bagley - World Vision Canada Brian Kellner - Newsgator Eric Raarup - Intetium Andy McLoughlin - Huddle Shannon Ryan - non-linear creations inc. Chris Slemp - Microsoft - internal program manager - internal social computing program manager What convinced you to choose sharepoint as part of your social strategy? 1. Integration with existing CMS 2. Leverage existing investment 3. Integration with osc + livemeeting + office + sharepoint 4. 2010 - tighter integration with office apps & search What capability in SP2010 are you most excited about? 1. Run third party app as managed service application and integration with the moss standard featur

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.

OOXML Drama ... No-Duh!

April 5 2010

Last week, Alex Brown wrote a pretty scathing blog entry about how Microsoft has not followed thru on implementing and supporting the OOXML ISO Standard. We have seen Ars Technica pick up the story. Even Ed blogged about it. Today, Nathan Freeman asked me this in IM: "so, I'm wondering if Alex's (Brown) blog post puts you in MSFT apologist-mode or "no-duh" mode" My answer was a resounding "no-duh" Here are some thoughts why. Microsoft said in late 2008 that there was no way ISO/IEC 29500 Strict was going to make Office 2010. I find this interesting because (I believe) Alex Brown was in the room when they said that. As far as I can tell, Office is on a 4 year development cycle. The first year is when the previous version is in testing, two years of development, and a year of testing. The specification was accepting mid way thru a development cycle. You don't add something like that midway in a product cycle like this. As much as the team I work with at Microsoft, led by Doug Mahugh

Open XML SDK for Microsoft Office Version 2.0 has shipped

March 15 2010

A big day for the OOXML community ... On February 21, 2008, I posted on Microsoft Interoperability Principles, which are designed to make our products more open and more available to the broader software community. Since that day, Microsoft has made several strides in this area, too many to recount here and now, but largely explained by the Interoperability@Microsoft team. Today we are making an important advance in the area of document format interoperability for Office, as part of our ongoing commitment to these interoperability principles. After four successful Technology Previews, today we are releasing the 2.0 version of the Open XML SDK for Microsoft Office. Among its benefits, this release of the Open XML SDK is a significant step forward because of the amount and quality of functionality it provides to developers seeking to build document processing solutions without the use of Microsoft Office applications. Today Visual Studio is the primary developer tool for Office 2010, and

It’s time Microsoft decide how serious they are about real people using OOXML

February 16 2010

As many of my readers know, one of the areas that PSC has invested quite a bit of time in the past 24 months is around Document Generation. Document Generation is defined (by myself) as the ability to generate a document, based on a format, without having any software installed to generate or render the document. This can be done client or server side. I have done quite a bit of blogging on the topic - and taken both Microsoft and IBM to task. We have done some real world client projects, including the Research Director, Inc. project that was highlighted in this case study. While PSC does not participate in the ODF or OOXML standards process, I think our team is one of the deepest on the technical side. I have been working with the PSC team to get our technical knowledge out into the world to share our experiences and engage in the conversations. The first piece of this engagement is a new blog called Coding the Document. Tim Murphy, a .NET guru in our Microsoft practice and one of t

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

PSC to introduce Social Web Manager at three events in October

September 28 2009

You are cordially invited to join PSC and Microsoft for a first look at… Social Web Manager for Microsoft SharePoint Join us for complimentary cocktails and hors d’oeurves and a presentation that will change the way you are thinking about the Social Web “Research suggests that companies that are using social media & new media technologies are growing faster than other companies. Four out of five companies in the Inc 500 rate social media technology as important or very important. Nearly half of the companies are using Social Networking sites such as Facebook, Twitter, YouTube and LinkedIn. The Inc 500 are adopting new media technologies much quicker than Fortune 500 companies.” … The University of Massachusetts Dartmouth Center for Marketing Research 3 Chances to have a First Look Wednesday, October 14th 6 – 7:30 PM Tuesday, October 20th 6 – 7:30 PM Thursday, October 22th 6 – 7:30 PM WHITE EAGLE GO

"I don’t care about standards, I just want everyone to implement the same thing in the same way”

September 26 2009

Yes it is true - as Doug Mahugh reports on the DII Workshop on Office 2010 Extensions, I did in fact make that statement. It was a good day at up at Microsoft headquarters on Sept 18th, 2009. We talked about how Microsoft is adding new features and functionality to Office 2010 and the OOXML format. Doug explains: Office 2010 takes advantage of two types of extensibility mechanisms in ISO/IEC 29500: extension lists and ACBs (alternate content blocks). These extension points, which are documented in the text of the standard (see Part 3), provide implementers with a standardized way to innovate and add new functionality while maintaining conformance to the standard itself. The core concept is that an implementer can provide more than one representation for an object (a shape on a slide, say), and then consumers of that document can render the version that they understand. The workshop featured four presentations on how Office 2010 uses ACBs and extension lists. Word/Excel/PowerPoin

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.

OOXML - What Microsoft should be doing going forward

May 26 2009

So I have taken ODF to task in the past couple of weeks, and since I have stated that my position is to work with both ODF and OOXML, I thought it was time for a bit of tough love for Microsoft. Before I do that, a bit of a current state observation. When someone says OOXML today, they can mean many things. For most, they are not talking about ECMA-376 or IS29500, the specifically mean Office 2007 file formats for Word, Excel, and PowerPoint. We can argue what the technical term used by the standards community uses, but let's get real. The average person has no clue what either standard is or what they are called or how they are different. They need to work with Office 2007 file formats - reading them and saving changes back to them. If you look at other software vendors; Apple, Google, IBM, etc; when they add OOXML support, they always call it 'adding Office 2007 file format' - and frankly, nothing has really changed for them since adding Office 2003 support. Sure, they might have b

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 OpenNTF.org 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

Round 2: Where do we go from here? (ODF & OOXML Discussion)

May 7 2009

So yesterday's post And in this corner ..." - can you hear Michael Buffer introducing ODF vs. OOXML in the boxing ring? is now the single most read post on my blog in the 5 1/2 years I have been blogging. The number of referrers is the highest I have seen as well. All for what I thought was a fairly routine post about what it felt to be caught in the middle of a playground fight over who got to push the swing - and who got to ride. Seeing the further discussion around the web honestly entertained me - as well as disappointed me. My blog entry saw both Rob Weir and Doug Mahugh respond. I am glad I could get both of them talking to each other - and not at each other. I find myself truly in the middle - agreeing and disagreeing with both of them on many of the things being done. But what I want to see is action out of the discussion (and drama) and I really do not see any positive progress on that. So a few comments: 1. I have been asked by many on both sides of the ODF and OOXML debate

"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, OpenOffice.org, and Google Docs with Lotus Notes and Domino Go behind the scenes of Lotus Symphony and OpenOffice.org 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

Are you gaming on the XBox 360 or PS3? Let’s connect

November 3 2008

So are you playing games on the Xbox 360 or PS3? If so, connect with me on Xbox Live or the Playstation Network. Xbox Live = starfish711 Playstation Network = starfish711 I play 90% of my games on the 360, so I am on there more often than the PS3. The PS3 is a BluRay player with only Uncharted: Drake's Fortune owned. What we really need is a friend connector service for both Xbox Live and the Playstation Network ... that I can use from the web and import email, Facebook, and LinkedIn. Now THAT is something I would pay for.

Microsoft Document Interop Initative Workshop on OOXML - Thoughts

November 2 2008

Thoughts on the workshop The DII (Document Interop Initiative website - http://documentinteropinitiative.org Presentations by the Word, Excel, and PowerPoint Teams on what they are doing with OOXML and testing going forward. No specific mention of Office 14 features or support Microsoft wants to created testing documents that everyone can test with their implementations of OOXML Microsoft seems far more interested in supporting both OOXML and ODF than anyone else out there. It seems most vendors are picking one file format or the other. Microsoft wants to continue to let OOXML to grow for their internal use but are very interesting in making sure ODF interop works as well. Nice change from what I have seen from Microsoft in the past Microsoft employees are trained very well to not talk about anything that is not public knowledge. Now, the DII Workshop was not covered by any NDA's, so I understand. But even in back channel discussions I could barely get timeframes and versions out

PSC’s Presentation from the DII Workshop this past week @ Microsoft

October 26 2008

Here are the slides from the PSC presentation at the Microsoft DII Workshop on OOXML from this past week PSC & OOMXLView SlideShare presentation or Upload your own. (tags: psc ooxml)

Test Documents for OOXML and ODF standards

October 23 2008

At the DII Workshop on OOXML today, one of the issues that is under discussion is creating an test suite of documents that implementers can test their implementation against. My recommendation is that the OOXML (and ODF) camp create something like the ACID test. The ACID test let's browser creators test specific features and functionality and let's the user see where they stand. This is not about implementing hundreds or thousands of pages of a spec, its about meeting specific requirements. There should be a test suite of documents that you can open, edit, save, and create. And then some validator to measure how the specific implementation opens and saves these documents. The documents can be tied to versions of the specifications. What is important is that I, the user, can take a document, run it against the validator, and get a visible score myself. It needs to be transparent. I know there is the ODF Validator, but it does not work very well. There should be one place where I uploa

DII Workshop around OOXML starts today in Redmond

October 23 2008

I am back in Redmond, WA this week for the DII Workshop on OOXML. What is great is that this time, I have two other PSC folks with me. David Munaretto, Vice President of Microsoft Services and Andrew Schwantes, OOXML Technical Champion. We are here to listen, learn, and talk about our Case Study around PowerPoint and OOXML. I am betting that this one will be as much fun as the ODF one I attended this summer. I wonder who will attend? :)

New PSC Case Study: PowerPoint as An Enterprise Reporting Framework: Harnessing the Power of OOXML

October 22 2008

We just posted a new case study on the PSC Website. This one talks about our first OOXML project, which uses PowerPoint as an enterprise reporting framework. I am super excited about this solution and can not wait to talk about our OOXML frameworks in the near future! If you are looking at doing any work with OOXML, please contact us!

Microsoft embraces Eclipse.org with Silverlight 2

October 14 2008

So in a move that many will raise an eyebrow to, Silverlight 2 ships today ... with support for development within the Eclipse.org development environment. Yes, Microsoft is embracing Eclipse.org. Mike Milinkovich, executive director of The Eclipse Foundation, posted a blog entry about this. It seems that Microsoft is funding a third-party, Soyatec, to do the development. Soyatec is already an Eclipse.org member. You can read about the tools at Eclipse Tools for Microsoft Silverlight site. I think this is a great move by Microsoft. The more places someone can do development with Silverlight, the more likely people are to use it.

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?

Microsoft E3 Press Conference

July 14 2008

Best thing I think I can do is give you a listing of stories from ShackNews.com. Fallout 3 live demonstration Resident Evil 5 dated Fable 2 in October, has co-op Gears of War 2 November 7, 5 player co-op NBC, Universal Come to Xbox Live Marketplace New 3D dashboard revealed for Xbox 360 Geometry Wars 2 coming next month Portal: Still Alive this fall Netflix X360 streaming service on the way Scene It Box Office Smash announced You're In The Movies announced Guitar Hero nets R.E.M., Van Halen, The Eagles, Metallica Karaoke/Dance game Lips officially unveiled Final Fantasy 13 coming to Xbox 360 Lots of exclusives announced .. Fallout 3 Downloadable Content (DLC) only for PC and the 360, Portal:Still Alive, Rock Band 2 for a couple months. Gears of War 2 and Fable 2 look amazing ... and Final Fantasy is no longer a Sony exclusive. Damn. The new dashboard and Live Avatars look really cool. Only thing we did not get was a BluRay add-on. Sony and Nintendo press conferences happen later

Microsoft OneNote might be the coolest application ever

July 8 2008

In the past couple weeks, I have done quite a bit more note taking vs coding. I have tried to play with software like MindMapper but what I need is a way to take notes, organize them, and work with them. I need it in a way I can type and outline fast. Nothing fancy or graphical. Up to a couple weeks ago, I did this either on paper (notepads and cards) or in my Notes journal. After playing with Microsoft OneNote a bit last year, I really pushed myself to use it the past month. Woah. Talk about a change in productivity. I do not have a Tablet PC, so I am not using a pen to take Notes. Just typing ... which I am a pretty good typist. The pure note taking part of OneNote is great. I can organize my notes in an outline format, just like I was creating an outline in Word or PowerPoint. I so wish Notes had this level of outlining support. But how I store those notes is the real power. The "Notepad" storage mechanism allows me to organize at the top level. I have one for Clients, Projects, a

Microsoft adds ODF support to Microsoft Office

May 21 2008

The official press release is out now, so I can comment on this ... Microsoft Expands List of Formats Supported in Microsoft Office Move enhances customer choice and interoperability with Microsoft’s flagship productivity suite. REDMOND, Wash. — May 21, 2008 — Microsoft Corp. is offering customers greater choice and more flexibility among document formats, as well as creating additional opportunities for developer and competitors, by expanding the range of document formats supported in its flagship Office productivity suite. The 2007 Microsoft Office system already provides support for 20 different document formats within Microsoft Office Word, Office Excel and Office PowerPoint. With the release of Microsoft Office 2007 Service Pack 2 (SP2) scheduled for the first half of 2009, the list will grow to include support for XML Paper Specification (XPS), Portable Document Format (PDF) 1.5, PDF/A and Open Document Format (ODF) v1.1. When using SP2, customers will be able to open

Its about the customer, not the technology

April 18 2008

Today, the hard work of multiple PSC employees on a discovery project was presented to a customer. We were reviewing an application framework and making recommendations. One of the pieces is the Output Generation Layer. The requirement is to have the output be in PowerPoint files. From there, they can generate a PDF or HTML, but we need something that in an electronic presentation format that scales. When I came to PSC, I was a very one-sided consultant. I was passionate about Lotus Notes and Lotus SmartSuite. I tolerated Microsoft Office, because people used it. But anything else, I loathed. I was so focused on the holy war of one technology and brand that I hated everything else. It didn't matter if it was Microsoft, Novell, Oracle, or anyone else .. it was not Lotus. And for many years, only the Lotus brand at IBM was something I cared about. PSC describes itself as a business technology services consulting firm. Our job is to listen (get it, it's all in the way we listen) and h

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 OpenOffice.org 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.

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, OpenOffice.org, 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

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, OpenOffice.org, and some other things like BIRT) Best Practices: Integration of IBM Lotus Notes 8 with the IBM Lotus Symphony and OpenOffice.org 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

DirectX 10 .. Microsoft has a real problem

August 28 2007

Microsoft has a real problem with DirectX 10. The problem is that the core audience for DirectX 10, gamers, are not upgrading to Microsoft Windows Vista. Since DirectX 10 only works on Vista, games with all the DirectX 10 goodies are not being played, or bought. Gabe Newell, President of Valve (makers of Half-Life, Half-Life 2, and the upcoming Orange Box) discussed this with Heise: According to an online survey by Valve Software, only one in fifty players who access download service Steam has a DirectX 10-compatible graphics card and Windows Vista installed. In an interview with heise online, Gabe Newell, president of Valve Software, said that Microsoft made a terrible mistake releasing DirectX 10 for Vista only and excluding Windows XP. He said this decision affected the whole industry as so far only a very small percentage of players can use DirectX 10. I think it is time for Microsoft to backport DirectX 10 to Windows XP. I feel bad for all my friends in the gaming development w

OpenProj hits beta ... could this be a real Microsoft Project Alternative

August 6 2007

I read on the Project blog this morning about OpenProj. This is an open source alternative to Microsoft Project. While it looks very much like a clone of MS Project, it strips down some of the complexity from the interface and makes some common tasks easier (viewing a stacked resource graph for example). It opened my MS existing MS Project 2003 .xml files with no visible problems - though even MS Project has some quirks in handling .xml files, so it will pay to double check this before using for a real schedule. I think this is the first MS Project viewer which will really make inroads against MS Project. This is true for a number of reasons: It is free Look and feel similar to Project (maybe too similar... but let the lawyers decide) File compatibility Ability to edit and create schedules Cross-platform compatibility (Mac users will rejoice after being denied the latest versions of Microsoft Project)I tried it out this morning and I was impressed. It uses the Java Web Star

PowerPoint is 20 today

August 3 2007

Today, Microsoft PowerPoint is 20 years old. I am not sure if I should cheer or scream in agony ... Check out this site for a gallery of PowerPoint splash screens over the years.

Powerpoint a requirement for business school?

July 30 2007

This is the first time I have heard of anything like this: In a first, the University of Chicago will begin requiring prospective students to submit four pages of PowerPoint-like slides with their applications this fall. The new requirement is partly an acknowledgment that Microsoft Corp.’s PowerPoint, along with similar but lesser-known programs, have become a ubiquitous tool in the business world. But Chicago says so-called “slideware,” if used correctly, also can let students show off a creative side that might not reveal itself in test scores, recommendations and even essays. By adding PowerPoint to its application, Chicago thinks it might attract more students who have the kind of cleverness that can really pay off in business, and fewer of the technocrat types who sometimes give the program a bad name. “We wanted to have a freeform space for students to be able to say what they think is important, not always having the school run that dialogue,” s

OBA for the ISV (Microsoft that is)

July 7 2007

Microsoft has created a page dedicated to Office Business Applications, or OBAs. There is also a starter kit with the following resources: OBA/VSTO Starter Kit v. 1.0 Whitepaper: http://msdn2.microsoft.com/en-us/library/bb498190.aspx OBA/VSTO Starter Kit v. 1.0 Installation Document: http://msdn2.microsoft.com/en-us/library/bb498189.aspx OBA/VSTO Starter Kit v. 1.0 Source Code: http://www.microsoft.com/downloads/details.aspx?FamilyID=120AAAA8-0A0C-4A0B-B605-4E08FFE7A786&displaylang=en Good stuff if you are an ISV and want to build Office applications.

Office 2003 to 2007 Interactive Guides

June 26 2007

One of the struggles with the new 2007 Office System User Interface, inclulding the Ribbon UI, is the change in location of menu items. I still struggle with simple things I did in Office 2003, such as Help | About (you have to go to the Windows Menu, click Word Options, Resources, About) and changing the slide backgrounds of a PowerPoint presentation. I found these Interactive Guides linked to on Erika Ehrli's blog. They are very cool ... Interactive: Word 2003 to Word 2007 command reference guide Interactive: Excel 2003 to Excel 2007 command reference guide Interactive: PowerPoint 2003 to PowerPoint 2007 command reference guide Hope these help some of you

The Microsoft Office Interactive Developer Map

June 13 2007

One of the things that I showed at Lotus Developer 2007 in my Advanced Office session was the Microsoft Office Interactive Developer Map. As big and overwhelming the 2007 Office Developer's roadmap is, this little gem gives you a great way to explore. It is a live application that you can click around. It contains links and it reads feeds to give you current information. Here is what it looks like: The Microsoft Office Interactive Developer Map helps developers visualize the different programs, servers, services, and tools that will help you build solutions. It allows you to drill down to each product and technology and learn about new features, objects, Web services, namespaces, and schemas required to extend Microsoft Office and build custom Office Business Applications (OBAs). This map provides links to MSDN portal pages, technical articles, and key pointers to SDK and reference documentation topics. When you download the map you can see an overview of the Office developer roadma

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

ILUG2007 - IBM Lotus Notes and Domino Integration with Microsoft Office - Presentation and Demo files

May 25 2007

Very shortly, Rocky Oliver will be presenting the Notes/Domino and Microsoft Office Integration session at ILUG2007. Rocky has stepped in to help me out since I had to cancel my trip ... Super Duper thanks to him! Here is all the stuff that Rocky is going to show, for your downloading pleasure Presentation PDF Demo Databases As promised, I will work on the Microsoft Project and XML and Excel topics that Rocky had to skip as articles here. I will get those out shortly after Lotus Developer 2007.

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!

Glimpses into the future of Office Development

May 10 2007

I got this from Eric Carter's .NET4Office blog. Watch the video here to see some of what is coming with the new release of Visual Studio.NET (codenamed "Orcas") and what Visual Studio Tools for Office will be like once it is built into the IDE. Cool stuff in the future for all of us Office developers.

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

Microsoft Visual Studio Marketing - Defy All Challenges

May 1 2007

Microsoft has put together a great site called Defy All Challenges. It is a Microsoft Visual Studio site, covering Vista, 2007 Office System, Web Development, and the Visual Studio Team System. But what makes it unique is that the whole site is based around games. You will find famous Microsoft game properties (both for the PC and XBOX/360) including the most famous, Halo. Lots of videos, information, and even your own machinima tool. Well worth a check out. Source: Denis @ Integra

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

2007 Lotus Notes .NET Integration Workshop

March 19 2007

As some have guessed, I am attending the 2007 Lotus Notes .NET Integration Workshop that Microsoft is running this week. I am here to learn and present on integration topics and Integra4Notes. Gary started out with a nice bribe ... free software. Update: Here is the picture I know it's blurry, but what you see is Microsoft InfoPath 2007, Microsoft Sharepoint Designer 2007, Microsoft Office 2007 Professional, and the full box edition of Visual Studio.NET 2005

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 dhough@psclistens.com 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

Windows Vienna coming ...

February 11 2007

So I was doing my nightly reading on the tech blogs I read, and came across this ... With Vista just hitting shelves, Microsoft is already looking ahead to their next OS codenamed "Vienna", that is slated for a 2009 release. This from development VP Ben Fathi: We're going to look at a fundamental piece of enabling technology. Maybe its hypervisors, I don't know what it is...Maybe it's a new user interface paradigm for consumers...It's too early for me to talk about it...But over the next few months I think you're going to start hearing more and more. Hmmm...lots of tech speak going on there. Let's give the prototype Gizmodo Translator a whack at it: The end user is F&*#ed Priceless

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!

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

Are you ready for your desktop to look like this?

July 17 2006

Windows Vista using Areo Glass and Microsoft Wrod 2007 using the Silver theme = I think it looks pretty slick, but is the average user ready for such a radical UI change when writing a memo? We shall see.

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 OpenNTF.org Project ...

April 18 2006

So after an announcement at Lotusphere and lots of prodding by Bruce, I have finally gotten my first project for OpenNTF.org 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

Office 12 is Dead, Long Live 2007 Microsoft Office System

February 16 2006

Today Microsoft announced that Office 12 was a code name. 2007 Microsoft Office System is the official name to the upgrade to Microsoft Office System 2003. First, some resources for you: The Press Release 2007 Microsoft Office System Packaging Fact Sheet 2007 Microsoft Office System Pricing Fact Sheet 2007 Microsoft Office System for Business Intelligence Fact Sheet Q&A: Microsoft Unveils Next Generation of Web Authoring and Design Tools Now some comments: Frontpage is Dead (Yes, I read the support until 2008). Say hello to Microsoft Office Sharepoint Designer 2007 and Microsoft Expression Web Designer. They have split out the functionality. It makes sense from a function stand point, but just means we have two tools to install and use We now have 7 Office "Suites" or packages, 15 Office Applications, 5 Office Servers, 2 Office CALs (Client Access Licenses), 3 Web Access applications, 3 Office Services, and 4 System solutions. Wow. that is a lot to

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

John Speaks - PSC Seminar with Microsoft "The Advantages of the Microsoft Office System"

April 5 2005

On May 5th, 2005, James Vaselopulos, Vice President of eBusiness and Collaboration, and myself will be talking about the Microsoft Office System and how to take advantage of it. The focus will be on how the Office System connects to a wide range of technologies, especially those that are not from Microsoft. Here is the marketing blurb: Every day, businesses face an ongoing challenge of making a wide variety of software from many different vendors work together. With so much invested, making new software work alongside existing systems is an ongoing customer need. This means letting different kinds of applications and systems do what they do best, while agreeing on a common "contract" for how disparate systems can communicate to exchange data with one another. This means learning how to interoperate more effectively. Now is the time to make your desktop work even better with your other systems on the back end. If Microsoft Office is where you start and end your busines

Microsoft Office XML is Leaking ...

March 28 2005

A co-worker found this article, and I have to completely agree. The steps Microsoft took with XML in Office 2003 are great, but they have a lot of holes that need to be filled. I do not expect them to get fixed in 2003, so hopefully the next version will give us the XML fixes we are looking for!

Longhorn Information

March 23 2005

As we get closer to Longhorn, the next release of Windows, information is going to pop all over the net. I found that this site, by Paul Thurrott, has the most detail I could find. Lots of good information, so go check it out. Attached are some of the new screenshots here ... the Avalon UI is looking very cool.

TuneXP from Driver Heaven - Free Windows XP Tweaker

April 13 2004

Create a XP Unattended Boot CD!

March 5 2004

So if you are like me, you probably nuke your OS partition and reinstall Windows a couple times a year. But doing the install is a pain! So here is a very detailed way to create a CD that will prompt you for your Name, CD Key, Timezone, and Region info and then just install. You can even include other software! Instructions here

Next Microsoft Operating System "Longhorn" Delayed until 2006

October 14 2003

Well, Microsoft execs have finally admitted that the next major operating system release after Windows XP, code named "Longhorn", wont ship until 2006. See this for the news. What blows my mind is that Apple can release a new version of OS X every year, with a solid feature set, when Microsoft can't even predict correctly when the next release of Windows will be out. So even though Panther (10.3) will be out next Friday, we will have 2 more Apple OS updates before Longhorn ships. Nice. Glad I switched.

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

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.

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 LotusUserGroup.org 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 LotusUserGroup.org Virtual User Group Meeting - The Real World IntegrationView SlideShare presentation or Upload your own. (tags: asp.net 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 LotusUserGroup.org 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. OpenOffice.org. 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

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, OpenOffice.org, 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.

Microsoft adds ODF support to Microsoft Office

May 21 2008

The official press release is out now, so I can comment on this ... Microsoft Expands List of Formats Supported in Microsoft Office Move enhances customer choice and interoperability with Microsoft’s flagship productivity suite. REDMOND, Wash. — May 21, 2008 — Microsoft Corp. is offering customers greater choice and more flexibility among document formats, as well as creating additional opportunities for developer and competitors, by expanding the range of document formats supported in its flagship Office productivity suite. The 2007 Microsoft Office system already provides support for 20 different document formats within Microsoft Office Word, Office Excel and Office PowerPoint. With the release of Microsoft Office 2007 Service Pack 2 (SP2) scheduled for the first half of 2009, the list will grow to include support for XML Paper Specification (XPS), Portable Document Format (PDF) 1.5, PDF/A and Open Document Format (ODF) v1.1. When using SP2, customers will be able to open

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/OpenOffice.org) 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

CNet loves Lotus Symphony? Have pigs started flying?

February 28 2008

From Ed ... can this really be true? Love it!

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 dhough@psclistens.com 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, OpenOffice.org, 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

I want this feature NOW - Presenter Screen

March 5 2008

Thanks to Alan Bell for pointing this out. I so want this feature now in Lotus Symphony .. and Microsoft should steal this and put it into PowerPoint NOW! This is from the OpenOffice.org wiki and is a feature that should be in the OpenOffice.org 3.0 release. Introduction The presenter screen for Impress is a feature (currently in development) that aids a presenter during a slide show. It provides information on a second screen, that typically is not visible to the audience. This includes a view to the currently displayed slide (for when the presenter faces the audience and can not see the primary screen) a preview of the next slide or next effect the notes of the current slide the current time and/or the elapsed time navigation buttons for going to the previous/next slide Here is how it looks at the moment (left the full screen presentation, right the Presenter Screen): The presenter screen is planned to be an extension. However, some core libraries will have to be modifi

Cylon Baseships are run by the Hybrid ... and Microsoft Windows

May 27 2008

O M F G ... Yes, that is a shot from Battlestar Gallatica. It's minute 9:26 in this season ... episode 7, Guess What's Coming to Dinner. No wonder this season has turned into a meltdown. Kudos to Gizmodo for finding this.

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