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(