SharePoint Integration

Re: Extracting Repeating Table Data in Web Parts

lday8 — Fri, 12 Jun 2009 09:59:19 GMT

Patrick Halstead:

Hi Luke,

The best practice here is to map your data to a SQL database and use SharePoint's out-of-box data view webpart to display the contents. No code required.

Hi Patrick,

Thanks for your response. However I am not needing to display the repeating tables' values, I need to iterate through each set of repeating values and then manipulate them in web part.

The scenario is: customer orders are recorded on an InfoPath order form where products are in a repeating table as there can be many products per customer order that comes in. Different views in the form make up the Order Acknowledgement / Delivery Note / Goods In Note and will soon make up an invoice. However I need to write a web part to allow a selected "delivered" order to have it's products, their quantities and unit prices passed into Sage (using Sage's SDK) to save the accounts department having to re-enter this information into their financial software (Sage).

I have attempted to make my way around the SQL created database for SharePoint in the past but it is so intertwined i have always stayed clear of going into it... Therefore I feel it would be too complicated to go looking for the InfoPath XML document in the SQL database to draw the data out. Is there a way, in code, that I can open the InfoPath XML form, retrieve the XML and then loop through the repeating table, like I would do a normal set of XML data?

Thank you for your help so far, if you can provide any further pointers / help this would be very much appreciated!!

Many Thanks,

Luke

Re: Extracting Repeating Table Data in Web Parts

Patrick Halstead — Thu, 11 Jun 2009 21:42:06 GMT

Hi Luke,

The best practice here is to map your data to a SQL database and use SharePoint's out-of-box data view webpart to display the contents. No code required.

Extracting Repeating Table Data in Web Parts

lday8 — Wed, 10 Jun 2009 10:49:05 GMT

Hi,

I am pretty new to developing in InfoPath and SharePoint. I have the requirement to extract repeating table data from an InfoPath form using web part (written in C#).

I have been looking into how I might go about doing this but I don't seem to have come up with a solution.

I have tried getting the document as an XML document but it will not let me open it in the web part and claims I don't have the correct permissions, even though i have full permissions across the whole site (including on the document library)

Could anyone point me in the right direction or offer any advice?

Many thanks in advance,

Luke