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
  • Trigger Actions
View Categories

Exporting and importing data blocks (DB)

Lesedauer: 1 min

Export #

DescriptionAllows the export of all variable names and values from a PLC data block. The export can be saved in a CSV, XLSX or XML file
Required LicenseStandard

With the help of this trigger action, we can easily create a backup. We can save recipes for later use or document changes. We simply specify a file in the action itself. XML, CSV and XLSX (Excel) files are supported. We specify XML files via their path, while we add CSV and XLSX files via the Excel files menu and then select them. We then specify from which controller and which DB we are exporting.

For example, we can use this function to create an image of our DB when an error occurs so that we can track it more easily. Or we can simply save recipes and read them in again later.


Import #

DescriptionAllows all variable values to be imported into a PLC data block from a previously created export.
Required LicenseStandard

With the help of this trigger action, we can easily load a backup of our data block. We can load recipes for our PLC or load a previous backup if there have been unwanted changes in our DB. In the action itself, we simply specify a file. XML, CSV and XLSX (Excel) files are supported. We specify XML files via their path while we add CSV and XLSX files via the Excel files menu and then select them. Finally, we select the controller and the DB to which we want to load this backup.

For example, we can use this function to load a previous state of our DB if an error occurs or we can load prefabricated DBs.

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

Wie können wir helfen?

Set PLC time FTP Upload
Inhalt
  • Export
  • Import

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