1

I am using the code in single login credential. I need to use multiple login credentials using python webdriver. Please guide me some one how can i call csv file(multiple login credentials) in this below code.

 from selenium import webdriver
 from selenium.webdriver.common.by import By
 from selenium.webdriver.support.ui import Select
 from selenium.common.exceptions import NoSuchElementException
 import unittest, time, re

 class Browse(unittest.TestCase):
    def setUp(self):
        self.driver = webdriver.Firefox()
        self.driver.implicitly_wait(30)
        self.base_url = "http://careergrab.ionface.com/"
        self.username=['[email protected]','[email protected]']
        self.password=['12345','12345']
        self.verificationErrors = []

    def test_browse(self):
        driver = self.driver
        driver.get(self.base_url + "/")
        driver.find_element_by_css_selector("img[alt=\"img\"]").click()
        driver.find_element_by_link_text("Career Grab").click()
        driver.find_element_by_class_name("browse").click()
        driver.find_element_by_id("id_identification").clear()
        driver.find_element_by_id("id_identification").send_keys(self.username)
        for index in range(len(self.password)):
        driver.find_element_by_id("id_password").clear()
        driver.set_page_load_timeout
        driver.find_element_by_id("id_password").send_keys(self.password)
        driver.find_element_by_css_selector("input.login-button").click()

    def is_element_present(self, how, what):
        try: self.driver.find_element(by=how, value=what)
        except NoSuchElementException, e: return False
        return True

    def tearDown(self):
        self.driver.quit()
        self.assertEqual([], self.verificationErrors)
2
  • What is the problem? What doesn't work? Commented Sep 14, 2012 at 17:08
  • @Kv.senthilkumar Did you found a solution to your question? thanks Commented Jan 15, 2013 at 23:22

1 Answer 1

2

I found the solution. you need to create file test.csv. Copy and paste code below. It worked for me. READ the code for better understanding :)

    from selenium import webdriver
    from selenium.webdriver.common.by import By
    from selenium.webdriver.support.ui import Select
    from selenium.common.exceptions import NoSuchElementException
    import unittest, time, re

    class Browse(unittest.TestCase):
    def setUp(self):
    self.driver = webdriver.Firefox()
    self.driver.implicitly_wait(30)
    self.base_url = "http://careergrab.ionface.com/"

    filename = 'test.csv'
    line_number = 1
    with open(filename, 'rb') as f:
        mycsv = csv.reader(f)
        mycsv = list(mycsv)
        self.username=mycsv[line_number][0]
        self.password=mycsv[line_number][1]
        self.verificationErrors = []

def test_browse(self):
    driver = self.driver
    driver.get(self.base_url + "/")
    driver.find_element_by_css_selector("img[alt=\"img\"]").click()
    driver.find_element_by_link_text("Career Grab").click()
    driver.find_element_by_class_name("browse").click()
    driver.find_element_by_id("id_identification").clear()
    driver.find_element_by_id("id_identification").send_keys(self.username)
    for index in range(len(self.password)):
    driver.find_element_by_id("id_password").clear()
    driver.set_page_load_timeout
    driver.find_element_by_id("id_password").send_keys(self.password)
    driver.find_element_by_css_selector("input.login-button").click()

def is_element_present(self, how, what):
    try: self.driver.find_element(by=how, value=what)
    except NoSuchElementException, e: return False
    return True

def tearDown(self):
    self.driver.quit()
    self.assertEqual([], self.verificationErrors)
Sign up to request clarification or add additional context in comments.

1 Comment

Thanks for your answer. We can use same like this and then we can use python binding of xlrd module . it is very easy to use

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.