val_businesstriporder = row[1]['Business trip order']
val_purchaseorder = row[1]['Purchase order']
val_cct = row[1]['CCT']
val_emp = row[1]['EMP']
val_dpt = row[1]['DPT']
val_projectcode = row[1]['Project Code']
val_email = row[1]['e-mail Заказчика']
val_tst = row[1]['TST']
if val_customer == 'Client L': cubeSelect = 'clientl'
if val_customer == 'Client P': continue
if val_customer == 'Client C': continue
if val_customer == 'Client D': continue
#----------------------------------------
id_airline = id.detectid('Airline', 'Airline_name', val_airline, cursor,
connection)
id_class = id.detectid('Class', 'Class_name', val_class, cursor,
connection)
id_destination = id.detectid('Destination', 'Destination_name', val_dest,
cursor, connection)
id_region = id.detectid('Region', 'Region_name', val_region, cursor,
connection)
id_route = id.detectid('Route', 'Route_name', val_route, cursor,
connection)
id_state = id.detectid('State', 'State_name', val_state, cursor,
connection)
val_businesstriporder = row[1]['Business trip order']
val_purchaseorder = row[1]['Purchase order']
val_cct = row[1]['CCT']
val_emp = row[1]['EMP']
val_dpt = row[1]['DPT']
val_projectcode = row[1]['Project Code']
val_email = row[1]['e-mail Заказчика']
val_tst = row[1]['TST']
if val_customer == 'Client L': continue
if val_customer == 'Client P': cubeSelect = 'clientp'
if val_customer == 'Client C': continue
if val_customer == 'Client D': continue
#----------------------------------------
id_airline = id.detectid('Airline', 'Airline_name', val_airline, cursor,
connection)
id_class = id.detectid('Class', 'Class_name', val_class, cursor,
connection)
id_destination = id.detectid('Destination', 'Destination_name', val_dest,
cursor, connection)
id_region = id.detectid('Region', 'Region_name', val_region, cursor,
connection)
id_route = id.detectid('Route', 'Route_name', val_route, cursor,
connection)
id_state = id.detectid('State', 'State_name', val_state, cursor,
connection)
val_personalid = row[1]['Personal ID']
val_msp = row[1]['MSP']
val_departmentcode = row[1]['DEPARTMENT CODE']
val_purposeofthetrip = row[1]['Purpose of the trip']
val_apn = row[1]['APN']
val_businesstriporder = row[1]['Business trip order']
val_purchaseorder = row[1]['Purchase order']
val_cct = row[1]['CCT']
val_emp = row[1]['EMP']
val_dpt = row[1]['DPT']
val_projectcode = row[1]['Project Code']
val_email = row[1]['e-mail Заказчика']
val_tst = row[1]['TST']
#----------------------------------------
id_airline = id.detectid('Airline', 'Airline_name', val_airline, cursor,
connection)
id_class = id.detectid('Class', 'Class_name', val_class, cursor,
connection)
id_customer = id.detectid('Customer', 'Customer_name', val_customer,
cursor, connection)
id_destination = id.detectid('Destination', 'Destination_name', val_dest,
cursor, connection)
id_region = id.detectid('Region', 'Region_name', val_region, cursor,
connection)
id_route = id.detectid('Route', 'Route_name', val_route, cursor,
connection)