Skip to content

msf4-0/workflow_instruction_version2.1

Repository files navigation

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
  1. 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"
  1. Create the required Database and Tables, In CMD cd to the database.txt directory
mysql -u root -p < database.txt
  1. 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

Demo Video

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages