Reg: PIVOT GRID Custome View Save

2 posts, 0 answers
  1. Chakri
    Chakri avatar
    4 posts
    Member since:
    Jul 2011

    Posted 08 Mar 2018 Link to this post

    Hello Team,

    We are into the WPF application development. We are using the RadPivotGrid control to view the information grid. To view the same BI format we are saving the  view(i.e in XML format). When we save the view. our application is saving the data in our database in XML format. Please review the attached file which is saved in xml format. But we want to know the what is the <ValueTypes> node which is created while saving the view. We want to know what is the version number saved in the file. Is there any relation with .net framework version while generating the XML string?

    Below is the XML string.

    <?xml version="1.0"?>
    <RawData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <SerializationString>&lt;?xml version="1.0" encoding="utf-16"?&gt;
    &lt;Data xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;
      &lt;T&gt;
        &lt;TI K="1984105613" N="Telerik.Pivot.Core.LocalDataSourceProvider, Telerik.Pivot.Core, Version=2014.2.729.45, Culture=neutral, PublicKeyToken=5803cfa389c90ce7" /&gt;
      &lt;/T&gt;
      &lt;P&gt;
        &lt;PV Key="1" TypeKey="-664072138"&gt;
          &lt;Value xsi:type="xsd:string"&gt;&amp;lt;DataProviderSettings xmlns="http://schemas.datacontract.org/2004/07/AIMSDotNet" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"&amp;gt;&amp;lt;Aggregates xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays"&amp;gt;&amp;lt;a:anyType i:type="b:PropertyAggregateDescription" xmlns:b="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core"&amp;gt;&amp;lt;b:CustomName i:nil="true"/&amp;gt;&amp;lt;b:TotalFormat i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core.Totals"/&amp;gt;&amp;lt;b:StringFormat i:nil="true"/&amp;gt;&amp;lt;b:StringFormatSelector i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core.Aggregates"/&amp;gt;&amp;lt;b:AggregateFunction i:type="b:SumAggregateFunction" xmlns:c="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core.Aggregates"/&amp;gt;&amp;lt;b:PropertyName&amp;gt;Stock&amp;lt;/b:PropertyName&amp;gt;&amp;lt;/a:anyType&amp;gt;&amp;lt;/Aggregates&amp;gt;&amp;lt;AggregatesLevel&amp;gt;0&amp;lt;/AggregatesLevel&amp;gt;&amp;lt;AggregatesPosition&amp;gt;Rows&amp;lt;/AggregatesPosition&amp;gt;&amp;lt;Columns xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays"&amp;gt;&amp;lt;a:anyType i:type="b:PropertyGroupDescription" xmlns:b="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core"&amp;gt;&amp;lt;b:CustomName i:nil="true"/&amp;gt;&amp;lt;b:GroupComparer i:type="b:GroupNameComparer"/&amp;gt;&amp;lt;b:SortOrder&amp;gt;Ascending&amp;lt;/b:SortOrder&amp;gt;&amp;lt;b:GroupFilter i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core.Filtering"/&amp;gt;&amp;lt;b:ShowGroupsWithNoData&amp;gt;false&amp;lt;/b:ShowGroupsWithNoData&amp;gt;&amp;lt;b:CalculatedItems/&amp;gt;&amp;lt;b:PropertyName&amp;gt;WarehouseCode&amp;lt;/b:PropertyName&amp;gt;&amp;lt;/a:anyType&amp;gt;&amp;lt;/Columns&amp;gt;&amp;lt;Filters xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays"/&amp;gt;&amp;lt;Rows xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays"&amp;gt;&amp;lt;a:anyType i:type="b:PropertyGroupDescription" xmlns:b="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core"&amp;gt;&amp;lt;b:CustomName i:nil="true"/&amp;gt;&amp;lt;b:GroupComparer i:type="b:GroupNameComparer"/&amp;gt;&amp;lt;b:SortOrder&amp;gt;Ascending&amp;lt;/b:SortOrder&amp;gt;&amp;lt;b:GroupFilter i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core.Filtering"/&amp;gt;&amp;lt;b:ShowGroupsWithNoData&amp;gt;false&amp;lt;/b:ShowGroupsWithNoData&amp;gt;&amp;lt;b:CalculatedItems/&amp;gt;&amp;lt;b:PropertyName&amp;gt;StyleDescription&amp;lt;/b:PropertyName&amp;gt;&amp;lt;/a:anyType&amp;gt;&amp;lt;a:anyType i:type="b:PropertyGroupDescription" xmlns:b="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core"&amp;gt;&amp;lt;b:CustomName i:nil="true"/&amp;gt;&amp;lt;b:GroupComparer i:type="b:GroupNameComparer"/&amp;gt;&amp;lt;b:SortOrder&amp;gt;Ascending&amp;lt;/b:SortOrder&amp;gt;&amp;lt;b:GroupFilter i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core.Filtering"/&amp;gt;&amp;lt;b:ShowGroupsWithNoData&amp;gt;false&amp;lt;/b:ShowGroupsWithNoData&amp;gt;&amp;lt;b:CalculatedItems/&amp;gt;&amp;lt;b:PropertyName&amp;gt;ColorDescription&amp;lt;/b:PropertyName&amp;gt;&amp;lt;/a:anyType&amp;gt;&amp;lt;a:anyType i:type="b:PropertyGroupDescription" xmlns:b="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core"&amp;gt;&amp;lt;b:CustomName i:nil="true"/&amp;gt;&amp;lt;b:GroupComparer i:type="b:GroupNameComparer"/&amp;gt;&amp;lt;b:SortOrder&amp;gt;Ascending&amp;lt;/b:SortOrder&amp;gt;&amp;lt;b:GroupFilter i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/Telerik.Pivot.Core.Filtering"/&amp;gt;&amp;lt;b:ShowGroupsWithNoData&amp;gt;false&amp;lt;/b:ShowGroupsWithNoData&amp;gt;&amp;lt;b:CalculatedItems/&amp;gt;&amp;lt;b:PropertyName&amp;gt;Size&amp;lt;/b:PropertyName&amp;gt;&amp;lt;/a:anyType&amp;gt;&amp;lt;/Rows&amp;gt;&amp;lt;/DataProviderSettings&amp;gt;&lt;/Value&gt;
        &lt;/PV&gt;
      &lt;/P&gt;
      &lt;R&gt;
        &lt;RV Key="21184986" IsRoot="true" TypeKey="1984105613"&gt;
          &lt;D&gt;
            &lt;PD PN="" VK="1" RK="0" TK="1984105613" TCK="0" /&gt;
          &lt;/D&gt;
        &lt;/RV&gt;
      &lt;/R&gt;
    &lt;/Data&gt;</SerializationString>
      <ValueTypes>
        <string>Telerik.Pivot.Core.LocalDataSourceProvider, Telerik.Pivot.Core, Version=2014.2.729.45, Culture=neutral, PublicKeyToken=5803cfa389c90ce7</string>
      </ValueTypes>
    </RawData>

    We want to know what is the significance of the  version number(i.e Version=2014.2.729.45) in the below context? 

      <ValueTypes>
        <string>Telerik.Pivot.Core.LocalDataSourceProvider, Telerik.Pivot.Core, Version=2014.2.729.45, Culture=neutral, PublicKeyToken=5803cfa389c90ce7</string>
      </ValueTypes>
    </RawData>

    Following are the software specifications

    OS: WINDOWS 10

    .Net Framework: 4.6.2

    Telerik Version: 14.2.729.0

     

    Regards,

    Chakradhar

     

     

  2. Dilyan Traykov
    Admin
    Dilyan Traykov avatar
    1070 posts

    Posted 12 Mar 2018 Link to this post

    Hello Chakri,

    By default, when the persistence framework saves a type it also saves its assembly's version and when deserializing it tries to get this exact same type (with the same version). We do this because there might be breaking changes between the different dll versions and the framework might not be able to load the properties correctly.

    This information is used by the AllowCrossVersion property of the PersistenceManager class. Please note, however, that it only works for the assemblies from the UI for WPF suite.

    I hope that this sheds some light on the matter. Should any follow up questions or concerns arise, do not hesitate to contact me again.

    Regards,
    Dilyan Traykov
    Progress Telerik
    Want to extend the target reach of your WPF applications, leveraging iOS, Android, and UWP? Try UI for Xamarin, a suite of polished and feature-rich components for the Xamarin framework, which allow you to write beautiful native mobile apps using a single shared C# codebase.
Back to Top