clone_name.send_keys(new_name) clone_description = browser.find_element_by_xpath('/html/body/form/div[7]/div[2]/div/table/tbody/tr[3]/td[2]/input') clone_description.clear() clone_description.send_keys(new_name) save_clone_update = browser.find_element_by_xpath('/html/body/form/div[7]/div[2]/div/table/tbody/tr[5]/td[2]/input') save_clone_update.click() target_item_list = 'target_clone.csv' col_names = ['clone_name'] data = pandas.read_csv(target_item_list, names=col_names) clone_name = data.clone_name.tolist() browser.implicitly_wait(60) login(bot1, password) set_site('Global Site Code') counter = len(clone_name) x = 0 while x <= counter: main_to_target = 'TEST_CABL_FSI_Monthly Cooler v2 by Aisle MAIN' clone_to_target = 'TEST_CABL_FSI_Monthly Cooler v2 by Aisle MAIN Clone' try: x += 1 print('{} of {}'.format(x, counter)) time.sleep(1) find_main(main_to_target) time.sleep(1) clone_main() time.sleep(1)
fsi_target_sch = 'FSI-Quarterly Consolidated' monthly_site_code = monthly_fsi_site fsi_monthly_start = monthly_fsi_start fsi_monthly_name = '{} {}'.format(monthly_site_code, fsi_target_sch) fsi_location = '{}-BLDA'.format(monthly_site_code) daily_frequency = monthly_frequency fsi_page_one(fsi_monthly_name, fsi_monthly_start, sch_on_comp_flag=0) fsi_page_two(fsi_location, set=1) fsi_page_three(fsi_monthly_name, fsi_monthly_start, daily_frequency, day_dropdown='Monthly', set=0, week_day=3) fsi_page_four(fsi_target_sch) print('{} Created'.format) mw_sites = [] browser.implicitly_wait(30) login(bot1, password) target_site_code = mw_sites[10] target_start_daily = '09072020' target_start_weekly = '09062020' target_start_monthly = '09072020' set_site(target_site_code) browser.get('https://sysco.sprocketcmms.com/Default.aspx?screen=PM%20Projects&SSF=244') create_fsi_daily(target_site_code, target_start_daily) create_fsi_weekly(target_site_code, target_start_weekly) create_fsi_monthly(target_site_code, target_start_monthly, monthly_frequency=1) # Quarterly variant of Monthly create_fsi_monthly(target_site_code, target_start_monthly, monthly_frequency=3)
from spBot_Core.BotLogin import set_site, login, browser from spBot_Core.secrets import bot1, bot2, bot3, bot4, bot5, bot6, password from selenium.webdriver.support.select import Select login(bot1, password) browser.implicitly_wait(30) target_file = 'docs_to_load.csv' col_names = ['unit', 'target_site', "target_url"] data = pandas.read_csv(target_file, names=col_names) unit = data.unit.tolist() target_site = data.target_site.tolist() target_url = data.target_url.tolist() counter = len(unit) x = 0 while x <= counter: try: x += 1 set_site(target_site[x]) target_inspection = \ 'https://sysco.sprocketcmms.com/Default.aspx?screen=Perform%20Inspection&ID=43575&InstanceName=43575' browser.get(target_inspection) question_equipment_id = browser.find_element_by_id('question_4880706') question_equipment_id.send_keys(unit[x]) except: break
time.sleep(1) def correct_device_id(new_value, old_value): device_id_field = browser.find_element_by_id( 'StdSf45_DeviceIdentifier_txt') device_id_field.clear() device_id_field.send_keys(new_value) save_record = browser.find_element_by_id('liSave') save_record.click() time.sleep(1) print('{} updated to {}'.format(old_value, new_value)) counter = len(old) x = 0 login(bot2, password) set_site(target_site[1]) while x <= counter: try: x += 1 device_search(old[x]) correct_device_id(new[x], old[x]) except IndexError: print('Device IDs corrected\nScript Complete') break except Exception as b: print('Error\n----> Moving to Next') continue browser.quit()
import requests import lxml import re from bs4 import BeautifulSoup import time from spBot_Core.BotLogin import set_site, login, browser from spBot_Core.secrets import bot1, bot2, bot3, bot4, bot5, bot6, password login(bot2, password) set_site('102') page = browser.get( 'https://sysco.sprocketcmms.com/Default.aspx?screen=New%20Equipment&InstanceName=203069' ) war_tab = browser.find_element_by_id('liWarranty') war_tab.click() time.sleep(3) html = browser.page_source soup = BeautifulSoup(html, 'lxml') #war = soup.tbody.td.find_all_next(string=True) war = soup.find(id='divWarranties') #war_anchor = soup.find_all('tr', {'class': re.compile('evenRow')}) for i in war: children = i.findChildren('a', recursive=True) for child in children: info = child.text print(info) #print(war)
import time target_file = 'targets_to_archive.csv' col_names = ['unit', 'target_site'] data = pandas.read_csv(target_file, names=col_names) # Store entries in list for variables unit = data.unit.tolist() target_site = data.target_site.tolist() login(bot1, password) counter = len(unit) browser.implicitly_wait(30) x = 0 set_site(target_site[x + 1]) sch_type = 1 ## 0 = Equipment Based while x <= counter: try: x += 1 if sch_type == 0: browser.get( 'https://sysco.sprocketcmms.com/Default.aspx?screen=PM%20Projects&SSF=-108' ) else: browser.get( 'https://sysco.sprocketcmms.com/Default.aspx?screen=PM%20Projects&SSF=244' ) search_trigger = browser.find_element_by_id('liSearch').click() search_box = browser.find_element_by_id('PMNumber_txt3')
unit = data.unit.tolist() year = data.year.tolist() model_flag = data.model_flag.tolist() engine_flag = data.engine_flag.tolist() transmission_flag = data.transmission_flag.tolist() axle_flag = data.axle_flag.tolist() alternator_flag = data.alternator_flag.tolist() login(bot1, password) counter = len(unit) x = 0 while x <= counter: try: # Main Loop Control x += 1 set_site(site[x]) equipment_page(unit[x]) # Dynamic Warranties try: year_var = year[x] target_war1 = '{} {}'.format( year_var, international_warranty_model[int(model_flag[x])]) target_war2 = '{} {}'.format( year_var, international_warranty_engine[int(engine_flag[x])]) target_war3 = '{} {}'.format( year_var, international_warranty_transmission[int(transmission_flag[x])]) target_war4 = '{} {}'.format( year_var, international_warranty_axle[int(axle_flag[x])]) target_war5 = '{} {}'.format(
equip_type = data.equip_type.tolist() equip_sys = data.equip_sys.tolist() department = data.department.tolist() gb_fuel_type = data.gb_fuel_type.tolist() make = data.make.tolist() model = data.model.tolist() unit_descrip = data.unit_descrip.tolist() vin_serial = data.vin_serial.tolist() start_date = data.start_date.tolist() status = data.status.tolist() location = data.location.tolist() site_code = data.site_code.tolist() const_year = data.const_year.tolist() browser.get('https://sysco.sprocketcmms.com/Default.aspx?screen=Equipment') set_site(site_code[1]) counter = len(target_number) x = 0 while x <= counter: try: x = x + 1 browser.get( 'https://sysco.sprocketcmms.com/Default.aspx?screen=Equipment') time.sleep(1) new_equip_button = browser.find_element_by_id('btnNewLink') new_equip_button.click() # Populate Form field_id = browser.find_element_by_id(