.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

Problem with InfoPath 2007 Form opened with InfoPath 2010 - whole number integer not coming into dat

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

I found an issue when testing existing InfoPath 2007 forms via the Infopath 2010 Designer client.  Integer fields in the form template are publishing to a SharePoint Forms Library and show in the default view.  However, if that library is then used as a Data Connection in another or same form template those integer fields are not displaying or available for selection. 

This is not a problem using the InfoPath 2007 client.  It is not an option to convert the field to text as it could affect existing forms in existing libraries.  Also, existing integer fields are no longer appearing in previously defined SharePoint-based secondary data connections.  Only the ID field still appears.  But, those existing fields still work in the form and are selectable for functions, etc.

Is there a solution to this?

Thanks much!  Mike - www.ProgramNetInc.com


View Complete Post

More Related Resource Links

Problem opening an attachment from Infopath 2007 form in SharePoint 2010

I have an InfoPath 2007 form that is opened as a web based form in SharePoint 2010 that has an attachment control.  In Windows XP with IE 7 when you double click the attachment there is a warning message presented and after you click OK you get a prompt that asks if you want to open or save the file or cancel.  In Windows 7 with IE 8 when you double click the attachment there is a warning message presented and after you click OK you get a prompt that asks if you want to save the file or cancel, no open option.  I already set the SharePoint browser permission to permissive for the site and it doesn't help.  How can I get this to work in Windows 7 and IE 8?

Problem to open infopath form : The file cannot be opened because it is not a valid InfoPath form

Hi i have a winform app which host of infopath forms. form templates and data stores in database and when user want to open/edit an existing infopath form data, it must be extract from database, save on disk and then open it to display it in formControl. my problem is that when i open form data, after it has been extracted on disk, i got this error : InfoPath cannot open the following file: C:\Users\Hamed\Documents\Visual Studio 2008\Projects\InfopathFormTest2\InfopathFormTest2\bin\Debug\d00d73e8-cf5c-4b12-b9a6-591c4ade83aa.xml. The file cannot be opened because it is not a valid InfoPath form.  The processing instruction in the file is missing or invalid. here is my code : this._fullPath = System.IO.Path.Combine(Application.StartupPath, this._dataRow.FormID.ToString() + ".xml"); this._templatePath = System.IO.Path.Combine(Application.StartupPath, this._templateRow.TemplateID.ToString() + ".xsn");if (HelperClass.ExtractToDisc(_fullPath, ASCIIEncoding.Unicode.GetBytes(this._dataRow.FormContent))) { this.formControl1.Open(_fullPath); this.txtFormName.Text = this._dataRow.FormName; } where is my problem and how to solve this ? thanks in advancehttp://www.codeproject.com/KB/codegen/DatabaseHelper.aspx

InfoPath 2007 browser form problem in SPS2010



i've one issue with an InfoPath browser form in SharePoint 2010 struggling with it for 2 days now.

I have an InfoPath 2007 browser form with PeoplePicker controls in it and custom code for XMLChangedEventHandler assigned to the PeoplePicker.

Below this Control i have a repeating table with a simple rule: "If the DisplayName is empty, don't show this section."
So if somebody picks up a user, normally the section should be enabled and visible to the user.

But for some reason this is not happening, but when i save the form and reopen it again, then the section is visible.
Opening the Form in Preview (F5) Filler Mode the section gets also enabled correctly. After uploading via Central Admin meaning in the browser not.

I also tried in the Browser tab setting the "Always" postback option to all relevant fields but still not working.

I also put code into the ChangedEvent Handler, when somebody adds a user with the PeoplePicker, then it puts a comment to a field for testing purposes.
This is also not happening by runtime, instead when i reopen the Form, then i can see the comment.

I increased also the Number of Postbacks in Forms Services in the Central Administration without success.
Can anybody help or had the same problem???

Create an Infopath form to generate unique number MOSS 2007


I created an infopath form that would auto generate a number to each form from following instructions at the following site.




I am wondering if it is possible to change the starting point of the ID field within sharepoint.  It starts at 1.  I would like it to start at 1000. and add 1 number each time a new infopath form is added. Or would I add a different field to accomplish this.

how to set whole number(integer) in infopath form

