Saving The RadPivotGrid.LocalDataSourceProvider

12 posts, 0 answers
  1. Tomer
    Tomer avatar
    6 posts
    Member since:
    Feb 2012

    Posted 13 Nov 2012 Link to this post

    Hello
    I am trying to save the RadPivotGrid after user has defined the pivot through the RadPivotFieldList, so when i will load it 
    it will load with all of the definition. I understand that most of it is stored in the LocalDataSourceProvider.
    is there way to save and restore the LocalDataSourceProvider to a file?

    Regards,

    Amir

     . 
  2. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 14 Nov 2012 Link to this post

    Hello Amir,

    Saving and loading the state of the LocalDataSourceProvider is in our to-do list, but with the current release it is not available to do this in a simple manner.
    We have prepared a project demonstrating one approach to do this, by using IsolatedStorage and Serialization. You can find it attached and check if it fits your needs. Note that it will work only with our latest internal builds, so if you are using the official one (2012 Q3), please download our latest build and use it. Just one more thing to add - we have created the serialization for some of the Properties, but if you need something, that we've missed, you can create it by following the same way we have done it.

    Please check the attachment and inform us if it doesn't fit your needs.

    Regards,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  3. UI for WPF is Visual Studio 2017 Ready
  4. Richard
    Richard avatar
    7 posts
    Member since:
    Apr 2013

    Posted 16 Apr 2013 Link to this post

    Hi,

    I'm trying to use your codes but how can i have this Telerik.Pivot.DataProviders library.

    Thanks,
    Chard
  5. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 16 Apr 2013 Link to this post

    Hello Richard,

    I'm sending you the modified version of the project. The one you have tried to used is outdated as we have made several modifications after my last post.

    Please note that this is just a workaround to show you how you can implement such scenario. We are working on a fully supported solution that will be much easier to use. It should be included in our Q2 release.

    Hopefully this helps.

    Kind regards,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  6. Richard
    Richard avatar
    7 posts
    Member since:
    Apr 2013

    Posted 16 Apr 2013 Link to this post

    Hi Rosen,

    It works! Thank you for your help.

    BTW when will be the Q2 Release ?

    Please email me once you have your Q2 release.

    Thanks,
    Chard
  7. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 18 Apr 2013 Link to this post

    Hi Chard,

    Our Q2 release is planned for June, but I cannot give you exact date in the moment. You can follow our official site and blogs where we'll announce when the release is available for download.

    Feel free to contact us if you have any suggestions or concerns.

    Regards,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  8. Richard
    Richard avatar
    7 posts
    Member since:
    Apr 2013

    Posted 24 Apr 2013 Link to this post

    Hi Rosen,

    Follow up question.

    How can i get or set other pivotfield properties like Label Filter, Value Filter, Top 10 Filter in LocalDataSourceProvider or in DataSourceProviderSettings class that you have provided?

    Thanks.
  9. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 25 Apr 2013 Link to this post

    Hello Richard,

    I'm sending you a modified version of the project - by using it you are able to serialize/deserialize filters as well. If you find a type, that you are unable to serialize, just add it to the KnonwType list in DataSourceProviderSettings.cs.

    Hopefully this helps.

    Regards,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  10. Richard
    Richard avatar
    7 posts
    Member since:
    Apr 2013

    Posted 02 May 2013 Link to this post

    Hi Rosen,

    I tried setting the Ignore Case in Label Filter, but it does not work when i re-open the application. It is always set to false.

    Please advice if there is any workaround.

    Thanks
  11. Hristo
    Admin
    Hristo avatar
    832 posts

    Posted 03 May 2013 Link to this post

    Hi Richard,

    Could you give us more details where Ignore case is not preserved?
    I've added Label filter on the Row Labels for Name property - Begins With "p" (without quotes) and with Ignore Case checked.
    It should correctly only 2 row groups and on application restart it shows the same groups again and when I go to Label filter for Name group it correctly shows that Ignore Case is checked.

    Kind regards,
    Hristo
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  12. Richard
    Richard avatar
    7 posts
    Member since:
    Apr 2013

    Posted 03 May 2013 Link to this post

    Hi,

    Please check the attachment that Rosen Vladimirov gave posted last April 25, 2013.

    Steps:
      1. Run the application
      2. Add Name in Row Labels
      3. Add Label Filter "pen" then check Ignore Case.
      4. Close the application.
      5. Run the application
      6. Check Label Filter. Notice that Ignore case is unchecked.

    Thanks
  13. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 04 May 2013 Link to this post

    Hi Richard,

    Thank you for the steps, we were testing with other filters and that's what caused the misunderstanding. If you test it with "begins with" condition, you'll see that the Ignore case value is persisted. The difference between the two cases is that "begins with" is a filter of type "TextCondition" where the IgnoreCase is public property and it can be easily serialized/deserialized. When you use "equals", we create a ComparisonCondition, where the IgnoreCase is an internal property and the application cannot set its value when deserializing. As I've already said, with our next official release we'll introduce a much better and easier way for persistence. It will include serialization and deserialization of all properties so this issues will not exist.

    We are sorry for the caused inconvenience. Feel free to contact us if you have any problems or concerns.

    Kind regards,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

Back to Top
UI for WPF is Visual Studio 2017 Ready