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 (Install or update to 3.12.1 or higher)
2. Install MySQL (Take the 8.0.35 version or higher, do not download the web version, install the full version)
3. Install PIP (If pip is not found you need to go to the link, note that if you have downloaded Python 2.7. 9+ and Python 3.4+ you will have pip)
4. If Python or MySQL is not found in the command prompt, you must add the path to the system environment. Please follow the YouTube instructions or article to add the path to the cmd so that you can use Python and MySQL in cmd. Youtube Window 10 or Youtube Window 11 or Article
5. Download the Work Instruction folder
6. Open your terminal and navigate to the downloaded folder (The folder where "work_instruction_creator.py" is)
7. Install all the App dependencies (If there is an error when trying to install that means that there is a newer version of App dependencies, download the newest one)

pip install -r requirements.txt

8. 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 user, and password of your MySQL server as shown below:

#.streamlit/secrets.toml

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

9. Create the required Database and Tables, In CMD cd to the database.txt directory

mysql -u root -p < database.txt

10. Run the App, to re-run the App, cd to the folder with work_instruction_creator.py in cmd and type the following instructions.

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