Medium badge

Automation Machine

Louisville-Metro-Badges/Automation-Machine

Work to automate some process in the data life cycle- from data collection to data visualization.

 

Jorge Felico

Expert

Awarded badge on December 15, 2017

Medium img 0040

Endorsements & Feedback

Feedback

Wow great work!

That's an awesome example and really good explanation. Thanks for making Metro better!
Small img 0040 jorgefelico About 2 years ago

Badge Portfolio

Proof of Automation

Evidence visible to public
Write up a summary about how you were able to change the process, and how the current automation process works. More Info

Automated dataset pull for OMB and gave them a great looking interface to search through the data.

Some of this is private so I will be very vague with the explanation. OMB needed a way to look through a dataset... The problem is that the dataset was being provided as a TXT file in an FTP server, so they would have to manually connect via FTP and download the file, and open it up with excel. I created a cron job that runs a bash script that I wrote from scratch to connect to the FTP, download the newest file, save it to a particular directory, and then do a CURL request to a particular website that then consumes the TXT file, parses it and inserts it into a database. OMB is then able to log in to the website that I created for this and search through the data in order to perform one of their daily tasks. Also, this web application will also be used by Codes and Regulations :). If anyone working for Louisville Metro would like to see this web application, as well as the cron job, contact me for a demo.