FEATURES

• File tranfer to SFTP

• Scheduled Program Run

• Process Logs and Notification

OVERVIEW

• This automation project was implemented in my previous organisation by me as it became very tedious to download clean and notify the database team to update the latest file.

• eTRACK (our application) has a Solar and Inverter module which required latest approved solar and inverter equipment to be listed for customers to choose from.

• This latest approved solar and inverter lists are available here (https://www.energy.ca.gov/programs-and-topics/programs/solar-equipment-lists) which are updated every 2 weeks and had to be downloaded, cleaned, transformed and uploaded into eTRACK application.

• So, I came up with a solution to use Python to automate the whole process.

CHALLENGES

• SFTP Access via Python

• Sending the correct Notification

METHODOLOGY

• Automation

  
  

GITHUB REPOSITORY

https://github.com/UniNash/pvinvUpdate.git 

GitHub Repository contains:

1. Documentation

2. Python code

TOOLS IN PLAY

1. Python

2. MS Excel

DATA PROCESS, STORAGE AND MANAGEMENT