Hello Alberto, thanks for your hint about using a servlet outside the application. This may be a first way handling the problem. I think only in that case a response type can be set. I also thought about writing an user extension. This might also work.
Changing the explorer options can't be done cause the clients who are using the application may not be authorized to change the settings. Thanks and regards, Daniel Backhausen [EMAIL PROTECTED] wrote: ----- To: <[email protected]>, <[EMAIL PROTECTED]> From: "Alberto Smulders" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] Date: 04/20/2007 17:34 Subject: Re: [ULC-developer] Question about 'ClientContext.showDocument(..)' in ApplicationServer Environment Open Windows Explorer, then go to "Tools" - "Folder Options". Choose "File Types", scroll to "XLS" under "Registered file types". Push "Advanced" button and remove the check mark "Browse in same window" -- now your Excel files should open with Excel instead of being embedded in an IE browser window. Also important, did you set your response content type to "application/vnd.ms-excel" ? I generate also an Excel sheet in one of my applications, I use poi-3.0-alpha for that, but I do it in a completely separate servlet, not tested doing it from within my Canoo application. It works more or less like this: Canoo app generates a sessionid and puts the id and other relevant information in a sessions table in the database (table has a trigger so new inserts automatically delete expired sessions); then a call is made to the servlet with the sessionid in the url; the servlet looks up the session data in the database, generates the Excel sheet and streams it to response object (with the content type shown above). Kind regards, Alberto A.Smulders HostDat Lda. - Portugal ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[email protected]> Cc: <[EMAIL PROTECTED]> Sent: Friday, April 20, 2007 1:54 PM Subject: [ULC-developer] Question about 'ClientContext.showDocument(..)' in ApplicationServer Environment > Hello all, > > we have a problem using the method 'ClientContext.showDocument(..)' in an > application server environment. Our goal is to let a user show the current > table data in Microsoft Excel. Therefore we generate a file and send it to > the client using the community code of the DownloadManager. Things work out > fine using the application in standalone mode but not starting it with > jnlp. Because the server sends a HTTP stream to the client, it wants to > open the excel file in a browser window where else it should open excel > directly. Is there a way doing this using jnlp? We allready set it that > way, that the user has to select the file on a local directory using the > 'ClientContext.storeFile(..)' method. So opening ain't some temporary file > on the server but an existing local file. > > All permission configuration stuff like > 'ClientEnvironmentAdapter.setFileService(new AllPermissionsFileService());' > are allready included. > > Has anyone an idea or any advice? > > Thanks and best regards, > Daniel Backhausen > Pz¢TSS,½¥Sq¡?Ûiÿùb²Û jz(r?¿T¨¥T©ÿ-+-Swèþé\uëÞ-S^ ---------------------------------------------------------------------------- ---- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 269.5.5/769 - Release Date: 19-04-2007 17:56 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 269.5.5/769 - Release Date: 19-04-2007 17:56 _______________________________________________ ULC-developer mailing list [email protected] http://lists.canoo.com/mailman/listinfo/ulc-developer _______________________________________________ ULC-developer mailing list [email protected] http://lists.canoo.com/mailman/listinfo/ulc-developer
