I am attempting to publish an RLIST report to the web using the example as outlined in chapter 17 of the OI documentation titled Internet Publishing.

I have successfully completed the following steps:

Installed the Microsoft Personal Web Server on my Win98 machine

Copied the OpenInsight OICGI program executable to the web server's scripts directory on my Win98 machine

Enabled the INET_GATEWAY service from OI

Opened http://oemcomputer/scripts/Oicgi.exe/INET_TRACE successfully in my web browser (Netscape 4.7)

Using OI Reporter, created a report in the HRIS application called TESTB

Created a form in OI with a list box containing the values TESTA/B/C, named the list box REPORT_ID per instructions

Added a SUBMIT quickevent to the OI window that calls the INET_RLIST procedure, and passes TESTB as the REPORT_ID paramater

Saved the form in OI as INET_REP

Published the form as INET_REP.htm to the REVSOFT\OINSIGHT\HTML directory

Opened the c:\REVSOFT\OINSIGHT\HTML\INET_REP.htm page in my browser

Selected TESTB from the web page list box and clicked PRINT

I get the following error message in Netscape: "Netscape is unable to find the file or directory named c:|REVSOFT/OINSIGHT/HTML/INET_RLIST. Check the name and try again".

What am I missing here?

Thanks.

Gene

Sounds as though you are launching inet_rlist incorrectly, the url should be something like

http://localhost/cgi-bin/oicgi.exe/inet_rlist

so that it is passed to OiCGI correctly.

Sprezz

World Leaders in all things RevSoft

O.K.

If I enter this URL in my browser -

http://oemcomputer/scripts/OICGI.EXE/INET_RLIST?REPORT_ID=TESTB

the rlist report runs to the browser as designed (albeit with some funny characters tagged onto the column values, but first things first). My question is, how do I get this report to run when I press the PRINT button from the web page URL that was published directly from the OI form containing the SUBMIT event? Isn't the submit event on the OI form supposed to fire off INET_RLIST and call the TESTB report as suggested by the example in the documentation…?

Again, what am I missing?

Thanks for your help.

Gene

In the source code for INET_REP look for the ACTION attribute of the FORM tag. It should contain the URL of http://oemcomputer/scripts/Oicgi.exe/INET_RLIST .

Something like this:

Regards,

Dave Pociu

The InsiTech Group

Gene,

Funny characters, eh ;). Well once we release our Java/XML ProJect, you won't see those anymore. But that's another story…

Anyway, see my answer above, but here's a bit more on how forms work.

Usually, if you do a POST ( press a button in an HTML form whose job is do do a POST), then the browser will concatenate pairs of ControlName=DataValue and append them to the content of the ACTION attribute of your HTML form.

So, assuming you have a control called REPORT_ID whose data value is REPORT1, and assumin that in the source code of your HTML there is a line that looks like

then what the server receives when you press the POST button is :

http://computername/scripts/oicgi.exe/inet_rlist?REPORT_ID=REPORT1

Which is exactly what you typed in in the first place!!!

Hope this clears up some of the mystery.

Dave Pociu

The InsiTech Group

dp@itgp.com

Thanks for the input Dave. I'll have a chance to give it a go tomorrow and see what happens.

One note, the 'funny' characters appeared in Netscape 4.7, but not in Internet Explorer 5.0… - not suprised, but sure points to the need to test these things out in multiple browsers/browser versions before deploying… !

I hope to get some time this Friday to have a more in depth conversation with you regarding your Java/XML project.

Gene

Funny - this part isn't detailed in the example given in the documentation…! :)

Thanks, I'll update the generated html and give it a whirl.

Gene

Bear in mind that INET_RList doesn't actually work - a fix has been promised since last year but it must only have been provided to Works subscribers as no mention of it has been made here in the public forum.

When your project is complete will we be able to ditch AREV and OI and forget about the long overdue jRev and just use your stuff? If so how did you get the file access working?

What are the funny characters? The HTML output generated by INET_RLIST is not 100% HTML standard and is not always rendered correctly by Netscape.

The Sprezzatura Group

[/i]World leaders in all things RevSoft[/i]

