Announcement

Collapse
No announcement yet.

Valence 5.2+ (All Builds)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Valence 5.2+ (All Builds)

    Versions:

    5.2.20200819, released on August, 19, 2020
    5.2.20200720, released on July 20, 2020
    5.2.20200630, released on June 30, 2020
    5.2.20200608, released on June 8, 2020
    5.2.20200526, released on May 26, 2020
    5.2.20200415, released on April 15, 2020
    5.2.20200323, released on March 23, 2020
    5.2.20200212, released on February 12, 2020
    5.2.20191218, released on December 18, 2019
    5.2.20190918, released on September 18, 2019
    5.2.20190822, released on August 22, 2019
    5.2.20190723, released on July 23, 2019
    5.2.20190630, released on June 30, 2019
    5.2.20190619, released on June 19, 2019
    5.2.20190528, released on May 28, 2019

    About Release Notes:

    These release notes are intended to document what has been added, changed and fixed in Valence Framework 5.2+ since the last 5.2 release and provide general information about the Valence Framework.

    Why Valence 5.2 "Plus"?
    We originally planned this release to be Valence 5.3. However we have many customers that prefer not to switch major release numbers frequently, so we decided to give them a break this time around! Our new Valence 5.2+ loads as an update to previous Valence 5.2 installs, but you get all the new features originally planned for a new major release number, hence the "plus".

    Licensing:

    By obtaining and using the Valence Framework, it is your responsibility to ensure that you and your company are following the proper licensing terms of the product. Be sure to review the licensing options on the Valence Pricing page and also review the Licensing and Support FAQs page before downloading and using the Valence Framework.

    Installing This Release:
    • Go to the downloads page to see what releases are available. If this release is superseded by another release it may no longer be available.
    • If this release is available for download then click the link to the download installation file. Be sure to download the correct version of the installer for your PC operating system and for your IBM i OS (V5R4 through 7.3). Sites running on IBM i 7.4 and use the 7.3 build.
    • It is highly recommend that you perform the installation from a PC or Mac that is on the same internal network as your IBM i. Performing the installation through a slow WAN connection or via a VPN connection may work but can take many hours to install.
    • The download is a zip file. To launch the installer extract the zip file and double click on the ValenceInstall.exe file on your Windows PC, or launch the ValenceInstall.app file on your Mac. Follow the prompts to install Valence Framework 5.2 onto your IBM i. Note that you may need administrative rights on your PC or Mac to launch the installer.
    • It is highly recommended that you use QSECOFR to perform the installation to avoid permissions issues.
    • This release will install to library VALENCE52 and ifs path /valence-5.2. It will also install an Apache server instance named VALENCE52.
    • If you have Valence Framework versions 5.1 and prior installed on your system you may install this release without affecting those earlier versions.
    • Once installed you can access the Valence Portal with the link http://xxx.xxx.xxx.xxx:7052 where xxx.xxx.xxx.xxx is the IP address of your IBM i. Port 7052 is the default installation port for Valence Framework 5.2. You can use Advanced Settings to change the port number at installation time.
    • The default user for administrative login to the portal after installation is vvadmin with password vvadmin. However you may also log in with any valid IBM i profile.
    • If using the vvadmin profile, it is highly recommended that you go into the Portal Admin app in the Valence Portal and add an IBM i user cross reference to vvadmin with security officer authority (like QSECOFR) so you will not have permissions issues.

    Changes Pending for the Next Build:
    • NAB: Corrected issue with initial value on a checkbox filter not being applied
    • NAB: Adjusted parser to preserve quotes surrounding aliased column names / reserve words
    • NAB (mobile): Corrected issue where form fields in error would not disable primary button
    • RPG Toolkit: vvUtility_parseIntoCharArray - corrected issue that would cause final element to be omitted if only one character long

    New Features and Fixes in 5.2.20200819:
    • NAB: Timeline widget - added grouping field option
    • NAB: Grid widget - corrected issue where action buttons could sometimes not be disabled on infinite scroll grids when no row selected
    • NAB: Excel download - ensure decimal values in spreadsheet follow grid renderer config
    • NAB: General - added a cache buster to all CSS files
    • VVRMTDB - Adjusted batch job to use library list of Valence environment rather then core Valence library

    New Features and Fixes in 5.2.20200720:
    • NAB: Excel/PDF download - Blank values in grid widget custom renderers are now honored in Excel and PDF downloads
    • NAB: Excel download - Corrected issue that could cause date column values to be off by one day under certain circumstances
    • NAB: Excel download - Corrected issue that could cause Excel download on grouped grids to not generate
    • NAB: Grid widget - Adjusted to ensure numeric cell values are not mistakenly treated as phone numbers on mobile devices
    • NAB: Grid widget - Corrected issue where filters could disappear upon maintenance in NAB Designer
    • NAB: Grid widget - Corrected issue that could cause group subtotals to not appear under certain circumstances
    • NAB: Grid widget - Corrected issue affecting older TR levels on 7.1 and 7.2 where paging would not work correctly (in VVOUT)
    • (.1 build) NAB: Grid widget - Adjusted to accommodate CSS bug introduced by latest Windows/Chrome update that was causing grids to show no data
    • (.1 build) NAB: Edit Grid widget - Corrected issue where grids using infinite scroll feature could have buttons not disable after updating a record
    • Fusion5250: Adjusted VVFUSIONP job to reflect the IBM i user ID associated with the interactive 5250 job
    • Fusion5250: Improved cursor positioning logic in PDM, etc.
    • Examples: Paging grid - adjusted back-end search logic to properly escape single quotes

    New Features and Fixes in 5.2.20200630:
    • NAB: Excel download - Corrected issue with improper time zone adjustment being applied to timestamp columns
    • NAB: SQL parser - added support for OPTIMIZE FOR clauses
    • NAB: App import - Adjusted to preserve category of imported apps when a match by name can be made, otherwise app goes into default category ("Uncategorized")
    • NAB: Widget filters - corrected issue where original widget filter could be lost after another user filter is subsequently applied
    • NAB: Grid widget - corrected issue where overriding the grouping column would result in an incorrect column heading and have the pdf/excel document reflect the overridden grouping column
    • NAB: Grid widget - fixed bug where column sequence could be incorrect when it has 50 or more columns
    • NAB: Grid widget - corrected issue where a column containing a summary function could be included in the WHERE clause of a global search, resulting in an SQL error
    • Fusion5250 - improved edit-checking and handling of double byte character fields
    • RPG Toolkit: vvJSON - adjusted to properly escape double quotes inside segments containing a mix of single byte and double byte characters
    • RPG Toolkit: vvOut_execSQLtoJSON - auto append OPTIMIZE FOR clause to improve performance on paging grids w/ asensitive cursor; Can be superseded by new vvOut.optimizeClause field
    • RPG Toolkit: vvOut_initialize - for systems below IBM i OS 7.3, check for SQL OFFSET clause support is now done once per job, rather than once per activation group. This will reduce "Y in *LIBL type *FILE not found" clutter in the job log.

    New Features and Fixes in 5.2.20200608:
    • NAB: RPG programs can now enable/disable widget components
    • NAB: Widget filters - for "between" filters over dates, blank filter values are now treated as '0001-01-01' or '9999-12-31'
    • NAB: Form widget - now uses the Valence date format on all date fields
    • NAB: SQL parser - added support for table joins based on a subquery
    • NAB: Pivot Grid widget - corrected issue that could cause cell color rules to not be followed
    • RPG Toolkit: vvOut_execSQLtoJSON - corrected issue where count statements could be thrown off by a LEFT JOIN or an unexpected GROUP BY clause in the SQL statement

    New Features and Fixes in 5.2.20200526:
    • NAB: Added form helper modes (startup/change/blur)
    • NAB: Added ability to refresh a widget via an App Variable
    • NAB: Popup windows - Can now keep state, vs being destroyed on close
    • NAB: Grid widget - Added time format column rendering options (HH:MM:SS and HH:MM)
    • NAB: Edit Grid widget - Adjusted logic so edit grids cannot be created over SQL-based data sources containing summary functions
    • NAB: Pivot Grid widget - Now fires row click if grid has a filter event and can satisfy the requirements of the filter event, or doesn't have a filter event
    • NAB: Pivot Grid widget - Corrected export bug where column headings were not aligning properly
    • NAB: SQL parser - Added support for "dec" function (short for "decimal")
    • NAB: Excel download - Fixed numeric formatting
    • NAB: Form widget - Corrected issue where combo boxes may not be loaded properly
    • NAB: Import/export - Corrected issue where combo boxes could be dropped on the export
    • NAB: Adjusted filter rules so blanks are treated same as "0" for numeric columns or "0001-01-01" for date columns
    • NAB: Corrected issue where the save of an app containing tabs could result in an error
    • Portal Admin > Settings > NAB: Added two optional paths (URLs) for specifying .css or .js files to be loaded into all NAB apps at runtime
    • Portal Admin > Environments: Prohibit creation of new environments with name that matches an already existing environment
    • RPG Toolkit: vvMail - Corrected issue where port number passed with TLS encryption could be ignored
    • Portal Login: Resolved issue where "Forgot Password" link would fail when logging in with a non-IBM i user ID with password linked to IBM i profile.

    New Features and Fixes in 5.2.20200415:
    • NAB: Form helper can now refresh a dropdown data source
    • NAB: Autofocus now places cursor into first focusable field in popup widget
    • NAB: No longer show a value of zero in a telephone-formatted field
    • NAB: Allow pasting of numbers with commas into number fields
    • NAB: The initial load mask text can now be changed by passing a URL parameter of "nabLoadMask"
    • NAB: Excel / PDF download now accommodate number calculations inside a column's "custom formatting" value
    • NAB: Encrypt summary SQL if encrypt is turned on in Portal Admin/Settings
    • NAB: Form widgets now accommodate text areas (via formatting option)
    • NAB: Corrected minor issues with app import/export
    • NAB: [BETA] Added new "script" feature for adding/running custom JavaScript on a user behavior
    • Desktop Portal: [BETA] Added two factor authentication (2FA) option
    • Fusion5250: Added ability to copy/paste blocks of text
    • Fusion5250: Added ability to override frontend SSL setting
    • Fusion5250: Improved Japanese compatibility
    • RPG Toolkit: vvIn_Sorters - corrected bug affecting sorting over grouped grids
    • Portal Admin > Settings: Corrected bug that would cause Settings to not list at all when "Show hidden settings" not checked (.1 build)
    Note: [BETA] features are not yet documented and can only be used if "Enable Beta Features" is activated in Portal Admin > Settings. These will become permanent, documented features in the forthcoming Valence 6.0 release.


    New Features and Fixes in 5.2.20200323:
    • Fusion5250: Licensing cost for the Valence Core with Fusion5250 is now free during the coronavirus pandemic. Read our March 20, 2020 blog post for more information
    • NAB: Added better fault checking on App/Widget/Data Source import
    • NAB: Added localization support for Valence-supported languages to the Timeline widget
    • NAB: Added fixed width option on widgets
    • NAB: Adjusted to derive proper display size for integer columns in SQL-based data sources
    • NAB: Added "Auto Refresh Interval" to Form, Map and Tile widgets
    • NAB: Fixed call RPG Program/URL "Prompt User For More Information" when it has more than one dropdown
    • NAB: Fixed Hide/Show Widgets "Refresh Data"
    • NAB: Added Unchecked/Checked/Both configuration to checkbox filters on grid widgets
    • Portal: Allow change password functionality on Valence profiles linked to different IBM i profiles when "Use IBM i Password" option is checked, provided IBM i user ID is not linked to any other Valence profiles
    • Portal: Chrome - fixed end session on close of the browser/browser tab
    • Installer: Ensure QTMHHTTP has proper access to certs required for running Fusion5250 under SSL

    New Features and Fixes in 5.2.20200212:
    • NAB: Improved editor for Tile widget configuration
    • NAB: Adjusted Behaviors so that button text is no longer automatically upper-cased
    • NAB: Added support for summary functions over data sources containing WITH clauses
    • NAB: Adjusted document upload logic to not give an "invalid extension" exception when valid extension(s) had been entered with a leading period
    • NAB: EXNABBTN > GetFilterValue procedure adjusted to check for both "F1." and "F1_" file prefix syntax
    • NAB: Corrected issue where data source caching was not always working correctly
    • NAB: Corrected issue where ability to add an icon button to a grid was not available if grid already contained a menu button
    • NAB: Corrected issue where app import could go into an endless loop condition
    • Portal Admin > Settings: Added new search mechanism so specific settings can be found more quickly
    • Portal: Added logic to trap and log record locks over VVSESSDATA when killing expired sessions in vvSecure_killSessions
    • RPG Toolkit > VVOUT: Corrected total row count calculation in vvOut_execSQLtoJSON for SQL statements containing GROUP BY clause (would also affect record counts showing on NAB grids)
    • RPG Toolkit > VVOUT: Added support for insert/update/delete operations against remote DB connections in vvOut_execSQLtoJSON
    • RPG Toolkit > VVUTILITY: corrected overflow issue in parseIntoCharArray that could occur when separator is more than one character

    New Features and Fixes in 5.2.20191218:
    • NAB: Corrected issue where grid checkbox column does not work when the grid has any action attached to its row click
    • NAB: Corrected issue in mobile grid where summary fields were causing data not to load
    • NAB: Corrected issue in Behaviors where the a widget was erroneously showing under the wrong section
    • NAB: Corrected issue where the SQL formatter was inserting a space before '#' in columns that contain the '#' symbol
    • NAB: Added icon column functionality to grids
    • NAB: No longer expands all behaviors by default
    • NAB: Corrected issue with import process where launch app actions were not importing properly
    • NAB: Corrected issue where Call RPG Program > success=true and success=false events are not showing in Behaviors.
    • NAB: Corrected import issue where in rare circumstance app import would show as successful yet the app was not fully imported.
    • NAB: Corrected issue where wizard based data source filters clicking on a field while in sql free-format mode was always injecting a file index of one even if it isn't the first file in the data source.
    • NAB: Corrected issue where KPI widget with empty data source will display incorrectly.
    • NAB: Adjusted SQL parser to support GROUP BY GROUPING SETS
    • Portal Admin > Apps: Added ability to copy NAB apps
    • RPG Toolkit > vvOut_execSQLtoJSON: Adjustments made to improve row count performance (also affects NAB data sources)
    • RPG Toolkit > VVDSEXIT1: expanded size of VVSESSDS field from 999A to 3200A to accommodate larger library list. Affects functionality of vvUtility_callExitPgm.
    • Fusion5250: Added macro recording/saving
    • Fusion5250: Autofocus last focused position when reactivating the application in the portal

    New Features and Fixes in 5.2.20190918:
    • NAB: Adjusted Form widget to prevent auto-filling passwords if input is masked on any form field.
    • NAB: Added ability to force uppercase on form input fields
    • NAB: Added close event to vertical container
    • NAB: Added simple theming support: choose color scheme, adjust widget border width and radius
    • NAB: Added file upload to button call RPG program
    • NAB: added a progress bar option to the KPI widget
    • NAB: added app security to behaviors
    • NAB: Corrected issue where attempting to apply a filter over a very long calculated column (>256 chars) would throw an SQL error
    • NAB: Corrected issue where grid cell colors were not applying to the "boolean" renderer
    • NAB: Corrected issue where grid column sortable:false was not applying when going back into edit mode of the widget
    • NAB: Corrected issue where form field colors were not saving properly when inside a field container
    • NAB: Corrected issue where URL widget presented as a popup was not translating the URL string properly
    • NAB: Corrected issue where close events were not saving properly when attached to a "utility" widget
    • NAB: Corrected issue where the timeline would not load if created from the "Create New App" option on the main data source/widget list.
    • NAB: Corrected issue where the timeline's height wouldn't adjust correctly on mobile if it gets a title set
    • NAB: Corrected issue where pdf download would fail if grid widget is set to infinite scroll
    • NAB: Corrected issue where an exported app containing a widget that launches another app could reference an incorrect or nonexistent app ID on the imported instance
    • NAB: Adjusted import logic to accommodate differences in app names/descriptions between instances when determining app ID to launch
    • NAB: Adjusted default behavior so that when a popup widget shows/filters another popup widget to not automatically close the popup
    • Web Services: Added support for wildcard (*) inside URL. Wildcard value can be retrieved via vvIn_char('vvWildcard')
    • RPG Toolkit - vvOut_data: added optional HTTP status and response text params

    New Features and Fixes in 5.2.20190822:
    • NAB: Introduced new "Tiles" widget
    • NAB: Added mobile support for the new Timeline widget
    • NAB: Fixed issue with Timeline widget's "Auto Load" not being applied
    • NAB: Fixed issue with Timeline widget's "End Data" field not being applied
    • NAB: Adjusted SQL parser to support UNION ALL
    • NAB: Adjusted SQL parser to support LATERAL JOIN
    • NAB: Added option to encode all SQL clauses to avoid firewall blocks
    • NAB: Adjusted "hide zero values" grid column renderer to apply to prefix/suffix values as well
    • NAB: Corrected issue where total row count could be incorrect on complex SQL-based data sources containing WITH clauses
    • NAB: Corrected import logic to accommodate changed IDs
    • NAB: form widget "helper" program to dynamically hide/show/disable/enable/filter/set values of form fields
    • NAB: new response helper procedure to button template program (EXNABBTN) to simplify responses and easily interact with form fields.
    • NAB: ability to mask input for form widget input fields.
    • NAB: provide built in email, phone, ssn#, or URL validation for form widget input fields.
    • NAB: Form widget - rule based text color
    • NAB: Added close application as a utility action.
    • RPG Toolkit - vvUtility_parseIntoCharArray: Adjusted logic to properly handle separators that are greater than one character
    New Features and Fixes in 5.2.20190723:
    • NAB: Introduced new Timeline widget
    • NAB: Added edit grid support for aliased files
    • NAB: Corrected issue where saving of a form widget containing field groups could break under particular circumstances
    • NAB: Corrected problem with "Create App" shortcut on widgets not working properly
    • Fusion5250: Added support for SSL
    • Fusion5250: Added ability to set a workstation naming convention in Portal Admin > Settings. Alternatively you can also use a custom exit program to set the device name.
    • Fusion5250: Corrected conflict with RemoteDB that could sometimes cause the VVFUSIOND Daemon job to go into a MSGW condition.
    • Spool File Viewer: Corrected issue where error messages encountered when attempting to perform actions on spool files would not display properly
    • RPG Toolkit - vvIn_Char(): Added optional third parameter to replace substitution characters (hex 3F) with a blank space. Can also be activated globally via Portal Admin > Settings.
    • RPG Toolkit - vvIn_Body(): Adjusted to limit CCSID conversion to size of data in memory at pointer location to avoid including garbage characters
    • RPG Toolkit - vvIn_base64toFile(): Adjusted to trap IFS errors (previously assumed IFS open and write API calls always succeeded)
    • VVMIGRATE: Corrected issue where portal User records would not migrate from pre 5.2+ instances

    New Features and Fixes in 5.2.20190630:
    • NAB: Corrected edit grid issue where a left-joined file in a data source with a null record would throw a "cannot derive key" error
    • Portal: Corrected issue where an IBM i user logging into the portal for the first time with an expired password could not successfully change password
    • Fusion5250: Adjusted logic to accommodate possible authority restrictions on data queue
    • RemoteDB: Adjusted count logic to accommodate more complex queries containing WITH clause
    • RemoteDB: Added support for Oracle Database connections
    • Nitro AutoCode: Ensure source file and object libraries specified in Settings exist prior to program generation

    New Features and Fixes in 5.2.20190619:
    • NAB: Adjusted SQL parser to support NOT EXISTS
    • NAB: Adjusted SQL parser to support subqueries in lieu of file names in FROM clause
    • NAB: Added ability to set Portal security on URL Widgets
    • NAB: Added inner padding to line chart widget
    • NAB: Adjusted export/import to include tags
    • Portal: Adjusted file VVUSERS -- added new field VVCODEPAGE
    • Portal: Corrected bug that could cause MSGW condition when changing an expired password at login
    • RPG Toolkit - vvSecure: Adjusted SendInvalidSidError routine to accommodate non-CGI calls (i.e., from PHP, Fusion, etc)
    • RPG Toolkit - vvUtility: Corrected problem where using _getSessVar with deprecated VVSESSVAR method would cause some session fields to return as blank
    • Fusion5250: Added many new code pages (total of 22 now supported)
    • Fusion5250: Portal Admin > Languages now has a default setting for each language code page (CCSID). Code pages overrides for individual users can also be set in file VVUSERS via field VVCODEPAGE. Ability to edit vial Portal Admin > Users is coming on the next build.
    • Fusion5250: Significantly improved performance in screen rendering (up to 300% faster)
    • Fusion5250: Ensure Daemon and Proxy jobs are submitted with user associated with the Fusion JOBD, not the user sparking its launch
    • Fusion5250: Improved overall reliability with various bug fixes
    • Fusion5250: Note that Fusion5250 is still considered BETA--general release is expected next month (July 2019)

    New Features in Valence 5.2+ (5.2.20190528 initial build):
    • New Key Feature: Introducing Fusion5250, a unique emulator-like Valence app which allows any legacy program that normally runs on a 5250 terminal emulator to run in the browser within the Valence Portal. No recompiling of your legacy programs is necessary. No source code for your legacy programs is necessary. Install Valence 5.2+ and it just works.
    • NAB: added ability to quickly create application from an individual widget
    • NAB: added ability to override SQL sort sequence at the data source level
    • NAB: corrected issue where a super large number of selected fields in a form could cause the save to fail
    • NAB: corrected issue where an abnormally large number of filter items in a widget could cause the save to fail due to truncation
    • NAB: Corrected issue where grid would show incorrect total row count on complex SQL statements including a WITH clause (.1 build)
    • Portal Admin > Settings: Added SRTSEQ override for vvOut.execSQLtoJSON (default is *LANGIDSHR)
    • Portal Admin > Languages: Added code page default for Fusion5250 (added VVCODEPAGE to file VVLNGS)
    • RPG Toolkit - VVOUT: Sort Sequence (SRTSEQ) used in execSQLtoJSON can now be overridden via Portal Admin setting or vvOut.srtseq parameter
    • RPG Toolkit - VVOUT: Improved reliability of record set count procedure used in conjunction with execSQLtoJSON and asensitive cursors
    • RPG Toolkit - VVOUT: Improved performance on paging through very large files with execSQLtoJSON and asensitive cursors
    • RPG Toolkit - VVPDF: Added barcode support
    • RPG Toolkit - VVUTILITY: Adjusted _encode() routine to escape tabs and substitute characters
    • Instance Manager: Adjusted to ensure instance update routine always uses BASE instance VVINSTUPD program, regardless of calling instance
    • Fusion5250: Fixed popup window positioning -- was off to the left by 1 column (.1 build)
    • Fusion5250: Fixed a problem where occasionally websocket negotiation would fail on some browsers (.1)
    • Fusion5250: Corrected rendering issues that could arise with custom window borders (.1)

    System Requirements:
    • Any hardware running the IBM i operating system V5R4 or higher (V7R1+ highly recommended). For installation of Valence Framework 5.2 to your IBM i, a PC running any newer version of Windows or a Mac running any newer version of OS X is required.
    • The client computer utilizing Valence apps can be Mac OS X, Windows, Unix, Linux, iPhone, iPad, Android, Blackberry and virtually any hardware that has a compatible browser.
    • To use Valence on iOS devices, install the Valence Portal from the Apple App Store
    • To use Valence on Android devices, install the Valence Portal from the Google Play Store
    Uninstalling Valence Framework 5.2:
    • Follow these instructions if you previously installed this release and would like to completely remove it from your system:
    • Log onto a 5250 session as QSECOFR or another profile with security officer authority.
    • End the VALENCE52 Apache server instance with command "ENDTCPSVR SERVER(*HTTP) HTTPSVR(VALENCE52)".
    • Before continuing, be certain there are no users and/or developers with a lock on the VALENCE52 library with command "WRKOBJLCK OBJ(VALENCE52) OBJTYPE(*LIB)". If there are any jobs listed, cancel them or ask the users/developers to exit.
    • Delete the VALENCE52 library with command "DLTLIB LIB(VALENCE52)".
    • Delete the IFS folder named /valence-5.2 and all subfolders and files. The easiest way to do this is to start with command "WRKLNK /" then use option 2 against the root folder, then option 9 (recursive delete) against the /valence-5.2 folder.
    • Delete the VALENCE52 Apache server instance by navigating with your browser to http://support@cnxcorp.com or call CNX at (312) 477-7450.
    Last edited by robert.swanson; 09-11-2020, 11:20 AM.

  • #2
    Valence Framework 5.2.20190528.0 (Valence 5.2+) is now available. Changes in this build since the previous release are:
    • New Key Feature: Introducing Fusion5250, a unique emulator-like Valence app which allows any legacy program that normally runs on a 5250 terminal emulator to run in the browser within the Valence Portal. No recompiling of your legacy programs is necessary. No source code for your legacy programs is necessary. Install Valence 5.2+ and it just works.
    • NAB: added ability to quickly create application from an individual widget
    • NAB: added ability to override SQL sort sequence at the data source level
    • NAB: corrected issue where a super large number of selected fields in a form could cause the save to fail
    • NAB: corrected issue where an abnormally large number of filter items in a widget could cause the save to fail due to truncation
    • Portal Admin > Settings: Added SRTSEQ override for vvOut.execSQLtoJSON (default is *LANGIDSHR)
    • RPG Toolkit - VVOUT: Sort Sequence (SRTSEQ) used in execSQLtoJSON can now be overridden via Portal Admin setting or vvOut.srtseq parameter
    • RPG Toolkit - VVOUT: Improved reliability of record set count procedure used in conjunction with execSQLtoJSON and asensitive cursors
    • RPG Toolkit - VVOUT: Improved performance on paging through very large files with execSQLtoJSON and asensitive cursors
    • RPG Toolkit - VVPDF: Added barcode support
    • RPG Toolkit - VVUTILITY: Adjusted _encode() routine to escape tabs and substitute characters
    • Instance Manager: Adjusted to ensure instance update routine always uses BASE instance VVINSTUPD program, regardless of calling instance
    Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

    Go to http://forums.cnxcorp.com/node/12708 for full release notes.
    Last edited by robert.swanson; 09-11-2020, 11:20 AM.

    Comment


    • #3
      Valence Framework 5.2.20190619 (Valence 5.2+) is now available. Changes in this build since the previous release are:
      • NAB: Adjusted SQL parser to support NOT EXISTS
      • NAB: Adjusted SQL parser to support subqueries in lieu of file names in FROM clause
      • NAB: Added ability to set Portal security on URL Widgets
      • NAB: Added inner padding to line chart widget
      • NAB: Adjusted export/import to include tags
      • Portal: Corrected bug that could cause MSGW condition when changing an expired password at login
      • RPG Toolkit - vvSecure: Adjusted SendInvalidSidError routine to accommodate non-CGI calls (i.e., from PHP, Fusion, etc)
      • RPG Toolkit - vvUtility: Corrected problem where using _getSessVar with deprecated VVSESSVAR method would cause some session fields to return as blank
      • Fusion5250: Added many new code pages (total of 22 now supported)
      • Fusion5250: Portal Admin > Languages now has a default setting for each language code page (CCSID). Code pages overrides for individual users can also be set in file VVUSERS via field VVCODEPAGE. Ability to edit vial Portal Admin > Users is coming on the next build.
      • Fusion5250: Significantly improved performance in screen rendering (up to 300% faster)
      • Fusion5250: Ensure Daemon and Proxy jobs are submitted with user associated with the Fusion JOBD, not the user sparking its launch
      • Fusion5250: Improved overall reliability with various bug fixes
      • Fusion5250: Note that Fusion5250 is still considered BETA--general release is expected next month (July 2019)
      Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

      Go to http://forums.cnxcorp.com/node/12708 for full release notes.
      Last edited by robert.swanson; 06-20-2019, 11:58 AM.

      Comment


      • #4
        Valence Framework 5.2.20190630 (Valence 5.2+) is now available. Changes in this build since the previous release are:
        • NAB: Corrected edit grid issue where a left-joined file in a data source with a null record would throw a "cannot derive key" error
        • Portal: Corrected issue where an IBM i user logging into the portal for the first time with an expired password could not successfully change password
        • Fusion5250: Adjusted logic to accommodate possible authority restrictions on data queue
        • RemoteDB: Adjusted count logic to accommodate more complex queries containing WITH clause
        • RemoteDB: Added support for Oracle Database connections
        • Nitro AutoCode: Ensure source file and object libraries specified in Settings exist prior to program generation
        Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

        Go to http://forums.cnxcorp.com/node/12708 for full release notes.

        Comment


        • #5
          Valence Framework 5.2.20190723 (Valence 5.2+) is now available. Changes in this build since the previous release are:
          • NAB: Introduced new Timeline widget
          • NAB: Added edit grid support for aliased files
          • NAB: Corrected issue where saving of a form widget containing field groups could break under particular circumstances
          • NAB: Corrected problem with "Create App" shortcut on widgets not working properly
          • Fusion5250: Added support for SSL
          • Fusion5250: Added ability to set a workstation naming convention in Portal Admin>Settings. Alternatively you can also use a custom exit program to set the device name.
          • Fusion5250: Corrected conflict with RemoteDB that could sometimes cause the VVFUSIOND Daemon job to go into a MSGW condition.
          • Spool File Viewer: Corrected issue where error messages encountered when attempting to perform actions on spool files would not display properly
          • RPG Toolkit - vvIn_Char(): Added optional third parameter to replace substitution characters (hex 3F) with a blank space. Can also be activated globally via Portal Admin > Settings.
          • RPG Toolkit - vvIn_Body(): Adjusted to limit CCSID conversion to size of data in memory at pointer location to avoid including garbage characters
          • RPG Toolkit - vvIn_base64toFile(): Adjusted to trap IFS errors (previously assumed IFS open and write API calls always succeeded)
          • VVMIGRATE: Corrected issue where portal User records would not migrate from pre 5.2+ instances
          Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

          Go to http://forums.cnxcorp.com/node/12708 for full release notes.

          Comment


          • #6
            Valence Framework 5.2.20190822 (Valence 5.2+) is now available. Changes in this build since the previous release are:
            • NAB: Introduced new "Tiles" widget
            • NAB: Added mobile support for the new Timeline widget
            • NAB: Fixed issue with Timeline widget's "Auto Load" not being applied
            • NAB: Fixed issue with Timeline widget's "End Data" field not being applied
            • NAB: Adjusted SQL parser to support UNION ALL
            • NAB: Adjusted SQL parser to support LATERAL JOIN
            • NAB: Added option to encode all SQL clauses to avoid firewall blocks
            • NAB: Adjusted "hide zero values" grid column renderer to apply to prefix/suffix values as well
            • NAB: Corrected issue where total row count could be incorrect on complex SQL-based data sources containing WITH clauses
            • NAB: Corrected import logic to accommodate changed IDs
            • NAB: form widget "helper" program to dynamically hide/show/disable/enable/filter/set values of form fields
            • NAB: new response helper procedure to button template program (EXNABBTN) to simplify responses and easily interact with form fields.
            • NAB: ability to mask input for form widget input fields.
            • NAB: provide built in email, phone, ssn#, or URL validation for form widget input fields.
            • NAB: Form widget - rule based text color
            • NAB: Added close application as a utility action.
            • RPG Toolkit - vvUtility_parseIntoCharArray: Adjusted logic to properly handle separators that are greater than one character
            Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

            Go to http://forums.cnxcorp.com/node/12708 for full release notes.

            Comment


            • #7
              Valence Framework 5.2.20190918 (Valence 5.2+) is now available. Changes in this build since the previous release are:
              • NAB: Adjusted Form widget to prevent auto-filling passwords if input is masked on any form field.
              • NAB: Added ability to force uppercase on form input fields
              • NAB: Added close event to vertical container
              • NAB: Added simple theming support: choose color scheme, adjust widget border width and radius
              • NAB: Added file upload to button call RPG program
              • NAB: added a progress bar option to the KPI widget
              • NAB: added app security to behaviors
              • NAB: Corrected issue where attempting to apply a filter over a very long calculated column (> 256 chars) would throw an SQL error
              • NAB: Corrected issue where grid cell colors were not applying to the "boolean" renderer
              • NAB: Corrected issue where grid column sortable:false was not applying when going back into edit mode of the widget
              • NAB: Corrected issue where form field colors were not saving properly when inside a field container
              • NAB: Corrected issue where URL widget presented as a popup was not translating the URL string properly
              • NAB: Corrected issue where close events were not saving properly when attached to a "utility" widget
              • NAB: Corrected issue where the timeline would not load if created from the "Create New App" option on the main data source/widget list.
              • NAB: Corrected issue where the timeline's height wouldn't adjust correctly on mobile if it gets a title set
              • NAB: Corrected issue where pdf download would fail if grid widget is set to infinite scroll
              • NAB: Corrected issue where an exported app containing a widget that launches another app could reference an incorrect or nonexistent app ID on the imported instance
              • NAB: Adjusted import logic to accommodate differences in app names/descriptions between instances when determining app ID to launch
              • NAB: Adjusted default behavior so that when a popup widget shows/filters another popup widget to not automatically close the popup
              • Web Services: Added support for wildcard (*) inside URL. Wildcard value can be retrieved via vvIn_char('vvWildcard')
              • RPG Toolkit - vvOut_data: added optional HTTP status and response text params
              Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

              Go to http://forums.cnxcorp.com/node/12708 for full release notes.

              Comment


              • #8
                Valence Framework 5.2.20191218 (Valence 5.2+) is now available. Changes in this build since the previous release are:
                • NAB: Corrected issue where grid checkbox column does not work when the grid has any action attached to its row click
                • NAB: Corrected issue in mobile grid where summary fields were causing data not to load
                • NAB: Corrected issue in Behaviors where the a widget was erroneously showing under the wrong section
                • NAB: Corrected issue where the SQL formatter was inserting a space before '#' in columns that contain the '#' symbol
                • NAB: Added icon column functionality to grids
                • NAB: No longer expands all behaviors by default
                • NAB: Corrected issue with import process where launch app actions were not importing properly
                • NAB: Corrected issue where Call RPG Program -> success=true and success=false events are not showing in Behaviors
                • NAB: Corrected import issue where in rare circumstance app import would show as successful yet the app was not fully imported
                • NAB: Corrected issue where wizard based data source filters clicking on a field while in sql free-format mode was always injecting a file index of one even if it isn't the first file in the data source
                • NAB: Corrected issue where KPI widget with empty data source will display incorrectly
                • NAB: Adjusted SQL parser to support GROUP BY GROUPING SETS
                • Portal Admin > Apps: Added ability to copy NAB apps
                • RPG Toolkit > vvOut_execSQLtoJSON: Adjustments made to improve row count performance (also affects NAB data sources)
                • RPG Toolkit > VVDSEXIT1: expanded size of VVSESSDS field from 999A to 3200A to accommodate larger library list. Affects functionality of vvUtility_callExitPgm
                • Fusion5250: Added macro recording/saving
                • Fusion5250: Autofocus last focused position when reactivating the application in the portal
                Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

                Go to http://forums.cnxcorp.com/node/12708 for full release notes.

                Comment


                • #9
                  Valence Framework 5.2.20200212 (Valence 5.2+) is now available. Changes in this build since the previous release are:
                  • NAB: Improved editor for Tile widget configuration
                  • NAB: Adjusted Behaviors so that button text is no longer automatically upper-cased
                  • NAB: Added support for summary functions over data sources containing WITH clauses
                  • NAB: Adjusted document upload logic to not give an "invalid extension" exception when valid extension(s) had been entered with a leading period
                  • NAB: EXNABBTN > GetFilterValue procedure adjusted to check for both "F1." and "F1_" file prefix syntax
                  • NAB: Corrected issue where data source caching was not always working correctly
                  • NAB: Corrected issue where ability to add an icon button to a grid was not available if grid already contained a menu button
                  • NAB: Corrected issue where app import could go into an endless loop condition
                  • Portal Admin>Settings: Added new search mechanism so specific settings can be found more quickly
                  • Portal: Added logic to trap and log record locks over VVSESSDATA when killing expired sessions in vvSecure_killSessions
                  • RPG Toolkit > VVOUT: Corrected total row count calculation in vvOut_execSQLtoJSON for SQL statements containing GROUP BY clause (would also affect record counts showing on NAB grids)
                  • RPG Toolkit > VVOUT: Added support for insert/update/delete operations against remote DB connections in vvOut_execSQLtoJSON
                  • RPG Toolkit > VVUTILITY: corrected overflow issue in parseIntoCharArray that could occur when separator is more than one character
                  Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

                  Go to http://forums.cnxcorp.com/node/12708 for full release notes.

                  Comment


                  • #10
                    Valence Framework 5.2.20200323 (Valence 5.2+) is now available. Changes in this build since the previous release are:
                    • Fusion5250: Licensing cost for the Valence Core with Fusion5250 is now free during the coronavirus pandemic. Read our March 20, 2020 blog post for more information
                    • NAB: Added better fault checking on App/Widget/Data Source import
                    • NAB: Added localization support for Valence-supported languages to the Timeline widget
                    • NAB: Added fixed width option on widgets
                    • NAB: Adjusted to derive proper display size for integer columns in SQL-based data sources
                    • NAB: Added "Auto Refresh Interval" to Form, Map & Tile widget.
                    • NAB: Fixed call RPG Program/URL "Prompt User For More Information" when it has more than one dropdown
                    • NAB: Fixed Hide/Show Widgets "Refresh Data"
                    • NAB: Added Unchecked/Checked/Both configuration to checkbox filters on grid widgets
                    • Portal: Allow change password functionality on Valence profiles linked to different IBM i profiles when "Use IBM i Password" option is checked, provided IBM i user ID is not linked to any other Valence profiles
                    • Portal: Chrome - fixed end session on close of the browser/browser tab
                    • Installer: Ensure QTMHHTTP has proper access to certs required for running Fusion5250 under SSL
                    Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

                    Go to http://forums.cnxcorp.com/node/12708 for full release notes.
                    Last edited by robert.swanson; 09-11-2020, 11:20 AM.

                    Comment


                    • #11
                      Valence Framework 5.2.20200415 (Valence 5.2+) is now available. Changes in this build since the previous release are:
                      • NAB: Form helper can now refresh a dropdown data source
                      • NAB: Autofocus now places cursor into first focusable field in popup widget
                      • NAB: No longer show a value of zero in a telephone-formatted field
                      • NAB: Allow pasting of numbers with commas into number fields
                      • NAB: The initial load mask text can now be changed by passing a URL parameter of "nabLoadMask"
                      • NAB: Excel & PDF now accommodate number calculations inside a column's "custom formatting" value
                      • NAB: Encrypt summary SQL if encrypt is turned on in Portal Admin/Settings
                      • NAB: Form widgets now accommodate text areas (via formatting option)
                      • NAB: Corrected minor issues with app import/export
                      • NAB: [BETA] Added new "script" feature for adding/running custom JavaScript on a user behavior
                      • Desktop Portal: [BETA] Added two factor authentication (2FA) option
                      • Fusion5250: Added ability to copy/paste blocks of text
                      • Fusion5250: Added ability to override frontend SSL setting
                      • Fusion5250: Improved Japanese compatibility
                      • RPG Toolkit: vvIn_Sorters - corrected bug affecting sorting over grouped grids
                      • Portal Admin > Settings: Corrected bug that would cause Settings to not list at all when "Show hidden settings" not checked (.1 build)
                      Note: [BETA] features are not yet documented and can only be used if "Enable Beta Features" is activated in Portal Admin > Settings. These will become permanent, documented features in the forthcoming Valence 6.0 release.

                      Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

                      Go to http://forums.cnxcorp.com/node/12708 for full release notes.
                      Last edited by robert.swanson; 04-23-2020, 01:48 PM.

                      Comment


                      • #12
                        Valence Framework 5.2.20200526 (Valence 5.2+) is now available. Changes in this build since the previous release are:
                        • NAB: Added form helper modes (startup/change/blur)
                        • NAB: Added ability to refresh a widget via an App Variable
                        • NAB: Popup windows - Can now keep state, versus being destroyed on close
                        • NAB: Grid widget - Added time format column rendering options (HH:MM:SS && HH:MM)
                        • NAB: Edit Grid widget - Adjusted logic so edit grids cannot be created over SQL-based data sources containing summary functions
                        • NAB: Pivot Grid widget - Now fires row click if grid has a filter event and can satisfy the requirements of the filter event, or doesn't have a filter event
                        • NAB: Pivot Grid widget - Corrected export bug where column headings were not aligning properly
                        • NAB: SQL parser - Added support for "dec" function (short for "decimal")
                        • NAB: Excel download - Fixed numeric formatting
                        • NAB: Form widget - Corrected issue where combo boxes may not be loaded properly
                        • NAB: Import/export - Corrected issue where combo boxes could be dropped on the export
                        • NAB: Adjusted filter rules so blanks are treated same as "0" for numeric columns or "0001-01-01" for date columns
                        • NAB: Corrected issue where the save of an app containing tabs could result in an error
                        • Portal Admin > Settings > NAB: Added two optional paths (URLs) for specifying .css or .js files to be loaded into all NAB apps at runtime
                        • Portal Admin > Environments: Prohibit creation of new environments with name that matches an already existing environment
                        • RPG Toolkit: vvMail - Corrected issue where port number passed with TLS encryption could be ignored
                        • Portal Login: Resolved issue where "Forgot Password" link would fail when logging in with a non-IBM i user ID with password linked to IBM i profile.
                        Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

                        Go to http://forums.cnxcorp.com/node/12708 for full release notes.

                        Comment


                        • #13
                          Valence Framework 5.2.20200608 (Valence 5.2+) is now available. Changes in this build since the previous release are:
                          • NAB: RPG programs can now enable/disable widget components
                          • NAB: Widget filters - for "between" filters over dates, blank filter values are now treated as '0001-01-01' or '9999-12-31'
                          • NAB: Form widget - now uses the Valence date format on all date fields
                          • NAB: SQL parser - added support for table joins based on a subquery
                          • NAB: Pivot Grid widget - corrected issue that could cause cell color rules to not be followed
                          • RPG Toolkit: vvOut_execSQLtoJSON - corrected issue where count statements could be thrown off by a LEFT JOIN or an unexpected GROUP BY clause in the SQL statement
                          Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

                          Go to http://forums.cnxcorp.com/node/12708 for full release notes.

                          Comment


                          • #14
                            Valence Framework 5.2.20200630 (Valence 5.2+) is now available. Changes in this build since the previous release are:
                            • NAB: Excel download - Corrected issue with improper time zone adjustment being applied to timestamp columns
                            • NAB: SQL parser - added support for OPTIMIZE FOR clauses
                            • NAB: App import - Adjusted to preserve category of imported apps when a match by name can be made, otherwise app goes into default category ("Uncategorized")
                            • NAB: Widget filters - corrected issue where original widget filter could be lost after another user filter is subsequently applied
                            • NAB: Grid widget - corrected issue where overriding the grouping column would result in an incorrect column heading and have the pdf/excel document reflect the overridden grouping column
                            • NAB: Grid widget - fixed bug where column sequence could be incorrect when it has 50 or more columns
                            • NAB: Grid widget - corrected issue where a column containing a summary function could be included in the WHERE clause of a global search, resulting in an SQL error
                            • Fusion5250 - improved edit-checking and handling of double byte character fields
                            • RPG Toolkit: vvJSON - adjusted to properly escape double quotes inside segments containing a mix of single byte and double byte characters
                            • RPG Toolkit: vvOut_execSQLtoJSON - auto append OPTIMIZE FOR clause to improve performance on paging grids w/ asensitive cursor; Can be superseded by new vvOut.optimizeClause field
                            • RPG Toolkit: vvOut_initialize - for systems below IBM i OS 7.3, check for SQL OFFSET clause support is now done once per job, rather than once per activation group. This will reduce "Y in *LIBL type *FILE not found" clutter in the job log.
                            Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

                            Go to http://forums.cnxcorp.com/node/12708 for full release notes.

                            Comment


                            • #15
                              Valence Framework 5.2.20200720 (Valence 5.2+) is now available. Changes in this build since the previous release are:
                              • NAB: Excel/PDF download - Blank values in grid widget custom renderers are now honored in Excel and PDF downloads
                              • NAB: Excel download - Corrected issue that could cause date column values to be off by one day under certain circumstances
                              • NAB: Excel download - Corrected issue that could cause Excel download on grouped grids to not generate
                              • NAB: Grid widget - Adjusted to ensure numeric cell values are not mistakenly treated as phone numbers on mobile devices
                              • NAB: Grid widget - Corrected issue where filters could disappear upon maintenance in NAB Designer
                              • NAB: Grid widget - Corrected issue that could cause group subtotals to not appear under certain circumstances
                              • NAB: Grid widget - Corrected issue affecting older TR levels on 7.1 and 7.2 where paging would not work correctly (in VVOUT)
                              • (.1 build) NAB: Grid widget - Adjusted to accommodate CSS bug introduced by latest Windows/Chrome update that was causing grids to show no data
                              • (.1 build) NAB: Edit Grid widget - Corrected issue where grids using infinite scroll feature could have buttons not disable after updating a record
                              • Fusion5250: Adjusted VVFUSIONP job to reflect the IBM i user ID associated with the interactive 5250 job
                              • Fusion5250: Improved cursor positioning logic in PDM, etc.
                              • Examples: Paging grid - adjusted back-end search logic to properly escape single quotes
                              Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

                              Go to http://forums.cnxcorp.com/node/12708 for full release notes.
                              Last edited by robert.swanson; 07-22-2020, 02:00 PM.

                              Comment

                              Working...
                              X