def addMember(self, rowNum): row = getInfoOnRow(rowNum) fn = str(row[0]) ln = str(row[1]) em = str(row[2]) print 'STARTING, this row is', rowNum print 'adding :', fn, ln print 'and email :', em time.sleep(.5) #fill in form #first name click(*geo_fn) time.sleep(.7) addToCB(fn) addToCB(fn) SendKeys('^v') #SendKeys(fn, pause=0) time.sleep(.2) #last name click(*geo_ln) addToCB(ln) SendKeys('^v') #SendKeys(ln, pause=0) time.sleep(.2) #click email click(*geo_em) addToCB(em) SendKeys('^v') #SendKeys(em, pause=0) time.sleep(.2) #click list click(*geo_sub) SendKeys('members')
from SendKeys import SendKeys from win32clipboard import GetClipboardData, SetClipboardText, \ EmptyClipboard, OpenClipboard, \ CloseClipboard from josh_new_user_account1 import click import time #copy link to moneris to CB OpenClipboard() EmptyClipboard() url = r'https://www3.moneris.com/mpg/index.php' SetClipboardText(url) CloseClipboard() time.sleep(3) username = r'oshfadmin' store_id = r'monca02268' password = r'oshfadmin6' un_pos = (291, 621) sid_pos = (274, 636) pas_pos = (279, 661) pairs = [(username, un_pos), (store_id, sid_pos), (password, pas_pos)] for string, pos in pairs: click(*pos) SendKeys(string, pause=0)
def next(self): excel = Dispatch('Excel.Application') excel.visible = 0 excel.Workbooks.Open(root_ent_filepath_curpath.get()) def getInfoOnRow(row): first_name = excel.ActiveSheet.Cells(row,1).value last_name = excel.ActiveSheet.Cells(row,2).value postal_code = excel.ActiveSheet.Cells(row,3).value email = excel.ActiveSheet.Cells(row,4).value return [first_name,last_name,postal_code, email] row = int(root_ent_set_row.get()) info = getInfoOnRow(row) #print info #takes their first last and email first_name= str(info[0]) last_name= str(info[1]) email_address= str(info[3]) #username first_letter= first_name[0].lower() last_lower= last_name.lower() username= '******'.format(first_letter,last_lower) #password pwd_lower= str(info[2]).lower() pwd_split= pwd_lower.split(' ') password= ''.join(pwd_split) #change entries #first self.ent_fn.delete(0, tk.END) self.ent_fn.insert(0, first_name) #last self.ent_ln.delete(0, tk.END) self.ent_ln.insert(0, last_name) #email self.ent_em.delete(0, tk.END) self.ent_em.insert(0, email_address) #username self.ent_un.delete(0, tk.END) self.ent_un.insert(0, username) #password self.ent_pw.delete(0, tk.END) self.ent_pw.insert(0, password) #increment row by 1 root_ent_set_row.delete(0, tk.END) root_ent_set_row.insert(0, row+1) print 'done next' #create url self.template = 'http://www.oshf.ca/admin/ManageSecureMembers.asp'\ '?formAction=&RecordPerPage=&message=CONFIRM+AND'\ ';+HIT+SUBMIT+AT+BOTTOM&msg=&firstName={first}&LastName={last}&email'\ '={email}&username={user}&password={pwd}&strRefreshFormAction'\ '=InsertSecureMembers&intSecureMemberId=&secureSectionId=444&'\ 'strRefreshSendEmail=1&emailMatch=1'.format( first=first_name, last=last_name, email=email_address, user=username, pwd=password) print first_name, last_name, email_address, username, password print self.template #put url in address bar wcb.OpenClipboard() wcb.EmptyClipboard() wcb.SetClipboardData(win32con.CF_TEXT, str(self.template)) wcb.CloseClipboard() click(335, 39) SendKeys('^a{DELETE}', pause=0.5) SendKeys('^v{ENTER}')
def loopOverEmails(i): cont = True ##alt tab over SendKeys.SendKeys('%{TAB}') while cont: row = getInfoOnRow(i) fn = str(row[0]) ln = str(row[1]) em = str(row[2]) print 'STARTING, this row is', i print 'look for:', fn, ln print 'and fix email to:', em ##fill in search form #first name click(*POS.SR_f) SendKeys.SendKeys(fn) #last name click(*POS.SR_l) SendKeys.SendKeys(ln) #click search click(*POS.SR_search) sleep(4) ##modify the entry #click entry click(*POS.DM_entry1) #click email click(*POS.DM_em) #ctrl a SendKeys.SendKeys('^a') #type new email SendKeys.SendKeys(em, pause=0) wcb.OpenClipboard() wcb.EmptyClipboard() wcb.SetClipboardText(str(em).strip()) wcb.CloseClipboard() resp = raw_input('Continue, y or n?') proper = False while not proper: if str(resp) == 'n': cont = False proper = True elif str(resp) == 'y': i += 1 print 'continue, next row is', i print 'look for:', fn, ln print 'new email is:', em proper = True cont = True ##alt tab over SendKeys.SendKeys('%{TAB}') click(*POS.DM_mod) click(*POS.DM_again) sleep(2) else: resp = raw_input('Continue, y or n?')
def loopOverMemstoAdd(rowNum): cont = True #alt tab #SendKeys('%{TAB}') while cont: row = getInfoOnRow(rowNum) fn = str(row[0]) ln = str(row[1]) em = str(row[2]) print 'STARTING, this row is', rowNum print 'adding :', fn, ln print 'and email :', em #fill in form #first name click(*geo_fn) SendKeys(fn, pause=0) #last name click(*geo_ln) SendKeys(ln, pause=0) #click email click(*geo_em) SendKeys(em, pause=0) #click list click(*geo_sub) SendKeys('members') #move mouse to add button win32api.SetCursorPos(geo_add) #confirm info resp = raw_input('If the confirmation is correct\n'\ 'and the add button as been clicked'\ 'continue, y or n?') #confirm answer is a y or a n proper = False while not proper: if str(resp) == 'n': cont = False proper = True elif str(resp) == 'y': rowNum += 1 print 'STARTING, this row is', rowNum print 'adding :', fn, ln print 'and email :', em proper = True cont = True ##alt tab over SendKeys('%{TAB}') #click(*POS.DM_mod) #click(*POS.DM_again) #sleep(2) else: resp = raw_input('Continue, y or n?')
def createURL(row): #gets the info on row X from the excel sheet excel = Dispatch('Excel.Application') excel.visible = 0 excel.Workbooks.Open('C:/josh.xls') def getInfoOnRow(row): first_name = excel.ActiveSheet.Cells(row,1).value last_name = excel.ActiveSheet.Cells(row,2).value postal_code = excel.ActiveSheet.Cells(row,3).value email = excel.ActiveSheet.Cells(row,4).value return [first_name,last_name,postal_code, email] info=getInfoOnRow(row) pp(info) #takes their first last and email first_name= str(info[0]) last_name= str(info[1]) email_address= str(info[3]) #username first_letter= first_name[0].lower() last_lower= last_name.lower() username= '******'.format(first_letter,last_lower) #password pwd_lower= str(info[2]).lower() pwd_split= pwd_lower.split(' ') password= ''.join(pwd_split) template= 'http://www.oshf.ca/admin/ManageSecureMembers.asp'\ '?formAction=&RecordPerPage=&message=SCRIPT'\ ';+HIT+SUBMIT+AT+BOTTOM&msg=&firstName={first}&LastName={last}&email'\ '={email}&username={user}&password={pwd}&strRefreshFormAction'\ '=InsertSecureMembers&intSecureMemberId=&secureSectionId=444&'\ 'strRefreshSendEmail=1&emailMatch=1'.format( first=first_name, last=last_name, email=email_address, user=username, pwd=password) print template ##note not working, IDK why wcb.OpenClipboard() wcb.EmptyClipboard() wcb.SetClipboardData(win32con.CF_TEXT, str(template)) wcb.CloseClipboard() #alt tab SendKeys('%{TAB}') #TRPL Click click(707,45) #click(707,45) #click(707,45) #ctrl A SendKeys('^v')