How to migrate an InfoPath form from test to production in SharePoint 2010

 

In order to migrate (copy) an InfoPath form from one environment (say test to production), there are several things to consider. First, does your form use a data connection to retrieve or submit data? Second, if you update the form in the future, do you want all of the locations where this form is used to be updated as well? Consider these issues while reading the instructions below.

Step 1: Create a form

First, let’s create a simple InfoPath. For my example, I’ve created an overly simplified leave request form. The PTO (Paid-Time-Off) form has only three fields on it: a leave date, a return date, and an employee name field. I know this isn’t all too realistic, but I don’t want to get lost in the details of what’s on the form since we’re focusing only on how to publish it.

Step 2: Publish your form using InfoPath

Our next step is to save and publish our form. In InfoPath, go to File à Publish and select “SharePoint Server”:

clip_image002

The Publishing Wizard will then appear:

· Enter a SharePoint URL (don’t worry about the URL – you can use a test URL if you like)

· Click next

The next step will ask how you want to publish it. You’ll want to choose “Administrator-approved form template (advanced)”:

clip_image004

After selecting Administrator-Approved and clicking next, InfoPath will then ask you to specify a file location to save the form’s template to. This is the location (file share) that you want to save the file to in order for your administrator to access it. In my example, I’m saving it to a mapped drive:

clip_image006

The next step is to choose any fields in your form that you want be available as columns in the SharePoint forms library:

clip_image008

For my example, I’ve chosen to include all three fields, but this is up to you.

The final step in the Publishing Wizard is to click “Publish”. This will save your form template to the location you’ve chosen. Once it’s saved, the final confirmation step will appear and you can click “Close”.

Uploading the Form to SharePoint

The next step in our process is to upload the form to the “Managed Form Templates” list in SharePoint’s Central Administration. In order to do this, you will need Farm Administrator permission.

Navigate to Central Administration and select “General Application Settings” in the left navigation. Once you do that, you should see “Upload form template” as a choice under “InfoPath Forms Services” on the right:

clip_image010

Click “Upload form template” and then you’ll see this:

clip_image012

The first thing you do on this screen is to click the browse button and locate your published InfoPath form. This will be the location that you entered in the Publishing Wizard in InfoPath. You can the click the Verify button and see if this form is ready to be uploaded. Hopefully, you’ll get the message “This form template is ready to upload to the server.”

If you receive an error at this step, be sure that you selected “Administrator Approved” in the Publishing Wizard, and that you’ve selected the same form to upload to SharePoint. InfoPath will also save a working copy that would normally be considered the author’s master copy, so you more than likely will have multiple copies/versions of the same form – so be sure you have the correct one.

When you click “Ok” on the Form Verification Status page, you will be directed back to the Upload page. You’ll have to select your form again, using the browse button. This time, don’t select Verify, since we’ve already verified that this template will work. Instead, look at the Upgrade options and consider if these are applicable.

Once you’ve made your upgrade selections, click the Upload button. You should then see this:

clip_image014

Click “Ok” and you’re sent to the “Manage Form Templates” page. Depending on how quick you click Ok and how speedy your farm is, you may see the Status as “Installing”:

clip_image016

Just give it a minute and then refresh the page. Once the status is shown as “Ready”, we can do the next step.

Step 3: Activate Form for a Site Collection

Now that we have the form in Central Administration, we can now make it available to the Site Collections where we want it to be used. To do this, hover over the form link and use the drop down menu to select “Activate to a Site Collection”:

clip_image018

You will then be asked to select the site collection to make it available to. Now that the form has been available to a site collection, let’s go use it.

Step 4: Using the InfoPath form in your Site Collection

Once your form is available in a Site Collection, you still need to use it with a library. So first, navigate to your Site Collection and create a new “Form Library”. After the library is created, then go to “Library Settings” for that library.

We need to add a content type to the library. In order to do this, we go to “Advanced Settings”:

clip_image020

On the Advanced Settings page, you’ll need to select “Yes” under “Allow management of content types?”:

clip_image022

You can scroll down on the page and click “Ok”. You should now see a “Content Types” section added to the Library settings page, just above the columns section.

In the Content Types section, click “Add from existing site content types”. On the “Select Content Types” page, find your InfoPath form in the available content types and click Ok.

We’re almost ready, but one thing I like to clean up is the list of available Content Types for this library. As it is currently configured, my library would allow users to submit two different forms: “Form” which is blank and “PTO Form” which is the one I want. So to clean this up, you click on “Change new button order and default content type”.

On this page, I’ll uncheck the box in the “Visible” column for my “Form” and change the position my “PTO Form” to 1. My page now looks like this:

clip_image024

After clicking Ok, I then go back to my library and submit a new form…and there it is -- my PTO form that I published via Central Administration.

Step 5: Updating an already deployed Managed InfoPath form

Once the form is deployed, you can then make changes to the original. Let’s say you need to add field to the form. You would update the form and use the Publishing Wizard to save it as an “Administrator Approved” form. Your SharePoint farm administrator would then upload the new form to the Managed Form list, paying careful attention to the Upgrade options.

Once the form is uploaded, then SharePoint will find where that form is deployed and update it. How quickly this happens will depend on your farm.

Further Information

If you would like further information about the options for upgrading, or even how to update the form using PowerShell steps, please see Microsoft’s documentation on TechNet: http://technet.microsoft.com/en-us/library/cc262921.aspx

As I mentioned at the beginning of this post, you will need to consider how your form is updated, which I discussed briefly above.  I also mentioned that you would need to think about your data connections.  I’ll cover the data connection topic in my next blog post.

Print | posted @ Monday, February 20, 2012 3:11 PM

Comments on this entry:

Gravatar # re: How to migrate an InfoPath form from test to production in SharePoint 2010
by Ram at 10/10/2012 11:05 AM

Very good article.. Actually i wanted to publish the form in to a sharepoint library on button click. But what happens here is on clicking submit button, the form is saving in the library of a test server and not in a production server. I was not able to configure the production library path on submit button of the form
Gravatar # re: How to migrate an InfoPath form from test to production in SharePoint 2010
by Vikas Mishra at 1/9/2013 4:05 AM

I just want to move infopathform from UAT to Production Server.
Gravatar # re: How to migrate an InfoPath form from test to production in SharePoint 2010
by Noel at 7/3/2013 10:50 AM

I've used this process before but I'm currently trying to use the 'Save List as Template' feature of SharePoint to move the list and its content (associated form) from one environment to another.
None of the data connections are being validated and I can't modify them or create new ones.
I get "The Operation Cannot be Completed" when I try to move past the selection of the site in which the lists exist.
Is it me???
N03L
Gravatar # re: How to migrate an InfoPath form from test to production in SharePoint 2010
by Yasotha at 7/11/2013 8:30 AM

Hi,
Is it possible to have more than one form type (content type) in a form library?
In that case, can user select the content type they want while submitting the form?
Is there any article what happens when infopath form is submitted? where the data fill in form gets saved?
Post A Comment
Title:
Name:
Email:
Comment:
Verification: