Vivaldi for MySQL

Release Notes


Vivaldi 3.1.1

  • Miscellaneous
    • Compatibility updates for MySQL 8
    • Improvements to installer to communicate install errors and connection issues.

Vivaldi 3.1

  • Runtime Experience
    • New "type-ahead" dropdown box option for large lists.
    • Fixed: Sort order on dropdowns was not respecting MySQL order by for existing records.
  • Configuration and Design
    • New "type-ahead" dropdown Form Item option for large lists.

Vivaldi 3.0.4

  • Fixed: users could not be added in some instances based on MySQL server settings.
  • Fixed: collapsed menu would open during navigation on small form factor mobile devices.

Vivaldi 3.0.3

  • Fixed: issue where inserts/updates were prevented by MySQL sql_mode = STRICT_TRANS_TABLES.
  • Master Detail wizard now supports unlimited children
  • MasterDetail forms now support faster tab navigation when the selected parent hasn't changed

Vivaldi 3.0.2

  • Resolved issue where Admin Dashboard popups would close after opening.

Vivaldi 3.0.1


  • Runtime Experience
    • PDF output now includes page numbering and headers on each page.
    • Improve vertical space utilization for tabular forms.
  • Configuration and Design
    • Fixed: Form Designer was not showing options to open the design view for new forms.
    • Support for MySQL column names with hyphens.
    • Ability to decide whether to use MySQL ordering or text value ordering on dropdowns.

Vivaldi 3.0


  • Runtime Experience
    • Table columns can display the Field Help text when the user hovers over the column name.
    • When a modal popup is closed, the content will be cleared so that the next time the user opens a modal, it doesn't show old information while the new information is loading.
    • Fix: Select dropdowns set to required were not preventing a save/insert when empty.
  • Configuration and Design
    • New Tabbed Form display option and wizard from 'New Form Wizard' menu option.
    • New Form Property 'Help URL' to open a new window to display the help URL of your choice.
    • New Application Property to make the Custom User ID field required on a new user account (if desired).
    • New Application Property for Return Email Addresss used for new account and password reset emails.
    • New Application Property for password reset email text.
    • New Application Property for showing a small form info icon at the bottom of each form. When clicked, the form name, GUID, and other information will be shown. Disabled by default in existing Vivaldi deployments.
    • A new option exists to add a database array in databases.php called 'test' that can then be used when you log in and pass the following parameter: login.php?test=testmode This will notify you that the connection will go against another database connection of your choice, which can be helpful when you want to test your Vivaldi application using an alternate database.
  • Miscellaneous
    • New custom attribute columns in ogs_form for your own use: customer_attribute1 and customer_attribute2. Both are varchar(100) and can be modified to your needs.
    • Fix: The required asterisk in detail forms was causing line breaks. Removed the preceding space.
    • You can optionally add a file /styles/customer_htmlfooter.php to place or invoke any code you would like at the end of the index.php file automatically.


Vivaldi 2.4.1


  • Runtime Experience
    • Fix: Password reset throwing an error on PHP 7.x
    • Fix: Default value 'Current Date and Time' was not working for AM hours.
    • Fix: Opening records with the new cascading dropdown to edit was clearing the child dropdown value.
  • Configuration and Design
    • The Form Designer now supports images as an item on Detail forms. Two new options - Image (upload) and Image(display) allow you to either let users upload images, or simply view them. Images are stored in a folder on your server, with a link reference in a table field of your choice.

Vivaldi 2.4


  • Runtime Experience
    • User administrators can now check a box to require new users to change their password when they login.  Currently it is a message that will not go away until they change their password (as opposed to a blocking workflow).
    • Modal popups now display the name of the form in the header instead of "Detail"
  • Configuration and Design
    • New Events options in the Form Designer allow you to call javascript functions at key junctures of the form lifecycle (after record fetch, after insert, after edit, after delete).
    • New Cascading Dropdown feature to make it easy to join a parent and child dropdown where the child dropdown will change and limit the results based on the value chosen in the parent dropdown.
    • Beta:  2nd-level submenus.
    • Fix: The Lookup Wizard was not returning table names.
  • Miscellaneous
    • Fix: Tables were not refreshing when a record was deleted from a Detail form.

Vivaldi 2.3.2


  • Runtime Experience
    • Adjusted Collapse Panels to allow users to click anywhere on the header rather than just the link text.
    • Fix: Default values for the Detail Form checkbox were not setting the box to checked.
  • Configuration and Design
  • Miscellaneous
    • The Administrator dashboard will tell you when new updates are available in the bottom right of the screen.
    • Fix: The Menu Designer was not displaying existing menu items.


Vivaldi 2.3.1


Minor fix to upgrade script to resolve key issue on ogs_application table.

Vivaldi 2.3


  • Runtime Experience
    • Users can choose to see Vivaldi in Spanish and French (beta)
  • Configuration and Design
  • Miscellaneous
    • Fix: Internet Explorer was not redirecting to login.php if the user did not include index.php in the URL before logging in.
    • Fix: The Menu Designer was not displaying existing menu items.


Vivaldi 2.2.1


Improved performance of table forms by 8% using compression for data returned from MySQL.

Vivaldi 2.2


  • Runtime Experience
    • Forms can now be opened using the formname in the URL parameter as follows: index.php?route=ogs/dynamicform.php?formname=YOURFORMNAME
    • Fix-Required label was showing on all items in row
  • Configuration and Design
    • New Form Designer layout
    • You can now copy form items from a Table to Detail form in the Form Designer to get your Detail form started faster.
    • Table forms now support Calculation fields that contain if() {} statements.
    • New option to show a logo instead of the application name on the header menu (use Administration>>Application Settings)
    • Detail forms now support Hyperlink as a display type. The bound field represents the URL. It will display the full link to the user unless you enter text in the 'Field Help' property (e.g., Click Here)
  • Miscellaneous
    • New User Statistics option on the Administrator dashboard

Vivaldi 2.1.2

  • Runtime Experience
    • Update to Font Awesome 5.4.1.
    • Users can now navigate directly to a URL after logging in (i.e., deeplinks are now supported after login).
  • Configuration and Design
    • New 'popout' option to preview a form in the Form Designer.
  • Miscellaneous
    • Fix: Upgrade process for 2.1 did not upgrade some views successfully.

Vivaldi 2.1.1


Miscellaneous
  • Fix: Some implementations of drilling to another form was not working for Firefox and IE

Vivaldi 2.1

  • Runtime Experience
    • Table forms now support checkboxes
  • Configuration and Design
    • Field display types that can't be used for a detail or tabular form won't show up in the list of options in the form item definition.
    • Tabular forms now support the Checkbox display type.
    • New Example table and detail forms to help provide a demonstration of the variety of options available when configuring your forms.
    • The 'Field Help' property can now be used to provide hover text for Buttons on your forms.
    • Adding the Custom CSS 'clearafteradd' to your control on a detail form will cause it to clear when a user clicks the 'Save and Add Another' option.
    • Adding the Custom CSS 'vivaldi-bold' will bold a column's text.
  • Miscellaneous
    • Fix: only the first role assigned to a user was being used to determine form permissions.
    • Fix: click the User Role Assignment edit button didn't filter to that user/role combination.

Vivaldi 2.0

  • Runtime Experience
    • 25%+ improvement to page load times
    • PDF exports now exclude action buttons on tables, page title matches form name
    • Users see a warning message when a Detail form has no results (but is expected to from being launched in a filtered condition)
    • Fix: Menu did not close when user clicked an item on a mobile device
  • Configuration and Design
    • New Master-Detail form wizard
    • New Default Value wizard to help guide options for defaults like current date, current user
    • New option to place extended information in expand/collapse section in tabular forms
    • Support for timestamp data type in Date and Time form controls
    • When a field default value is the current date and time, it now shows based on the user's local timezone.
    • Fix: timestamp date format not showing correctly in tables
  • Miscellaneous
    • Debug mode now reports query response times

Vivaldi 1.4

Vivaldi 1.3.2

  • Runtime Experience
  • Configuration and Design
    • New option to copy a form and it's related permissions
    • New option in the Click Event wizard to launch a drill form in a popup window.
  • Miscellaneous
    • Introduced support for servers that don't support MySQLND driver
    • A new 'rowlimit' URL parameter can be passed to the dynamicform.php URL to limit the number of rows displayed in a table.

Vivaldi 1.3.1

  • Miscellaneous
    • Fixed issue with the Click Event drilldown event.
    • Small adjustment to default date format on tables based on customer feedback.

Vivaldi 1.3.0

  • Runtime Experience
    • Added jQuery UI to provide cleaner look and feel for many elements.
  • Configuration and Design
    • Enhanced select dropdown with search by keyword (you must add the class 'chosen-select' to your dropdown item)
    • New Tasks framework (early release) that supports managing tasks within Vivaldi
    • New Menu Designer to simplify creating menus and managing children
    • Drag & drop row re-ordering for table form items in the Form Designer.
    • Support for checkboxes as a form control display type.
    • Tables now support 'Date' and 'Date and Time' formatting (be sure to use the Display Format options with java formating syntax)
  • Miscellaneous
    • Fixed issue where a table with a MySQL reserved word column name wouldn't update.

Vivaldi 1.2.1


  • Runtime Experience
    • New option for users to select at login to remember username when returning.
  • Configuration and Design
    • Click Event wizard now supports click events on any table column (not just buttons).
    • New upgrade-safe customer_htmlhead.php file to support customer-driven html header options
    • Added new "design" cog icon at top right for fast access to the Form Designer for authorized users.
    • Ability to add Collapse Panels to detail forms.
    • Resolved bug with Click Event and Format wizards.
  • Miscellaneous
    • Fixed issue where a table with a MySQL reserved word column name wouldn't render.
    • Improved security on user HTML inputs.

Vivaldi 1.2.0


  • Runtime Experience
    • Improved navigation submenu colors for mobile users.
  • Configuration and Design
    • New Form Wizard creates and links Table and Detail forms, permissions, and menu items automatically based on a few simple prompts.
    • New Click Event wizard to allow users to navigate from a table row to another form.
    • New Style Options screen to manage basic color styles in the application.
  • Miscellaneous
    • Resolved issue where form guid was not displaying on the Form Detail screen.
    • Improved support for embedded pages that use jQuery. When upgrading, ensure you modify your js/customer.js file to use the following convention to prevent jQuery conflicts:
      var $custjs = jQuery.noConflict(); $custjs(...
      (in other words, replace any $ with $custjs)
    • Enhanced Administrator dashboard with connection information and ability to purge the event log.

Vivaldi 1.1.0


  • Runtime Experience
    • Enhanced horizontal table scrolling
    • Suppressed PHP warning message output for authentication
  • Configuration and Design
    • Improved clarity on display order of fields in the Form Design Wizard
    • Added Related Menu item section to Form Design Wizard
    • Ability to define Detail Form sections (add to core config....)
    • New Validate option for Form SQL
    • Improved clarity on what fields are needed for Form Property definition
    • Introduced table sorting/ordering by field
    • Added table paging configuration option
  • Miscellaneous
    • Resolved issue with MySQL tables that contain non-UTF8 data returning empty results.

Vivaldi 1.0.2


Various fixes

Vivaldi 1.0.1


Various fixes

Vivaldi 1.0


Initial Release