Changes for version 0.005.1 - 2026-08-30
- Bug Fixes
- Fixed compatibility with Database::Abstraction >= 0.41. D::A 0.41 changed dbname to fall back to the class-name suffix rather than the table parameter, so a dynamically-generated package like Database::BI::_DB::Orders was used as the filename stem (Orders.csv) instead of the lowercase table name (orders.csv), causing "Can't find a file" errors on case-sensitive Linux filesystems. DataSource::_init_backend now passes dbname => $table explicitly so the filename stem is always correct regardless of D::A version. Minimum Database::Abstraction version bumped to 0.41.
- Columns containing accounting-style negative amounts - values written as (1,234.56) rather than -1,234.56 - are now recognised as numeric and handled correctly throughout the application:
- Column sort: clicking an Amount header now sorts correctly, with parenthesised values treated as negative numbers rather than being sorted as text or treated as positive values.
- Y-axis selector: columns whose values use accounting notation are now included in the "numeric columns" list for line graphs, so Amount (and similar columns) appear in the Y-axis dropdown.
- Line graph: Y values in accounting notation are plotted at the correct negative position on the chart rather than at their absolute value. The fix adds a parseAccounting() helper in the browser (shared by sort and graph detection) and updates the server-side graph_view Y-strip logic to detect the leading '(' before stripping non-numeric characters.
Documentation
Modules
Web-based Business Intelligence viewer for flat data files
Home picker, filesystem browser, table viewer, left-join engine, result filter, export, and file upload
Table-agnostic adapter around Database::Abstraction