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]calling a fex from a WebFOCUS html form

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED]calling a fex from a WebFOCUS html form
 Login/Join
 
pink
Silver Member
posted
Hi All,
I don't know how to call a fex file from a WebFOCUS UI. I searched it, and from what i got, tried to implement that in my case, but received an error. The code for my html form goes like this:-

<!-- Generated by Report Layout Painter -->
<HTML>
<HEAD>
<TITLE>HtmlPage
</TITLE>
<BASE href=HTTP://webfadh.target.com:80>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
function window_onload() {
UpdateData();
// TODO: Add your event handler code here
  document.getElementById("listbox15").style.display='none';
        document.getElementById("listbox16").style.display='none';
  document.getElementById("listbox17").style.display='none';
        document.getElementById("text16").style.display='none';
        document.getElementById("text15").style.display='none';
  document.getElementById("text13").style.display='none';
}
function comboSelect() {
timeframe = form1.combobox1.value;
 
 if(timeframe=="Monthly")
 {
  document.getElementById("listbox15").style.display='none';
        document.getElementById("listbox16").style.display='none';
  document.getElementById("listbox17").style.display='block';
        document.getElementById("text15").style.display='none';
        document.getElementById("text16").style.display='none';
  document.getElementById("text13").style.display='block';
 }
 else if(timeframe=="Quarterly")
 {
  document.getElementById("listbox15").style.display='none';
        document.getElementById("listbox16").style.display='block';
  document.getElementById("listbox17").style.display='none';
        document.getElementById("text16").style.display='none';
        document.getElementById("text15").style.display='block';
  document.getElementById("text13").style.display='none';
 }
 else if(timeframe=="Seasonal")
 {
  document.getElementById("listbox15").style.display='block';
        document.getElementById("listbox16").style.display='none';
  document.getElementById("listbox17").style.display='none';
        document.getElementById("text16").style.display='block';
        document.getElementById("text15").style.display='none';
  document.getElementById("text13").style.display='none';
 }
    else
 {
  document.getElementById("listbox15").style.display='none';
        document.getElementById("listbox16").style.display='none';
  document.getElementById("listbox17").style.display='none';
        document.getElementById("text16").style.display='none';
        document.getElementById("text15").style.display='none';
  document.getElementById("text13").style.display='none';
 }
}
 
 
function button5_onclick(ctrl) {
OnExecute(ctrl)
}
</SCRIPT>

<SCRIPT for=window eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>

