Softpedia >Mac >Internet Utilities >myDBR >  Changelog

myDBR Changelog

What's new in myDBR 4.5

May 18, 2015
  • New functionality:
  • OEM customization options added
  • User defined macros in SQL editor
  • myDBR command autocomplete in SQL Editor
  • Improved indentation in SQL Editor
  • Search / Replace dialog in SQL Editor
  • Autocomplete database definition possible in $mydbr_defaults
  • Ability to define Single Sign-On extra parameters also for local user
  • Logging option added for Single Sign-On authentication
  • Show group information for external users
  • Ignore SSL option added for the mail extension
  • JavaScript support added for import return values
  • New commands / options:
  • series_axis option added for charts
  • Extra parameter to import.prepare, import.finish
  • General improvements:
  • Support for empty strings in connected parameters
  • Ability to force IPv4 in CURL if IPv6 is giving trouble in your environment
  • Active Directory support for PHP 5.1/5.2
  • Date edit more straightforward in editable
  • Fixes:
  • sum prefix handling in calculate
  • Statistics log start fix
  • Organization linked report fix
  • Automatic updater detects if FilesystemIterator is not available
  • Formatting for tooltips in multuseries charts
  • Menu positioning in popup fixed window
  • PDF export current tab content
  • Apostrophe handling fixed in editable select
  • Ability to go around a bug in Microsoft Drivers for PHP affecting header encoding

New in myDBR 4.3 (Sep 12, 2014)

  • Contains new functionality, fixes and general improvements. The release is recommended for all users.
  • Users can now reset their own password if expired / forgotten (feature is off by default). Password reset feature sends user a password reset link mail, so mail settings needs to be configured. Mail settings are moved from a configuration file into the Environmental Settings. Old mail configuration settings can be removed once the new ones are in place.
  • New functionality:
  • User can reset own password when using myDBR authentication by requesting a password reset link via mail
  • User can update email address and phone numbers in preferences
  • Improved PHP 5.5 support
  • MySQL socket added as install option
  • Dashboard allows full reports with full functionality
  • Meters and pyramid/cone/funnel charts now support report linking
  • Allow to define own styles in mail
  • Import character conversion possible with 'charset' option
  • Linked reports can be added to html5-data element to be accessed via JavaScript
  • Allow to block Single Sign-On users as admin (local only admins)
  • Conditional linked reports with show_link-parameter
  • Ability to add Cancel-button to dialogs (append '&cancel_button=1' to url)
  • dbr.hidecolumn.summary command added
  • legend.position option added to charts
  • legend.style option added to charts
  • category_sort option added to charts
  • ip_address & user_agent added into statistics
  • no_scroll_to added to embed_object preventing scrolling to embedded element
  • regression_degree option added for trendline's polynomialRegression
  • dbr.colstyle now supports column references when used with charts
  • tooltip chart option supports column references
  • Fixes:
  • E_STRICT handling in older PHP
  • Special characters handled better in in-cell editing, linked reports and in parameters
  • Thousand separator in linked reports no longer causes problems
  • Column filter works with multiple tables
  • Improved checkbox parameter handling when no ID's are used
  • Improved UTF-8 support in parameters
  • Clear id's when empty autocomplete is entered
  • Workaround for InfiniDB commenting bug
  • Translation with Bing works again
  • General improvements:
  • Mail settings moved into the environmental settings
  • Memory optimizations
  • Dialogs movable in touch devices
  • Dialog positioning now always onscreen
  • Cleaner fonts in SQL Editor when using Firefox
  • adLDAP works with php55
  • Security improvements
  • Improved error handling
  • Export files have now always a name
  • Import supports automatic parameters
  • Tabs can how handle link to report folder (m-parameter)
  • Missing privileges shown in SQL Editor
  • More flexible for integer and float input fields
  • Allows all params to be optional when linked report is called
  • Allow sorting in editable selectlist
  • Commmand change dbr.hidedatacolumn -> dbr.hidecolumn.data (old kept for compatibilty)
  • dbr.calc works with dbr.crosstab.col
  • dbr.colstyle support added to the editable
  • dbr.cellformat support in dbr.editable
  • Crosstab tooltip is now optional (defined in defaults)
  • Improved language detection

