November Happy Hour will be moved to Thursday December 5th.

AI OnAI Off

read xForms data directly from database

David Einebrant
David Einebrant
Vote:
 

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.

#32016
Aug 20, 2009 8:23
Vote:
 

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.

Regards,

Johan

 

#32022
Aug 20, 2009 10:10
David Einebrant
David Einebrant
Vote:
 

OK!

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

 Thanks!

 /David

 

#32074
Aug 21, 2009 9:32
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.