[CLOSED]Chrome browser support

January 26, 2016, 05:17 AM

Ricardo Augusto

Hi,

The business area asked me to add chrome support to a WF Report. Can anyone help me?

Thanks

 
TABLE FILE CAR
SUM SALES
BY COUNTRY
ON TABLE HOLD AS DETAILS FORMAT HTMTABLE
END


TABLE FILE GGSALES
SUM UNITS
BY ST
ACROSS PRODUCT
ON TABLE HOLD AS SALES FORMAT HTMTABLE
END


-RUN

SET HTMLFORMTYPE=XLS


-HTMLFORM BEGIN
-*<html xmlns:o="urn:schemas-microsoft-com:office:office"
-*xmlns:x="urn:schemas-microsoft-com:office:excel"
-*xmlns="http://www.w3.org/TR/REC-html40">

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>


<style>
</style>
</head>
<body>
<table style="width:100%; height:100%" >
<tr>
<TD align="center">
!IBI.FIL.SALES;
</td>
<TR>
<TD>

<TD>
</TR>
</tr>
<tr>
<td>
!IBI.FIL.DETAILS;
</td>
</tr>
</table>
</body>
</html>
-HTMLFORM END

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

January 26, 2016, 06:34 AM

Wep5622

And the problem is?

quote:
Originally posted by Ricardo Augusto:
SET HTMLFORMTYPE=XLS

The above is almost certainly not correct when your output is in fact HTML.

January 26, 2016, 06:44 AM

Ricardo Augusto

No, it´s not. That was a remediation to reach report goal.

January 26, 2016, 08:26 AM

BabakNYC

I ran your code in Chrome Version 47.0.2526.111 using WF 8105 and it opened an Excel worksheet with the two reports in it. Is that not what you wanted to see?

January 26, 2016, 08:30 AM

Ricardo Augusto

OMG. BabakNYC, I am using the Chrome Version 47.0.2526.111 and APP Studio 8105 Gen 09132015 and It didn't open the excel. It creates a WFServlet.

Are you running it from MRE or URL?

I am trying to run it as http://http://localhost:8080/i...vlet?IBIF_ex=browser

Weird!

January 26, 2016, 08:31 AM

BabakNYC

Yes you get a WFServlet and you'd have to pick an application to open it. If it's not automatically opening it in Excel, see if you can browse for it.

January 26, 2016, 08:33 AM

Ricardo Augusto

Do you mean it is configuration in Chrome? Maybe installing an extention?

I am able to open it on Excel after rename it to any_file.XLS

January 26, 2016, 08:38 AM

BabakNYC

I believe it has to do with mime.wfs. Take a look at this case in tech support and see if it's the same problem.

https://techsupport.informatio...ttrack/92662013.html

January 26, 2016, 08:43 AM

Ricardo Augusto

Thanks BabakNYC. I will check it asap.

January 26, 2016, 11:42 AM

eric.woerle

Ricardo,

This issue with Chrome first showed up a couple years ago. I believe it has to do with a change by chrome regardign how it handles the MHT extension (Which I believe is how the excel file gets sent if it is not saved on the server first). As Babak mentions, you can resolve this by adjusting the mime.wfs for the excel formats.

To adjust that file, you can do so in the Administration Console which is accessible from the client. Open up the Admin Console, expand the configuration section and go to redirection settings. You'll find what you need there.

January 26, 2016, 12:55 PM

Ricardo Augusto

Thanks Eric. I will ask to my WF admin.

January 27, 2016, 04:28 AM

Ricardo Augusto

BabakNYC, I am not able to reach that case. I am getting HTTP 404 - File not found.

Also No documents matched the query "(((@all chrome AND support) AND (@all 92662013) AND (@ProductName APPSTUDIO OR DEVSTUDIO OR "PC/FOCUS" OR "WF/JDE" OR "WF/SAP" OR WORLDMART OR "WF/PPLSOFT" OR RESGOVERNOR OR RESANALYZER OR WEBFOCUS OR WF* OR EDA* OR IWAY* OR RPTSERV OR "WF/MAINTAIN" OR CACTUS OR "WF/PMF" OR "WF/RPTCASTER" OR "WF/VISUALDIS") AND NOT #filename *.pdf) OR ((@all chrome AND support) AND (@all 92662013) AND #filename *.pdf) AND NOT ((#vpath *\archive\*) OR (@Archive ARCHIVE)))".

Eric, I changed that redirection settings at my APP Studio but nothing changes.

January 27, 2016, 07:06 AM

Rifaz

As mentioned already, goto administration console-->client settings-->redirection seetings-->.xls[change 'Save Report' from no to yes.]

You're good to go. Ask your WF admin to make the changes.

quote:
Eric, I changed that redirection settings at my APP Studio but nothing changes

You have to change in local reporting server running locally then, which should be http://localhost:8080/ibi_apps/

January 27, 2016, 08:23 AM

Ricardo Augusto

Rifaz, As I said before, I went administration console-->client settings-->redirection seetings-->.xls[change 'Save Report' from no to yes.]

Reopened App Studio, then I opened browser.fex from chrome and I still get the result as WFServlet.

February 01, 2016, 01:09 PM

<Emily McAllister>

Hello,

Here is some information from our site regarding Chrome compatibility:

A change in the way Chrome works has caused it to stop respecting the XMH format as a Web Archive. A combination of two settings is required to resolve this problem:
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
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.

Please let me know if this solves your problem.

Thanks,
Emily McAllister
Focal Point Moderator