import time
import os
import excelfunctions as xlc
from datetime import date
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
path = os.path.abspath("datatest.xlsx")
driver = xlc.start_webdriver()
driver.get("http://*****:*****@type='submit']").click()
time.sleep(3)
#print(driver.find_element_by_id('myteam').is_displayed())
try:
if (driver.find_element_by_id('myteam').is_displayed() == True):
print("success")
xlc.writedata(path, 'login', r, 3, 'success')
xlc.writedata(path, 'login', r, 4, "")
xlc.writedata(path, 'login', r, 5, d1)
import time
import os
import excelfunctions as xlc
from datetime import date
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
path = os.path.abspath("datatest.xlsx")
driver = xlc.start_webdriver()
driver.get("http://*****:*****@eulerinnovations.com')
driver.find_element_by_id("login-form_password").send_keys('eulerinnovations')
driver.find_element_by_xpath("//button[@type='submit']").click()
time.sleep(5)
print("logged!!")
#Create provider---
for r in range(3, rows + 1):
driver.find_element_by_xpath("//button[text()=' Agregar']").click()
time.sleep(3)
try:
msg = "FORMULARIO NUMERO: " + str(
import time
import os
import excelfunctions as xlc
from datetime import date
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
path = os.path.abspath("datatest.xlsx")
driver = xlc.start_webdriver()
driver.get("http://*****:*****@href='/auth/register-3']").click()
time.sleep(1)
try:
msg = "FORMULARIO NUMERO: " + str(r - 2) #####################################################
print(msg)
flag=0
company_name=xlc.readdata(path, 'tourop-create', r, 1)
company_mobile=xlc.readdata(path, 'tourop-create', r, 2)
descripcion=xlc.readdata(path, 'tourop-create', r, 3)
local_pais=xlc.readdata(path, 'tourop-create', r, 4)
local_estado=xlc.readdata(path, 'tourop-create', r, 5)
import time
import os
import excelfunctions as xlc
from datetime import date
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
path = os.path.abspath("datatest.xlsx")
driver = xlc.start_webdriver()
driver.get("http://*****:*****@eulerinnovations.com')
driver.find_element_by_id("login-form_password").send_keys('eulerinnovations')
driver.find_element_by_xpath("//button[@type='submit']").click()
time.sleep(5)
print("logged!!")
driver.find_element_by_id("Places of interest").click()
#inicia el bucle
for r in range(3, rows + 1):
try:
msg = "FORMULARIO NUMERO: " + str(
r - 2) #####################################################
import time
import os
import excelfunctions as xlc
from datetime import date
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
path = os.path.abspath("datatest.xlsx")
driver = xlc.start_webdriver()
driver.get("http://*****:*****@eulerinnovations.com')
driver.find_element_by_id("login-form_password").send_keys('eulerinnovations')
driver.find_element_by_xpath("//button[@type='submit']").click()
time.sleep(5)
print("logged!!")
driver.find_element_by_id("Services").click()
#inicia el bucle
for r in range(3, rows + 1):
try:
msg = "FORMULARIO NUMERO: " + str(
r - 2) #####################################################
import time
import os
import excelfunctions as xlc
from datetime import date
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
path = os.path.abspath("datatest.xlsx")
driver = xlc.start_webdriver()
driver.get("http://*****:*****@eulerinnovations.com')
driver.find_element_by_id("login-form_password").send_keys('eulerinnovations')
driver.find_element_by_xpath("//button[@type='submit']").click()
time.sleep(5)
print("logged!!")
#inicia el bucle
for r in range(3,rows+1):
try:
msg = "FORMULARIO NUMERO: " + str(r - 2) #####################################################
print(msg)
flag = 0
nombre = xlc.readdata(path, 'admin-create', r, 1)