Challenge #3
Payment Settlement Bot
Develop a Settlement Bot that will go to the payment settlement file portal to download the report for the day; Unzip the folder; Open the .txt files in the folder; Get the important details needed such as the account number (the first 10 digits), amount (the second digit under the account number), and the reference number (the last random text after the date); Finally, paste this details in an excel and send as an email attachment to starschallenge@stardex.com.ng.
Hints...
- Go to the settlement file portal to fill in your details and download the files needed.
- Unzip the folder to reveal each file.
- Perform string manipulation for each text file to get the details needed.
- Paste details in an excel with headers (Account Number, Amount, and Reference Number)
- Send output excel to starschallenge@stardex.com.ng.
NB: You have to register your details to be able to access the drive to download the settlement file.
Share your screenshot or video of the bot developed on LinkedIn or Twitter with #RPAStarsChallenge and #Stardex.
Concepts you will learn:
Excel Automation
Web Automation
File and Folder Automation
String Manipulation
Email Automation
Tools to use:
Any RPA software such as UiPath, BluePrism, AutomationAnywhere, PowerAutomate, etc that you are familiar with.