AutoMATE Python script was created to act as a bridge between two separate systems we use at CMS. The code is responsible for gathering data about new, unexported orders by connecting to SQL database and saving a CSV file of these details into a folder that is used by a different software responsible for importing these orders into the system. AutoMATE also populates the ‘predicted’ project names in the CSV file and sends the details to specific emails to allow the users to update the orders’ project names. Before the script was created, a full-time employee was doing that job, and afterwards, the employee could perform more fruitful tasks as the software runs seamlessly without any interference. The script runs at certain times of working day by using a Batch file which is executed by Windows Task Scheduler.

Technologies used:
Visual Studio, Python, SQL, SMTP