How to publish data from Excel file to MQTT, and write back data from MQTT to Excel file
Part 1 : Create VB project, Read & Write Excel file
Part 2 : MQTT publish and subscribe, Testing
We will use :
+ Miqottt.com as MQTT broker
+ WPS Office spreadsheet to create Excel (xlsx) file
+ Visual Studio 2022
+ MQTT Explorer
Hello innovators !
This video tutorial shows how to create a VB (Visual Basic) dot Net Windows Form application to read data from MySQL and publish to MQTT.
These are the steps:
00:00 - intro
00:11 - setup database & login to Miqottt.com
01:34 - create a new VB WinForm project
10:20 - install package: MySQLConnector & M2Mqtt
11:55 - scripting
27:25 - start Runtime & Test
We use Miqottt as a MQTT broker. If you don't know about it, please watch the previous video here: https://youtu.be/G7tTA49Vd7w
Miqottt is FREE. You can register and follow the steps here: miqottt.com
Thanks, and have a nice day !
Hello innovators!
If you have Modbus data and you want to make it accessible from the internet, this video could be a perfect solution for you.
The goal of this project is to publish Modbus TCP data to MQTT so we can access it from anywhere and any application.
This is a Modbus IOT (internet of things) project.
Before you start, there are a few things you have to prepare:
1. get access to a MQTT broker. We will use Miqottt.com as a FREE MQTT broker. All you need to do is easily register, login and create a topic.
2. a Modbus device or simulator. We will use ModbusHD. You can get it from this link: https://youtu.be/gmmLis3Vk6Y
3. Visual Studio 2022 as an IDE for creating a project.
4. an application to check MQTT data. We will use MQTT Explorer.
These are the steps:
00:00 - intro
00:10 - create a new VB WinForm project
04:26 - login to Miqottt.com to get MQTT topic
05:04 - configure Modbus Register address
08:32 - install package: EasyModbus, M2Mqtt
10:07 - Scripting
19:53 - test Modbus with ModbusHD
20:32 - scripting MQTT client
24:41 - test MQTT with MQTT Explorer
Thanks, and have a nice day!
Hello innovators!
This video tutorial is for you who want to create Mobile Application as MQTT client for iOS and Android using Xamarin Forms project with Visual Studio on Mac.
From this app, you can Subscribe to get/read data and Publish to set/write data to some MQTT topics on the MQTT broker.
These are the steps:
00:00 - intro
00:11 - login to Miqottt.com and get main Topic
00:50 - test with MQTT Explorer
01:34 - create a new Xamarin Forms project
04:46 - edit MainPage layout
11:01 - install M2Mqtt package
11:49 - scripting
18:30 - start Runtime iOS emulator
21:32 - start Runtime Android emulator
We use Miqottt as a MQTT broker. If you don't know about it, please watch the previous video here: https://youtu.be/G7tTA49Vd7w
Miqottt is FREE. You can register and follow the steps here: miqottt.com
Thanks and have a nice day!
Hello innovators !
This video tutorial is for you who want to create a C# Windows Form application as a MQTT client.
From this app, you can Subscribe to get/read data and Publish to set/write data to some MQTT topics on the MQTT broker.
These are the steps:
00:00 - intro
00:11 - login to Miqottt.com and get Topic
00:39 - create a new C# WinForm project
04:21 - add M2Mqtt library
04:49 - scripting
13:40 - test Runtime with MQTT Explorer
We use Miqottt as a MQTT broker. If you don't know about it, please watch the previous video here: https://youtu.be/G7tTA49Vd7w
Miqottt is FREE. You can register and follow the steps here: miqottt.com
Thanks, and have a nice day !
Hello innovators !
This video tutorial is for you who want to create a VB (Visual Basic) dot Net Windows Form application as a MQTT client.
From this app, you can Subscribe to get/read data and Publish to set/write data to some MQTT topics on the MQTT broker.
These are the steps:
00:00 - intro
00:11 - login to Miqottt.com and get Topic
00:39 - create a new VB WinForm project
04:43 - add M2Mqtt library
05:15 - scripting
16:48 - test Runtime with MQTT Explorer
We use Miqottt as a MQTT broker. If you don't know about it, please watch the previous video here: https://youtu.be/G7tTA49Vd7w
Miqottt is FREE. You can register and follow the steps here: miqottt.com
Thanks, and have a nice day !
Hello!
This video shows how to:
Plug your ESP32 board into the PC and use Arduino IDE to program it.
We use Miqottt as a MQTT broker, it's free and easy to use. Please register at Miqottt.com and watch the previous video: https://youtu.be/G7tTA49Vd7w
SCALARE* is SCADA Application Software, that's also free and easy to use. Please watch this video: https://youtu.be/9izqUVRvfcw
Thanks, and have a nice day!
