Version Information
New Features
TSM-6645 TSM.App: Additional Attributes Search
The “Advanced Attribute Search“ has been enchanced so that it allows for an arbitary number of attribute Queries, containing an arbitrary number of Attribute Name, Value and TimeStamp conditions connected in an “OR“ fashion, combined in an “AND” fashion.
TSM-7043 Automation Server: Multiselect Excel Sheets and Evaluate Formula
New functionality has been added in the batch plugin for automation server. It is now possible, to select specific sheets, when exporting in Excel. If not all sheets are selected, it is possible, to force evaluation of formulas. This ensures, that formulas or graphs will show correct results, even if they reference cells in sheets not present in the final export. This is handled through a new checkbox.
TSM-8452: Support for List Attributes in Master Data Import and Export
Support for list attributes in the master data import/export tool has been added. Time series with assigned list attributes can now be exported and imported. The unit is included in bracket notation (e.g. Value [UnitName]). When importing data exported with a previous version of PowerTSM (without unit bracket), the unit is resolved automatically if the attribute has exactly one unit assigned or has a default unit configured. For attributes with multiple units that have no default unit configured, the data must be re-exported using this version so that the unit bracket is included. A bug in a stored procedure on Oracle has been fixed as part of this ticket.
.NET API: Parameterless constructor of the class AttributeValueSerialization and the constructor with only DAL as parameter of the class ImportTask have been marked obsolete and will be removed in version 3.12.0.0.
Exported time slices now look like this:
<AttributeSlots>
<Slot>
<ValidFrom>1972-01-01T00:00:00+01:00</ValidFrom>
<Value>Vienna</Value>
</Slot>
<Slot>
<ValidFrom>2024-04-14T00:00:00+02:00</ValidFrom>
<Value>Oslo</Value>
</Slot>
<Slot>
<ValidFrom>2026-04-14T00:00:00+02:00</ValidFrom>
<Value>Berlin</Value>
</Slot>
</AttributeSlots> [Location]TSM-6957: TSM Console: Update Excel References before or after Processing the Template
A configurable script (e.g., PowerShell, batch file) can now be executed before each template is processed, allowing external data sources and formulas to be refreshed via Excel COM automation. The script path, parameters, timeout, and error/timeout handling behavior can be configured per template in the Batch Parameters GUI.
Fixed Bugs
TSM-7103 Fixed HAKOM.TSM.App.ExcelAddin.dll.config overwriting HAKOM.PowerTSM_32Bit.xll.config and HAKOM.PowerTSM_64Bit.xll.config during installation
The installer no longer overwrites HAKOM.PowerTSM_32Bit.xll.config and HAKOM.PowerTSM_64Bit.xll.config by default with the content of HAKOM.TSM.App.ExcelAddin.dll.config. If these files already exist in the source folder, their original content is now preserved during installation. If they do not exist in the source folder, they will be created during installation with their default content.
TSM-8376 WebTSMService: Background Deletion Does Not Work on Oracle
The following endpoints support background execution (fire and forget or fire and callback):
DELETE repositories/{repository}/timeseries/id:{id}DELETE repositories/{repository}/timeseries/{name}DELETE repositories/{repository}/timeseries/archiveDELETE repositories/{repository}/timeseries/quotationDELETE repositories/{repository}/timeseries/id:{id}/dataDELETE repositories/{repository}/timeseries/{name}/dataDELETE repositories/{repository}/timeseries/id:{id}/data/archiveDELETE repositories/{repository}/timeseries/{name}/data/archiveDELETE repositories/{repository}/timeseries/id:{id}/data/auditDELETE repositories/{repository}/timeseries/{name}/data/auditDELETE repositories/{repository}/timeseries/id:{id}/quotationsDELETE repositories/{repository}/timeseries/{name}/quotationsDELETE repositories/{repository}/timeseries/id:{id}/quotations/auditDELETE repositories/{repository}/timeseries/{name}/quotations/auditDELETE repositories/{repository}/deletedtimeseries
When using Oracle, these endpoints did not behave as expected. Instead of returning a response immediately and delegating the actual work to a background task, they blocked until the background task completed before returning. This has been fixed; all listed endpoints now behave consistently across all supported databases.
Additionally, time series archive deletion and time series quotation deletion received significant performance improvements across all supported databases, with the most substantial gains on Oracle.
TSM-8393 AttributeManager: Consistent Localization for Attribute Types and Classifications
The Attribute Manager now shows attribute types, attribute classifications, and list-unit types consistently in the currently selected UI language, avoiding previous language mixing. This makes the configuration views clearer and more predictable for users, with all type names properly localized.
TSM-8395 Removed Complex Attribute Types in Type Selection of ListAttributeValue-Creation in TSM App
When creating new ListAttributeValues, the TSM App now hides complex attribute types. For ListAttributeValueswhich already have a complex attribute type assigned to them, the type will be shown as a disabled option. Attempting to select it will automatically fall back to the next available attribute type.
TSM-8399 AttributeManager: Fix UI Glitches After First List Attribute Creation
After creating the first list attribute, it was necessary to reopen the list attribute management dialog to be able to create list attribute values for it. This has been fixed, so that list attribute values can be created immediately after the creation of the first list attribute.
TSM-8419 TSM App: New Error Messages When Attempting to Delete Assigned Attributes
When trying to delete attributes for which assignments already exist, the user will be notified. In that case, the user is still able to proceed with the deletion, which consequently removes all existing assignments of the affected attributes.
TSM-8413 TSM.App: Fixed Concurrency Issues When Searching and Reloading the UI at the Same Time in AttributeManager
The AttributeManager performs asynchronous data fetching, when it searches and reloads the UI. If a search is triggered and, while it’s still running, another search is started, or the UI is reloaded, there could be issues with displaying the found attributes. This has been fixed.
TSM-8442 Fixed Wrong Table Name in Truncate Table SQL Statement For PostgreSQL
Warning
This change deletes archive data from fwa_attributeentryarchive when upgrading to version 3.10.2.0 or 3.11.2.2!
When updating a PostgreSQL database to version 3.10.2.0, both tables fwa_attributeentryarchive and fwa_attributeentrydataarchive were intended to be truncated. However, due to an error in the SQL statement, fwa_attributeentryarchive was not truncated as intended. This fix resolves the issue for version 3.10.2.0 and has also been applied to version 3.11.2.2.
Note: If the truncation of fwa_attributeentryarchive was skipped during the update to 3.10.2.0, it must also be skipped when updating to 3.11.2.2. Applying the truncation in 3.11.2.2 without having applied it in 3.10.2.0 would result in data loss for records that should have been retained.
TSM-8472 Two Vulnerabilities (CVE-2026-33116 & CVE-2026-26171) Have Been Patched
Two known vulnerabilities (CVE-2026-33116 & CVE-2026-26171) have been patched by updating to newer versions of affected libraries.
TSM-8427: TSM App: Incorrect start-of-day and start-of-year values for certain time zones
Time series configured with time zones such as Europe/Berlin or Europe/Vienna produced incorrect start-of-day and start-of-year timestamps. Affected time series showed a time offset at day and year boundaries that did not match the configured time zone.
The root cause was that IANA-format time zone identifiers (e.g. Europe/Berlin) were not correctly resolved by the application, leading to wrong boundary calculations. The time zone resolution has been corrected. Both IANA-format identifiers (e.g. Europe/Berlin) and Windows-format identifiers (e.g. W. Europe Standard Time) are now resolved correctly.
TSM-8482: ArgumentOutOfRangeException in the Batch Plugin When a Cell Contains “TEXT”
When a cell in the template used for the batch plugin contains “TEXT”, that might be a reference to the Text Function https://support.microsoft.com/en-us/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c. While processing the template it was possible, that an ArgumentOutOfRangeException was thrown, when such a cell was treated as if it contained a Text Function, when it wasn’t really a function, it simply had the word “TEXT” in it. This has now been fixed.