Tabulizer Change Log

Release 6.0.30 2016-08-04
  • Improved ReTabulize functionality to remove "leftovers" from tables previously created with Tabulizer.
  • Added new features to improved greatly memory consumption and execution time when reading very large Excel files.
  • Added a fix for the PHP xml reader bug
  • Various bug fixes.
Release 6.0.25 2016-05-16
  • Added support for graph series that contain empty values.
Release 6.0.23 2016-04-12
  • Added support to refresh data source cache(s) using a cron job.
Release 6.0.22 2016-04-08
  • Added support for calls to customized javascript code every time a table with dynamic features is refreshed (e.g. sorting, pagination, filtering).
Release 6.0.21 2016-04-06
  • A minor change in the range column filter.
Release 6.0.20 2016-03-15
  • Changed the implementation of Tabulizer for Wordpress so it's compatible with EventBlender for Wordpress.
  • Changed the upload file method so it works well in Joomla 3.4.
  • Fixed various bugs.
Release 6.0.15 2015-05-19
  • Fixed a type that was causing a fatal error when using data sources.
Release 6.0.14 2015-05-17
  • Data source parameters are acceessible to modification functions, when present.
  • XML data source params are hidden properly.
Release 6.0.13 2015-04-21
  • Fixed a bug that was affecting the table export feature when there were column filters in the table.
Release 6.0.9 2015-04-21
  • A new feature allows to specify the data type of the columns manually that is important for column sorting.
Release 6.0.8 2015-03-11
  • Fixed a bug that occurs when there is only one data source.
Release 6.0.7 2015-03-06
  • Fixed a few minor bugs.
Release 6.0.6 2015-02-17
  • Add an automatic detection for conflicts between responsive pattern of type scrollbar and datatables scrollbars.
  • Add protection against user parameters of type text.
  • Fixed a bug affecting the Excel extraction, when there are references to other sheets and cells outside the specified region.
Release 6.0.5 2015-02-16
  • Fixed a bug affecting graph axis ticks with custom formatting.
Release 6.0.4 2015-02-12
  • Add support for reading table data from an XML file.
  • Add support easily clearing the data source cache without editing each individual data source.
Release 6.0.3 2015-01-21
  • Fixed a bug that affects sorting.
Release 6.0.2 2015-01-20
  • Check the existence of the PHP Data Objects (PDO) extension before utilizing it.
Release 6.0.1 2015-01-19
  • Fixed a minor bug.
Release 6.0.0 2015-01-16
  • The grid editor. When entering the table data, choose between the standard plain text editor or the grid editor that creates a spreadsheet-like experience with copy-past commands, row/column additions and deletions with a just few clicks.
  • Cleaner User Interface. For instance, the Excel importation is placed on a separate tab, while new tabs from importing data from a CSV file or an external Web Page are not integrated in the Tabulizer popup. More data integration options (databases, RSS feeds, etc) are still available via the use of a data source.
  • The ability to export ruleset archives. This is very useful when migrating your site to a another server, a newer version or different platform (from Joomla to Wordpress or vice versa). Also it's safe and easy way to get backups of your existing rulesets.
  • The ability to export data sources. Very helpful when you are migrating your site, but also a very convenient way to get backups of your data sources.
  • The ability to publish data sources. Want to share data with other sites? Tabulizer gives you the power to become a data publisher, while the other end will consume these data using its own styling preferences.
  • Search the dynamic content of the data sources [Joomla platform]. A new search plugin makes the contents of the data sources searchable using the standard Joomla search box.
  • Make copies of a ruleset with a single click. This is a highly requested feature and it's ideal for those who want to make modifications to an existing ruleset without starting from the beginning.
  • Connect to an external database via a data source. A new data source type, called "external database/query" allows you to fetch and display data from a remote/external database table or query without the need of the proxy script.
  • User parameter sharing between data sources and rulesets. This is a big one but it's hard to explain without a specific example. Basically, user specified parameters will be available to the ruleset modification functions creating really interesting results such as a monthly event calendar!
  • New rule parameters and refinements. For instance, it's possible to set an HTML attribute to all table elements that fall into a certain range.
  • WCAG 2.0 compliance. New parameters and rules so your can build an HTML table in accordance with the Web Content Accessibility Guidelines (WCAG).
  • Various improvements and bug fixes.
