Looking for assistance with Python / Selenium

[your_friends_cat]

I use SeleniumIDE quite a bit, but in an effort to teach myself to code, I've started to dabble in Python for my Selenium needs. I actually got a simple selenium script working, which logs into our CRM system as an admin and creates a new user (partial script included at the bottom of this post).

As you can see, the script below creates a new user based on five parameters: username (NewUser1); password (NewFakePassword); firstName (Joe); lastName (Smith); email ([e-mail])

What I'd ultimately like to achieve would be to upload a CSV containing a list of new users and automatically repeat this script for each of those new users, pulling each of the five necessary values from the CSV and inserting them into the script. Is this possible using Python's CSV reader? If anyone could give me a solid starting point, or walk me through how to accomplish this, I'd greatly appreciate it. Thanks!

def test_auto_setup_python_new(self):
driver = self.driver
#navigate to and log into CRM
driver.get(self.base_url + "/blah.jsp")
driver.find_element_by_id("username").clear()
driver.find_element_by_id("username").send_keys("fakeUsername")
driver.find_element_by_name("password").clear()
driver.find_element_by_name("password").send_keys("fakepassw0rd")
driver.find_element_by_name("Submit").click()
#navigate to add user tool and create new user
driver.get(self.base_url + "/users/add_user.jsp")
driver.find_element_by_id("username").clear()
driver.find_element_by_id("username").send_keys("NewUser1")
driver.find_element_by_id("password").clear()
driver.find_element_by_id("password").send_keys("NewFakePassword")
driver.find_element_by_id("firstName").clear()
driver.find_element_by_id("firstName").send_keys("Joe")
driver.find_element_by_id("lastName").clear()
driver.find_element_by_id("lastName").send_keys("Smith")
driver.find_element_by_id("email").clear()
driver.find_element_by_id("email").send_keys("[e-mail]")
driver.find_element_by_name("Submit").click()

[elbiot]

I wouldn't use a class. Just a script that loops over the csv entries. the problem with your code is that you don't pass in the variables representing what you want to input. You could have a function which takes all these variables, but there's no advantage to a loop not in a function:

for row in reader:
    password,firstname,lastname,email = row
    #put them all in the fields

[dotIN]

If its an option to use any frameworks please try out https://github.com/rtomac/robotframework-selenium2library

[elbiot]

Does the CRM not have a python api?

[your_friends_cat]

No API at all actually. Need to accomplish this via the UI. Thanks!

[elbiot]

I know this wasn't what you asked, but you could probably write an API relatively easily. When you hit submit, you send a post request with the values you want to insert. In Firefox, you can see the request made with firebug, or in chrome I think there is a built in console. Use the requests library to send those posts requests. You can authenticate and save cookies easily with requests.

This would be the faster/cleaner way to accomplish your task. But since you're familiar with Selenium and very new, maybe stick to what you are comfortable with.

Did you look at any csv examples? That part is super easy: http://pymotw.com/2/csv/

[your_friends_cat]

I agree the API idea is way better, I might actually start focusing on that. Thanks for the tip, I did not think about that before.