Difference between revisions of "Release History"

From Vital Soft Wiki
Jump to: navigation, search
>Johno
(Visimage3 Release History)
(Version 3.4.2.3)
 
(155 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.12 - Released October 7th, 2014 ===
+
=== Version 3.4.2.3 ===
 +
:'''Production Version Released March 24, 2023'''
  
 
:'''Fixes:'''
 
:'''Fixes:'''
:* Fix a null object violation when adding a column to a list containing variables.
+
:* Fix an issue enabling batch access when the default port was used in the connection. (Bug introduced in version 3.4.2.2)
:* Improve the "No Key Defined" error message.
+
:* 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.
:* Remove the Ctrl-X short-cut and replace with Alt-F4.
+
:* 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)
:* Add the F4 short-cut to open the item list.
+
:* Fix an abort when opening a context with no selected output.
:* Fix a bug handling the AskPlus Prompt: ITEM is a member of these sets, which one do you want to use?
+
:* Fix a very rare issue trying to start multiple copies of Visimage3 (one in batch and one interactive.)
:* Fix bug selecting an ITEM into an empty Report Sort window.
 
  
=== Version 3.1.1.11 - Released October 3rd, 2014 ===
+
=== 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.
 +
<!-- 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:'''
:* Save ''Report Field'' Summary options in the context file.
+
:* Task Execution:
:* Add the Average option to the ''Report Field'' Summary options
+
::* Fix a bug while executing "Selection Only" tasks from the Execute Context menu.
:* 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 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:'''
:* Interrupt Selection
+
:* '''Shared selections between tasks:'''
:* List Designer Options - New option to print a message (using First Page lines) when no entries qualify in the selection
+
::* List and report tasks may share the selection of a previous task.
:* Usability Improvements
+
::* The shared selection may be used "as is" or refined by adding additional secondary topics or by adding a criteria or limit.
::* Right-clicking a context and selecting Open (or double-clicking) will open Visimage3 with the context open.
+
::* This feature is activated in the Selection > Advanced Options.
:::(The first time you will have to teach windows to associate ''.ctx'' with Visimage3)
+
::* Watch [https://vimeo.com/vitalsoft/shared-selections sample video] demonstrating this feature.
::* Most dialogs will be closed with Enter (OK) or Esc (Cancel)
+
::* For simplicity a task may be designated "Execute selection only":
::* When selecting items from an array, double-clicking an item will select that one item
+
:::* This option is located in the Selection > Advanced Options.
::* Main menus can be opened using the Alt key (For example, Alt-F opens the File menu)
+
:::* 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.
::* The following shortcuts have been added:
+
:* '''List compute statements support Begin/End sort levels:'''
::::{| class = "wikitable"
+
::* Similar to the report task, list compute statements can now use levels (previously all list compute statements were executed at the Detail level.)
! style="text-align:left;"| Shortcut Key
+
::* This feature is activated in the List > Options Calculation tab.
! style="text-align:left;"|Action
+
::* 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.
|Ctrl-G+S||Execute (Go) - Selection
+
:* '''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.
|Ctrl-G+T||Execute (Go) - Task
+
::* 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:
|Ctrl-G+C||Execute (Go) - Context
+
::: =pmt([APR]/12, [NUM-MTHS]*12, [BALANCE])
|-
+
::* Visimage3 will include the appropriate cell references when the formula is inserted in the output file.
|Ctrl-N+L||New Context with List
+
::* 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:'''
|Ctrl-N+R||New Context with Report
+
::* 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.
|Ctrl-O||Open Context
+
::* The output file name should be different from the Template (starting) file name.
|-
+
:* '''New List Options:'''
|Ctrl-P||Output (List / Report)
+
::* The List options window has been reorganized into 3 tabs for ease of use:
|-
+
:::* New option "Include summary row labels" (General tab):
|Ctrl-S||Save Context
+
::::* 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):
|Ctrl-X||Exit
+
::::* This activates the option described above to allow list compute statements to be calculated on different levels.
|-
+
:* '''Other enhancements:'''
|Ctrl-Y||Interrupt Selection
+
::* 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.
|Ctrl-Z||Undo
+
::* In host file output, a legacy menu was added for rarely used file types.
|-
 
|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 ===
+
:'''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:'''
:* Server
+
:* Fix an "unhandled exception" when an error occured while getting the list of available local printers.
::* Fix bug when testing a new connection (existing connections worked)
+
:* Properly handle invalid sheet names in Excel.
::* Refresh the local dictionary when an error occurs executing the saved Open/Close commands (Manage Databases)
+
:* Fix a batch error when trying to write a warning message.
 +
 
 +
=== Version 3.4.1.4 ===
 +
:'''Beta Version Released August 23, 2021'''
  
 
:'''Enhancements:'''
 
:'''Enhancements:'''
:* Server (Connection to AskPlus)
+
:* Added a "-t" option when executing from the command line to echo all logging statements to the stdlist.
::* Better detection of server problems when AskPlus exits prematurely
+
::(This works when executing from the COMMAND window, but does not seem to work from Automic.)
::* Better handling of Tcp/ip timeouts
+
:* 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.
:* List Designer:
+
:* 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.
::* Add menu choices to move columns left and right
+
:* Move Local Portable SD files to the list of Legacy Output choices.
::* Add a List > Column menu to the main menubar
 
:* Other
 
::* Tool Windows (Item, Macro, Variable Lists) can be pinned open
 
::* Status bar has been updated and provides more feedback including the current output.
 
  
=== Version 3.1.1.9 - Released September 12, 2014 ===
+
:'''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:'''
 
:'''Fixes:'''
:* Execution to Local File:
+
:* 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)
::* A bug that did not correctly purge the local file (and continue execution) when the user clicked OK has been fixed.
+
:* Fix a variety of issues with Formatted Excel sheet banding.
::* Improve the error message, when the local file name is an existing directory
+
:* Change the default for sheet banding to false.
:* Properly refresh the secondary topic list when duplicating a Task
+
:* 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:'''
 
:'''Enhancements:'''
:* Start Server Enhancements:
+
:* List Task - Formatted Excel Output
::* Encrypted password support
+
::* Enhanced to include a Sheet Banding Option
::* Ability to change passwords (Edit Connections)
+
::* When enabled, formatted Excel output is generated on multiple Excel work sheets (one work sheet for each unique value in the banding column.)
::* Ability to test a connection (Edit Connections)
+
::* 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>"
  
:*Job/Task Creation Enhancements:
+
=== Version 3.4.1.0 ===
::* Adding header/trailer files to the job output
+
:'''Production Version Released February 10, 2021'''
::* UC4 Integration
 
::* Add "-b" to the /ASKPLUS/askplus line in the created job
 
  
:'''Miscellaneous:'''
+
:'''Overview of Main Enhancements:'''
:* Allow the menu choice ''Report > Sort'' to be accessed from the ''Selection'' tab
+
:* Previous beta version now in production release.
:* Change the default name of a host/local file from temp to vistemp
+
:* 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:'''
 +
