O4W 2.0 Reference Guide

OpenInsight 10.0

O4W 2.0 Reference Guide

A Division of Revelation Technologies, Inc.

OpenInsight for Web (O4W) is a flexible and powerful web development toolkit for OpenInsight.

Don’t limit your application to the desktop! OpenInsight for Web (O4W) is a rapid application development tool that lets you generate responsive forms, reports, and dashboards. Use our GUI drag-and-drop to lay out your forms and then test in both desktop and mobile browser mode. Or use our full-function API to create the most sophisticated web pages.

The O4W Development Toolkit makes it possible for multivalue developers with limited or no HTML/XML/JavaScript experience to develop feature rich web pages. O4W is designed to work the way multivalue developers think, taking advantage of the skills and knowledge they already have. While users with more web development experience can use O4W's advanced features, all developers can create modern web applications (using JavaScript, XHTML, and AJAX) through O4W's APIs and integrated wizards.

This Reference Guide is designed to provide a detailed look into the properties of each of the O4W components:

* O4W Menu

* O4W Form

* O4W WYSIWYG

* O4W Reporter

* O4W Procedures

* O4W Dashboard

* DB Management

* OI Maintenance

* O4W Maintenance

* Deployment Tools

* O4W Commuter Module

* O4W Templates

* O4W Application Program Interface (API)

O4W uses advanced web technologies to deliver an interactive and dynamic web experience. For the best results, users and developers should use the most current versions of their web browser. As of early 2018, these versions are currently:

Chrome 64+, Firefox 58+, Edge 41+, Opera 51+, Safari 5+ (Windows), Safari 11+ (mac)

The minimal suggested versions for full functionality are:

Chrome 63, Firefox 57, Edge 40, IE 11, Opera 51+, Safari 4 (Windows), Safari 10 (mac)

Developers and users may choose to use older versions of their web browser, at the risk of reduced functionality, by changing the version of jQuery that O4W uses. Changing to jQuery 1.12 (or earlier) allows developers and users to support older browsers including:

IE 6-8, Opera 12.1x, Safari 5.1+

Developers who choose to support these older browsers should carefully test any plugins and functionality that their web sites may rely upon.

For Mobile development, the minimal recommended browsers are the stock browser on Android 4.0+ and Safari on iOS7+. For a complete list of supported mobile browsers, please see:

https://jquerymobile.com/browser-support/1.4/

Note: O4W displays a warning message on any browser that does not meet the suggested version and release requirements. The javascript to create and display this message is stored in the O4W configuration record, and this functionality will be updatable via DB Management,O4W Maintenance, Configuration Records, Browsers Tab.

Creating O4W Users

The O4W user and password

I. O4W Login

II. O4W Logout

III. O4W Start Page

O4W Menu

I. Create/Modify

II. Copy/Delete

III. Run

O4W Form

I. Create/Modify

II. O4W Form Commuter Module

III. Copy/Delete

IV. Run

O4W WYSIWYG

I. Create/Modify

II. O4W WYSIWYG Commuter Module

III. Copy/Delete

IV. Run

V. Reset Defaults

O4W Reporter

I. Create/Modify

II. O4W Reporter Commuter Module

III. Register BRW

IV. Copy/Delete

V. Copy/Delete AdHoc

VI. Run

VII. Run AdHoc

O4W Procedures

I. Create/Modify

II. Register

III. Copy/Delete

IV. Run

V. Help

O4W Dashboard

I. Create/Modify

II. Copy/Delete

III. Run

IV. How to Create a GeoChart with OpenInsight for Web

DB Management – OI Maintenance

I. Applications

II. Tables

III. Procedures

DB Management – O4W Maintenance

I. Permissions

II. Messages

III. RSS Feeds

IV. Configuration Records

V. About

DB Management – Deployment Tools

I. Deployment Management

O4W Form Commuter Module

I. The O4W Form Commuter Module

II. The O4W Form Event Model

III. The O4W Form Events

