Hi,

I am considering upgrading from OI 3.7.2 to OI 3.7.5

Can someone please point me to any documentation that would highlight the features GAINED by such an upgrade path.

Thanks,

Peter

Peter,

If you have received the annual CD that gets distributed to WORKS members, the accompanying documentation will let you know what new features are included with each upgrade.

I might be able to find the documentation if you do not have it handy.

Kevin

Hi Kevin,

] If you have received the annual CD that gets distributed to WORKS members, the accompanying documentation will let you know what new features are included with each upgrade.

Due to financial constraints a year or so back, I had to drop the WORKS subscription. I only had WORKS long enough to get to OI version 3.7.2

] I might be able to find the documentation if you do not have it handy.

Yes please.

Thanks

Peter

Peter .. then it really doesn't matter does it! Unless you are a WORKS subscriber, you can't receive updates so 3.7.2 is where you're stuck unless you become a WORKS subscriber again!!

Don Miller

C3 Inc.

Catch 22 easily resolved… here's the info on the upgrades taken from the release docs. We know it's a hard call for non-profits where to divert funds! (And remember Peter, Works now gets you a developer copy of OI32!).

The Sprezzatura Group

World Leaders in all things RevSoft

OpenInsight for Workgroups 3.7.5

(Upgrade)

Resolved Issues

OpenInsight

Changed run_inet_request to integrate JOI (run inet request)

Fixed a problem with Phone Format (PHONE_FORMAT)

Index_Lookup was modified to allow labels in the Index_Lookup window with a length of up to 80 characters.

RDKInstall. Added new dictionary field tab for deploying dictionary items.

RDKInstallModule. Correected a bug that would attempt to make a file revsoft\oi\\xxx

QBF

Fixed QBF to accept to accept sorting clauses. Sorting may be achieved by entering BY, or BY1, BY2, BY3, etc in controls in a form. BY-DSND works in a similar fashion.

Other minor changes

Licensing

Revised Runtime Engine to allow rebuilding indexes

Revised Runtime Engine to allow fixing group format errors and group calculation errors

Revise OpenInsight License, effective with version 3.75, to allow dynamic reports

New Features

Documentation

A new Stored Procedure insert named BERROR contains a listing and description of all system error messages starting with a 'B' (BERRORS)

Inet Gateway returns Fieldmarks

If you add a section titled INET_GATEWAY to Oinsight.ini, and item ReturnFM=1 then the INET_GATEWAY will pass fieldmarks through to the client rather than converting them to carriage return/linefeeds. (RUN_INET_REQUEST)

32-Bit Functionality

We've enhanced the 32-bit 'sandbox' functionality. We changed the underlying 'thunking' methodology to windows rather than flat files to accomplish inter-process communication. The result is a much more dynamic 'thunking' layer. It is possible to use 'on-the-fly' javascript or vbscript from OI, including the Eval function. The dll is an activex object. You can include it in a vb project or on a local web page and communicate with OI. We have included a small exe file that will host the dll when communication is started from OI

We have supplied a new program named check_workstation that will auto-register the DLLs and OCXs used by either version 3.7.4 or 3.7.5. Simply create a table named sysworkstation_settings in your system, and modify the program to register either rev32dlg.ocx or RevComI.dll. Call this program from the Create event of your application's entry point window.

Communication Infrastructure

We have delivered the next iteration of 32-bit integration. This version does not use an OCX, it instead uses a dll.

Created RevComI.dll, an activex dll, to manage the communications interface

Created RciStub.exe to host the dll.

Created Utility32_Set_Msg to send messages to the thunking layer from a stored procedure. Stored procedures and symbolics can send the name of a canned script, a vb or javascript function, or a single vb/javascript statement suitable for an EVAL statement. See UTILITY32_MSG_EQUATES for documentation of the message types and the parameters for each message type

Created Utility32_Get_Msg to get responses from the thunking layer

Created UTILITY32_Msg_COMMON to hold 32 bit message settings.

Modified UTILITY_RUNSCRIPT to use utility32_set_msg.

Note: RevComDlg.ocx is still used to host the file dialogs

Modified the canned vb scripts to use the revcomi.dll

