.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

move infopath forms from SP Portal Server 2003 to 2007

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :SharePoint

I am a newbie to SharePoint. Please let me know if I didn't explain my problem well...

We built the new SharePoint server 2007 on a different physcial box from the old server 2003. There are huge amount of InfoPath forms in form library on the old server. I was told that: to get these forms moved over to the new server 2007, we have to save the forms and re-publish to the new server one at a time. This will be really time consume and also loosing the attributes of the original forms, the date it was created and modified etc.

I would like to see if there is a way to move one form library at a time, and just copy the forms over; not publishing them again.

Many thanks!


View Complete Post

More Related Resource Links

InfoPath: Turn User Input into XML with Custom Forms Using Office InfoPath 2003


Office InfoPath 2003 is a new Microsoft Office product that lets you design your own data collection forms that, when submitted, turn the user-entered data into XML for any XML-supporting process to use. With an InfoPath solution in place, you can convert all those commonly used paper forms into Microsoft Office-based forms and end the cycle of handwriting and reentering data into your systems. Today organizations are beginning to realize the value of the mountains of data they collect every day, how hard it is to access it, and are striving to mine it effectively. InfoPath will aid in the design of effective data collection systems. Here the author shows you how to get started.

Aaron Skonnard

MSDN Magazine September 2003

MOSS 2007 : I am looking for tutorial about how tu use infopath 2007 forms and to associate to them



I am quite new on sharepoint 2007,

i am at the moment looking for tutorial to help to understand better the concept of workflow you can associate with infopath 2007.

I would like to create a  form that the visitor of the website can fill and then submit.

once the form submitted i would like tto be able to store all the date picked up to the database sqlserver 2005 and then to be able to send a email to the administator to be kept inform  of that.

the 2 tutorial i found that i found interested are http://weblog.vb-tech.com/nick/archive/2007/02/25/2207.aspx and the microsoft one o.n the virtual lab.

So what i am looking for is any tutorial which can help me to be understand very well how to use the worklow with infopath or if you have as well some book to advice me for that i would be happy.


Overwriting Existing InfoPath 2003 Forms



I'm having a big problem in my Sharepoint Environment.

So far I've created a form in InfoPath 2003 and successfully published it to a Form Library. It's also submitting correctly (at least at first).

Now after I added a couple forms, let's say three forms with unique file names, and then I open the second one, make a change and submit it again, it disappears from the "All Items" list. I can still see it sitting in the "Explorer View", but it's missing in the other. Now when I try to "Fill out a new Form", it either won't show up in the list or it will show up but with the column fields that have been populated previously.

We're using WSS 2.0 and InfoPath 2003.

I used this guide to create the unique filenames: http://www.codeproject.com/KB/sharepoint/SharePointSubmitInfoPath.aspx

In my view, the issue lies in trying to overwrite existing files and not appearing in the list.

Any help is much appreciated !!!


Thanks in advance.

Marvin Sugirin

Sharepoint 2003 + Windows Terminal Server 2008 + Office 2007 problem?

Hi, We have a customer where some users runs Windows Terminal Server 2008 with Office 2007. They open documents from a Sharepoint 2003 site. When they open an excel sheet they get a button in the document which says "Server workbook: Click edit workbook to edit this workbook" and there is a button: "edit workbook" The users clicks "edit workbook" but get an error message saying there is no connection to the server.  They are able to edit the document, but not save it back to the sharepoint site. Most other users work on their local computer with Office 2003. Here, everything works fine and there are no button/message stating its a server workbook.   Is this caused due to some compatability issues between Sharepoint 2003 and Office 2007?   Best regards, Thomas Hansen ErgoGroup AS

The URL is not valid error while publishing InfoPath form to MOSS 2007 server

Hi All,   When I try to publish the form onto a SharePoint Team site it throws the error: The following URL is not valid : http://tcs037288:6543/sites/projectmanagement   I have checked the comaptibility, trust and everything looks fine. Also, I tried to upload this template from Central Admin but there it is failing with browser-compatibility errors.       Regards,

Accessing code in InfoPath 2003 forms from Visual Studio 2005