:* Fix a '''Data Import''' bug when importing a delimited file.  Only the Tab delimiter was working correctly.
  
=== Version 3.1.1.8 - Released August 26, 2014 ===
+
=== Version 3.4.0.12 ===
 +
:'''Beta Version Released February 2, 2021'''
  
 
:'''Enhancements:'''
 
:'''Enhancements:'''
:* Add ''List Designer'' support.
+
:* Make additional improvements to the task request dialog shared by ''Execute Context'', ''Create UNIX Script'' and ''Schedule Windows Task''.  
::* List Designer is fully supported
+
 
::* Contexts can include both Lists & Reports
+
:'''Fixes:'''
::* Lists can contain Variables (compute statements are all executed at the Detail level)
+
:* 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''').
::* Select If cannot be used on columns that involve a variable
+
:* Fixed a code generation bug with a missing # in front of the INSEL and OUTSEL statements when creating a UNIX script.
:* Task Creation:
 
::* UC4 Header / Trailer support has been added
 
::* Task Header / Trailer support has been added
 
:* Edit Preferences
 
::* Set ''Uses UC4'' as default for all new Tasks
 
;;* 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 ===
+
=== 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:'''
 
:'''Fixes:'''
:* Correct an error that prevented  ''Edit > Connections'' from opening.
+
:* Fixed a bug appending Excel Data to a ''Used Range'' or ''Table'' when the current range or table is empty.
:: (This bug prevented 1st time users from configuring a connection.)
+
:* Fixed bold formatting in Formatted Excel Output (not all of the total values were bolded.)  
  
=== Version 3.1.1.6 - Released July 25, 2014 ===
+
=== Version 3.4.0.9 ===
 +
:'''Beta Version Released Sep 24, 2020'''
  
 
:'''Fixes:'''
 
:'''Fixes:'''
:* Correct ''Fully Qualified Name'' issue (BASE.SET.BASE.SET.ITEM(1)) when inserting array items.
+
:* Fix a code generation bug when creating a host Mail Merge file.
:* Fix bug when reading a selection compute statement from a ctx file.
+
:* Fix a bug locating ../VISCONF/usermdef for the Admin > Reload Macro File command.
:* 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.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:'''
 
:'''Enhancements:'''
:* Add support for ''Duplicate Task''.
+
:*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.
  
=== Version 3.1.1.5 - Released July 18, 2014 ===
+
:'''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.).
  
:'''Fixes:'''
+
=== Version 3.4.0.6 ===
:* Show the fully qualified domain (or file) name in Manage Host Databases.
+
:'''Beta Version Released May 22, 2020'''
:: For example, display membrs.report as the fullname when the month end database has been opened.
 
:* 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)
 
:* Disable ''Interrupt Task'' in the ''Server'' menu
 
:* Move ''Manage Databases'' from ''Report > Advanced'' to the ''View'' menu
 
:* Move ''Convert List to Report'' from ''Report > Advanced'' to the ''List'' menu
 
:* Other cosmetic fixes (and spelling errors)
 
  
=== Version 3.1.1.4 - Released July 16, 2014 ===
 
 
:'''Enhancements:'''
 
:'''Enhancements:'''
:* Add new tool window (list) for System Variables
+
:*Automatically restart server when a new connection is selected and the server is already started.
:* Support Select / Drag&Drop for System Variables
 
:* Support Select / Drag&Drop for Operators and Functions
 
:* 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 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.
  
=== Version 3.1.1.3 - Released July 11, 2014 ===
 
 
:'''Fixes:'''
 
:'''Fixes:'''
:* Fix Open error when opening large context files
+
:*Fixed issue when "Add Linked Topic" button was grayed out when it should have been enabled.
:* Report Options not being displayed.
+
:*List column name is automatically created when using the Expression Builder or the List Item Options dialog to create the column.
:* Job Creation, default directory is now Downloads
+
:*Fix unhandled exception if the configured Download path is not accessible when starting Visimage3.
:* Job Creation, OK btn enabled after using Browse button
+
::(User may choose to enter configuration and update the path or exit the program.)
:* Include Comment Level when loading compute statements
+
:*Fix unhandled exception when generating code for an "empty" report design.
:* 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 ===
 
:'''Initial Beta Version'''
 

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.