Qdabra Tools

Re: qRules Mapping - Infopath to SharePoint list only one row of repeating table is submitted

Hilary Stoupa — Fri, 28 Mar 2014 15:01:29 GMT

Oh hooray!!!! So glad you have it working. :)

Re: qRules Mapping - Infopath to SharePoint list only one row of repeating table is submitted

d24n4e — Fri, 28 Mar 2014 12:35:15 GMT

Hilary,

I redid everything again using your mapping example and it now works. Qdabra is excellent.

Thank you all for your help!

Re: qRules Mapping - Infopath to SharePoint list only one row of repeating table is submitted

d24n4e — Fri, 28 Mar 2014 09:13:02 GMT

I think it is because it is just a normal standalone text field?

Re: qRules Mapping - Infopath to SharePoint list only one row of repeating table is submitted

d24n4e — Fri, 28 Mar 2014 09:10:05 GMT

Thank you so much for your help, I understand now I can see your example.

I am still having issues with my OvertimeId field and now get this error message

Failed to generate new Batch from mapping. Error information: Error occurred generating the batch element
set.

Re: qRules Mapping - Infopath to SharePoint list only one row of repeating table is submitted

Hilary Stoupa — Thu, 27 Mar 2014 16:51:57 GMT

Here's a mapping with some manual mods that I think will be right for your form and what you are trying to do - you can always import it into the mapping tool so you can see the difference.

Re: qRules Mapping - Infopath to SharePoint list only one row of repeating table is submitted

d24n4e — Thu, 27 Mar 2014 16:41:33 GMT

Updated mapping file

Re: qRules Mapping - Infopath to SharePoint list only one row of repeating table is submitted

d24n4e — Thu, 27 Mar 2014 16:31:34 GMT

Thank you - I have corrected the Id field I think, but I haven't been able to sort the relative mapping.

Re: qRules Mapping - Infopath to SharePoint list only one row of repeating table is submitted

Hilary Stoupa — Thu, 27 Mar 2014 15:34:51 GMT

There are some problems with your mapping. You have a repeating group for your submit - >my:myFields/my:Project/my:Overtime/my:OvertimeDetails/my:OvertimeAuthHours/my:OvertimeDetail/ - but then you have absolute XPaths to your fields. They need to be relative to the repeating group instead.

The field you have indicated for the ID is outside of your repeating group. The purpose of the ID is to be able to effectively relate each item submitted to the list with the XML node in the form. So, if you are mapping repeating data, you will want to have the field you are using for the ID inside that repeating group. This walkthrough was written for 4.2, but may help clarify the issues:

http://www.infopathdev.com/blogs/hilary/archive/2012/05/30/qrules-submittosharepointlist-walkthrough-for-v4-2.aspx

Can you take a look at that post and try remapping your data? If you get stuck, just attach your template you are trying to submit to a reply and I can help you out.

Re: qRules Mapping - Infopath to SharePoint list only one row of repeating table is submitted

d24n4e — Thu, 27 Mar 2014 15:06:42 GMT

Hilary,

Please find attached. My command is SubmitToSharePointList /submit=ShPList

Thank you

Re: qRules Mapping - Infopath to SharePoint list only one row of repeating table is submitted

Hilary Stoupa — Thu, 27 Mar 2014 14:51:01 GMT

What is the syntax of your command? Can I see your mapping file? You can attach it under the options tab in a reply.

Re: qRules Mapping - Infopath to SharePoint list only one row of repeating table is submitted

d24n4e — Thu, 27 Mar 2014 14:37:21 GMT

That's great. Thank you for your help. Just got one final error message to resolve and hopefully it will work - it says Failed to select node for SharePoint List Id: my:myFields/my:Project/my:Id

Re: qRules Mapping - Infopath to SharePoint list only one row of repeating table is submitted

ErnestoM — Thu, 27 Mar 2014 13:42:56 GMT

Hi-

After checking the checkbox denoting a repeating group, you'll see a field where you can select the repeating schema node. I'm attaching a screenshot.

Here is one of our tutorials - I'm not sure if it's the same one you're following so this may help:

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

Re: qRules Mapping - Infopath to SharePoint list only one row of repeating table is submitted

d24n4e — Thu, 27 Mar 2014 13:35:33 GMT

Thank you Ernesto. I have ensured the checkbox in point 1 is ticked. Please can you advise what I need to do for point 2? Thanks

Re: qRules Mapping - Infopath to SharePoint list only one row of repeating table is submitted

ErnestoM — Thu, 27 Mar 2014 13:24:55 GMT

Hi-

If you are mapping repeating data, there are two things to watch out for when creating the mapping:

1. You must check the checkbox that indicates that your data is repeating

2. The root node must point to that repeating node in the form schema.

Hope this helps!

qRules Mapping - Infopath to SharePoint list only one row of repeating table is submitted

d24n4e — Thu, 27 Mar 2014 09:50:57 GMT

Hi I followed Hilary's excellent walkthrough to create my own submit to SP overtime authorisation form (changing fields to my own requirements etc). I only have one SPlist that I need all the data to be sent to, but when I have multiple lines in my repeating table, only the first one is submitted to my list. What might I be doing wrong please?

In my form I basically have header information (project details) then overtime request information (e.g date) then below it a repeating table so the project manager can request overtime pre-approval for multiple resources with different start/end times.

Thanks