I have some whole number(integer) field in infopath form  and need to set these field in task using workflow

but if I select numeric type in custom task wizard and afterwards I can not select this task field when I need to set the whole number(integer) with value I want, strange! !

So how to set whole number(integer) field ??

Infopath 2010 designer is not allowing to save or publish infopath 2007 form with design checker err


Infopath 2010 designer is not allowing to save or publish infopath 2007 for with designer checker error one for each view:

Error: "Some types of groups or fields are not supported."

As it is not pointing the exact control, I have tried removing all controls and fields but still it is showing the error.

Please advice if i need to re-create the form.

Hemant Joshi:: http://sharingthepoints.blogspot.com/

Formatting problem with Email from an Browser Enabled InfoPath 2010 Form in SharePoint 2010


I'm creating a form in InfoPath 2010 to be filled out in the browser within our SharePoint 2010 instance. It's pretty simple, four columns with total table width of about 650 pixels, textboxes, checkboxes, datepicker and one multiselect list box. The form is working fine up to the point where I invoke a data connection which emails the form to myself. When it arrives in my inbox, the format of the form included in the body of the email is funky. When I open the email and set it to a full screen viewing window (1440X900) the area that takes up the form exceeds the width of my viewing window and requires scroll bars to see all the fields on the form.

When printing the form from my email the area is so large that no data will show up in the printable area (it appears to be centered on the form and it is cutting off the "extra content" to the left and right which contains the form data as the user entered it). I'm using Outlook 2007. I also forwarded the email to a person who's using Outlook 2010 and they experienced the same problems as myself.

Things I've tried to fix it: Setting each column width, setting each control width to a pixel length (instead of using %). I added some code behind to switch the view to a two column view with a table width of 400px before it sends out the email. It's closer to being at a state where it's

Can you embed an Infopath 2007 form with MOSS 2007 in an Outlook 2010 email?



MOSS 2007, Infopath 2007 and Outlook 2010

Is it possible to embed the Infopath Form in the email itself.

I read this link (point 1) http://office.microsoft.com/en-us/infopath/microsoft-office-infopath-2007-top-10-benefits-HA010165024.aspx, but I have been unable to do this?

Do you have to have Infopath 2007 on the client machine to be able to do this?




InfoPath 2007: Designing Form Templates With The New Features Of InfoPath


InfoPath 2007 is an XML forms designer and editor, and a fully featured and integrated member of the Office family. This article takes a sneak peek at some of its new features.

Scott Roberts and Hagen Green

MSDN Magazine August 2006

How to set rule only on form validation success InfoPath 2007



I'm a newbie to InfoPath 2007. I am creating a from without code. Is there a way to set a Rule to the Submit Button which will be triggered only in the case of Form validation success ? can we make use of the "Set condition" to setup a expression  in the Rule, for this purpose. Still i have no idea how to come up with an expression for such purpose. Can someone please explain.

Infopath 2007 print view in browser enabled form with Print button


Hi i create a  print view brower enabled form in Infopath 2007 with header and footer. In Infopath works fine. Margin was ok, header and footter to. But then i try to print this browser the margin, header and footer it changes to default setting of browser ? I try also create a print button in form with VS 2008 code, but method :

this.print(); not working.

It is possible to print the "print view" in browser as the same like in Infopath 2007? Does anyone have the code how to create a print button in C# on browser enabled form?

Submtting Calendar items with variable date information via InfoPath 2007 form



I've seen several posts regarding submitting to a list using and InfoPath form which I am successfully able to do in limited form. (only passing a basic date value) My environment: MOSS 2007 Enterprise w/SP2, InfoPath 2007, SPD 2007.

I'm basically trying to recreate a calendar form with the same data elements (and some additional ones for a specific business requirement) as the standard calendar newform.aspx form. (start time, end time broken down by date, hour, minute and All day event)

I need the form users to be able to select the date and if it is not an All day event...be able to select the hours and minutes just like on the newform.aspx. (date picker control for date and drop downs for hour and minute selection)

On submit I then need to create the list item with the appropriate data passed via a workflow.

