Perfion 2025-R1

Perfion 2025-R1 SR1 (5.6.4)

June 30th, 2025

Database Installer

Database - Installation guide

Application Server

Application Server

API Service

Installation guide

Web Client

Web Client - Installation Guide

Windows Client

Windows Client - Installation Guide

Supplier Portal

Supplier Portal - Installation

API Tester

New Importer: Ambiguous selectable value handling added

When using the IMPORT.FEATUREDATA-action you now have one more parameter available, named AmbiguousSelectableValueHandling. This parameter allows you to control how the importer treats importing a selectable value that is shared by multiple items. The parameter can be set to one of the following 3 values

• Fail: The importer stops (default). Finding two or more items with the same value causes importer to stop with an error. This was how it worked in previous versions.

• Create: The importer picks any of the two items and assign that. The importer issues a warning when this happens. 

• Ignore: The importer ignores the item. 

Note: If a feature value is ambiguous, but the value is already assigned to the feature on some item, then the importer will reckon the value as "not modified" and not do anything. I.e. assume you have a selectable feature named Color and there are two Color-items that hold the value "Red". Further assume that some "Product" already holds the value "Red" (any of the two) of this Color-feature. Now say that the value "Red" is imported to that product. The importer will not do anything, since importing "Red" is not considered a modification. Now if the original value was "Green" the setting will be consulted to check which behavior is wanted. 

Note further: This parameter does apply to multi value- as well as to single value-features. It does not, however, apply for hierarchical features, for which the importer will always stop with an error. 

Import wizard ignores selectable values that are shared by multiple items

Null value in DB table SupplierPortalExposedBaseFeatures prevent Feature deletion - A bug in the database installer incorrectly creates a row with nulls in table SupplierPortalExposedBaseFeatures which blocks deletion of Features.

SELECT.API no longer sets 'charset' in content-type header when using default encoding

Previously, the SELECT.API Action command would set 'charset' in content-type header when using default encoding (UTF8).  Now, if the @Encoding parameter is not set, the 'charset' will not be appended.

Added handling for uploading single Binary to multiple Items

It generates guids for each of the binaries, and assigns them properly to the items in question.

Missing remote values could show as "No value"

Since version 2024 R2 of Perfion, the grid in the windows client could show "No value" for a remote feature, not containing any value. This has been fixed, so that now the client again simply shows a blank cell. This is just as we do for "non remote" explicit features. Localizable selectables, not containing a value for some language, still shows "No value". This behavior was introduced in 2024 R2 and kept. 

Unique Values also considered base value in some cases.

In previous versions of Perfion, when evaluating whether a value was unique or not, the base value for all items were included in the check. This meant, that when setting, say, a unique EAN-code to "123", it would not only fail with a unique constraint error, if some other item did have the same EAN-code, which is intended behavior. But it would also fail, if any item had "123" as a base value. This erroneous inclusion of base value in most unique value checks has been removed. 

WinClient was slow when using "Sortable Related Items"

When enabling "Sortable Related Items" on a feature used as a categorizer, Perfion was very slow when having many thousand items in the right-hand-side grid. This has been fixed. 

Cannot create more users even though license is unlimited

There was an issue with creating unlimited amount of users

Issue with images when scrolling through image library

Images was jumping around and rearranged itself

Report Parameters attributes not working

Parameters of type 'Boolean' was always true in webclient

Changed field to Theme Color

Changed field to Theme Color

Filtering out an image in web client gives error and blocks further expansion

Filtering out an image in web client gives error and blocks further expansion. This issue is now resolved by using the filename for the filtering.

The Connection Settings dialog in the Perfion Windows client now validates before save

Previously, when updating the connection settings in the Perfion Windows client the connection would be validated after the application restarted, which could lead to invalid connections due to connections to an unsupported version of the Perfion Database. The dialog will now validate the connection information before saving.

Feature definition "Graphic: Symbol" is not displayed correctly in Web Client

A Feature definition of type "Graphic: Symbol" was shown as a color picker i Web Client

Changed handling of Modal Data-subscription

Removed lingering subscription on Destroy of the modal, clearing the change detection issue that occurred on every login.

ServiceOnly users who attempts to login will receive the default username/password is incorrect message

ServiceOnly users will now recive a specific error message

Added an icon button that links to the Service Url

Added a small icon button on the same line as the Service Url input field, that links to the last accepted input value - that will also become inactive if the field isn't validated.

Updated Error Message

More clearly describe the issue when an error occurs while saving a Content Store user.

Added flexible handling of First Name without Last Name

Now feeds the same formatting of the User Name into all fields, so it will always reference the properly structure name reference.

Password length

Max password length changes from 20 to 50

Perfion will now skip upload of files bigger than the supported maximum size

The Content Store currently supports a maximum individual file size of 250MB. Previously, Perfion would attempt to upload files bigger than this, but would fail. Now it will log a warning in the scheduler log instead, with a message indicating that the specific file is skipped.

Widgets using Has value will now load correctly every time

Widgets using Has value will now load correctly every time

Added correct reference to current language, and fallbacks

Added correct reference to current language, and fallbacks. It will display data values for the currently selected language, if there are no values there, it will attempt English, and if even that has no values, it will display a localized 'No Value'.

Deleted users will be removed from dashboard access

Deleted users will be removed from dashboard access

Updated Error Handling

Now properly passes along the message from the 403 error, from the network response to the displayError field of the login template.

Accounts with service account type will be filtered out from dashboard access menu

Accounts with service account type will be filtered out from dashboard access menu

Going back and using new file in Import Wizard only works to clear settings if you remove the previous file

You couldn't reset header row values and first data row value when uploading a new file unless the old one was removed first

Disabling 'Custom Ordering' in Feature Definition will now reset any previously configured ordering of items.

Previously, when clearing the 'Custom Ordering' setting on a feature definition, items would still reflect any configured custom ordering.  This would mean that the API would still return the previously configured order, whereas the expectation would be that the API should return 0, indicating that the item does not have any explicit configured order.  This has been fixed so that when an admin clears the Custom Ordering checkmark, data will be updated to reflect the new setting.

New Importer now assigns values for Width, Height, WidthDPI and HeightDPI in Binaries-table

When importing images using the new import, the fields Width, Height, WidthDPI and HeightDPI in Binaries-table was only assigned 0'es. This has been fixed, so that these fields are now correctly assigned. 

Repeated text in Export Log has been removed

In previous versions of Perfion when exporting actions from Web Client a "Import actions via application server via application server" was added to log. Now the extra "via application server" has been removed.

User Access for AD users doesn't work in the web client

AD users can now always be added to Items regardless of the setup

Action - Join escaping special character single quote

A bugfix for the commands Join.Left, Join.Right, Join.Full and Join.Inner so the join can handle the single quote character.

Incorrect error message when trying to save more than one global search with same basefeature

The right error message is now displayed

Fixed issue with sync of multi variant values to Content Store

When synchronizing multi variant values to Content Store, the language was not correctly included in the data sent to Content Store.  This caused Content Store to not find and display the values correctly.

Users can no longer remove values from ReadOnly features

Previously, users could remove values from ReadOnly features via the grid in the Windows client. This has been fixed.

The Content Store sync job will now show status as 'Warning' instead of 'Error'

Previously if a Content Store did not have an item filter configured, the sync job would show a warning in the job output. The completed task, however, would show an error icon.This has been fixed.

ReadOnly feature can be cleared

It is possible to clear a read only value from the web client

Content Store Sync updated to include 'unit' in feature configuration sync

Content Store Sync updated to include 'unit' in feature configuration sync, as part of the featureInfos.

Supplier Portal Email templates - bug in Tags

A bug where the first letter in e.g. Organization Logo was removed are fixed

Selectables in supplier portal could not be saved

Cannot add values to any selectables

Cannot use other gui language than EN in web client

Some menu items was not translated in other languages than English

Copying items with Swap Relation Direction bugfix

A bug are fixed when items with Swap Relation Direction are copied

New Importer now allows use of _ParentId

In previous versions of Perfion, the only way to import a hierarchy of products was to create a _ParentPath-column and filling in the full path to the key imported to. Now you also have the option of specifying _ParentId making the importer place each product under the Item with the Id supplied.

User access type and a new Service Account user added

A new user property "Access type" are added to users. The property controls the users access to the system and makes is possible to limit a user to only Client access and/or Service access like API and Applications server. The new user Service Account is a fixed service user for API/App server and the Service Account and the Admin user does not count in the numbers for licensed users

Import Wizard

Purpose of the import wizard is to make it easy to import excel files different formats and map them to Perfion Features.

Last logon added to User settings

A new user property "Last logon" are added to users. The property shows the last time the user logon the system.

DeepL translations - Support for Glossary

It is possible to create DeepL Glossaries in the settings for translations. It will support one glossary pr. language combination. The settings for translations are updated, and the DeepL account type must be specified. All existing DeepL settings are updated to a free account and must manually updated to a pro account if the Api-key is from a pro account.

Supplier portal - Expose multiple base features

It is now possible to have more then one base feature in the Supplier Portal

Import Wizard

Purpose of the import wizard is to make it easy to import excel files different formats and map them to Perfion Features.

Import wizard - overlay size issues

Fixed overlay issue such as the sizing of the modal and the inputs.

Feature list not displayed in alphabetical order

Feature list in the configuration tab was not displayed in alphabetical order. This issue is now resolved.

Import Wizard Mapping Issues

There was an issue with the auto-mapping regarding the Mapping tab in the Import Wizard. This issue is now resolved.

Updated 'Execute Actions' evaluation

The fold-out menu now correctly evaluates based on the user rights and the status of the Application Server.

It is now possible to specify the parent of some item using a single path-element

In previous versions of Perfion, the IMPORT.FEATUREDATA-action (aka "New importer") did only allow you to specify a parent-item by using the full path to it. You would need a "_ParentPath"-column to specify the path. An example could be "Vehicles|Cars|BMW". Importing a, say, "BMW i5" using "Vehicles|Cars|BMW" as Parent Path would place the "BMW i5" as a child of "BMW", which again is a child of "Cars" etc. In case "BMW" is uniquely defined, you can from this version specify this as a Parent using a newly introduced "_Parent"-column in you spreadsheet. See documentation for further details. 

Action - FTP connection

The FTP commands in Actions will now reuse a FTP connection and keep it open until the Action (and sub actions) are executed. All created FTP connections will be closed upon completion of the Action.

Perfion-API: Update- and Insert-statements could stop updating row-values

When doing an Insert or Update-statement, the Perfion API would in previous versions of Perfion stop updating values on some row, if any of the values trying to be updated could not be due to inheritance. It would worst stop, when first inherited value was encountered. This has been fixed, meaning that all values not inheriting a parent value will still assigned regardless of whether one or more inherited value could not be assigned. 

Spellchecking in the grid will follow correct language of a column

Spellchecking in the grid will follow correct language of a column

Supplier Portal Email templates

The templates used in the Supplier Portal are changed in the syntax. The syntax was basted in the Razor syntax like @Company.Name and it is now based in Liquid syntax like {{ Company.Name }}. Please note that any custom templates must be updated to the new syntax to work properly.

Item Triggers - Action input

The input to Actions now include the Base type

ViewOrder was not correct in Perfion API Response

The ViewOrder in a Perfion API result has a bug and did not respect different orders in item dependency. This is now fixed.

Menu point for creating the first new content store now properly appears in the Web Client administration menu

Menu point for creating the first new content store now properly appears in the Web Client administration menu.  As content store organizations are dependent on at least one active content store, they now reference this menu point, if no content store is active, and organizations is navigated to.

Recycle bin - "Logged By" is now mandatory in delete triggers

The Recycle bin use database triggers to set the "Logged By". The trigger is changed to enforce to set the "Logged By"

New Importer: When using id of base item as key you can now update base values

In previous versions of Perfion the New Importer (The one used by IMPORT.FEATUREDATA-action and the Import Wizard) did not allow you to update base values for items when using the id as key. In other words it could not import a file like the one shown below: Product.Id Product Color========== ============== ===== 12345 New base value RedThis was possible in the old importer, and has now also been made for the new.

Webclient Action editor sort order

The Action editor in web had a bug when reordering Actions, Mappings or Parameters.

In SectionDesigner, section and panel rows will now be disabled across all columns

It was previously possible to set values in the Feature column of the section designer for Section (blue) and Panels (grey). This has now been disabled.

