Changelog

Follow up on the latest improvements and updates.

RSS

new

fixed

improved

accoMASTERDATA

v1.1.15.2

New accoMASTERDATA release: v1.1.15.2

Version 1.1.15.2 brings the following fixes and improvements::
  • Fixed a scenario that would crash the visual
  • Fixed a bug causing some conditional formats to not work when using '&'
  • Checkmark columns(Boolean) can now have prepended/appended characters
  • Fixed a bug causing the "Not Equal to" context menu item to not work for checkmarks
  • Fixed a bug causing the settings checkbox "Create row with pop-up window" to sometimes be disabled unintentionally
  • Fixed right click context menu for boolean type columns, showing some incompatible filtering options
  • Fixed "Single select" formatting option for Boolean column type being unable to deselect all, causing single select to invert.
  • Improved writeback to now be compatible with database triggers.
  • Restricted cross filterting to require holding the Ctrl when clicking on a cell. (allowing for cell edits while filtered)
  • Column specified default values now skips validation (Allowing for default values outside validation range)
  • Implemented "Group expanded" toggle for column groupings, to set if grouping should be expanded by default
  • Implemented "Rich Text" as a formatting option for string columns
  • Implemented "Single select" formatting option for boolean columns
The new release is available now from AppSource.

new

fixed

improved

accoMASTERDATA

v1.1.14.2

New accoMASTERDATA release: v1.1.14.2

Version 1.1.14.2 brings the following fixes and improvements::
  • Fixed a bug causing lower resolution of visual when in PBI service and a scroll bar is visible.
  • Fixed row creation form elements not being aligned
  • Fixed some incorrect spacings in multiline cells
  • Fixed a bug causing new measures to not be properly registered by the visual
  • Fixed some minor UI elements in settings
  • Fixed required value setting for dates
  • Fixed Validation for dates
  • Fixed new rows having empty default values instead of Nulls
  • Fixed being able to toggle between dropdown KV or not when a PBI conditional formatting measure was used
  • Implemented a way to use transaction keys for new rows. An input field with PBI conditional formatting, is generated in the Formatting settings panel, for each transaction key measures in the measure well. Using this input field, allows for specifying the transaction key value to be used for new rows.
  • Now allows server port delimiter to be either "," or ":"
  • Implemented pagination for dropdown options in the settings window.
  • Added styling of percentages in different colors
  • Added setting to allow custom values in dropdown
  • Adjusted dropdown option order of Key value in the UI, to match the naming convention.
  • Implemented notifications in the toolbar. Will contain messages from accobat when needed.
  • Added context menu option to "Search for value using google"
  • Added writeback option "Ignore empty cells in rows" for ignoreing blank cells when saving.
The new release is available now from AppSource.

new

fixed

improved

accoMASTERDATA

v1.1.13.1

New accoMASTERDATA release: v1.1.13.1

Version 1.1.13.1 brings the following fixes and improvements:
  • Fixed the UI alignemnt of some elements
  • Fixed a bug causing datetime to be shifted by the timezone offset of the client due to localization. Now datetime is consistant from the client to the database and back.
  • Fixed Default values not working for dropdown columns
  • Fixed Conditions with date not working
  • Fixed Conditions with calculated columns not working
  • Fixed a bug when creating a row when no existing rows in grid or row with null id. Causing the id auto increment to return null.
  • Fixed a bug, causing new rows with string as id's to not be able to be saved.
  • Fixed a bug, causing paste of across columns to not function properly
  • Fixed Special column formantting not displaying properly for new rows
  • Fixed a bug causing relative splashing to multiply the value relatively across cells rather than devide.
  • Fixed some incorrect info in the info panel.
  • Fixed pagination not working properly when infinite scroll was disabled.
  • Fixed shadowcalculations being able to be created without at least one measure reference in the formula
  • Fixed incorrect error "unexpected end of JSON" when license was missing for writeback
  • Fixed a bug causing invalid dates to not be properly checked before saving.
  • Implemented UpdateDate and UpdateDetails for writeback table, using the same Timestamp and Username stamp from auditlog, mirrored into connection
  • Implemented Transaction Keys, with a new "Transaction Keys" measure box
  • Improved some error messages to be more user friendly
  • Implemented Shadow Calculations for string columns (concat)
  • Improved measure boxes to now be compatibled with simple columns(data model)
  • Improved dropdown menus to now expand to fit long option
  • Improved String inputs to allow multiline inputs
  • Implemented allignemnt for checkbox columns
  • Implemented rightclick contexmenu button to reset filters
  • Improved date time formatting and moved it to be per-column in Settings->Column tab
  • Improved UI for creating calculated columns
  • Improved writeback for columns inserts to only insert on columns defined in the visual
  • Improved settings for dropdowns to be applied automatically, eliminating the need for an apply button
  • Improved the UI for creating rows via Form.
  • Moved create row with tab to general settings.
  • Improved Auditlog SQLQuery optional column to now quote string inputs for better copy paste reuse.
  • Improved scrollbar in grid to now follow when tabbing through columns.
  • Implemented Multiline "Display Value As" for text columns.
  • Updated Icons for data wells being able to contain both Measures and Datafields with both icons.
  • Improved splashing UI
  • Changed handleing of Key Value dropdown pairs, to now show label in both dropdown and cell, but sends value to DB.
  • Implemented dynamic local storage of user specific usestates, these include [Column width/Row height (dragged), Recent colors (colorpicker), Collapsed/Expanded groupings, Sorting, Filters]. Note this feature requires explicit allowence in Powerbi to function.
The new release is available now from AppSource.

new

improved

fixed

accoMASTERDATA

v1.1.9.3

New accoMASTERDATA release: v1.1.9.3

Version 1.1.9.3 brings the following fixes and improvements::
  • Fixed validation testing field not being inclusive for Min/Max.
  • Fixed visual grid being limited to 1000 rows, now allows rendering of up to 30000 rows (max limit from powerbi api).
  • Fixed "Required value" settings toggle & "Make field required" column header option, to now properly require a value to save.
  • Fixed prepend/append disapearing when swapping to and from percent format.
  • Fixed grouping on calculated column not working properly
  • Fixed UI for toolbar save button being too low & and save counter being too high.
  • Fixed disabled toolbar buttons, not properly using the configured style.
  • Fixed calculated column crashing the visual if ' or . was used in the calculation formula.
  • Fixed a bug causing Paste (copy&paste) across multiple rows to sometimes paste on incorrect column.
  • Fixed some column header buttons not applying theme color correctly.
  • Fixed a crash occuring when entering dropdown settings with no measures configured.
  • Fixed a bug causing measures to sometimes not be added to the grid when a custom state was saved.
  • Fixed a bug causing initial state to be reset when columns settings was interacted with.
  • Fixed a bug where date formats didnt properly follow the format set in the measure.
  • Fixed column header alignment not applying
  • Implemented initial support for fabric writeback. This is a limited implementation, with some restrictions due to the missing Identity in fabric warehouse, and unsuported OUTPUT keyword (For this initial implementation, Inserts of new rows is only possible when rowID is string due to the missing identity in fabric warehouse. Auditlog is limited due to the missing OUTPUT keyword, making id's in auditlog inconsistant)
  • Developed first implementation of Selfhosted API for accoMASTERDATA.
  • Implemented column grouping, allowing for columns to be grouped an being collapsable, can be configured in the settings->grouping tab.
  • Implemented formatting options for Boolean type columns, (Checkbox, Toggle switch).
  • Implemented functionality for Exporting and Importing of report settings/configuration, Exported settings comes in .JSON format, Import settings from .Json or .txt
  • General improvements to settings UI
  • Implemented and improved Paste functionality across multiple cells. (Replace/Even/Relative)
  • Improved settings UI for Validation/Conditions.
  • Adjusted icon size of Prepend/Apend icons to scale with font size.
  • Removed functionality of creating a new row after input in last cell of created rows.
  • Implemented option "Create new row with tab" to create new row when pressing Tab while the last cell of top row is selected. (default: off)
  • Implemented Dynamic default values for Measures & RowID's, via measures(pbi conditional formatting) in pbi formattingsettings pane.
  • Improved SQL differenctiation between Azure/fabric SQL and Fabric warehouse, for better compatability.
  • Implemented Fabric writeback via cloud API.
  • Implemented Fabric writeback via SelfHosted API (Retroactively)
  • Improved the date/time formatting and moved it into columns settings, making the format per column.
  • Implemented additional aggregations for string columns (Min, Max, First, Last, Count, Distinct Count).
  • Implemented a checkbox to column groupings which determines the default Expanded state.
  • Implemented Percentage slider as a formatting option for number columns.
  • Added dynamic formatting string for calculated columns.
  • Implemented single click for boolean columns (checkmarks/toggles).
  • Implemented ability to delete multiple selected columns at once.
The new release is available now from AppSource.

new

fixed

improved

accoMASTERDATA

v1.1.5.2

New accoMASTERDATA release: v1.1.5.2

Version 1.1.5.2 brings the following fixes and improvements:
  • fixed RowID not using "Writeback column name" setting
  • fixed setting box being able to be dragged outside window.
  • fixed writeback keybind adding an empty change to pending changes, causing the API to reject the writeback attempt
  • fixed custom calculations not working with decimal values with comma seperator
  • fixed empty conditions overwriting others by disallowing empty conditions
  • fixed unresponsive selecter on column "display value as" setting
  • Implemented a Temporary fix for Identity columns failing to write to Auditlog
  • Fixed MUI license sometimes not applything properly
  • Fixed being able to put special characters in condition titles, causing conditions to break.
  • Fixed auditlog handleing of Identity writeback columns when creating rows, now uses output from writeback to identity columns for auditlog.
  • Fixed Date type columns having an empty string instead of NULL as value on creation.
  • Fixed editing of custom calculated columns causing making values apear blank.
  • Fixed handleing of Toggle on rules to properly disable and enable.
  • Fixed Validation Min and Max to be inclusive instead of exclusive
  • Fixed Validation Apply button being grayed out for date columns.
  • Fixed being able to remove validation for a column.
  • Settings dialog styling updated
  • Added keybind when making dropdown options to begin a new option (Enter)
  • Added section for default values on columns for Row creation, under Settings -> Column "Row Creation"
  • Added filtering options to context menu when right-clicking on a cell
  • Improved user feedback for several actions
  • Added button with label for String operator in the condition flyout
  • Added toggles to conditions in the condition list which allows for disable/enable of conditions
  • Implemented automatic trimming of leading and trailing spaces on server name for connection
  • Added email syntax to the URL formatting of strings columns.
  • Added option for prepending/apending of icons for conditions
  • Added group names for the respective groups when grouping on columns
  • Added new QuickFilter feature to the toolbar, allowing for quick ad-hoc filtering on the grid
  • Implemented flyout for custom calculated columns with selectable column tokens.
  • Added initial Implementation for Percentage as a "Display value as" for numeric column types
  • Added custom calculated columns as option for conditional formatting(Conditions)
  • Improved Telemetry
  • Improved performance of pasting data into the grid.
  • Implemented Pasting options for Numeric data, Replace/Even/Relative
  • Added visual indication of which column is grouped on, when grouped on multiple columns
  • Improved UX for Tags to now include a multiselect dropdown list of all current tags and previeously typed during the session.
  • Implemented an indicator on column headers when configured as dropdown.
The new release is available now from AppSource.