Key Error while running createLeadTest | Selenium Python Forum
N
Nitika Sharma Posted on 26/01/2021
 

Lecture-9

Hi, I am facing the Key Error while running the CreateLead Test but not able to rectify this issue.Can you please help

Kindly check the attached zip file


J
Jaspreet Replied on 27/01/2021

Hey, 

The issue is in reading the excel file. The maximum columns are not being read out because of which column is not being read. Update your file 'readingexcel.py' where you are reading the no. of maxcols. Part to be updated is given below:

maxcols=0
    try:
        while not xls.checkemptycell(constants.DATASHEET,colstartrowindex,maxcols):
            maxcols=maxcols+1
            print("maxcols are : " +str(maxcols))
    except Exception:
        pass


N
Nitika Sharma Replied on 28/01/2021

Hi thanks for the update.This issue has been fixed but now in same script I am facing error while entering lead details.Last name is also getting entered in first name and lead is not getting saved

Screenshot linkS: https://drive.google.com/file/d/1bgJOCPNWLsFcQgjVD_ycijFrEkAvif-T/view?usp=sharing

https://drive.google.com/file/d/1jO_13AY9C5XYZVm7fwdn0YabNt-BwfeL/view?usp=sharing


J
Jaspreet Replied on 29/01/2021

Hey

Use time.sleep(5) after entering firstname.


N
Nitika Sharma Replied on 29/01/2021

 

Hi I have applied time.sleep(5) in EnterleadDetails page class after first name but still facing same issue.Its still typing the last name in first name field.


N
Nitika Sharma Replied on 01/02/2021

Please help I am not able to proceed further.

Waiting for ans


J
Jaspreet Replied on 03/02/2021

Hey, 

Replace the file given with the 'EnterLeadDetail.py'


N
Nitika Sharma Replied on 05/02/2021

 

Thanks for the solution.It works fine now


J
Jaspreet Replied on 10/02/2021

Thank you for the update.