Can vbscript code contained in an InfoPath 2003 form be accessed from VS2005 on a machine running Office 2010? We are testing Office 2010 our our PC's and the custom task pane code that works just fine on PC's running Office/InfoPath 2007 does not run on the test PC's. I've been reading that the vbscript code in the form can't be edited directly when opening the form in InfoPath 2010, but that's not what I'm trying to do. I want to access the vbscript code through the .Extension property of the XDocument object from client side javascript code on an .aspx page like we have done for years. The existing code, which runs perfectly on PC's with Office/InfoPath 2007,  looks like this ... var xDoc = window.external.Window.XDocument; xDoc.Extension.UserLookupDone (userid); When run on PC's with Office/InfoPath 2010 the code throws error "Class doesn't support Automation". Are we trying something that is no longer possible? Any help is appreciated.

Getting error while retrieving data from sql server 2008 to infopath 2007 in sharepoint 2007

Hi, I have created an InfoPath form in InfoPath 2007. In this form I am getting data from SQL Server. To do this I have created data source for SQL Server 2008’s Tables. I have created 4 connections for 4 tables. When I am previewing this form from InfoPath Designer 2007, it is working. But when I am publishing this, it is giving me an error ‘Can not update content type’. If I skip this error then my form published but when I open this form from Share Point 2007. It gives me an error:   There has been an error while processing the form. Click Continue to resume filling out the form. You may want to check your form data for errors. Click Start Over to load a new copy of the form.   An error occurred accessing a data source. An entry has been added to the Windows event log of the server. Log ID: 6932 G. Goyal

Install MOSS 2007 and ProClartity 6.3 (PAS6.3) on the same Microsoft Windows 2003 Server

An install of MOSS 2007 and ProClartity 6.3 (PAS6.3) on the same Microsoft Windows 2003 Server seems to be problematic. MOSS 2007 creates a default website and stops the normal default website. As soon as PAS 6.3 is installed it installs to this stopped default website. How can I overcome this issue?

MOSS 2007 to SharePoint Server 2010 Hybrid Upgrade Approach on Windows Server 2003 x64

There's some guidance circulating about upgrading to 2010 with a mix of In-Place and Database Attach upgrade methods. My Central Admin and SharePoint Web App are on a 64 bit server, but it's running on Windows server 2003 x64 and not on Windows Server 2008 or 2008 R2. SharePoint Team Blog says Server 2008 or 2008 R2 is required for SP2010. If I want to do the hybrid upgrade approach, is it possible to first upgrade the OS to Server 2008 R2 on the server where my Central Admin and SP Web App runs?  Or will this break MOSS 2007?

Win server 2003+ Sharepoint 2007+SQL Server 2008 ,reports view issue?


I hope someone may shed some light on a serious obstacle encountered on a client site:

We have implemented a SharePoint integrated report services solution for the client on a single server

Server = Windows 2003

SQL = 2008

MOSS 2007

Web application = servername:8888 (default) - windows auth

Web application extension 1 servername:8889 (extranet) forms auth

Web application extension 2 servername:8887 (intranet) forms auth

Reports are visible and can be run (renders) on internal sites

However, there is an external site which allows users to access the reports - the issue is, the reports then dont run and I get this:

"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode."

Though I have not actually seen the firewall config of the AAM, the client assures me it has been setup properly.

If the AAM is setup correctly, what could be the problem? The server is clearly available and confgured in SharePoint integrated mode.


has anyone experienced the scenario where clients want to publish their reports on an external site? What can one do to see any errors other than the one line message (tried enabling custom errors, but no good)

Urgent: InfoPath Forms on SharePoint and SQL Server


I'm very new to using InfoPath but we recently upgraded to SharePoint Enterprise 2010 and we would really like to take advantage of the new InfoPath Form Services that's available with this version of SharePoint. I need to know if it's possible to build a form that gets data from a Microsoft SQL Server, and also when that form is submitted it will need to populate a table on our Microsoft SQL Server. This form will also need to be published on SharePoint so our users can fill out the form directly from there. Is this possible? I've been trying to figure this out for almost a week now and can't seem to get very far at all- it's very frustrating.

If it is, what would be the first steps that I need to take? I thought it was as simple as building a form in InfoPath2010 and just publishing it to SharePoint but I get the feeling that I need to upload some type of data connections to SharePoint Central Administration?

Move SharePoint 2007 on Windows 2003 32-bit to Windows 2008 64-bit


I am planning to move SharePoint 2007 from a Windows 2003 32-bit system to a new Windows 2008 R2 64-bit server tomorrow afternoon.  I have done much research and found only one article that gives me enough information to go on for the migration.  Others in technet have cited this article; so, I expect it is the one go use.  However, before I begin, I wanted to see if anyone has anything else to add. 

Here's the article I'm planning to use:


