Adagio GridView Change log


Adagio GridView
9.2B | 2016-05-04 (May '16)
  Go to top
Release Notes
Print This

    Views created with this version are not backward compatible with earlier versions of GridView. Views opened with this version will be automatically converted to the new format and will not be usable by earlier GridView versions.

    ·    Conditional Cell Formatting is supported. Right mouse button on the column title and select Edit Conditional Styles from the context menu or choose Format | Conditional Styles to add a conditional Style to the active column. 

    Use a regular IF() function to test the condition. Name the desired style to apply if the condition is TRUE. Name an alternative Style to apply if the condition is FALSE, or use a NULL string ("") if you want the default formatting applied. Refer to the current cell with "#" (as illustrated).

    The Preview window will show a value with the formatting applied as the condition is evaluated. The OK button will only be enabled and the Preview window displayed, if the Formula is syntactically correct.

    Conditional Styles can be Enabled/Disabled on the Dialog or View | Conditional Styles menu.

    Constraint violations are no longer supported.

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

    ·    CSV and TXT files can be loaded and parsed in GridView. A structured CSV file with a defined header row can pass data element type information to GridView to correctly format the columns. See the F1-Help text for details.

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

    ·    Allows NULLs to be sent to external database. Option setting is in View | Customize | General.

    ·    When exporting a View with ODBC compliant column names (/XDO /XDN on the command line), empty cells will send 0 if the column is numeric unless NULLS are forced in the View | Customize | General tab.

    ·    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.

    ·    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.

    ·    "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.

    ·    The sample views installed in \Softrak\GVWIN\Views have been updated to use the currently shipping 9.2A dictionaries.

    ·    Added System Info tab to Help | About.

    ·    This release is Adagio Cloud ready.

    New FUNCTIONs

    GETPDFITEM(CVCode, DocPrefix, DocType, Docnum)

    Returns the full path of an ePrint saved document if it exists in the \SoftPDF Folder. The arguments are text fields containing:

    -       The Customer or Vendor Code (6 characters)

    -       The Application Prefix that generated the PDF (AR, IN, OE or TB).

    -       The Document Type (I=Invoice, C=Credit Note)

    -       The Document number

    DAYOFYEAR([Date])

    Returns the Julian day number of the date. Uses TODAY() if no date is provided. The date provided must be later than December 31, 1979.

    ISOWEEKNUM(Date)

    Returns the ISO week number in the year – the week with the year's first Thursday in it. Monday is the first day of the week.

    Julian day number of the date. Uses TODAY() if no date is provided.

    WEEKNUM(Date[,return type])

    Returns the week number in the year, counted according to the value in [return type]. If [return type] is not specified, 1 is used. January 1 is always week 1, except when [Return type] is 21 (ISO), in which case week 1 may begin on another day of the week. [Return type] controls how weeks are counted:

      1        Week runs from Sunday to Saturday

      2        Week runs from Monday to Sunday

     11        Week runs from Monday to Sunday

     12        Week runs from Tuesday to Monday

     13        Week runs from Wednesday to Tuesday

     14        Week runs from Thursday to Wednesday

     15        Week runs from Friday to Thursday

     16        Week runs from Saturday to Friday

     17        Week runs from Sunday to Saturday

     21        Use ISO week numbering 

    All other values return Error! 

    Problems Fixed

    ·    When a View is saved Summarized, the state is now saved for the next time the View is loaded.

    ·    Syntax checking has been relaxed for Calculated Columns and Filters that return "!Error" during definition.

    ·    Trailing spaces are trimmed from the Worksheet name when a Workspace is sent to Excel.



Adagio GridView
9.2A | 2014-08-29 (Aug '14)
  Go to top
Release Notes
Print This

    ·    GridView can now Combine or Append tables, making them appear as a single row set. In the same way that GETLINKEDVALUE() adds a column to every row, Combine or Append adds additional rows to a View from another table. Combine and Append are accessible from the Edit | Definition dialog on a second tab. Any Tables can be combined. Any fields in the subsequent table that do not exist in the original Table will return blank or zero. Fields with the same name will be automatically matched. You can manually match fields with different names.

    ·    You can use this feature to 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. Referencing additional datasets consumes a lanpak for each additional dataset added. So for example, combining 3 customer master records will result in 2 additional lanpaks being consumed.

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

    ·    GridView can now export a View/Workspace to any ODBC compliant database. A new button “DB” will appear on the toolbar when View | Customize | Reset is performed. Click on the Down arrow button to select whether the Table will Add or Replace (only available with GridView-RW) an existing table with the same name (the name of the View). 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. If a Sort Sequence called “PrimaryKey” is defined in the View, then this will be made the Primary Key in the exported database. Tables are always exported in their entirety to new tables in the database. If a Table with the name of the View already exists, and “Add” is the requested operation, then (n) will be appended to the View name until a unique name is generated. (Tables cannot be updated in place.)

    ·    Workspace and View tabs have been added to the View | Customize Dialog to provide a common place for setting program defaults.

    ·    If multiple columns are selected that represent the key values into an external table, the table will be presented in the list of available links when “File | Insert Related Column…” is chosen. For example, if you select columns containing a general ledger account number and department code, you will be offered the GL Account Master file to link to.


    ·    View and Workspace most recently accessed lists under the File menu are now saved by user, by company.

    ·    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.

    ·    File | Shortcut | Create and File | Shortcut | Edit menu choices have been added to facilitate the creation of GridView program shortcuts that open workspaces or send them to Excel using the “/XD” program parameters. These choices are especially useful when creating a series of GridView operations as part of an overnight automated process.

    ·    Sorting a numeric or date column now displays the results descending first, then ascending. Text columns are sorted ascending first, then descending.

    ·    Column Titles can now include formulas to allow them to change dynamically. Formulas cannot refer to database fields but may include include dates. (So, for example, this might be used to specify date ranges).

    ·    Column hints (displayed when the cursor is over the column title), now display which other columns reference a calculation and which other columns a calculation uses.

    ·    Minimized Views cannot be restored when a workspace is loaded without “/c” on the command line. This lets confidential information be referenced in a Workspace without being viewable.

    ·    New codes have been added to allow printing View information in the header/footer of a report. These codes are:

    §  $T{format string}     Prints the Run Date formatted according to the format string at the time the View was printed.

    §  $Q{Column name}   Prints the contents of the first row of the named column. This allows you to include View values in the header/footer.

    The following table summarizes the codes that may be used in a View header/footer:

    Specification Code

    Description

    $F

    File title

    $A

    Application GVWin.exe

    $P

    Current page number

    $N

    Number of pages

    $D

    Date - can have parameters in {}

    $R

    View Title

    $L

    Filter name

    $V

    Filter value

    $Y

    Table name

    $Z

    Table description

    $T

    Run date - can have parameters in {}

    $Q

    Field Value - must have parameters in {}

    $C

    Report page number

    ·     

    ·    Subtotals are now inserted when Views are formatted as reports with a sort sequence. The fields used in the sort sequence will result in subtotals being generated when the contents of the field changes.

    ·    A new option allows you to have the repeating values in a printed View suppressed on all rows but the first and total row.  The workspace CustomersAndTransactions.gvs in the sample data demonstrates this new feature and the new Header and Footer codes available in this release.

    ·    Filters can use the ROW() function to test the number of records that have been selected.

    ·    GridView Views can now be the data source for other Views, in the same way an Excel workbook can act as a data source. This allows multi-pass processing of your data, or regular summarization to speed processing.

    ·    Constraint violation checking has been enabled. Constraints are specified in calculated columns, after the calculated expression by appending a semicolon and the Constraint expression. “#” refers to the preceding formula. For example, if the calculated column contains:

          {Balance Outstanding};# < {Credit Limit}

    and the {Balance Outstanding} is greater than the {Credit Limit}, then the Cell will be formatted according to the “Constraint Violation” Style (under Format | Styles). This allows you to format a single cell in the View (rather than the whole row). However, there are limitations:

    §  Only a single Constraint Violation Style is available.

    §  The Constraint Violation Style is not stored with the View, but rather on the Workstation, so it must always be the same Style in different Views.

    §  “Calculate after refresh” must be selected on the calculated column.

    ·    Added command line parameter “/O” to allow generation of a sample COM script for external processing. If “/O” is specified on the command line, then right mouse clicking on a Filter name in the Edit Filter dialog results in a context menu that allows generation of a COM scripting example. The file \Softrak\GVWin\GV_ComDoc.zip is installed with GridView with examples of using the COM functionality in GridView.

    ·    Added command line parameter “/XM [A | M | R]:<DSN Name>” to allow automatic export of a workspace or view to <DSN Name>. Options are A - Add to database, M - Modify existing table, R - Replace existing table.

    ·    No Page Break” option added to Report Format Filters

    ·    Custom colors can be selected for Styles and Formats

    ·    The Filter Toolbox (Alt-F6) buttons have been rearranged for ease of access and are enabled/disabled depending on what Filters have been selected.

    ·    The Defaults Dialog (F2) has been expanded to allow specification of all default values and to make clear which defaults apply to a Workspace and which to a View.

    ·    You can now choose a Summary Filter in a Linked View.

    ·    Compatible with Adagio Console and respects requests to shut down.

    ·    Includes 64-bit version.

    New FUNCTIONs

    SYSDATE()

    ·    returns the system date/time, not influenced by the Run Date.

    FYEAR(date)

    ·    Returns the Fiscal Year for a given date

    FPD(date)

    ·    Returns the period as a string (e.g. “ 2”) in which a date falls

    FPERIOD(date)

    ·    Returns FYEAR & FPD (“2013- 2”) in which a date falls. This is useful when working with transactions in Ledger, or trying to create fiscal calendar summaries.

    ISERROR(x)

    ·    Returns TRUE if the result of "x" is an error, otherwise FALSE.

    ISNUMBER(x)

    ·    Returns TRUE if the result of "x" is an number, otherwise FALSE.

    ISSTRING(x)

    ·    Returns TRUE if the result of "x" is a string, otherwise FALSE.

    FOLDER()

    ·    Returns the path to the data space.

    FILEEXTENSION()

    ·    Returns the extension of the data in the View.

    QUERYDATE("Run date?")

    ·    Sets the run date for the Workspace. (The prompt must be exactly “Run date?”.)

    ROW(optional range)

    ·    Returns the index of the current row or the first row if a range is specified.

    COL(optional range)

    ·    Returns the index (base 0) of the column of the formula.

    COLUMN("title")

    ·    Returns the column number of the column with the specified title. Use this in RANGEREF() calls to keep them running properly when columns get moved around.

    CELLREF(Column,Row)

    ·    Returns the contents of a Cell. Column zero based, Row is 1 base

    ·    Example: CELLREF(2,ROW()) will return the value from the current Row and the “third” column, more useful when Calculate after refresh is checked.

    RANGEREF(c0, r0, c1, r1)

    ·    Returns a reference to a range of cells from column0, row0 to column1, row1. This would be used as an argument to the SUM() function to total a range of cells to another cell.

    APPLYMASK(mask, string)

    ·    Applies a mask to a string (like Crystal Reports for Adagio). Masks use lowercase “l” as a placeholder with all other characters being insertion characters. “<” and “>” may delimit the string and will not be inserted if they are at the beginning / end of the mask respectively. Mask may be a literal string or the contents of a database field or formula.

    ·    APPLYMASK() is useful to format phone numbers or item numbers:

    ·    Example

    ·    Result

    ·    APPLYMASK("(lll) lll-llll",{Phone})

    ·    Formats a 10 digit phone number

    ·    APPLYMASK("lll.lll-lllllllll",{Item #} )

    ·    Formats an item number

    ·    APPLYMASK(
       GETLINKEDVALUE(
          "GVICGlobal","ICGLOBAL",
          "Item Format",0),
       {Item #})

    ·    Formats an item number according to the formatting information stored in the database.

    ·     

    TABLEFIND(text, CaseFlag, [ReturnItem,] "View", "Column" [, "Column2…"])

    ·    This new function allows you to lookup a value from another table with an arbitrary number of rows. The sample workspace TABLEFIND.gvs uses the TABLEFIND() function to locate all transactions in the GL where the staff member’s name is in the description. The parameters are:

    ·     

    ·    Argument

    ·    Usage

    ·    Text

    ·    The field you want to search

    ·    CaseFlag

    ·    An integer 1 for case sensitive search, otherwise 0.

    ·    ReturnItem

    ·    A number in this position causes the function to return the value that matched, rather than its index position. If this parameter is not specified, then the index of the item is returned.

    ·    "View"

    ·    A text string containing the name of the View to search (NB: Do not include the .GV extension)

    ·    "Column"

    ·    A text string with the name of the column containing the values to look for. You can specify an arbitrary number of columns

    ·     

    ·    Returns

    ·    0 if the string is not found, otherwise an integer value of the row the element was located in. If more than one column is specified, then the value returned is the column index times number of rows + row number

    ·    For example:

    ·    View Table

    ·    TABLEFIND text

    Bob

    Mary

    Robin

    James

    Dave

    Phil

    Fred

    Robert

    Larry

    Bob

    Dick

    Martha

    ·   

    Text

    Returns

    Bob sent the message

    1

    Garry's offer

    0

    Elliot didn't like it

    0

    Robert has yet to see it

    10

    Larry has it complete

    5

    Mary was away

    7

    ·   

    MATCH(value, array, [Type])

    ·    Used to lookup values in a table where the values being inspected are approximate. For example, you need to find the commission payable on a dollar value of sales, and the commission levels "step" between discrete values.

    ·    Value - The value that you want to match in Array. For example, when you look up a book in the library, you are using the name of the book or author as the lookup value, but the “location” is the value you want.

    ·    The Value argument can be a value (number, text, or logical value) or a cell reference to a number, text, or logical value.

    ·    Array - The range of cells being searched.

    ·    Type - Optional. Number -1, 0, or 1. The Type argument specifies how the Value is matched with values in Array. The default for this argument is 1.

    ·    Returns is dependent on the type specified.

    ·    1 or omitted - Returns the largest value that is less than or equal to Value. The values in the Array argument must be placed in ascending order, for example: ...-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE

    ·    0 – Returns the first value that is exactly equal to Value. The values in the Array argument can be in any order.

    ·    -1 – Returns the smallest value that is greater than or equal to Value. The values in the Array argument must be placed in descending order, for example: TRUE, FALSE, Z-A, ...2, 1, 0, -1, -2, ..., and so on.

    FILTERNAME([type])

    ·    Takes an optional numeric parameter for use with Summary Filters

    §  FILTERNAME(1) returns the name of the detail record Filter

    §  FILTERNAME(2) returns the name of the Summary Filter

    Problems Fixed

    ·    Row formatting works more reliably in Summary Filters

    ·    Column formats are more reliably saved.

    ·    Calculated columns cannot be deleted while they are used in other calculations, Filters, Row Formats or Sort Sequences. Column hints (displayed when the cursor is over the column title), now display which other columns reference a calculation and which other columns a calculation uses to assist in determining where a calculation is used.

    ·    Excel workbooks referenced in a View were not released until GridView was closed. They are now released when all Views are closed.

    ·    Tiling Windows now properly positions Views when a toolbar is docked at the side of the desktop

    ·    ExcelDirect now always names the target sheet.

    ·    ExcelDirect now correctly formats columns containing percent values.

    ·    ExcelDirect now formats columns containing character data as text columns to preserve the presentation of gl account and phone numbers (for example).

    ·    Error messages are clearer when a View into a composite table fails to open due to missing secondary files.

    ·    The “Display total” option is now suppressed when a column is formatted as a percent

    ·    You can now press Escape to cancel the initial load of a View when “Refresh on open” is enabled.

    ·    Summary Filters would revert to the default column for Top/Bottom N selection if the Filter was edited.

    ·    GridView now remembers the Folder most recently used when a View is saved.

    ·    Row formatting is now applied even if the View load is cancelled by pressing Escape.

    ·    If AutoRefresh or Refresh on Open was enabled for a View using one of the QUERYxxx() functions, the user would be prompted for values twice.

    ·    Workspace window positions are now saved for Filter Toolbox, Row View, and User Notes.

    ·    Clicking the “Most recently accessed” list on the Login Dialog no longer results in an error when there are no entries in the list.



Adagio GridView
9.1A | 2013-04-02 (Apr '13)
  Go to top
Release Notes
Print This

    Enhancements and revisions in Adagio GridView 9.1A (2013.04.02)

    New Features

       Added ability to show a subtotal and page break on change of the first level sort sequence for Filters with a Sort Sequence. Click the new 'Format Report' option on the Filters dialog when a Sort Sequence has been applied. The page break is indicated by a red line on the row number. 'Set Page Break' and 'Clear Page Break' have been added to right mouse context menu.

       When on any cell in a row, use CTRL+B to toggle a page break on or off. The page break is indicated by a red line on the row number.

       Added the option 'Suppress Other' to Summary Filters when using Top/Bottom "n" so that the **Other** row is not displayed.

       Columns may now be formatted to contain hyperlinks to any document with an associated program in Windows, such as PDFs, Word documents or JPG image files (9.0F added hyperlinks but only to web URLs or email addresses). Use 'Make Hyperlink / Remove Hyperlink' from the column context menu and format the column as text. The cell must contain a filename with full path. Backslash characters must be replaced with forward slashes. For example, 'C:/SOFTRAK/DATA/ICBKHUNI001.jpg' to display the image associated with the 'Women's Via Montega hybrid' item in the Inventory sample data. Note that the Image File field on the Image tab in the item cannot be used directly as the path has backslashes. Therefore a formula must be used: STRCAT("C:/SOFTRAK/DATA/", "IC", trim({Item #}), ".jpg"). Click in the cell and the PDF is opened with default PDF viewer.

       Added function FULLFILENAME for use with hyperlinks. Use instead of STRCAT to form the path when a “\” is required. For example: FULLFILENAME("x:\Softrak\Data\SoftPDF\", {Cust #}, "_OE_I____", TRIM ({Doc #}",".PDF").

       Excel Direct now transfers hyperlinks to the Excel sheet.

       Added function FILEEXISTS(S). Use to test for the existence of a file. This is useful when used with hyperlinks to document files. Note: backslashes in the path must be replaced with forward slashes.

       Excel Direct now sends Page Scaling and Page Breaks to the sheet and handles $D in Header/Footer.

       Additional Print Setup and Page Setup options (ex. landscape, grid lines, centre on page) in the view are now sent to the Excel sheet by Excel Direct.

       In the File Properties dialog (right-click top left cell), wildcard characters (??? or +++) in the Name are replaced with the actual characters for single files. For example "GLPST" is now shown instead of "GL???" for the G/L Posted Transactions file.

       Added function DATESTART (”Spec Code” [,”C”|”F”]). It returns the start of period date based on the Financial Reporter spec code and the session date used to log into GridView, for either the Calendar or Fiscal year.

       Added function DATEEND (”Spec Code” [,”C”|”F”]). It returns the end of period date based on the Financial Reporter spec code and the session date used to log into GridView.

       Added function DATEIN ({Date},”Ledger Spec Code” [,”C”|”F”]). Used to test for the existence of the date stored in the Date calculated column within the range defined by the STARTDATE and ENDDATE calculated columns. Returns 1 if the date exists within the range. Alternate use of function is DATEIN ({Date}, {Start Date}, {End Date}). Returns 1 if Date falls in the specified date range.

       Added function INCLUDEAMOUNT ({Number}, {Date}, ”Ledger Spec Code” [,”C”|”F”]). Used to test for the existence of the date stored in the Date calculated column within the range defined which is based on the session date. Returns the value of {Number} if the date exists within the range otherwise 0. Alternate use of function is INCLUDEAMOUNT ({Number}, {Date}, {Start Date}, {End Date}). Returns {Number} if the date falls in the specified range, 0 otherwise.

       Added 'Tile In Place' to the Window menu. It proportionally tiles views in a workspace as long as they are close to what you want and are not overlapped. This is useful when opening a workspace originally saved on a machine with a different size monitor. The shortcut for 'Tile In Place' is Ctrl-T (which in previous versions was used for 'Tile Horizontal').

       Added control resizing for the entire workspace. Click the Ctrl button and size the GridView window. The views in the workspace will be sized proportionally. If you press ESCAPE before releasing the mouse button the change will be discarded.

       Added File | Export to | XML Data Only... (i.e. without formatting of any sort).

       Added new command line parameter 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:<workspace> - Exports column names using ODBC compliant fieldnames (no spaces or special characters).

       The column title now respects the Horizontal alignment setting (left, center, right) in Add Formatting, Align tab. In previous versions only the data in the column respected the setting.

       Added option 'Lock Toolbars" to View | Customize | Toolbars. Prevents the toolbar from being moved or modified.

       Help | Active Users now shows the date and time users logged into Adagio if you are logged in as SYS (and not running in RW mode, if GridView-RW is installed). You can sort the grid by any column.

       The Gather Files for Support function now includes the ADSPROF.xxx file and external files (xls?, dbf, dsn, udl) if used. It now retains the original date and time of the files.

       Added "Registered to: <Company Name>" to the status line.

       New splash screen with an updated look.

       In earlier releases of Adagio we added the ability for Excel Direct to create a CSV file for use by other spreadsheet applications, such as Apache OpenOfficeTM Calc, at sites that did not have Excel installed. The spreadsheet program was launched and opened the CSV file created. Excel Direct can now use Windows "automation" (inter-process communication) to send data to other spreadsheet applications, the same way it interfaces to Excel, allowing all formatting to be retained in the resulting sheet. OpenOffice 3.3 or later and LibreOffice® 3.3 or later are supported. This interface must be manually enabled. The file SSI2XL.INI must exist in \softrak\system and must contain the section [Initialization] with an entry <computer name>-UseOpenOffice=1, where <computer name> is the name of the machine that this entry references. Refer to the Readme Help for further details.

    Problems Fixed

       There was a problem in GridView 9.0F when a view having multiple sort columns was summarized. The column being summarized was not reported properly.

       The BEGINWEEK() function reported the wrong date when the week began in the previous month, depending on the system date and session date used.

       If you clicked the 'x' in the window title bar to exit a view, then responded Cancel to the prompt asking if you want to save the data, then refreshed the view, the error message "The ADS function: <table> returned unexpected error number 2111." was displayed.

       Corrected problem where the wrong result was returned from GETFIELDVALUE when referencing an Excel sheet.

       You are now prevented from deleting a Calculated Column that is used by another Calculated Column, which caused the program to crash in previous versions.

       Field Properties now recognizes fields of Type PERCENT.

       Installs an updated version of the Adagio Data Source (ADS) that corrects the OpLocks Setting shown in station log files <computer name>.log in \Softrak\System\StationLogs. It was reported as Enabled instead of Disabled in some cases.



Adagio GridView
9.0F | 2012-09-25 (Sep '12)
  Go to top
Release Notes
Print This

    Enhancements and revisions in Adagio GridView 9.0F (2012.09.25)

    New Features

       GridView will now read Excel workbooks that are in the Adagio data folder. The new option 'Include External Tables' on the Defaults dialog must be selected. The Select Module dialog will then include all Excel workbook files (*.xlsx or .xls) found in the data folder. Choose your workbook, then choose the sheet from the Select Table dialog and continue with GridView as usual. Use this powerful feature instead of Named Items. Note: GridView must open each sheet in the workbook to get the Column Names and it may take a significant amount of time before the Select Table dialog is displayed for very large workbooks.

       GridView can now access any database for which a Data Source Name (DSN) or Universal Data Link (UDL) has been defined. This allows you to create Views and Workspaces that include data from other sources. The new option 'Include External Tables' on the Defaults dialog must be selected. The DSN file or UDL has to be in the same folder as the Adagio data, although the database it connects to does not. The DSN must be a "File DSN". Note: Softrak Technical Support cannot help define the DSN / UDL, provide any assistance locating tables / fields, or troubleshoot connections to other databases.

       GridView specifically supports databases from Island Microsystems Ltd. products such as JobTracker and CounterSaleswithout defining a DSN or UDL. This allows you to create Views and Workspaces including data from these third-party products. The new option 'Include External Tables' on the Defaults dialog must be selected and the Visual FoxPro data files (with .DBF extension) for these products must be in the same folder as the Adagio data. To access the DBF files select 'Island Micro Data' from the Select Module dialogue, then select a table from the list presented.

       You can now edit the “Link Name” on the Field Properties dialog. Edit the Link Name and then use the “Insert Related Column" capability of GridView rather than using GETLINKEDVALUE or building the formula manually. Note: The DataDictExporter will come in handy for determining the correct Link Name. Note2: This works for Island Micro data linked to Adagio data, but for Adagio to Island Micro you will need to define a View and use GETLINKEDVALUE.

       Added a Sample Values list to the Field Properties dialog. The list shows the first 5 unique values found in the first 50 records in the file. This helps you find the field you are looking for. For "typed" fields, this list is shown in addition to the Lookup Table list.

       A View can now be “Locked” by setting the 'Lock View' option on the Edit Definition dialog. A locked View will not try and reload its data contents when the user presses the Refresh button or F5/F9. This allows a View to be loaded with specific data and used in another workspace. Generally, locked Views would be used to hold data from another dataset. A locked View can be explicitly refreshed only by unlocking the View, or by executing GridView with the new “/XLU” command line parameter, which will open the locked View, refresh it and save it. Only a user with /c permission can unlock a locked View. If this option is set, "Locked" is displayed in the Tooltip for when hovering over the top left corner cell.

       A View can now be “Tied” to a specific set of data (folder / extension) by setting the 'Tied to this database' option on the Edit Definition dialog. A tied View will always load its data from that folder. This allows a workspace to reference data stored in different folders, or with different extensions, for example for different companies. Normally all views in a workspace reference the same set of data. If this option is set, "Tied to" and the path is displayed in the Tooltip for when hovering over the top left corner cell. Note: a Lanpak is consumed when a “Tied” View is refreshed and you are not working in the database to which the View is tied.

       When defining Calculated Columns or Filters in a Workspace, a new “External References” list may appear in the left hand pane. Under the External References, you will see all the Views in the Workspace that share an element in common with the View you are working on. If you want an element from one of the other Views in the Workspace, locate it in the External references section. Clicking on the element will insert the necessary GETLINKEDVALUE() formula into the Computed column or Filter you are working with.

       When building a calculated column, the list of other calculated columns available for use has been expanded to include columns that are not themselves using a calculated column. This will remove many of the ordering dependencies in complex Views.

       Added the option 'Calculate after refresh' to the Edit Calculated Column dialog. Use this option to insert the actual formula into the cell, allowing it to calculate and display results after the processing is complete. For example, this can be useful in summarized views wherein you want the displayed result of the calculation to be based on the summarized view.

       Rules regarding the calculation order of Views in a Workspace are better defined. The Workspace order set in File | Set Recalc Order defines the order in which the Views will be loaded. If a View has Refresh on Open enabled, and the Workspace order requires refreshing subsequent Views, then they will be refreshed regardless of their Refresh on Open setting. Views not in the recalculation order will only be refreshed if they have Refresh on Open enabled.

       GridView is now smarter about whether the data file needs to be re-read in order to display the information in a different Filter. Two Filters with different names, that select the same set of records, will not bother re-reading the data file, but will simply re-summarize and sort the data. This will improve performance of Views when changing between equivalent Filters. Selecting a different Filter that uses the same selection formula as the previous Filter will simply re-sort and summarize the loaded records. This will greatly improve the speed in some cases. Make use of this to present the same data sorted and summarized by Salesperson, Customer or Territory. Ctrl-F9 will force a filter to refresh.

       The 'Disable Refresh' button has been added to the Toolbar. It stops GridView from reading the underlying data file automatically. Click the refresh button, or press F5/F9 to force a read of the database. This is useful as you are building a complex View of a large file, and you want to create several calculated columns and/or Filters before reading the entire file again. Note: you need to select View | Customize from the menu, then select each of the Toolbars options and click Reset in order to make the new button visible.

       The 'View Notes' button has been added to the Toolbar. It displays or hides the Notes stored with a View. This button will be disabled if there are no Notes to display. Note: you need to select View | Customize from the menu, then select each of the Toolbars options and click Reset in order to make the new button visible.

       If a View is saved with the Notes visible, the Notes will still be visible when the View is loaded again.

       Added function REMOVEALL(“S1”,”s2”). It removes all occurrences of string S1 from String S2.

       Added function REMOVEDUP(“S1,”S2”). It removes duplicate occurrences of S1 from S2. Useful for removing multiple blanks from a string.

       Added function COUNTSTR(“S1”,”S2”[,N]). It returns the count of the occurrences of string S1 in string S2. Matching is case sensitive if “N” is TRUE. 0 is returned if the string is not found.

       Added function COLUMNCONTAINS("S1", "S2"[, N]). It returns the count of the occurrences of string S1 in string S2. Note: S1 takes "Column Name" not {Column Name}. Matching of S2 is case sensitive if “N” is TRUE. 0 is returned if the string is not found

       New menu choice 'Top/Bottom N' has been added to the context menu for Date columns, allowing you to select the newest or oldest “N” records, depending on whether the column is sorted Ascending or Descending.

       Columns may now be formatted to contain hyperlinks (to web URLs or email addresses). This allows you to click directly to e-mail or the web from a View. Make Hyperlink / Remove Hyperlink have been added to the column context menu. Place the hyperlink in <angle brackets>. Text containing an “@” will hyperlink as an e-mail address. All others will be assumed to be URLs.

       'Size To Fit' has been added to the right-mouse context menu for columns.

       You can use the code $T to place the Run date (session date) in the Header or Footer of a View printout.

       When importing calculations for Filters or Calculated Columns, identical text from other columns will be replaced with a reference to the column. This improves the import functionality significantly.

       Added a Duplicate button to the Row Formats and Calculated Columns dialogs.

       Station Logs now indicate memory information for the station or Remote Desktop Services session in these variables:

    Total Memory       - total Mbytes of physical memory
    Available Memory- free Mbytes of physical memory
    Memory Load       - percent of memory in use.

       Station Logs now show the bitness of the application and the station OS in the variable "Environment".

    Problems Fixed

       The table 'Adagio Common Files 8.1A-9.0D' was not available to select unless the option 'Show All Tables' was set.

       Format / Cells changes were lost when the view was refreshed or saved in GridView 9.0E.

       When running Adagio on a network, if you launched GridView from the Adagio menu of an Adagio module, the help files (files with .chm extension) for the module were copied to the local c:\softrak\gvwin folder. Only the help files for GridView should have been copied.

       After a Summary Filter was run and then toggled off, columns that were previously hidden in the original view reappeared in the original view.

       When a Summary Filter was run on a View having ‘Blank when zero’ enabled in its definition, the setting was not maintained in the Summary Filter view (i.e. the zeroes reappeared).



Adagio GridView
9.0E | 2012-07-03 (Jul '12)
  Go to top
Release Notes
Print This

    Enhancements and revisions in Adagio GridView 9.0E (2012.07.03)

       The performance of refreshing views with a large number of columns on larger databases across a network in 9.0E (2012.04.26) was slow (during which time the status line showed "Storing cells...").

       In 9.0E (2012.04.26), you received the error "Out of memory" or GridView froze in some cases on very large views.



Adagio GridView
9.0E | 2012-04-26 (Apr '12)
  Go to top
Release Notes
Print This

    New Features

       The View by Rows function can now be docked to a View, allowing you to easily see all the fields for a row on Views with a large number of columns. The Record View window now includes buttons to go to the first and last rows of the View. Double-clicking on a row updates the fields in the Record View.

       Adagio Styles are supported. The Auto Styles button on the Font Toolbar automatically applies the record Style from the master record set with the 'Apply Styles' menu choice in other Adagio programs. In order to see the new Auto Styles button, select View | Customize from the menu, then select Font and click the Reset button. If you want to add the automatic Styles to an existing View, enable the option, then select 'Edit Definition' and press the OK button. The Styles will appear on the View.

       Filters can be combined into a single composite Filter. This allows you to create simple Filters and then combine them into one complex Filter. From the Filter Toolbox, make your selections for each Filter (Ignore, And, And Not, Or, Or Not) then click the New button to build a complex formula in a single Filter containing the logical functions from all the selections.

       The 'Reference filters by name' option allows composite filters to change automatically if a referenced filter is changed. A filter is referenced by its name in square brackets, for example: "[Balance Over 1000]". Disable the option to separate the composite Filter from the underlying simple ones. The filter reference changes to the original filter content, for example: "{Balance Outstanding} > 1000".

       Summary Filters allow you to summarize a large number of records into only a few rows in a View, with much faster calculation and load times than summarizing a large number of detail rows. Only the rows needed are created, rather than loading and hiding the rows for all the records that are not required. To create a Summary Filter, click the New Summary button on the Named Filters dialog. You may specify a Filter to apply to records when they are read from the database, and another Filter to apply after the summary records have been created. Separate Row Format rules can be used to highlight summarized rows. Any amount or date field can be summarized (min and max only for dates). Summary Views can have Sorts, Filters and Row formatting attached which allows you to present the summary in any desired sequence with highlighting applied.

       A new formula has been added: GLCALC(“spec code”, ”Fiscal year”, ”fiscal period”, ”Account”, ”Dept”[,”Division”]). Automatically calculates the value for the requested spec code for the requested entry. This may be any of the specification codes from the Adagio Financial Reporter. Popular codes include: Balance, YTD, Annual Budget, Budget YTD and Current Period.

       For linked rows, an automatic Style is applied to the column to highlight the fact that the value links to another View. The style gives the cell the appearance of a button. Styles named “Link Style 1” to “Link Style 4” are provided by default and will be automatically assigned as linked columns are created.

       The option Single Click Link has been added to the context menu for linked rows.  When enabled, you need only click once on a linked value in the parent view to drill down and display the related values in the child view.  When disabled, a double click is required. You can also press Enter to “Fire” the link and move to the next row.

       The attribute 'Blank when zero' has been added to the View definition to have zero values display as white space. This can improve the readability of many Views.

       A 'Reset' option has been added to View | Properties to restore the original program values.

       Views can have Notes attached to the View or Workspace. Notes can be defined under the View | Notes menu choice. Notes are displayed in a detachable, docking panel when open. Notes support fonts, bold, italics, underline, and bullets. If a View has Notes there will be a check mark next to Notes in the View menu. Clicking this menu choice will open the Notes.

       Columns may have notes attached which explain the purpose of a calculation or the information that will be displayed in another View if the column is clicked. Notes are displayed if the user hovers the cursor over the column heading. Notes are added by selecting Add Note from the right mouse context menu on the column heading.

       GridView 9.0E has new a new program icon.

       Buttons have been added to some dialogs to expose options that were previously only available on the right mouse button context menu.

       A new menu choice, File | Gather files for support, is available to assist in tracking down problems in specific Workspaces. This menu choice automatically copies only the necessary files for running the specific Workspace into a single directory for support, including the necessary data dictionaries and data files. The resulting Folder can be Zipped and e-mailed to your support technician.

       Workspace Recalc order improved. Workspaces are processed sequentially in the order in the list. One View will be completely processed before the next View is loaded.

       If you attempt to Enable Filters, and no Filter has been defined, you will be taken to the Edit Filter dialog to define a new Filter.

       You can now select Min/Max values for a date column. A specific Style has been defined to highlight Date Min/Max calculations.

       Columns may now have the attribute 'Hide when summarized'. This can automatically hide a column that is not relevant when a View is displayed in summary format.

       You now have more control over date formatting. Setting decimals to 0 results in 1/1/12 instead of 01/01/12.

       Subtotal formulas are now used in tables where available so that expected values are displayed in the Excel worksheet when ExcelDirect is used.

       GridView now reports a wider range of error conditions if the ExcelDirect button fails to connect to Excel.

       A new toolbar button is available to reset Workspace Queries. All =QUERYxxx() functions take an optional third parameter that, if non-zero, results in the query being executed once per load of a Workspace or View. In previous versions if you wanted to change an answer supplied to a query function, the View/Workspace had to be reloaded. Clicking this new button will cause the next refresh to re-prompt the user for all =QUERYxxx() values. In order to see the new button, select View | Customize from the menu, then select Toolbars and click the Reset button.

       GridView now displays the 10 most recently accessed Dictionaries and Tables.

       Help | Active Users now shows Adagio users in all companies if you are logged in as SYS (and not running in RW mode). Also shows the 'Free used' license count (Adagio consumes a "free", module specific license, for the first instance of the module, rather than using a Lanpak license). The Company Name, Data Path, Extension, Computer Name and other new fields are shown in the grid, in addition to just the Adagio User Name and Application in earlier versions. The column editor is enabled on the grid and an Excel Direct button has been added.

       Duplicate button on filters allows you to quickly create a new filter with the contents of an existing filter as a starting point, rather than having to created an empty new filter and copy and paste the contents.

       Sample Views in \softrak\gvwin\views\Adagio have been updated. They now all use the GETEXTERNALDATA function added in GridView 9.0C (2010.10.01) rather than the composite dictionaries, such as 'Adagio {Composite Tables 9.0A}' (@Z90A), which are no longer maintained.

       When GridView is opened after installing an upgrade, a dialog is displayed with a link to a short video highlighting the new features. The dialog is displayed for each user until they tick 'Don't show this message again'. The video also be viewed anytime by visiting the Softrak website. Note: the dialog also appears when Adagio is installed at a new site.

       The Help | About screen has been redesigned and includes a link to a documentation page for the module that shows New Features, What's New video and manuals.

    Problems Fixed

       A View that contains a QUERYxxx function does not hold data files open while waiting for input. This could have caused data integrity errors in a multi-user environment in some cases.

       A View with 'Auto refresh' enabled that contains a QUERYxxx function will not prompt again until you complete entry for the first prompt.

       For a View with 'Refresh on open' enabled the user is prompted only once for QUERYxxx functions. Previously the prompt was needlessly repeated.

       Print Preview no longer re-prompts for QUERYxxx() functions.

       Formatting is now correctly applied to the entire column, including the total row, when the column is selected.

       Some correctly constructed formulas would be incorrectly flagged as “Invalid”.

      The field properties where shown for the wrong field when they were opened from Selected Fields within a Filter.

     



Adagio GridView
9.0D | 2011-08-28 (Aug '11)
  Go to top
Release Notes
Print This

    Enhancements and revisions in Adagio GridView 9.0D (2011.08.28)

    • Filter Toolbox now 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.

    • The /XD parameter now respects the “Allow export” option to permit explicit control of the worksheets created in a GridView exported workbook. You have explicit control whether the export file contains the Total row. This is useful if GridView is preparing a file for eventual re-import.

    • File | Set Workspace Recalc Order now allows explicit control of the order that Views in a Workspace are loaded and recalculated.

    • Tooltips have been enhanced to display calculation and field information, as well as the File driving the View when the cursor points at various elements in the View. Hovering over the Row number shows the Row Format formula. Hovering over the column name show the Column Formula.

    • =GETLINKEDRESULT() has new parameters that allow totaling of arbitrary values in a linked View, whether or not the View is sorted or summarized.

    • Shift-click on the ExcelDirect button now exports the entire Workspace in a single click. Alt-F-E-W accomplishes the same task from the keyboard.

    • A new column operator, “Display Calculation” has been added to force GridView to re-process a calculation on the displayed totals. This is useful for margin and other % calculations that are not  “associative”.

    • You now are prevented from Deleting a column used in another calculation.

    • You can now display the Top/Bottom N records in a View. A row is always displayed summing the remainder of the entries. Top N is displayed if the column is sorted in Descending order. Bottom N for Ascending sequence. “N” is user selectable.

    • When a View has been named and Summarized, you can Create a Summary View by selecting Create Summary View from the context menu available on the View Selector (top left hand intersection of Title Row and Row counter). The Summary View is one record per item from the summarized row. This allows Top/Bottom N displays of amounts calculated by summarizing detail records (for example, Top 10 invoices this month from SalesAnalysis). Filters and many other View options are not available on this special View which will be saved with the Workspace.

    • Auto Hide, a new column option is available that automatically hides a column if all rows in the View are blank for that column. This is useful in the creation of Summary Views that display only columns useful in the summary.

    • The Formula and Filter definition dialogs now use a monospace font to improve readability of the formulas.

    • GETEXTERNALDATA() now takes an optional record number to retrieve data from files that are not indexed (like the Company Profile). GETEXTERNALDATA("@L90DGLO","Current Fiscal Year",0)will return the currently defined fiscal year from the Ledger company profile.

    • GETLINKEDVALUE() returns a matching value from another View in the workspace. Its operation is similar to VLOOKUP() in Excel. Parameters control whether and exact match is required, or you wish to return the next highest or lowest value from that passed.

    • FILTERMOD() returns the text after the “+” in the View title when a Child View is linked to from another View (for example, Customer transactions from the customer master). This allows passing of some text from the Parent to the Child Filter in a Workspace.

    • GETCODEDTEXT() translates a coded database value to its full text equivalent in Formulas. Normally Coded Fields are not translated in a Formula for evaluation consistency.

    • ROW() places the value of the row for the record when it is being read from the database. Sorting the View will not change the value.

    • A new Summarize option has been added to the Filter definition which will automatically summarize the View according to the selected sequence when that Filter is processed.

    • The Filter name box has been made wider. To take advantage of the increased width, Click View \ Customize | Settings and reset the File toolbar.

    • All QUERYxxx() functions now take a third parameter that, if non-zero, causes the QUERYxxx() function to be executed once, and only once for a View. Any edit of a Calculated column or Filter will result in the QUERYxxx() function being re-invoked.

    • If a user is not able to Edit Views in the Workspace, then collapsed Views cannot be expanded. This allows confidential data required for calculations to be hidden from View.

    • New, Rename and Delete buttons have been added to the Define Sort Sequence Dialog.

    • A Named Item file can now be associated with a specific View. The file will have the name of the View with a .GVNames extension. An error will be displayed if the associated file cannot be found when the View is loaded.

    • When using GridView to automatically created Excel workbooks using the /XDW or /XDP command line parameters, you can now test for success or failure of the operation using the ERRORLEVEL value in the batch file. Successful operation sets this value to 0. Any logged error results in 1 as a return code. Improper format of the /XDW or /XDP parameters return 2 or 3 respectively.

    • File | Open Dataset allows you to quickly change the data being loaded in a View from the File menu. This was possible before using the F2 – Defaults dialog, but was not apparent to many users.

    • The Formula Verify function has had several inconsistencies corrected and now better handles calculations involving previously defined calculated columns.

    • When linking from one View to another in a Workspace, you can now select a Filter in the target View to be selected when the View is refreshed as a result of a double click on the link column. Leaving the Filter choice blank results in the currently selected Filter being used.

    • Field Lists and Calculated columns now have a check box to Enable/Disable hiding of the Column. This allows you to quickly hide/unhide an individual field or calculation.

    • The AdagioPDF printer driver is available to print views to PDF files.

    • This version moves toward our goal of a more Windows 7 friendly environment for installation. If you are installing to a mapped network drive that is normally accessible, but you cannot see it during the install when attempting to select a drive or folder, you can now install by browsing to the correct folder using the Universal Naming Convention (UNC), for example \\myserver\accounting\. This avoids having to adjust the User Account Control settings, which requires you to restart your computer and temporarily grant Administrative privileges to the user if they are not an administrator.

    • The install writes to the master install log file "AdagioMasterInstall.log" in the \softrak\system folder. This log shows the version installed and the version being replaced, the name of the Windows user who did the install and the rights for that user. An entry is also written to the log when an updated version of the Adagio Data Source (ADS) is installed, showing the version installed and the version being replaced. This log can be used to quickly determine the install history for all Adagio programs.


Adagio GridView
9.0C | 2010-10-01 (Oct '10)
  Go to top
Release Notes
Print This

  • Compatible with Office 2010 (Excel 2010, 32-bit and 64-bit versions).

  • Added a Permissions function to allow you to define what Users are allowed in what Application.. When logged in as SYS, then Edit |
    Permissions is available. You select the user(s) and then the application(s) they are permitted to access. For example, a particular
    user could be allowed to create or use views based on Receivables but not Ledger. Attempting to load a pre-created view on a
    restricted table will open the view but not load any records - the user will get a blank view. Permissions are by company database.
    This allows a user permission to access an application for one company but not for another. Permissions cannot be set when
    running GridView-RW in RW mode. Note: you cannot restrict the user SYS. .

  • Added named Row Formats. A Row Formats dropdown box has been added to the toolbar, similar to the Filters dropdown. Row
    Formats allow conditional formatting on rows. For example, format a view of customers to show customers who have exceeded their
    credit limit highlighted in red or any Style you have defined. The "tested field" can be a column in the view or a data element in the
    table. Row Formats can be attached to filters. When a Filter is selected the associate Row Format is automatically applied. Note:
    after installing the 9.0C upgrade, you need to reset the toolbar before it will display the Row Formats dropdown. Select View |
    Customize and click on the Reset button for each choice in the Toolbars tab.

  • Added the GETEXTERNALDATA function, which gets fields from other tables. This allows you to create your own composite views,
    eliminating the need for composite dictionaries (@Znna). Each table used for the view must contain the same Link identifier. For
    example, you can add the Customer Name to the A/R Customer Transactions. There are two ways to use the function:
    1 - Define an associated view (ex. Customers), and then in that view, select 'Copy column to another View', then in the primary view
    (ex. Transactions) select 'Paste Column from another View'.
    2 - When in the primary view, select Edit | Insert Related Column (Alt F8). A list of modules is presented, then a list of tables in the
    module and finally a list of fields in the table. The fields will be alphabetical if that option was originally selected when defining the
    view

  • Added the GETLINKEDVALUE function, which returns fields within another view that was created with a table that does not contain a
    Link identifier . This function is similar to VLOOKUP in Excel. For example, add the Balance Outstanding field from a view created
    from the A/R Customer Master table to a calculated column within a view created from the OE History Detail table.

  • Added the GETLINKEDRESULT function, which copies the original column Total, Min, Max or Average result to a calculated column
    in another view. This result might then be used in a calculation within the destination view. For example, you can add the column
    total of the Balance Outstanding field from a view created from the A/R Customer Master table to a calculated column within a view
    created for the OE History Detail table.

  • The 'Selected Fields' choice was added to the form when defining Filters, Calculated Columns and Row Formats. Selected Fields are
    the ones that are on the current View. The list is presented in the order they appear on the view or in alphabetical order if that option
    was selected when defining the View.

  • When you open a view or workspace that has been saved with data, the status line along the bottom of the GridView windows now
    displays a message indicating the name of the view being loaded, which could take several seconds or minutes. In previous versions
    the status line only displayed 'For Help, press F1' during this time.

  • Edit | Defaults | 'On Start up do' now includes the 'Open Workspace' option.

  • The Named Items file is loaded when a workspace is opened from the Inquiries menu in Adagio applications.

  • Calculated Columns can now be edited directly from the View, using the right-click menu. In previous versions, the Edit / Calculated
    Columns function was required to edit the column. This makes editing calculated columns faster and easier to use.

  • View file properties added to show the file name, description, type, index file(s) and other information. Select and right-click on the
    top left-most cell of the view to display the properties.

  • GridView 9.0B allowed you to save your Adagio User Id and Password, and defaulted them from your Windows authenticated user
    name when logging in. This option may now be turned off by editing SoftraksystemADS.INI and adding the lines:
    [Options]
    RememberUser=0
    RememberPassword=0

  • Individual Item Number segments can be shown as separate fields in views. The field names are set to the Segment Name fields
    from the System Options tab in the Company Profile in Adagio Inventory. You must open the database at least once with Inventory
    8.1C before these fields become available.

  • Updated and added to the sample views installed in softrakgvwin iewsadagio. SummarizeSales.gvs (workspace) shows how to
    set up Sort Sequences. AP Invoices to Pay.gv (view) shows connecting Filters to Named Row Formats, and also uses
    GetExternalData to get the Vendor Name into the AP Transaction table view. CustomersWithPaidSales.gvs (workspace) shows how
    to retrieve a subtotal from one view to use in another (in this case, for sorting). CustomersWithRecentOEdocs.gvs (workspace)
    shows how to use GetLinkedValue formulas to report the most recent transaction for each customer.

  • Updated sample data to the most current versions, including GL 9.0C, AR 9.0B, AP 8.1C, and IC 8.1C.

  • The Delete key has been disabled on columns unless GridView-RW is active. In previous versions the Delete key cleared the
    contents of the fields in the column, whereas the Delete in the pop-up menu deleted the entire column.

  • When renaming a column you are now prevented from using the same name as an existing column or calculated column, thus
    preventing potential problems when linking on the field.

  • When GridView is opened from the menu in an Adagio application by a user with a blank Adagio password it no longer displays the
    Open dialog and waits for user input (same behavior as for other Adagio applications).

  • If you opened a workspace, closed all the views in it and then closed GridView, it asked if wanted to close all views even though
    none were open.


Adagio GridView
9.0B | 2010-02-22 (Feb '10)
  Go to top
Release Notes
Print This



  • The functions =RECORDCONTAINS(itemvalue[,endingvalue]) and =VIEWCONTAINS(itemvalue[,endingvalue]) have been added to search for information in a record or view respectively. If the RECORDCONTAINS() function is used, then all fields with the same data type (string, date, number) in the record are searched for a case insensitive match. If VIEWCONTAINS() is used, then only those table fields included in the View are inspected (calculated columns are not inspected). If the itemvalue is a string and the endingvalue parameter is non-zero, then a case sensitive search is performed, otherwise the search is not sensitive to case. If the itemvalue is a date or number and a second value is specified, then all records containing dates or numbers between (rather than equal to) the specified range are matched.

  • The program DataDictionaryExporter.EXE is now installed in the Softrak\GVWin folder. It creates Excel Workbooks listing all the tables and data elements in your installed Adagio modules. You can use Excels search functions to locate specific field instances in a large table. The file DDExporter.pdf documents how the utility works.

  • An option has been added to sort the field names in a table into alphabetical order

  • The workspace name is now included in the title bar to make it easier to identify multiple GridView sessions on the Task Bar.

  • On startup of Adagio GridView, you can choose a function (New, Open, Recent Files, Recent Workspaces) to invoke automatically.

  • The command line parameter “/F:folderpath” has been added to specify the folder to be used for loading and saving Views and Workspaces. If the command line parameter “/c” is not specified (meaning that the user may not change or create a view), then the user may only open Views in the specified folder.

  • Security has been improved. If the user does not have permission to change a view, then they may only open Views in the directory specified in the “/F” command line parameter. If GridView has been launched from an Adagio module and the user does not have permission to edit the View, then they also cannot open any other Views (the Open button is disabled).

  • Adagio GridView RW has been improved in the following ways:

  • The program title automatically changes to Adagio GridViewRW when read-write is enabled

  • Translate coded values is now automatically disabled

  • You can now multi-select records for deletion

  • You can now add records to a file. To add multiple records, multi-select the number of record you want to add and choose “Insert”.

  • The Recent Files and Views Dialog boxes have been made resizable.

  • Improvements in speed and other features have been made to the automated Excel export functionality (“/XDV”). Now only the exported workbook is closed on task completion (rather than the entire Excel session).

  • Improvements have been made to the automatic conversion of Views when a different data table is selected. Adagio GridView 9.0B 2 of 3 GV20100222 15-Feb-10

  • The Format Styles have been added to the Row Formatting Dialog.

  • Compatible with Windows 7.

  • The Adagio Open Data Dialog has been significantly improved. The Previously Opened database list is now saved by Adagio User rather than for all users. The first time an existing user or a new user logs into Adagio GridView they will be asked “Would you like your historical company access list set up?” Answer yes to have all entries from the Previously Opened list from your prior use of GridView copied for your use. The Open Data screen and Previously Opened database list now show the date the database was last opened by the user. You may also elect to have Adagio save your Adagio User Id and Password and default them when logging into Adagio. The saved information is based on your Windows authenticated user name. This option may be turned off by editing \softrak\system\ADS.INI and adding the lines: [Options] RememberUser=0 RememberPassword=0

  • Excel Direct (from finders, smart finders and from grids in some modules) can be configured to export an ASCII CSV file (instead of sending data direct to Excel) and start an application that automatically opens the file. This allows export when Excel is not installed and provides support for other spreadsheets such as OpenOffice.org. Note that unlike Excel Direct there is no formatting with CSV. To enable this functionality, entries must be made manually in the file \softrak\system\ssi2xl.ini. Refer to the Configuring Excel Direct to Export to CSV topic in the Readme help for details.

  • Install, workstation install and Service Pack install now support installing to a LINUX server without the special command line parameter /LINUX. Note: This prevents problems with future installs but if you encounter a problem with read-only files from a previous install you must correct it manually to set all Adagio files to read-write.

  • When using GridView RW Copy/Paste of a Date field has been fixed.

  • When using Excel Direct with hidden columns all columns are correctly formatted.

  • Autorun features for Excel Direct have been fixed.

  • Added Copy to the grid context menu to facilitate the paste of the cell value into another application.

  • You can no longer make changes to the Header/Footer or change the cell formatting unless you are allowed to Edit a View.

  • When saving a View with “Save without data” enabled and a large number of rows, clearing memory would take an inordinate amount of time. This has been fixed.


Adagio GridView
9.0A | 2008-11-06 (Nov '08)
  Go to top
Release Notes
Print This

  • Supports Adagio GridView-RW add-on product that allows you to write to your database.

  • Select Table now shows only the dictionaries matching the versions of your databases. It shows only latest revision of the dictionary if more than one exists for the version of the data. For example, if dictionaries exist for Adagio Receivables 8.0A and 8.0B-8.1A (@R80A and @R80B) then Select Table only shows the Adagio Receivables 8.0B-8.1A dictionary, not the Adagio Receivables 8.0A dictionary and not the Adagio Receivables 9.0A dictionary (@R90A). This makes it easier to find and select the correct dictionary. Note: you must open your database at least once with its application before the dictionaries are available in Select table. For example: the Adagio Ledger 9.0A dictionary will not be available until you open your G/L database at least once with Adagio Ledger.

  • Added the ‘Show all tables’ option to Edit | Defaults. If not selected, only the dictionaries matching the versions of your databases. Note: You must use this option to see Composite tables.

  • Added Excel Direct Views (XDViews). This allows you to automate sending views to Excel. For example, a batch file could be run daily after normal office hours to generate a view result and send to it to a spreadsheet for use the next business day. The new command line parameters for XDViews are:

    /XDW:<workspace> Launch GridView and send the named workspace (or View) to Excel without operator intervention.
    /XDF:<filtername> Select the named filter prior to sending the workspace to Excel.
    /XDD Create a subdirectory with today’s date under dataXDViews (or dataXDViewsUserID if /XDP is specified) to hold the Excel workbook
    /XDP:<workspace> Launch GridView and send the named workspace (or View) from a private directory (directory name equal to UserID) to Excel without operator intervention.

  • A new function YEARL({date}) returns the actual year of the date in the formula. The function YEAR({date}) continues to return the number of years since 1900.

  • Enlarged the Select Fields dialog box. The size of all sizeable dialog boxes is now saved.

  • Dialog boxes are now centered correctly over the main application screen when you have more than one monitor.

  • The performance across a network has been significantly improved.

  • Tables added to the ‘Adagio (Composite Tables 8.0C)’ dictionary:

    *J/C Estim w Master
    *AR Notes Header w Cust
    *IC Adjustment Audit w IC Item
    *IC Physical Inv. Worksheet w IC Item

  • Edit | Defaults has new field ‘On start up do’ option that can be set to create a new view, open views, or open list of recent files or workspaces.

  • In the Edit Definition | Fields, if you de-select a field from the right-hand list it returns to its original position rather than the bottom of the list.

  • The RowFormat function was moved from the Edit menu to the Format menu as it is actually a formatting function.

  • Leading spaced are now supported in the Named Items file.

  • When GridView is launched from the GridView menu in another Adagio module (current versions only) the data dictionary of the calling module is place at the top of the list in the Select Tables dialog.

  • The green sort order indicator line on the sorted column no longer disappears when you refresh the view.

  • Translation of coded fields in the Extension table in a Composite table is now supported. Previously codes fields were only translated for the Primary file of a Composite table.

  • GridView can update views (*.gv files) when a data dictionary changes for a new version of an Adagio module (for example when you upgrade from Adagio Ledger 8.1A to 9.0A the dictionary (Module) changes from ‘Adagio Ledger 8.0A – 8.1A’ to ‘Adagio Ledger 9.0A’). The view is converted by selecting Edit | Definition, clicking the Tables button and choosing the new Module and Table. If all fields in the old view can be converted you just need to save the view to update it. If some fields cannot be converted to fields in the new table a message is displayed naming the fields. Note that in many cases an existing view using the original dictionary will continue to work although not when you upgrade modules to 9.0A. Also note that new versions do not install old dictionaries and thus views using old dictionaries could stop working if you moved to a new server and installed the current versions.

  • The sample views installed in softrakgvwinviewsadagio have been updated to use the currently shipping dictionaries, including the Adagio Ledger 9.0A dictionary.


Adagio GridView
8.1A | 2007-10-08 (Oct '07)
  Go to top
Release Notes
Print This

  • Refreshing a View that had extra spaces in a Filter or Calculated Column would cause a "Not Responding" state in GridView 8.1A.


Adagio GridView
8.1A | 2007-08-27 (Aug '07)
  Go to top
Release Notes
Print This

  • Compatible with Windows® VistaT.

  • Compatible with Adagio Lankpaks 8.1A. Lanpaks must be 8.1A for all Adagio 8.1A modules.

  • Adagio download files, installs, workstation installs, all workstation install (\softrak\allwkst\allwkst.exe), and the Adagio Check System utility (chksys.exe) are now signed with a digital certificate using VeriSign to allow you to verify the Publisher is Softrak Systems Inc.

  • Vista does not support the old style Windows Help (.HLP files). All .HLP files were converted to compiled HTML help (.CHM files), which are supported by Vista.

  • For security reasons Windows does not permit .CHM help files to be run from a network drive. This is true in XP as well as Vista. The .CHM files must be run from a local drive. Adagio 8.1A installs all .CHM help files to your local hard drive and loads them from there. The workstation install also copies .CHM files to the local drive.

  • When switching window/task in Vista with Alt-Tab or the new Flip 3D (Windows-Tab) an image of the current Adagio screen is shown rather than just the icon of the Adagio program.

  • The formatting of dates and text sent to Excel has been improved.

  • Updated @Z80C. Added *IC Item Loc w IC Item ( @Z80C206 ), IC Item Location ( @Z80CILO ) linked to IC Item - Selected ( @Z80CICM ). Added missing index to *OE Ord Detail w Head, Head Ext so that extended information shows.

  • New function ToWords that returns the text representation of numbers or amounts. For example 914.38 returns "Nine Hundred Fourteen Point Three Eight" and $914.38 returns "Nine Hundred Fourteen Dollars and Thirty Eight Cents".

  • New function RecordNumber that returns the physical record number in a "flat" or "index random" file. The record number can be useful for a developer when attempting to track down a problem with selected data. The value returned for a "idt" file is undefined.

  • New header / footer codes have been added:

    $L prints the Filter name
    $V prints the Filter expression
    $Y prints the Table name
    $Z prints the Table description

  • Date format MM/DD/YYYY has been added.

  • Added 'Regional Number' and 'Regional Currency' formatting.



Adagio GridView
8.0E | 2006-10-17 (Oct '06)
  Go to top
Release Notes
Print This

  • Named Sort Sequences have been added and are used in conjunction with Filters.

  • You can now have a "negative link" between two Views. Negative links display all records that do not contain the linked field.

  • You can now "Join" one link with another. This allows a link to search within the row set already displayed in the link View.

  • Recently used lists have been added to Dictionary and Table selection.

  • Named Item file may contain [Include] section which will help when defining repetitive entries.

  • Selecting "Refresh on Open" in the defaults dialog, automatically selects "Save without data".

  • Added command line parameter '/?' to display a short help screen of the available command line parameters and Server Code.

  • Users without Edit permission on the command line ( /C ) can no longer disable Filters to get a View of the entire contents of a table.

  • Users without Edit permission on the command line ( /C ) are allowed to change column order.

  • Allow /S to connect, without stopping, when only one server is active and Company, User ID and User Password are provided.

  • Allow fully qualified server, company, user name and password to skip login dialog.

  • /S without a server name will display a list of available servers.

  • Corrected handling of comments inside strings.

  • The Sort function now uses the collation sequence of the language the user is running.


Adagio GridView
8.0D | 2005-09-14 (Sep '05)
  Go to top
Release Notes
Print This

  • Support for Adagio GridView Server added.

  • Hints pop up when the mouse cursor hovers over column titles. The field name and link are shown for data fields; formula text for calculated columns.

  • Fixed problems in GridView 8.0C experienced when run on Windows 98.



Adagio GridView
8.0C | 2005-07-05 (Jul '05)
  Go to top
Release Notes
Print This

  • Now supports multiple, named filters into a table.

  • You can now have GridView read all files that match a wildcard specification.

  • A new menu choice allows you to set the "Run date" for a View.

  • You can now import or export named filters or calculated columns for use in other Views.

  • You can now multi-select items in a linked view, and see the results of all of the selected items in the link.

  • New Query functions have been added: =DATAFILENAME() and =FILTERNAME().

  • A new function "=LIKE(S1,S2) has been added.

  • New pattern matching functions have been added to locate records.

  • The summary state of a view is remembered, even when it is refreshed. Formatting is preserved on the summary view.

  • You can have GridView automatically translate "coded fields" in a view, without requiring a formula.

  • Formatting is preserved on totals when a view is summarized. The formatting of numbers has been improved to prevent (0.00) display.

  • You can see the properties of fields displayed in the View.

  • Only user "SYS" is entitled to see encrypted data fields.

  • ExcelDirect no longer sends hidden rows and columns to the spreadsheet.

  • You can now only delete a computed column if no other columns refer to it.

  • Error reporting has been improved.

  • The "Edit" Menu is now accessible if "/C" is not specified on the command line.


Adagio GridView
8.0B | 2004-08-30 (Aug '04)
  Go to top
Release Notes
Print This

  • A composite table "Adagio {Composite Tables 6.8B}" is installed with this version of GridView. This table can be used to define views that incorporate fields from related tables.

  • Added 3 new views to illustrate use of composite tables: AR Transactions with Customer Name.gv, GL Posted Transactions w Account Description.gv, and AP Transactions with Vendor Name.gv.

  • The Toolbar requires resetting in this release.

  • Refresh of linked views will be much quicker in most cases.

  • Excel Direct has been improved.

  • Columns can now be formatted, renamed, deleted and hidden from the View by using the Right Button on the Column Title.

  • "Save Workspace As..." and "Save All" options have been added to the File menu.

  • "Named Items" have been added which, when used in conjunction with the GetNamedItem function, provides greater flexibility when defining a View.

  • Column Minimum, Maximum and Average have been added to Total and each have a different "highlight" style.

  • Linked Views will attempt to match on "Column Name" if no other "index" was found.

  • An optional parameter, to provide the initial value, has been added to QueryString, QueryNumber and QueryDate.

  • QueryString, QueryNumber and QueryDate will remember the last value entered and use that as the default value.

  • The Calendar used in QueryDate has been updated.

  • A new DateString function has been added to give greater flexibility when formatting dates.

  • Date formatting for MM/DD/YY has been fixed.

  • Excel direct now transfers column and row formatting.

  • The number of decimals defined in the dictionary is now used when displaying numeric fields.

  • Integer type fields such as Fiscal Period can now be used for summarizing.

  • Using the Right Button on a Column Title now allows for complete control over the format of the column. The formatting information is now saved with the View.

  • View by rows now hides the underlying grid.

  • Previously, if you cancelled a refresh and kept the records the Row and Column formatting was not performed, this has been fixed.

  • The "View by Rows" has been added to the view definition.

  • Improvements have been made to the reporting of errors.

  • Corrections were made to the functions Day(), Month(), and Year() which would sometimes return unexpected values.


Adagio GridView
8.0A | 2003-05-15 (May '03)
  Go to top
Release Notes
Print This

  • The toolbar requires resetting in this release.

  • A summarize View has been added\.

  • A toolbar button has been added to enable and disable a Filter attached to a View.

  • A Sort toolbar button has been added.

  • Columns that make up the Sort Order are now highlighted with a color at the top of the column title.

  • A Refresh toolbar button has been added. The View can also be refreshed by pressing either F5 or F9.

  • "Tile Vertical" has been added as a Window option.

  • Beginmonth(), Beginweek(), Beginyear(), FiscalStart(), are available Date functions for defining formulas and filters with "floating" date ranges.

  • QUERYDATE("prompt"), QUERYNUMBER("prompt"), QUERYSTRING("prompt") are available to ask the user a question and have the result stored or used in a View.

  • Calculated columns can be used in Filters.

  • Calculated columns can be used in later defined calculated columns.

  • Lines beginning "//" are treated as comments in filters and formulas.

  • You can now save a View without any data.

  • Columns may be "Frozen" in position to allow easy scrolling of data.

  • Added dictionaries for ACCPAC Plus Accounts Receivable V7.0A, General Ledger V7.0A and Inventory Control V7.0A.

  • Highlighting a previously used file on the File menu displays the full path of the file on the status bar. Submenus have been added for Recent Workspaces and Recent Files.

  • ExcelDirect functionality has been improved in speed and formatting. Transfers can now be aborted by pressing the Escape key.

  • Sorting a large number of rows is now significantly faster.

  • The arguments and returned values from the string functions Find(), Mid(), Replace() and Choose() have been made consistent.

  • Data elements that contained a "\" character did not display properly. This has been fixed.

  • Sometimes the calculated value displayed on a right button click from a selection of entries would be incorrect. This has been fixed.

  • The install and workstation install now check to be sure the Windows user has administrator rights to the local machine.

  • The install now checks for Adagio programs in use by other workstations on a network.


Adagio GridView
6.8A | 2002-10-15 (Oct '02)
  Go to top
Release Notes
Print This

  • Improved method of creating and modifying Filters and Calculated Columns. Views are automatically converted when they are first accessed. converted Views can not be opened by previous versions of GridView.

  • Filter definitions may use Calculated Columns.

  • Calculated Columns may be used when Linking Views.

  • Added Excel Direct to Export To menu and to the File Menu bar.

  • Help has been modified to reflect the improved method of defining Filters and Calculated Columns.


Adagio GridView
6.8A | 2002-09-10 (Sep '02)
  Go to top
Release Notes
Print This

  • GridView stopped working 60 days after its initial use, even if you had registered and licensed the product.

  • In some cases, the Criteria was not saved and therefore the result was incorrect.

  • Some context Help links have been corrected.

  • When you defined a link and browsed for the View to link to, the listed files also included the workspace files (*.GVS). If you chose a workspace file, an error resulted. Only View files (*.GV) are shown now.

  • In rare cases, the link on some fields did not return the correct information.


Adagio GridView
6.8A | 2002-07-26 (Jul '02)
  Go to top
Release Notes
Print This

  • Initial release of Adagio GridView.