New in myDBR 4.2.2 (Jun 3, 2014)

  • Fixes a problem some users are experiencing with templates
  • Reduced memory footprint
  • Ability to set string parameter field length

New in myDBR 4.2.1 (May 15, 2014)

  • Removes Strict warnings with PEAR on older PHP installations
  • Fixes a problem with user permissions

New in myDBR 4.0.0 (Dec 14, 2013)

  • New features:
  • Scrollable table functionality
  • Running total functionality
  • Organization chart -extension
  • HERE Maps -extension
  • Hashed password support (turned on by default)
  • Ability to show main view (public reports) without login or autologin
  • Ability to automate myDBR update process via scripting
  • Ability to automate Active Directory sync via scripting
  • Ability to set the user sort order to be remembered
  • Report parameter suffixes
  • Report parameters can be paired
  • Title-separators can be added to report parameters
  • New parameter query options
  • Native date/datetime/time-picker on touch devices supporting HTML5 date/datetime-local/time
  • Added import options
  • csv.enclose_always -option added
  • Support for non-editable visible parameters (s-parameter)
  • Ability to set active tab
  • MSLineDY chart added
  • gantt.baseline chart option can now be set for single stage
  • Multiple account suffix support for Active Directory
  • Ability to set browser autocomplete off in login
  • Ability to skip attaching linked report to a cell/row by adding 'no_link'-class
  • Accordion multiopen support
  • Ability to add constants to linked report calls
  • Ability for admin to impersonate other users
  • Greek localization by Goumas Lefteris
  • SQL-export option added with &export=sql (allowed by default for admin)
  • Added new settings to Environment settings for charts and page title
  • New commands:
  • dbr.running_total
  • dbr.scrollable
  • dbr.footer.colstyle
  • dbr.import.options
  • dbr.import.options
  • dbr.sort.remember
  • Chart option: gantt.single_label
  • Chart option: trendline-chart
  • Export option: xml.declaration
  • Misc improvements / fixes:
  • Improved date/datetime/time-picker on touch devices not supporting HTML5 date/datetime-local/time
  • Mobile support for dbr.refresh counter pause
  • Autosubmit editable select
  • Parameter help shows also in report
  • Excel export improvements
  • Usability improvements for touch devices
  • Google maps support for popups embedded elements
  • Improved error messages for SQL Server
  • Mailed reports show correctly also with Outlook 2007-2013's MS Word HTML parser
  • Ability to show new version update info only to the admins
  • Support for HiDPI displays
  • Pie label dispay changes to support smaller pie slices
  • Time integer XLS export format
  • Longer Help/JavaScript in report parameters
  • Improved debugging info about erroneous Active Directory configuration
  • Changed to jQuery UI datepicker
  • Support type=date in sqlsrv
  • Commenting in SQL Editor
  • Internet Explorer 11 support
  • Unique id for Flash chart when using a Windows server
  • Parameter initialization in connected parameter's popup's when more complex connections are made
  • Allow - and ~ signs in front of chart axis labels
  • Tab initialization in ajax tabs

New in myDBR 3.9.4 (Aug 6, 2013)

  • A security update recommended for all users.

New in myDBR 3.9.1 (Aug 6, 2013)

  • Fixed an issue where crosstable headers were not drawn correctly

