.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

Testing InfoPath Forms with Rules using GetCommonMemberships Data Connection

Posted By:      Posted Date: October 28, 2010    Points: 0   Category :SharePoint

I have my first InfoPath form coming up for testing. This uses a GetCommonMemberships data connection as a condition for various rules (for example, form load rules that switch views when the user is a member of a Packaging AD group). I’m not a member of any of the AD groups being used for these conditions and neither are the company’s QAs.

Because I’m not a member of any of the groups, I tend to set my rule up in reverse to check it. For example, if I have a rule where the DisplayName is equal to “domain\Packaging” (of which I am not a member), the control is not disabled for me. This assumes that the opposite is also true if I change the rule to is not equal to “domain\Packaging”. In other words, the control should not be disabled for members of that group but it should be for me.

How do you guys allow your QAs to impersonate different team members to properly test this without compromising the integrity of the form?

View Complete Post

More Related Resource Links

Building InfoPath forms against Sharepoint 2010 Data Connection Library and Form Services...


Hi Sharepoint Experrts,

I'm trying to develop InfoPath 2010 forms that use External Lists that have been created in Sharepoint Server 2010.  I have problems when testing the forms because access is denied to the external lists.

When I try deploying the forms to the sharepoint site, I cannot upload the form template because it says I have to be a member of the local administrators group.  However, I'm running the administrator account used to install and setup sharepoint on the Windows 7 development machine I'm using.

I also tried loading the InfoPath Data Connections to a data connection library on my Sharepoint site... I can see the files when I login to the site but when I try creating a New form from a Data Connection File, I get an error message "This location does not contain any data connection files with the appropriate settings".  What ARE the appropriate settings?

I'm just really confused about this because I cannot seem to be able to build forms that use data connection files loaded onto a Sharepoint site or central server....

I appreciate any help I can get!




Thanks, KBW

Integrating InfoPath 2010 Forms with the SharePoint 2010 Data Connection Library

Learn how to create a data connection library on SharePoint Server 2010, and create a UDC file in InfoPath Designer 2010 to define a SharePoint List connection.

External Lists and Infopath forms issue with Secondary Data Sources

I've followed this tutorial for creating and customising forms for external data (http://blogs.msdn.com/infopath/archive/2010/03/11/customize-an-external-list-form-in-infopath-2010.aspx).  The only difference being that my seconday data source is not an XML file (I've tried database connection and existing sharepoint lists both internal and external) When running the design checker I get the message "Additional Data connections not supported" and my form won't publish.  Any ideas?

Get user info in infopath using data connection

hi,  i want to use the absence request template form and connect the employee section and manager section to an existing database. what i want to create now in this template is this (i'm going to explain my scenario): - when the user open the infopath absence request form and insert his name, id number etc (employee section), the approver's name and mail addres (manager section) filled automatically. the approver name must be corresponding to the user name. in the existing database there is a table with the approvers name filled for each user, but from there i dont know how to apllicate this table to use for the auto fill. and after the form is ready can i publish it to my wss 3 site collection? is there a tutorial that explain a scenario like this? thnx

import data from infopath xml forms to SharePoint list

Hi. I have this issue, a customer has an old application that consists of a SharePoint 2003 site and a 'forms library' with forms listing information about physical servers. The infopath (2003) form is pretty straight forward and has a few dropdowns from lists and so on. Now, we need to move this to 2010 and preferably to a list only using oob functionality. I would like to know if anyone has a clue as to how I can get the data from the hundreds of xml files into a list, could be to excel and then to SharePoint, or any means Necessary. I would prefer it if it can be scripted or done using standard tools from Microsoft, no 3rd party custom xml importer...(if it's not really good and free :-) ) ThanksThomas BalkestÃ¥hl - Technical Specialist - SharePoint

Infopath bug in windows 7 to convert datasource to data connection library in sharepoint?

Any ideas about this bug: Windows 7, infopath 2007, did not check in the data connection file when converting a data source? Also it did not set title and kept the file checked out so that you can not even update the items by SharePoint UI. I did everything successfully with Infopath 2007 on a windows xp machine. Is the OS related in this case? Thanks,

auto-populate infopath form with sql server data connection



is it possible to auto-populate an infopath form with a sql data connection?

i have a form that only populate the username of the logged in user. but i want to use a secondary data source to auto-populate the user his email, id and department all comming from a sql server database.

and after that auto-populate the user's manager name using sql server db

is this possible in infopath 2007 and how can i do this?

InfoPath crashes after trying to add data connection


Hi All,


I have created a view in my database which selects and ID and Name columns from a table. When I try to add a data connection in infopath linked to this view Infopath crashes. The following is information from the event log:


"Faulting application infopath.exe, version 12.0.4518.1014, stamp 45428209, faulting module ipdesign.dll, version 12.0.4518.1014, stamp 4542826f, debug? 0, fault address 0x003786fa.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp."


I have created other views that read from other tables and these one do nothave a problem....Any suggestions are very much appreaciated.



Using Infopath rules and filters off an XML data source


Hi Everyone:

Using InfoPath browser based form, I have an drop down menu connected to another list using an XML data source (I am doing this so I can use the view to control the data in the drop down menu).

When the user selects a value from a drop down, I also want other fields in the form to populate with the corresponding data for that item from the other list. I can't get the filters to work and I am not sure what I am doing wrong. I originally had just a regular secondary source for the list and the filters worked just fine but I need to use the XML source so all items will show up in the drop down, not just part of the list. So the XML data source shows odd field names like ows_Project_x0020_Number in the zrow of the XML source. I set up all the filters but when I select an item from my drop down the other fields are only showin the first items from the list and not filtering to my selection.

Hope you can help.




InfoPath Forms Services has detected a mismatch between the user's data in the browser and on the s


Hi All,

I am getting following error message in my SharePoint Logs,

InfoPath Forms Services has detected a mismatch between the user's data in the browser and on the server. This may indicate the SESSION_STATE_PASCAL_CASED is not configured properly on a multiple front end farm or that a malicious user is trying to tamper with client data.

Any idea how to solve this issue ?


Muhammad Tariq khan

Infopath form updating from secondary data connection initally, then not!


Let me set up what I am doing...

I have a table with multiple text boxes. Each of these text boxes pulls a total for it's corresponding item from a SharePoint List. Each item has 3 boxes that return three different totals.(Filters correctly into This week, This month, and Year to date).

When I open the InfoPath form initially all the columns return the correct totals. Now If I edit the date created on an item; so that it was created last month. Nothing changes on my infopath form. The created this month total remains the same.

I have my data connection set to update everytime a form is opened.

What am i missing?


InfoPath: Copying values from a multiple-selection lookup (secondary data connection) to a multiple-

Trying to use "Set Field Value" action in InfoPath to set values in a multiple selection lookup field. Does not not seem to be possible. Has anyone achieved this?

How to remove data connections dependancy from infopath forms?


Hi All,

In my Infopath forms there are hard coded data connections.

For example GetUserProfileByName data connection has url http://site_url:port/_vti_bin//UserProfileService.asmx?WSDL. Every time I want to publish the form to different site url, port, I have to modify such data connections. Is there any way to remove this dependacy or make it configurable from some central location.


Rahul Babar

Dot Net, Sharepoint, Infopath Developer

Need Oracle Data Provider .CS File for Oracle 10g Database connection !



I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where

i can just call the method with my SQL Query


Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");


Plz Post the link if there is any open source !    

Input Validation: Enforcing Complex Business Data Rules with WPF


Windows Presentation Foundation has a rich data binding system that includes flexible support for business data validation. We take a look at implementing some complex data input validation scenarios that include customized data errors for users.

Brian Noyes

MSDN Magazine June 2010

Know Thy Code: Simplify Data Layer Unit Testing using Enterprise Services


If you want to employ unit testing and test-driven development techniques in your database application development process, you'll have different factors to consider than you do when you're not involving a database. For example, you have to maintain a consistent state within the database and be able to roll back transactions when necessary. This article shows you how to get the best of unit testing for your database apps in a safe, usable manner.

Roy Osherove

MSDN Magazine June 2005

Draft a Rich UI: Ground Rules for Building Enhanced Windows Forms Support into Your .NET App


In this article, the winning Windows Forms duo of Chris Sells and Michael Weinhardt team up again to explore lots of new features and additions to Windows Forms 2.0 that will let you build more flexible, feature-rich controls, get better resource management, more powerful data-binding abilities, and make your development life a whole lot more fun.

Michael Weinhardt and Chris Sells

MSDN Magazine May 2005

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