InfoPath & SharePoint screencast demo

As  follow-up to the “hook InfoPath to a database” demo, here I’m taking a step back to a simpler form – building an InfoPath form to be used on its own in conjunction with SharePoint.  https://channel9.msdn.com/ShowPost.aspx?PostID=344635 In the next few videos I’m going to cover: InfoPath, xml schemas, and xml An advanced InfoPath form connected…

3

Why InfoPath?

Okay, I’m going to try a different approach on the “why do I care about InfoPath?” issue.  I recorded a short screencast and posted it to Channel9: https://channel9.msdn.com/ShowPost.aspx?PostID=343092   In the screencast, I walk through setting up an InfoPath form to connect to a database, and show how the idea is to free up developers from…

6

"InfoPath isn’t part of Office"

Simon said: “Then you find out its not part of the office suite.” To be fair, this is somewhat true. At best, it’s confusing. With Office 2003, InfoPath wasn’t part of the suite you could buy retail or on open license. However, if you bought Office Pro on an enterprise agreement, you did have rights…

1

Why hasn’t anyone heard of InfoPath?

I recently wrote a book on InfoPath 2007. What I find most amazing about the book is that it’s evangelizing InfoPath. I’ve shown a number of developers the book, and when they read the description, their reaction is “wow, InfoPath sounds cool – I should check it out.” How is it possible that a member…

15

Creating a web service for an InfoPath form in 25 easy steps

It took me a while to figure out how to do the InfoPath/webservice thing starting with an InfoPath form. Maybe this is blindingly obvious to everyone but me, but here it is anyway: 1) Create an InfoPath form from a new, blank form:   2) Lay out your form, using sections, grouping, and naming controls…

9

Stupid SQL Tricks

Argh. Classic Schroedinbug. I had an outer join between two tables to populate an InfoPath multi-select listbox. (So I needed a list of potential options with indications of which options had been selected). I created an outer join and put my parameter in the WHERE clause, like this: SELECT dbo.NeedRequestType.NeedRequestID,    dbo.NeedType.NeedTypeID,    dbo.NeedType.NeedType,    dbo.NeedCategory.NeedCategory FROM dbo.NeedCategory…

6

Emailing a different InfoPath form

I recently needed to create an InfoPath form that enabled the user to post the data to another user in a format they could open in *their* InfoPath form. After some thought, I went with the idea of running an XSL transform on the data and posting it via an email connector. Of course, first…

2

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…

1

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…

2

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…

4