Can I know what saved in pagesettings on ASPNET_PERSONALIZATIONPERUSER table

Last post 03-19-2006 10:31 AM by Sonofthesun. 3 replies.

Sort Posts:

  • Can I know what saved in pagesettings on ASPNET_PERSONALIZATIONPERUSER table

    03-16-2006, 4:24 AM
    • Member
      60 point Member
    • vmalvarez
    • Member since 02-24-2006, 7:48 AM
    • Posts 12
    The colum pagesettings of the ASPNET_PERSONALIZATIONPERUSER table, save a Serialized data blob that I don´t understand. I'd like to know what's happens, what kind of data structure is saved, because later I'd like to do some data statistic from this data blob.
  • Re: Can I know what saved in pagesettings on ASPNET_PERSONALIZATIONPERUSER table

    03-16-2006, 6:47 PM
    • Member
      720 point Member
    • davidbarkol
    • Member since 01-27-2006, 6:57 PM
    • CA
    • Posts 141
    • ASPInsiders

    One thing you might want to try doing is implementing you own personalization provider. It can inherit from the existing provider and your provider would simply just take a look at the data before it gets passed on to the original provider.

  • Re: Can I know what saved in pagesettings on ASPNET_PERSONALIZATIONPERUSER table

    03-17-2006, 4:35 AM
    • Member
      60 point Member
    • vmalvarez
    • Member since 02-24-2006, 7:48 AM
    • Posts 12

    Yes.

    You didn't understand me. I had finished my own Personalization Provider for ORACLE, 2 weeks ago. But my doubt is other, when I'm going to get data from the page setting to store , I have a binary array with encrypted data. I need Know what is this encrypted data.

    The data (converted to string) is similar to this:

    /wEUKwAiAgICBRkqMVN5c3RlbS5XZWIuVUkuV2ViQ29udHJvbHMuV2ViUGFydHMuR2VuZXJpY1dlYlBhcnQFFGd3cE15V2ViVXNlckNvbnRyb2wxAgEeBVRpdGxlBRJCdXNjYWRvciBkZSBHb29nbGVmGSsEBQxnd3BOb3RpY2lhczICAR8ABRtEb3NzaWVyIGRlIHByZW5zYSBkZSBsYSBVTUhmGSsEBQlnd3BMb2dpbjECAR8ABRNSZWdpc3RybyBkZSBVc3VhcmlvZhkrBAUMZ3dwQ2FsZW5kYXIxAgIfAAUMQ2FsZW5kYXJpbyAxHgtDaHJvbWVTdGF0ZQsqMlN5c3RlbS5XZWIuVUkuV2ViQ29udHJvbHMuV2ViUGFydHMuUGFydENocm9tZVN0YXRlAGYZKwQFDGd3cE5vdGljaWFzMQIBHwAFEk5vdGljaWFzIGRlIGxhIFVNSGY=

    I would like to decipher it, for instance, exporting to XML data file or similar.

     

  • Re: Can I know what saved in pagesettings on ASPNET_PERSONALIZATIONPERUSER table

    03-19-2006, 10:31 AM
    • Member
      290 point Member
    • Sonofthesun
    • Member since 11-11-2005, 5:03 AM
    • Helsinki, Finland
    • Posts 58

    Hi vmalvarez,

    The as you already wrote, the blob is in binary array format and cannot be directly converted to any understandable format. The saved information depends on the controls created on the page. Basically the saved byte array is serialized BlobPersonalizationState object, which insted is basically collection of PersonalizationInfo entries.

    Unfortunately the both objects used in this serialialization / deserializations are private or shared objects and there for can not be used out side of the System.Web assembly. This is most likely due the fact, that the changing the format would be easier for MS in future releases.  These objects aren't even documented in msdn (I checked the process using Reflector).

    Basically the PersonalizationInfo object saves the control id, control type and property information data of single control in page. This is done to each control, which have the Personalizable attribute set for the properties.

    So... forget the actual content of the byte array... since it's impossible to use it in your solution.

    - Vsku

    Vesa Juvonen
Page 1 of 1 (4 items)