Release 5.2.18 2014-10-03
  • Now th column filtering works better with 3rd party extensions that hide/show Tabulizer tables.
Release 5.2.17 2014-10-01
  • Fixed a bug affecting search highlight functionality.
Release 5.2.16 2014-09-29
  • Changed the width calculation method for Chrome browsers.
Release 5.2.15 2014-09-11
  • Fixed a bug affecting multi-line SQL queries.
Release 5.2.14 2014-09-11
  • Fixed a bug affecting server side processing with header selection responsive pattern.
Release 5.2.12 2014-09-11
  • Fixed some bug regarding the Wordpress version and the "element section" feature.
Release 5.2.11 2014-09-08
  • Made some changes in the code that handles modification function arguments to allow white space and double quotes.
Release 5.2.10 2014-09-03
  • Change the way vertical scroll with fixed top header works, to handle more gracefully conflicting issues in other parts of the page.
Release 5.2.9 2014-08-30
  • Change the way Tabulizer handles Excel images of unknown type.
  • Fixed a bug so Graphulizer can handle correctly labels with quotes
  • Fixed a bug so column filters of type range can handle well long numbers using comma as their decimal separator.
Release 5.2.8 2014-08-25
  • A few minor fixes.
Release 5.2.7 2014-08-22
  • Fixed a few more bugs regarding server side processing and responsive header selection along with server side processing.
Release 5.2.6 2014-08-21
  • Reworked the server side processing, so some previous limitations are gone, along with a few bugs.
Release 5.2.5 2014-08-19
  • Added a new features/options to responsive patterns Header Selection and Fixed Left Header + Expand.
  • Fixed a few bugs regarding the responsive patterns Header Selection and Fixed Left Header + Expand.
Release 5.2.4 2014-08-16
  • Fixed a bug regarding captions in table split.
Release 5.2.3 2014-08-15
  • Fixed a bug regarding closing DIVs in server side processing.
Release 5.2.2 2014-08-13
  • Add the character encoding parameter in the data sources, so it is possible to read external files and web pages encoded in other than the default UTF-8 charset.
  • Fixed a minor bug that was affecting server side tables.
Release 5.2.1 2014-07-28
  • Minor changes in the implementation of two responsive patterns.
  • Added some tips for the data source file path.
Release 5.2.0 2014-07-28
  • Now it's possible to upload a file (e.g. Excel document) used by data source directly from Tabulizer's panel, without the use of FTP client. This also makes easy to distribute ruleset archives that include the data source and the data file.
  • RSS feed can be read the turned into a table for further processing (Atom and RSS2 formats).
Release 5.1.2 2014-07-24
  • Fixed a bug that was affecting the display of the Export Table button under certain conditions.
Release 5.1.1 2014-07-21
  • Changed the implementation of server side table loading to support new features.
  • Table footer feature was added.
Release 5.1.0 2014-07-14
  • Changed the internal implementation of some core functionality. As a result of that there are no dependencies in jQuery library and therefore no conflicts.
  • New features have been added and will be demonstrated and documented later on.
Release 5.0.10 2014-06-01
  • Changed the literals for some data tables labels.
  • Fixed a bug that was affecting the numeric comparison ranges.
Release 5.0.9 2014-05-23
  • The range EMPTY (for empty cells) is now officially part of the available row, column and cell ranges.
  • Fixed a bug in the split table display.
Release 5.0.8 2014-05-14
  • Changed the way Table Export works, so now even non visible rows due to pagination will get exported.
  • The custom javascript file for dataTables operation is optional and separate from the rest of distribution. This keeps it safe from accidental removal when a new release is installed.
Release 5.0.7 2014-04-28
  • Removed a notice that was displayed when creating new data source, if the STRICT STANDARDS were enabled.
Release 5.0.6 2014-04-27
  • Made some minor changes. Now you can fully preview the data sources.
