Browser automation using Python-selenium (web-form filling)

Welcome to a quick video tutorial of browser automation using python.

Most of the web-based databases have no access to back-end large data upload. This helps to minimize the risk involved in the upload of malicious script or unauthorized access. This is mainly because the end users may have less knowledge in database management, PHP and other programming languages.

The task of filling web-form may not be as hard when one has a handful of data to fill, for example when tasks like taking a client bio-data as one fill the web-form. Buts most cases people prefer having the data in an excel sheet or CSV. The amount of work may pile up to a large data file. At time data collection and data entry is done separately.
Python becomes a very helpful tool to help automate these tasks. Python programming is easy to learn and one can kick start using Youtube Tutorials and become a master.
This process requires fast internet speed and a fast computer
I have provided a video sample of browser automation using python scripting. For more information or customized jobs please contact Email: [email protected]
the excel sheet or the CSV file should march the web-form field requirements
Date should be yyyy/dd/mm not 11/23/1986 (mm/dd/yyyy)
also, the field has not been coded yet.
that is done
creating a field in python using xpath

let's get the xpath of the DOB field

we have the xpath

"//input[@id='jform_com_fields_date_of_birth']"


this is not enough.
and error will occur

this is because the date of birth is on a separate tab in the web-form and it's not provided for.
it's done. let's run the script now

we forgot to click back to the start tab
we are good to go..........

oops, another error. this will clear such errors
we can reduce the waiting time to increase speed

the 1000 entries take less than 2hrs.

each entry is printed below.

that's all for now but if you have questions please contact me in the email or tel: +254724438204 (on WhatsApp)