[SOLVED] Using HTML, JavaScript, and CSS to Interface with WebFOCUS

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1827082706

July 22, 2011, 03:20 PM

Tiggy0414

[SOLVED] Using HTML, JavaScript, and CSS to Interface with WebFOCUS

With the exception of using HTML Composer, has anyone had any experience/luck creating his/her own HTML, JavaScript and CSS and interfacing it with WebFOCUS?

I have spent time creating an HTML Composer document hoping to view the HTML code and understand how this works. I am still not understanding how/if I can do this?

Any help/hints would be greatly appreciated.

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

July 22, 2011, 03:53 PM

Francis Mariani

quote:
had any experience/luck creating his/her own HTML, JavaScript and CSS and interfacing it with WebFOCUS

This is all we did before those GUI tools reared their (apparently now slightly less) ugly heads...

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

July 22, 2011, 03:56 PM

Enigma006

Previously it used to be so. But with 7.7 and above, HTML composer is lot improved. I hope 8 would be lot and lot better.

July 22, 2011, 04:06 PM

Francis Mariani

quote:
(apparently now slightly less)

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

July 22, 2011, 04:07 PM

Tiggy0414

Francis - Can you give me any tips on how to add the FOCEXEC code into the HTML? I really do not want to use the HTML Composer.

Thanks!

July 22, 2011, 04:29 PM

Francis Mariani

Minimal HTML to run a WebFOCUS report:

<html>
<head>
<title>Demo Launch WebFOCUS program</title>

</head>

<body>

<form method="post" action="/ibi_apps/WFServlet?" target="wfreport">

<input type="hidden" name="IBIF_focexec" value="bid1">

<select name="PARM1">
<option value="D1">D 1</option>
<option value="D2">D 2</option>
<option value="D3">D 3</option>
</select>

<input type="submit" value="Submit">

</form>

</body>
</html>

Any form object placed within the form will generate WebFOCUS parameters with the selected values.

I'm sure this is all in one of the manuals...

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

July 22, 2011, 04:37 PM

Tiggy0414

Thanks Francis. One would think that this would be in one of the manuals, however, I sure couldn't find anything, and I have been searching for awhile.

Thanks for the code. I will try it out.

July 24, 2011, 06:04 PM

Waz

The basics for a call to WebFOCUS are simple and standard, as Francis' example shows.

As the call to the WebFOCUS server is through a servlet, a set of parameters needs to be passed to the servlet.

The key ones are:

IBIF_ex (The fex)
IBIAPP_app (The app path, if it needs changing.)
IBIC_server (The node name of the server to connect to)
IBIC_user (The user to use to connect to the WebFOCUS server, if needed)
IBIC_pass (The users password to use to connect to the WebFOCUS server, if needed)
Any parameters needed for the fex.

There are many other parameters that can be set that controls whats happening, also if you are useing MRE, there is a set for that as well.

Waz...

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

July 25, 2011, 03:36 PM

Tiggy0414

Waz

This is great info. Can you share a couple of the MRE parameters?

We use MRE for the majority of our reporting.

Thanks!

July 25, 2011, 03:41 PM

Rafael.AZ

Tiggy, I don't use HTML composer however i'm able to achieve great looking reports and applications let me tell you how:

I do all the front end funcionality on a regular html page with my own JS and CSS, I build a backend WF fex with the printing and I just parse the results on the html page via jquery if I want to add any special effects like theming, editable grids, sortable tables or dynamic hover.

So pretty much you would be hitting a fex with ajax requests, I hope i made sense.

Regards,

July 25, 2011, 06:09 PM

Waz

Hi Dawn,

Here is a link to the documentation.

http://documentation.informati...i/source/topic15.htm

It will explain most things you will want to do.

Waz...

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

July 26, 2011, 07:40 AM

Tiggy0414

Thanks so much!!

Dawn

July 26, 2011, 07:48 AM

Tiggy0414

Hi Rafael.AZ,

Yes, your post makes sense. I am just learning JavaScript and JQUERY.

Could you give me an example of what you mean by "I just parse the results on the html page via jquery"?

Thanks!