<META content="MSHTML 6.00.3790.4426" name=GENERATOR>
</HEAD>
<BODY style="OVERFLOW: auto; BORDER-TOP-STYLE: none; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; BACKGROUND-COLOR: white; BORDER-BOTTOM-STYLE: none">
<FORM id=form1 name=vpf_rpt_form>
<INPUT id=button1 style="Z-INDEX: 35; LEFT: 280px; POSITION: absolute; TOP: 140px" tabIndex=35 type=button value=">>" name=">"> 
<INPUT id=button2 style="Z-INDEX: 36; LEFT: 280px; POSITION: absolute; TOP: 340px" tabIndex=36 type=button value=">>" name=">"> 
<INPUT id=button3 style="Z-INDEX: 36; LEFT: 280px; POSITION: absolute; TOP: 170px" tabIndex=36 type=button value=. name=.> 
<INPUT id=button4 style="Z-INDEX: 36; LEFT: 280px; POSITION: absolute; TOP: 380px" tabIndex=36 type=button value=. name=.> 
<SPAN id=text9 style="FONT-WEIGHT: bold; Z-INDEX: 26; LEFT: 370px; WIDTH: 150px; POSITION: absolute; TOP: 730px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=26>Merchandise Vendor 
</SPAN>
<SPAN id=text16 style="FONT-WEIGHT: bold; Z-INDEX: 34; LEFT: 870px; WIDTH: 150px; POSITION: absolute; TOP: 840px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=34>Season 
</SPAN>
<SPAN id=text15 style="FONT-WEIGHT: bold; Z-INDEX: 33; LEFT: 620px; WIDTH: 150px; POSITION: absolute; TOP: 840px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=33>Quarter 
</SPAN>
<SPAN id=text14 style="FONT-WEIGHT: bold; Z-INDEX: 32; LEFT: 80px; WIDTH: 150px; POSITION: absolute; TOP: 840px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=32>Year 
</SPAN>
<SPAN id=text8 style="FONT-WEIGHT: bold; Z-INDEX: 25; LEFT: 370px; WIDTH: 150px; POSITION: absolute; TOP: 610px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=25>Fabric Suppplier 
</SPAN>
<SPAN id=text13 style="FONT-WEIGHT: bold; Z-INDEX: 31; LEFT: 370px; WIDTH: 150px; POSITION: absolute; TOP: 840px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=31>Month 
</SPAN>
<SPAN id=text11 style="FONT-WEIGHT: bold; Z-INDEX: 28; LEFT: 620px; WIDTH: 150px; POSITION: absolute; TOP: 730px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=28>Time Frame 
</SPAN>
<SPAN id=text12 style="FONT-WEIGHT: bold; Z-INDEX: 29; LEFT: 620px; WIDTH: 150px; POSITION: absolute; TOP: 610px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=29>Fabric Subtype 
</SPAN>
<SPAN id=text3 style="FONT-WEIGHT: bold; Z-INDEX: 7; LEFT: 80px; WIDTH: 150px; POSITION: absolute; TOP: 270px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=7>Available Metrics 
</SPAN>
<SPAN id=text7 style="FONT-WEIGHT: bold; Z-INDEX: 24; LEFT: 90px; WIDTH: 150px; POSITION: absolute; TOP: 610px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=24>Fabrication 
</SPAN>
<SELECT id=listbox14 style="Z-INDEX: 18; LEFT: 60px; WIDTH: 200px; POSITION: absolute; TOP: 870px; HEIGHT: 60px" tabIndex=18 size=3 name=year_listbox ibiapp_app IBIMR_folder="#metricrptjsy" sourcetype="typeFex" operation="NONE" datatype="1" datafield displayfield datasource="app/slsilhou.fex">
</SELECT> 
<SELECT id=listbox17 style="Z-INDEX: 21; LEFT: 340px; WIDTH: 200px; POSITION: absolute; TOP: 870px; HEIGHT: 60px" tabIndex=21 size=3 name=month_listbox> 
<OPTION value=Feb selected displaytext="Feb">Feb
</OPTION> 
<OPTION value=Mar displaytext="Mar">Mar
</OPTION> 
<OPTION value=Apr displaytext="Apr">Apr
</OPTION> 
<OPTION value=May displaytext="May">May
</OPTION> 
<OPTION value=Jun displaytext="Jun">Jun
</OPTION> 
<OPTION value=Jul displaytext="Jul">Jul
</OPTION> 
<OPTION value=Aug displaytext="Aug">Aug
</OPTION> 
<OPTION value=Sep displaytext="Sep">Sep
</OPTION> 
<OPTION value=Oct displaytext="Oct">Oct
</OPTION> 
<OPTION value=Nov displaytext="Nov">Nov
</OPTION> 
<OPTION value=Dec displaytext="Dec">Dec
</OPTION>
</SELECT> 
<SELECT id=listbox16 style="Z-INDEX: 20; LEFT: 600px; WIDTH: 200px; POSITION: absolute; TOP: 870px; HEIGHT: 60px" tabIndex=20 size=3 name=quarter_listbox> 
<OPTION value=Feb,Mar,Apr selected displaytext="Quarter-1">Quarter-1
</OPTION> 
<OPTION value=May,Jun,Jul displaytext="Quarter-2">Quarter-2
</OPTION> 
<OPTION value=Aug,Sep,Oct displaytext="Quarter-3">Quarter-3
</OPTION> 
<OPTION value=Nov,Dec,Jan displaytext="Quarter-4">Quarter-4
</OPTION>
</SELECT> 
<SELECT id=listbox10 style="Z-INDEX: 14; LEFT: 60px; WIDTH: 200px; POSITION: absolute; TOP: 760px; HEIGHT: 60px" tabIndex=14 size=3 name=silhoute_group_listbox ibiapp_app IBIMR_folder="#metricrptjsy" sourcetype="typeFex" datatype="1" datafield displayfield datasource="app/kn43wry5.fex">
</SELECT> 
<SELECT id=listbox9 style="Z-INDEX: 13; LEFT: 340px; WIDTH: 200px; POSITION: absolute; TOP: 760px; HEIGHT: 60px" tabIndex=13 size=3 name=merchandise_vendor_listbox ibiapp_app IBIMR_folder="#metricrptjsy" sourcetype="typeFex" datatype="1" datafield displayfield datasource="app/ko3rqbue.fex">
</SELECT> 
<SELECT id=listbox7 style="Z-INDEX: 11; LEFT: 340px; WIDTH: 200px; POSITION: absolute; TOP: 640px; HEIGHT: 60px" tabIndex=11 size=3 name=fabric_supplier_listbox ibiapp_app IBIMR_folder="#metricrptjsy" sourcetype="typeFex" datatype="1" datafield displayfield datasource="app/diyn41nm.fex">
</SELECT> 
<SELECT id=listbox11 style="Z-INDEX: 15; LEFT: 600px; WIDTH: 200px; POSITION: absolute; TOP: 640px; HEIGHT: 60px" tabIndex=15 size=3 name=fabric_subtype_listbox ibiapp_app IBIMR_folder="#metricrptjsy" sourcetype="typeFex" datatype="1" datafield displayfield datasource="app/n65r2kzo.fex">
</SELECT> 
<SELECT id=listbox15 style="Z-INDEX: 19; LEFT: 860px; WIDTH: 200px; POSITION: absolute; TOP: 870px; HEIGHT: 60px" tabIndex=19 size=3 name=season_listbox> 
<OPTION value=Feb,Mar,Apr,May,Jun,Jul selected displaytext="Spring">Spring
</OPTION> 
<OPTION value=Aug,Sep,Oct,Nov,Dec,Jan displaytext="Fall">Fall
</OPTION>
</SELECT> 
<SELECT id=listbox8 style="Z-INDEX: 12; LEFT: 60px; WIDTH: 200px; POSITION: absolute; TOP: 640px; HEIGHT: 60px" tabIndex=12 size=3 name=fabrication_listbox ibiapp_app IBIMR_folder="#metricrptjsy" sourcetype="typeFex" datatype="1" datafield displayfield datasource="app/vf47qjjl.fex">
</SELECT> 
<SELECT id=listbox1 style="Z-INDEX: 1; LEFT: 60px; WIDTH: 200px; POSITION: absolute; TOP: 120px; HEIGHT: 110px" tabIndex=1 multiple size=3 name=available_grpng_listbox ibiapp_app IBIMR_folder="#metricrptjsy" sourcetype="typeFex" operation="OR" datatype="0" datafield displayfield datasource> 
<OPTION value=Value selected displaytext="Value">Value
</OPTION> 
<OPTION value=Value displaytext="Value">Value
</OPTION> 
<OPTION value=Value displaytext="Value">Value
</OPTION>
</SELECT> 
<SPAN id=text1 style="FONT-WEIGHT: bold; Z-INDEX: 5; LEFT: 80px; WIDTH: 150px; POSITION: absolute; TOP: 90px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=5>Available Grouping 
</SPAN>
<SPAN id=text4 style="FONT-WEIGHT: bold; Z-INDEX: 8; LEFT: 360px; WIDTH: 150px; POSITION: absolute; TOP: 270px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=8>Selected Metrics 
</SPAN>
<SPAN id=text10 style="FONT-WEIGHT: bold; Z-INDEX: 27; LEFT: 80px; WIDTH: 150px; POSITION: absolute; TOP: 730px; HEIGHT: 48px; BACKGROUND-COLOR: white" tabIndex=27>SL Silhouette Group 
</SPAN>
<SELECT id=listbox3 style="Z-INDEX: 3; LEFT: 60px; WIDTH: 200px; POSITION: absolute; TOP: 300px; HEIGHT: 250px" tabIndex=3 multiple size=3 name=availble_metrics_listbox operation="OR"> 
<OPTION value="LY Qty SQ yards" selected displaytext="LY Qty SQ yards">LY Qty SQ yards
</OPTION> 
<OPTION value="LY Qty LBS" displaytext="LY Qty LBS">LY Qty LBS
</OPTION> 
<OPTION value="LY consumption/Unit SQ yards" displaytext="LY consumption/Unit SQ yards">LY consumption/Unit SQ yards
</OPTION> 
<OPTION value="LY consumption/Unit LBS" displaytext="LY consumption/Unit LBS">LY consumption/Unit LBS
</OPTION> 
<OPTION value="LY Quantity" displaytext="LY Quantity">LY Quantity
</OPTION> 
<OPTION value="LY First Cost" displaytext="LY First Cost">LY First Cost
</OPTION> 
<OPTION value="LY Estimated Landed Cost" displaytext="LY Estimated Landed Cost">LY Estimated Landed Cost
</OPTION> 
<OPTION value="Plan Quantity SQ Yards" displaytext="Plan Quantity SQ Yards">Plan Quantity SQ Yards
</OPTION> 
<OPTION value="Plan Quantity LBS" displaytext="Plan Quantity LBS">Plan Quantity LBS
</OPTION> 
<OPTION value="Plan Consumption/Unit SQ Yards" displaytext="Plan Consumption/Unit SQ Yards">Plan Consumption/Unit SQ Yards
</OPTION> 
<OPTION value="Plan Consumption/Unit LBS" displaytext="Plan Consumption/Unit LBS">Plan Consumption/Unit LBS
</OPTION> 
<OPTION value="Plan Quantity" displaytext="Plan Quantity">Plan Quantity
</OPTION> 
<OPTION value="Plan First Cost" displaytext="Plan First Cost">Plan First Cost
</OPTION> 
<OPTION value="Plan Estimated Landed Cost" displaytext="Plan Estimated Landed Cost">Plan Estimated Landed Cost
</OPTION>
</SELECT> 
<SELECT id=listbox4 style="Z-INDEX: 4; LEFT: 340px; WIDTH: 200px; POSITION: absolute; TOP: 300px; HEIGHT: 260px" tabIndex=4 multiple size=3 name=slctd_metrics_listbox operation="OR">
</SELECT> 
<SELECT id=listbox2 style="Z-INDEX: 2; LEFT: 340px; WIDTH: 200px; POSITION: absolute; TOP: 120px; HEIGHT: 110px" tabIndex=2 multiple size=3 name=slctd_grpng_listbox operation="OR">
</SELECT> 
<SPAN id=text2 style="FONT-WEIGHT: bold; Z-INDEX: 6; LEFT: 370px; WIDTH: 150px; POSITION: absolute; TOP: 90px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=6>Selected Grouping 
</SPAN>
<SELECT id=combobox1 style="Z-INDEX: 30; LEFT: 600px; WIDTH: 200px; POSITION: absolute; TOP: 760px" tabIndex=30 onchange=comboSelect() name=time_frame_combobox> 
<OPTION value=Annual selected displaytext="Annual">Annual
</OPTION> 
<OPTION value=Monthly displaytext="Monthly">Monthly
</OPTION> 
<OPTION value=Quarterly displaytext="Quarterly">Quarterly
</OPTION> 
<OPTION value=Seasonal displaytext="Seasonal">Seasonal
</OPTION>
</SELECT> 
<INPUT language=javascript id=button5 style="FONT-WEIGHT: bold; Z-INDEX: 39; LEFT: 70px; WIDTH: 130px; COLOR: white; POSITION: absolute; TOP: 1000px; HEIGHT: 30px; BACKGROUND-COLOR: gray" onclick=button5_onclick(this) tabIndex=39 type=button size=13 value="Generate Report" name=button5 requests_list="1"> 
</FORM>
<INPUT id=edit1 style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; Z-INDEX: -1; LEFT: 60px; WIDTH: 310px; COLOR: gray; POSITION: absolute; TOP: 34px; HEIGHT: 36px; BACKGROUND-COLOR: transparent" tabIndex=42 size=31 value="Available Grouping and Metric Report" name=edit1> 
<xml id=ibi_requests>
<requests>
<request requestid="1" sourcetype="typeFex" targettype="1" targetname="_blank" IBIMR_folder="#testpgntp4yx" ibif_ex="app/newcar.fex" ibiapp_app="">
</request>
</requests>
</xml>
</BODY>
</HTML>


