Re: Webwasher, Excel files, and why I hate my life
On Friday 17 Aug 2007, [EMAIL PROTECTED] wrote: You will avoid that problem if you use Apache POI to generate the Excel file instead of using HTML tables. He said he had the same problem with 'real' Excel XML files, as per the MS spec. So MailWasher is broken. Who knows that else is wrong with it ? -- Tom Chiverton Helping to widespreadedly synthesize scalable solutions on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286449 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Webwasher, Excel files, and why I hate my life
I also have no access to appache, thanks for all your responses no it is just a matter of convincing these corperate types to let go of webwasher for this intranet site on which they control the content anyhow. On 8/17/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Friday 17 Aug 2007, [EMAIL PROTECTED] wrote: You will avoid that problem if you use Apache POI to generate the Excel file instead of using HTML tables. He said he had the same problem with 'real' Excel XML files, as per the MS spec. So MailWasher is broken. Who knows that else is wrong with it ? -- Tom Chiverton Helping to widespreadedly synthesize scalable solutions on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286464 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Webwasher, Excel files, and why I hate my life
To clarify, Apache POI is not the Apache Web server. It comes standard as part of ColdFusion MX. No need to install anything. Just invoke functions that are already there. I don't think you will find this mentioned in the documentation, but there are some nice blogs that tell you exactly what to do. -Mike Chabot On 8/17/07, Wesley Middendorff [EMAIL PROTECTED] wrote: I also have no access to appache, thanks for all your responses no it is just a matter of convincing these corperate types to let go of webwasher for this intranet site on which they control the content anyhow. On 8/17/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Friday 17 Aug 2007, [EMAIL PROTECTED] wrote: You will avoid that problem if you use Apache POI to generate the Excel file instead of using HTML tables. He said he had the same problem with 'real' Excel XML files, as per the MS spec. So MailWasher is broken. Who knows that else is wrong with it ? -- Tom Chiverton Helping to widespreadedly synthesize scalable solutions on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286536 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Webwasher, Excel files, and why I hate my life
Hello all, I am having a small problem. I am attempting to generate excel files using coldfusion and then force the user to the excel file. The client has webwasher content filtering on their network and I get the following error message from webwasher when attempting to view SOME of excel files: The transferred file http://192.168.4.122/sup_report/exceloutput/OPR_7_2007_0.769483807854.xls; has been blocked by Webwasher. The server returned a file of type application/vnd.ms-excel but the content of this file is of a different type. This is odd to me as the same CF function generates the excel file content. The code is nothing more than a loop over a query that outputs a HTML table and saves the content in a variable and then dumps the variable into a new created file with extension .xls and the files do open in excel no problem. Also, I have written some sample files in XML per MS Tech net articles on how to do so. These files also work in excel, but not through the browser. I am about to pull my hair out on this one as these folks have decided that adding this Intranet site to a list of sites for webwasher to bypass is simply not an option. Thanks in advance for all your help, Wes ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286350 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Webwasher, Excel files, and why I hate my life
On Thursday 16 Aug 2007, [EMAIL PROTECTED] wrote: Also, I have written some sample files in XML per MS Tech net articles on how to do so. These files also work in excel, but not through the browser. Then WebWasher is broken. They'll have to add you to the bypass list. -- Tom Chiverton Helping to evangelistically scale unique services on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286351 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Webwasher, Excel files, and why I hate my life
You will avoid that problem if you use Apache POI to generate the Excel file instead of using HTML tables. Apache POI is harder to work with, but ultimately you have more control over the resulting file and the file will be an actual Excel file as opposed to being an HTML document that gets opened by MS Excel. -Mike Chabot On 8/16/07, Wes Middendorff [EMAIL PROTECTED] wrote: Hello all, I am having a small problem. I am attempting to generate excel files using coldfusion and then force the user to the excel file. The client has webwasher content filtering on their network and I get the following error message from webwasher when attempting to view SOME of excel files: The transferred file http://192.168.4.122/sup_report/exceloutput/OPR_7_2007_0.769483807854.xls; has been blocked by Webwasher. The server returned a file of type application/vnd.ms-excel but the content of this file is of a different type. This is odd to me as the same CF function generates the excel file content. The code is nothing more than a loop over a query that outputs a HTML table and saves the content in a variable and then dumps the variable into a new created file with extension .xls and the files do open in excel no problem. Also, I have written some sample files in XML per MS Tech net articles on how to do so. These files also work in excel, but not through the browser. I am about to pull my hair out on this one as these folks have decided that adding this Intranet site to a list of sites for webwasher to bypass is simply not an option. Thanks in advance for all your help, Wes ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286443 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4