Qdabra qRules

Re: updating and deleting items in sharepoint list

rodrigosmith — Thu, 08 May 2014 12:57:40 GMT

Hi Hilary, I have a issue that I have no idea for resolve. I have to make a view in Sharepoint from three repeating table, each with a fixed line. Could you help me? Thank you!!!

Re: updating and deleting items in sharepoint list

ErnestoM — Mon, 15 Jul 2013 21:15:15 GMT

If an XML form (in a SharePoint form library) is deleted, its related SharePoint list items will NOT be deleted from the list. In order for qRules to execute, the form must execute actions (rules).

Hope this helps.

One of the possible issues "You do not have permissions to access a SharePoint list that contains data required for this form to function correctly."

Stefan Lankester — Thu, 20 Jun 2013 06:58:45 GMT

When you have an InfoPath form containing a data connection for retrieving SharePoint list data you might get these below error:

"You do not have permissions to access a SharePoint list that contains data required for this form to function correctly.".

This error might occur after redeployment of the form in for example SharePoint webtemplate solution (recreation of the site and list) or you try to deploy the form on an other site.

In this situation the problem isn't actually an access denied error. The real problem here is that for InfoPath services the list doesn't seems to exist. The reason for this is that list you retrieve data from has gotten a new unique GUID. (Data Connection retrieves data from the list by looking for it's unique GUID.)

The advice here is that you use a SharePoint Data Connection library for storage of the UDCX files. Deployment of the form by using a feature you now are able to dynamically update the UDCX file and change the List GUID (and to make other changes when needed).

	<udc:ConnectionInfo Purpose="ReadOnly" AltDataSource="">
		<udc:WsdlUrl/>
		<udc:SelectCommand>
			<udc:ListId>{7CB78DC5-5BDD-4C66-8C33-0375FFAAFBD1}</udc:ListId>
			<udc:WebUrl>your site url</udc:WebUr>

ListId > Update it to the new unique GUID id of the list after recreation.
WebUrl > Update the Url also when needed.

In a OTAP situation i expect that connection of InfoPath form to the SharePoint Data Connection lib is relative. So no updates needed in the InfoPath form in OTAP situation deployment.

See these two Links for deployment of InfoPath forms by feature and dynamically updating your UDCX files:

http://nader.elshehabi.com/2011/08/how-to-really-deploy-infopath-2010-forms-with-code-behind-as-a-feature/
http://nader.elshehabi.com/2011/09/dynamically-modifying-udcx-connection-files/

Greetings,
Stefan Lankester

Re: updating and deleting items in sharepoint list

Hilary Stoupa — Fri, 24 May 2013 17:38:49 GMT

Wonderful! Glad you got it figured out!

Re: updating and deleting items in sharepoint list

lcountee — Fri, 24 May 2013 17:35:56 GMT

This is fixed. I had updated permissions correctly for end users, but not for my testing account. Happy Friday. Thanks for all the help.

Re: updating and deleting items in sharepoint list

lcountee — Fri, 24 May 2013 13:20:53 GMT

Yes, I've checked a bunch of times. :(

Re: updating and deleting items in sharepoint list

Hilary Stoupa — Thu, 23 May 2013 19:52:40 GMT

Do your users have read permissions to all lists or libraries your form is querying?

Re: updating and deleting items in sharepoint list

lcountee — Thu, 23 May 2013 19:47:28 GMT

My form is working in my test environment, but after I moved it to my production environment, users get an error: "You do not have permissions to access a SharePoint list that contains data required for this form to function correctly." (I don't get the error when logged in as myself with admin rights.)

I've checked all of my data connections, and they all seem to be correct. Is there anything qRules-related that I might have missed? Thanks.

Re: updating and deleting items in sharepoint list

Hilary Stoupa — Tue, 21 May 2013 17:31:43 GMT

No - there is no way that qRules, which is executed from within the XSNs logic, can know that an XML has been deleted. You'd want to use some kind of custom workflow for this.

Re: updating and deleting items in sharepoint list

lcountee — Tue, 21 May 2013 15:44:07 GMT

Sorry if this is a silly question, but I have a deadline I'm trying to meet and I need to make sure I'm going in the right direction. It looks like RefreshSharePointListItems will delete individual items from a SharePoint list. But what if the entire InfoPath form is deleted? Will all of the corresponding items in the SharePoint list be deleted? Thanks.

Re: updating and deleting items in sharepoint list

Hilary Stoupa — Tue, 21 May 2013 14:24:35 GMT

Perfect. So have you modified any of the items in the list after creating them? The XML sample has the last modified date/time and will compare it to the last modified date/time in the list to see what needs to be refreshed.

Re: updating and deleting items in sharepoint list

lcountee — Tue, 21 May 2013 13:33:31 GMT

Changed TRUE to true. Success now says "false" and Error says "Failed to refresh list items: No list items to refresh. Verify parameters are correct."

Re: updating and deleting items in sharepoint list

Hilary Stoupa — Mon, 20 May 2013 21:48:32 GMT

Change the condition on finishedLoading to finishedLoading = true instead of TRUE.

Re: updating and deleting items in sharepoint list

Hilary Stoupa — Mon, 20 May 2013 19:53:40 GMT

Can you email the XML you are previewing with?

Re: updating and deleting items in sharepoint list

lcountee — Mon, 20 May 2013 19:49:22 GMT

Hmm, the error node is blank also. I've attached a screenshot of all of the QdabraRules nodes.