WERMA WIN UPDATE / Manual

WERMA WIN software download

Download Software

download
Login necessary
Date: 09.03.2023 - Size: 211.4 MB

Download Documents

download
Manual
Date: 28.02.2022 - Size: 6 MB
download
SQL-Server 2022 Quickstart
Date: 09.03.2023 - Size: 1 MB

Calculation scheme

download
Calulation scheme
Date: 19.12.2022 - Size: 351 KB

Manual

download
Online Manual (HTML)
Date: 15.12.2022

Support Contact

You need support?

Contact us!

Technical Support
E-mail: support@werma.com
Phone: +49(0) 7424 9557-222


 

Language

Deutsch

Francais


SQL Server Management Studio SMMS 18.7.1

Download: http://go.microsoft.com/

Under "Download", select the following file:

  • Windows (32-Bit): SQLManagementStudio_x86_ENU.exe
  • Windows (64-Bit): SQLManagementStudio_x64_ENU.exe

Important notes:

  • Please note the updated system requirements for installing WERMA-WIN.
  • We recommend backing up your WIN database before running the update.
  • Please install or update the software on the PC where the database is installed (the Server PC) first and then on all other PCs.
  • If you are running WIN on multiple PCs, you must upgrade all your PCs to the same software version to maintain correct Operation (same version as on the Server PC).
  • During the update of an existing WIN installation the database will be automatically updated. The database can then no longer be used with an older WERMA-WIN version.
  • Before installation, please note the topics that you will find under the heading “Announcement WERMA-WIN 5.0 SP1”

Important notes:

  • Please note the system requirements for installing WERMA-WIN.
  • We recommend that you perform a data backup before updating WERMA-WIN.
  • Please run the installation or update on the server PC first and then on all other client PCs.
  • To ensure the correct operation of WERMA-WIN when used on multiple PCs, you must update all your PCs to the same software version (same version as on the server PC).
  • When updating an existing WERMA-WIN installation, the database is automatically updated. The database can then no longer be used with an older WERMA-WIN version.

WERMA-WIN 5.3 introduces the following additions, among others:

  • Layers
    • The runtime and productivity module now displays all layers that were previously assigned to a slave.
  • Runtime module  
    • Interference reasons can be hidden in the selection list.
    • Period selection improved
  • Productivity module
    • Period selection improved.
  • Further bug fixes and stability improvements

Important notes:

  • Please note the system requirements for installing WERMA-WIN.
  • We recommend backing up your WIN database before running the update.
  • Please install or update the software on the PC where the database is installed (the Server PC) first and then on all other PCs.
  • If you are running WIN on multiple PCs, you must upgrade all your PCs to the same software version to maintain correct Operation (same version as on the Server PC).
  • During the update of an existing WIN installation the database will be automatically updated. The database can then no longer be used with an older WERMA-WIN version.

