AutoDoc: RTO Document Upload Automation
Budget: ₹10,000 – ₹12,000 INR
Project Title: RPA Automation for RTO Document Upload (Excel to Web)
Project Description:
I need a robust automation (RPA) solution, preferably using Power Automate Desktop (PAD), to automate the document uploading process on an RTO (Regional Transport Office) portal. The bot needs to handle data from an Excel sheet, match it with local PC folders, and upload documents to the website.
Detailed Workflow:
1. Data Input (Excel Integration):
The bot should read an Excel file containing two primary columns: Vehicle Number and Chassis Number.
It must iterate through each row one by one.
2. Web Navigation & Search:
Open the RTO portal and log in (if required).
Input the Vehicle Number and Chassis Number from Excel into the website's search fields to fetch the specific vehicle's details.
3. Dynamic Folder & File Mapping:
There is a Main Directory on my PC. Inside, there are sub-folders named after each Vehicle Number (e.g., folder "GJ01XX1234").
The bot must enter the corresponding folder for the current vehicle and identify files (RC, Insurance, Fitness, etc.).
4. Conditional Upload & Error Handling:
Successful Upload: If all required documents are found in the folder, upload them to their respective fields on the website and click Submit.
Missing Documents Logic: If a specific document is missing from the folder, the bot should NOT stop. It should:
Upload the available documents.
Trigger a Popup or Log Message identifying which document was missing (e.g., "Insurance missing for GJ01XX1234").
Continue to the next vehicle.
5. Loop & Reporting:
After finishing one vehicle, the bot should automatically move to the next row in Excel.
Status Tracking: Update the Excel sheet in a new column (Status) as "Completed," "Pending," or "Missing [Document Name]" after each process.
Project Description:
I need a robust automation (RPA) solution, preferably using Power Automate Desktop (PAD), to automate the document uploading process on an RTO (Regional Transport Office) portal. The bot needs to handle data from an Excel sheet, match it with local PC folders, and upload documents to the website.
Detailed Workflow:
1. Data Input (Excel Integration):
The bot should read an Excel file containing two primary columns: Vehicle Number and Chassis Number.
It must iterate through each row one by one.
2. Web Navigation & Search:
Open the RTO portal and log in (if required).
Input the Vehicle Number and Chassis Number from Excel into the website's search fields to fetch the specific vehicle's details.
3. Dynamic Folder & File Mapping:
There is a Main Directory on my PC. Inside, there are sub-folders named after each Vehicle Number (e.g., folder "GJ01XX1234").
The bot must enter the corresponding folder for the current vehicle and identify files (RC, Insurance, Fitness, etc.).
4. Conditional Upload & Error Handling:
Successful Upload: If all required documents are found in the folder, upload them to their respective fields on the website and click Submit.
Missing Documents Logic: If a specific document is missing from the folder, the bot should NOT stop. It should:
Upload the available documents.
Trigger a Popup or Log Message identifying which document was missing (e.g., "Insurance missing for GJ01XX1234").
Continue to the next vehicle.
5. Loop & Reporting:
After finishing one vehicle, the bot should automatically move to the next row in Excel.
Status Tracking: Update the Excel sheet in a new column (Status) as "Completed," "Pending," or "Missing [Document Name]" after each process.
Related categories:
Data Processing
Excel
Web Scraping
Process Automation
Data Integration
Automation
Power Automate
RPA Development