work-instruction-create-and-deploy

Streamlit-based tools to create, edit and deploy step-by-step multimedia work instruction documents for the process line.

implementation guide

1. Install Python
2. Install MySQL
3. Download the Work Instruction folder
4. Open your terminal and navigate to the downloaded folder
5. Install all the App dependencies

pip install -r requirements.txt

6. Add username and password to your local app secrets
   Your local Streamlit app will read secrets from a file .streamlit/secrets.toml in your app's root directory. Create this file if it doesn't exist yet and add the database name, user, and password of your MySQL server as shown below:

#.streamlit/secrets.toml

[mysql]
host = "localhost"
port = 3306
database = "xxx"
user = "xxx"
password = "xxx"

7. Create the required Database and Tables

mysql -u root -p < database.txt

8. Run the App

streamlit run work_instruction_creator.py

---

Credentials

Admin

Username: admin  
Password: admin123

Instructor

Username: instructor  
Password: instructor123

Operator

Username: operator  
Password: operator123

---

Features

Admin

• Create Work Instructions
• Edit Work Instructions
• Deploy Work Instructions
• Delete Work Instructions
• Filter Work Instructions
• Create Work Instruction Steps
• Edit Work Instruction Steps
• Delete Work Instruction Steps
• Send data to MQTT Broker through MQTT
• Receive data from MQTT Broker through MQTT
• Admin dashboard with Operator Access Control Panel and Operator parameters assignment Panel

Instructor

• Create Work Instructions
• Edit Work Instructions
• Deploy Work Instructions
• Delete Work Instructions
• Filter Work Instructions
• Create Work Instruction Steps
• Edit Work Instruction Steps
• Delete Work Instruction Steps
• Send data to MQTT Broker through MQTT
• Receive data from MQTT Broker through MQTT

Operator

• Deploy Work Instructions
• Filter Work Instructions
• Send data to MQTT Broker through MQTT
• Receive data from MQTT Broker through MQTT

---

Demo

Click on image to watch the demo video