IV. OpenInsight Field Names and Web Form Input Controls

V. Example Code

VI. O4W Form: Commuter Module Events

VII. O4WCommuterUtility Section Identification

VIII. Disabling one or more tabs on a multi-tab O4W Form-wizard designed form

IX. Show or hide one or more “groups” on a O4W Form-wizard designed form

X. O4W Report: Commuter Module Events

O4W WYSIWYG Commuter Module

XI. The O4W WYSIWYG Commuter Module

XII. The O4W WYSIWYG Event Model

XIII. The O4W WYSIWYG Events

XIV. OpenInsight Field Names and Web Form Input Controls

XV. Example Code

XVI. O4W WYSIWYG: Commuter Module Events

XVII. O4WCommuterUtility Section Identification

XVIII. Disabling one or more tabs on a multi-tab O4W WYSIWYG form

XIX. Show or hide one or more “groups” on a O4W WYSIWYG form

O4W Templates

I. O4W Templates

II. O4W Tags

III. O4W Template Settings

IV. Additional Templates

V. Example

O4W Application Program Interface (API)

I. Design Flow

II. O4W Toolkit Style and Option functions

III. O4W Toolkit Display Element functions

IV. O4W Toolkit Input Control functions

V. O4W Toolkit Action functions

Click/Change Events

Client-side UI/Animation Events

Other Client-Side Control Events

Focus Events

Validation Events

Table Management Events

Miscellaneous Events

VI. O4W Toolkit Utility functions

O4W Mobile

Mobile Page Design

Mobile Application Design

O4W Mobile APIs

Mobile Device Orientation

Enhancing User Interface Elements

Grouping Elements Together

Accessibility Enhancement

Special Textbox Types

Enhanced Listboxes

Enhanced Lists

Mobile Pizza Ordering Application

Building Paginated tables

O4W Sample Stored Procedures..

I. O4W_EXAMPLE0

II. O4W_EXAMPLE1

III. O4W_EXAMPLE2

IV. O4W_EXAMPLE3

V. O4W_REVSHOW

VI. Login Screen

VII. Invoice Form

VIII. Order Entry

IX. Generic Edit Record Routine

X. Creating a subroutine to populate an O4W Listbox

XI. Creating a subroutine to populate an O4W Type ahead Listbox

Calling Forms, Reports, Dashboards and Procedures

I. Calling an O4W Form

II. Calling an O4W Report

III. Calling an O4W Dashboard

IV. Calling an O4W Procedure

Building a dynamic table for multivalue handling in an O4W Form

O4W PayPal Integration..

I. Using PayPal “Buy Now”

II. Using PayPal “Add to Cart”

III. Using PayPal “View Cart”

O4W and RSS

O4W Password Encryption

O4W Child Form

Browser Control for OpenInsight

Configuring O4W to run in debug mode

I. Setting up the registry

II. Running the engineserver in manual debug mode.

O4W Configuration

I. SYSENV Configuration

II. O4WCONFIG Configuration

III. O4W and https

The Background Processor

I. The Background Processor

II. Configuring the Background Processor

III. Invoking the Background Processor On An Ad-Hoc Basis

IV. Invoking the Background Processor Via A Queue Manager

Resetting Engines from the Browser

I. OECGI4P.PHP

Apache configuration file (http.conf)

Revelation Software, Inc

99 Kinderkamack Road, First Floor

Westwood, NJ 07675

U.S.A

Toll Free: 800-262-4747

Phone: 201-594-1422

Fax: 201-722-9815

www.revelation.com

Revelation Software Ltd.

Boundary House

Boston Road

London, W7 2QE

U.K.

Phone: +44 0 208 912 1000

Fax: +44 0 208 912 1001

www.revsoft.co.uk

BrightIdeas New Zealand

44 Cockle Bay Road

Howick

Auckland, 2014

New Zealand

Phone: +64 9 534 9134

www.revelationsoftware.asia

Revelation Software is a division of Revelation Technologies, Inc.

Part No 218-987