With WERMA-WIN 5.0 the following changes and additional functions have been introduced:

  • General:
    • Configuration of the shift model
      • You can now configure work shifts (times and days) in the settings.
      • Different work shift patterns can be applied to different machines and workstations independently.
      • The creation of work shifts is equipped with a collision check.
    • For new installations the SQL Server 2014 Express SP3 is used.
    • Views:
      • If a view is deleted and is selected as the start view, a message is displayed. The Main View (default) is loaded instead at subsequent starts.
  • Runtime module
    • The runtime module was rewritten in the course of the shift model development.
      • The automatic update of the display is activated by default.
      • The update interval is 60 seconds by default.
      • Corrections and bug fixes in the calculation and display of counter curves.
      • Insertion of Fault Conditions in appropriate time periods is now by double-clicking.
      • The addition of a "Modified Job Curve" to show a predicition of Job progress according to actual activity.
      • Visualisations of quantities, target lines and shifts can be shown or hidden.
      • Options to show/hide shift information.
      • The Job target lines are visualised depending on the stored shift model.
      • Selection of a longer display time period along with the selection of specific shifts allows reporting to show activity in only these shifts.
      • Calculation of total status times in a selected time period can be set to include or ignore activity during pauses within shifts.
      • Display of entered Notes in the Notes bar now includes the text description for the selected Fault Condition.
      • Addition of Hide Filters function to simplify Runtime display.
      • Removal of user pre-defined display time periods.
      • Display of planned and actual quantities during the operation of a Job is now replaced with more detailed mouse-over displays.
  • Productivity module:
    • The automatic update of the display is activated by default.
    • The update interval is 60 seconds by default.
    • Displays of productive states now include "Undefined" in the state charts.
    • Selection of a longer display time period along with the selection of specific shifts allows reporting to show activity in only these shifts.
    • Productivity calculations can take into account defined pauses during shifts.
    • Automatic reload when moving slave control was fixed.
    • The tacho display for Job Productivity has been replaced by a more readable visualisation that includes Plan and Actual average cycle times.
    • The calculation of productive times has been revised.
    • Corrections and bug fixes in the calculation of the total productivity.
    • Removal of user pre-defined display time periods.
    • Pie Charts for normal Slave states has been removed.
  • Job  module
    • The Productivity (Cycle time) display has been modified.
    • Consideration of pauses during shifts in the calculation of the total planned Job runtime.
    • Consideration of pauses in repeating Auto Jobs.
  • Report:
    • The report "Runtime module - Tabular representation of the fault conditions" only includes those time periods in the total time of the disturbance reason which also fall within the period under consideration. Fault conditions that start before the observation period and reach into it or that start in the observation period and go beyond it are cut off accordingly.
  • Administration Console:
    • Where used, the user-defined password associated with Functions can now be reset.

Other improvements and bug fixes:

  • Fixed a programme crash that arose when scrolling quickly through the date filter in the productivity module.
  • Rules in Control Module are now imported when the Import Devices function is used.

With WERMA-WIN 5.1 the following changes and additional functions have been introduced:

  • Extension of reports to include information from the shift model
  • Bug fixing: The end of the validity period of shifts must not be overwritten when deleting if a date has already been entered.
  • Bug fixing: When transforming times into shift times, the following day is not entered if the end of the period is smaller than the beginning of the period.

With WERMA-WIN 5.2 the following changes and additional functions have been introduced:

  • System requirements updated to the current Microsoft support lifecycle. See manual for details.
  • Runtime environment and device drivers updated to the up-to-date versions.
  • SQL Server 2014 removed from the setup. Setup of new SQL Servers must now be done manually.
  • Extensive bug fixes, especially related to the working shift model.
  • Significant performance improvements, especially in the runtime module.
  • New "Database Maintenance" feature in the Admin Console to clean up duplicate database entries.

With WERMA-WIN 5.0 the following additional functions have been introduced:

  • General:
    • Configuration of the shift model
      • You can now configure work shifts (times and days) in the settings.
      • The creation of work shifts is equipped with a collision check.
    • For new installations the SQL Server 2014 Express SP3 is used.
    • Views:
      • If a view is deleted and is selected as the start view, a message is displayed. The default view is loaded instead at subsequent starts.
  • Runtime module
    • The runtime module was rewritten in the course of the shift model development.
      • The automatic update of the display is activated by default.
      • The update interval is 60 seconds by default.
      • Corrections and bug fixes in the calculation and display of counter curves.
      • Insertion of comments in appropriate time periods by double-clicking.
      • Visualisations of quantities, target lines and shifts can be shown and hidden.
      • Options to show/hide shift information.
      • The target lines are visualised depending on the stored shift model.
      • Adjusted target line (ideal line within a shift) can be shown and hidden
  • Productivity module:
    • The automatic update of the display is activated by default.
    • The update interval is 60 seconds by default.
    • Display of "not defined" in the state chart.
    • Time selection extended by shift selection.
    • Inclusion of breaks in the productivity calculation.
    • Automatic reload when moving slave control was fixed.
    • The tacho display has been replaced by a more readable visualisation.
    • The calculation of productive times has been revised.
    • Corrections and bug fixes in the calculation of the total productivity.
  • Job  module
    • Exchange of the productivity diagram
    • Consideration of pauses in the calculation of the runtime
    • Consideration of breaks in serial jobs
  • Report:
    • The report "Runtime module - Tabular representation of the fault conditions" only includes those time periods in the total time of the disturbance reason which also fall within the period under consideration. Fault conditions that start before the observation period and reach into it or that start in the observation period and go beyond it are cut off accord-ingly.

