Creating a Structured Product Labeling Editor

The challenge: use InfoPath to create an editor for the Structured Product Labeling (SPL) subset of the HL7 Clinical Document Architecture (CDA) schema. I’ve done quite a bit of document-centric work, and my philosophy has always been to design an XML schema first, because from an xsd, all other things can flow: InfoPath can generate forms…


Healthcare / HL7 solution

Over the next few days I’ll be posting a series of articles covering my trials and tribulations in creating an “HL7 Generator” – specifically using InfoPath to generate XML in the Structured Product Label format, which is a subset of the Clinical Document Architecture. Here is an image of the (nearly) completed form. As usual, it…


InfoPath Context Sensitive Help

InfoPath SP1 (public beta at the link; final due out this summer) includes a lot of cool changes, both in the UI and behind the scenes (most notably the ability to stuff managed code behind the form). First I’m going to cover the OnContextChange event and using it to create context-sensitive help. To create a managed…


A Polite Request for Those Who Post Code

Lots of samples flying around – I think we released new versions of just about everything we publish in the last twelve months, so everyone is publishing all kinds of tutorials and how-tos online. In observation of this, I have one simple request – if you’re going to post sample code, please be sure to…



1. Grab the nearest book. 2. Open the book to page 23. 3. Find the fifth sentence. 4. Post the text of the sentence in your journal along with these instructions. “Right-click the My Documents folder and select Properties” (from Hillier’s book, reviewed below) Hmm… that may be the most common answer around. 😉 Philo


Book Review: SharePoint, Building Office 2003 Solutions

I bought Scot’s book hot off the presses, since it’s the first major SharePoint 2003 book. When I got it, I breezed through it, and I’ll be honest – I was unimpressed. Well, I had reason to browse through it again, and this time I just sat down and started reading it. That’s when I…


Times Change

The trebuchet was the world’s most powerful weapon for three hundred years, until it was superceded by the cannon.  My dad was born in 1922. When he was eight years old his parents took him to visit Lithuania via a steamship (best transport around). He’s taking a nap in the living room right now while I’m…


SharePoint Planning

      The centipede was happy, quite,         Until the toad for fun      Said, ‘Pray which leg comes after which?’      This worked her mind to such a pitch      She lay distracted in a ditch,         Considering how to run.                    -George Herbert Palmer It’s entirely possible SharePoint offers the best out-of-the-box experience of any product Microsoft has ever…


Why Smart Clients?

… or “Why is my client so fat?” InfoPath is really cool. To some degree, it actually delivers on the ancient promise of “productivity without programmers.” Fundamentally, it’s a form design and publication tool – end users can design forms and publish them to a server where the people who need to fill out the…


It’s not your father’s Office (dev)

I’m a Business Productivity Technology Specialist – that means I get to convince everyone why Office is a cool development platform. The good news is that I really don’t have to do much convincing, because the platform is so cool. I’m simply baffled at where to start. So much has changed in Office since VBA…