Integracion (TrackTecII) 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><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><br>Carga de eventos<br>https://csv.webfleet.com/extern?lang=es&account=transportes-UbP&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=showAccelerationEvents&objectgroupname=765C27A29CF36F528909418CC94A0885&range_pattern=d0&outputformat=json&useUTF8=true&freetext=Leipzig<br><br>************************ los apagados ******************<br>OK.<br><br>Integracion (TrackTecII) transportes-polykarpo<br><br><br>https://csv.webfleet.com/extern?lang=en&account=transportes-polykarpo&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=showVehicleReportExtern&outputformat=json&useUTF8=true&freetext=Leipzig<br>{"errorCode":1130,"errorMsg":"Account blocked"}<br><br><br>https://csv.webfleet.com/extern?lang=en&account=transportes-polykarpo&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=showDriverReportExtern&outputformat=json&useUTF8=true&freetext=Leipzig<br>https://csv.webfleet.com/extern?lang=en&account=transportes-polykarpo&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=popQueueMessagesExtern&msgclass=0&outputformat=json&useUTF8=true&freetext=Leipzig<br>{"errorCode":1130,"errorMsg":"Account blocked"}<br><br><br>Carga de eventos<br>https://csv.webfleet.com/extern?lang=es&account=transportes-polykarpo&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=showAccelerationEvents&objectgroupname=765C27A29CF36F528909418CC94A0885&range_pattern=d0&outputformat=json&useUTF8=true&freetext=Leipzig<br><br>************************ los apagados ******************<br>OK.<br><br>OK proceso terminado.