toolbar save and load report not working with data type CSV

Question

Hello,

I have an issue with save and load report, the data in CSV format. I noticed that data is stored in the datasource without column names. Because of this, save and load report does not work.

Am I missing something?Attachment: pivottable_922f25b4.zip

AngelinFaithSheeba PaulvannanRajadurai · Answer

Hi Salwaen,We are validating the reported issue and will provide
further details within two business days (June 8, 2022). However, you can
utilize the below workaround solution to overcome the reported problem until
then.Code Example:

methods: {
     
  loadReport: function(args) {
     
    let pivotObj = (this.$refs.pivotview).ej2Instances;
     
    let reportCollection =
  [];
     
    if (
     
      localStorage.pivotviewReports &&
     
      localStorage.pivotviewReports !== ""
     
    ) {
     
      reportCollection = JSON.parse(localStorage.pivotviewReports);
     
    }
     
    reportCollection.map(function(item) {
     
      if (args.reportName === item.reportName) {
     
        args.report = item.report;
     
      }
     
    });
     
   pivotObj.setProperties(
     
                  { dataSourceSettings:
  JSON.parse(args.report).dataSourceSettings},
     
                  true
     
                );
     
      pivotObj.refreshData();
   
      }
  }

Meanwhile, we have prepared a sample
for your reference.Sample:  https://www.syncfusion.com/downloads/support/directtrac/general/ze/pivot235751094Please let us know if you have any
concerns.Regards,Angelin Faith Sheeba

AngelinFaithSheeba PaulvannanRajadurai · Answer

Hi Salwaen,We have considered this as a
bug “Save and load report not working properly with CSV data”. And
this fix will be available in our Vol 2 main release which
is estimated to be rolled out at end of June 2022. You
can track the same by using below link.https://www.syncfusion.com/feedback/35531/save-and-load-report-not-working-properly-with-csv-dataPlease let us know if you
have any concerns.Regards,Angelin
Faith Sheeba.

salwaen · Answer

Thank you

Angelin

Manikandan Murugesan · Answer

Hi Salwaen,Please let us
know if you have any other queries. We are always happy to assist you.Regards,Manikandan

AngelinFaithSheeba PaulvannanRajadurai · Answer

Hi
Salwaen,We are glad to announce that our Essential
Studio weekly release V20.1.61 is rolled out and fix for the issue “Save and load
report not working properly with CSV data” has been
included in this release. Please refer to the following sample.Sample:https://www.syncfusion.com/downloads/support/directtrac/general/ze/pivot1251520689We
thank you for your support and appreciate your patience in waiting for this
release. Please contact us if you require any further assistance.Regards,Angelin
Faith Sheeba.

salwaen · Answer

Hi Angelin,I tested

V20.1.61

in Vue 3 application. Unfortunately it does not work.Regards,Salwaen

AngelinFaithSheeba PaulvannanRajadurai · Answer

Hi Salwaen,The sample from our previous update, which uses the most
recent version V20.1.61 in Vue 3 application, is functional and working fine.
However, we have prepared a sample in Vue 3 application.Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/F175421-2010315669Kindly
refer to the following document to know more details about the Vue 3
Application.Document: https://ej2.syncfusion.com/vue/documentation/pivotview/getting-started-vue-3/Please
let us know if you have any concerns.Regards,Angelin Faith Sheeba

salwaen · Answer

Hi Angelin,

Yes your project is working properly , I should update all components in my project to the latest new version for it to work fine.Thank you for your support!

Regards,

Salwaen

AngelinFaithSheeba PaulvannanRajadurai · Answer

Hi Salwaen,Thanks
for the update. Please contact us if you have any other queries. We are always
happy to assist you.Regards,Angelin Faith Sheeba.