Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Anders Brohäll 295 posts 561 karma points c-trib
    Feb 08, 2012 @ 11:23
    Anders Brohäll
    0

    Mimicking BigTable in editable DataType

    Hi,

    Im looking for a DataType that works pretty much like a BigTable.

    What i need is the ability to set rows of values for various data.
    My perticular scenario is that i have a member that has periods of "activity". And i need to keep history of em all.

    Eg. Member 123 has two periods of activity, 1) between 2011-01-01 to 2011-12-01, and 2) 2012-01-01 to 2012-06-01.

    So, I need something like:
    id | nodeId | data | data

    Im thinking that there is (or should be) a DataType where i can build somewhat of a DataTable storing my data as a XML in ntext. In my scenario above, the datatypes aren't really important, if i can save em as text and parse them as int's and datetimes, that'd be sufficient.

    I need it to be editable, so that i can add and remove entries. Preferrably both via the backend and via codebehind.

    Is there any DataTypes out there that might help me?

    Any pointers when building it?
    Is the approach above with XML the way to go, or might a third party NoSQL be a better solution?

    Anders

  • Anders Brohäll 295 posts 561 karma points c-trib
    Feb 09, 2012 @ 11:07
    Anders Brohäll
    0

    No takers?

  • Nigel Wilson 939 posts 2061 karma points
    Feb 09, 2012 @ 23:01
    Nigel Wilson
    0

    Hi Anders

    Is this suitable ?

    http://our.umbraco.org/projects/backoffice-extensions/dynamic-grid-data-type

    I have used it for opening hours of shops.

    Cheers

    Nigel

  • Anders Brohäll 295 posts 561 karma points c-trib
    Feb 09, 2012 @ 23:56
    Anders Brohäll
    0

    It does look exactly like the datatype im looking for.
    Excellent!

    I will try it out tomorrow.

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies