Problem with Connecting to CSV using Compressor

Hi,
 
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.

6 answers

Public
Tanya Gryshko Flexmonster September 21, 2018

Hello,
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.
Regards,
Tanya

Public

Hi,
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.

Public
Dmytro Zvazhii Flexmonster September 24, 2018

Hi,
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.
Regards,
Dmytro

Public

Thank you for the response. I will check it.

Public

is there any way to download sample csv with 1 million rows using in following link
https://www.flexmonster.com/demos/one-million-rows/

Public
Dmytro Zvazhii Flexmonster September 26, 2018

Hi,
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.
Regards,
Dmytro

Please login or Register to Submit Answer