I'm a complete noob at this as I have not done any coding for a while. trying to make my life a little easier by automating a job I'm doing. I've created a script to input "first name" "last name" but it seems to just pulls the last field from my csv . can anyone help!!!
import csv
input = open('C:\Sikuli\jslogic.csv', 'rb')
for row in csv.reader(input):
firstColumnValue = row[0]
secondColumnValue = row[1]
click("1477300865566.png")
wait("1477300892860.png")
click(Pattern("1477300892860.png").targetOffset(-60,-83))
wait(Pattern("1477300993973.png").targetOffset(-6,43))
click(Pattern("1477301019405.png").targetOffset(-107,14))
paste(firstColumnValue)
type(".")
paste(secondColumnValue)
click(Pattern("1477302537861.png").targetOffset(89,27))
click(Pattern("1477302228123.png").similar(0.88).targetOffset(108,54))
click(Pattern("1477301587806.png").targetOffset(-1,-2))
The CSV is just a basic one made in excel just a table denoting first name and last name as follows
First Name Last Name
testy Mctestface
testy1 Mctestface
testy2 Mctestface
testy3 Mctestface
testy4 Mctestface
It Currently pulls from the CSV entering but only uses the last value in the table so in the current table Testy4 mctestface