Skip to content

Instantly share code, notes, and snippets.

@brettclare
Created April 29, 2016 23:43
Show Gist options
  • Save brettclare/5133726dcf57dd2e20269867f4515240 to your computer and use it in GitHub Desktop.
Save brettclare/5133726dcf57dd2e20269867f4515240 to your computer and use it in GitHub Desktop.
Enter file contents hereimport pandas
import webbrowser
import select
from selenium import webdriver
from selenium.webdriver.support.ui import Select
from selenium.webdriver.common import keys
browser = webdriver.Firefox()
type(browser)
data_df=pandas.read_csv('C:\Code\ASN_example.csv',sep=",",header=0,index_col=False)
data_frame1=pandas.DataFrame(data_df.transpose())
print(data_frame1)
#<class 'selenium.webdriver.firefox.webdriver.Webdriver'
browser.get('https://xx.xxxx.com/xxx/xxx/GenEdit.aspx?ID=556&NEW=TRUE&rtrn_sortexpression=&rtrn_pageindex=0&rtrn_pagesize=100&rtrn_ID=666')
username=browser.find_element_by_id('ctl00_ContentPlaceHolder1_UserNameTextBox')
username.send_keys('BClare')
password=browser.find_element_by_id('ctl00_ContentPlaceHolder1_PasswordTextBox')
password.send_keys('Bcbike')
logon=browser.find_element_by_id('ctl00_ContentPlaceHolder1_LogOnButton')
logon.click()
browser.implicitly_wait(10)
i=0
g=0
while g < len(data_frame1.columns):
delivdate=Select(browser.find_element_by_id("ctl00_nonAjaxContentPlaceHolder_use_sysgen_exp_delivery_date"))
browser.implicitly_wait(15)
delivdate.select_by_value(data_frame1.iloc[i,g])
vendor_code=Select(browser.find_element_by_id("ctl00_nonAjaxContentPlaceHolder_vendor_code"))
browser.implicitly_wait(15)
vendor_code.select_by_value(data_frame1.iloc[i+1,g])
browser.implicitly_wait(15)
ship_to=Select(browser.find_element_by_id("ctl00_nonAjaxContentPlaceHolder_ship_to"))
browser.implicitly_wait(15)
ship_to.select_by_value(data_frame1.iloc[i+2,g])
browser.implicitly_wait(15)
ship_date=browser.find_element_by_name ("ctl00$nonAjaxContentPlaceHolder$ctl07$textBox")
ship_date.send_keys(data_frame1.iloc[i+3,g])
browser.implicitly_wait(15)
exp_deliv_date=browser.find_element_by_name ("ctl00$nonAjaxContentPlaceHolder$ctl09$textBox")
exp_deliv_date.send_keys(data_frame1.iloc[i+4,g])
carrier_code=Select(browser.find_element_by_id('ctl00_nonAjaxContentPlaceHolder_carrier_code'))
browser.implicitly_wait(15)
carrier_code.select_by_value(data_frame1.iloc[i+5,g])
trailer_num = browser.find_element_by_id("ctl00_nonAjaxContentPlaceHolder_trailer_number")
browser.implicitly_wait(15)
trailer_num.send_keys(data_frame1.iloc[i+6,g])
pro_number=browser.find_element_by_id("ctl00_nonAjaxContentPlaceHolder_pro_number")
browser.implicitly_wait(15)
pro_number.send_keys(data_frame1.iloc[i+7,g])
comment=browser.find_element_by_name("ctl00$nonAjaxContentPlaceHolder$ctl13")
browser.implicitly_wait(15)
comment.send_keys(data_frame1.iloc[i+8,g])
weight = browser.find_element_by_id("ctl00_nonAjaxContentPlaceHolder_weight")
browser.implicitly_wait(15)
weight.send_keys(data_frame1.iloc[i+9,g])
carton = browser.find_element_by_id("ctl00_nonAjaxContentPlaceHolder_carton_count")
browser.implicitly_wait(15)
carton.send_keys(data_frame1.iloc[i+10,g])
asn = browser.find_element_by_id("ctl00_nonAjaxContentPlaceHolder_manhattan_asn_number")
browser.implicitly_wait(15)
asn.send_keys(data_frame1.iloc[i+11,g])
okbutton=browser.find_element_by_id("ctl00_nonAjaxContentPlaceHolder_InsertButton").click()
browser.implicitly_wait(15)
g = g + 1
browser.get('https://xx.xx.com/xx/xx/GenEdit.aspx?ID=556&NEW=TRUE&rtrn_sortexpression=&rtrn_pageindex=0&rtrn_pagesize=100&rtrn_ID=666')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment