read xForms data directly from database


Is it posible to read the data posted from a xform directly from the database? Im lookling in the tblItem table but cant find my data in clear text. Seems like it encryptet.

 What i'm looking for is a way to show reports and statistics from the data using Reporting Services.

Aug 20, 2009 8:23

Hi David!

Its not encrypted, but binary serialized objects of type XFormData saved through EPiServer's ObjectStore services. 

This makes it _very_ difficult to get at the posted data from the "outside" (not going through EPiServer's XForms/ObjectStore services).

One possible solution would be to develop a module that uses the XForms functions and simply exports the data into some other custom table (in a more normalized way) and then use Reporting Services on *that* table.




Aug 20, 2009 10:10


 I'l use BeforeSubmitPostedData and send the data into another table.




Aug 21, 2009 9:32