New in myDBR 3.9.0 (Aug 6, 2013)

  • New features:
  • Complete CSS-style overhaul allowing easier theming and easier access to objects
  • Column filter capability
  • Aggregate commands have now equivalent prefix commands
  • Gantt-chart support added
  • Stepline-chart support added
  • Charts can now calculate their size automatically using 'auto'-size definition
  • Added column styles with leading zero support
  • Connected parameters allow now connection via name and relative position
  • 'inline'-target support allow linked report to be opened inside result set
  • 'include_image' export-option
  • JSON object notation support in JSON export
  • Firefox mobile support
  • BlackBerry 10 support
  • New commands:
  • dbr.filter
  • dbr.sum_prefix
  • dbr.min_prefix
  • dbr.max_prefix
  • dbr.count_prefix
  • dbr.hminus
  • dbr.footer.colclass
  • Misc improvements:
  • JavaScript component updates
  • One cellstyle is enough for all conditions (positive, zero, negative)
  • Maximum number of autocomplete rows returned is now an user defined parameter
  • Improved accordion height calculation
  • Line chart markers with show_markers
  • allow_gaps allow line charts with missing data to be created
  • Linefeeds in HTML mail no work without extra steps
  • Scrolling connected checkbox parameter now handle nonexistent data situation
  • Added "Report parameters"-link into the SQL Editor
  • Ajax indicator for slow connected parameters
  • Connected parameter query optimization
  • Improved Excel exports
  • Improved remote server error messages
  • Allow HTML in dbr.button
  • Improved Internet Explorer 10 support
  • Fixes:
  • When sending HTML mail, the plain text version has now always the same content
  • sqlsrv driver no longer returns extra empty result sets
  • Connected parameter in same line works now
  • Hidden column are no longer included in emailed reports
  • Dialogs closes again with esc
  • No data working in multiseries chart
  • Connected parameter handling in Internet Explorer fixed
  • Column order in Excel exports when using dbr.calc
  • negative currency sorting

New in myDBR 3.8.0 (Feb 26, 2013)

  • New features:
  • Template support added
  • Google Maps heatmap support
  • Internet Explorer 10 support
  • Windows Phone 7/8 support
  • Dynamic parameter support for editable reports
  • All new and faster CSV exports
  • Protected variable support in connected parameters
  • SugarCRM 6.x support for SSO
  • Folder content can now be obtained in json
  • dbr.calc improvements. Calc col can ref to another calc col. Aggregate function support for calc cols)
  • dbr.summary.text supports now column references
  • dbr.pageview support style and class attibutes
  • SVG support for charts improved. Fallback on PNG charts for older browsers
  • Output as SQL option added into the SQL Editor for support purposes
  • New commands:
  • dbr.template - ability to apply a template to the result set
  • dbr.sort - set initial sorting order
  • dbr.sortmethod - ability to specify sorting method for a column
  • dbr.chart.options stacked_order - allows to specify multiseries column order
  • Misc improvements:
  • Improved filter functionality
  • Improved null handling in dbr.calc
  • Calculations with seconds supported in export
  • Text parameters now autosize the text field
  • Timeout for remote calls
  • Use BOM in UTF CSV export
  • Performance imnprovements
  • Internet Explorer 9 fixes
  • ID classes for mainview categories
  • Pie charts linked report can be invoked by clicking on chart labels
  • Accordion are now collapsible
  • dec, numeric, fixed support in MySQL
  • SSL support for MySQL added
  • HttpOnly cookies
  • Fixes:
  • Extended charts work again
  • Graphviz charts obey chart format
  • Fixed the focus problem in popups
  • Fixed a problem in Ajax calls when hostnames include a port number
  • Fixes for the timepicker
  • Fixed hyphen handling in editable reports
  • Fixed tab initialization issue in Ajax reports
  • Fixed export column shift fixed with hidden columns
  • sqlsrv driver works even when mydbr-user's dafault database is not mydbr
  • Extra column removed in when drill column is used
  • Fixed a problem with touch based Webkit devices
  • Fix for potential collation problem with certain MySQL Servers configuration

New in myDBR 3.7.0 (Nov 16, 2012)

  • Server support:
  • Added support for PHP 5.4
  • Added support for Microsoft Drivers for PHP for SQL Server. Windows server no longer need to use FreeTDS.
  • Compatibility with Infobright installations
  • Support for installations on MySQL servers without InnoDB support
  • New features:
  • Added Google Maps Business support
  • Added support for displaying images stored in database
  • Time formatting options to charts (hh:mm:ss, negative times)
  • Converting times from seconds in charts is also now supported
  • Additional formatting options for checkbox parameters
  • Cartesian coordinate system chart support added
  • Default setting for opening exports into new window
  • embed_image, image_format URL variables added
  • New optional date and datetime -entry filter
  • default_image_format and embed_image URL parameters added
  • New commands:
  • dbr.mail.debug command added to add debug info on sent mails
  • dbr.divify command added to use DIV's instead of tables for output
  • dbr.header.colclass command added allowing formatting of the headers
  • dbr.cellformat command allowing cells in a column to have different format on different rows
  • Misc improvements:
  • Improved Active Directory integration
  • Summary lines are calculated with full decimal precision even when column formatting shows less precise values
  • Popup windows can be opened in a new browser window
  • Popup windows close on esc
  • SQL Editor adapts it's initial size based on browser window size
  • Forcing Internet Explorer to use standards based formatting for better results
  • Allow to deny editing cells with 'no_edit' class
  • Fixes:
  • Handle empty export filenames in Internet Explorer
  • Tabs with large amount of data no longer flashes in slow browsers
  • Fixed a problem with linked parameters and checkboxes
  • Internet Explorer UI fixes
  • Improved session error messages for incorrectly configured servers
  • Improved handling of empty crosstab report objects
  • 'onload' option in dbr.javascript works now in all cases
  • Remote server call does not need to have a return value
  • A bug with dbr.url referencing report parameters fixed
  • Improvements on Excel exports
  • Remote call no longer executes twice if no data is shown
  • SQL Editor initiation should no longer create problems in Windows servers

