Data Connections

Re: Parse repeating table document library file to sharepoint list

donstephen — Wed, 18 Mar 2015 16:56:33 GMT

Hi Dave,

You might want to check out qRules' SubmitToSharePointList command for a codeless approach on submitting data to a SharePoint list.

And here is a guide you can use:

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

Re: Parse repeating table document library file to sharepoint list

davedmonds — Wed, 18 Mar 2015 16:38:04 GMT

Hi Don, I looked at this already and it doesn't exactly match what I am trying to achieve. It may be easier to see if there is an out of the box solution to meet my needs.

Dave

Re: Parse repeating table document library file to sharepoint list

donstephen — Wed, 18 Mar 2015 16:13:17 GMT

Hi Dave,

I'm sorry to hear that. We have a blog post here which discusses the submit to SHarePoint technique via CAML in full detail:

http://www.infopathdev.com/blogs/matt/archive/2006/02/02/Add-SharePoint-List-Items-with-InfoPath.aspx

Hope this helps.

Re: Parse repeating table document library file to sharepoint list

davedmonds — Wed, 18 Mar 2015 16:02:16 GMT

Hi Don, I am having no luck with this project. I am still where I was in my last post and can't seem to get any further forward.

Is anyone able to assist with the creation of the rules as the video doesn't cover them individually in enough detail.

Dave

Re: Parse repeating table document library file to sharepoint list

davedmonds — Tue, 24 Feb 2015 16:54:35 GMT

Hello, many thanks for this link. I am halfway through it.

I have created the form and linked the CAML to it. I now have to set up the data connections and the rules. It's quite a long job for a novice!!

I will post the completed form when I get it working if you like.

Dave

Re: Parse repeating table document library file to sharepoint list

donstephen — Wed, 18 Feb 2015 15:49:16 GMT

Hi Dave,

I'm not sure where you're exactly at so I recommend checking this webinar out:

InfoPath: InfoPath Dashboards & Repeating Data - Part 2

Hope this helps.

Regards,

Parse repeating table document library file to sharepoint list

davedmonds — Tue, 17 Feb 2015 07:36:51 GMT

Hi, my brief is to create a timesheet that must be submitted weekly but with a repeating section for every day. I have the form, it submits to a doc library (because you can't submit repeating data directly to a list) I want to take the xml file in the doc library and parse each repeted section as a new list item into another sharepoint list.

I have read http://www.infopathdev.com/blogs/matt/archive/2006/02/02/Add-SharePoint-List-Items-with-InfoPath.aspx and whilst helpful, it doesn't answer my exact questions.

I have created a CAML file and imported it as a data source.

Can anyone suggest the next steps please?

Dave