Qdabra qRules

Re: Submit to list

Hilary Stoupa — Tue, 17 Apr 2012 20:04:44 GMT

Can you tell me what you mean by "returning values" - do you mean that the values of your higher level items aren't being populated in your list?

I'm pretty sure, given the previous sample you showed, that you have one too many "../" in your relative paths.

Did you try the syntax I suggested in my earlier post?

<my:Mapping>
<my:FormField my:IsRichText="false">../../my:employee/my:name</my:FormField>
<my:SharePointColumn>User</my:SharePointColumn>
</my:Mapping>
<my:Mapping>
<my:FormField my:IsRichText="false">../../my:employee/my:emailAddress</my:FormField>
<my:SharePointColumn>email</my:SharePointColumn>
</my:Mapping>

Re: Submit to list

crisb184 — Tue, 17 Apr 2012 19:14:13 GMT

Ok, I entered the relative paths (still learning as I go) and am still not returning the values. The updated xml is as follows:

Re: Submit to list

Hilary Stoupa — Tue, 17 Apr 2012 18:27:10 GMT

The relative path is the path from the repeating node. Your repeating node is: my:expenseReport/my:items/my:item

Your relative path would be:

I'm assuming that this has the full path because that is what you entered in the mapping tool. One way to figure out the relative path is to set up a rule on your repeating group. Add a condition. For the first drop down for your condition, select the field you want (like name in the above example). Then change the first drop down to "The expression" - you'll see the relative path in the text box that displays in the condition. Then you can delete your rule.

Re: Submit to list

crisb184 — Tue, 17 Apr 2012 18:18:13 GMT

I did this and it did not map it properly. Any idea what is occuring? Here is what my xml looks like.

<my:Mappings>
    <my:IsRepeating>true</my:IsRepeating>
    <my:RepeatingGroup>my:expenseReport/my:items/my:item</my:RepeatingGroup>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:date</my:FormField>
      <my:SharePointColumn>Item_x0020_Date</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:description</my:FormField>
      <my:SharePointColumn>Title</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:category</my:FormField>
      <my:SharePointColumn>Category</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:amount</my:FormField>
      <my:SharePointColumn>Amount</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:expenseReport/my:employee/my:name</my:FormField>
      <my:SharePointColumn>User</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:expenseReport/my:employee/my:emailAddress</my:FormField>
      <my:SharePointColumn>email</my:SharePointColumn>
    </my:Mapping>
</my:Mappings>
<my:SharePointListURL>http://myxxxx.teams.xxxx.com/sites/Proc_CTT</my:SharePointListURL>
<my:FullListURL>http://myxxxx3.teams.xxxx.com/sites/Proc_CTT/Lists/Expenses</my:FullListURL>
<ListCollection>{E9824E1F-2697-45F1-8D14-5186021A462D}</ListCollection>
<Batch OnError="Continue">
    <Method ID="1" Cmd="New">
      <Field Name="Item_x0020_Date" />
      <Field Name="Title" />
      <Field Name="Category" />
      <Field Name="Amount" />
      <Field Name="User" />
      <Field Name="email" />
    </Method>
</Batch>
</my:myFields>

Re: Submit to list

Hilary Stoupa — Tue, 17 Apr 2012 17:57:49 GMT

Okay, so back we go to my original post - type in the relative path to the non repeating field you want. You can type in the field text box. You do not have to use the node picker. I am not sure how else to explain this.

Re: Submit to list

crisb184 — Tue, 17 Apr 2012 17:47:42 GMT

I cannot map the non-repeating data. I only want to submit to one list, but I need to capture the header information and the repeating table information on the same SP list. The QRules mapping tool does not allow me to do this as it forces me to check the repeating data box, but the non repeating data cannot be accepted.

Re: Submit to list

crisb184 — Tue, 17 Apr 2012 17:23:39 GMT

I have just one list, however I want to map the header data as well as the repeating table data in the same list. However, QRules mapping only allows me to map the repeating data columns. I tried to manually add it to the fields column and it took it but it does not populate the SP list. The xml is as follows with the addition fields that I tried to map in bold:

<my:myFields xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xdServerInfo="http://schemas.microsoft.com/office/infopath/2009/xslt/ServerInfo" xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" xmlns:tns="http://schemas.microsoft.com/sharepoint/soap/" xmlns:s1="http://microsoft.com/wsdl/types/" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/" xmlns:ns1="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" 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:expenseReport/my:items/my:item</my:RepeatingGroup>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:date</my:FormField>
      <my:SharePointColumn>Item_x0020_Date</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:description</my:FormField>
      <my:SharePointColumn>Title</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:category</my:FormField>
      <my:SharePointColumn>Category</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:amount</my:FormField>
      <my:SharePointColumn>Amount</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:expenseReport/my:employee/my:name</my:FormField>
      <my:SharePointColumn>User</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:expenseReport/my:employee/my:emailAddress</my:FormField>
      <my:SharePointColumn>email</my:SharePointColumn>
    </my:Mapping>
</my:Mappings>
<my:SharePointListURL>http://myxxxxx3.teams.xxxxx.com/sites/Proc_CTT</my:SharePointListURL>
<my:FullListURL>http://myxxxxx3.teams.xxxxx.com/sites/Proc_CTT/Lists/Expenses</my:FullListURL>
<ListCollection>{E9824E1F-2697-45F1-8D14-5186021A462D}</ListCollection>
<Batch OnError="Continue">
    <Method ID="1" Cmd="New">
      <Field Name="Item_x0020_Date" />
      <Field Name="Title" />
      <Field Name="Category" />
      <Field Name="Amount" />
      <Field Name="User" />
      <Field Name="email" />
    </Method>
</Batch>
</my:myFields>

Re: Submit to list

Hilary Stoupa — Tue, 17 Apr 2012 17:11:27 GMT

I must have misunderstood you. You need to submit to two separate lists? Is that what you are saying? If so, then you do need to create two mappings - one for each list, and two submit connections - one for each mapping file. Does that make sense?

Re: Submit to list

crisb184 — Tue, 17 Apr 2012 17:01:25 GMT

My issue is that I need to click the repeating data checkbox but there is no way to add the non-repeating data (only one list to add to) does this make sense or am I missing something?

Re: Submit to list

Hilary Stoupa — Tue, 17 Apr 2012 14:49:37 GMT

You can use relative paths in the mapping - so, one mapping with relative paths to the fields outside of the repeating table.

Say you want to map the Buyer field - the relative path from the ItemDetails group would be ../my:HeaderInfo/my:Buyer. So you would just hand enter that in the Field column in the mapping tool.

Re: Submit to list

crisb184 — Tue, 17 Apr 2012 13:55:49 GMT

Hilary,

I decided to try your expense report example in your qrules 2.0 walkthrough and finally got that to work. However, I did change the SP site that my list was maintained and did notice that the expense form was browser enabled (was not the case on my initial file that we were troubleshooting). So I am going to sstart from scratch. I did want to ask you about mapping other fields in the form outside of the repeating table. I noticed that the Qrules mapping only allows for the repeating table but no other fields. Will I have to mapp a second file, or will i have to combine the xml's into one (which I do not know how to do)?

Re: Submit to list

Hilary Stoupa — Tue, 17 Apr 2012 00:35:51 GMT

I'm not finding much for this error online, and I can't reproduce it. Can you try the command in your form w/out the /id parameter? And if you can access the SharePoint logs to see if there is more info in the log files, that would be great.

Re: Submit to list

Hilary Stoupa — Mon, 16 Apr 2012 17:38:44 GMT

Do you have access to the SharePoint logs? I'm wondering if there may be more info there.

I'll have to do some more research later today - see if I can figure out what the issue is.

Re: Submit to list

crisb184 — Mon, 16 Apr 2012 17:31:04 GMT

It gave me some more info. Hopefully it makes sense to you!

"Failed to submit to SharePoint. URL = 'http://myxxxx3.teams.xxxx.com/sites/Proc_CTT/BPAF/_vti_bin/lists.asmx'. Full error node text: The system cannot find the file specified. (Exception from HRESULT: 0x80070002).: Exception from HRESULT: 0x8004304D"

Re: Submit to list

Hilary Stoupa — Mon, 16 Apr 2012 17:26:55 GMT

I see what I did - I used the wrong form. Sorry!

Here's yours, re-injected.