this html file named 'newhtm.htm' is present in 'HTML Files' folder. My requirement is that I have a button on this form 'button5', on clicking which, a fex file named 'newcar.fex', which is present in 'Procedures' folder should invoked and execute.

so for calling the fex file, I used this. Actually I just copied it from an example, so don't know what all attributes stand for and what is the proper syntax:-

<xml id=ibi_requests>
<requests>
<request requestid="1" sourcetype="typeFex" targettype="1" targetname="_blank" IBIMR_folder="#testpgntp4yx" ibif_ex="app/newcar.fex" ibiapp_app="">
</request>
</requests>
</xml>


The code for my fex file is:-

TABLE FILE CAR
PRINT
COUNTRY
CAR
END
-EXIT


When m clicking on the button to get the fex file executed. It is displaying error which reads- 
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: app/newcar


I searched on the forum for the relevant info, but probably am using inappropriate keywords.

So please help! Its pretty urgent.

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


Thanks and Regards,

WF 7611
XFOCUS/FOCUS DB
Win XP
EXL2K/HTML
 
Posts: 37 | Location: India | Registered: September 25, 2008Report This Post
pink
Silver Member
posted Hide Post
Hey.!
I found the solution and its working fine now. Smiler


Thanks and Regards,

WF 7611
XFOCUS/FOCUS DB
Win XP
EXL2K/HTML
 
Posts: 37 | Location: India | Registered: September 25, 2008Report This Post
bhadraavantsa
Member
posted Hide Post
quote:
ibif_ex


Could you please let us know the solution for this,

I get a message saying WEBFOCUS called with an invalid request


Windows XP/ 7.6.* -
All Formats
 
Posts: 1 | Location: WebFOCUS 7 | Registered: February 04, 2010Report This Post
<paul_doughty_ibi>
posted
http://servername/ibi_apps/WFS...=AVALUE&PARM2=AVALUE

This will all you to call 'nameoffex.fex' passing &PARM1 and &PARM2 ...

Hope that helps
Paul
 
Report 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]calling a fex from a WebFOCUS html form

Copyright © 1996-2020 Information Builders