Created an OpenInsight window to manage the interprocess communication (OI_COMDLG)

Long Filename Support

Added OS_LongfileWrite to create files with long names. The function creates the long file name, returns the short file name. (OS_LONGFILEWRITE)

Added parameters SPECIALFOLDER and TEMPFILE to utility file dlg. OpenInsight can now retrieve the locations f special folders and the name of a temp file. (UTILITY_FILEDLG)

Network

Added MAPNETWORKDRIVE, REMOVENETWORKDRIVE to UTILITY_NETWORK. OpenInsight can now map drives directly (UTILITY_NETWORK)

Volume Maintenance

Added a new routine named RENAME_VOLUME which will allow developers to rename the volume information in a subdirectory.(RENAME_VOLUME)

Web Services

Provided an example of using Utility32_Set_Msg to send a request to a web server, parse the returned data. This example 'screen-scrapes? a page hosted by the us postal service (ZIP_CODE_EXAMPLE)

XML

Minor fixes to inet_oi_xml. Added ability to list_tables, list_dict for a table.

Created a program to generate the XML schema for a list statement in element centric fashion (CREATE_XML_ELEMENT_SCHEMA)

Added a window that will generate an XML file and schema from a list statement (XML_PUBLISHER)

OpenInsight for Workgroups 3.7.4

(Upgrade)

Resolved Issues

OpenInsight

Enlarged Scan_Rep screen to make more usable

Fixed bug in sorted popups returning more than 10 items. Changed jujstification from L to R. Special Thanks to Don Bakke of SRP.(POPUP)

Created new command, LIST_INDEX_DETAILED, which displays all indexed files, fields, and index types (LIST_INDEX_DETAILED)

Corrected bug in V119 to correctly sort data with leading zeroes (V119.DLL)

Corrected error in Index Build and Rebuild that would treat keys with leading zeroes the same as keys without leading zeroes. Corrected same problem with indexed data values being treated the same whether or not they had leading zeroes. eg, previously 001 and 1 were treated as the same value; now they are treated as different values.

HTML Publishing

Modified HTML to correct embedded table problems, which makes generated HTML more usable. (RWD_HTMLSTRUCTCREATE)

Modified Action Method of Form tag generated by HtmlPublisher, added Default IP address of 127.0.0.1to generated HTML.(RWD_CHANGEFORMDIMS)

Modified HTML Generation to work correctly with calls to Inet_Rlist (RWD_CHANGEFORMDIMS)

New Features

32-Bit Functionality

We've added some 'sandbox' examples of 32-bit functionality. We've created a 32-bit OCX (rev32Dlg.ocx) that will allow OI developers to make use of the enhanced features in the Win32 environment. This OCX calls some windows common dialog and shell dialog functions, and provides a conduit from 32-bit functions back to OpenInsight. Most of the functionality supplied with this release is accomplished using the Windows scripting host, which calls the OCS to pass data back. We have used a very simple mechanism, WritePrivateProfileString, to pass data back to OpenInsight via OINSIGHT.INI. The filename, section and key are all configurable. You will see that most of our examples follow a pattern: An OpenInsight function shells to a vbScript that does the work, then uses the OCX to pipe data back to OpenInsight. We hope to provide a simple framework that you can use and extend as needed. We have included the source for all of these functions.

Communication Infrastructure

Created DLL_THUNK to declare GetWindowsDirectory.

Created SYSENV record CFG_UTLITY32 to soft-code default 32bit message passing section, key, application

Created UTILITY32_EQUATES

Created UTILITY32_COMMON to hold current communication settings.

Created UTILITY_SETCOMMUNICATION, UTILITY_GETCOMMUNICATION to

set and get the communication parameters (which ini file to use) for a session.

Created new functions UTILITY_GETSETTING, UTILITY_SETSETTING to get and set data where the OCX expects it.

Created UTILITY_RUNSCRIPT to run vbscript. If command is too long to pass via Utility("RUNWIN",command) then this function will write the command to inifile, run it from there. Created oiJump.vbs to support this indirect calling. The command coordinates retrieving the answer passed via PrivateProfileString.

