Skip to content
MB Datasuite
  • Features
  • Applications
  • Energy
  • Visualization
  • Prices
  • Free Trial
  • Deutsch
MB Datasuite
  • Features
  • Applications
  • Energy
  • Visualization
  • Prices
  • Free Trial
  • Deutsch

System requirements and compatibility

5
  • System requirements and secure operation
  • Run DataSuite as a Windows Service
  • DataSuite Supported Databases – Overview & Setup Tips
  • PLC support  
  • White Label

Quick start

11
  • Quick Start with DataSuite for IT Experts
  • Quick Start with DataSuite – For OT Experts
  • DataSuite Installation – Guide for Windows (PC & VM)
  • Set up PLC connection  
  • Create trigger  
  • Select trigger variable in the handshake  
  • Execute trigger  
  • Create Excel file  
  • Write header data to the file  
  • Write record  
  • Connect to a Database

Tutorials, HowTos and instructions

1
  • Alarm emails with OPC-UA: Monitoring excess temperature with an S7 1500 PLC

User Manual

96
  • General information on the user manual
  • Accounts
    • Threema account
      • Threema Time limit  
      • Configure Threema account 
      • Set up a Threema account
    • E-Mail account
      • Email time limit
      • Configure email account  
      • General info about e-mail account
    • SMS-account
      • Configuring a SMS / Seven Account
      • SMS time limit
      • SMS Sandbox
    • Telegram account
      • Telegram time limit
      • Configure Telegram account 
      • Set up Telegram
  • Error Codes
    • General   (0 – 99)
    • PLC (200 – 299)
    • E-mail (300 – 399)
    • SMS (400 – 499)
    • Excel (500 – 599)
    • OPC UA (700 – 799)
    • Databases (800 – 899)
    • Print (1000 – 1099)
    • PDF (1100 – 1199)
    • HTML (1200 – 1299)
    • Start external applications  (1300 – 1399)
    • Rest (1400 – 1499)
    • Time Master (1900 – 1999)
    • Telegram (2000 – 2099)
    • Threema (2100 – 2199)
  • Devices (Shelly)
    • General information about Shelly
    • Add devices 
    • Using Shelly variables 
  • Excel, CSV, PDF files
    • CSV files: Formats, special characters, encodings
    • General information on Excel files
    • File selection 
    • File formats  
    • Read Access 
    • Write Access 
  • Control systems (PLC connections)
    • General information on PLC connections
    • Create PLC connection  
    • Variables  
    • Configure PLC connection  
  • Databases
    • General information on databases
    • Database: Write record (Insert) 
    • Database: Write several data records (insert) 
    • Database: Read data record (Select) 
    • Database: Read multiple records (Select) 
    • Database: Execute Query 
  • Webserver / REST API
    • General information web server/rest API
    • Settings and security 
    • Calling up web pages 
    • Use Rest-API 
  • Support
    • Create Support Packages  
    • Support contact details
  • Licensing
    • Determining the required licence  
    • Activate your licence  
  • Settings
    • General information
    • Export  
    • Import  
    • Password protection  
    • Change language  
    • Factory settings  
  • Trigger
    • General information about the trigger
    • Create trigger  
    • Trigger structure  
    • Use variables  
    • Trigger Actions
      • General information
      • Write variable 
      • Excel – Writing  
      • Excel – Read  
      • Convert Excel file to PDF  
      • Print Excel file  
      • Convert Excel file to HTML file  
      • Database: Execute Query 
      • Database: Write record (Insert) 
      • Database: Write several data records (insert) 
      • Database: Read data record (Select) 
      • Database: Read multiple records (Select) 
      • File options (copy, move, rename, delete)  
      • Read out file names in folder  
      • Execute REST Request 
      • FTP Upload
      • Send e-mail  
      • Send SMS  
      • Send message using Telegram 
      • Send message using Threema  
      • Start external applications  
      • Exporting and importing data blocks (DB)
      • Update Data Block
      • Set PLC time 
    • Trigger trigger conditions and handshake
      • General information on Trigger conditions and handshake  
      • Standard handshake  
      • Individual handshake  
    • Error handling and log
      • Error handling and log  
    • Additional trigger editing functions
      • Calculations and Formatting of SPS Data
      • Invert Excel Actions 
      • Changing data blocks for all variables in the trigger 

Upgrade from version 2 to version 3

1
  • Change from version 2 to version 3  
  • Home
  • Docs
  • User Manual
  • Trigger
  • Additional trigger editing functions
View Categories

Calculations and Formatting of SPS Data

Lesedauer: 1 min

The DataSuite has many options for customizing variables before use. It allows you to customize variables according to specific formats, such as restricting DateTime variables to time or date. The side panel for the calculation and formatting options can be found anywhere we can select a variable. Once we are in the variable selection we can simply expand the panel on the right side of the window and add as many calculations and formatting as we want.

Operations #

The DataSuite offers the possibility to format variables, replace specified text sections with other text, conditional replacement of the variable value and the application of simple calculations through the side panel.

Formatting #

Formatting text is very useful for tailoring a text to what is necessary or to ensure that the text adheres to a predefined standard. For this purpose, DataSuite offers the option to adjust variables with the help of a format string. A typical case is to crop a date so that you only get the month or the year, for example. PLC devices often only have one DateTime variable. In this case, DataSuite allows you to get both the date and the time individually from this variable. At the same time, we can use this formatting to use the computer time variable available in DataSuite more effectively.

Formatting Examples #

Limit decimal places of a floating point number0.000 (limited to 3 digits after the decimal point)
Time without Secondshh:mm
Date without YearMM:dd

Replace Text #

The Replace text function does exactly what it says. In this function, we can simply specify a text that we want to replace and what we want to replace it with. For example, this function allows us to convert error codes into error descriptions or to break up umlauts for the international market. Or perhaps you have used abbreviations in your strings in the PLC to save memory and now want to have them written out.

Boolean #

The Boolean function allows us to conditionally assign a value to variables. To do this, the variable is converted into a Boolean (also called a bit in PLC, a value that is true or false). Based on what this value then represents, the corresponding value is returned. However, it is important to note that it makes more sense for some variable types than for others. For example, there are values that automatically become true as long as they are not empty. So it would be good to stick with simple data types like bit or byte.

Calculation #

The Calculations function allows us to calculate our variables with fixed values. The four basic arithmetic operations are covered. Possible applications are the conversion of units. For example, we can convert kiloamperes into amperes by simply multiplying by 1000. Or we could convert kilometers per hour into meters per second. Alternatively, you can convert a timestamp represented in milliseconds to seconds if you don’t need this fine precision and want to save memory.

Wie findest du den Beitrag?
Immer noch Fragen? Wie können wir helfen?

Wie können wir helfen?

Changing data blocks for all variables in the trigger 
Inhalt
  • Operations
    • Formatting
    • Formatting Examples
    • Replace Text
    • Boolean
    • Calculation

MB DataSuite

  • Home
  • Features
  • Applications
  • Prices

Info portal

  • Knowledge Base
  • Blog
  • Newsletter
  • Change Log
  • FAQ & Support

Company

  • About us
  • Imprint
  • Linkedin
  • YouTube
  • Facebook

Legal

  • Privacy
  • EULA
  • Cookie Settings

Help and support

  • Tel +49 2742 72927 80
  • Live Presentation
  • Contact
  • Deutsch
    • About us
    • Support & FAQ
    • Contact
    • Imprint
    • TOS and EULA
    • Privacy policy
    • Linkedin
    • Facebook
    • Youtube
    [MB] Software und Systeme GmbH