Our current environment consist of one front end server (Windows 2003 32-bit running MOSS 2007) and one SQL server (Windows 2008 Standard 64-bit with SQL 2008 640bit).  So, we don't need to move the SQL databases - just the SharePoint front end.  We are moving to Windows 2008 R2 with MOSS 2007 (same SP and patch levels are planned).  

Our final goal is to move to SharePoint 2010 in the next week or two, but this seems to be the required first step.

Most of what I've read online contradicts other things.  I've found no consistency between articles.  

Thank you in advance for your assistance. 

add new items to sql server using infopath 2007


can someone help me with this adding new items using infopath 2007.

i have create a form based on sql database connection.

i have 2 tables that are related to each other. table A is the user table with the user name and id in it. table B is the vacation days table that has the days that the user went or will go on vacation.

in my form i have set 2 field with the user and the user id and a repeating section with the absence/vacation days in it.

when i go to preview the form and click on the "run query" both the fields and the repeating section are filled correctly. and if i click on insert item to insert a new item it submit fine to the database.

but what i need is that the user must fill a new form. when i click on the "new" button it cleared all the fields. but i dont want it to clear the username and the userid field.

i want the user to open a blank form with only his username and userid already filled in.

i know how to autopapulate those fields. but everytime i try to insert new absence dates. it gives me this error:

Violation of PRIMARY KEY constraint 'PK_USER'. Cannot insert duplicate key in object 'dbo.USER'.

another error i have got once was that i need to insert the 2 keys i have in the tables.

but i dont want that the user fill in the keys

can someone

Licensing for InfoPath 2007 when using Rich Client Forms only



I am using InfoPath 2007. I intend to design and distribute Rich Client forms only, and once the user fills the form, they will submit the data to a Web Service or Email the form data (xml). I am aware that each user will need to have InfoPath 2007 installed on their computer, which is ok for me. My question is, apart from purchasing the Office InfoPath 2007 (which in my case comes with Office 2007 Enterprise), are there any other licences I will need in order to deploy my solution?

Thanks and regards.

Moss 2007 and Infopath 2003 client


System config:

SharePoint 2007 SP2 - 64 bit Standard edition

2 WFE, 1 APP/index,  Clustered SQL DB Servers (SQL 2005)


Issues is with Infopath forms saved to a document library (NO FORMS SERVICES ENABLED - MOSS Standard license), no code behind, just XML based form with a number of fields in it linked to an xsn that is located on another server entirely.

Client machines are IE 6 Infopath 2003


When form is opened by an owner - works fine, client opens no issue

When form is opened by a contributor - unless checked out first or if the "Require checkout before allowing editing of file" is disabled works fine

When form is not checked out to contributor or if the user if a viewer the error is:

"Infopath cannot open the following file:<filename>.xml. The file does not appear to be an infopath form ."

Show details:

"The processing instruction in the file is missing or invalid"

I tried a couple tests, I logged into Windows as a user who had viewer rights and then logged into MOSS as a user who has owner rights. Issue still happens. So I am assuming there is a second call being made by the InfoPath client using the windows identity and integrated auth.

If I download the file to my desktop it opens just fine. I cannot determine what ch

SharePoint Portal Server 2003 - email alert based on due date


Hello All,

Hoping someone can help us here.

Note:Workflow/3rd party solutions not an option-

We would like to send an email alert when a list items due date is eqaul to "today".

We are trying to manage some certificates of compliance by flagging the "due date of the particular certificate (list item)" and sending an alert email when that occurs.

Is this feasible in any manner without workflow?

Is it possible to send an alert based on a calculated field when that calculated data changes? .

Any direction would be appreciated.

Thank you

Mike Harvey
Software Solutions Architect


Cannot install MOSS 2007 on Windows server 2003 SP2



I try to install moss 2007 on a developper workstation:

An error occured in the step 2 of the installation (installation of the administration database)

The error is as follow:


Exception: System.Data.SqlClient.SqlException: the procedure or function 'proc_SetDatabaseInformation' expected the '@Value' parameter, wich is not provided

i first try with an sql server 2005 database instance, then with an sql server 2008 database instance. Same problem.



In the log file, i can see this message before the exception:

Creating a new farm with config db SharePoint_Config content db SharePoint_AdminContent_59286dfd-6ead-46e6-8268-7b4c0f5025b1 server XXXXX for farm mode

The thing is, i do not want a farm mode installation, but the install wizard do not allow me to choose a non farm install.

Maybe this is non relevant, i don't know.


Thanks for your help



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend