Release Notes

This page describes releases of fSeries, including feature additions, changes, and bugfixes. Versions which have not been installed or released to customers are not detailed here.

• Full Release including fDocs and fPanels

• Bugfix: Access Role pattern check (must start with letter or underscore and may only contain letters, numbers and underscores)
• Bugfix: Functions - “compare” contains/isin fix (was inverse of expected value)
• change: fData - check for upper case version of fields when obtaining value

• Bugfix: Conversion of highlighters not set correctly for “all”
• Bugfix: fSeries API - embed Aspose licenses to remove evaluation notice
• Change: fSeries API - default x-output to “fData”

• Change: Conversion - carry over name of old system
• Change: Conversion - retain error/warning ticks (db change)
• Bugfix: Menus - API Document menu item fix to available document in designer

• Addition: APIs - list of current routes added to Routes edit page, to assist in design of RESTful API routes
• Change: Security DSDs - pass Email and AuthId to security DSDs to make it easier for DSD to get back to calling system

• Bugfix: Conversion - placeholder to function, particularly for #cluase()# conversion
• Bugfix: fTest - fix format of the “all data” download to valid JSON
• Bugfix: fData - allow all fields to be used in Rank type
• Bugfix: fPanels - adjust top margin of dashboard if heading changes height (e.g. when data version is displayed)
• Bugfix: Functions - DateAdd to use default date format if none specified
• Bugfix: fData - correct dependency sequencing to get data groups gathered in correct order (where multiple dependencies)
• Bugfix: fData - recursed data items to check their data group in case coincident name with other value functions

• Change: fPanels - tidy layout for mobile devices and allow designer to choose content and sequence
• Addition: Version - link to this page for Version page
• Addition: External API - new module to allow API access from non-fSeries systems (chargeable)

• Bugfix: fAdmin - User Download was not checking for lack of roles
• Bugfix: fAdmin - User Import was not defaulting to “User” role if none specified
• Change: fSeries API - ensure system knows when fSeries is accessing fSeries
• Change: Account Info - if account has no modules, none are considered activated - previously the opposite but no accounts should be set up without modules
• Change: Conversion - legacy link redirect to fSeries/Viewer.aspx now does same as fPanels/Viewer.aspx

• Addition: Added Logout button to error pages
• Change: Changed context link to help pages to user JS location.href instead of internal Redirect. Redirect with AzureAD Auth Method was causing user to be logged out when they opened help.
• Change: Versions - moved ScriptSettings value into code so automatically updated with WebSite version, but can be overridden for rapid changes to scripts if necessary

• Change: Remove unused setting in settings class
• Addition: fAdmin - added temporary-use fAdmin user for emergency and initial set up
• Change: Conversion - Menu Select option to default to true if attribute not in original (i.e. pre-3.8)
• Addition: fAdmin - allow fAdmin to update module activations by token

• Change: Audit Log Gatherer - trim precision of audit date (customer database refused long precision)
• Change: Conversion - prevent invalid blank fields being added to panel attributes
• Addition: API Source - allow addition of Open API file for non-fSeries API; Used to assist user when setting up data group
• Change: Minor typos in messages
• Bugfix: Dynamics CRM Gatherer - multiple common link entities not picked up in schema
• Bugfix: Create Link- not automatically changing link when “By Alias” checked
• Bugfix: Legacy Redirect - not converting alias using safe alias rules
• Bugfix: Menu Designer - not stripping pasted Font Awesome HTML properly
• Change: Select Page - disable Submit button on auto generate
• Bugfix: DB Initialize - only add SA user if account has been set up
• Addition: Functions - Added Env[ironment](variable) to return any environment variable's value

• Bugfix: Functions - loop prevention when establishing parameters
• Bugfix: Functions - FindValue now returns no value if no data group data
• Changes: Conversion - adjustments to errors and warnings
• Changes: fData - expand error message from failure to open DSD
• Bugfix: fData API - fix for non-fSeries API UI
• Changes: Conversion - additional error monitoring
• Changes: Conversion - handle missing fSeries folders
• Bugfix: Conversion - Lookup options: remove blank options and fix reversed value/text
• Bugfix: Dynamics CRM settings - missing parameter value
• Addition: Generic Data Group Settings - option to bulk enter parameters
• Changes: UseLogs - record CallerId (e.g. from API call)
• Changes: Help - open in new window
• Addition: Entity Usage - Usage pages now show last 30 uses of the entity
• Addition: Usage Usage - optional analysis of entity, user or general usage
• Bugfix: Select Page - true/false checkbox was not showing
• Bugfix: Functions - Case not properly comparing case insensitive
• Bugfix: Conversion - fDocs Chart table fix

• Change: Mosaic Form Gatherer - upgrade
• Addition: Conversion - Convert single fDocs Template
• Bugfix: API Source - hide external settings when fSeries API set
• Bugfix: Conversion - fDocs dgval conversion error
• Bugfix: fData - DSDDG UI not retaining Data Group setting
• Bugfix: Processes - Send As Files always applied
• Bugfix: Processes - error when saving changed function with literal text value

• Addition: Conversion - ClearCore plugin parameters
• Bugfix: Mosaic Form - permit Step Id to have placeholder
• Bugfix: Dynamics CRM designer - properly set source when only one present

• Bugfix: Functions - not wrapping parameters with commas in double quotes properly
• Bugfix: User Login - claims and validation DSDs need source info inserted before execution

• Bugfix: fDocs - New template error on save if “master file” changed
• Changes: fDocs - Typo in properties edit page
• Bugfix: fDocs/fSheets - new template not getting DSD Id when saving to database, causing immediate test of in progress to fail.
• Bugfix: Conversion - fSheets published templates not converted
• Addition: fPanels - handle missing data group in fPanels data
• Bugfix: fData - API data group editor was not handling optional elements in OpenAPI.json
• Addition: Function Definitions - add Environment synonym
• Addition: fAdmin Sources - improve use and test of environment variables in database connection source
• Addition: fData - in API data group edit, use default values from OpenApi parameter definitions
• Addition: fData - in API data group edit, allow addition of headers when OpenApi definition specifies none (in case required for authz but definition does not include them)

• Change: Functions - make all parameters available as functions (some were fixed values)
• Addition: Functions - add new function to retrieve value from fSeries Account Config
• Addition: fAdmin Sources - make fSeries Account Config settings available as connection string
• Addition: fAdmin Sources - make raw connection string hidden until user chooses
• Change: Functions - Environment variable allowed all variables, which is too open; now only those prefixed with fSeriesAccount.[account id].
• Bugfix: fMaps Settings - broke if no previous feature file set
• Bugfix: fPanels - prevent empty message being displayed
• Change: fMaps - minor change to prevent unnecessary access to Azure Maps search
• Bugfix: fPanels - new map to default type value of Points (was empty)
• Addition: fPanels - link from dashboard display page to it's primary DSD in fData
• Addition: fAdmin - option to create link to Start page with navigation

• Change: Data Gatherer - improve sort comparison (by object)
• Change: SQL Gatherer - overcome Microsoft ODBC driver error that does not return date/time data types correctly
• Bugfix: fData Api Data Group Designer - not getting form details
• Change: fPanels - improved tab targetting for links
• Bugfix: Dashboard - option to select new criteria did not persist navigation
• Bugfix: Import - not executing entity with same alias (Matched)
• Bugfix: fPanels Designer - layout preventing access to top row

• Bugfix: Import - further work on single entity import
• Bugfix: Dashboard - Url command not calculating placeholders
• Addition: fAdmin - show settings keys in Settings edit page
• Change: fAdmin - clear account cache before setting edit (to make sure latest being used)
• Bugfix: Entity Lists - fix filter by labels
• Bugfix: Export/Menu Generation - fix use of Index Labels
• Bugfix: fSeries Select - change target when not replacing to default _blank

• Bugfix: Fibonacci Super User - account clear not clearing new entity types
• Bugfix: Export/Import - references for alias matched item corrected
• Bugfix: Dashboard - error if WordCloud panel allows data view
• Bugfix: Dashboard - not showing charts series name if overridden in chart series settings
• Change: Menu - set new members to default to “Replace ” true by default
• Addition: Fibonacci Super User option to change menu member Replace settings

• Bugfix: Functions - DataGroupSum not working when specifying a function instead of a field
• Addition: Menus - allow preview of menu as top, side or main
• Bugfix: DSD Gatherer - not getting included list of DGs correctly
• Bugfix: Function Builder - breaking when data group in Value function is invalid
• Bugfix: Grid Gatherer - was not populating grid correctly

• Upgrade to .Net 6 - required before expiry of Core 3 in December
• Aspose Cells - upgrade to latest version - renewed license
• Aspose Words - upgrade to latest version - renewed license
• Highcharts - upgrade to latest version
• Font Awesome - upgrade to latest version + update type classes throughout (including all Gatherer definitions) + reduce size of installation
• fData - correct some project references
• Turf.js - use minimal js file, held locally to greatly reduce the download size of dashboards
• Bugfix: fAdmin - Custom Settings were not saving properly
• Addition: Functions - re-introduced Calc function
• Bugfix: fData - DataGroup Gatherer validation error
• Bugfix: fData - DSD Gatherer - was not finding DSD DG data groups correctly
• Bugfix: fData - Merge Gatherer - was setting Row Index and adding Merged From column in original data groups
• Bugfix: fPanels - map location failing on missing lat/lng or latlng value
• Change: fPanels - New Panel Details set up improved
• Change: fPanels - New Panel Id should be underscore letters and numbers only
• Change: fPanels - Dashboard nav bar: align all text, increase size of icons, move keyboard to right side
• Bugfix: fPanels - initial (fallback) panel class not being cleared when loaded
• Addition: Functions - reintroduced =Current() function
• Bugfix: fPanels Dashboard - improve “controlled by” filtering functionality
• Bugfix: fAdmin Entity Import - add new source types to page display
• Bugfix: fPanels Dashboard - improve targeting for links to other dashboards

• Bugfix: Add DB Initialize to .Net 6 Program.cs
• Bugfix: fDocs - not fully removing template record on Remove
• Change: fTest - make action logging safe in async DSDs
• Bugfix: Select - correct “lookup on change of” for live DSDs
• Change: fData - make cursors more efficient and safe
• Change: fPanels - map reload on error now tries once automatically
• Bugfix: fPanels - map reload fixed
• Bugfix: Conversion - Mosaic Form parameters

• Bugfix: fPanels Dashboard - improve handling of fields with dots, especially in grouped panels
• Bugfix: Mosaic Form plugin - improve manual entry and field names for schema
• Bugfix: Conversion - fDocs HTML tag was not converted
• Bugfix: Conversion - Mosaic Form form field values to upper case
• Bugfix: Select - did not do initial lookups for connected user entries
• Bugfix: fPanels Dashboard - fix targeting of link to other dashboards

• Bugfix: fPanels - chart from data with fields in dots fixed
• Bugfix: fPanels - map reload was double the legend display
• Bugfix: fPanels - setting target from fPanels command
• Change: fDocs - use multipart/form-data to upload template to avoid firewall limitations
• Bugfix: Entity Import - fSheets not importing
• Bugfix: Entity Import - specified alias not being applied
• Change: Export Account - only include published entities

• Bugfix: fPanels Dashboard - click through parameters duplicated
• Bugfix: Select page - 'lookup on change of' errors

• Change: fAdmin Imports - speed up display of list
• Addition: fPanels Export/Import - was not including Bounds Feature File
• Addition: fData Export/Import - was not including Lookup DSDs
• Bugfix: fData Usage - was not including Lookup DSDs
• Bugfix: fPanels - Dashboard link by alias not working
• Bugfix: fData - API design was not showing all parameter options on opening
• Addition: fData - API did not handle response of simple string array

• Bugfix: fData - correction to Json array in API gatherer / FlattenJson helper
• Addition: fAdmin Entity Import - option to accept all found aliases

• Addition: fAdmin - simple email tester; sends simple email to requested recipient; shows stack tract if exception occurs
• Addition: Forms Login - if Auto Authorise is on and AD login fails, the login attempted is shown on the login page.
• Addition: Title Prefix - account setting of a short text which prefixes all title (e.g. MyAcc:) helps identify the system in use in browser tabs
• Bugfix: fSeries Login - when using Forms, pick up correct value for user's AD login
• Bugfix: Functions - increase max length of value in 'In Quotes' functions
• Bugfix: fData - error when notifying fTest of changes made, if fTest window has been re-used
• Bugfix: fDocs Designer - pages not all using correct jQuery file
• Bugfix: fData Designer - User entry input issue with options list
• Addition: fSeries - option to add coloured strip at top of all design and admin pages to indicate which account is being used
• Bugfix: Entity Import - object Id values not being reset to new value (Super User Fix included)

• Bugfix: fAdmin Sources - select source without specifying type
• Bugfix: Emails sent over non-SSL connections now function correctly
• Bugfix: fData - API settings - some issues with UI options
• Bugfix: fSheets - reset data group pointer each time a data group set is generated
• Change: fAdmin - divided options into separate sections for clarity
• Change: fAdmin Sources - prevent change log recording encrypted values
• Change: Design History - tidy up of auto recorded “Unpublish” action
• Change: Change Log - tidy up of saved values to reduce db size and add consistency
• Change: Links to home page always specify /Home to aid sites not operating at top level
• Addition: Entity Usage - added “Uses” and “Flow” tabs to view what other entities each uses and how it fits in the flow from used to used by
• Addition: fAdmin Source - checks source is not in use in Live DSDs before allowing deletion
• Addition: Entity Create Link - add a link to jump straight to creating a link to the Start page
• Addition: fData - SQL settings - option to insert selected table and field names based on list set up in source.
• Addition: fAdmin - Database Connection Source - specify tables and fields to be available in SQL settings, with export/import option
• Addition: fDocs - Installer page to download Word manifest, with instructions
• Addition: fAdmin - option to send email to select users, based on roles, group and/or team
• Addition: fData - option to format true/false field values (e.g. as Yes/No)
• Addition: fData - optional placeholder in external input box when user selects criteria
• Addition: fData - optional entry mask for text external inputs, to enforce a pattern of entry
• Addition: fAdmin - option to download and/or clear Change, Use and Audit Logs

• Experimental: fData - new plugin to get response from Chat GPT artificial intelligence chat bot
• Bugfix: fData - using Audit Data as lookup did not pass connection string so returned no values
• Bugfix: fData - rank plugin now correctly calculates filter functions
• Bugfix: fData - masking user entries javascript issue fixed
• Bugfix: fData - log data plugin now runs correctly when used in user entry lookup lists
• Bugfix: fSheets - ignored fields with spaces in name
• Bugfix: fSheets - asking to publish a template when uploading now correctly publishes
• Bugfix: fSeries - email test no longer crashes if an error is encountered
• Bugfix: fSeries - emails sent over non-SSL channels now correctly pick up setting from app config
• Addition: fSeries - times are now shown in local country time rather than UTC
• Addition: fSeries - setting to make Alias a mandatory field
• Change: Entities - entity names consistent

• Bugfix: APIs - API edit error on alias when alias is required
• Bugfix: fAdmin - User New Registration not setting time zone correctly
• Bugfix: fSheets - calculate formulae after generation
• Bugfix: fMaps - feature file not being picked up in export when used for bounding only

Note: includes database migration

• Addition: APIs - filter by index labels
• Addition: Processes - permit max expiry for token (18/1/2038)
• Addition: Processes - add index labels
• Addition: Processes - option to set notification email's priority level
• Addition: Processes - ability to specify external link as item
• Addition: APIs - key/value pair format
• Addition: APIs - test option within fSeries Route designer
• Addition: Functions - Trim, to remove start/end spaces
• Addition: Mosaic Plugin now can use Workflow Step or Form Id
• Addition: fSeries - Onboarding Process
• Addition: fSeries - enable max users per account
• Addition: fSeries - Recents - all pages now have dropdown with direct link to selected recently visited pages (e.g. entity display pages and sources)
• Addition: Functions - GetValue, to get a value from a row located by its row index
• Change: Functions - FindValue restructured for better performance in large data groups
• Bugfix: fAdmin - Imports to work correctly with multi-accounts
• Bugfix: fSeries - Select page link with date values (now reverse date used)
• Bugfix: fAdmin - import of Processes and APIs improved
• Bugfix: fData - merged Data Items were missing from schema - now included as fields (not Data Items as they have become raw)
• Experimental: fData Machine Learning - new module (requires license)

• Addition: Machine Learning module
• Addition: Dataverse source type and gatherer
• Addition: Option to edit entity JSON

• Bugfix: APIs - include Query String parameters in API Test
• Bugfix: fData - recognise DataGroup context in data gatherer (substitutes DSD)
• Bugfix: fData - New DSD Steps error when Alias not required
• Addition: Help - link to downloadable documents added to Help page
• Bugfix: Menus - Title now shows without having to have a sub title
• Bugfix: fData - prevent removal of data group with dependencies
• Change: Spelling of authorization changed to UK where visible
• Bugfix: fAdmin - Source type cn, prevent escaping of connection strings
• fPanels: Import of Content Commands was not converting to new menu id

• Bugfix: fData- Abandon checkboxes not being maintained properly
• Bugfix: fAdmin - Source (cn) not escaping connection string \ correctly
• Bugfix: fSeries - Select not handling checkbox inputs correctly

• Change: fData- SQL option for query timeout

• Change: Machine Learning - new model type: Data Classification - multiple classifications from table of features.
• Change: Machine Learning - additional information about training results

• Change: fPanels - option to have preset filters applied in Filter type panel

• Change: fSeries- change to fPanels to prevent CORS issues

• Addition: fLite - set up and management of fLite stand alone fDocs/fSheets
• Addition: fData - Xml Data download direct from DSD
• Update: All projects updated to .Net 9 (.Net 8 caused significant slow down of data gathering)
• Addition: fData - Single Row indicator duplicated into Data Group General options (same as fDocs Design At Top Level)
• Bugfix: fData - GeoJson, Grid, Notification, Rank and Values data group type were not operating properly when acting as a parent data group
• Update: fData - ServicePointManager.SecurityProtocol obsolete. Code changed throughout

• Upgrade to Bootstrap v5
• Upgrade MDB for Bootstrap v5
• Upgrade SummerNote for Bootstrap v5