Created UTILITY_RUN32 to run files, similar to the "START" command available from the operating system. This function UTILITY_Run32 will also use the Jump method to execute long commands. Created oiRun.vbs to support this functionality.

Created the window UTILITY_RUN32 to demonstrate use of UTILITY_RUN32 to open spreadsheets, browse the web and send e-mail.

Long Filename Support

Created and provided rev32Dlg.OCX file to enable use of Long FileName (LFN) FileOpen and FileSave dialog box, as well as get the short filename for a long filename.

Created new function named Utility_FileDialog to front-end to rev32Dlg.OCX.

Created vbScript intermediary named FileDlg.vbs (UTILITY_FILEDLG)

Created and provided window named Utility_FileDialog to show use of FileDialog function.(UTILITY_FILEDLG)

Created new function named Utility_CopyFile32, to copy long files. Created associated vbScript CopyFile.vbs (UTILITY_COPYFILE32)

Created and provided window named Utility_CopyFile32 to show use of CopyFile32 function.(UTILITY_COPYFILE32)

Created a function to OsOpen a long filename (OS_LONGFILEOPEN)

Created a function to Browse for a folder using the Win32 Shell Dialog. (UTILITY_GETFOLDER)

Created associated vbScript. OiFolder.vbs

Created and provided window named Utility_Examples to call various Utility screens.(UTILITY_EXAMPLES)

Network

Created a function named Utility_Network to obtain Username, ComputerName, DomainName (UTILITY_NETWORK)

Created Function to enumerate Printers, Set Default printer Connection (UTILITY_NETWORK)

Created and provided window named Utility_Network to show use of function.(UTILITY_NETWORK)

Created associated vbScript (oiNetWrk.vbs)

Created Function to list freespace for a specific drive or for all drives (UTILITY_FREESPACE)

Created and provided window named Utility_Freespace to show use of function.(UTILITY_FREESPACE)

Created associated vbScript Freespc.vbs

System

Created a function to read the registry (UTILITY_REGREAD) (RegRd.vbs)

Created a function to write to the registry (UTILITY_REGWRT) (RegWrt.vbs)

Created a function to delete from the registry (UTILITY_REGDEL) (RegDel.vbs)

XML

Provided source code to two new procedures, INET_OI_XML and LH_FROM_XML. INET_OI_XML will create an XML string of data and return it to a calling web request, LH_FROM_XML will update Linear Hash tables from an XML stream.

Created an Active server page that will allow IIS to route a call to OICGI running on the same server on a different port or on a different server, and will allow OI to return more than 64K in a single call. This can avoid the "Server is not available" error message without reducing IIS security features. (OIGET.ASP)

OpenInsight for Workgroups 3.7.3

(Upgrade)

Resolved Issues

Internet Gateway (OICGI.EXE, OINSIGHT.EXE)

· Quote and field-mark (0xFE) characters in a CGI request could cause incorrect results, either corrupting the request or causing the request to fail altogether; field-marks are now disallowed and quotes are correctly handled.

· Under certain error conditions, a CGI request could return the previous request's result, posing a security risk; this has been corrected in the CGI request and response routing protocol.

· CGI requests were limited in size due to architectural and specifically designed constraints; CGI request and response routing now supports up to roughly 63k.

· Error checking was added to each of the steps in the process synchronization portion of OICGI.

· As a result of the improvements in the CGI request and response routing implementation, request latency is slightly lower providing an overall increase in performance.

Presentation Server (OINSIGHT.EXE)

· Fixed a bug that caused the IDLEPROC property to fire a scheduled event prematurely.

Hi Don,

] Peter .. then it really doesn't matter does it! Unless you are a WORKS subscriber, you can't receive updates so 3.7.2 is where you're stuck unless you become a WORKS subscriber again!!

Yes, and that is why my original post said:

] I am considering upgrading from OI 3.7.2 to OI 3.7.5

…. and I needed to know the ROI, or at least some idea.

Thanks

Peter

To all my friends at Sprezzatura,

Thanks very much for supplying the information.

] Catch 22 easily resolved… here's the info on the upgrades taken from the release docs. We know it's a hard call for non-profits where to divert funds! (And remember Peter, Works now gets you a developer copy of OI32!).

Regards,

Peter

View this thread on the forum...