Renaming a feature holding a Default value could cause IMPORT.FEATUREDATA-action to fail

Renaming a feature holding a Default value could cause IMPORT.FEATUREDATA-action to fail. This has been fixed. 

It is not possible to select a report on the left side using the WebClient

Catalog Reports can now be generated through the webclient

DevExpress components updated to version 2024.2.5

Perfion uses a third-party component library, DevExpress, for generating reports (amongst other things). This library has been updated to version 2024.2.5

In previous versions of Perfion, updating a localizable, selectable value could error

In previous versions of Perfion, updating a localizable, selectable value could cause a "Sequence contains no elements"-exception. That happened if the previous value in the mean time was deleted. This has been fixed. 

Remote values did not inherit the Localizable flag

The Remote values feature will now inherit the Localizable flag from the "value feature"

Widgets with many items could fail

Fixed a bug where widgets with a high number of items (higher than the defined page size) could cause an error when trying to open the list of items behind the widget.

Deprecated support for SQL Server 2014

The required database server version is now Microsoft Sql Server 2016 or newer.

"Move Reports to database" tool deprecated

The tool "Move Reports to database"/MoveReportsToDb are deprecated. To upgrade from before Perfion version 5.0 and using "file based reports" an upgrade to version 5.0 are needed ot convert the reports and then upgrade to desired version of Perfion afterwards. 

Cannot change tristate boolean state on default values in web client if it is set to "true"

Tristate Boolean features could not change their stage from 'true' to 'false'. This has now been fixed.

New import included empty cells when calculating filled out cell count

In previous versions of Perfion, the importer also counted empty cells when calculating the filled out cell count. This has been fixed. 

Updated Category Access indicators to follow Enum correctly

The check-marks were incorrectly mapped to states, so even though the data was stored and loaded correctly, the check-marks were simply not corresponding, which they are now.

The Perfion.DbInstaller.Commandline now supports Windows Integrated Security and 'FromVersion'

The Perfion.DbInstaller.Commandline now supports new arguments --IntegratedSecurity and --FromVersion. IntegratedSecurity uses the current Windows login for authenticating to the database server. FromVersion allows administrators to rerun an upgrade from a previous version.

Improved error message on malformed API query

An Perfion API update query could throw an 'Object not set to an instance of an object' error if the query was malformed - e.g. if the Item element was missing from the Update.  This has now been fixed so a more meaningful error is returned.

Service Account user can not be deleted

A user with ID as 'ServiceAccount' cannot be deleted. All users can now set 'Access type' and see last log on.

API user and Admin were counted as normal users in the license

API user and Admin were counted as normal users in the license

Changed rendering condition for Item Filter

Now renders filter field based on enum, not string, to prevent localization from affecting it.

Database table GlobalSectionSearches and Dictionaries - Extend UserId

The column ModifiedBy in table GlobalSectionSearches and Dictionaries are extend to 26 characters.

ValidateOnly Does not work on OperationsMode parameter for new importer action

This issue is now resolved

Updated Select Component

Updated Select Component to no longer apply a fixed size to the dropdown, and allow it to manage its own size based on content size.

Cannot choose feature in dashboards

Features were blank

Choosing base feature in widgets cleared all views

No views were visible when a base feature was chosen

Cannot choose filter on widgets

When 'Total Count' was set in Widgets the filter option was disabled

Widgets gives supplieritems error

An 'InContextOf' property needed to be set

Properly pass InContextOfFeature id to query

The Supplier Feature Search had a broken reference chain for passing on the inContextOfFeature value, which has been corrected.

several feature definitions were greyed out

If you try to create a search feature and try to click on anything - name, feature definition - anything - then it greys out Allow Hierarchy, Custom Ordering, Sort Related Items.

Views for widgets seems to be locked

Views modal button seems to be locked even though it is not

Made Organizations rendering independent of old Active flag

Backend no longer passes a usable Active flag, so we have made the frontend solely dependent on the categoryAccess instead.

Aligned with InContextOf requirement

Endpoints have been updated with requirements for InContextOf, and this aligns with this change.

Multiple "InContextOf" errors

Supplier Portal threw multiple "InContextOf" errors when copying context between rows