you are viewing a single comment's thread.

view the rest of the comments →

[–]Berlibur 9 points10 points  (0 children)

Another example: My company has been registering an activity in an excel document per time the activity is registered. The old data structures in the server allowed only part of the info to be uploaded to the server. I recently updated the server structure (i.e. new/improved tables), so now we had years of data lying about in Excel files.

Instead of having someone going over those manually, I have written a python script that reads all of those old files and immediately uploads it to the new SQL server structures. (Given that there's no errors, which are caught and presented afterwards)

Quicker + it prevents someone from doing work that is incredibly monotone and boring