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.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 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; 10-25-2019, 04:26 PM.

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

    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

              Working...
              X