New in myDBR 3.3.0 (Feb 6, 2012)

  • New features/improvements:
  • Added sparkline chart (inline chart) support
  • Active Directory synchronization allows importing current AD users and groups
  • Pie labels are now clickable in linked charts
  • wkhtmltopad PDF export headers now customizable
  • dbr.javascript option allows script to run after the DOM hierarchy has been fully constructed
  • Fixes:
  • A problem with Chrome and gz compressed javascript has been fixed
  • Improvements to skip_single_line_summary option
  • A problem with xlsx-export fixed
  • JSON support for exports in older PHP installations without built in json
  • A problem with connected paramerters has been fixed
  • A problem with wkhtmltopdf headers fixed

New in myDBR 2.6.1 (Feb 22, 2011)

  • Fixes a problem with automatic SQL generation and localizations.

New in myDBR 2.6.0 (Feb 22, 2011)

  • Changes / improvements:
  • Active Directory browser
  • Report parameters accessible directly from report
  • Fast access to access rights
  • Folders can now have explanation
  • OEM customization options
  • Workflow improvement
  • Improved Mobile UI's
  • Community version displays usage statistics directly in Dashboard

New in myDBR 2.2.1 (Sep 14, 2010)

  • New Features:
  • Ability to directly update data in reports
  • New SQL Editor with color syntax highlighting
  • Ability to edit server side files
  • Improved Export functionality: native Excel, PDF, CSV
  • Localization files now editable. Ability add new localizations.
  • New css class based styling commands
  • Downloadable PDF documentation
  • phpBB Single-Sign-On module
  • Improvements:
  • Browser issues fixed (Internet Explorer 8, Firefox)
  • Chart fixes in multiseries charts
  • Support for direct links on image charts
  • Parameter queries can be personalized
  • Aggregate functions work even on styled cells
  • Localized reports can now be moved
  • Embedded reports support sorting, finding and exporting
  • Greatly improved SQL Server support in SQL Editor
  • Date-datatype support in SQL Server
  • Removal of header / foorter from browser print
  • Sorting fixes
  • iPad homescreen webclip icon

New in myDBR 1.4.5 (Dec 21, 2009)

  • New features:
  • Ability to send reports / parts of it via mail (Premium-version feature).
  • A new 'dbr.button'-command for easy report linking.
  • Fixes/improvements:
  • A fix when in certain combinations user input was unnecessary encoded when user made an error in parameter input.
  • Demo database should now install cleanly regardless of database character set.
  • Google Maps extension improvements to follow Google's changes.
  • No more limiting database usernames to 15 characters in installer.
  • myDBR cookies now handles spaces in URL's correctly.
  • UI cleanup for Firefox and Internet Explorer.
  • Javascript optimizations to reduce network traffic.

New in myDBR 1.4.3 (Nov 20, 2009)

  • Users with web server configured with FastCGI should no longer have trouble with HTTP/HTTPS
  • SQL Editor improvements (execute selection, SQL Server version improvements)
  • Improved error handling with Google's geo service
  • Internet Explorer UI cleanup
  • Opera Mobile now mobile optimized when using in Symbian device
  • ionCube Install instructions now corrected in thread safe PHP installations
  • Upgrading from 1.2/1.3 now completes without false error messages

