New features by version in Adagio GridView

Adagio GridView 9.2B 2016-05-04 (May. 4, 16)

9.2B release notes
 - Whats new in version 9.2B!

    ·    Conditional Cell Formatting is supported. Styles are applied using a regular IF() function to test the condition.

    ·    Views that are "Tied" to a specific database can now be modified so that network Views can be maintained when running on a laptop version of the data.

    ·    Tool tips have been added to display calculation dependencies, Filter and Row Format definitions.

    ·    New FUNCTIONS:

    GETPDFITEM() - Returns the full path of an ePrint saved document if it exists in the \SoftPDF Folder

    DAYOFYEAR() - Returns the Julian day number of the date

    ISOWEEKNUM() - Returns the ISO week number in the year

    WEEKNUM() - Returns the week number in the year

    ·    When a cell is hyperlinked to a PDF document, the Adagio PDF Viewer is called to display the PDF instead of the workstation default PDF Viewer.

    ·    "Enable auto trim" on the Defaults | Views tab automatically wraps a right justified field in the TRIM() function to strip leading blanks. This makes string comparisons more natural when the fields are used in formulas.

    ·    Default column widths will be more accurate. Calculated Columns, Row Formats and Sort Sequences are now sorted for selection. Field name matching when replacing one table with another has been improved. Refreshing of multiple Views in an ordered Workspace has been improved. The default Table Style to be used by Excel can be set on the Defaults | General tab.

    ·    CSV and TXT files can be loaded and parsed in GridView

    ·    Adagio Cloud ready.

And these changes were made in earlier versions:

Version 9.2A | 2014-08-29 (Aug. 29, 14)
9.2A release notes
 - Whats new in version 9.2A! Video demonstration of 9.2A

    ·    Combine or Append tables, making them appear as a single row set. Use this feature to summarize information for speedy processing or to report across different companies (requires Lanpaks). Any Tables can be combined. Fields with the same name will be automatically matched. You can manually match fields with different names.

    Create a common name and address file from Customer and Vendor tables, Append current sales records to a summary table or join 2 or more Customer or Inventory Item lists in different datasets.

    The workspace VendorCustomerCombine.gvs in the sample data provides an example of this new feature.

    ·    Export any View/Workspace to any ODBC compliant database. Click on the DB button to select the database where you want the rows delivered. The Select dialog can choose any Access database or DSN. Tables are exported in their entirety to new tables in the database.

    ·    GridView Views can now be the data source for other Views. This allows multi-pass processing of your data, or regular summarization to speed processing.

    ·    Automatically create a shortcut to launch GridView. Easily create GridView program shortcuts that open workspaces or send them to Excel using the “/XD” program parameters. This is especially useful when creating a series of GridView operations as part of an overnight automated process.

    ·    Quickly create a well formatted report. A new option allows you to have the repeating values in a printed View suppressed on all rows but the first and total row.

    ·    Workspaces and Views are now auto-saved while they are being edited so that they may be recovered in the event of a program crash.

    ·    Recently Opened View and Workspace lists are now saved by user, by company. 

Version 9.1A | 2013-04-02 (Apr. 2, 13)
9.1A release notes
Adagio GridView Academy Online Session 5 - Whats new in version 9.1A! Video demonstration of 9.1A

    Enhancements and revisions in Adagio GridView 9.1A (2013.04.02)

    New Features

       Added ability to subtotal and page break on change of sort sequence. Ctrl+B to toggle a page break on/off.

       Columns may now contain hyperlinks to any document with an associated program in Windows, such as PDFs, Word documents or JPG image files.

       Suppress the **Other** row for Top/Bottom "n" Summary Filters.

       Excel Direct now transfers hyperlinks, Print Setup and Page Setup options (ex. landscape, grid lines, centre on page, scaling and page breaks).

       New functions using Financial Reporter spec codes have been added:
    DATESTART (”Spec Code” [,”C”|”F”]). Returns the start of period date based on spec code.
    DATEEND (”Spec Code” [,”C”|”F”]). Returns the end of period date based on spec code.
    DATEIN ({Date},”Ledger Spec Code” [,”C”|”F”]). Tests for the existence of the date stored in the Date calculated.
    INCLUDEAMOUNT ({Number}, {Date}, ”Ledger Spec Code” [,”C”|”F”]). Returns value of {Number} if the date exists within the range.

       Tile In Place proportionally tiles views in a workspace. Control resizing for the entire workspace.

       Export to XML files (data only, without formatting).

       Added new command line parameters for use with XDViews:
    /XDN - Exports view without formatting and any hyperlinks.
    /XDS - Runs XDViews in 'silent' mode (no user interface displayed for GV or Excel).
    /XDO: - Exports column names using ODBC compliant fieldnames (no spaces or special characters).

       Excel Direct to Apache OpenOfficeTM Calc or LibreOffice® with all formatting retained in the resulting sheet, at sites that did not have Excel installed.

