Skip to main content

Hello,


we are working on a project where we use K2 Infopath to register and reporting incidents and accidents (I&A). The form is a Infopath form with three repeating tables/sections with rows.


Beause of reporting requirements we want to store this information in Sharepoint list and database tables using K2 Blackpoint.  I know that you can use external content types to store info in SP list which then automatically will be store the data in a seperate db table.


Is this possible and if yes, anyone does have tips whats the best way to do this?


Thx in advance


Ludwig Stokkelaar


Open Docs bv


 


 

Hi Ludwig - is your issue surrounding the management of data entered by repeating sections onto your sharepoint list or the use of data once it is in there?


We have found that when you hook-up the data-set from infopath to a list for repeating values the list will handle this by simply adding to the text field on the same row. So if one incident ref has three repeating entries as "example1" then "example2", then "example3" it will appear as "example1,example2,example3"


I am not sure what you mean by external data types, but in terms of making the list accessible to other databases the easiest way is to link the sharepoint list to an access database via the actions taks bar at the top of the list. This makes the list appear as an access database table - and although it is not dynamic (list changes need a refresh on the database to come through), it has potential. Obviously this is most straight-forward example but we have found that SharePoint lists are accessible to most Microsoft systems (possibly sql server as well?). so making this data available to other platforms is possible.


Regards, Rob


 


Hi Rob


Thx for the reaction. Yes, we solved the problem to store "header-field"relationships in a infopath form in a relational database, e.q. in our case SQL server via the use of smart objects..


Regs


Ludwig


 


 


 


Reply