My Start Time has a validation rule to not allow dates prior to the current date (and it can't blank) The End Time has a validation rule to not allow dates prior to what is specified as the Start Time value. (Also can't be blank) When I attempt to include conditonal formatting to hide the hour and minute drop downs if 'All Day Event' is selected I get errors stating the fields can't be blank.

I also can't figure out how to pass the entire date/time values or the All Day Event to the list withou

Issue in Infopath 2007 browser form - cascading dropdown using owssvr.dll filter view


Referring the below link, I created a cascading dropdown. The parent dropdown has sharepoint list as datasource and the child dropdown has xml datasource that points to owssvr.dll filter view. The cascading drop down works fine in preview but throws error after publishing as admin approved form - "form cannot run the specified query" exception when trying to execute xml datasource i.e., when a value is selected in parent dropdown. The security is 'Full Trust". In the event viewer the error message states "401 unauthorised" for the user a/c. the xml data source is an approved udcx file and in central admin, have enabled cross domain for infopath service. I have tried different solution provided in tech forums but issue still exists. Not sure whether Im missing something. Can someone guide me in fixing this issue?

Link Reffered:



wss2.0 Infopath 2007 'This form requires connections to data sources when it is loaded. At least on


Hi all

I have a user who receives the error 'This form requires connections to data sources when it is loaded. At least one of these connections is not available. As specified by the form designer, this form will not open' when trying to Submit an infopath form located on a WSS2.0 site.

The user has been having this issue since upgrading to Office 2007 and IE7. I have had the user run an Office Diagnostics but this has not resolved the issue.

I am not aware of any other users experiencing this issue.

Any ideas please?

Deploying InfoPath 2007 form to WSS 3.0 as browser enabled


Please Help! I've created an Infopath form and wanted to deploy the form as browser enabled to WSS 3.0? What are the different options I can do this? If i cannot use a form then i would like to  create a custom list with all the form fields but the user should be able to enter information in the list and he should see only the information related to him. I don't want to give access of the whole list to each and every user. Only the administrator should be able to see the whole list. The form was actually a user access request form.

Any help and suggestions is appreciated.


Infopath 2010 Browser Based Form Vs Infopath 2010 Filler Based Form Issue

I have created a detailed infopath form that is connecting to multiple sharepoint lists, some of which contain thousands of rows and dozens of columns.  To tailor for the data load i have enabled the form to only pull in data as needed and on some of the lists i have created 5 or 6 data connections to the same list, each only looking at a certain set of data, and as you make your way through the form selecting your options, the data is pulled in. If i preview this form from within Infopath or if i launch it using Infopath filler this works great, the data is pulled through in under a second.  However if i then publish the form to the browser and launch it through the browser, it now takes roughly 30 seconds to pull in the data. My question is therefore this,  Is there something i can do to speed up the way the data is pulled in when launched through the browser?  are there transport protocols i can alter or something like that? maybe config in central admin or infopath config? any help would be gratefully appreciated as if i can not get the form to pull the data in fast through the browser then the whole project is a waste of time as my management team will never go for the solution if it is slow and will get slower as more data is added. thanks

Changing fields while updating an InfoPath Form to a SharePoint 2010 Document library

My document library has following EventReceiver: <?xml version="1.0" encoding="utf-8"?> <Elements xmlns="http://schemas.microsoft.com/sharepoint/"> <Receivers ListTemplateId="101"> <Receiver> <Name>EventReceiverDocumentLibraryItemUpdating</Name> <Type>ItemUpdating</Type> <Assembly>$SharePoint.Project.AssemblyFullName$</Assembly> <Class>EventHandling.EventReceiverDocumentLibrary</Class> <SequenceNumber>10000</SequenceNumber> </Receiver> </Receivers> </Elements> Updating a browser enabled InfoPath form in the document library fires following event: Public Overrides Sub ItemUpdated(ByVal properties As SPItemEventProperties) Try Me.EventFiringEnabled = False properties.ListItem("Lastname") = "Testperson" properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = True properties.ListItem.SystemUpdate(False) ' solution 1 properties.ListItem.Update() ' solution 2 properties.ListItem.UpdateOverwriteVersion() ' solution 3 properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = False Me.EventFiringEnabled = True MyBase.ItemUpdated(properties) Catch ex As Exception Me.EventFiringEnabled = True E
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