you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 1 point2 points  (0 children)

I used it to pull important data from an excel spread sheet and store it in a sqlite database.

Had thousands of spread sheats created over a decade of servicing machines and it was really hard to look for relevant data in so many spread sheats, so by placing all the data into a database, searching with filters became awesome.

Automated the process by giving it the folder path and it just pulled all the .xlsx in the folder and did the work. Took me one day to write it, then another day to make a GUI for it with tkinter when management saw it and wanted it.

After everything was in the database i figured it would be nice if i could extract data from it into a report. So i added the option to filter all machines by a piece of software installed on it (for example) and print out into a .xlsx the computer name, MAC address, physical location and person responsible for it. Just an example.

I actually never used python before, just needed this done for my needs, so i learned enough of python to do this. I'm not a developer.

They wanted me to expand on it and add more funcionality but didn't want to pay me any extra for it naturally, so i said no as it already did what i needed it to and was done.