InfoPath Dev

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

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!

 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

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

 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

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

Hilary,

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

Thank you 

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.

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

 Updated mapping file

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.

 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. 

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

 Hilary,

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

Thank you all for your help!

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