Enhancements & Revisions


Adagio GridView 9.3B


November 7, 2018


    ·       Temporary indexes are generated for Linked Views to dramatically improve the lookup of data after the View is initially loaded. Indexes will be automatically regenerated if the data in the underlying table changes. Linked lookups into large Views are now virtually instantaneous after the initial load. Indexes are also generated for Filtered Views to allow quick switching between different Filters while the underlying data has not changed.

    ·       Added new option ‘Read without indexes’ to 'View | Customize | General' and 'Edit | Defaults'. Enable this option to read the data records in a file directly, rather than using the primary index for the file. Performance and accuracy of the retrieved records will be improved when processing files that are frequently updated (such as OEHEAD or OELINE). Reading a large database will not terminate prematurely because of an index rebalance. As would be expected, the result may not reflect additions/deletions that occurred while the records are being read. The view will be presented in the order the records are stored in the file and will likely need a specific sort sequence to present the data in primary key (or other) sequence.

    ·       Improvements to the calculation engine measurably improve the performance of views using Filters and Calculated Columns.

    ·       Enable “Export Documents” in the View Definition to have linked documents retrieved from the DocStore folder when exporting a View or Workspace containing the Doc Link field. The documents are exported to a subfolder named “ExcelDirect” under the Folder containing the View or Workspace. Package up the documents along with the Excel workbook for use where the Adagio database and DocStore documents are not available. The links work from the resulting spreadsheet. Leave the option off if you want the spreadsheet to link to the document directly in DocStore.

    ·       Added Copy File(s) to the right-click popup menu when Doc Link cell(s) are selected. Select Paste to copy the DocStore PDF documents selected into an email or Folder.

    ·       Drag-and-drop a View (.gv file) into an existing Workspace you are building, and GridView will automatically add it to the Views that make up the Workspace in the Folder. If there are no Views currently open, then the drop of the View onto the GridView desktop will set the “Save to….” Folder to the source Folder of the View to help you build a new Workspace there.

    ·       Added function UTC2LOCALSTRING to convert UTC to local time and date, with detailed control of the format of the local time and date returned. This function is useful for views reading the Application Log file (SDAPPLOG) where times are in UTC. For example:

    For ‘Local Date’ use the formula UTC2LOCALSTRING({Date},{Time},\\\"%Y%m%d\\\")

    For ‘Local Time’ use the formula UTC2LOCALSTRING({Date},{Time},\\\"%H:%M:%S:%%Milli\\\")

    ·       Ctrl+Alt+F to displays the File Properties of the selected View.

    ·       Added 'Duplicate View' to the right-click popup context menu at the top left of a view. It copies the current view to a newly created view. The keyboard shortcut Ctrl-Alt-V also invokes the copy.

    ·       On Summary Views, 'Top N', ‘** Other **’ row now correctly displays values based on what the user has selected (eg. Total, Min, Max, Average, Calculation) for each column.

    ·       Added Text and Date styles buttons to the format button bar. They format a cell, row or column to Text or Date. To have these buttons added to the bar, from the View | Customize menu, on Toolbars tab in the Toolbars list box, select Format in the list box and press the Reset button.

    ·       The Shift ExcelDirect button now exports the Excel workbook files (.XLSX) to a subfolder \ExcelDirect of the folder containing the workspace.

    ·       The Create and Edit Shortcut screen now includes the parameter value (/T, /F, /N) on field labels, to further identify the information saved on the Target path.

    ·       Added ease of use features such as pressing F2 in the 'Sort Sequences' dialog will bring up rename dialog and double-clicking an item in the ‘Format Type’ dialog selects that type and closes dialog (presses OK).

    ·       Sample Views installed by GridView to \SOFTRAK\GVWIN\Views have been updated for and work with data for current versions of the Adagio modules.

    Problems Fixed

    ·       Exporting to CSV using the /XCSV parameter was placing the CSV file in the data folder instead of the XDViews folder.

    ·       Some Total cells formatting was lost in export to Excel for views with many columns.

    ·       On very large files, GridView x64 was not reading all the records and ending prematurely without an error message.

    ·       Insert Related Data now assigns formatting to allow Doc Link hyperlinks to work.

    ·       Export Documents now exports all documents linked to field in GridView.

    ·       When using a calculated column, defining the summary type as Calculation, and applying Summarization, the summary value was not calculated correctly in some cases.


© Copyright Softrak Systems Inc. All rights reserved.