SELECT id, descripcion, empresa,parametro1,parametro2,logbook,endpoint,utc, usuario, password, apikey, vigente FROM procesos where vigente=1  and descripcion like '%(TrackTec)%'  <br>Integracion Escondida (TrackTec) transportes-UbP<br><br><br>https://csv.webfleet.com/extern?lang=en&account=transportes-UbP&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=showVehicleReportExtern&outputformat=json&useUTF8=true&freetext=Leipzig<br>insert into integracion_tracktec_vehiculos (nro,numero, nombre,patente, empresa) values ('1-838083-299F841037','044','PDWG85',upper('PDWG85'),'transportes-UbP') <br>Excepción capturada: Duplicate entry '1-838083-299F841037' for key 'PRIMARY'
[{"objectno":"044","objectname":"PDWG85","licenseplatenumber":"PDWG85","vehicletype":"heavytruck_us","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":90,"description":"Corregido.","objectuid":"1-838083-299F841037","obu_btaddress":"E8:B4:70:37:3A:2C","fuelreference":0,"accelerationvehicletype":"heavy_weight"},{"objectno":"045","objectname":"RKLF-71 ","licenseplatenumber":"RKLF-71 ","vehicletype":"heavy_truck","vh_avgfuelusage":35000,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":90,"objectuid":"1-838083-6660751397","fueltanksize":580,"obu_btaddress":"E4:04:39:56:AB:FB","fuelreference":1,"accelerationvehicletype":"heavy_weight"},{"objectno":"046","objectname":"LZRG-76","licenseplatenumber":"LZRG-76","vehicletype":"dump_truck","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":90,"objectuid":"1-838083-46607411CE","obu_btaddress":"E4:04:39:9C:60:03","fuelreference":0,"accelerationvehicletype":"heavy_weight"},{"objectno":"043","objectname":"PDWG89","licenseplatenumber":"PDWG89","vehicletype":"trailer","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":90,"description":"Corregido Patente PDWG89.","objectuid":"1-838083-050317616F","obu_btaddress":"E4:04:39:72:62:7C","fuelreference":0,"accelerationvehicletype":"heavy_weight"}]<br>https://csv.webfleet.com/extern?lang=en&account=transportes-UbP&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=showDriverReportExtern&outputformat=json&useUTF8=true&freetext=Leipzig<br>insert into integracion_tracktec_conductores (id,conductor, nombre, empresa,rut,tarjeta) values ('1-838083-4637384C3D8','12441657-4','mauricio peralta','transportes-UbP','2620','24C11F2E') <br>Excepción capturada: Duplicate entry '1-838083-4637384C3D8' for key 'PRIMARY'
[{"driverno":"12441657-4","name1":"mauricio peralta","state":"CL","telmobile":"+56996584870","email":"camiones@transportesfox.cl","description":"2620","company":"camiones ","objectno":"046","signontime":"31/08/2026 17:42:21","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":false,"objectuid":"1-838083-46607411CE","driveruid":"1-838083-4637384C3D8","driver_keys":[{"driver_key_type":2,"driver_key_value":"24C11F2E"}]},{"driverno":"12616672-9","name1":"luis rojas ","telmobile":"+56995922143","description":"2619 . 240B24A2","company":"camiones ","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-663732C7597","driver_keys":[{"driver_key_type":2,"driver_key_value":"0000012BD1C7"}]},{"driverno":"15010627-3","name1":"andres  Gonzalez ","telmobile":"+56940070103","company":"camiones ","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-95C4DB2F515","driver_keys":[{"driver_key_type":2,"driver_key_value":"345116A2"}]},{"driverno":"17974655-7","name1":"Michael Araya","telmobile":"+56936736020","email":"michel@transportesfox.cl","company":"MEL","current_workstate":4,"dt_cardid":"","current_workingtimestart":"26/04/2025 12:25:21","current_workingtimeend":"26/04/2025 12:25:21","pin":"3217","driveruid":"1-838083-66374212505","driver_keys":[{"driver_key_type":2,"driver_key_value":"143251A2"}]},{"driverno":"18125115-8","name1":"francisco cabrera ","telmobile":"+56962303936","email":"camiones@transportesfox.cl","description":"2621","company":"camiones ","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-29C8C84E431","driver_keys":[{"driver_key_type":2,"driver_key_value":"24A7522E"}]},{"driverno":"24032878-k","name1":"Roberto valencia ","telmobile":"+56961780152","email":"camiones@transportesfox.cl","description":"2615","company":"Camiones","current_workstate":4,"dt_cardid":"","current_workingtimestart":"24/07/2026 10:01:48","current_workingtimeend":"29/07/2026 11:17:54","current_workingtime":"PT433421S","driveruid":"1-838083-663732C756A","driver_keys":[{"driver_key_type":2,"driver_key_value":"24E7F52E"}]}]https://csv.webfleet.com/extern?lang=en&account=transportes-UbP&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=popQueueMessagesExtern&msgclass=0&outputformat=json&useUTF8=true&freetext=Leipzig<br>mensaje:[]<br><br>Vacio<br>https://csv.webfleet.com/extern?lang=en&account=transportes-UbP&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=ackQueueMessagesExtern&msgclass=0&outputformat=json&useUTF8=true&freetext=Leipzig<br><br>$data[0][action]=ackQueueMessagesExtern<br>$data[0][result]=1<br>$data[0][acknowledgedMessages]=0<br>$data[0][outstandingMessages]=0<br><br><br>************************ los apagados ******************<br>OK.<br><br>Integracion Escondida (TrackTec) construccion-montajes<br><br><br>https://csv.webfleet.com/extern?lang=en&account=construccion-montajes&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=showVehicleReportExtern&outputformat=json&useUTF8=true&freetext=Leipzig<br>insert into integracion_tracktec_vehiculos (nro,numero, nombre,patente, empresa) values ('1-838083-9590C12673','001','BUS MERCEDES BENZ 0500RS LPHG-',upper('LPHG85'),'construccion-montajes') <br>Excepción capturada: Duplicate entry '1-838083-9590C12673' for key 'PRIMARY'
[{"objectno":"001","objectname":"BUS MERCEDES BENZ 0500RS LPHG-","licenseplatenumber":"LPHG-85","vehicletype":"bus","identnumber":"85","registrationdate":"2020-05-19","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"blue","speedlimit":100,"objectuid":"1-838083-9590C12673","fueltanksize":1,"obu_btaddress":"E4:04:39:72:6C:BB","fuelreference":0,"accelerationvehicletype":"heavy_weight"},{"objectno":"020","objectname":"CAMION PLUMA VOLVO LXHZ-25","licenseplatenumber":"LXHZ-25","identnumber":"25","registrationdate":"2020-05-20","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-196C066343","obu_btaddress":"E4:04:39:E1:EE:EF","fuelreference":0},{"objectno":"033","objectname":"CAMION PAÑOL VOLKSWAGEN RVWK-8","licenseplatenumber":"RVWK-85","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-32343F6FE2","fueltanksize":230,"obu_btaddress":"E8:B4:70:32:A0:DA","fuelreference":2,"accelerationvehicletype":"medium_weight"},{"objectno":"036","objectname":"SVZT92 CAMIONETA TSS BHP SPENC","licenseplatenumber":"SVZT92","vehicletype":"pickup","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-4660526C59","obu_btaddress":"E8:B4:70:33:FD:AC","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"035","objectname":"SVZT93 CAMIONETA TSS BHP SPENCE","licenseplatenumber":"SVZT93","vehicletype":"pickup","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-3234055E72","obu_btaddress":"E8:B4:70:33:FD:B6","fuelreference":2,"accelerationvehicletype":"light_weight"}]<br>https://csv.webfleet.com/extern?lang=en&account=construccion-montajes&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=showDriverReportExtern&outputformat=json&useUTF8=true&freetext=Leipzig<br>insert into integracion_tracktec_conductores (id,conductor, nombre, empresa,rut,tarjeta) values ('1-838083-95CDC04547','1','Conductor Prueba 1','construccion-montajes','','') <br>Excepción capturada: Duplicate entry '1-838083-95CDC04547' for key 'PRIMARY'
[{"driverno":"1","name1":"Conductor Prueba 1","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-95CDC04547"},{"driverno":"11","name1":"Igor Sepulveda","state":"CL","company":"ESR/SERVICIOS","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-326A6F0514"},{"driverno":"12","name1":"Conductor ´Prueba 12","objectno":"012","signontime":"03/01/2019 17:03:06","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-9590C10E35","driveruid":"1-838083-463E38373F"},{"driverno":"13","name1":"EDUARDO LOPEZ","company":"ESR SPENCE BHP","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-29C1C83543","driver_keys":[{"driver_key_type":2,"driver_key_value":"248E082E"}]},{"driverno":"16","name1":"Pablo Jimenez","state":"CL","city":"Rancagua","company":"ESR/FLOTA","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-88504327EA"},{"driverno":"17","name1":"Daniel Pavez","state":"CL","city":"Rancagua","company":"ESR/FLOTA","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-95CDD825B7"},{"driverno":"19","name1":"JAVIER DROGUETT","company":"ESR SPENCE BHP","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-29C1D055A0"},{"driverno":"2","name1":"Conductor Prueba 2","objectno":"70","signontime":"03/01/2019 17:04:36","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-05005A273E","driveruid":"1-838083-055D5B4402"},{"driverno":"20","name1":"PAUL LORCA","state":"CL","email":"imunoz@esrservicios.cl","company":"ESR/FLOTA","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-463E2057D0"},{"driverno":"21","name1":"JUAN PABLO REYES","company":"ESR SPENCE BHP","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-535B4270DF"},{"driverno":"22","name1":"Victor Iturriaga","company":"ESR/PREVENCION","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-8850432078"},{"driverno":"23","name1":"JOSE POZO","company":"ESR SPENCE BHP","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-1931250303"},{"driverno":"24","name1":"Nicolas Allendes","company":"ESR/PREVENCION","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-29C1D05232"},{"driverno":"26","name1":"JANSON PERALTA","state":"CL","current_workstate":2,"dt_cardid":"","current_workingtimestart":"09/11/2023 09:28:32","current_workingtimeend":"09/11/2023 10:14:46","current_workingtime":"PT603S","driveruid":"1-838083-055D433053","driver_keys":[{"driver_key_type":2,"driver_key_value":"24A73B2E"}]},{"driverno":"27","name1":"Miguel Reyes","company":"CALAFQUEN/MAESTRANZA","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-1931251036"},{"driverno":"28","name1":"Daniel Pavez","company":"ESR SERVICIOS","current_workstate":1,"dt_cardid":"","current_workingtimestart":"19/02/2024 06:21:17","current_workingtimeend":"19/02/2024 06:21:23","current_workingtime":"PT6S","driveruid":"1-838083-663747D7963","driver_keys":[{"driver_key_type":2,"driver_key_value":"34B7C72E"}]},{"driverno":"3","name1":"Daniel Soarzo","state":"CL","company":"ESR/FLOTA","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-19313D6465"},{"driverno":"4","name1":"Conductor Prueba 4","objectno":"003","signontime":"03/01/2019 17:04:20","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-72174D8314","driveruid":"1-838083-29C1C83550"},{"driverno":"46","name1":"Spence","city":"Olivar","email":"rprieto@esrservicios.cl","company":"ESR LTDA","objectno":"009","signontime":"11/08/2022 09:57:29","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-6663385672","driveruid":"1-838083-1938440E348"},{"driverno":"5","name1":"Conductor Prueba 5","objectno":"004","signontime":"03/01/2019 17:04:11","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-9590C12642","driveruid":"1-838083-326A6F0505"},{"driverno":"6","name1":"Conductor ´Prueba 6","objectno":"005","signontime":"03/01/2019 17:04:03","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-05005A2701","driveruid":"1-838083-463E383720"},{"driverno":"67","name1":"JHON PACHECO","telmobile":"967532843","email":"pmellado@esrservicios.cl","company":"ESR SPENCE BHP","current_workstate":4,"dt_cardid":"","current_workingtimestart":"12/02/2024 11:08:01","current_workingtimeend":"12/02/2024 11:08:01","driveruid":"1-838083-885925B0FE6","driver_keys":[{"driver_key_type":2,"driver_key_value":"249D6D2E"}]},{"driverno":"7","name1":"Jonathan Sepulveda","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-535B5A102F"},{"driverno":"8","name1":"Conductor ´Prueba 8","objectno":"006","signontime":"03/01/2019 17:03:41","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-4663395438","driveruid":"1-838083-724A4CE000"},{"driverno":"9","name1":"Conductor ´Prueba 9","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-88505B4709"}]https://csv.webfleet.com/extern?lang=en&account=construccion-montajes&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=popQueueMessagesExtern&msgclass=0&outputformat=json&useUTF8=true&freetext=Leipzig<br>mensaje:[]<br><br>Vacio<br>https://csv.webfleet.com/extern?lang=en&account=construccion-montajes&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=ackQueueMessagesExtern&msgclass=0&outputformat=json&useUTF8=true&freetext=Leipzig<br><br>$data[0][action]=ackQueueMessagesExtern<br>$data[0][result]=1<br>$data[0][acknowledgedMessages]=0<br>$data[0][outstandingMessages]=0<br><br><br>************************ los apagados ******************<br>OK.<br><br>