Transcript OECGI For Dummies: Bringing OpenInsight to the Web Web Server Software • Apache – Free Download www.apache.org – Conf\httpd.conf – ScriptAlias /OI/ “C:/development/WebPresentation/” • IIS – Comes with.

OECGI For Dummies:
Bringing OpenInsight to the Web
Web Server Software
• Apache
– Free Download www.apache.org
– Conf\httpd.conf
– ScriptAlias /OI/
“C:/development/WebPresentation/”
• IIS
– Comes with Windows Server software
– Configurations vary
– Permissions
– Revelation discussion board
Web Server Software
• Key Information
– oecgi.exe, rcl4.dll, revcap32.dll, utf8.dll
– http://127.0.0.1/OI/oecgi.exe/inet_trace
OECGI Options
• Dynamic Engine
– New engine each call
– Handles multiple requests
– Recompiled code is recognized
– No debugging
• Static Engine
– Calls existing engine
– Stacks multiple requests
– Recompiled code requires an engine restart
– Debugging possible
OECGI Options
• OECGI2
– Runs as a service. Similar to Dynamic Engine
OECGI/HTML Basics
• INET_Trace (Trace)
– Verifies OECGI configuration
– Returns HTTP header information
• INET Routines
– Must start with Inet_
– Use Request variable fields
– Returns the HTML
• Static HTML
– HTML that does not change
– Use OSRead with OECGI
OECGI/HTML Basics
• Dynamic HTML
– Changing HTML depending on data requests
– Display only (no data interaction)
– FORM type
• Preparing
• Submitting
• Parsing
• Data Only
– Pure data string
• EDI, Tab delimited, XML, etc
– Can return non-HTML
Keys to Using OECGI
• Coding Tips
– Separate static data from the dynamic
– Use CSS
– Externalize HTML paths
– HTML Lists
• Build the lists from a single line of HTML
• Use placeholders to swap data
– Data Entry/Display forms
• Use placeholders to swap data
• Assign SeqKeys during the writing of the record
• Separate business logic from the INET routine
Keys to Using OECGI
• Speed Tips
– Only allow selection against indexed columns
– Use lookups/direct reads
– Loop/Remove/While for large loops
– Concatenate instead of <>
• Generalize
– Split common HTML and recombine when served
– Reuse HTML forms for similar tables
– Merge similar INET subroutines
Keys to Using OECGI
• JavaScript
– Data validation/conversion
– Simple HTML event structures
– Form validation
• AJAX
– Asynchronous JavaScript XML
– Communicates with web server during an event
– Changes the HTML without loading another
window
Beyond HTML
• OECGI is a communication layer. Use it as such
• Can transmit PDF, JPG, XML, EDI, etc.
• Can receive requests from any language
– XMLHTTP Posting process (Msxml2.XMLHTTP.3.0)
– XML SOAP
• OpenInsight can communicate with web servers
– XML SOAP
– OLE Calls to the Msxml2.XMLHTTP.3.0
– Receive XML response within OpenInsight code
Thank You
Any Questions?