Qdabra qRules

Re: Upgraded Qrules to 4.3 and Commands are not working

jerryO — Mon, 01 Apr 2013 16:33:37 GMT

Hi Hilary,

Thanks for the update, I created a new mapping file and named it mapping. I removed the ID and the mapping from the refresh command. It is working on all three forms now. I tried removing only the id from the refresh on the last form and still had the same problem until I created a new mapping file and removed it from the refresh.

In the future I will setup all forms with this config. Thanks a million for all the testing you have done.

Re: Upgraded Qrules to 4.3 and Commands are not working

Hilary Stoupa — Fri, 29 Mar 2013 19:54:49 GMT

Okay, I took your form and made some minor changes to use it with my Office 365 site. I added 4 rows to the form and submitted to my list - verified they were there. I then executed the refresh command. Then I deleted two rows from the middle of the table in the form and submitted again - both items were deleted from my list. So - this makes it seem like it is an issue on your site / machine? I'm just not sure at this point. I did slightly modify your commands - with 4.3 (actually, I think as of 4.2) you don't have to include /mapping if it is named "mapping" and you don't have to include /id if it is mapped in your mapping.

Re: Upgraded Qrules to 4.3 and Commands are not working

Hilary Stoupa — Thu, 28 Mar 2013 22:04:33 GMT

Okay, thanks for that info as well - with my test the other day I was not deleting just the first item (and I do recall this was a bug with this feature at one point, but I believe it was resolved). I'm sorry it is taking me so long to get the time to set up a test for your form, but I'm hoping to get that done still today.

Re: Upgraded Qrules to 4.3 and Commands are not working

jerryO — Thu, 28 Mar 2013 11:41:02 GMT

After reading some of the other old posts on this matter I have come across the following. If I create multiple items in the table(3) and they are submitted to the list, I can delete the very first item in the table and it will get removed from the list! If I try and delete any of the other items, it does not work.

If I delete the first item in the table and press the submit button, i immediatley get the following in the result:

Item does not exist. The page you selected contains an item that does not exist. It may have been deleted by another user.

When I look in the item view, the item has been deleted. WooHoo!

I do not get anything in the result if i delete the others and the item does not get removed from the list.

Re: Upgraded Qrules to 4.3 and Commands are not working

jerryO — Wed, 27 Mar 2013 19:41:00 GMT

Thanks Hilary, this is happening on the three forms I am using the submit and refresh with. I am working with MS on the qRules Office 365 and web forms problem and they had be upgrade to 4.3 becuase that is the trial version they had. After I upgraded, I started seeing these problems. One thing I did notice is on the Refresh data connection, when I add the View ID, I change the ID so that it has curley braces at the front and back along with the "-". After I inject the curely braces turn into %7B and &7D. I can change them back to braces but it looks like they keep changing back. It does this on all the forms I have been referencing. Not sure if this has anything to do with it but I thought it was strange.

Re: Upgraded Qrules to 4.3 and Commands are not working

Hilary Stoupa — Wed, 27 Mar 2013 19:28:01 GMT

Thanks for setting up a fresh try. I'll set up a test list to match yours and try this exact template so we can see if it is the template, the server, something else. It may be late tomorrow before I have a chance to do this. As I stated further up the thread - with a qRules 4.3 test form I created, deleting from the form also deleted from the list.

Re: Upgraded Qrules to 4.3 and Commands are not working

jerryO — Wed, 27 Mar 2013 17:13:29 GMT

To eliminate any type of corruption, I created a new site and a new blank form. Injected and created a mapping. I can sumbit to the library and the list with this new form. It is setup identicle as the last one.

I added another button for the refresh. I have one button for submit - SubmitToSharePointList /submit=ShPSubmit /mapping=mapping /id=my:ID

and one button for refresh - RefreshSharePointListItems /dsname=Refresh /id=my:ID /mapping=mapping /mode=Update

I have also added the result, error and qRulesLastModified fields to the form so I can see everything that is happening. (The refresh has also been added to the finished loading)

When I add items to the table and press the submit they are added to the list.

Each item get a lastmodified entry with the time it was added ( I added 2 items)
Result and error node are empty

If I refresh after making a change the result contains - Report for mapping: ItemList. All items match.

I have also tested on another form that I am using the refresh. After deleting an item, and refreshing, the error I am getting is:

