pass_ASN_example_w_Selenium-6.py

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')