Tag: automation

Login Automation Using Selenium Not Working Properly

I have built a login Automator using Selenium, and the code executes without errors but the script doesn’t login. The page is stuck at login page, email and password are entered, but login is not completed. enter image description here I have tried 2 ways to login: By clicking on Login through Click () Using Enter in password area But

how to disable outlook security pop-ups when sending emails via python

I have a problem I am trying to automate the sending of emails using win32 in python. The problem s that every time when I run the code I get a security pop as shown below How do i disable it Answer Disclaimer: you should not be sending messages by automating a message software, EVER. There are way better ways

How to scroll down in side menu

I am new to selenium python, how to scroll down to the bottom of the filter in swiggy. When I tried the background page is getting scroll instead of filter. enter image description here Answer First you have to be sure to target the correct element, in this case the side menu, then with javascript you can edit its scroll

Error when executing a test whose .sql file has variable (Robot Framework)

I have the following situation, could you help me? I would like to leave some dynamic data (variables) inside my .sql file and execute my test correctly in .robot file. However, when I go to do my test, it returns an error, that is, the variable is not mounted correctly. I think I’m leaving something “behind”. Could anyone help me?

Add pivot table in excel with python

I am trying to add a pivot table in excel using python script with pandas but not able to do so. I won’t to count number of missed and met entries for each priority. Excel script: Excel data: Priority SLA p1 Met p2 Missed p3 Missed p2 Missed p3 Missed desired output: Priority Met Missed p1 1 0 p2 1

Find a Excel file in directory, compress and send it to another folder

I have an Excel file WK6 that is downloaded in the below folder: The Python script should first navigate till the above directory and then find the excel file WK6 (the name of the excel file changes as per week) and compress it. Then move it to some other directory. Please help me understand how can I find and compress

Automate appending yesterday’s date to end of file names using Python?

I’m trying to solve a problem at work, I am not a developer but work in general IT operations and am trying to learn a bit here and there, so I may be way off right now with what I’m trying to do here. I’ve just been utilizing online resources, here and a little bit from the book Automate the