Qdabra qRules

Re: Using Infopath Form to Update a Single field in Custom List

llaurens — Mon, 14 Feb 2011 05:37:51 GMT

Hi Mel

Thanks for the posting. I successfully completed the evaluation last year sometime and purchased a license.

Re: Using Infopath Form to Update a Single field in Custom List

Mel Clemente — Sun, 13 Feb 2011 15:33:26 GMT

Hi Lance,

How's the evaluation going? Are you still having issues using qRules in your InfoPath forms?

You might want to try the latest version - qRules v2.4 which we released on December. With this release, there are now more than 50 unique commands available. More commands will be introduced in the upcoming major release.

Do try it out and let us know if you need assistance in your evaluation.

Best Regards,

Re: Using Infopath Form to Update a Single field in Custom List

llaurens — Thu, 25 Nov 2010 05:42:23 GMT

I have finally been able to resolve this issue of submitting via web services. With much help and patience from Hiliary and Ernesto, I was able to track the resolution to a registry change as described by Zeroecho at this link: http://www.infopathdev.com/forums/t/7676.aspx?PageIndex=2.

The issue revolved around using load balanced servers. Submitting directly to indivdual front end servers worked but this obviously was not the solution. The IP client would update the SP list successfully but in web services I got the "401 unauthorized" error in the qTools error field and "An error occurred accessing a data source. An entry has been added to the Windows event log of the server. Log ID:5566" when submitting. I used the above resolution in Windows Server 2008 R2, SP 2010 and IP 2010.

Thanks to the team for great support.

Re: Using Infopath Form to Update a Single field in Custom List

ErnestoM — Tue, 26 Oct 2010 13:01:35 GMT

Hi Lance,

Would it be possible for you to send us your form and the mapping file? This would help us to understand and fix the issue.

You may contact us via support at qdabra dot com

Thank you.

Re: Using Infopath Form to Update a Single field in Custom List

Patrick Halstead — Tue, 26 Oct 2010 08:26:55 GMT

Hi Lance,

Thanks for the extra detail. We will investigate and respond within 24 hours. We appreciate your patience.

Best regards,

Re: Using Infopath Form to Update a Single field in Custom List

llaurens — Tue, 26 Oct 2010 06:56:29 GMT

In Infopath 2010 in the Data Connections box, there is a button labeled "Convert to Previous Version" or "Convert to Current Version" depending on the comptibility setting in Form options. Because I had changed the compatibility to Infopath 2007, I then had to also convert the data connections to previous version.

By the way, I also tried creating a new form from scratch Infopath 2007 compitibility mode to eliminate any possible issues with converting the data connectors. I ran into exactly the same problems.

To summarise: In Infopath filler, the form submits to the Forms Library and also updates the Custom List field succesfully.

In Web Services, the form submits to the forms library successfully but does not update the Custom List at all.

It seems to me that the "Submit to Web Service" data connector is just not firing in IP Web services.

Re: Using Infopath Form to Update a Single field in Custom List

llaurens — Tue, 26 Oct 2010 06:44:39 GMT

Under the Form Options - Compatibility, the Form Type is set to "Web Browser Form (Infopath 2007)"

Re: Using Infopath Form to Update a Single field in Custom List

ErnestoM — Mon, 25 Oct 2010 16:37:58 GMT

Also, can you elaborate on what you mean by “converted data connections to previous version”?Thanks.

Re: Using Infopath Form to Update a Single field in Custom List

ErnestoM — Mon, 25 Oct 2010 13:50:15 GMT

Hi Lance,

Thanks for the additional information. The evaluation copy is not the cause of the problem; we include full features in the trial copy.

I'm concerned about the compatibility setting. You mention that you have a version of the form that works in the client; can you check the compatibility settings for that and let us know what it's set to? I'm afraid that if it's set to anything other than Web Browser Form (InfoPath 2007) it will not work in the browser (IPFS).

Re: Using Infopath Form to Update a Single field in Custom List

llaurens — Mon, 25 Oct 2010 13:10:49 GMT

Hi Ernesto

Thanks for the suggestions. I have added the Error, Result and Success nodes to the form. As mentioned previously, when submitting via Infopath filler, the form works perfectly. However, subimitting the form via Infopath Web services (2010), the custom SP list does not update and I get the following error: "An error has occurred executing the rule. Failed to submit to SharePoint. URL = '{0}'."

When I injected the form I selected the "Inject Browser and Client Compatible Features" option.

I set the controls using the qRules to always Postback. This made no difference.

I set the Compatibility in form options to "Web Broweser Form" (Infopath 2007)". I then converted the data connections to Previous Version. I ran a Modify on the affected data connections. I then had to reconfigure several rules as the conversion changed the X path name for the data retreive connection. This excercise caused problems with the data retreive connection as it would not read several columns in the custom SP list correctly and rendered the form unusable. I ended up reverting to a backup of the Infopath form.

Is the fact that I am still using an evaluation copy causing problems?

Re: Using Infopath Form to Update a Single field in Custom List

ErnestoM — Thu, 21 Oct 2010 12:55:50 GMT

Hi Lance,

Thanks for the praise.

Concerning the issue you've encountered, a few things come to mind.

1. Are you displaying the qRules Error, Result and Success nodes in the view? You mention no error is displayed but I want to make sure you're looking at these fields.

2. In the browser form, the controls that use qRules commands need to be set to always Postback.

3. Are you using InfoPath 2010? Go to Developer > Language > Compatibility, and select Web Browser Form (InfoPath 2007) from the Form type: drop down. qRules uses the InfoPath 2007 Object Model. This means that we need to use the InfoPath 2007 Web Browser form in SharePoint 2010.

4. When injecting, did you select the Browser or the Client option?

Let's start with that, and if none of these address the issue then we'll dig deeper. Thanks.

Re: Using Infopath Form to Update a Single field in Custom List

llaurens — Thu, 21 Oct 2010 09:56:46 GMT

Hi Ernesto. Thanks for the follow up. The support on this site is brilliant.

I used Hilary's recommendation of the CopyTable command and combined this with the SubmitToSharePointList command and got it to work like a charm to update the inventory list as well as submit to a form library with Infopath filler. However, I have not been successful in getting this work with Infopath Web Service despite publishing as an Administrator approved document. The form submits to form library but the SubmitToSharePointList command does not update the inventory list. It displays no error. Can you comment on whether it should work in Infopath Web Service?

Re: Using Infopath Form to Update a Single field in Custom List

ErnestoM — Wed, 20 Oct 2010 15:44:06 GMT

Hi Lance, any updates on this?

Thanks.

Re: Using Infopath Form to Update a Single field in Custom List

llaurens — Wed, 13 Oct 2010 05:33:19 GMT

Thanks for replies and suggestions. I will test this today and report back.

Re: Using Infopath Form to Update a Single field in Custom List

Patrick Halstead — Wed, 13 Oct 2010 02:14:30 GMT

Here's another blog that shows how to copy items into a main data source when the schemas differ (uses SharePoint list as the source and InfoPath as a destination).

http://www.infopathdev.com/files/folders/qrules/entry58577.aspx