Integracion EMSA (Wisetrack Emsa) aquadrill<br><br><br>https://csv.webfleet.com/extern?lang=en&account=aquadrill&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-880F30517D','047',upper('RBXF43'),'aquadrill') <br>Excepción capturada: Field 'conductor' doesn't have a default value
[{"objectno":"047","objectname":"RBXF43","licenseplatenumber":"RBXF43","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-880F30517D","fuelreference":2},{"objectno":"032","objectname":"PZZD87","licenseplatenumber":"PZZD87","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-4661697000","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"006","objectname":"SVZR30","licenseplatenumber":"SVZR30","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-32347F7716","obu_btaddress":"E8:B4:70:35:E1:31","fuelreference":2},{"objectno":"015","objectname":"LYPB88","licenseplatenumber":"LYPB88","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-72145C9536","obu_btaddress":"E8:B4:70:35:E1:63","fuelreference":2},{"objectno":"022","objectname":"GLBC21","licenseplatenumber":"GLBC21","vehicletype":"car","fl_fueltype":1,"vehiclecolor":"blue","objectuid":"1-838083-46602871C1","fuelreference":2},{"objectno":"007","objectname":"LDBB13","licenseplatenumber":"LDBB13","vehicletype":"dump_truck","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-196F2D1223","obu_btaddress":"E8:B4:70:35:57:3D","fuelreference":2,"accelerationvehicletype":"medium_weight"},{"objectno":"018","objectname":"LYPB89","licenseplatenumber":"LYPB89","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-72145C95F2","obu_btaddress":"E8:B4:70:35:DE:7E","fuelreference":2},{"objectno":"020","objectname":"RD1926","licenseplatenumber":"RD1926","vehicletype":"car","fl_fueltype":1,"vehiclecolor":"blue","objectuid":"1-838083-880E4B010C","fuelreference":2},{"objectno":"021","objectname":"BDDZ35","licenseplatenumber":"BDDZ35","vehicletype":"car","fl_fueltype":1,"vehiclecolor":"blue","objectuid":"1-838083-880E4B01FB","fuelreference":2},{"objectno":"008","objectname":"TDVP16","licenseplatenumber":"TDVP16","vehicletype":"pickup","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-466028411B","obu_btaddress":"E8:B4:70:35:55:C1","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"016","objectname":"PRVR43","licenseplatenumber":"PRVR43","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-9593D03073","obu_btaddress":"E8:B4:70:35:57:56","fuelreference":2},{"objectno":"003","objectname":"SVZR31","licenseplatenumber":"SVZR31","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-299FD84653","obu_btaddress":"E8:B4:70:35:57:B6","fuelreference":2},{"objectno":"027","objectname":"LXJJ22","licenseplatenumber":"LXJJ22","vehicletype":"car","fl_fueltype":1,"vehiclecolor":"blue","objectuid":"1-838083-196F2D2167","fuelreference":2},{"objectno":"004","objectname":"PZZD87","licenseplatenumber":"PZZD87","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-466028454A","obu_btaddress":"E8:B4:70:35:DE:A7","fuelreference":2},{"objectno":"002","objectname":"LTZP99","licenseplatenumber":"LTZP99","vehicletype":"van","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-880E4B346E","obu_btaddress":"E8:B4:70:35:D9:D0","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"011","objectname":"LYPF53","licenseplatenumber":"LYPF53","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-05034B32F3","obu_btaddress":"E8:B4:70:35:D1:72","fuelreference":2},{"objectno":"017","objectname":"LYPF15","licenseplatenumber":"LYPF15","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-9593D03042","obu_btaddress":"E8:B4:70:35:D8:C8","fuelreference":2},{"objectno":"001","objectname":"RBXF43","licenseplatenumber":"RBXF43","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-72145C8B24","obu_btaddress":"E8:B4:70:35:DB:BB","fuelreference":2},{"objectno":"029","objectname":"TYWR51 ","licenseplatenumber":"TYWR51 ","vehicletype":"pickup","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-299FE2632E","obu_btaddress":"E8:B4:70:33:B1:4E","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"030","objectname":"TYWR42","licenseplatenumber":"TYWR42 ","vehicletype":"pickup","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-0503711243","obu_btaddress":"E8:B4:70:35:5C:25","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"031","objectname":"SXGB65","licenseplatenumber":"SXGB65","vehicletype":"tanker_truck","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-721461EA10","obu_btaddress":"E8:B4:70:35:5B:B1","fuelreference":2,"accelerationvehicletype":"light_weight"}]Excepción capturada: Duplicate entry '1-838083-1938373210D' for key 'PRIMARY'
[{"driverno":"1","name1":"Conductor 1","objectno":"001","signontime":"06/01/2025 13:19:56","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-72145C8B24","driveruid":"1-838083-1938373210D"},{"driverno":"10","name1":"Conductor 10","objectno":"011","signontime":"06/01/2025 13:37:08","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-05034B32F3","driveruid":"1-838083-66373363134"},{"driverno":"11","name1":"Conductor 11","objectno":"012","signontime":"06/01/2025 13:38:54","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-05034B3165","driveruid":"1-838083-885951116BE"},{"driverno":"12","name1":"Conductor 12","objectno":"013","signontime":"06/01/2025 13:39:13","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-05034B3147","driveruid":"1-838083-95C4CA1337C"},{"driverno":"13","name1":"Conductor 13","objectno":"014","signontime":"06/01/2025 13:39:34","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-32347F7051","driveruid":"1-838083-29C8C263227"},{"driverno":"14","name1":"Conductor 14","objectno":"015","signontime":"06/01/2025 13:40:00","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-72145C9536","driveruid":"1-838083-32636553766"},{"driverno":"15","name1":"Conductor 15","objectno":"016","signontime":"06/01/2025 13:40:43","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-9593D03073","driveruid":"1-838083-463732615C2"},{"driverno":"2","name1":"Conductor 2","objectno":"002","signontime":"06/01/2025 13:24:33","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-880E4B346E","driveruid":"1-838083-53525046571"},{"driverno":"3","name1":"Conductor 3","objectno":"003","signontime":"06/01/2025 13:24:52","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-299FD84653","driveruid":"1-838083-724346B6611"},{"driverno":"4","name1":"Conductor 4","objectno":"004","signontime":"06/01/2025 13:25:24","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-466028454A","driveruid":"1-838083-95C4CA13365"},{"driverno":"5","name1":"Conductor 5","objectno":"005","signontime":"06/01/2025 13:25:45","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-53054A620F","driveruid":"1-838083-1938373212B"},{"driverno":"6","name1":"Conductor 6","objectno":"006","signontime":"06/01/2025 13:27:06","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-32347F7716","driveruid":"1-838083-32636553700"},{"driverno":"7","name1":"Conductor 7","objectno":"007","signontime":"06/01/2025 13:35:55","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-196F2D1223","driveruid":"1-838083-19383732138"},{"driverno":"8","name1":"Conductor 8","objectno":"008","signontime":"06/01/2025 13:36:19","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-466028411B","driveruid":"1-838083-32636553717"},{"driverno":"9","name1":"Conductor 9","objectno":"009","signontime":"06/01/2025 13:36:39","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-9593D03343","driveruid":"1-838083-463732615B5"}]https://csv.webfleet.com/extern?lang=en&account=aquadrill&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=aquadrill&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.