Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): George Alsobrooks / George Alsobrooks (GEORGE ALSOBROOKS)
Created: 01/22/2015
Components: File Management, VFS-RAM
Versions: 10.0
Failure Type: Non Functioning
Found In Build/Fixed In Build: Final /
Priority/Frequency: Normal / Some users will encounter
Locale/System: English / Win 2008 Server R2 64 bit
Vote Count: 1
Problem Description: cfspreadsheet tag is unable to write to the Virtual File System by using "ram://"
This was reportedly fixed in CF 10 Update 11, and previously reported in these Bugs:
3178676 "cfspreadsheet with ram://"
3042909 "Cannot use action="write" with the cfspreadsheet tag and a filename on the VFS "
Steps to Reproduce:
<cfoutput>
<br><br>Write text file to disk
<cffile action="write" file="#expandPath('./cfspreadsheet.txt')#" output="Quick Test">
<br><br>Write text file to ram
<cffile action="write" file="ram://cfspreadsheet.txt" output="Quick Test">
<br><br>Read text file from ram
<cffile action="read" file="ram://cfspreadsheet.txt" variable="ReadInfo">
<br><br>We read in: #ReadInfo#
<cfset qtest = QueryNew('A,B,C')>
<br><br>Write excel file to disk
<cfspreadsheet action="write" filename="#expandPath('./cfspreadsheet.xls')#"query="qtest" overwrite="true">
<br><br>Write excel file to ram
<cfspreadsheet action="write" filename="ram://cfspreadsheet.xls" query="qtest" overwrite="true">
<!--- The above line throws an error --->
</cfoutput>
Actual Result: The following error message is displayed:
An exception occurred while using action=write.
java.io.FileNotFoundException: ram:///cfspreadsheet.xls
Expected Result: cfspreadsheet should write the excel file to ram and not throw an error.
Any Workarounds: Write to Disk instead of ram.
Other:
In the example above I write to and read from ram using cffile just to verify that ram:// is available. All of the code above worked except for the last line trying to cfspreadsheet to ram://.
I don't have the ability to remove updates from the ColdFusion server so I have no way to test which update broke this functionality, or if it was still broke after Update 11. I'm only now trying to use this to help with the god awful slowness of the spreadsheet functions in ColdFusion.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3925916
External Customer Info:
External Company:
External Customer Name: GEORGE
External Customer Email:
External Test Config: My Hardware and Environment details:
Windows 2008R2 64 Bit Server
Coldfusion 10 with Update 15.
Attachments:
Comments: