130 likes | 347 Views
OECGI For Dummies:. Bringing OpenInsight to the Web. Web Server Software. Apache Free Download www.apache.org Confhttpd.conf ScriptAlias /OI/ “C:/development/WebPresentation/” IIS Comes with Windows Server software Configurations vary Permissions Revelation discussion board.
E N D
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?