Release History

Visimage3 Release History

See release history of previous versions.

Version 3.4.2.2

Beta Version Scheduled for Release December 12, 2022

Enhancements:

• List Designer

• Added an "Is Key" checkbox to the Item Options in the List Designer column

• Previously, sorting a column caused the column to be used as a key when creating SD Indexed files.
• The "Is Key" field must now be checked to create a column as a key.
• Existing contexts will be automatically updated.

• Task Execution

• Enhance the GO toolbar button's split menu to provide better feedback

• Banded Excel Output

• Expand the meaning of "Delete Sheet if it exists" to delete any 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
• Reorder all sheets that match the banded sheet name pattern to match the order of the current set of banded values.

• Version Information

• The current Visimage3 version is displayed on the first welcome dialog.
• An update will be recommended if the current release is at least 18 months old and a newer (general release) has been available for at least 6 months.
• A new Help menu (Version Info) will display current and available release information for Visimage3, AskPlus and VsvTcp.

• Encrypted Connections:

• Add support for using PuTTY tunnels to encrypt traffic (similar to sTunnel)
• Feature is hidden by default - to enable, manually add "EnableSSHTunneling=true" to the Visimage3.cfg file

• Miscellaneous

• Remove the Global Outer Join option in the Selection Advanced Options dialog.
• Display the AskPlus version information the first time server is started. An update will be recommended if the current release is at least 18 months old and a newer (general release) has been available for at least 6 months.
• The List Column Item Options button tooltip (mouse hover) will display the Format and whether or not the column is a key for SD Indexed files.
• After starting server, display a message if the user password will expire in less than 10 days. This enhancement requires VsrvTcp version x.y to be installed on the host.

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 using 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

• 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.b-totals at TF only
• 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

• Batch Execution:

• Fix intermittent problem "error refreshing local dictionary."

• 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 exeited 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.