Version 9.0F | 2012-09-25 (Sep. 25, 12)
9.0F release notes
What's new in Adagio GridView 9.0F - Whats new in version 9.0F! Video demonstration of 9.0F

    New Features

       GridView can now read Excel workbooks. Use this feature instead of Named Items when you need multiple values per item (row), for example, commission by salesperson by category.

       GridView can now access any database for which a File Data Source Name (DSN) or Universal Data Link (UDL) has been defined in the data folder, allowing you to create Views and Workspaces that include data from other sources.

       GridView specifically supports databases from Island Microsystems Ltd. products such as JobTracker and CounterSales™ without defining a DSN or UDL.

       More easily find fields you are looking for using the "Sample Values" list in Field Properties (shows the first 5 unique values found in the first 50 records in the file).

       A View can now be “Locked” and will not reload its data contents when the user presses the Refresh button or F5/F9. This allows a View to be loaded with specific data from one dataset and used in a workspace for another.

       A View can now be “Tied” to a specific set of data. This allows a workspace to reference data stored in different folders, or with different extensions, for different companies.

       Calculated Columns or Filters in a Workspace add “External References” in the left hand pane, showing Views in the Workspace that share an element in common with the View you are working on. Select an element from one of the other Views to automatically insert the necessary GETLINKEDVALUE() formula.

       GridView is now smarter about whether the data file needs to be re-read in order to display the information in a different Filter. This will greatly improve the speed in some cases.

       Four new functions have been added:
    REMOVEALL(“S1”,”S2”) removes all occurrences of string S1 from String S2.
    REMOVEDUP(“S1,”S2”) removes duplicate occurrences of S1 from S2.
    COUNTSTR(“S1”,”S2”[,N]) returns the count of the occurrences of string S1 in string S2 (case sensitive if N is true).
    COLUMNCONTAINS("S1", "S2"[,N]) returns the count of the occurrences of string S1 (column name) in string S2 (S2 is case sensitive if N is true).

       Columns may now be formatted to contain hyperlinks to web URLs or email addresses.

Version 9.0E | 2012-07-03 (Jul. 3, 12)
9.0E release notes
What's new in Adagio GridView 9.0E - Whats new in version 9.0E! Video demonstration of 9.0E

       View by row displays a record in a single, dock-able panel that can be placed within a workspace. This attribute is now saved with the View and is useful for easily viewing many fields in a single record. First, Last, next and previous buttons are available to scroll through a selected list.

       Adagio Styles assigned to a master record in an Adagio module can now be automatically displayed in a GridView View. Make your GridView Views directly correspond to the Grids in the Adagio modules. The Adagio Style list is also available as a format to apply to a row for Row Formatting.

       Complex Filters are a snap to create using the New button in the Filter Toolbox. Create simple Filters to make sure the logic is correct. Then combine the Filters in the Tool Box and click new to automatically create a formula with the correct AND/OR/NOT logic. Tie the complex Filter to the underlying simple conditions so changes to them are reflected automatically in the complex Filter, or copy the logic into the complex Filter to keep its operation undisturbed by changes elsewhere.

       Summary Filters are a great new way to improve Adagio GridView performance. Summary Filters automatically process and summarize data, creating rows with only the summarized values for the numeric and date columns. Apply Filters before and after the summarization, sort and apply Row formatting to the summarized rows after the operation is complete. Summary Filters allow you to display your Top 20 Items from the detail records in SalesAnalysis without loading all the records required for the analysis.

       The new GLCALC() formula allows you to calculate any general ledger value available in the Adagio Financial Reporter for display in a View.

       New Column and View Notes allow you to document Workspace operation and values for users of complex workspaces.

       The Active User List now displays all Adagio users, the company they are working in and the module they are using. Lanpak usage is also displayed. This user list is only displayed for user SYS.

