Submit a Form With CSV/excel Data using Python : Web Automation Part 2

[@rayray7244]

This kid is going to take over the world one day! Holy Moly!

[@vinayakdevc6]

thank you kid, this made my job 100x better, i hate data entry, unfortunately i had to do this. thanks for your explanation and few changes with new documentation i started loving data entry😆!

[@SAYN12]

great Rishab, very good excellent speech, and explained

[@BestoracleDBA]

Excellent presentation

[@stephenscorzo]

This was an excellent video on how to automate for filling which is straight to the point, informative and very impressive.

[@RishabTeachesTech]

thank you !!

[@eduardotejeda]

This is so helpful. Thank you for making this video.

[@masterprog48]

awesome kids , i respect you

[@iamkzonjames]

Nice video. What if i want to use proxies a driver opens and if you need to solve a captcha before submitting the form? How can i integrate those? Thanks!

[@xandergr8t]

Matey this is amazing! Keep it up!

[@appsgames3513]

If the csv file contains the hindi language and emojis then send_keys is not working so how to fix that

[@cpramanick]

Hi, can I use this code fill out any from in specific website, what about the attachment if I have to attach.

[@kadiriyoussef2782]

very good excellent explained, I have a question How to fill Drop Down, Radio Buttons or Checkboxes with a CSV File using Python

[@pedrolebre2827]

How can you write this so that it keeps looping through each row without opening a new browser instance for each row?

[@kaifmomin2119]

Hey nice video...one question and im not sure if you covered it or not, but can you create an auto fill bot that can work with different form types (ie google and microsoft) and for a form that you do not know the fields of. I want to create a auto filler that fills my name, address, email, phones number, etc, for every form, regardless of the other fields. I dont want to fill these fields every time and just want to worry about the other ones....thanks!

[@kadiriyoussef2782]

Hi, this is excellent video, I have a question, how I can save this form for example in CSV/Excel using Python

[@macrozel-id]

how to make something like this, but not opening a browser, i mean, just run and done. no apps opened. thanks

[@RishabTeachesTech]

You can use request.get that can fetch web page contents without launching the browser. I may do a video on this topic soon.

[@varunkumarmachipeddi9057]

@@RishabTeachesTech please post it possibly faster

[@RishabTeachesTech]

@@varunkumarmachipeddi9057 Here it is :) kzbin.info/www/bejne/mJi4fXute6ajqMU

[@Elhmiz]

I have csv data and I want to upload this data from website using python

[@mehdismaeili3743]

Hi, this is excellent video, thanks.

[@mjnyota]

what if the form has a radio button?

[@rupaliurkude5298]

can this work for crm website??

[@indie226]

mantap

[@378983149]

damn, kid you are great xd, thanks

[@378983149]

you just made my life easier

[@frankservant5754]

thanks kiddo

[@BestoracleDBA]

Excellent video. Great job. I am having issue picking the 2nd column. First element (First column, First Row) after that it don't pickup 2nd column and I see error "NoSuchWindowException: Message: no such window: target window already closed from unknown error: web view not found (Session info: chrome=108.0.5359.99)" Ths is my code can you let me know what is missing. Thank you. import csv import time import webbrowser from selenium import webdriver from webdriver_manager.chrome import ChromeDriverManager import pandas as pd import requests from selenium.webdriver.chrome.service import Service from selenium.webdriver.chrome.options import Options with open('test.csv', 'r') as csv_file: csv_reader = csv.reader(csv_file) for line in csv_reader: ## print(line) driver = webdriver.Chrome(ChromeDriverManager().install()) driver.get("""www.2-10.com/get-a-quote-ypmrt/?gclid=CjwKCAiAs8acBhA1EiwAgRFdw3oVH8ouB_zhXvpIP2iSzqcBvWv-d8JTtlG1bqgT8QspxJgJDwNyURoCWn4QAvD_BwE""") driver.maximize_window() time.sleep(1) name= driver.find_element('xpath','//*[@id="zip"]') name.send_keys(line[0]) l_mame = driver.find_element('xpath', '//*[@id="email"]') l_name.send_keys(line[1]) submit = driver.find_element('//*[@id="topLoginForm"]/div[3]/button' ) submit.click