Skip to main content

Hi,


I am developing a process for my company and a requirement is to store a repeating section in the InfoPath form in a SmartObject in K2 in a SQL table.


I have seen this done before without out custom coding but I am struggling to reproduce it.


As far as I know it can be done using a Data Event and an XSLT file to transform the ActivityInstanceDestInstanceData to a Data Field. This data field is used as an Input paramater for the Create Method in a Smart Object Event.


Is this the correct approach to take.


 


 


Can somebody explain to me in detail how to do this please?


The xml of the infoPath form is something like


<myFields>


<Capacity>


<Capacity_section>


<field1> - data type text


<field2> - data type Date


<field3> - data type Whole Number (integer)


</Capacity_section>


</Capacity>


</myFields>


 


Thank you,


Sam

Sorry,


I meant to mention that I can get the process to insert the data directly from the xml data in K2 into the Smart Object. But all the data is concatenated as follows:


If I had 3 entries in the repeating section:


Field1 | Field2 | Field3


Field1text1Field1Text2Field1Text3 | Field2Date1Field2Date2Field2Date3 | Field3Number1Field3Number2Field3Number3 |


Field1text1Field1Text2Field1Text3 | Field2Date1Field2Date2Field2Date3 | Field3Number1Field3Number2Field3Number3 |


Field1text1Field1Text2Field1Text3 | Field2Date1Field2Date2Field2Date3 | Field3Number1Field3Number2Field3Number3 |


Reply