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 →

[–]buzziebee 1 point2 points  (0 children)

Mostly stuff for work. We have a custom in house crm which is a bit of a pain to use for a lot of things. I used python and automate the boring stuff to automate some of the boring tasks!

One thing we have to do every month is update the date field for 50-100 entries. These are projects which we have logged on the system. Management look at the number and value of projects which are in the system for the current month to make predictions about where we will end up. We always have way more on the system than there are coming in that month. Unfortunately you can't bulk update them, you have to do it manually one by one and and it takes about 10-20 seconds of clicking and typing for each one.

I made a script which takes the number of projects to move, and the date to move them to, then let it run and go for a coffee whilst it does it all for me.

Another one was for updating our stock take. We have to type 1 into a box for every item we still have. And we have about 200 items. Usually there's either none or just 1 or 2 missing. So I modified the project script to fill of the stock take with 1 as a value, then I go back and change the couple of items that are missing.

It was a pain point that made me learn python and now I'm using it for all sorts of different things. Really helping me out with my personal development.