Qdabra qRules

Re: Submit nested repeating fields to Sharepoint List

Hilary Stoupa — Tue, 01 Mar 2011 21:01:00 GMT

You may be able to populate the table you are submitting with data from your "nested" tables using a combination of the Insert command and SetValue. When you start working on it again, if you run into trouble, be sure to start a new thread so it gets noticed... sometimes older threads don't get the attention and love they should.

Re: Submit nested repeating fields to Sharepoint List

dsnightthunder — Tue, 01 Mar 2011 18:13:48 GMT

Well, it now writes without error... HOORAY!!!

It does not collect the info properly anymore, though, because it is not nested as it was... I don't have time to play with it now, but when I do I will let you know the outcome.

I had looked and looked at all the connections, but never saw that... THANKS again!!!

Re: Submit nested repeating fields to Sharepoint List

Hilary Stoupa — Tue, 01 Mar 2011 16:21:10 GMT

It appears to me that you are using the Combined Mapping data connection in your qRules command for the /mapping parameter, but you are still using the LevelTwoMapping for the parameters in your ShPSubmit data connection. Could you walk through the wizard for that ShPSubmit data connection again (the one that uses UpdateListItems) and make sure you are using the same data source for the listName and update parameters in that data connection that you are specifying for the /mapping parameter?

Re: Submit nested repeating fields to Sharepoint List

dsnightthunder — Tue, 01 Mar 2011 13:38:01 GMT

SURE!!!! Here ya go!!! Thanks!!!

Re: Submit nested repeating fields to Sharepoint List

Hilary Stoupa — Tue, 01 Mar 2011 01:28:56 GMT

Oh, and can you also attach an XML that fails when you try to submit? Thanks!

Re: Submit nested repeating fields to Sharepoint List

Hilary Stoupa — Tue, 01 Mar 2011 01:26:43 GMT

It is a lousy error message, and I apologize for that. I should have better error handling in the command for this type of issue.

I believe that what is still happening is that while you may have multiple instances of your group, they are not all in the same parent group. I'll make some modifications to your template and mapping in the morning and post it back here for you to try again.

Re: Submit nested repeating fields to Sharepoint List

dsnightthunder — Tue, 01 Mar 2011 01:21:03 GMT

Same error...

I have attached the form so you can see whether I did what you suggested correctly.

I just dragged a copy of the whole table out on the form so I could see how it gets filled out from the other objects. When you fill in the repeating areas it looks like it fills the actual table as it should.

I feel like I am going backwards on this thing...

Why do I get an error saying that there is no such object??? I just don't get it....

ERROR:

An unexpected error occurred executing the rule. Action: SubmitToSharePointList Arguments: submit: ShPSubmit mapping: CombinedMapping id: my:id3 Details: Object reference not set to an instance of an object. Stack: at Qdabra.Tools.RulesLibrary.Commands.PopulateIdsAndLastModified(XPathNavigator outputNav, XmlDocument mapping, String idXpath) at Qdabra.Tools.RulesLibrary.Commands.SubmitToSharePointList(String submitDs, String mappingDs, String id, String dsname, String xpath, String name, String uniqueName) at Qdabra.Tools.RulesLibrary.Commands.SubmitToSharePointList() at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand()

Re: Submit nested repeating fields to Sharepoint List

Hilary Stoupa — Mon, 28 Feb 2011 16:16:29 GMT

Id should be optional -- but in 2.3, there was a bug where that made it required (fixed in 2.4).

When you get the error using the command that includes the /id parameter, how were you inserting the rows for your table? Were you using the new table in the bottom of your form, so that all the rows were in the first instance of the repeats they are nested in? Can you move your LevelTwo group out so it is no longer nested and adjust the mapping and try that?

Re: Submit nested repeating fields to Sharepoint List

dsnightthunder — Sat, 26 Feb 2011 21:07:38 GMT

OK - so I re-configured my form so that everything is in the Level Two table to be written to the list - and it still gave me the "id3" error. So I removed the id parameter (which is supposed to be optional?) in the submit statement on the button and got this error?? Take a look at this form and tell me what is wrong with my logic now... All of the repetitive work is being done in the form... It is just a simple mapping at this point??? Now I am really confused...

