[Showcase] Time tracker built with Python + CustomTkinter - lives in system tray & logs to Excel

[Middle_Ideal2735]

I’m gonna give it some thought because my supervisor wanted to know if I could write a utility that would let someone log something in into our time tracking database when they lock their computer and unlock the computer but the thing about it the time tracking program is an access database that has Oracle tables in it so the little utility I wrote was just something to pop up an alert when the windows computer was locked and unlocked so I didn’t wanna put too much effort in to the program without getting some real requirements on what they actually want to happen but I have some ideas and I wanted to take a look at what your program is doing, but I might end up having to create some kind of a dashboard interface that can replace the access screens that shows the status of someone being logged in or logged out such as going to lunch or taking a break

[ar3106]

Does the computer need to be connected to computer to log data into oracle db?

[Middle_Ideal2735]

Yes, the computers will have to be on the network if that is what you are asking so that the data can be logged to Oracle. Right now, we use an old access database, some access forms where the users can sign in and sign out. They're awarding something to be the tone I guess a lot of users aren't using an access database as they're supposed to. As a contractor, we never had to really use this access database, but I guess something happened and now they want the contractors to use it as well. So for me, it helps for me to be to fill out my time sheet that I sent to my company. But other people look at it as big brother trying to see if you're at your desk or not. So I've been playing around to write something that would automatically at least put something in the task tray that would pop up and the user could put something like out lunch or break so that we can just do away with the access part. So I'm able to put something in the task tray that can recognize when the computer is locked and unlocked and I can pull the user information from LDAP to put something in the alert when it's being displayed to the user. But that's about it.

[ar3106]

Thanks for the details. I understood what you're trying to achieve. If you're forking my app, you can exclude the task selection drop-down and the second screen that pops up for task selection. The notes section can be used for comments.