Enhancements & Revisions

Adagio GridView 9.3A

December 20, 2017

· GridView Views that include a “Doc Link” data element from a table will automatically support display of documents associated with the record stored with Adagio DocStore. When the field is chosen from the table, the column will display the text “View” with a hyperlink to the document. Clicking on the “View” will display the text in the Adagio document viewer. Filter for records containing links using the formula {Doc Link} <> “”. Exporting a View containing links will send a full path to the “first” PDF file to the Excel Spreadsheet.

· Adagio GridView now includes ChartView, so you can create line, bar and pie charts from your GridView data.

· It is easier to choose the correct field from tables with large numbers of fields. As well as sorting the list, you can now filter the list using the data type you are searching for, and by typing in some text likely to identify the field. On the Select the Type option on the Select Fields dialog to show fields of that type.

· Significantly more application logging is performed with log entries recorded in SDAPPLOG file.

· You can export to CSV either with or without column headings. Date fields are now formatted as dates. Command line parameters /XCSV (export with header) and /XCSVN (export without header) have been added to enable automated export of CSV tables.

· A Remove button has been added to the Filter toolbox.

· A new menu choice, File | New External, allows the creation of Views from Excel workbooks, CSV files and other non-Adagio data sources without changing the database GridView is working with. This allows central storage of common Excel lookup tables. The resulting Views are automatically “Tied” to the Folder specified.

· Added USERID() and USERNAME() functions to return the User information for someone running a View. Added $U (UserId) and $M (User name) parameters to Header/Footer codes for use when a View is printed, or sent to Excel.

· Most Recently Used lists for Views and Workspaces are now saved with the data, rather than in the registry. Longer filenames are now more likely to display properly for these menu choices.

· Column Titles can now be formatted independently of the column contents. Add Title Format and Clear Title Format have been added to the context (right mouse button) menu on the column title.

· You can now specify a Summary Filter when automatically exporting a View using /XDViews command line parameter.

· Conversion of Views has been improved. Conversion attempts to use partial field matching to identify fields are the same when the field names have changed in tables.