read xForms data directly from database

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

Vote:

OK!

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

Thanks!

/David

#32074

Aug 21, 2009 9:32

Try our conversational search powered by Generative AI!

read xForms data directly from database