Difference between revisions of "Release History"

From Vital Soft Wiki
Jump to: navigation, search
>Johno
(Version 3.1.1.11 - Not Released)
(Version 3.4.2.3)
 
(157 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
== Visimage3 Release History ==
 
== Visimage3 Release History ==
 +
See [[History of Previous Releases | release history]] of previous versions.
  
=== Version 3.1.1.11 - Released October 2nd, 2014 ===
+
=== Version 3.4.2.3 ===
 +
:'''Production Version Released March 24, 2023'''
  
 
:'''Fixes:'''
 
:'''Fixes:'''
:* Save ''Report Field'' Summary options in the context file.
+
:* Fix an issue enabling batch access when the default port was used in the connection. (Bug introduced in version 3.4.2.2)
:* Add the Average option to the ''Report Field'' Summary options
+
:* Modify codegen to no longer use an edit mask when generating automatic counts to host SD files. The mask could potentially cause an issue when creating an Excel column from this field.
:* Better detection of changes made to context files (The prompt to save should no longer appear if no changes were made to the context.)
+
:* Fix an issue when creating Excel files with a column formatted using a mask like "$$$,$$9.99-". (Bug introduced in version 3.4.2.2)
 +
:* Fix an abort when opening a context with no selected output.
 +
:* Fix a very rare issue trying to start multiple copies of Visimage3 (one in batch and one interactive.)
 +
 
 +
=== Version 3.4.2.2 ===
 +
:'''Beta Version Scheduled for Release December 15, 2022'''
  
 
:'''Enhancements:'''
 
:'''Enhancements:'''
:* Interrupt Selection
+
:*List Designer
:* List Designer Options - New option to print a message (using First Page lines) when no entries qualify in the selection
+
::* Added an "Is Key" checkbox to the Item Options in the List Designer column.
:* Usability Improvements
+
:::* The "Is Key" option '''must now''' be checked to designate a column as a key when creating SD Indexed files.
::* Right-clicking a context and selecting Open (or double-clicking) will open Visimage3 with the context open.
+
:::* Previously, sorting caused the column to be used as a key when creating SD Indexed files.
:::(The first time you will have to teach windows to associate ''.ctx'' with Visimage3)
+
:::* Existing contexts will be automatically updated.
::* Most dialogs will be closed with Enter (OK) or Esc (Cancel)
+
::* The List Column Item Options button tooltip (mouse hover) will display the column Format and whether or not the column is a key for SD Indexed files.
::* When selecting items from an array, double-clicking an item will select that one item
+
 
::* Main menus can be opened using the Alt key (For example, Alt-F opens the File menu)
+
:* Task Execution
::* The following shortcuts have been added:
+
::* Enhance the GO toolbar button's split (dropdown) menu for "Selection Only" tasks.
::::{| class = "wikitable"
+
 
! style="text-align:left;"| Shortcut Key
+
:* Banded Excel Output
! style="text-align:left;"|Action
+
::* Expand the meaning of "Delete Sheet if it exists" to delete all sheets that match the banded sheet name pattern "<band> Loans" where the banded value does not exist in the current execution list of banded values.
|-
+
::* This enhancement could cause backwards compatibility issues if other sheets exist that match that pattern but are not banded sheets. For example, a sheet called "All Loans" will be deleted using the previous example, but "All Loans.", or "All LOANS" would not be deleted.
|Ctrl-G+S||Execute (Go) - Selection
+
::* Reorder all sheets that match the banded sheet name pattern to match the order of the current set of banded values.
|-
+
 
|Ctrl-G+T||Execute (Go) - Task
+
:* Version Information
|-
+
::* A new Help menu (Version Info) will display current and available release information for Visimage3, AskPlus and VsvTcp.
|Ctrl-G+C||Execute (Go) - Context
+
::* The current Visimage3 version is now displayed on the first welcome dialog.
|-
+
::* Display the AskPlus version information the first time server is started.
|Ctrl-N+L||New Context with List
+
::* An update will be recommended for Visimage3 and/or AskPlus if the current release is at least 18 months old and a newer (general release) has been available for at least 6 months.
|-
+
 
|Ctrl-N+R||New Context with Report
+
:* Support SSH Tunnel Definitions as part of the Visimage3 Connection Information:
|-
+
::* Feature is hidden by default - to enable, manually add "EnableSSHTunneling=true" to the Visimage3.cfg file.
|Ctrl-O||Open Context
+
::* When enabled, each connection definition can optionally include SSH Tunnel Information.
|-
+
::* Visimage3 supports both sTunnel and PuTTY tunnels.
|Ctrl-P||Output (List / Report)
+
::* When using PuTTY tunnels, Visimage3 will automatically launch a PuTTY session to enable the tunnel.
|-
 
|Ctrl-S||Save Context
 
|-
 
|Ctrl-X||Exit
 
|-
 
|Ctrl-Y||Interrupt Selection
 
|-
 
|Ctrl-Z||Undo
 
|-
 
|Ctrl-Tab||Switch Tabs Right (Selection->Design->Output)
 
|-
 
|Shift-Tab||Switch Tabs Left (Output->Design->Selection)
 
|-
 
|F5||Execute Task
 
|-
 
|}
 
  
=== Version 3.1.1.10 - Released September 24, 2014 ===
+
:* Miscellaneous
 +
::* Remove the Global Outer Join option in the Selection Advanced Options dialog.
 +
<!-- This is a comment
 +
::* After starting server, display a message if the user password will expire in less than 10 days. This enhancement requires VsrvTcp version 4.9.2.7 to be installed on the host.
 +
-->
  
 
:'''Fixes:'''
 
:'''Fixes:'''
:* Server
+
:* Task Execution:
::* Fix bug when testing a new connection (existing connections worked)
+
::* Fix a bug while executing "Selection Only" tasks from the Execute Context menu.
::* Refresh the local dictionary when an error occurs executing the saved Open/Close commands (Manage Databases)
+
::* Fix a code generation bug while creating a UNIX script for host TEMP files that used the append option.
 +
::* Fix an "invalid path error" when a global variable was used as part of the local filename and no path was specified.
 +
::* Fix an intermittent problem "error refreshing local dictionary" that could occur during batch execution.
 +
 
 +
:* Excel Output:
 +
::* Fix a bug calculating the number of implied decimal points with fields formatted with a percent mask. (eg zz9.99%)
 +
::* Fix a bug when generating sub-total calculations (TF level only). Sub-total was always generated, even if the corresponding Print At was not set.
 +
::* Fix a bug identifying the Excel UsedRange (check the IsBlank property rather than checking the text property which did not work for numbers and formulas.)
 +
::* Do not attempt to load a default value for null data. Leave the cell empty.
 +
 
 +
:* Data Import:
 +
::* Change the order of the default file types when opening a file in Data Import.
 +
::* Fix several issues when displaying sample values in the main Data Import design tab.
 +
 
 +
:* Miscellaneous:
 +
::* Reload the System Variable and System Operator lists after starting server.
 +
::* Fix a "parameter error" when starting server failed in some circumstances.
 +
::* The messages for read and select limit reached will be displayed as high priority messages.
 +
::* Improved logic when creating automatic variables in list code generation.
 +
::* Fix several help button links.
 +
::* Display an error message if the AppData/Roaming/Visimage3 folder cannot be created. Previously, Visimage3 exited silently with no error.
 +
 
 +
=== Version 3.4.2.1 ===
 +
:'''Production Version Released May 23, 2022'''
 +
:(Beta Version Initially Released January 21, 2022)
  
 
:'''Enhancements:'''
 
:'''Enhancements:'''
:* Server (Connection to AskPlus)
+
:* '''Shared selections between tasks:'''
::* Better detection of server problems when AskPlus exits prematurely
+
::* List and report tasks may share the selection of a previous task.
::* Better handling of Tcp/ip timeouts
+
::* The shared selection may be used "as is" or refined by adding additional secondary topics or by adding a criteria or limit.
:* List Designer:
+
::* This feature is activated in the Selection > Advanced Options.
::* Add menu choices to move columns left and right
+
::* Watch [https://vimeo.com/vitalsoft/shared-selections sample video] demonstrating this feature.
::* Add a List > Column menu to the main menubar
+
::* For simplicity a task may be designated "Execute selection only":
:* Other
+
:::* This option is located in the Selection > Advanced Options.
::* Tool Windows (Item, Macro, Variable Lists) can be pinned open
+
:::* Choose this option if the selection will be used by other tasks and you do not wish to have any output when the selection is executed.
::* Status bar has been updated and provides more feedback including the current output.
+
:* '''List compute statements support Begin/End sort levels:'''
 +
::* Similar to the report task, list compute statements can now use levels (previously all list compute statements were executed at the Detail level.)
 +
::* This feature is activated in the List > Options Calculation tab.
 +
::* A new summary option (Current Value) is available to print a variable on a summary line with no automatic summary applied.
 +
::* Watch [https://vimeo.com/vitalsoft/list-compute-with-levels sample video] calculating weighted average APR using this feature.
 +
:* '''Include Excel Formulas in Excel Output:'''
 +
::* A list task column can contain an Excel formula. The formula can refer to other columns in the list.
 +
::* In the List column properties choose "Excel Formula" in the Print Options dropdown list.
 +
::* When referring to other columns, enclose the column name in square brackets. For example:
 +
::: =pmt([APR]/12, [NUM-MTHS]*12, [BALANCE])
 +
::* Visimage3 will include the appropriate cell references when the formula is inserted in the output file.
 +
::* Excel Formula columns are included in Excel Data files and Formatted Excel files. They are ignored in all other output types.
 +
:* '''Support for Excel Template Files:'''
 +
::* When generating Excel output you can specify a template (or master file) that is used as the starting file when creating the output.
 +
::* This file is opened, the requested data is appended to the file, and the file is saved with the specified output file name.
 +
::* The output file name should be different from the Template (starting) file name.
 +
:* '''New List Options:'''
 +
::* The List options window has been reorganized into 3 tabs for ease of use:
 +
:::* New option "Include summary row labels" (General tab):
 +
::::* The summary row labels "Tot", "Cnt" etc were always included by default. They can now be removed.
 +
:::* New option "Enable sort group levels in compute statements" (Calculation tab):
 +
::::* This activates the option described above to allow list compute statements to be calculated on different levels.
 +
:* '''Other enhancements:'''
 +
::* The column "Print Conditionally" if logic will be applied to the lowest level sort when "Summary Only" is selected.
 +
::* In local file output, MS Mailmerge was moved to the legacy menu.
 +
::* In host file output, a legacy menu was added for rarely used file types.
  
=== Version 3.1.1.9 - Released September 12, 2014 ===
+
:'''Fixes:'''
 +
:* Improved Excel append data logic that should protect Conditional Formatting and other calculations.
 +
:* Do not generate commas in the edit mask for count summary values in Excel output.
 +
:* In some cases with Formatted Excel output, the insertion of the "Tot" and "Cnt" columns was incorrect. This has been corrected.
 +
:* Fix a bug when appending asd files whose name include a global variable.
 +
:* Improve the path verification for local files that contain global variables in the name.
 +
:* Add missing special operators to the tools menu: UniqueId and IsEven.
 +
:* Handle AskPlus warnings related to !RANGE as errors and customize the messages.
 +
:* Do not used forced type conversion in the Select If code of Data Import.
 +
:* Fix a Data Import VariableScope error message.
 +
:* Rename duplicate global variables while importing tasks from another context.
 +
:* Clear the current values of global variables after exiting server.
 +
:* Exit server prior to exiting Visimage3.
 +
 
 +
=== Version 3.4.1.5 ===
 +
:'''Production Version Released December 30, 2021'''
 +
:(Beta Version Initially Released October 22, 2021)
 +
 
 +
:'''Enhancements:'''
 +
:* Do not report a "bad path" error if the local filename contains a global variable.
 +
::This modification causes a strange error message "SdToX Scratch Open Error" when a bad path is encountered (fixed in 3.4.2.1)
  
 
:'''Fixes:'''
 
:'''Fixes:'''
:* Execution to Local File:
+
:* Fix an "unhandled exception" when an error occured while getting the list of available local printers.
::* A bug that did not correctly purge the local file (and continue execution) when the user clicked OK has been fixed.
+
:* Properly handle invalid sheet names in Excel.
::* Improve the error message, when the local file name is an existing directory
+
:* Fix a batch error when trying to write a warning message.
:* Properly refresh the secondary topic list when duplicating a Task
+
 
 +
=== Version 3.4.1.4 ===
 +
:'''Beta Version Released August 23, 2021'''
  
 
:'''Enhancements:'''
 
:'''Enhancements:'''
:* Start Server Enhancements:
+
:* Added a "-t" option when executing from the command line to echo all logging statements to the stdlist.
::* Encrypted password support
+
::(This works when executing from the COMMAND window, but does not seem to work from Automic.)
::* Ability to change passwords (Edit Connections)
+
:* If an error occurs when executing in batch, the last line of the log will always contain the phrase "Visimage3 task execution failed.”  If executing via Automic, add this phrase to the list of ERROR_VARIABLES checked by your error routine.
::* Ability to test a connection (Edit Connections)
+
:* Add a new '''Local File''' output option for ASD files to use the Heading 1 text (List) or the Field Name text (Report) to generate the column headers. This allows mixed case headers. Local file output only.
 +
:* Move Local Portable SD files to the list of Legacy Output choices.
  
:*Job/Task Creation Enhancements:
+
:'''Fixes:'''
::* Adding header/trailer files to the job output
+
:* Fix an issue opening older contexts (introduced in version 3.4.1.2 and fixed in 3.4.1.3)
::* UC4 Integration
+
:* Fix a rare bug with duplicated global variables. After duplicating a global variable, the Visimage3 current value of that variable was incorrect. Saving and reopening the context also resolved the issue.
::* Add "-b" to the /ASKPLUS/askplus line in the created job
+
:* Fix a bug when executing in batch mode. Visimage3 execution could hang if a syntax error occurred in a task which was not the last task in the context.
 +
:* Fix a bug when executing in batch mode.  An error could sometimes occur when executing a multi-pass task because the Local Dictionary was not ready.
  
:'''Miscellaneous:'''
+
=== Version 3.4.1.2 ===
:* Allow the menu choice ''Report > Sort'' to be accessed from the ''Selection'' tab
+
:'''Beta Version Released July 15, 2021'''
:* Change the default name of a host/local file from temp to vistemp
+
 
 +
:'''Enhancements:'''
 +
:* Scheduling Visimage3 Tasks
 +
::* The File menu choice was renamed from "Schedule Windows Task" to "Schedule Visimage3 Task"
 +
::* The scheduling Window includes an option to choose between "Windows Task Scheduler" and "Automic"
 +
::* When Automic is selected as the scheduler...
 +
:::* A "Task log file name" can be entered (Default is context_name.log)
 +
:::* When "Schedule" is clicked, a text winow is opened...  Copy & Paste the contents into the Automic code window.
 +
:::* The code includes the syntax to launch Visimage3 followed by a "type" command to echo the results of the log file
 +
:::* If an error occurs while executing the task, Visimage3 will exit with an error code
 +
::* Edit Preferences (General Tab) includes a default scheduler option (Windows Task Scheduler / Automic)
 +
:* Misc Enhancements:
 +
::* Add a "log=filename" parameter when launching Visimage3 tasks in Windows. This parm allows Automic to display the results of the Visimage3 task execution in it's results tab.
 +
::* Several missing System Variables and Operators were added to the Tool Windows.
 +
::* Add a check box to immediately view the results when generating a UNIX script file.
 +
 
 +
:'''Fixes:'''
 +
:* Fix an issue with calculated headers in Formatted Excel output (if a subsequent list did not have a calculated header, the wrong header was shown)
 +
:* Fix a variety of issues with Formatted Excel sheet banding.
 +
:* Change the default for sheet banding to false.
 +
:* Fix an issue when testing a new connection from the initial setup dialogs.
 +
:* Fix a script code generation issue (MAKETEMP commands were missing in some cases)
 +
:* Add missing Cut/Copy/Paste short-cut keys to the list column name field
  
=== Version 3.1.1.8 - Released August 26, 2014 ===
+
=== Version 3.4.1.1 ===
 +
:'''Beta Version Released April 2, 2021'''
  
 
:'''Enhancements:'''
 
:'''Enhancements:'''
:* Add ''List Designer'' support.
+
:* List Task - Formatted Excel Output
::* List Designer is fully supported
+
::* Enhanced to include a Sheet Banding Option
::* Contexts can include both Lists & Reports
+
::* When enabled, formatted Excel output is generated on multiple Excel work sheets (one work sheet for each unique value in the banding column.)
::* Lists can contain Variables (compute statements are all executed at the Detail level)
+
::* The left most (highest level) sort is automatically selected as the banding column.
::* Select If cannot be used on columns that involve a variable
+
::* Include the current banding value on the list header or the sheet name using <band>.
:* Task Creation:
+
:::* For example, when banding by BRANCH, use "Branch <band>" as the sheet name
::* UC4 Header / Trailer support has been added
+
:::* In the header, use "Loan results for branch <band>"
::* Task Header / Trailer support has been added
+
 
:* Edit Preferences
+
=== Version 3.4.1.0 ===
::* Set ''Uses UC4'' as default for all new Tasks
+
:'''Production Version Released February 10, 2021'''
;;* Enter default Header / Trailer text to be included in all tasks that use UC4
 
::* Edit the default ''User Format'' list
 
  
=== Version 3.1.1.7 - Released July 29, 2014 ===
+
:'''Overview of Main Enhancements:'''
 +
:* Previous beta version now in production release.
 +
:* New List > Output type: Formatted Excel Output with Sub-totals: Watch [https://vimeo.com/vitalsoft/v3formattedexcel video].
 +
::* Excel output which closely resembles display output with sorts and sub-totals.
 +
::* Automatically uses the Excel SUBTOTAL() function to display sub-totals.
 +
::* Previous Excel Output type renamed to '''Excel Data File'''.
 +
:* New Admin menu for Visimage3 administrators: Watch [https://vimeo.com/vitalsoft/v3admincommands video].
 +
::* Requires vsrvTCP version 4.9.2.3 (or higher).
 +
::* Edit and rebuild user macro definitions.
 +
::* Create and delete Visimage3 users for your Credit Union.
 +
::* Password resets for other users in your Credit Union.
 +
::* Available to all sites including Fiserv ASP clients if appropriate vsrvTCP version is installed.
 +
 
 +
:'''Enhancements:'''
 +
:* Support ''Calculated List Headers'' in Formatted Excel output.
 +
:* Support global variables in Excel sheet name. For example "Loans as of #E-DATE".
  
 
:'''Fixes:'''
 
:'''Fixes:'''
:* Correct an error that prevented  ''Edit > Connections'' from opening.
+
:* Fix a '''Data Import''' bug when importing a delimited file.  Only the Tab delimiter was working correctly.
:: (This bug prevented 1st time users from configuring a connection.)
 
  
=== Version 3.1.1.6 - Released July 25, 2014 ===
+
=== Version 3.4.0.12 ===
 +
:'''Beta Version Released February 2, 2021'''
 +
 
 +
:'''Enhancements:'''
 +
:* Make additional improvements to the task request dialog shared by ''Execute Context'', ''Create UNIX Script'' and ''Schedule Windows Task''.
  
 
:'''Fixes:'''
 
:'''Fixes:'''
:* Correct ''Fully Qualified Name'' issue (BASE.SET.BASE.SET.ITEM(1)) when inserting array items.
+
:* Fixed a code generation bug when creating a UNIX script and the first line of code contains an exclamation point.  The line was is now prefixed with ''':DATA''' (not '''!DATA''').
:* Fix bug when reading a selection compute statement from a ctx file.
+
:* Fixed a code generation bug with a missing # in front of the INSEL and OUTSEL statements when creating a UNIX script.
:* Clean up minor issues in Output Options.
+
 
:* Fix a code gen issue for ''empty lines'' with an IF cond. (; was generated in the wrong place)
+
=== Version 3.4.0.11 ===
 +
:'''Beta Version Released January 20, 2021'''
  
 
:'''Enhancements:'''
 
:'''Enhancements:'''
:* Add support for ''Duplicate Task''.
+
:* The task request dialog shared by ''Execute Context'', ''Create UNIX Script'' and ''Schedule Windows Task'' now supports executing the same task multiple times using different output choices. For example, execute the task to a csv file to send to a vendor and then execute the same task to a txt file in another location as a log.
 +
::* A '''Reset''' button was added to reset the grid to default values.
 +
::* Use ''Duplicate'' to execute a task again.
 +
::* By default, ''Execute Selection'' will be set to No for duplicated tasks.
 +
::* Added more consistency checks when '''OK''' is clicked.
  
=== Version 3.1.1.5 - Released July 18, 2014 ===
+
:'''Fixes:'''
 +
:* Fixed a bug appending Excel Data to a ''Used Range'' or ''Table'' when the current range or table is empty.
 +
:* Fixed bold formatting in Formatted Excel Output (not all of the total values were bolded.)
 +
 
 +
=== Version 3.4.0.9 ===
 +
:'''Beta Version Released Sep 24, 2020'''
  
 
:'''Fixes:'''
 
:'''Fixes:'''
:* Show the fully qualified domain (or file) name in Manage Host Databases.
+
:* Fix a code generation bug when creating a host Mail Merge file.
:: For example, display membrs.report as the fullname when the month end database has been opened.
+
:* Fix a bug locating ../VISCONF/usermdef for the Admin > Reload Macro File command.
:* Fix code generation for blank lines with a Print If condition on the line or on the level
+
 
:* Fix ''Binding List Error'' for System Variables when restarting server (after closing the current context)
+
=== Version 3.4.0.8 ===
:* Disable ''Interrupt Task'' in the ''Server'' menu
+
:'''Beta Version Released June 30, 2020'''
:* Move ''Manage Databases'' from ''Report > Advanced'' to the ''View'' menu
+
 
:* Move ''Convert List to Report'' from ''Report > Advanced'' to the ''List'' menu
+
:'''Fixes:'''
:* Other cosmetic fixes (and spelling errors)
+
:* Fix a bug in the change password dialog.  The new/confirm password fields were not visible.
 +
 
 +
=== Version 3.4.0.7 ===
 +
:'''Beta Version Released June 22, 2020'''
  
=== Version 3.1.1.4 - Released July 16, 2014 ===
 
 
:'''Enhancements:'''
 
:'''Enhancements:'''
:* Add new tool window (list) for System Variables
+
:*Admin commands for Delete User and Reset Password will display list of existing users.
:* Support Select / Drag&Drop for System Variables
+
:*Admin privileges can be given to new users and can be added/removed when resetting passwords.
:* Support Select / Drag&Drop for Operators and Functions
+
:*There is a maximum of 3 admin users per Financial Institution.
:* Support Operator parameters (same logic as macro parameters)
 
:* Allow a ''Field Name'' to be specified when selecting a macro or operator with parameters
 
  
 
:'''Fixes:'''
 
:'''Fixes:'''
:* Improve report designer scrolling for large contexts
+
:*Fix a bug that Global Variables were not imported when importing a task from another context.
 +
:*Fix unhandled exception when opening a context (JobParm structure could point to an undefined output structure.).
 +
 
 +
=== Version 3.4.0.6 ===
 +
:'''Beta Version Released May 22, 2020'''
 +
 
 +
:'''Enhancements:'''
 +
:*Automatically restart server when a new connection is selected and the server is already started.
  
=== Version 3.1.1.3 - Released July 11, 2014 ===
 
 
:'''Fixes:'''
 
:'''Fixes:'''
:* Fix Open error when opening large context files
+
:*Fix unhandled exception when generating Report output to anything other than Display.
:* Report Options not being displayed.
 
:* Job Creation, default directory is now Downloads
 
:* Job Creation, OK btn enabled after using Browse button
 
:* Include Comment Level when loading compute statements
 
:* Fix code generation for "Comment Level" compute statements
 
:* Fix code generation for HostPrinter Name
 
:* Optimize context load, do not create the ReportDock until the tab is displayed the first time.
 
:* Add ''Insert Level'' to main Report Menu (Delete Level not implemented yet)
 
:* Add ''Edit Sort Expression'' to the Level Context Menu (Quick way to edit a single sort expression)
 
:* Add ''Refresh Designer'' option to the ''View Menu''
 
:* Binding list error during start server
 
  
=== Version 3.1.1.2 - Released July 9, 2014 ===
+
=== Version 3.4.0.5 ===
:'''Initial Beta Version'''
+
:'''Beta Version Released Apr 9, 2020'''
 +
 
 +
:'''Enhancements:'''
 +
:*New "Formatted Excel" '''Local File''' output for List tasks:
 +
::*Only available for '''List Task''' Local file output
 +
::*Output will closely match Display output with sort breaks (grouping) and sub-totals
 +
::*Groups are created for all sorts that have at least one summary associated with that sort break
 +
::*Sort values in grouped columns are not repeated unless specifically requested in the sort window
 +
::*Summary row sort values are '''always''' repeated and therefore a sub-total calculation (count, total, …) cannot be displayed in the sorted column for that sort break.
 +
:::(For example, in a list sorted by COLLATERAL, you cannot count the COLLATERAL column and also total the BALANCE column with sub-totals for each collateral code.)
 +
::*The "Count Sort" summary is ignored (there is no equivalent in Excel)
 +
::*Plain text page headers can be included in the formatted output (calculated headers using an expression are not supported)
 +
::*If no entries are selected, the List Options "No Entries Message" will be written to the output file.
 +
:*The local file options "Excel (.xls)" and "Excel (.xlsx)" have been consolidated using the name "Excel Data File"
 +
::*Functionality has not changed, just the name.
 +
::*Default extension is xlsx, but xls can be forced by typing the extension.
 +
:*Rename "Print (.prn)" output to "Text File" for both host and Local files
 +
::*Functionality has not changed, just the name.
 +
:*For '''new''' Ascii output (Host/Local Text Files and Printers), the value of "Chars per Line" will '''default''' to the current Display output "Chars per Line"
 +
:*CCTL is now available as an option for Host Text File (Print) output
 +
:*Add "Add to Topics" option for host Text File (Print) output
 +
::*Using SD Indexed or Self Describing files is still preferred for multi-pass reporting
 +
::*This option should be used only when multiple levels are required in the created host file.
 +
:*Tooltip for global variables will display the current value if the variable has been initialized at least once.
 +
:*List Summary Dialog OK button is grayed out until a summary and at least one "Print At" value have been selected.
 +
:*New default script directory (Edit > Preferences > Scripts) when creating a UNIX script.
 +
::*If specified, a cd to this path will be generated prior to launching AskPlus.
 +
::*This option is useful when "-u" is used in the AskPlus run parameters without using "-a".  The "-a" option will activate the directory path stored in the specified profile.
 +
 
 +
:'''Fixes:'''
 +
:*Fixed issue when "Add Linked Topic" button was grayed out when it should have been enabled.
 +
:*List column name is automatically created when using the Expression Builder or the List Item Options dialog to create the column.
 +
:*Fix unhandled exception if the configured Download path is not accessible when starting Visimage3.
 +
::(User may choose to enter configuration and update the path or exit the program.)
 +
:*Fix unhandled exception when generating code for an "empty" report design.

Latest revision as of 15:53, 24 March 2023

Visimage3 Release History

See release history of previous versions.

Version 3.4.2.3

Production Version Released March 24, 2023
Fixes:
  • Fix an issue enabling batch access when the default port was used in the connection. (Bug introduced in version 3.4.2.2)
  • Modify codegen to no longer use an edit mask when generating automatic counts to host SD files. The mask could potentially cause an issue when creating an Excel column from this field.
  • Fix an issue when creating Excel files with a column formatted using a mask like "$$$,$$9.99-". (Bug introduced in version 3.4.2.2)
  • Fix an abort when opening a context with no selected output.
  • Fix a very rare issue trying to start multiple copies of Visimage3 (one in batch and one interactive.)

Version 3.4.2.2

Beta Version Scheduled for Release December 15, 2022
Enhancements:
  • List Designer
  • Added an "Is Key" checkbox to the Item Options in the List Designer column.
  • The "Is Key" option must now be checked to designate a column as a key when creating SD Indexed files.
  • Previously, sorting caused the column to be used as a key when creating SD Indexed files.
  • Existing contexts will be automatically updated.
  • The List Column Item Options button tooltip (mouse hover) will display the column Format and whether or not the column is a key for SD Indexed files.
  • Task Execution
  • Enhance the GO toolbar button's split (dropdown) menu for "Selection Only" tasks.
  • Banded Excel Output
  • Expand the meaning of "Delete Sheet if it exists" to delete all sheets that match the banded sheet name pattern "<band> Loans" where the banded value does not exist in the current execution list of banded values.
  • This enhancement could cause backwards compatibility issues if other sheets exist that match that pattern but are not banded sheets. For example, a sheet called "All Loans" will be deleted using the previous example, but "All Loans.", or "All LOANS" would not be deleted.
  • Reorder all sheets that match the banded sheet name pattern to match the order of the current set of banded values.
  • Version Information
  • A new Help menu (Version Info) will display current and available release information for Visimage3, AskPlus and VsvTcp.
  • The current Visimage3 version is now displayed on the first welcome dialog.
  • Display the AskPlus version information the first time server is started.
  • An update will be recommended for Visimage3 and/or AskPlus if the current release is at least 18 months old and a newer (general release) has been available for at least 6 months.
  • Support SSH Tunnel Definitions as part of the Visimage3 Connection Information:
  • Feature is hidden by default - to enable, manually add "EnableSSHTunneling=true" to the Visimage3.cfg file.
  • When enabled, each connection definition can optionally include SSH Tunnel Information.
  • Visimage3 supports both sTunnel and PuTTY tunnels.
  • When using PuTTY tunnels, Visimage3 will automatically launch a PuTTY session to enable the tunnel.
  • Miscellaneous
  • Remove the Global Outer Join option in the Selection Advanced Options dialog.
Fixes:
  • Task Execution:
  • Fix a bug while executing "Selection Only" tasks from the Execute Context menu.
  • Fix a code generation bug while creating a UNIX script for host TEMP files that used the append option.
  • Fix an "invalid path error" when a global variable was used as part of the local filename and no path was specified.
  • Fix an intermittent problem "error refreshing local dictionary" that could occur during batch execution.
  • Excel Output:
  • Fix a bug calculating the number of implied decimal points with fields formatted with a percent mask. (eg zz9.99%)
  • Fix a bug when generating sub-total calculations (TF level only). Sub-total was always generated, even if the corresponding Print At was not set.
  • Fix a bug identifying the Excel UsedRange (check the IsBlank property rather than checking the text property which did not work for numbers and formulas.)
  • Do not attempt to load a default value for null data. Leave the cell empty.
  • Data Import:
  • Change the order of the default file types when opening a file in Data Import.
  • Fix several issues when displaying sample values in the main Data Import design tab.
  • Miscellaneous:
  • Reload the System Variable and System Operator lists after starting server.
  • Fix a "parameter error" when starting server failed in some circumstances.
  • The messages for read and select limit reached will be displayed as high priority messages.
  • Improved logic when creating automatic variables in list code generation.
  • Fix several help button links.
  • Display an error message if the AppData/Roaming/Visimage3 folder cannot be created. Previously, Visimage3 exited silently with no error.

Version 3.4.2.1

Production Version Released May 23, 2022
(Beta Version Initially Released January 21, 2022)
Enhancements:
  • Shared selections between tasks:
  • List and report tasks may share the selection of a previous task.
  • The shared selection may be used "as is" or refined by adding additional secondary topics or by adding a criteria or limit.
  • This feature is activated in the Selection > Advanced Options.
  • Watch sample video demonstrating this feature.
  • For simplicity a task may be designated "Execute selection only":
  • This option is located in the Selection > Advanced Options.
  • Choose this option if the selection will be used by other tasks and you do not wish to have any output when the selection is executed.
  • List compute statements support Begin/End sort levels:
  • Similar to the report task, list compute statements can now use levels (previously all list compute statements were executed at the Detail level.)
  • This feature is activated in the List > Options Calculation tab.
  • A new summary option (Current Value) is available to print a variable on a summary line with no automatic summary applied.
  • Watch sample video calculating weighted average APR using this feature.
  • Include Excel Formulas in Excel Output:
  • A list task column can contain an Excel formula. The formula can refer to other columns in the list.
  • In the List column properties choose "Excel Formula" in the Print Options dropdown list.
  • When referring to other columns, enclose the column name in square brackets. For example:
=pmt([APR]/12, [NUM-MTHS]*12, [BALANCE])
  • Visimage3 will include the appropriate cell references when the formula is inserted in the output file.
  • Excel Formula columns are included in Excel Data files and Formatted Excel files. They are ignored in all other output types.
  • Support for Excel Template Files:
  • When generating Excel output you can specify a template (or master file) that is used as the starting file when creating the output.
  • This file is opened, the requested data is appended to the file, and the file is saved with the specified output file name.
  • The output file name should be different from the Template (starting) file name.
  • New List Options:
  • The List options window has been reorganized into 3 tabs for ease of use:
  • New option "Include summary row labels" (General tab):
  • The summary row labels "Tot", "Cnt" etc were always included by default. They can now be removed.
  • New option "Enable sort group levels in compute statements" (Calculation tab):
  • This activates the option described above to allow list compute statements to be calculated on different levels.
  • Other enhancements:
  • The column "Print Conditionally" if logic will be applied to the lowest level sort when "Summary Only" is selected.
  • In local file output, MS Mailmerge was moved to the legacy menu.
  • In host file output, a legacy menu was added for rarely used file types.
Fixes:
  • Improved Excel append data logic that should protect Conditional Formatting and other calculations.
  • Do not generate commas in the edit mask for count summary values in Excel output.
  • In some cases with Formatted Excel output, the insertion of the "Tot" and "Cnt" columns was incorrect. This has been corrected.
  • Fix a bug when appending asd files whose name include a global variable.
  • Improve the path verification for local files that contain global variables in the name.
  • Add missing special operators to the tools menu: UniqueId and IsEven.
  • Handle AskPlus warnings related to !RANGE as errors and customize the messages.
  • Do not used forced type conversion in the Select If code of Data Import.
  • Fix a Data Import VariableScope error message.
  • Rename duplicate global variables while importing tasks from another context.
  • Clear the current values of global variables after exiting server.
  • Exit server prior to exiting Visimage3.

Version 3.4.1.5

Production Version Released December 30, 2021
(Beta Version Initially Released October 22, 2021)
Enhancements:
  • Do not report a "bad path" error if the local filename contains a global variable.
This modification causes a strange error message "SdToX Scratch Open Error" when a bad path is encountered (fixed in 3.4.2.1)
Fixes:
  • Fix an "unhandled exception" when an error occured while getting the list of available local printers.
  • Properly handle invalid sheet names in Excel.
  • Fix a batch error when trying to write a warning message.

Version 3.4.1.4

Beta Version Released August 23, 2021
Enhancements:
  • Added a "-t" option when executing from the command line to echo all logging statements to the stdlist.
(This works when executing from the COMMAND window, but does not seem to work from Automic.)
  • If an error occurs when executing in batch, the last line of the log will always contain the phrase "Visimage3 task execution failed.” If executing via Automic, add this phrase to the list of ERROR_VARIABLES checked by your error routine.
  • Add a new Local File output option for ASD files to use the Heading 1 text (List) or the Field Name text (Report) to generate the column headers. This allows mixed case headers. Local file output only.
  • Move Local Portable SD files to the list of Legacy Output choices.
Fixes:
  • Fix an issue opening older contexts (introduced in version 3.4.1.2 and fixed in 3.4.1.3)
  • Fix a rare bug with duplicated global variables. After duplicating a global variable, the Visimage3 current value of that variable was incorrect. Saving and reopening the context also resolved the issue.
  • Fix a bug when executing in batch mode. Visimage3 execution could hang if a syntax error occurred in a task which was not the last task in the context.
  • Fix a bug when executing in batch mode. An error could sometimes occur when executing a multi-pass task because the Local Dictionary was not ready.

Version 3.4.1.2

Beta Version Released July 15, 2021
Enhancements:
  • Scheduling Visimage3 Tasks
  • The File menu choice was renamed from "Schedule Windows Task" to "Schedule Visimage3 Task"
  • The scheduling Window includes an option to choose between "Windows Task Scheduler" and "Automic"
  • When Automic is selected as the scheduler...
  • A "Task log file name" can be entered (Default is context_name.log)
  • When "Schedule" is clicked, a text winow is opened... Copy & Paste the contents into the Automic code window.
  • The code includes the syntax to launch Visimage3 followed by a "type" command to echo the results of the log file
  • If an error occurs while executing the task, Visimage3 will exit with an error code
  • Edit Preferences (General Tab) includes a default scheduler option (Windows Task Scheduler / Automic)
  • Misc Enhancements:
  • Add a "log=filename" parameter when launching Visimage3 tasks in Windows. This parm allows Automic to display the results of the Visimage3 task execution in it's results tab.
  • Several missing System Variables and Operators were added to the Tool Windows.
  • Add a check box to immediately view the results when generating a UNIX script file.
Fixes:
  • Fix an issue with calculated headers in Formatted Excel output (if a subsequent list did not have a calculated header, the wrong header was shown)
  • Fix a variety of issues with Formatted Excel sheet banding.
  • Change the default for sheet banding to false.
  • Fix an issue when testing a new connection from the initial setup dialogs.
  • Fix a script code generation issue (MAKETEMP commands were missing in some cases)
  • Add missing Cut/Copy/Paste short-cut keys to the list column name field

Version 3.4.1.1

Beta Version Released April 2, 2021
Enhancements:
  • List Task - Formatted Excel Output
  • Enhanced to include a Sheet Banding Option
  • When enabled, formatted Excel output is generated on multiple Excel work sheets (one work sheet for each unique value in the banding column.)
  • The left most (highest level) sort is automatically selected as the banding column.
  • Include the current banding value on the list header or the sheet name using <band>.
  • For example, when banding by BRANCH, use "Branch <band>" as the sheet name
  • In the header, use "Loan results for branch <band>"

Version 3.4.1.0

Production Version Released February 10, 2021
Overview of Main Enhancements:
  • Previous beta version now in production release.
  • New List > Output type: Formatted Excel Output with Sub-totals: Watch video.
  • Excel output which closely resembles display output with sorts and sub-totals.
  • Automatically uses the Excel SUBTOTAL() function to display sub-totals.
  • Previous Excel Output type renamed to Excel Data File.
  • New Admin menu for Visimage3 administrators: Watch video.
  • Requires vsrvTCP version 4.9.2.3 (or higher).
  • Edit and rebuild user macro definitions.
  • Create and delete Visimage3 users for your Credit Union.
  • Password resets for other users in your Credit Union.
  • Available to all sites including Fiserv ASP clients if appropriate vsrvTCP version is installed.
Enhancements:
  • Support Calculated List Headers in Formatted Excel output.
  • Support global variables in Excel sheet name. For example "Loans as of #E-DATE".
Fixes:
  • Fix a Data Import bug when importing a delimited file. Only the Tab delimiter was working correctly.

Version 3.4.0.12

Beta Version Released February 2, 2021
Enhancements:
  • Make additional improvements to the task request dialog shared by Execute Context, Create UNIX Script and Schedule Windows Task.
Fixes:
  • Fixed a code generation bug when creating a UNIX script and the first line of code contains an exclamation point. The line was is now prefixed with :DATA (not !DATA).
  • Fixed a code generation bug with a missing # in front of the INSEL and OUTSEL statements when creating a UNIX script.

Version 3.4.0.11

Beta Version Released January 20, 2021
Enhancements:
  • The task request dialog shared by Execute Context, Create UNIX Script and Schedule Windows Task now supports executing the same task multiple times using different output choices. For example, execute the task to a csv file to send to a vendor and then execute the same task to a txt file in another location as a log.
  • A Reset button was added to reset the grid to default values.
  • Use Duplicate to execute a task again.
  • By default, Execute Selection will be set to No for duplicated tasks.
  • Added more consistency checks when OK is clicked.
Fixes:
  • Fixed a bug appending Excel Data to a Used Range or Table when the current range or table is empty.
  • Fixed bold formatting in Formatted Excel Output (not all of the total values were bolded.)

Version 3.4.0.9

Beta Version Released Sep 24, 2020
Fixes:
  • Fix a code generation bug when creating a host Mail Merge file.
  • Fix a bug locating ../VISCONF/usermdef for the Admin > Reload Macro File command.

Version 3.4.0.8

Beta Version Released June 30, 2020
Fixes:
  • Fix a bug in the change password dialog. The new/confirm password fields were not visible.

Version 3.4.0.7

Beta Version Released June 22, 2020
Enhancements:
  • Admin commands for Delete User and Reset Password will display list of existing users.
  • Admin privileges can be given to new users and can be added/removed when resetting passwords.
  • There is a maximum of 3 admin users per Financial Institution.
Fixes:
  • Fix a bug that Global Variables were not imported when importing a task from another context.
  • Fix unhandled exception when opening a context (JobParm structure could point to an undefined output structure.).

Version 3.4.0.6

Beta Version Released May 22, 2020
Enhancements:
  • Automatically restart server when a new connection is selected and the server is already started.
Fixes:
  • Fix unhandled exception when generating Report output to anything other than Display.

Version 3.4.0.5

Beta Version Released Apr 9, 2020
Enhancements:
  • New "Formatted Excel" Local File output for List tasks:
  • Only available for List Task Local file output
  • Output will closely match Display output with sort breaks (grouping) and sub-totals
  • Groups are created for all sorts that have at least one summary associated with that sort break
  • Sort values in grouped columns are not repeated unless specifically requested in the sort window
  • Summary row sort values are always repeated and therefore a sub-total calculation (count, total, …) cannot be displayed in the sorted column for that sort break.
(For example, in a list sorted by COLLATERAL, you cannot count the COLLATERAL column and also total the BALANCE column with sub-totals for each collateral code.)
  • The "Count Sort" summary is ignored (there is no equivalent in Excel)
  • Plain text page headers can be included in the formatted output (calculated headers using an expression are not supported)
  • If no entries are selected, the List Options "No Entries Message" will be written to the output file.
  • The local file options "Excel (.xls)" and "Excel (.xlsx)" have been consolidated using the name "Excel Data File"
  • Functionality has not changed, just the name.
  • Default extension is xlsx, but xls can be forced by typing the extension.
  • Rename "Print (.prn)" output to "Text File" for both host and Local files
  • Functionality has not changed, just the name.
  • For new Ascii output (Host/Local Text Files and Printers), the value of "Chars per Line" will default to the current Display output "Chars per Line"
  • CCTL is now available as an option for Host Text File (Print) output
  • Add "Add to Topics" option for host Text File (Print) output
  • Using SD Indexed or Self Describing files is still preferred for multi-pass reporting
  • This option should be used only when multiple levels are required in the created host file.
  • Tooltip for global variables will display the current value if the variable has been initialized at least once.
  • List Summary Dialog OK button is grayed out until a summary and at least one "Print At" value have been selected.
  • New default script directory (Edit > Preferences > Scripts) when creating a UNIX script.
  • If specified, a cd to this path will be generated prior to launching AskPlus.
  • This option is useful when "-u" is used in the AskPlus run parameters without using "-a". The "-a" option will activate the directory path stored in the specified profile.
Fixes:
  • Fixed issue when "Add Linked Topic" button was grayed out when it should have been enabled.
  • List column name is automatically created when using the Expression Builder or the List Item Options dialog to create the column.
  • Fix unhandled exception if the configured Download path is not accessible when starting Visimage3.
(User may choose to enter configuration and update the path or exit the program.)
  • Fix unhandled exception when generating code for an "empty" report design.