New in myDBR 1.4.1 (Nov 5, 2009)

  • Direct access to reports via URL (bookmarking and embedding of reports is now possible).
  • Ability to publish reports that do not require user login.
  • myDBR SQL Editor allows direct report authoring inside myDBR.
  • Navigation of reports using browser’s back and forward buttons.
  • Multiseries charts is now even easier to use. This will require small changes to existing reports.
  • Fixes parameter input problem and allows datatypes to be in all caps.

New in myDBR 1.4.0 (Nov 2, 2009)

  • Direct access to reports via URL (bookmarking and embedding of reports is now possible)
  • Ability to publish reports that do not require user login
  • myDBR SQL Editor allows direct report authoring inside myDBR
  • Navigation of reports using browser’s back and forward buttons
  • Multiseries charts is now even easier to use. This will require small changes to existing reports.

New in myDBR 1.3.3 (Oct 22, 2009)

  • Fixes an error where saving global preferences could not be saved.

New in myDBR 1.3.1 (Oct 6, 2009)

  • Fixes a date problem in 1.3.0.

New in myDBR 1.2.2 (Aug 31, 2009)

  • Fixes:
  • Fixes a security problem, where user could access reports without sufficient privileges.
  • Better error message when trying to use myDBR without proper database objects installed.
  • Changes:
  • Better error messages when Google Maps service returns an error.

New in myDBR 1.2.1 (Aug 31, 2009)

  • Works around a bug in older MySQL 5.0 installations, where text variables where handled incorrectly. As a result, report’s first parameters were not handled correctly
  • Better message to user in cases where myDBR is run under insufficient user privileges when using MySQL.

New in myDBR 1.2.0 Build 297 (Aug 20, 2009)

  • New features:
  • No more need for SUPER privileges when using MySQL. This allows myDBR to be installed more easily on hosted server.
  • Remember me feature in login page.
  • Enhanced extension interface. Ability to include CSS files..
  • Ability to copy table report content to clipboard. This allows fast data transfer to other programs.
  • Ability to copy Report Wizard code to clipboard with a button.
  • Documentation improvements.
  • Changes:
  • Extension handling changes. Reports no longer include every extension’s JavaScript-code to header. This can now be defined on each individual report. Resulting better performing reports.
  • Usability improvements on Admin-views.
  • Minor Report Wizard refinements.
  • Fixes:
  • Linked report work again after sorting.
  • Pager works again in Firefox.
  • Report map PDF/doc -generation works again.
  • MS SQL Server statistics reports date fixed.
  • MS SQL Server included defaults fixed.
  • Added more checks against misconfigured servers.
  • Titlebar no longer displays text “mydbr.mycompany.com”. User changeable (in defaults).
  • ChartDirector (image chart) report linking improved.

New in myDBR 1.1.0 Build 255 (Jun 30, 2009)

  • New features/changes:
  • Column sorting is again enabled.
  • Cross tabulation elements can now have predefined data columns. This will ease up cross tabulation usage in cases where data columns are not derived from the data.
  • Support for ChartDirector 5.0 release and some of it's new features.
  • Ability to define colors for individual charts.
  • Chart colors now support alpha channel.
  • Internet Explorer 6 & 7 can now use border-commands in row styles.
  • Easier to find About-screen in Admin-settings.
  • Styles and Parameter queries in Admin-settings are now sortable.
  • Fixed bugs:
  • Horizontal sum column's in cross tabulation reports behave now correctly when column styles are applied to the base column.
  • Image charts now work also when admin has disabled Flash charts.
  • Bar charts are now identical on Image and Flash charts (previously switching chart type caused data to be drawn in reversed order).
  • Free text elements on reports now adhere the dbr.keepwithnext command.
  • Row style definition was forced to be last in column. Now corrected.

New in myDBR 1.0.2 Build 248 (Jun 5, 2009)

  • Includes better troubleshooting for the installation.
  • The new version checks and informs about the missing database extensions and includes sample scripts (see user/troubleshooting) to test the database connection.
  • The version also corrects the rendering error in install page when used with Microsoft Internet Explorer.
  • If you already have the myDBR installed, there is no need to update.