Integracion LomasBayas (Wisetrack LomasBayas) inamar<br><br><br>https://csv.webfleet.com/extern?lang=en&account=inamar&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=showVehicleReportExtern&outputformat=json&useUTF8=true&freetext=Leipzig<br>con error:<br><br>insert into  integracion_wisetrack_vehiculos (nro,numero, nombre, empresa) values ('1-838083-5305336500','019',upper('SBDL81'),'inamar') <br>Excepción capturada: Field 'conductor' doesn't have a default value
[{"objectno":"019","objectname":"SBDL81","licenseplatenumber":"SBDL81","vehicletype":"pickup","ep_avgfuelusage":5926,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"enginesize":2300,"ep_btaddress":"E4:04:39:E2:2F:86","vehiclecolor":"","objectuid":"1-838083-5305336500","obu_btaddress":"E8:B4:70:33:3C:6C","ep_type":2,"fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"014","objectname":"SBDJ46","licenseplatenumber":"SBDJ46 ","vehicletype":"pickup","identnumber":"3N6BD33B2PK802027","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-196F657467","fueltanksize":2200,"obu_btaddress":"E8:B4:70:32:57:D4","fuelreference":2,"accelerationvehicletype":"light_weight"}]Excepción capturada: Duplicate entry '1-838083-72434D15F6D' for key 'PRIMARY'
[{"driverno":"00001","name1":"Nicolas Cid","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-72434D15F6D","driver_keys":[{"driver_key_type":2,"driver_key_value":"6143E731"}]},{"driverno":"4481","name1":"RODRIGO IRIZAR","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-95C4BC14473","driver_keys":[{"driver_key_type":2,"driver_key_value":"34152F2E"}]},{"driverno":"4483","name1":"JUAN MARCHANT","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-463744662B0","driver_keys":[{"driver_key_type":2,"driver_key_value":"34068A2E"}]},{"driverno":"4484","name1":"MIGUEL ALARCON","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-32631354014","driver_keys":[{"driver_key_type":2,"driver_key_value":"343C122E"}]},{"driverno":"4485","name1":"Rodrigo Verdugo Leon","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-05542404631","driver_keys":[{"driver_key_type":2,"driver_key_value":"34C2A92E"}]},{"driverno":"4486","name1":"DIEGO GONZALEZ","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-724330B111E","driver_keys":[{"driver_key_type":2,"driver_key_value":"34C3732E"}]},{"driverno":"4487","name1":"Manuel Díaz","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-0554521F504","driver_keys":[{"driver_key_type":2,"driver_key_value":"24E69D2E"}]},{"driverno":"4489","name1":"Mauricio Paredes","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-1938343F36F","driver_keys":[{"driver_key_type":2,"driver_key_value":"34C4992E"}]},{"driverno":"4490","name1":"Gonzalo Quezada","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-53525B2606E","driver_keys":[{"driver_key_type":2,"driver_key_value":"24AE112E"}]},{"driverno":"4492","name1":"FELIPE GONZALEZ","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-19384135619","driver_keys":[{"driver_key_type":2,"driver_key_value":"3453D92E"}]},{"driverno":"4493","name1":"Gonzalo Segura","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-3263665E227","driver_keys":[{"driver_key_type":2,"driver_key_value":"2495672E"}]},{"driverno":"4495","name1":"Ricardo Lopez","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-0554521F234","driver_keys":[{"driver_key_type":2,"driver_key_value":"3428AE2E"}]},{"driverno":"4496","name1":"Saúl Zambra","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-1938343F45F","driver_keys":[{"driver_key_type":2,"driver_key_value":"24BC8A2E"}]},{"driverno":"4497","name1":"Paula Segovia","current_workstate":4,"dt_cardid":"","current_workingtimestart":"20/02/2025 07:15:40","current_workingtimeend":"20/02/2025 07:15:40","driveruid":"1-838083-8859521C3E4","driver_keys":[{"driver_key_type":2,"driver_key_value":"34E2CD2E"}]},{"driverno":"4502","name1":"Daniel Alarcon","current_workstate":1,"dt_cardid":"","driveruid":"1-838083-29C8C16E700","driver_keys":[{"driver_key_type":2,"driver_key_value":"2453E12E"}]},{"driverno":"4503","name1":"Sebastian Villegas","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-3263665E243","driver_keys":[{"driver_key_type":2,"driver_key_value":"24DF042E"}]},{"driverno":"4505","name1":"RIGOBERTO MIRANDA","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-724330B114B","driver_keys":[{"driver_key_type":2,"driver_key_value":"34AEDB2E"}]},{"driverno":"4507","name1":"MARCELO CANDIA","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-8859271618E","driver_keys":[{"driver_key_type":2,"driver_key_value":"2470742E"}]},{"driverno":"4508","name1":"JOSE CARRASCO","company":"INAMAR","current_workstate":1,"dt_cardid":"","driveruid":"1-838083-53523364343","driver_keys":[{"driver_key_type":2,"driver_key_value":"24F5D32E"}]},{"driverno":"4509","name1":"OSCAR MARQUEZ","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-95C4BC1475C","driver_keys":[{"driver_key_type":2,"driver_key_value":"341B952E"}]},{"driverno":"4510","name1":"MARCO MARIN","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-29C8B4646E3","driver_keys":[{"driver_key_type":2,"driver_key_value":"24A7102E"}]},{"driverno":"4627","name1":"MICHEL PONCE","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-19384135529","driver_keys":[{"driver_key_type":2,"driver_key_value":"24B7B52E"}]},{"driverno":"4630","name1":"ROBERTO MATAMALA","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-8859271629E","driver_keys":[{"driver_key_type":2,"driver_key_value":"3446F62E"}]},{"driverno":"4631","name1":"Carlos Catalan","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-29C8C1234E6","driver_keys":[{"driver_key_type":2,"driver_key_value":"2472AF2E"}]},{"driverno":"4632","name1":"Ruben Salinas","current_workstate":1,"dt_cardid":"","driveruid":"1-838083-326366131A5","driver_keys":[{"driver_key_type":2,"driver_key_value":"24DFE42E"}]},{"driverno":"4633","name1":"Kevin Suaznabar","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-46373121303","driver_keys":[{"driver_key_type":2,"driver_key_value":"349DF92E"}]},{"driverno":"4636","name1":"Joaquin Ortiz","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-95C4C9535C2","driver_keys":[{"driver_key_type":2,"driver_key_value":"2463232E"}]},{"driverno":"4637","name1":"JORGE ARANCIBIA","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-29C8B464577","driver_keys":[{"driver_key_type":2,"driver_key_value":"3401602E"}]},{"driverno":"4638","name1":"LUIS TABILO","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-32631354306","driver_keys":[{"driver_key_type":2,"driver_key_value":"34338F2E"}]},{"driverno":"4639","name1":"Diego Tirado","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-326366131B4","driver_keys":[{"driver_key_type":2,"driver_key_value":"24D8C12E"}]},{"driverno":"4642","name1":"CLAUDIO VALDES","current_workstate":4,"dt_cardid":"","current_workingtimestart":"29/05/2024 10:07:36","current_workingtimeend":"29/05/2024 10:07:36","driveruid":"1-838083-6637456476B","driver_keys":[{"driver_key_type":2,"driver_key_value":"34DDDC2E"}]},{"driverno":"4643","name1":"Pedro Escudero","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-53522641254","driver_keys":[{"driver_key_type":2,"driver_key_value":"24EF012E"}]},{"driverno":"4644","name1":"NELSON PACHECO","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-66374564631","driver_keys":[{"driver_key_type":2,"driver_key_value":"34807D2E"}]},{"driverno":"4646","name1":"MARCO ORTIZ","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-29C8B464647","driver_keys":[{"driver_key_type":2,"driver_key_value":"347ABB2E"}]},{"driverno":"4647","name1":"María Eugenia","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-6637300312A","driver_keys":[{"driver_key_type":2,"driver_key_value":"2492892E"}]},{"driverno":"4648","name1":"LUIS LOPEZ ","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-05542715049","driver_keys":[{"driver_key_type":2,"driver_key_value":"34C6412E"}]},{"driverno":"4649","name1":"Felipe Quezada","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-0554536E244","driver_keys":[{"driver_key_type":2,"driver_key_value":"34B6742E"}]},{"driverno":"4650","name1":"MAURICIO RIVAS","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-724330B113C","driver_keys":[{"driver_key_type":2,"driver_key_value":"3488752E"}]},{"driverno":"4651","name1":"Natalia Lagos","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-29C8C364034","driver_keys":[{"driver_key_type":2,"driver_key_value":"34803E2E"}]},{"driverno":"4652","name1":"Jesús Arellano","objectno":"006","signontime":"30/10/2026 07:29:29","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":false,"objectuid":"1-838083-05009A3247","driveruid":"1-838083-724347C1F68","driver_keys":[{"driver_key_type":2,"driver_key_value":"34ED5B2E"}]},{"driverno":"4653","name1":"Jehú Videla","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-663732C0291","driver_keys":[{"driver_key_type":2,"driver_key_value":"2472192E"}]},{"driverno":"4654","name1":"Nicolas Benavente","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-88595104593","driver_keys":[{"driver_key_type":2,"driver_key_value":"343A8B2E"}]},{"driverno":"4655","name1":"Javier Rojas","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-53525053647","driver_keys":[{"driver_key_type":2,"driver_key_value":"24FDD42E"}]},{"driverno":"4656","name1":"Sergio Bugueño","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-66373376220","driver_keys":[{"driver_key_type":2,"driver_key_value":"34895D2E"}]},{"driverno":"4657","name1":"Julinka Muñoz","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-885951045A2","driver_keys":[{"driver_key_type":2,"driver_key_value":"340A4A2E"}]},{"driverno":"5341","name1":"Jason Albornoz","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-95C4CA72461","driver_keys":[{"driver_key_type":2,"driver_key_value":"21C5E931"}]},{"driverno":"5368","name1":"Sebastian Viera","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-8859517C105","driver_keys":[{"driver_key_type":2,"driver_key_value":"C10AF031"}]},{"driverno":"5370","name1":"Hernán Sanhueza","objectno":"019","signontime":"29/10/2026 17:44:16","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":false,"objectuid":"1-838083-5305336500","driveruid":"1-838083-88595152303","driver_keys":[{"driver_key_type":2,"driver_key_value":"8122E731"}]},{"driverno":"5371","name1":"Sebastián Albornoz","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-885951A57BE","driver_keys":[{"driver_key_type":2,"driver_key_value":"112CF031"}]},{"driverno":"5372","name1":"Luis Sepúlveda","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-95C4CAA727C","driver_keys":[{"driver_key_type":2,"driver_key_value":"41BAF131"}]},{"driverno":"5373","name1":"Pabla Farias","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-95C4CAA3076","driver_keys":[{"driver_key_type":2,"driver_key_value":"9175EF31"}]},{"driverno":"5375","name1":"Juan Luis Ortiz","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-46373544504","driver_keys":[{"driver_key_type":2,"driver_key_value":"F1F1DF31"}]},{"driverno":"5377","name1":"ALEXANDER ESPINOZA","current_workstate":4,"dt_cardid":"","current_workingtimestart":"11/09/2023 07:13:57","current_workingtimeend":"11/09/2023 07:39:05","current_workingtime":"PT1508S","driveruid":"1-838083-6637456459A","driver_keys":[{"driver_key_type":2,"driver_key_value":"917FE731"}]},{"driverno":"5378","name1":"Abel Cruz","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-0554521F205","driver_keys":[{"driver_key_type":2,"driver_key_value":"41CFE331"}]},{"driverno":"5379","name1":"Jhans Honores","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-66373023786","driver_keys":[{"driver_key_type":2,"driver_key_value":"B11FEA31"}]},{"driverno":"5380","name1":"Sergio Zulen","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-32636E3162C","driver_keys":[{"driver_key_type":2,"driver_key_value":"218AE731"}]},{"driverno":"5381","name1":"David Muñoz","objectno":"023","signontime":"30/10/2026 07:23:57","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":false,"objectuid":"1-838083-880E566C69","driveruid":"1-838083-72434DD4719","driver_keys":[{"driver_key_type":2,"driver_key_value":"C1FEDF31"}]},{"driverno":"5382","name1":"Benjamin Valenzuela","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-19383C5001C","driver_keys":[{"driver_key_type":2,"driver_key_value":"C173DF31"}]},{"driverno":"5479","name1":"Eduardo Obreque","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-724357C4568","driver_keys":[{"driver_key_type":2,"driver_key_value":"F1E6E931"}]}]https://csv.webfleet.com/extern?lang=en&account=inamar&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=inamar&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>OK.<br><br>Integracion LomasBayas (Wisetrack LomasBayas) yconstruccion<br><br><br>https://csv.webfleet.com/extern?lang=en&account=yconstruccion&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=showVehicleReportExtern&outputformat=json&useUTF8=true&freetext=Leipzig<br>{"errorCode":1130,"errorMsg":"Account blocked"}<br><br>con error:error<br><br>https://csv.webfleet.com/extern?lang=en&account=yconstruccion&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=popQueueMessagesExtern&msgclass=0&outputformat=json&useUTF8=true&freetext=Leipzig<br><br>OK.<br><br>Integracion LomasBayas (Wisetrack LomasBayas) Reliper-Comercial<br><br><br>https://csv.webfleet.com/extern?lang=en&account=Reliper-Comercial&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=showVehicleReportExtern&outputformat=json&useUTF8=true&freetext=Leipzig<br>con error:<br><br>insert into  integracion_wisetrack_vehiculos (nro,numero, nombre, empresa) values ('1-838083-32332E4EF7','030',upper('SCGY15'),'Reliper-Comercial') <br>Excepción capturada: Field 'conductor' doesn't have a default value
[{"objectno":"030","objectname":"SCGY-15 Toyota Hilux","licenseplatenumber":"SCGY15","vehicletype":"pickup","identnumber":"v","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"red","description":"Nissan Navara Operaciones","objectuid":"1-838083-32332E4EF7","obu_btaddress":"E4:04:39:BD:BB:7B","fuelreference":0,"accelerationvehicletype":"medium_weight"},{"objectno":"077","objectname":"SPGJ-35 Toyota Hilux","licenseplatenumber":"SPGJ35","vehicletype":"pickup","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-3234306277","obu_btaddress":"E8:B4:70:32:E4:E7","fuelreference":0,"accelerationvehicletype":"light_weight"}]Excepción capturada: Duplicate entry '1-838083-663274C359' for key 'PRIMARY'
[{"driverno":"001","name1":"Juan Olivares","state":"CL","telmobile":"+56962752791","telprivate":"+56962752791","company":"Transporte La Perla","objectno":"033","signontime":"31/05/2021 08:36:38","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-05041A1445","pin":"7738","driveruid":"1-838083-663274C359"},{"driverno":"002","name1":"Jeans Alquinta Antofagasta","objectno":"030","signontime":"06/10/2023 14:25:20","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-32332E4EF7","driveruid":"1-838083-885925651B5"},{"driverno":"003","name1":"Luis Castillo","state":"CL","telmobile":"+56975795663","company":"Sociedad Transportes La Perla","objectno":"054","signontime":"15/11/2021 12:25:11","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-196AE00154","driveruid":"1-838083-29C014D257"},{"driverno":"005","name1":"Rodrigo Muñoz","company":"Sociedad de transportes Zorros del Desierto","objectno":"037","signontime":"27/12/2019 14:50:21","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-2998896267","driveruid":"1-838083-95CC1CA253"},{"driverno":"006","name1":"Ramiro Rodriguez","company":"Reliper Calama","objectno":"056","signontime":"09/01/2023 22:29:45","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-05068640F4","driveruid":"1-838083-46374317701"},{"driverno":"007","name1":"Jorge Collao","company":"Reliper Casa Matriz","objectno":"059","signontime":"30/12/2019 16:55:28","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-95961D4E56","pin":"1234","driveruid":"1-838083-463FE7307F"},{"driverno":"008","name1":"Felipe Lagos","company":"Reliper Fabrica","objectno":"029","signontime":"09/01/2023 22:30:39","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-2998897EA2","driveruid":"1-838083-724337C048B"},{"driverno":"009","name1":"Marcos Sarmiento","company":"Reliper Santiago","objectno":"051","signontime":"09/01/2023 22:28:07","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-666500C311","driveruid":"1-838083-29C8B31501F"},{"driverno":"010","name1":"Pablo Acori","objectno":"065","signontime":"28/09/2023 17:07:13","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-299F811661","driveruid":"1-838083-3263114F762"},{"driverno":"011","name1":"Carlos Roberto Martinez","company":"Reliper S.A","objectno":"063","signontime":"17/06/2022 15:19:24","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-6663E52F92","driveruid":"1-838083-72432CBB311"},{"driverno":"012","name1":"Juan Navarrete","objectno":"039","signontime":"11/10/2023 11:58:56","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-466779601B","driveruid":"1-838083-4637461C4C6"},{"driverno":"014","name1":"Jorge Molina","objectno":"041","signontime":"17/11/2023 14:57:30","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-32332E5F04","driveruid":"1-838083-7243321B52D"},{"driverno":"053","name1":"Rita Garcia","objectno":"066","signontime":"06/10/2023 14:28:30","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-323426263A","driveruid":"1-838083-05542566054"},{"driverno":"077","name1":"Valentina Ocampo Antofagasta","objectno":"077","signontime":"06/10/2023 14:26:53","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-3234306277","driveruid":"1-838083-95C4BE67471"}]https://csv.webfleet.com/extern?lang=en&account=Reliper-Comercial&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=Reliper-Comercial&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>OK.<br><br>OK proceso terminado.