Conference Update

It is NOW time to register

With the 2008 Conference less than 60 days away, now is the time to register and especially as the 'early bird registration' expires on 31st March 2008 - less than two weeks time.

If you have not already registered and plan to come along to this premier Revelation event, please contact Martyn as soon as possible.

The conference guide is now available in .PDF format and you can download a copy of our web site by simply clicking here.  Your Registration includes:

Our 2008 User's Conference will be held at the Rio All-Suite Hotel and Casino in Las Vegas, Nevada on the 13th  to the 16th May 2008.  For more conference information and the very latest news please click here.

[top]

April Special Offer - 30% off OpenInsight WORKS!

Have you have been putting off buying a copy of OpenInsight WORKS lately?  If you have, April is the month to put off that purchase no longer and to get involved with one of the easiest to use Windows application development tools around. 

From the 1st April 2008 (it's no April fool scam) right through to the 30th April 2008 we will be slashing 30% off of the cost of a 'new OpenInsight WORKS subscription' - that is the entire OpenInsight WORKS package giving you the full development suite, 12 months technical support on any documented feature, all of the upgrades that we will release during the 12 month period (including 8.1 in the summer), plus access to the busy OpenInsight WORKS discussion forum and all of the other goodies hidden away in the WORKS member's private area on www.revelation.com.

Don't be an April Fool this year!  Whether you have an ARev system that needs modernising, or you just want to benefit from an easy to use application development product that enables Windows and Web applications to be built very quickly, Contact Martyn on +44 (0) 20 8912 1000 to get your hands on your copy of OpenInsight WORKS.

[top]

Letter from the President and EOY CDs

Earlier this month the end of year (EOY) CDs were sent out to all current OpenInsight WORKS subscribers in our region.  This CD contains a library of OpenInsight upgrades and the 8.0.3 full installation files.  In addition, the CD includes sections with OpenInsight documentation, very useful white papers and a number of extras. 

If you are a WORKS subscriber and you did not receive your CD, or you wish to get onto the WORKS program, please contact Martyn.

This year, we have included both the annual EOY CD and this years ‘Letter from the President’ in the one mailing. This years letter details the advances with all Revelation Products during 2007 and Mike Ruane touches upon some of the development plans of Revelation Products during the next 12 months. These plans include, a simplification of OpenInsight's and the Universal Driver's licensing from the OpenInsight 8.1 release onwards. To review the letter please click here. 

[top]

OpenInsight Version 8.0.4

The OpenInsight version 8.0.4 is currently running through its beta stage of development and should be available for OpenInsight WORKS members to download soon.  If you will be upgrading from release 8.0.3, you will receive your authorisation code via our new automated email system on submitting your request through the WORKS upgrade area.

Enhancements and fixes included in this point release apply to the Database Manager, Basic+, Form Designer, AREv32 and RDK Deployment.

If you are a WORKS member and your fix or enhancement is not featured in this forthcoming release, and you have not yet entered it into the bug tracker or suggestion database, please submit details of your request to the database as soon as possible - please remember that it is these lists that we use to drive and influence OpenInsight's product enhancement decisions.
[top]

Technical Tip

The internet is becoming one of the most powerful tools in the world of IT and business generally.  OpenInsight's ability to exploit the technology are a key benefit to all Revelation developers.  As such, Revelation continue to invest in technologies that make life easier for everyone developing and using OpenInsight based systems.  OECGI2 has been around for a little while now and has pretty much replaced OECGI, as that replaced OICGI before that.  Over the summer we will see more enhancements to OpenInsight with the inclusion of WebOI into the 8.1 WORKS release. 

This article looks at how easy it is for developers to provide the ability for files to be uploaded into OpenInsight via a web browser using OECGI2.

There are two registry settings that control file uploads, FileMode and FilePath.  We will look at each in turn.

FileMode

There are four possible settings for FileMode:

For modes 1 and 2, OECGI2 will assign a temporary filename to the file that is physically located in the FilePath.  The name of the temporary file will be passed to OpenInsight in the request string and it will be accessible via INET_QUERYPARAMS.

OECGI2 also adds an input tag of the form <filetag>.length (in this example, myfilename.length) to pass you the size of the uploaded file.

FilePath

This is the directory where the file will be uploaded to when modes 1 and 2 are used.  This path is relative to the directory where OECGI2.EXE is located.

Here is an example of the registry settings for:

These settings will upload a file to the c:\inetpub\upload directory on the web server and they will delete the file once your INET procedure has completed.

Below is an example of an HTML page which will upload a file to OpenInsight via OECGI2.  File uploads in HTML are handled by a form tag and the input tag with the type set to file.  Please note the enctype attribute in the form element.  You will need to set this element as per the example so that your web server will upload the file correctly.

<html>
<body>
<form name="myform" action="\cgibin\
oecgi2.exe\inet_myloadproc" method="POST"
enctype="multipart/formdata">
<input name="myfilename" type="file" size="50">
</form>
</body>
</html>

The BASIC+ code for the INET stored procedure (inet_myloadproc) is shown below:

Function inet_myuploadproc(request)

// Sample code to demonstrate how to upload a file to OpenInsight
// via OECGI2

declare function inet_queryParam

// set the upload directory
uploadDir = “c:\inetpub\upload\”

// For FileMode = 1 & 2
// Get the name of the file the user uploaded to us
filename = inet_queryparam(request,”myfilename”)

// Get the name of the file stored in the directory specified in
// FilePath
uploadedFileName = inet_queryparam(request,”myfilename.filename”)

// Now copy the uploaded file to somewhere on our server so that
// we can process it
osread data from uploadDir:uploadFileName then
oswrite data on drive():”\”:filename
end

// For FileMode = 3
// The actual data file is passed to us via the request string
data = inet_queryparam(request,”myfilename”)

return “thanks for uploading you file to us”

Note 1: FileMode = 2 will delete the temporary file from the upload directory after your BASIC+ procedure completes.
Note 2: We did not create an input tag in our html page with the name of myfilename.filename. This is added to the request string by OECGI2 to pass you the temporary filename it created in the upload FilePath directory.

[top]

Latest Version Checker

*The Universal Driver is the new preferred driver for all ARev and OpenInsight based systems.  Please check the web site at http://www.revsoft.co.uk/universal_driver.htm for more details about this product and how it can benefit your system.

[top]

We are always pleased to hear from existing, expired and potentially new Revelation developers and end-users alike.  You can contact us in many ways:

Post 45 St Mary's Road Ealing London W5 5RG United Kingdom Email info@revsoft.co.uk sales@revsoft.co.uk Telephone +44 (0) 20 8912 1000 Fax +44 (0) 20 8912 1001

Click here for a map of our location

You can also find directions to our offices on our web site.

[top]