---

Wincc Unified Test

---

Table of Contents

1. General Info
2. Development Environment
3. Tested
4. Package
5. Tutorial

---

General Info

• It is a project to test the possibilities of Wincc Unified. At the moment the project is testing these points:
  • Switching screens based on PLC input and recording the current view number to a PLC tag.
  • Faceplate open Faceplate PopUp only once and implementing s UDT (User-Defined Type) interface.
  • Inserting data into a SQL Server Express database (INSERT).
  • Retrieving specific records from the SQL Server Express database(SELECT).
  • Deleting records from SQL Server Express Database(DELETE).
  • Establishing a remote connection to the SQL Server Express database.
  • Developing a custom web control for table manipulation.
  • Developing a custom web control Tetris.
  • SQLite database.
  • MySQL database.
  • Update data in a database (UPDATE).

Images HMI

---

---

Development Environment

• TIA PORTAL V17 update 01
• Pc Windows 10

---

Tested

• Plc S7 1200/1500
• Simatic Pc station

---

Package

RELEASES	COMMENT	DOWNLOAD
	Dynamically change HMI/SCADA screens based on PLC input
0.0.1	Implement UDT interface to open Faceplate PopUp once, enhancing control	Link Download Project TIAPORTAL
0.0.2	Using Subqueries in INSERT statement	Link Download Project TIAPORTAL
	Using Subqueries in SELECT statement
	Using Subqueries in DELETE statement
0.0.3	Establishing a remote connection to the SQL Server Express database	Link Download Project TIAPORTAL
0.0.4	Developing a custom web control for table manipulation	Link Download Project TIAPORTAL
0.0.5	Developing a custom web control Tetris	Link Download Project TIAPORTAL
0.0.6	SQLite database	Link Download Project TIAPORTAL
0.0.7	MySQL database	Link Download Project TIAPORTAL
	Using Subqueries in UPDATE statement

Custom Web Control	COMMENT	DOWNLOAD
0F9F7D83-89C4-469B-A897-40CCE1091384	Template	Link Download Custom Web Control Template
9DE938AC-F10E-4DED-B46D-5B3B0618B180	Table	Link Download Custom Web Control Table
4E4FE6DA-82F7-4B2A-9C67-4432F6BEE3DE	Tetris	Link Download Custom Web Control Tetris

---

Tutorial

Watch the video on youtube.

---

• https://www.youtube.com/watch?v=FK0YO2sVGdQ

---

• https://www.youtube.com/watch?v=b_cZfcwDo8I

---

• https://www.youtube.com/watch?v=mQPbr5zExjw

---

• https://www.youtube.com/watch?v=Ho08pz4NnSY

---

• https://www.youtube.com/watch?v=glEN80kdpNA

---

• https://www.youtube.com/watch?v=MEREY21KcoY

---

• https://www.youtube.com/watch?v=RAA_pDz8YUc

---

• https://www.youtube.com/watch?v=jfNLthcY6LE

---