Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] HTML Page refresh

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] HTML Page refresh
 Login/Join
 
SBanks
Member
posted
Can anyone assist with the following issue? I have an HTML page with several reports and charts. I am using the script below to set each of the reports and charts to auto refresh.

The script below works well for the TABLE FILES but for the GRAPH FILES it does not work. The graph does not build. We have narrowed the issue down to two lines of code: the ON GRAPH AUTOFIT and the ON GRAPH PCHOLD FORMAT JSCHART. With both of these lines included the refresh script does not work. Taking either of the two lines out, the refresh works. Any way I can remedy this without pulling out one of the two lines of code? I am using App Studio 8202. Thanks.

 
GRAPH FILE CAR
SUM DEALER_COST
RETAIL_COST
SALES
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET AUTOFIT ON
END


-HTMLFORM BEGIN
  < !DOCTYPE html>
  <body onload="setTimeout['document.f1.submit[);',2000);">
  <form name=f1 action="/ibi_apps/run.bip" method="get" target="_self">
  <input type="hidden" name="BIP_REQUEST_TYPE" value="BIP_RUN">
  <input type="hidden" name="BIP_folder"       value="IBFS:/WFC/Repository/IT_Development_Joe_B/">
  <input type="hidden" name="BIP_item"         value="AUTO_REFRESH.fex">
  <input type="hidden" name="Rand"             value="!IBI.AMP.Rand;">
  !IBI.FIL.REPORT01;
  </body>
  </html>
-HTMLFORM END
-RUN

This message has been edited. Last edited by: FP Mod Chuck,


8202
 
Posts: 5 | Registered: June 05, 2018Report This Post
mlhapner
Silver Member
posted Hide Post
ON GRAPH PCHOLD FORMAT JSCHART will not allow you to use the graph later on in the HTMLFORM. Instead, you want to hold the graph as the NAME in !IBI.FIL.{NAME}; .

So instead, you should have ON GRAPH HOLD AS REPORT01 FORMAT JSCHART. (really you should rename that to something like GRAPH01 or CHART01)


WebFOCUS 8.201m
Windows, All Outputs
 
Posts: 28 | Location: Indiana | Registered: June 08, 2016Report This Post
Chaudhary
Platinum Member
posted Hide Post
you can integrate this html page in BIP portal and use the portal refresh property .


WF Production :- WF:8.0.0.4, 8.1.05 App-studio/Developer Studio(8.1.x) ,
8.2.0.1M , 8.2.0.2 (App-Studio8.2.x),
InfoAssist/+, InfoDiscovery
Output format:-AHTML, PDF, Excel, HTML
Platform:-Windows 7, 8,10
 
Posts: 186 | Location: Infobuild India | Registered: August 28, 2015Report This Post
SBanks
Member
posted Hide Post
Thanks mlhapner, I changed the line of code to hold the graph using !BI.FIL name. The graph is building now, but it is no longer refreshing.

I am using the HTML page in a portal and currently using the portal refresh option. However since the maximum refresh timing is like 90 seconds, it refreshes too often for users.


GRAPH FILE CAR
SUM DEALER_COST
RETAIL_COST
SALES
-*ON GRAPH PCHOLD FORMAT JSCHART
HEADING
"CAR REFRESH TEST"
"AT &TOD"
ON GRAPH HOLD AS GRAPH01 FORMAT JSCHART
ON GRAPH SET AUTOFIT ON
END

-HTMLFORM BEGIN
  <!DOCTYPE html>
  <body onload="setTimeout('document.f1.submit();',2000);">
  <form name=f1 action="/ibi_apps/run.bip" method="get" target="_self">
  <input type="hidden" name="BIP_REQUEST_TYPE" value="BIP_RUN">
  <input type="hidden" name="BIP_folder"       value="IBFS:/WFC/Repository/IT_Development/SarahB/Reports/Supv_Dashboard/notes/">
  <input type="hidden" name="BIP_item"         value="AUTO_REFRESH.fex">
  <input type="hidden" name="Rand"             value="!IBI.AMP.Rand;">
  !IBI.FIL.GRAPH01;
  </body>
  </html>
-HTMLFORM END
-RUN


8202
 
Posts: 5 | Registered: June 05, 2018Report This Post
mlhapner
Silver Member
posted Hide Post
Why do you need to have a refresh timer?

Couldn't you just have an onchange or onafterload function on the elements in the HTML page that refreshes the graph & report?


WebFOCUS 8.201m
Windows, All Outputs
 
Posts: 28 | Location: Indiana | Registered: June 08, 2016Report This Post
SBanks
Member
posted Hide Post
I do have the onchange functionality in place. That works well for users viewing at a desk. But we will project the dashboard on a monitor so it will need to refresh itself every 5 or 10 mins.


8202
 
Posts: 5 | Registered: June 05, 2018Report This Post
Doug
Expert
posted Hide Post
Hey Sarah,

Not sure why so many people as using JavaScript (I'm not a big fan of it and know that statement will cause chaos). But, HTML CODE will do what you want (I used to be a WebMaster, actually code web pages in HTML).

So, consider this: 
-* FP HTML Page refresh.fex
-SET &ECHO = ALL ;
GRAPH FILE CAR
-*TABLE FILE CAR
SUM DEALER_COST
RETAIL_COST
SALES
HEADING
"CAR REFRESH TEST AT &TOD"
ON GRAPH HOLD AS GRAPH01 FORMAT HTMTABLE
ON GRAPH SET AUTOFIT ON
-*ON TABLE HOLD AS GRAPH01 FORMAT HTMTABLE
-*-*ON TABLE HOLD AS GRAPH01 FORMAT JSCHART
ON TABLE SET AUTOFIT ON
END
-RUN
-HTMLFORM BEGIN
<HTML>
<head>
  <title>HTML in 10 Simple Steps or Less</title>
  <meta http-equiv="refresh" content="2"> <!-- See the difference? -->
</head>
<body>
<TABLE><TR><TD>
!IBI.FIL.GRAPH01;
</TD></TR></TABLE>
</BODY>
</HTML>
-HTMLFORM END
-*-HTMLFORM BEGIN
-*  <!DOCTYPE html>
-*  <body onload="setTimeout('document.f1.submit();',2000);">
-*  <form name=f1 action="/ibi_apps/run.bip" method="get" target="_self">
-*  <input type="hidden" name="BIP_REQUEST_TYPE" value="BIP_RUN">
-*  <input type="hidden" name="BIP_folder"       value="IBFS:/WFC/Repository/KGPCo_IT/Doug/FP_HTML_Page_refresh.fex">
-*  <input type="hidden" name="BIP_item"         value="FP_HTML_Page_refresh.fex">
-*  <input type="hidden" name="Rand"             value="!IBI.AMP.Rand;">
-*  !IBI.FIL.GRAPH01;
-*  </body>
-*  </html>
-*-HTMLFORM END
-RUN
I left most of your code in there.

Enjoy, Doug
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] HTML Page refresh

Copyright © 1996-2020 Information Builders