To develop a BOT which can remove redundancy of admitted students and applied students from given files and append the total admitted and applied students’ available details in specific admitted and applied output files respectively.
The aim of the BOT is also to remove a given mobile number from each given file as per the Admin's requirements.
• The BOT will take input of different files namely Admitted, Application, Common, Walkin, Lead, Output Admitted and Output Applied Data Files.
• It will remove redundancy of data from Application, Common, Walk-in and Lead Data Files based on Admitted Data File using mobile number and application number as primary keys.
• It will remove redundancy of data from Common, Walk-in and Lead Data Files Based on Application Data File using mobile number and application number as primary keys.
• It will take input of a mobile number from admin and is capable of removing all of its occurrences from all 7 files in case the mobile number has stopped working and is uncontactable.
• Append Output and Remove Redundancy (Data)
• Remove Not Required Mobile Numbers
- Open Chrome or any other browser installed in your system. (If not, download the same)
- Goto URL : https://www.uipath.com/
- Register yourself with the appropriate details.
- Sign-in and download UiPath Community Edition from the same.
- Run the downloaded UiPath Community Edition installation (exe) file and install with required details.
- After installation, open UiPath Community Edition.
- Click on Process given on the right side of the window.
- When the dialog box for process opens, enter the name you want to give to your bot and the location you want it to work from.
- Click on Create.
- Close UiPath.
- Now, open file explorer and paste all the project files in the location which contains the folder of your newly created process.
- Open UiPath.
- Open the project you named (say, botathon).
- Click on Manage Packages.
- Search BalaReva Excel and install both the packages as marked in the snapshot given.
- Click on project panel given on the bottom-left side.
- Now, click on Flowchart.xaml
- From Debug File, select Run File.
- From the panel shown select the option on which you want to work on:
Option 1: This will remove redundancy of admitted data from all other files and append details in final output file and also for applied data from other files and append the details in final output for the same.
Option 2: This will remove the given mobile number, if present, in any of the excel files.
- On selecting first option and clicking Ok, you have to provide all the 7 excel files one by one.
- If second option is chosen, then, provide the mobile number in the window as shown below without putting +91 before any number and press Ok.
- Now, select all the seven files one-by-one through the selection windows like the one given below. Make sure to select the correct files which have been asked.
- Now, let the bot do the work.
- After the operations have been finished check the files modified as output.
This project was created by TEAM DDDK (Dhruv Dixit [Leader] and Dhreeti Kesharwani) as a part of offline national level hackathon Botathon 2.0 conducted at JECRC University, Jaipur sponsored by UiPath based on Robotic Process Automation. We won 2nd prize representing our college United College of Engineering and Management, Praygraj, Uttar Pradesh among 136 teams participating from 17 states of India.