An unexpected error occurred executing the rule. Action: SubmitToSharePointList Arguments: submit: ShPSubmit mapping: CombinedMapping Details: Expression must evaluate to a node-set. Stack: at MS.Internal.Xml.XPath.XPathParser.ParseNodeTest(AstNode qyInput, AxisType axisType, XPathNodeType nodeType) at MS.Internal.Xml.XPath.XPathParser.ParseStep(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseRelativeLocationPath(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseRelativeLocationPath(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseRelativeLocationPath(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseRelativeLocationPath(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseRelativeLocationPath(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseLocationPath(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParsePathExpr(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseUnionExpr(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseUnaryExpr(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseMultiplicativeExpr(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseAdditiveExpr(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseRelationalExpr(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseEqualityExpr(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseAndExpr(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseOrExpr(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseXPathExpresion(String xpathExpresion) at MS.Internal.Xml.XPath.QueryBuilder.Build(String query, Boolean allowVar, Boolean allowKey) at MS.Internal.Xml.XPath.QueryBuilder.Build(String query, Boolean& needContext) at System.Xml.XPath.XPathExpression.Compile(String xpath, IXmlNamespaceResolver nsResolver) at System.Xml.XPath.XPathNavigator.Select(String xpath, IXmlNamespaceResolver resolver) at Qdabra.Tools.RulesLibrary.Commands.UpdateFormItemList(String fullIdPath) at Qdabra.Tools.RulesLibrary.Commands.PopulateIdsAndLastModified(XPathNavigator outputNav, XmlDocument mapping, String idXpath) at Qdabra.Tools.RulesLibrary.Commands.SubmitToSharePointList(String submitDs, String mappingDs, String id, String dsname, String xpath, String name, String uniqueName) at Qdabra.Tools.RulesLibrary.Commands.SubmitToSharePointList() at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand()

Re: Submit nested repeating fields to Sharepoint List

Hilary Stoupa — Sat, 26 Feb 2011 00:17:55 GMT

Donna -- I had a chance to run this in debug today, and you have my humblest apologies for leading you down a dead end path! This absolutely is not going to work with nested groups as qRules currently is written.

I think you are going to have to move everything into the same level. You may be able to use some conditional formatting to get it to look the way you want it to...

Re: Submit nested repeating fields to Sharepoint List

Hilary Stoupa — Fri, 25 Feb 2011 23:14:44 GMT

Okay, I created a test form and get the same results. It is going to be early next week before I can finish checking this out, but I will, and I'll get back to you.... Thanks for being so patient!

Re: Submit nested repeating fields to Sharepoint List

dsnightthunder — Fri, 25 Feb 2011 21:08:50 GMT

Well, it errored when I just filled out the first line. It just does not like that additional layer... I tried adding one sub task - It errors again and is not saving anything to the list.

An unexpected error occurred executing the rule. Action: SubmitToSharePointList Arguments: submit: ShPSubmit mapping: LevelOneMapping id: my:id3 Details: Object reference not set to an instance of an object. Stack: at Qdabra.Tools.RulesLibrary.Commands.SubmitToSharePointList(String submitDs, String mappingDs, String id, String dsname, String xpath, String name, String uniqueName) at Qdabra.Tools.RulesLibrary.Commands.SubmitToSharePointList() at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand()

Re: Submit nested repeating fields to Sharepoint List

Hilary Stoupa — Thu, 24 Feb 2011 20:46:42 GMT

Can you try the attached template? I've injected it with a more recent version of qRules, just in case part of this behavior is caused by a logic flaw we've since fixed.

Re: Submit nested repeating fields to Sharepoint List

dsnightthunder — Wed, 23 Feb 2011 22:19:47 GMT

OK - so I finally revised my mapping as you suggested, and tested with just a single level one with two level twos under it - which was working yesterday...

I have not put the insert command on the form as of yet... so I did not test unmatched level ones yet... I attached the form.

I got an error again:

An unexpected error occurred executing the rule. Action: SubmitToSharePointList Arguments: submit: ShPSubmit mapping: LevelOneMapping id: my:id3 Details: Object reference not set to an instance of an object. Stack: at Qdabra.Tools.RulesLibrary.Commands.PopulateIdsAndLastModified(XPathNavigator outputNav, XmlDocument mapping, String idXpath) at Qdabra.Tools.RulesLibrary.Commands.SubmitToSharePointList(String submitDs, String mappingDs, String id, String dsname, String xpath, String name, String uniqueName) at Qdabra.Tools.RulesLibrary.Commands.SubmitToSharePointList() at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand()

I told you I was stupid!!!

FYI - Here is the mapping:

<my:myFields xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-11-27T15:29:00" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003" xml:lang="en-us">
<my:Mappings>
    <my:IsRepeating>true</my:IsRepeating>
    <my:RepeatingGroup>my:myFields/my:grpEmployeeInfo/my:grpEmployee/my:grpProjectItems/my:grpLevelOneItems/my:tblLevelOneItems/my:grpLevelTwoItems/my:tblLevelTwoItems</my:RepeatingGroup>
    <my:Mapping>
      <my:FormField>my:LevelTwoItem</my:FormField>
      <my:SharePointColumn>Body</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField>my:LevelTwoResp</my:FormField>
      <my:SharePointColumn>Sub_x0020_Task_x0020_Assign</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField>my:LevelTwoPriority</my:FormField>
      <my:SharePointColumn>Sub_x0020_Task_x0020_Priority</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField>my:LevelTwoStatus</my:FormField>
      <my:SharePointColumn>Sub_x0020_Task_x0020_Status</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField>my:LevelTwoDueDate</my:FormField>
      <my:SharePointColumn>Sub_x0020_Task_x0020_Due</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField>my:LevelTwoPercentComplete</my:FormField>
      <my:SharePointColumn>Sub_x0020_Task_x0020__x0025_</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField>../../my:LevelOneItem</my:FormField>
      <my:SharePointColumn>Title</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField>../../my:LevelOneAssign</my:FormField>
      <my:SharePointColumn>Task_x0020_Assign</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField>../../my:LevelOnePriority</my:FormField>
      <my:SharePointColumn>Priority</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField>../../my:LevelOneStatus</my:FormField>
      <my:SharePointColumn>Status</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField>../../my:LevelOneDueDate</my:FormField>
      <my:SharePointColumn>DueDate</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField>../../my:LevelOnePercent</my:FormField>
      <my:SharePointColumn>PercentComplete</my:SharePointColumn>
    </my:Mapping>
</my:Mappings>
<my:SharePointListURL>http://fulcoforms.co.fulton.ga.us/cff/Project</my:SharePointListURL>
<my:ListCollection>{087BC6F8-C28C-424A-BC0F-9C6FD1A5CB80}</my:ListCollection>
<my:FullListURL>http://fulcoforms.co.fulton.ga.us/cff/Project/Lists/Project</my:FullListURL>
<Batch OnError="Continue">
    <Method ID="New" Cmd="New">
      <Field Name="Body">
      </Field>
      <Field Name="Sub_x0020_Task_x0020_Assign">
      </Field>
      <Field Name="Sub_x0020_Task_x0020_Priority">
      </Field>
      <Field Name="Sub_x0020_Task_x0020_Status">
      </Field>
      <Field Name="Sub_x0020_Task_x0020_Due">
      </Field>
      <Field Name="Sub_x0020_Task_x0020__x0025_">
      </Field>
      <Field Name="Title">
      </Field>
      <Field Name="Task_x0020_Assign">
      </Field>
      <Field Name="Priority">
      </Field>
      <Field Name="Status">
      </Field>
      <Field Name="DueDate">
      </Field>
      <Field Name="PercentComplete">
      </Field>
    </Method>
</Batch>
</my:myFields>

Re: Submit nested repeating fields to Sharepoint List

dsnightthunder — Tue, 22 Feb 2011 20:11:05 GMT

OK I think I get it now... Let me try it and I will let you know asap how it goes.

THANKS so much for all your excellent HELP!!!