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)
driver.find_element_by_id("navprofile").click()
time.sleep(1)
driver.find_element_by_xpath("//span[text()='Cerrar sesión']").click()
driver.find_element_by_id("login-form_email").send_keys(
'*****@*****.**')
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(
r - 2) #####################################################
print(msg)
flag = 0
company_name = xlc.readdata(path, 'provider-create', r, 1)
permiso = xlc.readdata(path, 'provider-create', r, 2)
t_proveedor = xlc.readdata(path, 'provider-create', r, 3)
operador = xlc.readdata(path, 'provider-create', r, 4)
descripcion = xlc.readdata(path, 'provider-create', r, 5)
local_pais = xlc.readdata(path, 'provider-create', r, 6)
local_estado = xlc.readdata(path, 'provider-create', r, 7)
local_ciudad = xlc.readdata(path, 'provider-create', r, 8)
cod_postal = xlc.readdata(path, 'provider-create', r, 9)
direccion = xlc.readdata(path, 'provider-create', r, 10)
cobertura_pais = xlc.readdata(path, 'provider-create', r, 11)
cobertuda_estado = xlc.readdata(path, 'provider-create', r, 12)
contact_nombre = xlc.readdata(path, 'provider-create', r, 13)
contact_apellido = xlc.readdata(path, 'provider-create', r, 14)
contact_mobile = xlc.readdata(path, 'provider-create', r, 15)
contact_correo = xlc.readdata(path, 'provider-create', r, 16)
driver.maximize_window()
rows=xlc.getrowcount(path,'tourop-create')
print(driver.title)
#Test date---
today = date.today()
d1 = today.strftime("%d/%m/%Y")
#Create tour operator---
msg="not created"
for r in range(3,rows+1):
driver.find_element_by_xpath("//a[@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)
local_ciudad=xlc.readdata(path, 'tourop-create', r, 6)
cod_postal=xlc.readdata(path, 'tourop-create', r, 7)
direccion=xlc.readdata(path, 'tourop-create', r, 8)
cobertura_pais=xlc.readdata(path, 'tourop-create', r, 9)
cobertuda_estado=xlc.readdata(path, 'tourop-create', r, 10)
contact_nombre=xlc.readdata(path, 'tourop-create', r, 11)
contact_apellido=xlc.readdata(path, 'tourop-create', r, 12)
contact_correo=xlc.readdata(path, 'tourop-create', r, 13)
contact_mobile=xlc.readdata(path, 'tourop-create', r, 14)
mainuser_nombre=xlc.readdata(path, 'tourop-create', r, 15)
mainuser_apellido=xlc.readdata(path, 'tourop-create', r, 16)
msg = "not logged"
driver.find_element_by_id("login-form_email").send_keys(
'*****@*****.**')
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) #####################################################
print(msg)
flag = 0
nombre = xlc.readdata(path, 'poi-create', r, 1)
mostrar = xlc.readdata(path, 'poi-create', r, 2)
categoria = xlc.readdata(path, 'poi-create', r, 3)
sinopsis = xlc.readdata(path, 'poi-create', r, 4)
descripcion = xlc.readdata(path, 'poi-create', r, 5)
pais = xlc.readdata(path, 'poi-create', r, 6)
ciudad = xlc.readdata(path, 'poi-create', r, 7)
direccion = xlc.readdata(path, 'poi-create', r, 8)
lat = xlc.readdata(path, 'poi-create', r, 9)
lon = xlc.readdata(path, 'poi-create', r,
10) # string "0,1,2,3,4,5,6,7"
c_tips = xlc.readdata(path, 'poi-create', r, 11)
t_titulo = xlc.readdata(path, 'poi-create', r, 12)
t_mensaje = xlc.readdata(path, 'poi-create', r, 13)
t_tipo = xlc.readdata(path, 'poi-create', r, 14)
t_notif = xlc.readdata(path, 'poi-create', r, 15)
msg = "not logged"
driver.find_element_by_id("login-form_email").send_keys(
'*****@*****.**')
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) #####################################################
print(msg)
flag = 0
nombre = xlc.readdata(path, 'accomm-create', r, 1)
proveedor = xlc.readdata(path, 'accomm-create', r, 2)
nummax = xlc.readdata(path, 'accomm-create', r, 3)
moneda = xlc.readdata(path, 'accomm-create', r, 4)
costo = xlc.readdata(path, 'accomm-create', r, 5)
sinopsis = xlc.readdata(path, 'accomm-create', r, 6)
descripcion = xlc.readdata(path, 'accomm-create', r, 7)
f_inic = xlc.readdata(path, 'accomm-create', r, 8)
f_final = xlc.readdata(path, 'accomm-create', r, 9)
checkbox = xlc.readdata(path, 'accomm-create', r,
10) #string "0,1,2,3,4,5,6,7"
h_inic = xlc.readdata(path, 'accomm-create', r, 11)
h_final = xlc.readdata(path, 'accomm-create', r, 12)
pais = xlc.readdata(path, 'accomm-create', r, 13)
ciudad = xlc.readdata(path, 'accomm-create', r, 14)
direccion = xlc.readdata(path, 'accomm-create', r, 15)
today = date.today()
d1 = today.strftime("%d/%m/%Y")
#LOG IN---
msg="not logged"
driver.find_element_by_id("login-form_email").send_keys('*****@*****.**')
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)
apellido = xlc.readdata(path, 'admin-create', r, 2)
permiso = xlc.readdata(path, 'admin-create', r, 3)
proveedor = xlc.readdata(path, 'admin-create', r, 4)
correo = xlc.readdata(path, 'admin-create', r, 5)
password = xlc.readdata(path, 'admin-create', r, 6)
confirm_pass = xlc.readdata(path, 'admin-create', r, 7)
mobile = xlc.readdata(path, 'admin-create', r, 8)
# ingresar al formulario
#driver.find_element_by_id("rc-tabs-0-tab-2").click()
driver.find_element_by_xpath("//div[text()='Usuarios']").click()
time.sleep(3)
driver.find_element_by_xpath("(//button[text()=' Agregar'])[2]").click()
time.sleep(3)
print("ingreso al formulario")
msg = "Inform. Basica"