LPC sign-in/out system at guard house with RFID, Tkinter, Raspberry Pi, Python, Excel, and Google Drive API.
- Mac/Windows computer: internet access, two monitor ports, ethernet(preferred)/wifi connectivity
- Raspberry Pi (ethernet preferred) - Assigned static IP/Direct Connection
- RFID card reader
- Two monitors
Main computer is connected to RPi through ethernet/wifi. RFID reader(s) connected directly to RPi. Both monitors are connected to the main computer.
Starting script initialize main script & parameter -> main script starts listening indefinately RPi capture RFID reader input indefinately -> sent to main script with socket -> process info -> display info -> record data
- Package tkinter app to .exe
- Color code in
tksheets
& exported Excel/Sheets - Incorporate web-based dashboard to assign overnights/extensions/gating
- Upload to specific folder on google drive
- Improve UI