Other improvements and bug fixes:

  • Fixed a programme crash that arose when scrolling quickly through the date filter in the productivity module
  • Rules for device import are imported with device Import.

Announcement WERMA-WIN 5.0 SP1

In addition to stability and performance optimisation, all reports in WERMA WIN 5.0 SP1 will be adapted to the new shift model. In Release 5.0 not all reports are yet available.

The following features are introduced in WERMA-WIN 4.7

  • General:
    • When exporting the link file, administrator rights are no longer required.
    • After WERMA-WIN has been installed, the application is now started with normal user rights.
    • The update package has been omitted. For WERMA-WIN there is only the installation package.
  • Device management:
    • IP addresses of devices connected to WERMA-WIN are now displayed in the devices overview.
  • Deactivate functions:
    • In addition to the complete activation and deactivation of modules, individual functions in the Control Station, Runtime and Job modules can also be deactivated and activated in the Settings menu.
  • Status:
    • E-mails sent when a status is changed are now in HTML format. HTML tags are not support-ed.
    • The states "Off" and "Connection error" can now be renamed.
    • The colour of the states "Off" and "Connection error" can now be changed.
  • Initiation:
    • Adding a slave without connecting a master is now possible.
  • Productivity module:
    • You can choose between bar- and pie-charts in both the Productivity module and Productivity reporting.
    • When the bar chart is selected, all states are displayed in the same sequence
  • Control station:
    • It is now possible to create an auto job via the Control Station.
  • Status transmission:
    • The status transmission can now be defined separately for each tier. You can define which status change (On, Off, Connection Error) triggers a notification and how that no-tification is transmitted (e-mail, popup).
  • Time units:
    • The time units are now adjusted automatically. Only the two largest units are displayed here. The smaller time units are rounded. Example:
      • 34 sec
      • 14 min. 34 sec
      • 6 hours 14 min
      • 5 days 6 hours
    • From a period of 100 days, the hours are omitted.
    • From 366 days, > 1year is displayed.
  • Reporting:
    • The automatic time unit also applies to the reports.
    • The Excel export was revised and now uses Closed XML as Third Party Library.
  • Unattended Setup:
    • To be able to roll out WERMA WIN without supervision, both an Unattended Setup and an Unattended Language Pack Installer have been implemented.
    • The uninstallation can be done via a Silent Uninstaller in the future.

Other improvements and bug fixes:

  • The size and format of the Fault Conditions dialogue box can no longer be changed.
  • Bugfix: When the number of pieces or the order progress is reached, a notification is sent by e-mail.
  • Bugfix: Crash when exporting Excel to an existing and still-open file has been fixed.
  • Bugfix: Double save dialogue during CSV export has been fixed.
  • Bugfix: In the Control Station the order information is displayed via popup directly below the progress bar.
  • - Bugfix: A problem where a negative count was displayed when a slave had been powered down and up again has been fixed

Other improvements and bug fixes:

  • A problem with the notification Pop-Up not being displayed in the centre of the program window has been fixed.
  • A problem with the display of additional job details in the Control Station module has been fixed.
  • A problem with the e-mail notification function has been fixed.
  • Users can now again create auto-jobs directly from inside the Control Station module.

XML interface

  • Configuration using WERMA-WIN Administration Console on the Server PC.
  • XML Export:
    • Current status of the wireless transmitters
    • Current counter value
    • Current job status
  • XML Import
    • Job data import for entering and editing a job
    • Start job
    • Change job status to active waiting
    • End job
    • Delete job