Failed to refresh list items: Failed to select node for SharePoint list ID :/my:myFields/my:Plants/my:group2/my:ID

This is the path to the ID file in the repeating table

So far so good

If I delete an item from the table and press the submit button

lastmodified entry for that item disappears and results and error is blank
If I look in the list the item is still in the list
I press the refresh button on the form result=Report for mapping: ItemList. All items match
The item is still in the list and is not deleted.(1 item in form, 2 items in list)

If I close and reopen the form, there is one item left in the table and there is still two items in the list. The result field has-Report for mapping: ItemList. All items match

Am I missing something, I attached the template

Re: Upgraded Qrules to 4.3 and Commands are not working

jerryO — Wed, 27 Mar 2013 16:01:44 GMT

I am not adding code to the form, I know how to add the code. When I click on the form option, there is a button in the programming tab name "remove Code". I am not adding any custom code, but this button is able to be clicked many times. I will click the button, then a few days later if I am having problems like I am now, the button will be able to be pressed again.

Were you able to look at the form I sent that will not send to the list? I am referring to the error:

Action: SubmitToSharePointList. Arguments: submit: ShPSubmit mappingName: mapping id: my:ID . Details: Index (zero based) must be greater than or equal to zero and less than the size of the argument list.. Stack: at System.Text.StringBuilder.AppendFormat(IFormatProvider provider, String format, Object[] args) at System.String.Format(IFormatProvider provider, String format, Object[] args) at Qdabra.Tools.RulesLibrary.Commands.SubmitToSharePointList() at Qdabra.Tools.RulesLibrary.Commands.RunCommand(String commandName) at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand()

Everything was working fine with the forms using 4.2. After updating them with the 4.3, I seem to be having many issues.

Re: Upgraded Qrules to 4.3 and Commands are not working

Hilary Stoupa — Wed, 27 Mar 2013 15:55:58 GMT

Okay - looks like your qRules install is fine- this form has a DLL that is 4.3 and the XML for the data connection is also 4.3

You asked about how you are adding code - if you right click a field in the data source, one of the options is "programming" that allows you to add events. The developer tab in the ribbon allows you to add events. The properties of a button allow you to add events - generally, the dev environment opens when we do any of these things. Is that happening while you are working on your form?

Re: Upgraded Qrules to 4.3 and Commands are not working

jerryO — Wed, 27 Mar 2013 15:45:07 GMT

I created a new blank form and injected it. This was the text in the injection box.

Removed the trustLevel attribute
Removed the trustSetting attribute
Adding a file reference to Qdabra.Tools.RulesLibrary.dll
Adding a file reference to QdabraRules.xml
Adding a file reference to QdabraRules.xsd
Adding xsf:save node
Adding xsf2:managedCode node
Adding the missing scriptLanguage attribute on the xsf:solutionsProperties node
Creating the QdabraRules data object
Copying C:\Program Files (x86)\Qdabra Software\Qdabra Rules Library\Client2010\Qdabra.Tools.RulesLibrary.dll to C:\Users\oberjc\AppData\Local\Temp\pb0vaym3.dp3\Qdabra.Tools.RulesLibrary.dll
Copying C:\Program Files (x86)\Qdabra Software\Qdabra Rules Library\QdabraRules.xml to C:\Users\oberjc\AppData\Local\Temp\pb0vaym3.dp3\QdabraRules.xml
Copying C:\Program Files (x86)\Qdabra Software\Qdabra Rules Library\QdabraRules.xsd to C:\Users\oberjc\AppData\Local\Temp\pb0vaym3.dp3\QdabraRules.xsd
Adding an entry for the QdabraRules data connection to sample data
Injection complete.

Re: Upgraded Qrules to 4.3 and Commands are not working

Hilary Stoupa — Wed, 27 Mar 2013 15:15:26 GMT

Can you inject a blank form with your 4.3 build and attach it here? Just save a blank form, inject and attach - don't make any changes to the template. Thanks!

Re: Upgraded Qrules to 4.3 and Commands are not working

jerryO — Wed, 27 Mar 2013 15:09:56 GMT

Thanks for you time Hilary!

After hours of trying to find out why this is not working, I decided to create a new blank client form in a differnet test site. I added a 3 column repeating table and a button to submittosharepoint(SubmitToSharePointlLib). I injected the form as a 2010 client, and I created a mapping(mapping.xml) to map the three fields to a list(TestingQdabara43) I also added the result and error nodes to the form.

