Focal Point
CSV Limit?

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8191024561

April 27, 2006, 09:36 AM
BenC
CSV Limit?
Hi All,

I am having a problem getting a CSV file for a large number of records (in the millions).

My procedure works fine with HTML etc, but when I choose CSV (COMMA), it gives me a HTTP 500 error and tells me that I should contact my adminitrator. Is there a limitation on how much data can be put into the CSV and sent to the user?
April 27, 2006, 10:45 AM
reFOCUSing
Could the problem be that you can only put around 65,000 rows of data on one Excel worksheet? Try limiting your data to 65,000 and see if the fex works, if it does you will need to put some code in the fex to break the output onto multiple worksheets.
April 27, 2006, 11:45 AM
BenC
I am using the CSV file for a database. If I limit it to 65000 records, then it would be no different then an excel file.
April 27, 2006, 02:07 PM
newtofocus
What version are you using?. Are you trying to pull the CSV file through a browser?


WF7.1.4 Prod/Test, MRE, self serve, DM
April 28, 2006, 10:54 AM
BenC
Yes, I am trying to pull the CSV through a browser. And I am using WF 7.1