Version 9.0D | 2011-08-28 (Aug. 28, 11)

    • The new Filter Toolbox allows the creation of complex compound Filters from simple ones known to be working correctly. A context menu allows you to select “AND”, “OR” or “NOT” conditions to combine two or more Filters. “AND” conditions must be met before any OR conditions are evaluated. Access the Filter Toolbox by pressing Alt-F6 in a view to toggle it on and off.

    • Explicit control of workspace load and evaluation order has been added. Automatic exports can now suppress totals and entire Views from the created Excel workbook.

    • Many small user interface improvements, such as use of a mono-spaced font in the Filter and Calculated Column formula box improve the ease of View design. Quickly show or hide a field or calculated column from a View.

    • Export an entire Workspace with a single Shift-click.

    • “Top/Bottom n” View selection is available, with automatic calculation of “other” for the other summarized entries.

    • Automatically hide a column containing only blanks or 0.00.

    • Automatically sort and summarize a View when a specific Filter is selected by the user.

Version 9.0C | 2010-10-01 (Oct. 1, 10)

  • User security has been added. The SYS user can now restrict other users from using GridView to see confidential data. If security is turned on, users must be given explicit permission to create Views against a module’s data.

  • Data elements from tables external to the main View, can now be included in the View, without using a “Composite Table”. Composite tables are no longer required since you can select any data element from a related external table. Use this to include the Inventory Item description when creating a View from the OrderEntry Order Detail. Or include the General Ledger account description when creating a View from the posted transaction file.

  • Column Totals (or Min/Max/Averages) from another table can be included as a calculated value in the main View. Use this to calculate “Percent of Total” figures.

  • Retrieve any field or calculated result from another table by matching a data value. This is similar to invoking the VLOOKUP() function in Excel across Views.

  • Edit a column calculation directly on the View, without having to invoke the Edit | Calculated Columns function. This greatly speeds up the creation and correction of calculated columns.

  • Named Row Formats allow you to quickly display all rows that conform to a specific presentation style. When used in conjunction with Filters, Named Row Formats easily highlight records that meet certain rules.

Version 9.0B | 2010-02-22 (Feb. 22, 10)

  • New functions =RecordContains(value[,range/case]) and =ViewContains(value[,range/case]) have been added to easily locate records in the database containing particular data. RecordContains() searches all fields of the same data type for a match, while ViewContains() searches only those data elements referenced in the particular View for a match. For string values, the search can be either case sensitive or insensitive. For other data types (numbers or dates) an ending range can be supplied and all records falling within the range will be selected.

  • Security has been significantly improved. Users without permission to create or change Views will only be able to open Views contained in a specific directory specified on the command line. If the Workspace is launched from within an Adagio module, the user is not able to open any other Views or Workspaces. If the user can create or change Views, then the "/f:folder" command line parameter provides a default location to load and save Views from/to.

  • Table element names can now be sorted into alphabetical order to assist in locating specific fields.

  • GridView-RW now allows records to be added (inserted) and multiply deleted from a database.

  • Performance has been significantly improved.

  • The list of recently reported on databases is now stored by user.

Version 9.0A | 2008-11-06 (Nov. 6, 08)

  • Supports Adagio GridView-RW (a separate add-on product for GridView that allows you to write to Adagio data from GridView).

  • Excel Direct Views allow you to automate sending GridView views to Excel. For example, a batch file could be run after normal office hours to generate a view result and send it to a spreadsheet for use the next business day.

  • Select Table now shows only the dictionaries and versions matching your data, simplifying selection of the required table.

  • Existing views can be updated to use the new tables when you upgrade to new versions of Adagio modules.