Just catching up on some email and something that many InfoPath developers are asking:

I have an InfoPath form that uses a Web Service. How can I move that into production and point the Web Service as a production system?

Check out the following KB article:

	HOW TO: Change the URL of a Web Service in InfoPath
	(827003) - This article describes how to modify the URL of a Web service that is used as a data source for an InfoPath form.

10:15:29 PM    

Here are the steps to do a quick export manually from Excel to InfoPath. I am sure this could be pretty easily scripted. Maybe, I’ll give it a try - what do you think? Let me know.

In InfoPath

1. Open the InfoPath form that you want to fill out.
2. Save a blank copy of the form. This blank copy contains the XML structure of the InfoPath XSD.

In Excel

1. Open an Excel spreadsheet.
2. From the Data menu, click XML and then XML Source.
3. Select the XML Source task pane and then select XML Maps button
4. Using the Add dialog, select the XML file that was saved from the InfoPath file.
5. Place the nodes in the XML Source task pane into the Excel cells for all fields.
6. Under the Data menu click XML and then export the Excel XML structure, saving it over the InfoPath XML file.

In Notepad

1. Open the XML file created from Excel
2. Add the XML processing structure from InfoPath to the file. This is what InfoPath uses to open and locate the template associated with the XML file. It will look something like this.

<?xml version="1.0" encoding="UTF-8"?>

<?mso-infoPathSolution solutionVersion="1.0.0.1" href="Enter the template location here" productVersion="11.0.5531" PIVersion="1.0.0.0" ?>

<?mso-application progid="InfoPath.Document"?>

<!-- rest of your document here -->

Double click on the file and it will open up in InfoPath. Remember, the PI that was placed above it essential to allowing InfoPath to open the file.

5:01:52 PM    

The folks in EMEA have created a great new online site that is designed to cover architectural issues that we all face. From what I have read so far it has some great content.

http://www.thearchitectjournal.com/Journal/Default.aspx

9:26:26 AM