Get Free Trial

while using flexmonster js we are getting error.

Answered
santhosh krishna asked on July 29, 2022

flexmonster.js:2347

Uncaught TypeError: Cannot read properties of null (reading ‘cancel’)
at a.kDa (flexmonster.js:2347:60)
at a.XH (flexmonster.js:2345:500)
at a.dga (flexmonster.js:2345:386)
at a.wfa (flexmonster.js:2345:249)
at a.vK (flexmonster.js:2343:402)
at flexmonster.js:2338:287
 
 
this error we are getting while connecting to data. Also, we want to know how much of the pivot data this API can process(in MB, GB)…

4 answers

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster August 1, 2022

Hello, Santhosh!
 
Thank you for contacting us.
 
We haven’t managed to reproduce the described behavior on our side. Could you please provide us with a sample report where this issue is reproducible?
 
Here is also an example of connecting Flexmonster to a remote CSV file for reference: http://jsfiddle.net/flexmonster/pc8nzn5z/.
 
Regarding your question about the amount of data Flexmonster can handle, it depends a lot on a data structure.
Please note that it requires some testing to define the optimal size of data. At the same time, Flexmonster provides a special custom API approach that is designed to handle large amounts of data.
 
Could you please provide us with your data amount requirements, so we’ll be able to suggest you something more case-specific?
 
Looking forward to hearing from you.
 
Regards,
Solomiia

Public
santhosh krishna August 1, 2022

So we have our 700 CSV files in our azure data lake servers we are using .net as the backend  we want to 
showcase in pivot table 

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster August 2, 2022

Hello, Santosh!
 
Thank you for getting back to us and for the details of your use case. They were very helpful.
 
We recommend two approaches to handle CSV files in Flexmonster. Please find the detailed description of each below.
 
1. Using CSV as a data source.
You can connect remote CSV files to Flexmonster as follows:

report: {
    dataSource: {
      type: "csv",
      filename: "https://cdn.flexmonster.com/data/data.csv"
    }
  }

Kindly note that this approach requires the whole file to be loaded into the browser’s memory.

You can find more details about the CSV data source in our docs: https://www.flexmonster.com/doc/csv-data-source/.
 
2. Using Flexmonster Data Server as a data source. If your files are more than 100-150Mb, we recommend this approach for better performance.

The Data Server is a server-side tool responsible for aggregating the data and sending it to Flexmonster in ready-to-shown format. This approach reduces the use of browser memory as the Data Server loads files into the RAM instead.

Here is a step-to-step guide on how to connect CSV files to Flexmonster using Flexmonster Data Server: https://www.flexmonster.com/doc/pivot-table-connect-to-csv/.

The Data Server can be used as a DLL instead of the console application. Please let us know if you need more details about this approach.
 
Hope you will find our answer helpful. You are welcome to ask if any further questions arise.
 
Regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster 4 days ago

Hello, Santosh!

Hope you are doing well.

Our team is wondering if you had some time to try the suggested approaches and connect to the CSV data source. Could you please let us know if any of them works for your case?

Looking forward to hearing from you.

Regards,
Solomiia

Please login or Register to Submit Answer