Question
Opening CSV file via CFHTTP in Excel 2003
Hi Guys
We are having an issue with a CFM page we have created (using CFHTTP) to extract/open a CSV file from a Unix Drive, under Windows XP/Excel 2003.
Our apps is on our Portal to open a CSV file (Excel Download). When clicking on our Download button, the regular IE pop up let us choose between Opening the file or Save it. On W2K/Excel 2K, both options are behaving properly, meaning that I can locally save the CSV file or opening it in Excel. With Win XP and Excel 2003, the SAVE option is working OK as it let me save my CSV file, but when I'm clicking on OPEN, it will launch Excel and will open my CFM page (lets call it downloadCFHTTP.cfm) in Excel with the content of the CSV file in it. so if you are trying to save that file once displayed in Excel, the program crashed as it looks like it is trying to save the CFM file on the web server instead of proposing the user to save the CSV file.
Have you ever experienced something like that? How can it be fixed?
Thanks in advance
Eric L.
We are having an issue with a CFM page we have created (using CFHTTP) to extract/open a CSV file from a Unix Drive, under Windows XP/Excel 2003.
Our apps is on our Portal to open a CSV file (Excel Download). When clicking on our Download button, the regular IE pop up let us choose between Opening the file or Save it. On W2K/Excel 2K, both options are behaving properly, meaning that I can locally save the CSV file or opening it in Excel. With Win XP and Excel 2003, the SAVE option is working OK as it let me save my CSV file, but when I'm clicking on OPEN, it will launch Excel and will open my CFM page (lets call it downloadCFHTTP.cfm) in Excel with the content of the CSV file in it. so if you are trying to save that file once displayed in Excel, the program crashed as it looks like it is trying to save the CFM file on the web server instead of proposing the user to save the CSV file.
Have you ever experienced something like that? How can it be fixed?
Thanks in advance
Eric L.
AdChoices