Get Free Trial

Excel export positioning data error on large dataset

Answered
massimo besozzi asked on September 29, 2022

HI,
attached there are 2 files, F18.ab.xslx and F18.ab_only_entity_err.xlsx, that contains the same report F18.ab.xlsx contains more than one ENTITIES while the other one contains only one (ENTITY_ERROR).
In the first report (F18.ab.xlsx) there is an error, some amounts are shifted to the left after excel and csv export (HTML is correct),while in the other one  are correct.Look at the date 31/03/2022 and 30/06/2022 columns 150-160(31/03/2022) 20-140(30/06/2022).
In the web grid all reports are corrects.

13 answers

Public
massimo besozzi September 30, 2022

The version in use is :
 
/**
* Flexmonster Pivot Table & Charts [https://www.flexmonster.com/]
* September 2022 (v. 2.9.34)
* Copyright (c) 2022 Flexmonster. All rights reserved.
*

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster September 30, 2022

Hello, Massimo!
 
Thank you for contacting us and providing us with the attachments for your case.
 
Kindly note that we could not reproduce the described export behavior on our side. 
Could you please provide us with the sample report where the case is reproducible? With this information, we’ll be able to compare the data on the grid with the exported Excel file and continue the investigation.
 
You can modify our JSFiddle sample to make the case reproducible: https://jsfiddle.net/flexmonster/3wgbb191/.
 
Looking forward to your response.
 
Kind regards,
Solomiia

Public
massimo besozzi September 30, 2022

Hi ,
 
i have attached the data in csv format and the slice in json format.
 
Bye

Attachments:
to_flexMonster.zip

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster October 4, 2022

Hello, Massimo!
 
Thank you for providing us with the sample data and report.
 
Still, we haven’t managed to reproduce the described exporting behavior.

We have created the pivot using the data you provided in the attached flexmonster.html file and exported it, but there are no shifts in the resulting Excel file.
Note that the dates in this example are sorted as regular strings, as they weren’t in ISO 8601 format in the provided CSV file, so the component can’t parse them as dates correctly.
 
We also want to kindly note that if using the custom data source API, the data can be shifted before it comes to the component. We kindly suggest checking the responses from the server to investigate the case further.
 
Looking forward to your response.
 
Kind regards,
Solomiia

Attachments:
flexmonster.zip

Public
massimo besozzi October 5, 2022

Hello, we use Flexmonster Data Server as a data source, the date field is SQL Date. We need a solution as soon as possible.
 
thanks in advance

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster October 6, 2022

Hello, Massimo!
 
Thank you for the additional details about your data source.
 
We understand that seeing different data on the grid and in the exported file is unacceptable, and we are ready to provide you with a fix. 
For that, we need to reproduce the described behavior on our side. As we haven’t managed to reproduce it yet, our team wants to kindly ask for your cooperation.
 
Here are the steps our team has tried to reproduce the issue:

1. Created a pivot table with the slice in the JSON format and with the sample CSV data you have provided.
2. Exported the data in Excel.
3. Opened exported Excel file and compared the data to the pivot.

It seems to us that the data in the component and in the exported file are the same.

Could you please check one more time if the described behavior is reproducible on mentioned sample data and slice? If yes, could you please tell us the exact rows and columns where the shift is visible?

If the described behavior is not reproducible on this sample CSV data, we kindly ask you to provide us with another example. In case of sensitive data, you can send the file to our inbox.
 
Looking forward to hearing from you.
 
Kind regards,
Solomiia

Public
massimo besozzi October 7, 2022

Hi
I send Valeriia Khomenets a private email with a link to download data:

  • CSV files
  • flexmonster html example with report

You have to create an index in Flexmonster Data Server, use csv file as datasource.

  1. onfigure Flexmonster data server
  2. Configure flexmonster.html file to use correct data source and index (i put placeholders  into the file)
  3. Export the report into excel format(as i prepared for you)
  4. Execute report only with entity ENTITY_ERROR
  5. Export the report into excel format

The same period 31/03/2022 30/06/2022 (excel column BYZ in the first report) are different and the correct one is the second report.(point 4)

If you follow the steps above, the bug is reproduced.

I await yours.

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster October 10, 2022

Hello Massimo,
Thank you for providing such a detailed explanation.
We have reproduced the described issue on our side.
Our team will release the version with the fix, ETA Oct 31st.
Please let us know if you have any further questions.
Regards,
Dmytro

Public
massimo besozzi October 12, 2022

Thanks ,
I’m waiting yours.

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster November 1, 2022

Hello, Massimo!

We are happy to inform you that the issue with exporting large data to Excel was fixed.

This fix is included in the 2.9.37 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-37/.

You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/.

Please let us know if the fix works fine for you.

Best regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster November 9, 2022

Hello, Massimo!

Hope you are having a great week.

Our team is wondering if you had a chance to test the fix. Could you please let us know if everything works well?

Looking forward to hearing from you.

Kind regards,
Solomiia

Public
massimo besozzi November 9, 2022

Hello,
I had replied via email, however the problem was solved.
A thousand thanks.

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster November 9, 2022

Hello, Massimo!

Thank you for your feedback.

We are glad to hear that the fix works well for you.

Feel free to contact us in case of any other questions.

Regards,
Solomiia

Please login or Register to Submit Answer