April 27, 2006, 09:36 AM
BenCCSV 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
reFOCUSingCould 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
BenCI 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
newtofocusWhat version are you using?. Are you trying to pull the CSV file through a browser?
April 28, 2006, 10:54 AM
BenCYes, I am trying to pull the CSV through a browser. And I am using WF 7.1