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.

New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.

What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.

During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] WebFocus - Maintain integration

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] WebFocus - Maintain integration
 Login/Join
 
Platinum Member
posted
Dear Mr. Wizard,

I would like to know how well integrated maintain is with the rest of Webfocus. Once upon a time the picture was not so rosy.

Can a Maintain procedure be called by PDF, Excel, PPT outputs as well as from an HTML report, and without the caching issue ? How would this be done ?

Can a maintain call a report procedure on close, and have it pop up in the same window ?

Are there any issues with running maintain under MRE vs. Self Service, and will that impact answers to the previous questions ?

That's all for now Smiler

This message has been edited. Last edited by: Kerry,


Regards,
Dave

http://www.daveayers.com

WebFocus/Maintain 7.6.4-8
on Win2000 and 2003 Server
 
Posts: 165 | Location: Detroit Metro | Registered: September 17, 2003Report This Post
Virtuoso
posted Hide Post
Dave

I think these question can better be answerd by your local IBI sales dep.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Master
posted Hide Post
Hi Dave
If you can set up a URL you can kick off a Maintain without a caching issue. To do this, add the line:

javascript:window.location='http://server/ibi_apps/WFServlet?IBIF_cmd=MNTCON+EX+maintain_app&IBIAPP_app=maintain_path&random='+Math.random();

This adds a random value to there is no problem. There should be NO problems calling Maintain from an MRE or self-service application.

As for kicking off the report when the Maintain exits, you could try:

IWCTrigger("WINEXIT");
window.close();
url=”http://server/ibi_apps/WFServlet?IBIF_ex=fex”
window.open(url);

but I am honestly not sure what will happen with the agent.

Mark
 
Posts: 663 | Location: New York | Registered: May 08, 2003Report This Post
Expert
posted Hide Post
quote:
but I am honestly not sure what will happen with the agent.


The URL will be returned to the browser, the agent will respect the server config, and a new call will be made to WF.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6349 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Platinum Member
posted Hide Post
quote:
If you can set up a URL you can kick off a Maintain without a caching issue.


But, that is the problem with the Excel and PDF output format - no Javascript ! How does one get around that ?

If one is working with an HTML output, then Javascript can be added, but how to work with the following ?

TYPE=DATA,
COLUMN=N1,
URL=/ibi_apps/WFServlet?(xxx=N1 IBIF_cmd='MNTCON EX mnt1' IBIS_passthru='on' IBIS_connect='on' IBIAPP_app='cloop baseapp' IBIC_server='EDASERVE'),
$

I tried adding a random number in an & var to the end of one of those kind of URL's, but realized that once the report was rendered, that number didn't change for subsequent clicks, and was useless.


Regards,
Dave

http://www.daveayers.com

WebFocus/Maintain 7.6.4-8
on Win2000 and 2003 Server
 
Posts: 165 | Location: Detroit Metro | Registered: September 17, 2003Report This Post
Master
posted Hide Post
Dave
Would it be possible to create a TimeStamp field and place it somewhere on the report? I am not sure how you are generating the PDF or EXCEL output, but what we are coming up with is adding a random timestamp field to the report at runtime. Then you can pass it as part of the Maintain request.

Mark

DEFINE FILE CAR
TIMESTAMP/D8 WITH MODEL = RDUNIF (TIMESTAMP) * 100000;
END

TABLE FILE CAR
PRINT TIMESTAMP NOPRINT
BY COUNTRY
BY CAR
BY MODEL
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=DATA,
COLUMN=N3,
URL=/ibi_apps/WFServlet?( \
model=N3 \
stamp=TIMESTAMP \
IBIF_cmd='MNTCON EX MNTIVP2' \
IBIS_passthru='on' \
IBIS_connect='on' \
IBIAPP_app='projects baseapp' \
IBIC_server='EDASERVE' \
),
$
ENDSTYLE
END
 
Posts: 663 | Location: New York | Registered: May 08, 2003Report This Post
Platinum Member
posted Hide Post
quote:
Would it be possible to create a TimeStamp field and place it somewhere on the report? I am not sure how you are generating the PDF or EXCEL output, but what we are coming up with is adding a random timestamp field to the report at runtime. Then you can pass it as part of the Maintain request.


Mark,

I tried adding a timestamp to the maintain drilldown URL in a report focexec using a DM &var. The problem was that the value is generated only once, when the report page is rendered and sent to the user. If the user clicks on the link a second time, the timestamp value doesn't change, and a cached maintain page is displayed with no changes visible to them.

I took your advice about using Javascript to create a URL that varied with each click of the same maintain link in an HTML format report, and that worked fine. (Thanks again)

But we are being asked to include maintain links in format EXCEL and PDF reports (clones of the HTML format report), where Javascript processing isn't available, and I'm afraid the caching issue will not be solvable there. That is unless you can pull a rabbit out of your hat Smiler


Regards,
Dave

http://www.daveayers.com

WebFocus/Maintain 7.6.4-8
on Win2000 and 2003 Server
 
Posts: 165 | Location: Detroit Metro | Registered: September 17, 2003Report This Post
Platinum Member
posted Hide Post
Bump


Regards,
Dave

http://www.daveayers.com

WebFocus/Maintain 7.6.4-8
on Win2000 and 2003 Server
 
Posts: 165 | Location: Detroit Metro | Registered: September 17, 2003Report This Post
Virtuoso
posted Hide Post
Dave

does "Bump" mean, "I managed to get this working" or "why is this not possible"




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Virtuoso
posted Hide Post
quote:
But we are being asked to include maintain links in format EXCEL and PDF reports (clones of the HTML format report), where Javascript processing isn't available, and I'm afraid the caching issue will not be solvable there. That is unless you can pull a rabbit out of your hat Smiler


Have the PDF's drilldown call a stub fex that returns a blank html page, whose onload calls the intended report fex, passing through the received drilldown arguments plus a random tag-along. When the blank page loads (even from cache) its onload javascript function will generate a unique call (whether a url or a Submit), so you will avoid receiving a cached report.


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Platinum Member
posted Hide Post
Frank,

'bump' means to bump up to the top, so the thread doesn't get lost in the noise of newer posts.

Jack,

Thanks, that's an interesting approach, through a bit of a 'long way around the horn'. Perhaps the only way... Smiler

Mark,

I'm hoping to hear you weigh in on how to deal with the lack of Javascript issue...


Regards,
Dave

http://www.daveayers.com

WebFocus/Maintain 7.6.4-8
on Win2000 and 2003 Server
 
Posts: 165 | Location: Detroit Metro | Registered: September 17, 2003Report This Post
Master
posted Hide Post
Dave
Jack's idea does seem like a viable solution. At one point there was a technique:

Set EXPIRE_REPORTS=1 in CGIVARS.WFS

The file is in \ibi\DevStudionn\srvnn\wfc\etc.

I am not sure what the downside to this setting is, but give it a try and let me know.

Mark
 
Posts: 663 | Location: New York | Registered: May 08, 2003Report This Post
Platinum Member
posted Hide Post
Thanks to everyone !

I won't be able to try an implement the suggestions for a bit due to other problems, but I will report back with the results when I do.


Regards,
Dave

http://www.daveayers.com

WebFocus/Maintain 7.6.4-8
on Win2000 and 2003 Server
 
Posts: 165 | Location: Detroit Metro | Registered: September 17, 2003Report 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] WebFocus - Maintain integration

Copyright © 1996-2020 Information Builders