Saving The RadPivotGrid.LocalDataSourceProvider

[Tomer]

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

 . 

[Rosen Vladimirov]

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

[Richard]

Hi,

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

Thanks,
Chard

[Rosen Vladimirov]

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

[Richard]

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

[Rosen Vladimirov]

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

[Richard]

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.

[Rosen Vladimirov]

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

[Richard]

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

[Hristo]

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

[Richard]

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

[Rosen Vladimirov]

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