John,

No - the application we will be building is for a vertical market, and will leverage the use of tools like JRev rather than replace them. We will continue to rely heavily on AREV/OI for the linear hash filing system, as well as for certain RBASIC functions and code.

Initially, we intend to make use of the OpenInsight internet gateway service to provide OICGI services required to get web page access to the linear hash data. In the longer term and as the technology matures, I fully expect to deploy a hybrid programming approach using a mixture of OI/Java/Javascript/JRev/XML/Others to provide web pages with dynamic access to the linear hash data.

Gene

I'll regenerate the report tonight and post a follow up with the details.

One other thing, the RLIST report listed three columns, but in the web page output, the first column heading lined up fine with the data, but the second and third column headings were combined and displayed at the top of the second column of data. The third column had no column heading, but the data for that column appeared as expected.

My next task will be to pass ad hoc RLIST syntax from the web page to the INET_RLIST procedure, rather than having INET_RLIST call a predesigned report developed using the ORMAIN report builder.

Gene

John

We gave up waiting for RTI to fix various bugs in INET_RLIST and decided to write our own.

In doing so, we realised we had the perfect code base to start from, our popular S/LIST product. Sprezzatura decided to enhance S/LIST to output data in HTML format. We then placed in some additional hooks to enable S/LIST to be called from internet applications.

SWEB/LIST give you all the features and functionality you have come to appreciate in S/LIST (column specific font and colours, headings, etc.) but callable from a web browser with direct output back to the browser.

We'd love to tell you more about this product, but forum rules do prevent us from advertising.

Please contact the office for more information on how we might be able to help you be more sucessful using Revelation's Product line.

The Sprezzatura Group

World Leaders in RevSoft 3rd Party Utilities

"When your project is complete will we be able to ditch AREV and OI and forget about the long overdue jRev and just use your stuff? If so how did you get the file access working?"

Our project ( codenamed InsiTech ProJect) strives to make developing data-enabled screens in Java straight forward, and based on setting properties ( table name, column name, etc) rather than writing reams of code.

Yes, everything is 100% pure Java and will work with the Java Editor of your choice ( I'm currently using Sun's Forte because it has the latest Java 1.3 and is pure Java).

Now as far as "ditching" JRev, it is entirely your choice. You certainly can, but I wouldn't discount all the hard work that Revelation is doing in that direction. I would rather look at integrating our tool in JRev and going from there. I played around with the betas, and I believe that JRev will be a great tool to use. The nice part for you will be that you will be able to mix and match features from different environments ( let's say you develop part of a project using our controls, and another part using some custom controls you buy on the open market). But, again, you will not be tied down to JRev, if you choose not to use it.

Our tool (InsiTech ProJect) accesses the data through a web server currently and uses XML as the mode of communications between client and server. You will need OpenInsight on the back-end in order to get web access to Linear Hash, but you will design your forms in Java. Future releases will include access to Oracle/MS SQL/Access/etc the same way OI is accessed.

We are in the final beta and documentation phase with the product and hope to release it soon to the ARev/OI community.

In the mean time my advice would be to dust off the Java manuals and absorb as much of the language as possible. Even though our tool makes data access easy, you will still write your business code in Java ;)

Regards,

David Pociu

The InsiTech Group

dp@itgp.com

Oh so you're stuck with OI as your way of accessing the data? I was hoping that you had worked out a way to access linear hash directly thus eliminating the 16 bit single threaded inet_gateway bottleneck along with the worrying security issues discussed recently. Have you tried to use their jLH Server stuff?

Does your stuff need a PII 450 with 256MB of RAM too? Or will it run on the sort of kit my (mostly small retailer) customers have?

Using the jLH for direct access is the next step ( integrating it in Enterprise Java Beans). That will give you multi-threaded access to your data, although you will have to license an app-server like BEA Webserver.

As for the hardware needed, you will need the bigger machine for development, but any regular PC will be able to run the regular screens with no problem.

Dave

Oops, I meant BEA Weblogic not Webserver. ( Didn't have my coffee yet this morning)

View this thread on the forum...