I am facing an issue with connect csv file using flexmonster Compressor.
It is working fine in local. Once it is moving to production it is giving following Error.
“Unable to open file http://XXX.com/api/Cube/Get?427089316.
It seems that this file doesn’t exist or ‘Access-Control-Allow-Origin’ header is absent in the resource requested.“
I have given permissions for the Access-Control-Allow-Origin in web.config File.
Please help me how to solve this.
Thank you for writing to us.
Please check all possible cases described here: https://www.flexmonster.com/doc/typical-errors/#!unable-to-open-file. Let me know if it helps. Waiting for your reply.
Thank you for the response.
I have found issue in csv file, have corrected it.
CSV file having Year column, which is having some string values, while conversion this is giving error.
I have used aspnet compressor technique with 1million rows with 20 columns, still it is taking 6 minutes of time to load the data. Is there any way to reduce the time to load the data.
Please let me know how to make it faster loading of my data.
Thank you for writing. We are glad you have managed to resolve it.
As for pivot’s loading speed, please have a look at the following article: https://www.flexmonster.com/blog/sql-pivot-table-best-performance/. It describes some key ideas of getting a better performance when working with the compressor. Also, you can try configuring g-zip on the server side.
Please let us know if the information above was helpful for you.
Thank you for the response. I will check it.
is there any way to download sample csv with 1 million rows using in following link
Thank you for your feedback. You are welcome to refer to the following thread: https://www.flexmonster.com/question/improve-speed-for-flexmonster-1million-row/ since the similar question was already discussed there.
Please let us know in case of any other questions.