Release 5.0.5 2014-04-21
  • The inclusion of required CSS/JS files became smarter in order to avoid the inclusion of duplicate copies of the same resource.
  • Fixed a bug that was affecting multiple tables on the same page that were using the fixed-left, scroll responsive pattern.
Release 5.0.4 2014-04-18
  • Fixed a bug that was causing multiple copies of the same export table buttons, under certain conditions.
Release 5.0.3 2014-04-17
  • Fixed a bug to render Tabulizer tables properly, if outside the content component (e.g. modules, other components, etc)
Release 5.0.2 2014-04-15
  • Fixed a bug in graph display, to remove outer graph border properly, if needed.
Release 5.0.1 2014-04-13
  • When creating a data source of type "Database Table/Query" the query parameter can contain HTML code.
Version 5.0.0 2014-04-11
  • Reworked the core engine to remove STRICT STANDARDS warnings, improve flexibility and extensibility
  • Re-order the fields and introduced new tools in some common tasks to improve usability
  • Changed the data source cache implementation in order to improve performance. Server side table loading is now faster up to 10x.
  • Changed the column filtering in order to support new search methods, such as:
    • numeric range
    • exact match
    • starts with match
  • Responsive design support has increased for data tables with sorting, filtering and pagination.
  • Nicescroll jQuery script has been integrated for more smooth scrolling interaction with the end user
  • Theming is now available just for the filtering, pagination and sorting controls.
  • Rules now have priority field that can overwrote the default order of execution.
  • You can merge multiple data sources to produce a single table
  • When importing an Excel file you have much more options to control background color, font styles, etc.
  • Excel sheets can reference other sheets.
  • Fixed bugs.
Revision 4.1.13 2014-02-24
  • Changed the data source cache implementation in order to improve performance.
  • Changed the naming of the temporary images exported from an Excel file in order to improve efficiency.
  • Changed the way custom Javascript code is added, in order to avoid a Joomla bug that causes multiple copies of the same javascript code when cache is enabled.
  • Changed the handling of Email Cloaking plugin conflicts and set it to automatic by default.
  • Fixed a bug regarding image extraction from an Excel file.
Revision 4.1.12 2014-02-13
  • Changed the internal order of execution for the table modification and row/column removal rules, so they are executed after the CSS styling rules.
Revision 4.1.11 2014-02-12
  • Changed pagination in rulesets and data source views, so now it's done on client side. Additionally, you can search/filter rulesets and data sources using the builtin tools of Tabulizer.
Revision 4.1.10 2014-02-11
  • Column consistency works now as expected in data source settings.
  • Increased the maximum length a database query can have in data source settings.
Revision 4.1.9 2014-02-08
  • Fixed a bug, so now the column removal rules are working as expected.
Revision 4.1.8 2014-02-06
  • Fixed a minor bug that affected the persist header option for the header selection responsive pattern.
Revision 4.1.7 2014-02-05
  • Fixed some non-properly formatted language strings.
Revision 4.1.6 2014-02-05
  • Fixed a bug in gauge-meter graph. Now the interval colors are shown as expected.
Revision 4.1.5 2014-01-30
  • Removed and compressed some javascript file so the installation zip file in less than 2MB.
Revision 4.1.4 2014-01-30
  • Fixed a bug related to column filtering feature that also affects other dynamic features.
Revision 4.1.3 2014-01-29
  • Fixed a bug related to column filtering feature.
Revision 4.1.2 2014-01-28
  • Reworked some js libraries in order to avoid to notorious jQuery conflicts.
  • Fixed a bug that was causing extra slashes to be added to table prepend and table append fields, when magic quotes were on.
Revision 4.1.1 2014-01-28
  • Fixed a bug that was making impossible to add user defined parameters in the sheet selection field of a data source.
