Highlights

Vision 5.6 brings a repeatable personnel CSV import, a cleaned-up portier Vision Companion interface, and fixes on top of 5.5.0. The release includes schema extensions; the update runs automatically on first start.

New features

• Personnel data import from CSV: A new Personnel data import menu item in Vision, visible to users with the Personnel / Import permission, opens the portier Vision Companion. Set up a template per data source once (column order, delimiter, header row, encoding, default values), then import repeatedly. For existing customers with grown import formats, position-based standard templates are available.

• Supervisor field on the personnel record: A personnel record can reference another personnel record as its supervisor. The field is carried during import and in the personnel form.

• Colour highlighting of departed employees: In the personnel list, the key reminder grid, and the main personnel overview, departed employees can be set apart by colour. Switchable under the Super Admin settings; colour and cut-off logic (with or without a grace period) configurable per installation.

• Edit the return date directly in the list: On the personnel, key, and cylinder forms, the return date of issued keys can now be edited directly in the list. Input is validated (return not before issue), editing is tied to the modify permission, and without admin rights only your own rows are editable.

• portier Vision Companion, new interface: The Companion gains three tabs: Import, Export, DB configuration. Under Import, three sources sit side by side: portier XML, Dormakaba KWD, and the new personnel CSV import. Multilingual: German, English, French.

Improvements

• portier Vision Companion starts faster: The database connection is no longer opened at program start, but on first actual need.

• Building and system selection: Consistent column layout.

• Label overlaps: Fixed in the password dialog, the search form, and the system/building info panels.

• Installer: Updating via the installer leaves portiervision.ini unchanged. MSI source files are sourced consistently from the CommonData directory.

Bug fixes

• French translations: Distributeur replaced with Revendeur (dealer), Jeux with Trousseaux (key bundle). Missing translations in context menus and sort dialogs added. Permission types and roles are delivered translated in the DORA export.

• Spanish translations: Gaps on dashboard tiles and in the DORA labels closed.

• English translations: Login screen corrected (Country instead of COUNTRY, Gate instead of Gap). Labels such as Customer ID cleanly localized.

• Data source in the personnel list: The Source column is now shown in the application language.

• Umlauts: Character-set fixes in labels with ä/ö/ü/ß completed.

• Key list: Sorting regression from 5.5 reverted.

• Deleted imported cylinders: A cylinder imported from manufacturer data came back as stock on the next import. Vision now offers to mark it as destroyed or lost instead, so it stays out on re-import. Manually created cylinders are still deleted normally.

• Duplicate cylinders on PortierXML import: When the existing locking system could not be resolved, cylinders were silently created twice. A unique index on the manufacturer ID now prevents this, and existing IDs are skipped on import instead of aborting the run.

• Rights assignment in user administration: Several faults in role assignment fixed: assigning rights could raise an error message, removed rights were not saved (the role reappeared after a refresh), and the user could not be deleted afterwards. Assigning and removing now run in a transaction and report errors properly.

• DOM ENiQ synchronization: Primary key violation in RE_PERSONAL_EGK fixed.

• Web update: The preflight request failed with HTTP 400 under certain WinHTTP configurations. Fixed (follow-up to the 5.5.0 self-update).

• Personnel save: Correction to the supervisor field and a clean default value for the source on manually created records.

• First start with a Companion-configured database: When the database connection was set up through the portier Vision Companion, Vision could overwrite the stored credentials on first start or fall back to Windows authentication, resulting in a failed login (Login failed for user), sometimes with Azure SQL login errors. The Companion credentials are now preserved, the DBLOGIN key is read case-insensitively, and the migration is fault-tolerant.

• portier Vision Companion, connection strings: Credentials with special characters in MSSQL and Firebird are escaped correctly.

• portier Vision Companion, PERSONALNUMMER conflict: A conflict when re-importing manually maintained personnel records is resolved cleanly instead of aborting with an error.

• portier Vision Companion, import results: Progress and detail messages of the PortierXML import are now fully translated (German, English, French). Cylinders that already exist are listed separately, so cylinder and key counts no longer contradict each other.

• portier Vision Companion, local MSSQL instance: Connected via shared memory (LPC) by default, reducing configuration effort.

Upgrade instructions

5.6 includes database schema extensions. The update runs automatically on first start, identical for Firebird and MSSQL installations. If the update still finds duplicate cylinders from earlier imports, it completes anyway and points them out with a clear notice; the cleanup can be sorted out with support. As always, create a backup before updating.