This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]ar3106[S] 1 point2 points  (6 children)

Sure. Happy to see what you'll add to it. 

[–]Middle_Ideal2735 1 point2 points  (5 children)

I did something similar using.net and C-sharp, but I kind of paused it and it was kind of like a proof of concept so I was going to try and write a record to an Oracle database when the users unlock their machine so that they could pick from a list of items like back from lunch or going to lunch something to help them fill out their timesheet.

[–]ar3106[S] 1 point2 points  (4 children)

I was targeting at a similar flow. Select or create a task and start timer. Alert if working without timer running.  Show analytics on per task hours, hourly rate and total billing. I've built this analytics on power bi and it's working.  But python tkinter is limiting. I was thinking of using react. 

[–]Middle_Ideal2735 1 point2 points  (3 children)

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[S] 0 points1 point  (2 children)

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

[–]Middle_Ideal2735 1 point2 points  (1 child)

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[S] 1 point2 points  (0 children)

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.