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)...
⋅ 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
⋅ 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
⋅ 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
⋅ August 9, 2022
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
⋅ August 22, 2022
Hello, Santosh!
Hope you are having a great week.
Just checking in to ask if you had any progress connecting Flexmonster to the CSV data source.
Looking forward to your feedback.
Regards,
Solomiia