Python Automation | Part 10 : Automatic Form Submission using Python |Python Selenium Web Automation

[@adithyanvr9399]

1 st Please pin me

[@CodeBand]

Keep supporting brother❤️

[@tigreonice2339]

Related with selenium: I have an excel or csv file, some cells have NaN value. I want when there's no value (Nan) the driver doesn't fill in the web input(with 'Nan' or nan), just skip it to the next line code instruction.... how can I do that?

[@mfsdrawings8600]

Superb🤩👍

[@CodeBand]

Thanks a lot❤️

[@rahulteja536]

really helped me a lot.

[@CodeBand]

Very glad to hear that and keep going😊

[@rangabharath4253]

awesome as always bro

[@CodeBand]

Thanks a lot brother..keep supporting❤️

[@TevfikBagcivan]

This video is very helpful for web automation. Thank you

[@CodeBand]

Glad it was helpful!😊

[@ajmalbinnizam]

keep going bro.. addicted to the web automation playlist 😍😍

[@CodeBand]

Lots of love bro❤️ Keep going👍🏻👍🏻

[@sidtech10]

Thank you so much ❤ that 2nd way to submit was really helpful for me

[@CodeBand]

Very glad to hear that😊

[@RaviSharma-zb9ve]

thanks a lot

[@CodeBand]

Glad to help you out...😊

[@amarnath9945]

3:58-4:05 You said that it has been already discussed it's simple. please share the link of the discussion, I need that

[@CodeBand]

This video is a part of Python Automation Series... I have taught all those things in the previous videos...

[@creshalybeau149]

Hello do you have any idea how to automatic web form with datepicker? I have excel file with date(dd-mm-yyyy) and rainfall coloumn for a month. How can i autofill them with a form consist of date picker and rainfall entry. Thank you

[@CodeBand]

Sorry for the late reply... Was this solved ? It's actually not very hard, check this out : stackoverflow.com/questions/49747034/select-from-a-datepicker-in-python

[@ThamizhiShanmugam]

Hi, does this work for Microsoft Forms?

[@davidramosmartinez9057]

Hi there, Thanks for share your knowledge, I'm having an issue entering numbers from an excel. Python is giving me this error "object of type 'numpy.int64' has no len() ", I google it and it telling me that is error happend when you try to add types such as integer, float, boolean, long, complex. What other fuction can I use in this case? Kind regards!

[@CodeBand]

Sorry for the late reply... Is this solved ? Or can you pin-point where exactly the error is occurring...

[@harriscastro535]

This a great video. It seems that the xpath for choosing radio button is not working when used in MS Forms. I tried it and it just skips the radio button question for me. Do you have any alternative way to choose a radio button based on MS Forms? Thanks!

[@CodeBand]

Glad to hear that... I haven't actually tested with MS Forms... Please research on Google and SO, and if you've found any solution, please post here. Thanks🙌🏻

[@awaismaz]

How to deal with 'unseen' forms. If I have a url and I need to find forms on that url and submit them automatically without opening them and finding xpath, what will be the procedure?

[@CodeBand]

Sorry for the late reply... Were you able to design that ? Well, that's achievable, but a little tricky. You'll have to find forms by tag, get all the inner inputs, read the input field name and populate the data and then submit.

[@mehulpanchal4472]

Hi Code Band, Need your help to find Combo Box and entering the value .Can you please help me on this

[@CodeBand]

Sorry for the late reply... Solved ?

[@royalwinautomatedsoftware2985]

Hai sir, ur video super. I learn so much ur channel. I have one doubt I'm using excel data python. Excel sheet cells I have created formula. Excel read data python program only copy formula not value. Please help me I need excel rows read values only. Please advise sir.

[@CodeBand]

Sorry for the late reply... Is this solved ?

[@royalwinautomatedsoftware2985]

@@CodeBand solved 👍

[@moeinht2713]

I used selenium to click a page I need to use Chrome cache and cookies But Chrome works as a test software please guide me

[@CodeBand]

Sorry for the late reply... Check this out : stackoverflow.com/questions/53095611/python-selenium-how-to-get-cookies-and-format-them-to-use-in-an-http-request

[@omkarupare8706]

I want to reload form after first entry submitted and after that fill second entry .

[@CodeBand]

