[2025-10-24 00:48:28] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24269.xml [2025-10-24 00:48:28] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24269.xml for user: 68d56363ec1209189 [2025-10-24 00:48:28] [INFO] File size: 1922 bytes [2025-10-24 00:48:28] [INFO] Created FTPFiles record with ID: 68faccdc9d162e4e5 [2025-10-24 00:48:28] [INFO] WE ARE HERE {"mappings":{"IncidentNumber":"dispatchRunNumber","house_number":"incidentLocationStreetNumber","street":"streetName","apt":"incidentLocationApt","city":"incidentLocationCity","location_name":"businessName","STATE":"incidentLocationStateName","ZIPCODE":"nERISIncidentPostalCode","LATITUDE":"nERISIncidentLatitude","LONGITUDE":"nERISIncidentLongitude","incident_type":"incidentTypeValue1","commentlist.comment":["dispatchNotes","cADLog"],"time_first_unit_assigned":["alarm","dispatched"],"time_first_unit_arrived":"onScene","time_last_unit_cleared":["cleared","inService"],"Units.Unit[0].radio_name":["cADVehicleID","name"],"Units.Unit[0].time_enroute":"timeenroutetoscene","Units.Unit[0].time_arrivedatscene":"timeonscene","Units.Unit[0].time_depart_scene":"timeunitclear","Units.Unit[0].time_assigned":"timedispatch"},"selectedRecord":{"id":"68eeb2639352dd41d","name":null},"fieldExamples":{"IncidentNumber":{"name":"IncidentNumber","value":"25-23514","type":"text"},"house_number":{"name":"house_number","value":"515","type":"number"},"street":{"name":"street","value":"LINDENWOOD AVE","type":"address"},"apt":{"name":"apt","value":"Array","type":"text"},"city":{"name":"city","value":"Array","type":"address"},"location_name":{"name":"location_name","value":"Array","type":"text"},"STATE":{"name":"STATE","value":"Array","type":"address"},"ZIPCODE":{"name":"ZIPCODE","value":"Array","type":"address"},"LATITUDE":{"name":"LATITUDE","value":"0","type":"coordinate"},"LONGITUDE":{"name":"LONGITUDE","value":"0","type":"coordinate"},"incident_type":{"name":"incident_type","value":"FIRE-GAS LEAK","type":"text"},"commentlist.comment":{"name":"comment","value":"10-14-2025 15:05:06|B45 ADVISED HE WOULD NOTIFY GAS CO 10-14-2025 15:05:23|B46 NOTHING SHOWING 10-14-2025 15:08:22|B46 ADVISED NO SMELL OF GAS HOWEVER ALARMS GOING OFF 10-14-2025 15:13:38|B46 CLEARED ","type":"text"},"time_first_unit_assigned":{"name":"time_first_unit_assigned","value":"10-14-2025T15:04:42","type":"datetime"},"time_first_unit_arrived":{"name":"time_first_unit_arrived","value":"10-14-2025T15:07:19","type":"datetime"},"time_last_unit_cleared":{"name":"time_last_unit_cleared","value":"10-14-2025T15:27:23","type":"datetime"},"Units.Unit[0].radio_name":{"name":"radio_name","value":"ENG2","type":"text"},"Units.Unit[0].time_enroute":{"name":"time_enroute","value":"10-14-2025T15:04:46","type":"datetime"},"Units.Unit[0].time_arrivedatscene":{"name":"time_arrivedatscene","value":"10-14-2025T15:08:38","type":"datetime"},"Units.Unit[0].time_depart_scene":{"name":"time_depart_scene","value":"10-14-2025T15:27:23","type":"datetime"},"Units.Unit[0].time_assigned":{"name":"time_assigned","value":"10-14-2025T15:04:42","type":"datetime"}},"timestamp":"2025-10-16T18:16:37.381Z"} [2025-10-24 00:48:28] [INFO] About to extract fields from XML. File size: 1922 bytes [2025-10-24 00:48:28] [INFO] Number of mappings: 20 [2025-10-24 00:48:28] [INFO] Starting XML parsing. Content length: 1922 [2025-10-24 00:48:28] [INFO] XML parsed successfully. Root element: Incident [2025-10-24 00:48:28] [INFO] Processing 20 field mappings [2025-10-24 00:48:28] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber' [2025-10-24 00:48:28] [INFO] -> Found value: 25-24269 [2025-10-24 00:48:28] [INFO] -> Set field 'dispatchRunNumber' = "25-24269" [2025-10-24 00:48:28] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber' [2025-10-24 00:48:28] [INFO] -> Found value: 1817 [2025-10-24 00:48:28] [INFO] -> Set field 'incidentLocationStreetNumber' = 1817 [2025-10-24 00:48:28] [INFO] Mapping #3: Extracting 'street' => 'streetName' [2025-10-24 00:48:28] [INFO] -> Found value: E MALONE AVE [2025-10-24 00:48:28] [INFO] -> Set field 'streetName' = "E MALONE AVE" [2025-10-24 00:48:28] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt' [2025-10-24 00:48:28] [INFO] -> No value found (null or empty) [2025-10-24 00:48:28] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity' [2025-10-24 00:48:28] [INFO] -> Found value: SIKESTON [2025-10-24 00:48:28] [INFO] -> Set field 'incidentLocationCity' = "SIKESTON" [2025-10-24 00:48:28] [INFO] Mapping #6: Extracting 'location_name' => 'businessName' [2025-10-24 00:48:28] [INFO] -> Found value: GREEN LIGHT DISPENSARY [2025-10-24 00:48:28] [INFO] -> Set field 'businessName' = "GREEN LIGHT DISPENSARY" [2025-10-24 00:48:28] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName' [2025-10-24 00:48:28] [INFO] -> Found value: MO [2025-10-24 00:48:28] [INFO] -> Set field 'incidentLocationStateName' = "MO" [2025-10-24 00:48:28] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode' [2025-10-24 00:48:28] [INFO] -> Found value: 63801 [2025-10-24 00:48:28] [INFO] -> Set field 'nERISIncidentPostalCode' = 63801 [2025-10-24 00:48:28] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude' [2025-10-24 00:48:28] [INFO] -> Found value: 0 [2025-10-24 00:48:28] [INFO] -> Set field 'nERISIncidentLatitude' = null [2025-10-24 00:48:28] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude' [2025-10-24 00:48:28] [INFO] -> Found value: 0 [2025-10-24 00:48:28] [INFO] -> Set field 'nERISIncidentLongitude' = null [2025-10-24 00:48:28] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1' [2025-10-24 00:48:28] [INFO] -> Found value: ACCIDENT-J2 [2025-10-24 00:48:28] [INFO] -> Set field 'incidentTypeValue1' = "ACCIDENT-J2" [2025-10-24 00:48:28] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"] [2025-10-24 00:48:28] [INFO] -> Found value: 10-23-2025 19:14:04|Call Received on 10/23/2025 @ 19:14 VEH ACCIDENT BOTH VEHS IN THE ROADWAY 10-2... [2025-10-24 00:48:28] [INFO] -> Set field 'dispatchNotes' = "10-23-2025 19:14:04|Call Received on 10\/23\/2025 @ 19:14\n\nVEH ACCIDENT BOTH VEHS IN THE ROADWAY\n 10-23-2025 19:21:41|BOTH EAST BOUND LANES OF TRAVEL ARE BLOCKED 10-23-2025 19:21:52|20 YO FEMALE WITH NOSE BLEED 10-23-2025 19:22:54|542 ADVISED NO ENTRAPMENT 10-23-2025 19:27:46|10-51 ON CALL 1X 10-23-2025 19:28:06|CONTACTING JSH 10-23-2025 19:28:41|JSH EN ROUTE 10-23-2025 19:36:42|10-51 ON SCENE 10-23-2025 19:41:03|REFUSAL 10-23-2025 19:41:52|Disposition - SSCA: RPT 10-23-2025 19:47:30|1051 HAS VEHS ONE CITATION TO ONE OF THE DRIVERS WILL HAVE A LETS REPORT" [2025-10-24 00:48:28] [INFO] -> Set field 'cADLog' = "10-23-2025 19:14:04|Call Received on 10\/23\/2025 @ 19:14\n\nVEH ACCIDENT BOTH VEHS IN THE ROADWAY\n 10-23-2025 19:21:41|BOTH EAST BOUND LANES OF TRAVEL ARE BLOCKED 10-23-2025 19:21:52|20 YO FEMALE WITH NOSE BLEED 10-23-2025 19:22:54|542 ADVISED NO ENTRAPMENT 10-23-2025 19:27:46|10-51 ON CALL 1X 10-23-2025 19:28:06|CONTACTING JSH 10-23-2025 19:28:41|JSH EN ROUTE 10-23-2025 19:36:42|10-51 ON SCENE 10-23-2025 19:41:03|REFUSAL 10-23-2025 19:41:52|Disposition - SSCA: RPT 10-23-2025 19:47:30|1051 HAS VEHS ONE CITATION TO ONE OF THE DRIVERS WILL HAVE A LETS REPORT" [2025-10-24 00:48:28] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"] [2025-10-24 00:48:28] [INFO] -> Found value: 10-23-2025T19:17:36 [2025-10-24 00:48:28] [ERROR] Error formatting datetime '10-23-2025T19:17:36': Failed to parse time string (10-23-2025T19:17:36) at position 0 (1): Unexpected character [2025-10-24 00:48:28] [INFO] -> Set field 'alarm' = null [2025-10-24 00:48:28] [ERROR] Error formatting datetime '10-23-2025T19:17:36': Failed to parse time string (10-23-2025T19:17:36) at position 0 (1): Unexpected character [2025-10-24 00:48:28] [INFO] -> Set field 'dispatched' = null [2025-10-24 00:48:28] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene' [2025-10-24 00:48:28] [INFO] -> Found value: 10-23-2025T19:21:15 [2025-10-24 00:48:28] [ERROR] Error formatting datetime '10-23-2025T19:21:15': Failed to parse time string (10-23-2025T19:21:15) at position 0 (1): Unexpected character [2025-10-24 00:48:28] [INFO] -> Set field 'onScene' = null [2025-10-24 00:48:28] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"] [2025-10-24 00:48:28] [INFO] -> Found value: 10-23-2025T19:47:36 [2025-10-24 00:48:28] [ERROR] Error formatting datetime '10-23-2025T19:47:36': Failed to parse time string (10-23-2025T19:47:36) at position 0 (1): Unexpected character [2025-10-24 00:48:28] [INFO] -> Set field 'cleared' = null [2025-10-24 00:48:28] [ERROR] Error formatting datetime '10-23-2025T19:47:36': Failed to parse time string (10-23-2025T19:47:36) at position 0 (1): Unexpected character [2025-10-24 00:48:28] [INFO] -> Set field 'inService' = null [2025-10-24 00:48:28] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"] [2025-10-24 00:48:28] [INFO] -> Found value: ENG2 [2025-10-24 00:48:28] [INFO] -> Set field 'cADVehicleID' = "ENG2" [2025-10-24 00:48:28] [INFO] -> Set field 'name' = "ENG2" [2025-10-24 00:48:28] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene' [2025-10-24 00:48:28] [INFO] -> No value found (null or empty) [2025-10-24 00:48:28] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene' [2025-10-24 00:48:28] [INFO] -> Found value: 10-23-2025T19:22:45 [2025-10-24 00:48:28] [ERROR] Error formatting datetime '10-23-2025T19:22:45': Failed to parse time string (10-23-2025T19:22:45) at position 0 (1): Unexpected character [2025-10-24 00:48:28] [INFO] -> Set field 'timeonscene' = null [2025-10-24 00:48:28] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear' [2025-10-24 00:48:28] [INFO] -> Found value: 10-23-2025T19:47:36 [2025-10-24 00:48:28] [ERROR] Error formatting datetime '10-23-2025T19:47:36': Failed to parse time string (10-23-2025T19:47:36) at position 0 (1): Unexpected character [2025-10-24 00:48:28] [INFO] -> Set field 'timeunitclear' = null [2025-10-24 00:48:28] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch' [2025-10-24 00:48:28] [INFO] -> Found value: 10-23-2025T19:22:43 [2025-10-24 00:48:28] [ERROR] Error formatting datetime '10-23-2025T19:22:43': Failed to parse time string (10-23-2025T19:22:43) at position 0 (1): Unexpected character [2025-10-24 00:48:28] [INFO] -> Set field 'timedispatch' = null [2025-10-24 00:48:28] [INFO] Finished extracting fields. Total fields extracted: 22 [2025-10-24 00:48:28] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-24269","incidentLocationStreetNumber":1817,"streetName":"E MALONE AVE","incidentLocationCity":"SIKESTON","businessName":"GREEN LIGHT DISPENSARY","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"ACCIDENT-J2","dispatchNotes":"10-23-2025 19:14:04|Call Received on 10\/23\/2025 @ 19:14\n\nVEH ACCIDENT BOTH VEHS IN THE ROADWAY\n 10-23-2025 19:21:41|BOTH EAST BOUND LANES OF TRAVEL ARE BLOCKED 10-23-2025 19:21:52|20 YO FEMALE WITH NOSE BLEED 10-23-2025 19:22:54|542 ADVISED NO ENTRAPMENT 10-23-2025 19:27:46|10-51 ON CALL 1X 10-23-2025 19:28:06|CONTACTING JSH 10-23-2025 19:28:41|JSH EN ROUTE 10-23-2025 19:36:42|10-51 ON SCENE 10-23-2025 19:41:03|REFUSAL 10-23-2025 19:41:52|Disposition - SSCA: RPT 10-23-2025 19:47:30|1051 HAS VEHS ONE CITATION TO ONE OF THE DRIVERS WILL HAVE A LETS REPORT","cADLog":"10-23-2025 19:14:04|Call Received on 10\/23\/2025 @ 19:14\n\nVEH ACCIDENT BOTH VEHS IN THE ROADWAY\n 10-23-2025 19:21:41|BOTH EAST BOUND LANES OF TRAVEL ARE BLOCKED 10-23-2025 19:21:52|20 YO FEMALE WITH NOSE BLEED 10-23-2025 19:22:54|542 ADVISED NO ENTRAPMENT 10-23-2025 19:27:46|10-51 ON CALL 1X 10-23-2025 19:28:06|CONTACTING JSH 10-23-2025 19:28:41|JSH EN ROUTE 10-23-2025 19:36:42|10-51 ON SCENE 10-23-2025 19:41:03|REFUSAL 10-23-2025 19:41:52|Disposition - SSCA: RPT 10-23-2025 19:47:30|1051 HAS VEHS ONE CITATION TO ONE OF THE DRIVERS WILL HAVE A LETS REPORT","alarm":null,"dispatched":null,"onScene":null,"cleared":null,"inService":null,"cADVehicleID":"ENG2","name":"ENG2","timeonscene":null,"timeunitclear":null,"timedispatch":null} [2025-10-24 00:48:28] [INFO] Number of extracted fields: 22 [2025-10-24 00:48:28] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e87be42b7c [2025-10-24 00:48:29] [INFO] Created Dispatches record with ID: 68faccdcbef2c52a0 [2025-10-24 00:48:29] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24269.xml [2025-10-24 00:48:29] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24269.xml [2025-10-24 04:44:47] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24283.xml [2025-10-24 04:44:47] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24283.xml for user: 68d56363ec1209189 [2025-10-24 04:44:47] [INFO] File size: 2013 bytes [2025-10-24 04:44:47] [INFO] Created FTPFiles record with ID: 68fb043f706433122 [2025-10-24 04:44:47] [INFO] WE ARE HERE {"mappings":{"IncidentNumber":"dispatchRunNumber","house_number":"incidentLocationStreetNumber","street":"streetName","apt":"incidentLocationApt","city":"incidentLocationCity","location_name":"businessName","STATE":"incidentLocationStateName","ZIPCODE":"nERISIncidentPostalCode","LATITUDE":"nERISIncidentLatitude","LONGITUDE":"nERISIncidentLongitude","incident_type":"incidentTypeValue1","commentlist.comment":["dispatchNotes","cADLog"],"time_first_unit_assigned":["alarm","dispatched"],"time_first_unit_arrived":"onScene","time_last_unit_cleared":["cleared","inService"],"Units.Unit[0].radio_name":["cADVehicleID","name"],"Units.Unit[0].time_enroute":"timeenroutetoscene","Units.Unit[0].time_arrivedatscene":"timeonscene","Units.Unit[0].time_depart_scene":"timeunitclear","Units.Unit[0].time_assigned":"timedispatch"},"selectedRecord":{"id":"68eeb2639352dd41d","name":null},"fieldExamples":{"IncidentNumber":{"name":"IncidentNumber","value":"25-23514","type":"text"},"house_number":{"name":"house_number","value":"515","type":"number"},"street":{"name":"street","value":"LINDENWOOD AVE","type":"address"},"apt":{"name":"apt","value":"Array","type":"text"},"city":{"name":"city","value":"Array","type":"address"},"location_name":{"name":"location_name","value":"Array","type":"text"},"STATE":{"name":"STATE","value":"Array","type":"address"},"ZIPCODE":{"name":"ZIPCODE","value":"Array","type":"address"},"LATITUDE":{"name":"LATITUDE","value":"0","type":"coordinate"},"LONGITUDE":{"name":"LONGITUDE","value":"0","type":"coordinate"},"incident_type":{"name":"incident_type","value":"FIRE-GAS LEAK","type":"text"},"commentlist.comment":{"name":"comment","value":"10-14-2025 15:05:06|B45 ADVISED HE WOULD NOTIFY GAS CO 10-14-2025 15:05:23|B46 NOTHING SHOWING 10-14-2025 15:08:22|B46 ADVISED NO SMELL OF GAS HOWEVER ALARMS GOING OFF 10-14-2025 15:13:38|B46 CLEARED ","type":"text"},"time_first_unit_assigned":{"name":"time_first_unit_assigned","value":"10-14-2025T15:04:42","type":"datetime"},"time_first_unit_arrived":{"name":"time_first_unit_arrived","value":"10-14-2025T15:07:19","type":"datetime"},"time_last_unit_cleared":{"name":"time_last_unit_cleared","value":"10-14-2025T15:27:23","type":"datetime"},"Units.Unit[0].radio_name":{"name":"radio_name","value":"ENG2","type":"text"},"Units.Unit[0].time_enroute":{"name":"time_enroute","value":"10-14-2025T15:04:46","type":"datetime"},"Units.Unit[0].time_arrivedatscene":{"name":"time_arrivedatscene","value":"10-14-2025T15:08:38","type":"datetime"},"Units.Unit[0].time_depart_scene":{"name":"time_depart_scene","value":"10-14-2025T15:27:23","type":"datetime"},"Units.Unit[0].time_assigned":{"name":"time_assigned","value":"10-14-2025T15:04:42","type":"datetime"}},"timestamp":"2025-10-16T18:16:37.381Z"} [2025-10-24 04:44:47] [INFO] About to extract fields from XML. File size: 2013 bytes [2025-10-24 04:44:47] [INFO] Number of mappings: 20 [2025-10-24 04:44:47] [INFO] Starting XML parsing. Content length: 2013 [2025-10-24 04:44:47] [INFO] XML parsed successfully. Root element: Incident [2025-10-24 04:44:47] [INFO] Processing 20 field mappings [2025-10-24 04:44:47] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber' [2025-10-24 04:44:47] [INFO] -> Found value: 25-24283 [2025-10-24 04:44:47] [INFO] -> Set field 'dispatchRunNumber' = "25-24283" [2025-10-24 04:44:47] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber' [2025-10-24 04:44:47] [INFO] -> Found value: 226 [2025-10-24 04:44:47] [INFO] -> Set field 'incidentLocationStreetNumber' = 226 [2025-10-24 04:44:47] [INFO] Mapping #3: Extracting 'street' => 'streetName' [2025-10-24 04:44:47] [INFO] -> Found value: PLAZA DR [2025-10-24 04:44:47] [INFO] -> Set field 'streetName' = "PLAZA DR" [2025-10-24 04:44:47] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt' [2025-10-24 04:44:47] [INFO] -> No value found (null or empty) [2025-10-24 04:44:47] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity' [2025-10-24 04:44:47] [INFO] -> No value found (null or empty) [2025-10-24 04:44:47] [INFO] Mapping #6: Extracting 'location_name' => 'businessName' [2025-10-24 04:44:47] [INFO] -> Found value: LABONNE MAISON [2025-10-24 04:44:47] [INFO] -> Set field 'businessName' = "LABONNE MAISON" [2025-10-24 04:44:47] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName' [2025-10-24 04:44:47] [INFO] -> No value found (null or empty) [2025-10-24 04:44:47] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode' [2025-10-24 04:44:47] [INFO] -> No value found (null or empty) [2025-10-24 04:44:47] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude' [2025-10-24 04:44:47] [INFO] -> Found value: 0 [2025-10-24 04:44:47] [INFO] -> Set field 'nERISIncidentLatitude' = null [2025-10-24 04:44:47] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude' [2025-10-24 04:44:47] [INFO] -> Found value: 0 [2025-10-24 04:44:47] [INFO] -> Set field 'nERISIncidentLongitude' = null [2025-10-24 04:44:47] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1' [2025-10-24 04:44:47] [INFO] -> Found value: FIRE-ALARM MECH [2025-10-24 04:44:47] [INFO] -> Set field 'incidentTypeValue1' = "FIRE-ALARM MECH" [2025-10-24 04:44:47] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"] [2025-10-24 04:44:47] [INFO] -> Found value: 10-23-2025 23:32:13|CALLER STATED ALARM IS DETECTING HEAT IN THE KITCHEN ADMINISTRATOR ROOM 10-23-2... [2025-10-24 04:44:47] [INFO] -> Set field 'dispatchNotes' = "10-23-2025 23:32:13|CALLER STATED ALARM IS DETECTING HEAT IN THE KITCHEN ADMINISTRATOR ROOM 10-23-2025 23:41:34|ONE STORY NOTHING SHOWING" [2025-10-24 04:44:47] [INFO] -> Set field 'cADLog' = "10-23-2025 23:32:13|CALLER STATED ALARM IS DETECTING HEAT IN THE KITCHEN ADMINISTRATOR ROOM 10-23-2025 23:41:34|ONE STORY NOTHING SHOWING" [2025-10-24 04:44:47] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"] [2025-10-24 04:44:47] [INFO] -> Found value: 10-23-2025T23:39:10 [2025-10-24 04:44:47] [ERROR] Error formatting datetime '10-23-2025T23:39:10': Failed to parse time string (10-23-2025T23:39:10) at position 0 (1): Unexpected character [2025-10-24 04:44:47] [INFO] -> Set field 'alarm' = null [2025-10-24 04:44:47] [ERROR] Error formatting datetime '10-23-2025T23:39:10': Failed to parse time string (10-23-2025T23:39:10) at position 0 (1): Unexpected character [2025-10-24 04:44:47] [INFO] -> Set field 'dispatched' = null [2025-10-24 04:44:47] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene' [2025-10-24 04:44:47] [INFO] -> Found value: 10-23-2025T23:40:10 [2025-10-24 04:44:47] [ERROR] Error formatting datetime '10-23-2025T23:40:10': Failed to parse time string (10-23-2025T23:40:10) at position 0 (1): Unexpected character [2025-10-24 04:44:47] [INFO] -> Set field 'onScene' = null [2025-10-24 04:44:47] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"] [2025-10-24 04:44:47] [INFO] -> No value found (null or empty) [2025-10-24 04:44:47] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"] [2025-10-24 04:44:47] [INFO] -> Found value: ENG2 [2025-10-24 04:44:47] [INFO] -> Set field 'cADVehicleID' = "ENG2" [2025-10-24 04:44:47] [INFO] -> Set field 'name' = "ENG2" [2025-10-24 04:44:47] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene' [2025-10-24 04:44:47] [INFO] -> Found value: 10-23-2025T23:40:07 [2025-10-24 04:44:47] [ERROR] Error formatting datetime '10-23-2025T23:40:07': Failed to parse time string (10-23-2025T23:40:07) at position 0 (1): Unexpected character [2025-10-24 04:44:47] [INFO] -> Set field 'timeenroutetoscene' = null [2025-10-24 04:44:47] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene' [2025-10-24 04:44:47] [INFO] -> No value found (null or empty) [2025-10-24 04:44:47] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear' [2025-10-24 04:44:47] [INFO] -> Found value: 10-23-2025T23:44:26 [2025-10-24 04:44:47] [ERROR] Error formatting datetime '10-23-2025T23:44:26': Failed to parse time string (10-23-2025T23:44:26) at position 0 (1): Unexpected character [2025-10-24 04:44:47] [INFO] -> Set field 'timeunitclear' = null [2025-10-24 04:44:47] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch' [2025-10-24 04:44:47] [INFO] -> Found value: 10-23-2025T23:40:01 [2025-10-24 04:44:47] [ERROR] Error formatting datetime '10-23-2025T23:40:01': Failed to parse time string (10-23-2025T23:40:01) at position 0 (1): Unexpected character [2025-10-24 04:44:47] [INFO] -> Set field 'timedispatch' = null [2025-10-24 04:44:47] [INFO] Finished extracting fields. Total fields extracted: 17 [2025-10-24 04:44:47] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-24283","incidentLocationStreetNumber":226,"streetName":"PLAZA DR","businessName":"LABONNE MAISON","nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-ALARM MECH","dispatchNotes":"10-23-2025 23:32:13|CALLER STATED ALARM IS DETECTING HEAT IN THE KITCHEN ADMINISTRATOR ROOM 10-23-2025 23:41:34|ONE STORY NOTHING SHOWING","cADLog":"10-23-2025 23:32:13|CALLER STATED ALARM IS DETECTING HEAT IN THE KITCHEN ADMINISTRATOR ROOM 10-23-2025 23:41:34|ONE STORY NOTHING SHOWING","alarm":null,"dispatched":null,"onScene":null,"cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":null,"timeunitclear":null,"timedispatch":null} [2025-10-24 04:44:47] [INFO] Number of extracted fields: 17 [2025-10-24 04:44:47] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e872e5ae13 [2025-10-24 04:44:48] [INFO] Created Dispatches record with ID: 68fb043f8c9882403 [2025-10-24 04:44:48] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24283.xml [2025-10-24 04:44:48] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24283.xml [2025-10-24 07:53:23] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24298.xml [2025-10-24 07:53:23] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24298.xml for user: 68d56363ec1209189 [2025-10-24 07:53:23] [INFO] File size: 1886 bytes [2025-10-24 07:53:23] [INFO] Created FTPFiles record with ID: 68fb3073358f0c04a [2025-10-24 07:53:23] [INFO] WE ARE HERE {"mappings":{"IncidentNumber":"dispatchRunNumber","house_number":"incidentLocationStreetNumber","street":"streetName","apt":"incidentLocationApt","city":"incidentLocationCity","location_name":"businessName","STATE":"incidentLocationStateName","ZIPCODE":"nERISIncidentPostalCode","LATITUDE":"nERISIncidentLatitude","LONGITUDE":"nERISIncidentLongitude","incident_type":"incidentTypeValue1","commentlist.comment":["dispatchNotes","cADLog"],"time_first_unit_assigned":["alarm","dispatched"],"time_first_unit_arrived":"onScene","time_last_unit_cleared":["cleared","inService"],"Units.Unit[0].radio_name":["cADVehicleID","name"],"Units.Unit[0].time_enroute":"timeenroutetoscene","Units.Unit[0].time_arrivedatscene":"timeonscene","Units.Unit[0].time_depart_scene":"timeunitclear","Units.Unit[0].time_assigned":"timedispatch"},"selectedRecord":{"id":"68eeb2639352dd41d","name":null},"fieldExamples":{"IncidentNumber":{"name":"IncidentNumber","value":"25-23514","type":"text"},"house_number":{"name":"house_number","value":"515","type":"number"},"street":{"name":"street","value":"LINDENWOOD AVE","type":"address"},"apt":{"name":"apt","value":"Array","type":"text"},"city":{"name":"city","value":"Array","type":"address"},"location_name":{"name":"location_name","value":"Array","type":"text"},"STATE":{"name":"STATE","value":"Array","type":"address"},"ZIPCODE":{"name":"ZIPCODE","value":"Array","type":"address"},"LATITUDE":{"name":"LATITUDE","value":"0","type":"coordinate"},"LONGITUDE":{"name":"LONGITUDE","value":"0","type":"coordinate"},"incident_type":{"name":"incident_type","value":"FIRE-GAS LEAK","type":"text"},"commentlist.comment":{"name":"comment","value":"10-14-2025 15:05:06|B45 ADVISED HE WOULD NOTIFY GAS CO 10-14-2025 15:05:23|B46 NOTHING SHOWING 10-14-2025 15:08:22|B46 ADVISED NO SMELL OF GAS HOWEVER ALARMS GOING OFF 10-14-2025 15:13:38|B46 CLEARED ","type":"text"},"time_first_unit_assigned":{"name":"time_first_unit_assigned","value":"10-14-2025T15:04:42","type":"datetime"},"time_first_unit_arrived":{"name":"time_first_unit_arrived","value":"10-14-2025T15:07:19","type":"datetime"},"time_last_unit_cleared":{"name":"time_last_unit_cleared","value":"10-14-2025T15:27:23","type":"datetime"},"Units.Unit[0].radio_name":{"name":"radio_name","value":"ENG2","type":"text"},"Units.Unit[0].time_enroute":{"name":"time_enroute","value":"10-14-2025T15:04:46","type":"datetime"},"Units.Unit[0].time_arrivedatscene":{"name":"time_arrivedatscene","value":"10-14-2025T15:08:38","type":"datetime"},"Units.Unit[0].time_depart_scene":{"name":"time_depart_scene","value":"10-14-2025T15:27:23","type":"datetime"},"Units.Unit[0].time_assigned":{"name":"time_assigned","value":"10-14-2025T15:04:42","type":"datetime"}},"timestamp":"2025-10-16T18:16:37.381Z"} [2025-10-24 07:53:23] [INFO] About to extract fields from XML. File size: 1886 bytes [2025-10-24 07:53:23] [INFO] Number of mappings: 20 [2025-10-24 07:53:23] [INFO] Starting XML parsing. Content length: 1886 [2025-10-24 07:53:23] [INFO] XML parsed successfully. Root element: Incident [2025-10-24 07:53:23] [INFO] Processing 20 field mappings [2025-10-24 07:53:23] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber' [2025-10-24 07:53:23] [INFO] -> Found value: 25-24298 [2025-10-24 07:53:23] [INFO] -> Set field 'dispatchRunNumber' = "25-24298" [2025-10-24 07:53:23] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber' [2025-10-24 07:53:23] [INFO] -> Found value: 607 [2025-10-24 07:53:23] [INFO] -> Set field 'incidentLocationStreetNumber' = 607 [2025-10-24 07:53:23] [INFO] Mapping #3: Extracting 'street' => 'streetName' [2025-10-24 07:53:23] [INFO] -> Found value: ELM ST [2025-10-24 07:53:23] [INFO] -> Set field 'streetName' = "ELM ST" [2025-10-24 07:53:23] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt' [2025-10-24 07:53:23] [INFO] -> No value found (null or empty) [2025-10-24 07:53:23] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity' [2025-10-24 07:53:23] [INFO] -> Found value: SIKESTON [2025-10-24 07:53:23] [INFO] -> Set field 'incidentLocationCity' = "SIKESTON" [2025-10-24 07:53:23] [INFO] Mapping #6: Extracting 'location_name' => 'businessName' [2025-10-24 07:53:23] [INFO] -> No value found (null or empty) [2025-10-24 07:53:23] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName' [2025-10-24 07:53:23] [INFO] -> No value found (null or empty) [2025-10-24 07:53:23] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode' [2025-10-24 07:53:23] [INFO] -> No value found (null or empty) [2025-10-24 07:53:23] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude' [2025-10-24 07:53:23] [INFO] -> Found value: 0 [2025-10-24 07:53:23] [INFO] -> Set field 'nERISIncidentLatitude' = null [2025-10-24 07:53:23] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude' [2025-10-24 07:53:23] [INFO] -> Found value: 0 [2025-10-24 07:53:23] [INFO] -> Set field 'nERISIncidentLongitude' = null [2025-10-24 07:53:23] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1' [2025-10-24 07:53:23] [INFO] -> Found value: FIRE-ALARM MECH [2025-10-24 07:53:23] [INFO] -> Set field 'incidentTypeValue1' = "FIRE-ALARM MECH" [2025-10-24 07:53:23] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"] [2025-10-24 07:53:23] [INFO] -> Found value: 10-24-2025 02:46:24|RESIDENTAL SMOKE ALARM HALL WAY NO KEYHOLDER 10-24-2025 02:48:28|PAGE 10-24-2... [2025-10-24 07:53:23] [INFO] -> Set field 'dispatchNotes' = "10-24-2025 02:46:24|RESIDENTAL SMOKE ALARM \nHALL WAY \n\nNO KEYHOLDER 10-24-2025 02:48:28|PAGE 10-24-2025 02:50:02|ONE STORY BRICK STRUCTURE NOTHING SHOWING 10-24-2025 02:52:04|MADE CONTACT WITH RESID\\ENT 10-24-2025 02:52:14|ADVISED DRY COOKING 10-24-2025 02:52:19|UNITS CAN CANCEL" [2025-10-24 07:53:23] [INFO] -> Set field 'cADLog' = "10-24-2025 02:46:24|RESIDENTAL SMOKE ALARM \nHALL WAY \n\nNO KEYHOLDER 10-24-2025 02:48:28|PAGE 10-24-2025 02:50:02|ONE STORY BRICK STRUCTURE NOTHING SHOWING 10-24-2025 02:52:04|MADE CONTACT WITH RESID\\ENT 10-24-2025 02:52:14|ADVISED DRY COOKING 10-24-2025 02:52:19|UNITS CAN CANCEL" [2025-10-24 07:53:23] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"] [2025-10-24 07:53:23] [INFO] -> Found value: 10-24-2025T02:48:17 [2025-10-24 07:53:23] [ERROR] Error formatting datetime '10-24-2025T02:48:17': Failed to parse time string (10-24-2025T02:48:17) at position 0 (1): Unexpected character [2025-10-24 07:53:23] [INFO] -> Set field 'alarm' = null [2025-10-24 07:53:23] [ERROR] Error formatting datetime '10-24-2025T02:48:17': Failed to parse time string (10-24-2025T02:48:17) at position 0 (1): Unexpected character [2025-10-24 07:53:23] [INFO] -> Set field 'dispatched' = null [2025-10-24 07:53:23] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene' [2025-10-24 07:53:23] [INFO] -> Found value: 10-24-2025T02:49:51 [2025-10-24 07:53:23] [ERROR] Error formatting datetime '10-24-2025T02:49:51': Failed to parse time string (10-24-2025T02:49:51) at position 0 (1): Unexpected character [2025-10-24 07:53:23] [INFO] -> Set field 'onScene' = null [2025-10-24 07:53:23] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"] [2025-10-24 07:53:23] [INFO] -> No value found (null or empty) [2025-10-24 07:53:23] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"] [2025-10-24 07:53:23] [INFO] -> Found value: ENG2 [2025-10-24 07:53:23] [INFO] -> Set field 'cADVehicleID' = "ENG2" [2025-10-24 07:53:23] [INFO] -> Set field 'name' = "ENG2" [2025-10-24 07:53:23] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene' [2025-10-24 07:53:23] [INFO] -> Found value: 10-24-2025T02:50:19 [2025-10-24 07:53:23] [ERROR] Error formatting datetime '10-24-2025T02:50:19': Failed to parse time string (10-24-2025T02:50:19) at position 0 (1): Unexpected character [2025-10-24 07:53:23] [INFO] -> Set field 'timeenroutetoscene' = null [2025-10-24 07:53:23] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene' [2025-10-24 07:53:23] [INFO] -> No value found (null or empty) [2025-10-24 07:53:23] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear' [2025-10-24 07:53:23] [INFO] -> Found value: 10-24-2025T02:52:26 [2025-10-24 07:53:23] [ERROR] Error formatting datetime '10-24-2025T02:52:26': Failed to parse time string (10-24-2025T02:52:26) at position 0 (1): Unexpected character [2025-10-24 07:53:23] [INFO] -> Set field 'timeunitclear' = null [2025-10-24 07:53:23] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch' [2025-10-24 07:53:23] [INFO] -> Found value: 10-24-2025T02:50:08 [2025-10-24 07:53:23] [ERROR] Error formatting datetime '10-24-2025T02:50:08': Failed to parse time string (10-24-2025T02:50:08) at position 0 (1): Unexpected character [2025-10-24 07:53:23] [INFO] -> Set field 'timedispatch' = null [2025-10-24 07:53:23] [INFO] Finished extracting fields. Total fields extracted: 17 [2025-10-24 07:53:23] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-24298","incidentLocationStreetNumber":607,"streetName":"ELM ST","incidentLocationCity":"SIKESTON","nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-ALARM MECH","dispatchNotes":"10-24-2025 02:46:24|RESIDENTAL SMOKE ALARM \nHALL WAY \n\nNO KEYHOLDER 10-24-2025 02:48:28|PAGE 10-24-2025 02:50:02|ONE STORY BRICK STRUCTURE NOTHING SHOWING 10-24-2025 02:52:04|MADE CONTACT WITH RESID\\ENT 10-24-2025 02:52:14|ADVISED DRY COOKING 10-24-2025 02:52:19|UNITS CAN CANCEL","cADLog":"10-24-2025 02:46:24|RESIDENTAL SMOKE ALARM \nHALL WAY \n\nNO KEYHOLDER 10-24-2025 02:48:28|PAGE 10-24-2025 02:50:02|ONE STORY BRICK STRUCTURE NOTHING SHOWING 10-24-2025 02:52:04|MADE CONTACT WITH RESID\\ENT 10-24-2025 02:52:14|ADVISED DRY COOKING 10-24-2025 02:52:19|UNITS CAN CANCEL","alarm":null,"dispatched":null,"onScene":null,"cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":null,"timeunitclear":null,"timedispatch":null} [2025-10-24 07:53:23] [INFO] Number of extracted fields: 17 [2025-10-24 07:53:23] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e872e5ae13 [2025-10-24 07:53:24] [INFO] Created Dispatches record with ID: 68fb307356b2667cb [2025-10-24 07:53:24] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24298.xml [2025-10-24 07:53:24] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24298.xml