London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!

read xForms data directly from database

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
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.