If it's not going somewhere(or reloading), you can manually refresh the page like how you first navigated to the same page initially. Alternatively, you can use, driver.refresh()

[@vatsalaykhobragade]

My code is filling the form for the first time only after that the program just stops. How do I fix this ?

[@CodeBand]

Sounds like some issues with the code you've written... Maybe the loop is only running once... Please check and confirm...

[@vatsalaykhobragade]

@@CodeBand I've fixed it.

[@CodeBand]

@@vatsalaykhobragade Keep going

[@akm1511]

Hey Can you please help me on how to fire a website using single sign on.. because as soon as the website detects that chrome is being controlled by automation test software it does not allow access.

[@CodeBand]

Which service are you using? Sign In with Google?

[@akm1511]

@@CodeBand Never mind.. I figured it out. But yes kudos to you. Nice tutorial with all bases covered.

[@CodeBand]

@@akm1511 Very glad to hear that...keep going👍🏻

[@stembabe740]

How can we edit the script to run so that it automatically fills out the patient information only after inputting the the first form.

[@CodeBand]

You can put an input() before the actual code for auto filling begins and then after filling the first form, you can enter something in the console, and the rest of the code works... This is just one way of doing it😊

[@stembabe740]

@@CodeBand in this case it would be input patientID and then the rest of the form would be completed

[@CodeBand]

You can do pretty much everything as you're doing it manually...after typing anything in the console, the rest of the code executes...😊

[@madhav3444]

Hey just wanna thank you for this precious knowledge. I have a question, that what if the script brokes somehow in between for any particular row data of excel, how can we tackle this thing and continue our script for other row data or index?

[@CodeBand]

Good question, you can achieve this thing in different ways.... 1) By having a file in which you have the current row number...You need to update this value after you complete each item... 2) Keeping a separate copy of the excel file, and upon filling the data, delete that specific row... And a lot of other ways too... Keep going👍🏻

[@srinivasanseenu731]

I am getting this error "name 'send_keys' is not defined " . I tried both the package, but still same issue from selenium.webdriver.common.keys import Keys Import selenium.webdriver.common.keys.

[@CodeBand]

Sorry for the late reply... Was this fixed ? Seems like the object you're trying to send_keys to is not an input field.

[@sanielsainoding2735]

Subs here, may I ask if I run again the script it will run same entry.? I just wanted to skip the entry once it is done. Please help

[@royalwinautomatedsoftware2985]

Hai sir, ur video super. I learn so much ur channel. I have one this video I try read data is work. I want write data for excel can plz send format for write data in pandas

[@CodeBand]

Sorry for the late reply... This can be a good resource : xlsxwriter.readthedocs.io/working_with_data.html

[@hamud350]

Hey bro when it’s a number it doesn’t type it any idea how to fix it

[@CodeBand]

You might need to convert it into str... something like str(your_field)

[@hamud350]

or i in range(len(val)): TypeError: object of type 'numpy.int64' has no len() how to fix this

[@CodeBand]

Please tell me where the error is, I mean the timestamps, so that I can help you out... Probably, the issue here is you might have incorrectly placed the variable 'val' in the for loop😊

[@vmdbeats5909]

@@CodeBand i have this issue too and I dont have a val variable in my code at all nor the '' len() function

[@vmdbeats5909]

you can do for exp : title.send_keys(str('' the input'')) converting it to a string fixed it for me

[@aryajakbar5830]

@@vmdbeats5909 it works but the code input all data in the column. can you help me?

[@madhav3444]

Have you ever explained in any of your video that how can we scrap the values from the Web and fills back the values in excel for a particular row, then plss refer your tutorial or make a tutorial, it would be really helpful. Thank you ❤️❤️

[@CodeBand]

Great suggestion! I actually planned for one...but somehow, I just forgot that stuff...I will post one in future, if possible. Anyway, I have explained scraping in my earlier videos (Instagram Profile Fetching), the only thing I left behind was writing into excel which you can btw do with pandas library or the normal Python DictWriter class. (I have also explained how to read data from excel and fill in the form in this video.) Keep going😊

[@mpumisetshedii]

Have you found a resource for this?

[@wspaiva]

Thank you very much!!! Congrats!!! Like DONE - Subscribe Super DONE

[@CodeBand]

Very glad to hear that...😊