GitHub - felixrojauro/smed_stopwatch

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 16 Commits
Fonts		Fonts
Imagens		Imagens
mysql-connector-python		mysql-connector-python
.DS_Store		.DS_Store
._.DS_Store		._.DS_Store
._eSMED_settings.xlsx		._eSMED_settings.xlsx
._eSmed.png		._eSmed.png
.gitignore		.gitignore
CoresInsert.xml.sql		CoresInsert.xml.sql
Gipo_Conekt_Rpi		Gipo_Conekt_Rpi
ParagensInsert.xml.sql		ParagensInsert.xml.sql
RFid		RFid
ReadMe.txt		ReadMe.txt
S71200.py		S71200.py
S7200.py		S7200.py
UI10.py		UI10.py
UI10.ui		UI10.ui
cleardb.py		cleardb.py
country.txt		country.txt
db1_9.py		db1_9.py
db1_9.py.save		db1_9.py.save
eSMED_settings.xlsx		eSMED_settings.xlsx
eSmed.png		eSmed.png
faurecia.png		faurecia.png
faurecia_V061.py		faurecia_V061.py
faurecia_V061.py.save		faurecia_V061.py.save
novaDB.sql		novaDB.sql
plc_data		plc_data
plc_ip		plc_ip
raspberry_pi_circuit_note_fig2a.jpg		raspberry_pi_circuit_note_fig2a.jpg
rfid_port		rfid_port
server.py		server.py
simulate_gpio.json		simulate_gpio.json
smed_stopwatch_autorun.sh		smed_stopwatch_autorun.sh
wazne_komendy		wazne_komendy
write_output.py		write_output.py

Repository files navigation

Faurecia eSMED v061

The propose of this app is to act like a stopwatch for SMED at injection lines featuring troax systems 

Features:
	- Visual interface with last and best times
	- Polish and Portuguese language
	- Adjustable objective times
	- Data export to Excel file
	- Info related to current line and time

Files:
	- cleardb.py - Script to restart database values
	- country.txt - Keeps track of current language. Updated automaticaly
	- db1_9 - Version 1.9 of database scripts - Queries and inserts data to database
	- eSmed.png - Printscreen of working app
	- eSMED_settings - Settings for app and tranlation lines
	- fau.png - Faurecia small logo 
	- faurecia.png - Faurecia big logo
	- faurecia_V061.py - Python main app script
	- novaDBb.sql - Database parameters
	- ParagensInsert.xml.sql - Database parameters
	- UI10.py - Python interface file
	- UI10.ui - PyQt designer interface file
	- Fonts Folder - Fonts Folder
	- Imagens - Images folder - Contains app images
	- mysql-connector-python - library for mysql connection

Dependencies:
	Software:
	-PyQt4
	-mysql
	-openpyxl
	-mysql connector
	-RPi.GPIO 
	-Other dependencies depending on raspberry firmware version 

	Hardware
	- Raspberry 3 (optimized for RPi3)
	- 24v->5v Relay
	- Troax system

Luís Soares
2017