InfoPath Dev

I am creating a stationary ordering system on InfoPath to submit to SharePoint. I have an issue where I need a mix of static fields and repeating tables. i.e.  Requestor name, requestor date etc. then the repeating table to actually select the items wanted and quantity. I need each of these items to be submitted into a different line in SharePoint as it is then exported to XML and uploaded into another system. Any idea how to get this work?

 Hello Kristie84,

For the scenario you are describing there are essentially 3 options.  

1. Use CAML to map your repeating items to a SharePoint list on submit. This option is fairly complex and can be very hard to debug. Here's a similar post on CAML: http://www.infopathdev.com/forums/p/28811/98887.aspx#98887

2. Use qRules InfoPath to SharePoint List tool. This is easy to use, and maps your data to flat lists where you can export the data. Here's a lin to Hilary's awesome blog on how to use the command: http://www.infopathdev.com/blogs/hilary/archive/2012/06/27/qrules-submittosharepointlist-walkthrough-for-v4-2-working-with-existing-data-amp-submitting-a-single-mapping.aspx

3. Use DBXL to automatically shred data to a SQL database using a web service. This solution is great if you want your data sent to SQL for reporting. http://www.qdabra.com/en/products/DBXL.aspx

I hope that helps! Please let me know if you have more questions!

Bre

Bre Huston | Project Manager

Qdabra® Software / InfoPathDev.com / FormsQuo /  877.544.2389 main / 425.318.7843 direct

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

 Hello Kristie84,

For the scenario you are describing there are essentially 3 options.  

1. Use CAML to map your repeating items to a SharePoint list on submit. This option is fairly complex and can be very hard to debug. Here's a similar post on CAML: http://www.infopathdev.com/forums/p/28811/98887.aspx#98887

2. Use qRules InfoPath to SharePoint List tool. This is easy to use, and maps your data to flat lists where you can export the data. Here's a lin to Hilary's awesome blog on how to use the command: http://www.infopathdev.com/blogs/hilary/archive/2012/06/27/qrules-submittosharepointlist-walkthrough-for-v4-2-working-with-existing-data-amp-submitting-a-single-mapping.aspx

3. Use DBXL to automatically shred data to a SQL database using a web service. This solution is great if you want your data sent to SQL for reporting. http://www.qdabra.com/en/products/DBXL.aspx

I hope that helps! Please let me know if you have more questions!

Bre

Bre Huston | Project Manager

Qdabra® Software / InfoPathDev.com / FormsQuo /  877.544.2389 main / 425.318.7843 direct

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™