Version 4.1.0 2014-01-25
  • Table data can be downloaded as file (CSV, Excel) and/or emailed to user selected recipients
  • Graph image can be downloaded as file (png,gif,jpg) and/or emailed to user selected recipients
  • Graphs can be responsive
  • Graphs can be resizable
  • A new rule was introduced that allows you to remove rows and columns from the input table data based on certain criteria, like remove all rows that have a date value in the 3rd column that is older than the last 30 days or remove all column that contain the text value "Cancelled"
  • Data sources can contain user defined variables or system parameters. You can use this feature if you have multiple data sources that vary only slightly,or you want user customized output.
    • Example 1
      A data source can have a database query similar to SELECT * FROM #__orders WHERE user = {user_id}. The parameter {user_id} will be replaced by the actual user id of the currently logged in user and as a result, each user will see a different table view with this personalized data. Another exam
    • Example 2
      A data source has a database query to show a list of articles similar to SELECT * FROM #__content LIMIT {user_param_1:int}. The parameter {user_param_1:int} is user defined variable (of type integer) and it will be replaced by the actual value given either in the editor (while inserting the data source) or in the GET/POST request.
  • You can search/filter the table in two ways, either all table rows and columns or specific columns. You can filter specific column either by using a input text box per column or a select box per column.
  • You can pre-populate the table search/filter boxes with values given in the URL of the page.
  • When sorting the table, you can ignore some header columns (i.e. have no sorting controls)
  • The sorting header is not anymore necessarily the top row, but it can the 2nd row, the 3rd row, etc.
  • The table can have sorting controls without being initially sorted
  • Some new ranges have been introduced that allows you to select rows, columns or cells based on cell value comparison for a specified data type. For instance, you can select all rows the in the 5th column contain a date that is more than 30 days older from now.
  • A catch-all custom function can be defined to pre-process the table data before the rest of the rules are applied.
  • A new experimental feature has been added that is essential for very large input data. Using server side processing, only the necessary data will be loaded on the client side (browser). The rest will be loaded dynamically via Ajax when needed.
  • The data source cache has been reworked so it can handle real large data.
  • A lot of minor bugs have been fixed
Revision 4.0.24 2013-12-06
  • Fixed a bug that was making impossible to select the "horizontal scrollbars" responsive design.
Revision 4.0.23 2013-11-28
  • Reworked the responsive design patterns. There were a few issues with older Android devices that could display properly the scrollbars. Also, some CSS properties were modified.
  • Change the replacement "from-to" path separator character from ^ to : in the "System - Tabulizer jQuery" plugin parameter "Remove Path(s)". Example:
    Now the path1 and path4 will be removed, while path3 will be replaced with path4.
  • Added support to make a graph resizable and responsive.
Revision 4.0.22 2013-11-18
  • Rewrote the System - Tabulizer jQuery plugin, to remove user specified javascript files. This is necessary in cases where there is jquer conflict with other extensions.
  • Add a new experimental feature, to allow users to download and email a graph or a table as a file.
  • Fixed a bug in the pagination of the data sources.
Revision 4.0.22 2013-10-28
  • Fixed a bug in the "System - Tabulizer jQuery" plugin to detect properly the presence of Tabulizer directives.
Revision 4.0.21 2013-10-28
  • Add proper handling of Excel cell with new line character, which are converted to <br/>
Revision 4.0.20 2013-10-18
  • Called TabulizerEncoding::initMBString() that will try to replace missing MBString function with proxy latin-only functions. Even though MBString library is installed in almost all PHP environments, it's not a standard library and therefore it may be missing.
Revision 4.0.19 2013-10-18
  • Increased the maximum size an Excel file can have to 8MB.
  • When reading hyperlinks from an Excel file, if they contain single quotes they will be converted to double quotes so they don't break in the resulting HTML code.
Revision 4.0.18 2013-10-12
  • Add support for removing multiple copies of the jQuery lirary load by other extensions. This was causing problems to advanced Tabulizer features such as table sorting and filtering.
Revision 4.0.17 2013-10-09
  • Add support for relative paths in data sources.
  • Add support for proper table sorting with dataTables, where the columns contain numbers with commas, or percentages.
  • A user theoritcally can add his own data types.
Revision 4.0.16 2013-10-02
  • Change the way User Preferences are stored in the database, so there are "user specific" and "system specific". This affects mainly the preferences for loading the jQuery/dataTable libraries.