Qdabra qRules

Re: Issue trying to get qRules injected form working with SharePoint List

Hilary Stoupa — Tue, 22 Jan 2013 16:29:04 GMT

Adding a link to your new thread on this.

Re: Issue trying to get qRules injected form working with SharePoint List

Den12 — Mon, 21 Jan 2013 18:19:17 GMT

Hi Ernesto,

I have a similar situation, but with a Workflow Task form. Getting similar messages, but not quite.

However, I was able to inject qRules 4.3 (trial) into a Workflow Taskform (SP 2010 enterprise & Infopath 2010, 64-bit, no C# or VB code before injection) with a warning:

[1] "The form template has been published to the server, but can only be opened in Infopath because it contains features that are not compatible with web browsers.

To fix this problem, close the dialog and review the errors in the design checker task pane".

[2] Runnning the design checker shows no errors, but it does show "Click Change Settings.. to provide the address of the server where you plan to publish this template. This will make error checking more accurate."

Now it is interesting, that:

-the Workflow task form (infopath 2010) is actually opening in the Infopath client from the workflow e-mail notification (use Open Task in MS Outlook).

- same workflow task form is able to approve/reject and complete successfully the workflow.

- was able to use people picker control (outside repating table), to properly authenticate all AssignedTo users..to be used for a following step in a multi-step workflow.

Now the parts that do NOT work:

- trying to open the assigned Task from the Workflow -> Tasks page , In Browser, produces an error, as warned in [1], but it opens nicely in Infopath Client/Filler.

- The AssignedTo users (properly parsed using the double eval trick and formatted to submit multiple users via the SubmitToSharepointList qRules command) together with Due Dates and descriptions is supposed be populating the rows of a repeating table. It WORKS when run on the desktop (same form being published), BUT the Description and Due Date fields are now DISABLED (opening from MS Outlook Task notification)!?!?

Reference to that functionality mentioned at http://www.infopathdev.com/forums/p/15290/86156.aspx#86156 and http://www.infopathdev.com/forums/p/24879/86188.aspx#86188.

- Custom "Add Task" button, using rules to move the data from non-repeating controls to the repeating table is ACTIVE, but the rules (OOTB rules, no qrules commands here), which work when form/template executed from desktop, but does NOTHING when run from MS Outlook "Open Task".

- the mapping used with qRules on that form has been used successfully with a similar non-published Infopath+qRules form, same target list for submitting the items from the repeating table, but NO re-mapping done after used on the workflow form (id is not mapped as it is not specified on the workflow taskform).

Could you please clarify whether the limitation for publishing Infopath Forms with qRules (4.3 trial here) to SP List is also valid for Workflow Taskforms. It looks like it might be possible..

Re: Issue trying to get qRules injected form working with SharePoint List

ErnestoM — Tue, 31 Jul 2012 12:05:35 GMT

Hi,

You can't add code to SharePoint list forms. If you click on Customize form in a SharePoint list, the form will open in InfoPath's design mode, then go to the Form Options -> notice there is no option for Programming.

qRules cannot be added to a SharePoint list form because SharePoint List forms cannot have code.

Instead, create a blank new form (not based off a list) and then inject qRules. You can use qRules commands to write to a SharePoint list, but your form will be published to a ShP form library.

Here is the qRules page with videos and tutorials.

Good luck.

Re: Issue trying to get qRules injected form working with SharePoint List

mossums — Tue, 31 Jul 2012 07:55:56 GMT

I too am receiving the below error after injecting qRules 4.2:

The SOAP response indicates that an error occurred on the server:
Server was unable to process request. ---> Object reference not set to an instance of an object.

In SP2010 I click on a basic custom list, select the ribbon list tool list tab, click the edit in Infopath icon, wait for the form to download and open in designer, save the form, close infopath, inject qrules for a 2010 browser form, reopen the form, then quick publish. There is no custom code in the form. This error has been repeated by another staffer on a completely independent SP install.

What am I missing, as this is the most straightforward and common out of box behaviour for editing Sharepoint forms with Infopath?

If you can't use qRules this way, please advise ASAP.

Re: Issue trying to get qRules injected form working with SharePoint List

ErnestoM — Wed, 14 Sep 2011 17:52:12 GMT

Hi,

To submit to a SharePoint list, qRules has a command called SubmitToSharepointList. You'll find more information here:

http://www.infopathdev.com/blogs/hilary/archive/2009/11/16/submit-items-to-a-sharepoint-list-with-qrules-v2-0.aspx

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

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

Hope these help.

Re: Issue trying to get qRules injected form working with SharePoint List

Micheal Goodwin — Wed, 14 Sep 2011 17:46:09 GMT

Thanks for the response. I hadn't seen that document so thanks. After following the steps in the document I got stuck on Step 3. As the instructions are for Infopath 2007 and I'm on 2010 I figured a button/function was moved so I started researching where to find the "missing" Programming commands. I found that what is missing is due to the fact that I am working on a form attached directly to a SharePoint LIST and these commands are only available if you are working on a form submitting to a SharePoint LIBRARY.

So now I'm gravely concerned. I need to be able to submit my form data directly to a SharePoint List but it appears that I can't get qRules to work to do this... or can I? If so the document and info I've come across so far don't seem to apply to enabling an Infopath 2010 form submitting to a SharePoint LIST.

Re: Issue trying to get qRules injected form working with SharePoint List

ErnestoM — Wed, 14 Sep 2011 16:05:14 GMT

Hi Michael,

I'm sorry you've run into issues. You mention that you've injected the InfoPath form with qRules, but since the form has code, the process is not as easy as injection. Have you seen this document?

Thanks.

Issue trying to get qRules injected form working with SharePoint List

Micheal Goodwin — Wed, 14 Sep 2011 15:37:31 GMT

I am new to qRules and Infopath custom code... I'm trying to get an injected form published back to the SharePoint list. I'm obviously doing something wrong or am not using the program correctly but browsing the documentation hasn't pointed me in the right direction.

Following is what I have tried with associated errors:

1. SANDBOX SERVICE NOT RUNNING

I am able to open the form directly from the SharePoint List ribbon. I Save As and save the file to a known location. I close the form. I successfully Inject the form. I can then open it in Design mode in Infopath but when I try to Publish it back to the SharePoint list I get the following error:

The SOAP response indicates that an error occurred on the server:

Server was unable to process request. ---> Form template "Lists/Assessments/Item/f09ad1e8-0596-42e9-96cc-f9f3c74c22b9.xsn" cannot be browser enabled because the sandboxed code service is not running on the server.

2. SANDBOX SERVICE RUNNING

I start the Foundation Sandbox Service in Central Admin. I immediately open the injected form in Design Mode and attempt to publish again back to the SharePoint list and get the following error:

The SOAP response indicates that an error occurred on the server:

Server was unable to process request. ---> Object reference not set to an instance of an object.