Hi guys,

We're still on WF77, Windows 7. I seem to have WFServlet download in Chrome without an extension. The same fex in IE downloads with the .xls extension.

Is there a Chrome setting I am missing? I have .xht in the Redirect Settings set to yes/yes. I also have WEBARCHIVE set to OFF.

The problem with the WFServlet without an extension is we can't associate the thing to always open in Excel.

How do you have this set in your installation?

Regards,
Anatess.

This message has been edited. Last edited by: <Emily McAllister>,

I've cut and pasted this from another similar problem. Maybe this is the issue:

A combination of two settings is required:

 Use SET WEBARCHIVE = OFF to change WebFOCUS processing from XMH to XHT format.
 Change the Redirection Settings for the XHT format to Yes/Yes to redirect and
 save the report to XLS format.
 1. SET WEBARCHIVE = OFF
    You can specify the command either directly within the .fex procedure
itself
    or you can specify the command within the edasprof.prf.  Placing the
command
    within the edasprof.prf file allows it to be globally enabled for all
    requests.
 To set the command in the edasprof:
    http://server:8121 (for a default installation)
    Click Workspace and then Expand Configuration Files
    Right click "Server Profile - edasprof.prf(TAKE A BACK UP FIRST)
    Add SET WEBARCHIVE = OFF to a new line at the bottom of the file.

 2. To set the Redirection Settings:
    http://server:8080/ibi_apps/
    Click WebFOCUS Administration Console
    Expand Configuration
    Click Redirection Settings
    Change the settings for .xht format to Yes and Yes
    Click Save at the bottom of the page
 Click Clear Cache at the top of the page

Yes. We already have those settings. Does your Excel output download in Chrome with an extension?

Yes, but I'm running Windows 10 and WF 8.105.

Anatess,

This is a result of a change by Chrome in how it recognizes webarchive files. It no longer provides the extension for whatever reason. You need to change your redirection settings for your excel extensions to save to the server. This will create a file with the .xls/.xlsx extension instead of the xmh/xht formats. If you need help with which one specifically to change, please post all of your redirection settings related to all Excel formats and we can help point you in the right direction.

Hi Eric,

Thank you for your response.

We already have the redirection settings for .xht set to yes/yes. All other Excel-type extensions are set to no/no. We had this change made when IE decided to not open .xht files anymore. So, in IE, the file downloads with the .xls extension.

Regards,
Anatess

its not the xht setting. Its the excel ones. there are multiple different extensions for excel.

Yes, they're all set to no/no except for .xht. Should I set them all to yes/yes?

yes, but only the ones related to excel. It is worth reading the help files on the redirection settings. For instance, I don't have my PDF files set the same as my excel files. You need to understand the needs of your organization and how you want things to work.

This message has been edited. Last edited by: eric.woerle,

Hi Eric,

Yes, we have our redirect settings set to how we want it. We only need .xht to be set to yes/yes as that is the only Excel output that we need to redirect since IE, for some reason, does not recognize .xht files as Excel files anymore. It has no problems with the other Excel extensions. Therefore, we only need to redirect the .xht output so that it will download the file then the Save Report setting is also set to Yes so that the user will have the option to Open the file.

This is how we want it.

But, for some reason. Google chrome downloads the file without the .xht or .xls extension. It saves the file to the download directory as WFServlet(n) without an extension so that when we open the file we have to associate the darned thing to Excel.

This doesn't happen in either IE or Firefox. Both browsers honor the extension that Webfocus assigns to it so we can just open the file after it is downloaded and it opens in Excel.

I want to know if you have the same issue in your WF 7.7 installation. If you don't, I'd like to know why that is so we can fix our set-up.

I perused the mime headers of the WFServlet file produced on an output format EXL2K and I realized that there is no specified content-disposition on the header. This may be why Chrome doesn't honor the extension. But, I don't know how to fix it.

Regards,
Anatess

Set redirection as above also add the following at the beginning of your fex, in a profile or _site_profile :

SET WEBARCHIVE = OFF

and let us know of the result. Me I had to add the above to make GC download properly Excel files.

Anatess,

Your reasoning is flawed in that when you set your PCHOLD format to XLSX or XLS that the intended out put is .xht. Its not. Its supposed to be excel, IBI just uses a web format because its not saving to the server. That's why you are changing the other excel output types. So it does save it to an .xlsx/.xls format before sending the file over. You're focusing on the wrong issue. Chrome will never add the .xht extension. If you for whatever reason (and I don't know why you would want it) want the .xht extension added onto the end of the file then you are looking for help in the wrong forum. That is a Chrome issue and one that was done by design. It was changed in version 40 something of chrome(42 I think). If you won't head our advice then I would suggest contacting google and having them explain why they remove .xht file extensions from the file.

By the way, I've been through this in my own system, I know exactly what the problem is and I have resolved it exactly as I described. Yes I found this issue in 7.7.03 and you will find it in every version of webFOCUS because its not a webFOCUS issue. I guess your other solution would be to downgrade Chrome.

We have the same problem. If we make the change, it affects how IE works, so for the moment, since IE is the only officially supported web browser, we're not fixing the problem for Chrome.

Still no solution for an environment with BOTH Chrome and IE?

P.S. Why was this closed (most likely by IBI)?