System requirements

  • The list of supported operating systems has been updated (see Help / System Requirements).
  • WERMA-WIN now supports the following operating systems and Microsoft SQL Server versions:
    • Microsoft SQL Server 2016 SP2
    • Microsoft SQL Server 2017
    • Windows Server 2016

Device configuration

  • Tier descriptions in the configuration which are unused, are no longer displayed in the drop down. Incorrectly created tier descriptions can no longer be selected.

Language Pack

  • The Italian language has been added to the WERMA-WIN Language Pack.

Other improvements and bug fixes

  • A problem with the icon display in the report preview has been fixed.
  • A problem with a text field which was cut off in the runtime module has been fixed.
  • A problem with the translation of weekdays and month names in the auto job overview has been fixed.
  • A problem with the display of the scroll menu in the productivity and job module of the Chinese language version has been fixed.
  • A problem with the display of the signal towers in the control station module of the Chinese lan-guage version has been fixed.

Language Pack

The Czech language has been added to the WERMA-WIN Language Pack.
WERMA-WIN is now available in the following languages:

  • German
  • English
  • French
  • Chinese
  • Polish
  • Spanish
  • Portuguese
  • Czech

Other improvements and bug fixes:

  • The Alt + Tab function is now available in fullscreen mode.
  • A problem during the configuration and the display of the status change message (missing status colours) has been fixed.
  • A problem during the configuration of the status transmission (missing status colours) has been fixed.
  • A problem when opening the productivity main view has been fixed.
  • A problem with the WERMA-WIN program start function for the productivity main view in fullscreen mode has been fixed.

Bug fix

  • Corrected a colour display error in Slave configuration and status change message.

System requirements

  • The list of supported operating systems has been updated (see Help / System Requirements).
  • Verification of the fulfilment of the system requirements during the installation process has been optimised.

Microsoft SQL Server 2014 Express

  • When installing WERMA-WIN including the database, the Microsoft SQL Server 2014 Express is installed and the database is created on it.
  • You can still use your own Microsoft SQL Server by selecting IT Expert Installation (see Help / IT Expert Installation).

Design

  • New Ribbon-Menu component provides WERMA-WIN with a new and modern design.

Views

  • New management of views (create, edit and delete) under the settings.
  • The number of views is now unlimited.
  • The order of the views can be adjusted.
  • Duplicating of views including previously-selected WIN transmitters and background is now possible.

Job Module

  • An Auto job with defined start time and end time and/or quantity can now be specified in WERMA-WIN.
  • An Auto job can be provided with a recurrence pattern and a range of recurrence and it repeats according to the pattern.
  • A job with a defined end time and/or quantity, at which the job is automatically terminated, can now be specified. Alternatively, an order can be terminated manually or by the job input tier.

Other improvements and bug fixes

  • Improvement of the installation process by correcting the installation path.
  • Improvement when entering the server name (including instance) during the installation process.
  • Improvement of the list of auto jobs during the updating of the view.
  • A problem with the pie chart diagram in productivity report has been fixed.
  • A problem when loading background images has been fixed.
  • A problem where a WIN slave used in a job could be deleted has been fixed.
  • A problem with special characters in the connection password has been fixed.

Installation

Windows 10 support:

Examination during the installation process, if the "Server" installation will be carried out on a Windows 10. Display a warning message if the SQL Server 2008 R2 will be installed automatically.
Please refer to the instructions in the manual.

General

WIN ethernet master activation:

Improvement of the activation dialogue to facilitate the network configuration.

Productivity module

Troubleshooting the view was not updated automatically in full screen mode after 10 minutes.

WINtoApplication

When you trigger an external application the directory where the application is stored is defined as the working directory.

Troubleshooting "WINtoApplication start automatically" setting was not saved.

Reporting

Correction of the data filtering for the reports of the job module.

Job module

Fixes an issue after a power loss that triggered negative job values in the next job.

Auto jobs

Corrections for auto jobs for newly added WIN slave performance.

Corrections to the correct job assignment of the first piece (first impulse).

Correction with editing auto jobs.

Further information is available in the WIN manual.