Although my submit is working fine in the old forms that were using 4.2 originally, this new form that was created and injected with 4.3 is not sumbitting to the list. The error message I am getting when submitting is:

The command in the submit button is = SubmitToSharePointList /submit=ShPSubmit /mappingName=mapping /id=my:ID (The field ID is capitalized)

The Mapping file is :

?xml version="1.0" encoding="utf-16"?>
<myFields lang="en-us">
<Mappings mappingName="TestingQdabra43">
    <ListCollection useName="false" ListName="TestingQdabra43">{72997136-35EB-4AD3-97B6-4E16F901B04B}</ListCollection>
    <IsRepeating>true</IsRepeating>
    <RepeatingGroup>my:myFields/my:group1/my:group2</RepeatingGroup>
    <Relationships>
      <RelatedList />
      <RelatedListId />
    </Relationships>
    <Mapping>
      <FormField IsRichText="false" IsId="true" IsAttachment="false">my:ID</FormField>
      <SharePointColumn />
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:Title</FormField>
      <SharePointColumn>Title</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:Value</FormField>
      <SharePointColumn>Value</SharePointColumn>
    </Mapping>
    <Batch OnError="Continue">
      <Method ID="1" Cmd="New">
        <Field Name="Title" />
        <Field Name="Value" />
      </Method>
    </Batch>
</Mappings>
<SharePointListURL>https://kennametal.sharepoint.com/sites/testing</SharePointListURL>
</myFields>

In the Form Options I have the form set to Client, with Domain Security. This is the way all of the forms are currently configured. I had to press the remove code again, I have no idea how that is getting populated. I am also haveing the same issue that the thread started with in the dll and form not matching. I attached the basic form to see why this is happening. I may have something wrong with the 43 install?

Re: Upgraded Qrules to 4.3 and Commands are not working

Hilary Stoupa — Tue, 26 Mar 2013 14:06:48 GMT

The refresh command should update your XML with the latest from the SharePoint list - I'm obviously not explaining well what I'm trying to find out. Deleting is part of "refresh" - when the refresh command executes, we store a list of the current IDs for list items in the XML - then the next time you Submit, we can find out what needs to be deleted from the SharePoint list - IDs that where in the form originally and now are not. My suspicion is that for some reason, refresh is not working correctly. What you are describing - changing items in the XML and them being updated correctly in the SharePoint list - is just part of the Submit command.

The Refresh command should always report something in the Results node if it is running correctly - even if it just that all items between the form and list match. Can you just add a message box to the same ruleset that executes the Refresh command and have it pop up to verify the rule is executing? Have it show the value of Results?

Your QdabraRules data source looks off again - did you walk through the data connection manually again?

Originally, I forgot to check for the qRulesLastModified attribute, but I see you have that on your ID node. I think at this point, I would try with a simple form and just set it up with Refresh and Submit to try to track down whether it is the form or something else that is causing the issue.

Re: Upgraded Qrules to 4.3 and Commands are not working

jerryO — Tue, 26 Mar 2013 13:03:52 GMT

I am assuming the refresh is working becuase if I change one of the repeating table items, the list gets updated. I am not getting anything back in the result node when the form loades or after I delete the item from the repeating table. The items list is definetly getting updated when I update the repeating table, I have checked many times.

After I delete or add a savings item to the repeating table, this is the command that runs - SubmitToSharePointList /submit=Savings Web Service Submit /mapping=savingsmapping /id=my:ID /dsname=AddAttachment /xpath=/my:myFields/my:Files. This is the same command that runs when the form is submitted for the first time.

This is the refresh in the finsihedloading - RefreshSharePointListItems /dsname=Refresh /mapping=savingsmapping /mode=Update

I am using the same submit command after the changes are made. Do I need to do a refresh after the submit?

I am using IE9, with IP 2010 and O365. Our 365 tenant has not been updated to Wave 15 yet.

Re: Upgraded Qrules to 4.3 and Commands are not working

Hilary Stoupa — Mon, 25 Mar 2013 14:17:52 GMT

Can you please check and see if Refresh is working? When you open your form, after the Refresh command runs, there should be something in the results node - even just that the items match. You may need to disable other commands that run after Refresh to verify this, or copy the results node to another field.