[2025-11-19 00:05:43] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26997.xml
[2025-11-19 00:05:43] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26997.xml for user: 68d56363ec1209189
[2025-11-19 00:05:43] [INFO] File size: 2023 bytes
[2025-11-19 00:05:43] [INFO] Created FTPFiles record with ID: 691d09d7671ae1301
[2025-11-19 00:05:43] [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-11-19 00:05:43] [INFO] About to extract fields from XML. File size: 2023 bytes
[2025-11-19 00:05:43] [INFO] Number of mappings: 20
[2025-11-19 00:05:43] [INFO] Starting XML parsing. Content length: 2023
[2025-11-19 00:05:43] [INFO] XML parsed successfully. Root element: Incident
[2025-11-19 00:05:43] [INFO] Processing 20 field mappings
[2025-11-19 00:05:43] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-19 00:05:43] [INFO]   -> Found value: 25-26997
[2025-11-19 00:05:43] [INFO]   -> Set field 'dispatchRunNumber' = "25-26997"
[2025-11-19 00:05:43] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-19 00:05:43] [INFO]   -> Found value: 1500
[2025-11-19 00:05:43] [INFO]   -> Set field 'incidentLocationStreetNumber' = 1500
[2025-11-19 00:05:43] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-19 00:05:43] [INFO]   -> Found value: W MALONE AVE
[2025-11-19 00:05:43] [INFO]   -> Set field 'streetName' = "W MALONE AVE"
[2025-11-19 00:05:43] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-19 00:05:43] [INFO]   -> No value found (null or empty)
[2025-11-19 00:05:43] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-19 00:05:43] [INFO]   -> Found value: SIKESTON
[2025-11-19 00:05:43] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-19 00:05:43] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-19 00:05:43] [INFO]   -> Found value: ALAN WIRE - WEST MALONE
[2025-11-19 00:05:43] [INFO]   -> Set field 'businessName' = "ALAN WIRE - WEST MALONE"
[2025-11-19 00:05:43] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-19 00:05:43] [INFO]   -> Found value: MO
[2025-11-19 00:05:43] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-19 00:05:43] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-19 00:05:43] [INFO]   -> Found value: 63801
[2025-11-19 00:05:43] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-19 00:05:43] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-19 00:05:43] [INFO]   -> Found value: 0
[2025-11-19 00:05:43] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-19 00:05:43] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-19 00:05:43] [INFO]   -> Found value: 0
[2025-11-19 00:05:43] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-19 00:05:43] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-19 00:05:43] [INFO]   -> Found value: ACCIDENT-J2
[2025-11-19 00:05:43] [INFO]   -> Set field 'incidentTypeValue1' = "ACCIDENT-J2"
[2025-11-19 00:05:43] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-19 00:05:43] [INFO]   -> Found value: 11-18-2025 17:25:27|VEHICLE IN THE DITCH - UNABLE TO GET VEH. DESCRIPTION
UNSURE OF INJURIES  SUBJEC...
[2025-11-19 00:05:43] [INFO]   -> Set field 'dispatchNotes' = "11-18-2025 17:25:27|VEHICLE IN THE DITCH - UNABLE TO GET VEH. DESCRIPTION\nUNSURE OF INJURIES  SUBJECT MAY NOT BE ABLE TO GET OUT OF THE VEHICLE \nDITCH IS FULL OF WATER\n 11-18-2025 17:36:43|518 REQUESTING 10-51 11-18-2025 17:37:26|LOWES EN ROUTE 11-18-2025 17:38:44|518 ADVISED DRIVER EXTRACTED 11-18-2025 17:54:37|530 ADVISED 10-51 ON SCENE 11-18-2025 18:00:06|I SINED REFUSAL 11-18-2025 18:00:42|Disposition - SSCA:  RPT"
[2025-11-19 00:05:43] [INFO]   -> Set field 'cADLog' = "11-18-2025 17:25:27|VEHICLE IN THE DITCH - UNABLE TO GET VEH. DESCRIPTION\nUNSURE OF INJURIES  SUBJECT MAY NOT BE ABLE TO GET OUT OF THE VEHICLE \nDITCH IS FULL OF WATER\n 11-18-2025 17:36:43|518 REQUESTING 10-51 11-18-2025 17:37:26|LOWES EN ROUTE 11-18-2025 17:38:44|518 ADVISED DRIVER EXTRACTED 11-18-2025 17:54:37|530 ADVISED 10-51 ON SCENE 11-18-2025 18:00:06|I SINED REFUSAL 11-18-2025 18:00:42|Disposition - SSCA:  RPT"
[2025-11-19 00:05:43] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-19 00:05:43] [INFO]   -> Found value: 11-18-2025T17:31:10
[2025-11-19 00:05:43] [ERROR] Error formatting datetime '11-18-2025T17:31:10': Failed to parse time string (11-18-2025T17:31:10) at position 0 (1): Unexpected character
[2025-11-19 00:05:43] [INFO]   -> Set field 'alarm' = null
[2025-11-19 00:05:43] [ERROR] Error formatting datetime '11-18-2025T17:31:10': Failed to parse time string (11-18-2025T17:31:10) at position 0 (1): Unexpected character
[2025-11-19 00:05:43] [INFO]   -> Set field 'dispatched' = null
[2025-11-19 00:05:43] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-19 00:05:43] [INFO]   -> Found value: 11-18-2025T17:34:50
[2025-11-19 00:05:43] [ERROR] Error formatting datetime '11-18-2025T17:34:50': Failed to parse time string (11-18-2025T17:34:50) at position 0 (1): Unexpected character
[2025-11-19 00:05:43] [INFO]   -> Set field 'onScene' = null
[2025-11-19 00:05:43] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-19 00:05:43] [INFO]   -> No value found (null or empty)
[2025-11-19 00:05:43] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-19 00:05:43] [INFO]   -> Found value: ENG2
[2025-11-19 00:05:43] [INFO]   -> Set field 'cADVehicleID' = "ENG2"
[2025-11-19 00:05:43] [INFO]   -> Set field 'name' = "ENG2"
[2025-11-19 00:05:43] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-19 00:05:43] [INFO]   -> Found value: 11-18-2025T17:32:22
[2025-11-19 00:05:43] [ERROR] Error formatting datetime '11-18-2025T17:32:22': Failed to parse time string (11-18-2025T17:32:22) at position 0 (1): Unexpected character
[2025-11-19 00:05:43] [INFO]   -> Set field 'timeenroutetoscene' = null
[2025-11-19 00:05:43] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-19 00:05:43] [INFO]   -> Found value: 11-18-2025T17:34:50
[2025-11-19 00:05:43] [ERROR] Error formatting datetime '11-18-2025T17:34:50': Failed to parse time string (11-18-2025T17:34:50) at position 0 (1): Unexpected character
[2025-11-19 00:05:43] [INFO]   -> Set field 'timeonscene' = null
[2025-11-19 00:05:43] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-19 00:05:43] [INFO]   -> Found value: 11-18-2025T18:05:20
[2025-11-19 00:05:43] [ERROR] Error formatting datetime '11-18-2025T18:05:20': Failed to parse time string (11-18-2025T18:05:20) at position 0 (1): Unexpected character
[2025-11-19 00:05:43] [INFO]   -> Set field 'timeunitclear' = null
[2025-11-19 00:05:43] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-19 00:05:43] [INFO]   -> No value found (null or empty)
[2025-11-19 00:05:43] [INFO] Finished extracting fields. Total fields extracted: 20
[2025-11-19 00:05:43] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-26997","incidentLocationStreetNumber":1500,"streetName":"W MALONE AVE","incidentLocationCity":"SIKESTON","businessName":"ALAN WIRE - WEST MALONE","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"ACCIDENT-J2","dispatchNotes":"11-18-2025 17:25:27|VEHICLE IN THE DITCH - UNABLE TO GET VEH. DESCRIPTION\nUNSURE OF INJURIES  SUBJECT MAY NOT BE ABLE TO GET OUT OF THE VEHICLE \nDITCH IS FULL OF WATER\n 11-18-2025 17:36:43|518 REQUESTING 10-51 11-18-2025 17:37:26|LOWES EN ROUTE 11-18-2025 17:38:44|518 ADVISED DRIVER EXTRACTED 11-18-2025 17:54:37|530 ADVISED 10-51 ON SCENE 11-18-2025 18:00:06|I SINED REFUSAL 11-18-2025 18:00:42|Disposition - SSCA:  RPT","cADLog":"11-18-2025 17:25:27|VEHICLE IN THE DITCH - UNABLE TO GET VEH. DESCRIPTION\nUNSURE OF INJURIES  SUBJECT MAY NOT BE ABLE TO GET OUT OF THE VEHICLE \nDITCH IS FULL OF WATER\n 11-18-2025 17:36:43|518 REQUESTING 10-51 11-18-2025 17:37:26|LOWES EN ROUTE 11-18-2025 17:38:44|518 ADVISED DRIVER EXTRACTED 11-18-2025 17:54:37|530 ADVISED 10-51 ON SCENE 11-18-2025 18:00:06|I SINED REFUSAL 11-18-2025 18:00:42|Disposition - SSCA:  RPT","alarm":null,"dispatched":null,"onScene":null,"cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":null,"timeonscene":null,"timeunitclear":null}
[2025-11-19 00:05:43] [INFO] Number of extracted fields: 20
[2025-11-19 00:05:43] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e87be42b7c
[2025-11-19 00:05:44] [INFO] Created Dispatches record with ID: 691d09d789bfaad3a
[2025-11-19 00:05:44] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26997.xml
[2025-11-19 00:05:44] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26997.xml
[2025-11-19 00:13:49] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27004.xml
[2025-11-19 00:13:49] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27004.xml for user: 68d56363ec1209189
[2025-11-19 00:13:49] [INFO] File size: 1894 bytes
[2025-11-19 00:13:49] [INFO] Created FTPFiles record with ID: 691d0bbd588fae9c3
[2025-11-19 00:13:49] [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-11-19 00:13:49] [INFO] About to extract fields from XML. File size: 1894 bytes
[2025-11-19 00:13:49] [INFO] Number of mappings: 20
[2025-11-19 00:13:49] [INFO] Starting XML parsing. Content length: 1894
[2025-11-19 00:13:49] [INFO] XML parsed successfully. Root element: Incident
[2025-11-19 00:13:49] [INFO] Processing 20 field mappings
[2025-11-19 00:13:49] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-19 00:13:49] [INFO]   -> Found value: 25-27004
[2025-11-19 00:13:49] [INFO]   -> Set field 'dispatchRunNumber' = "25-27004"
[2025-11-19 00:13:49] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-19 00:13:49] [INFO]   -> No value found (null or empty)
[2025-11-19 00:13:49] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-19 00:13:49] [INFO]   -> Found value: STATE HIGHWAY 114
[2025-11-19 00:13:49] [INFO]   -> Set field 'streetName' = "STATE HIGHWAY 114"
[2025-11-19 00:13:49] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-19 00:13:49] [INFO]   -> No value found (null or empty)
[2025-11-19 00:13:49] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-19 00:13:49] [INFO]   -> Found value: SIKESTON
[2025-11-19 00:13:49] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-19 00:13:49] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-19 00:13:49] [INFO]   -> No value found (null or empty)
[2025-11-19 00:13:49] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-19 00:13:49] [INFO]   -> No value found (null or empty)
[2025-11-19 00:13:49] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-19 00:13:49] [INFO]   -> No value found (null or empty)
[2025-11-19 00:13:49] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-19 00:13:49] [INFO]   -> Found value: 0
[2025-11-19 00:13:49] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-19 00:13:49] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-19 00:13:49] [INFO]   -> Found value: 0
[2025-11-19 00:13:49] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-19 00:13:49] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-19 00:13:49] [INFO]   -> Found value: RESCUE
[2025-11-19 00:13:49] [INFO]   -> Set field 'incidentTypeValue1' = "RESCUE"
[2025-11-19 00:13:49] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-19 00:13:49] [INFO]   -> Found value: 11-18-2025 18:03:29|518 WAS ADVISED BY ANOTHER SUBJECT THAT THERE IS ANOTHER VEHICLE IN THE DITCH 
U...
[2025-11-19 00:13:49] [INFO]   -> Set field 'dispatchNotes' = "11-18-2025 18:03:29|518 WAS ADVISED BY ANOTHER SUBJECT THAT THERE IS ANOTHER VEHICLE IN THE DITCH \nUNKNOWN FURTHER 11-18-2025 18:06:43|518 ADVISED TO CANCEL  SLIDE OFF  NO INJURIES 11-18-2025 18:07:05|518 ADVISED SLID OFF NO INJURIES NO ENTRAPMENT ON FF AND 114 11-18-2025 18:07:39|FEMALE IS NOT REQUESTING REPORT  HAS 10-51 EN ROUTE FROM MATTHEWS"
[2025-11-19 00:13:49] [INFO]   -> Set field 'cADLog' = "11-18-2025 18:03:29|518 WAS ADVISED BY ANOTHER SUBJECT THAT THERE IS ANOTHER VEHICLE IN THE DITCH \nUNKNOWN FURTHER 11-18-2025 18:06:43|518 ADVISED TO CANCEL  SLIDE OFF  NO INJURIES 11-18-2025 18:07:05|518 ADVISED SLID OFF NO INJURIES NO ENTRAPMENT ON FF AND 114 11-18-2025 18:07:39|FEMALE IS NOT REQUESTING REPORT  HAS 10-51 EN ROUTE FROM MATTHEWS"
[2025-11-19 00:13:49] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-19 00:13:49] [INFO]   -> Found value: 11-18-2025T18:04:40
[2025-11-19 00:13:49] [ERROR] Error formatting datetime '11-18-2025T18:04:40': Failed to parse time string (11-18-2025T18:04:40) at position 0 (1): Unexpected character
[2025-11-19 00:13:49] [INFO]   -> Set field 'alarm' = null
[2025-11-19 00:13:49] [ERROR] Error formatting datetime '11-18-2025T18:04:40': Failed to parse time string (11-18-2025T18:04:40) at position 0 (1): Unexpected character
[2025-11-19 00:13:49] [INFO]   -> Set field 'dispatched' = null
[2025-11-19 00:13:49] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-19 00:13:49] [INFO]   -> No value found (null or empty)
[2025-11-19 00:13:49] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-19 00:13:49] [INFO]   -> No value found (null or empty)
[2025-11-19 00:13:49] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-19 00:13:49] [INFO]   -> Found value: ENG2
[2025-11-19 00:13:49] [INFO]   -> Set field 'cADVehicleID' = "ENG2"
[2025-11-19 00:13:49] [INFO]   -> Set field 'name' = "ENG2"
[2025-11-19 00:13:49] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-19 00:13:49] [INFO]   -> Found value: 11-18-2025T18:05:51
[2025-11-19 00:13:49] [ERROR] Error formatting datetime '11-18-2025T18:05:51': Failed to parse time string (11-18-2025T18:05:51) at position 0 (1): Unexpected character
[2025-11-19 00:13:49] [INFO]   -> Set field 'timeenroutetoscene' = null
[2025-11-19 00:13:49] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-19 00:13:49] [INFO]   -> No value found (null or empty)
[2025-11-19 00:13:49] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-19 00:13:49] [INFO]   -> Found value: 11-18-2025T18:06:47
[2025-11-19 00:13:49] [ERROR] Error formatting datetime '11-18-2025T18:06:47': Failed to parse time string (11-18-2025T18:06:47) at position 0 (1): Unexpected character
[2025-11-19 00:13:49] [INFO]   -> Set field 'timeunitclear' = null
[2025-11-19 00:13:49] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-19 00:13:49] [INFO]   -> No value found (null or empty)
[2025-11-19 00:13:49] [INFO] Finished extracting fields. Total fields extracted: 14
[2025-11-19 00:13:49] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-27004","streetName":"STATE HIGHWAY 114","incidentLocationCity":"SIKESTON","nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"RESCUE","dispatchNotes":"11-18-2025 18:03:29|518 WAS ADVISED BY ANOTHER SUBJECT THAT THERE IS ANOTHER VEHICLE IN THE DITCH \nUNKNOWN FURTHER 11-18-2025 18:06:43|518 ADVISED TO CANCEL  SLIDE OFF  NO INJURIES 11-18-2025 18:07:05|518 ADVISED SLID OFF NO INJURIES NO ENTRAPMENT ON FF AND 114 11-18-2025 18:07:39|FEMALE IS NOT REQUESTING REPORT  HAS 10-51 EN ROUTE FROM MATTHEWS","cADLog":"11-18-2025 18:03:29|518 WAS ADVISED BY ANOTHER SUBJECT THAT THERE IS ANOTHER VEHICLE IN THE DITCH \nUNKNOWN FURTHER 11-18-2025 18:06:43|518 ADVISED TO CANCEL  SLIDE OFF  NO INJURIES 11-18-2025 18:07:05|518 ADVISED SLID OFF NO INJURIES NO ENTRAPMENT ON FF AND 114 11-18-2025 18:07:39|FEMALE IS NOT REQUESTING REPORT  HAS 10-51 EN ROUTE FROM MATTHEWS","alarm":null,"dispatched":null,"cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":null,"timeunitclear":null}
[2025-11-19 00:13:49] [INFO] Number of extracted fields: 14
[2025-11-19 00:13:49] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e86df03b7f
[2025-11-19 00:13:50] [INFO] Created Dispatches record with ID: 691d0bbd7b1c4434e
[2025-11-19 00:13:50] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27004.xml
[2025-11-19 00:13:50] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27004.xml
[2025-11-19 01:31:52] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27005.xml
[2025-11-19 01:31:52] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27005.xml for user: 68d56363ec1209189
[2025-11-19 01:31:52] [INFO] File size: 2142 bytes
[2025-11-19 01:31:53] [INFO] Created FTPFiles record with ID: 691d1e09e27db4de2
[2025-11-19 01:31:53] [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-11-19 01:31:53] [INFO] About to extract fields from XML. File size: 2142 bytes
[2025-11-19 01:31:53] [INFO] Number of mappings: 20
[2025-11-19 01:31:53] [INFO] Starting XML parsing. Content length: 2142
[2025-11-19 01:31:53] [INFO] XML parsed successfully. Root element: Incident
[2025-11-19 01:31:53] [INFO] Processing 20 field mappings
[2025-11-19 01:31:53] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-19 01:31:53] [INFO]   -> Found value: 25-27005
[2025-11-19 01:31:53] [INFO]   -> Set field 'dispatchRunNumber' = "25-27005"
[2025-11-19 01:31:53] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-19 01:31:53] [INFO]   -> Found value: 1213
[2025-11-19 01:31:53] [INFO]   -> Set field 'incidentLocationStreetNumber' = 1213
[2025-11-19 01:31:53] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-19 01:31:53] [INFO]   -> Found value: S MAIN ST
[2025-11-19 01:31:53] [INFO]   -> Set field 'streetName' = "S MAIN ST"
[2025-11-19 01:31:53] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-19 01:31:53] [INFO]   -> Found value: S 225
[2025-11-19 01:31:53] [INFO]   -> Set field 'incidentLocationApt' = "S 225"
[2025-11-19 01:31:53] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-19 01:31:53] [INFO]   -> Found value: SIKESTON
[2025-11-19 01:31:53] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-19 01:31:53] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-19 01:31:53] [INFO]   -> Found value: CATO'S
[2025-11-19 01:31:53] [INFO]   -> Set field 'businessName' = "CATO'S"
[2025-11-19 01:31:53] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-19 01:31:53] [INFO]   -> Found value: MO
[2025-11-19 01:31:53] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-19 01:31:53] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-19 01:31:53] [INFO]   -> Found value: 63801
[2025-11-19 01:31:53] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-19 01:31:53] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-19 01:31:53] [INFO]   -> Found value: 0
[2025-11-19 01:31:53] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-19 01:31:53] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-19 01:31:53] [INFO]   -> Found value: 0
[2025-11-19 01:31:53] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-19 01:31:53] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-19 01:31:53] [INFO]   -> Found value: FIRE-SMOKE INVESTIGATION
[2025-11-19 01:31:53] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-SMOKE INVESTIGATION"
[2025-11-19 01:31:53] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-19 01:31:53] [INFO]   -> Found value: 11-18-2025 18:50:58|CALLER STATED RAIN HAS CAME THROUGH THE WALLS AND NOW IT SMELLS LIKE SOMETHING I...
[2025-11-19 01:31:53] [INFO]   -> Set field 'dispatchNotes' = "11-18-2025 18:50:58|CALLER STATED RAIN HAS CAME THROUGH THE WALLS AND NOW IT SMELLS LIKE SOMETHING IS BURNING \nNO VISIBLE SMOKE OR FIRE\n 11-18-2025 19:01:51|SINGLE STORY COMMERCIAL STRUCTURE NOTHING SHOW"
[2025-11-19 01:31:53] [INFO]   -> Set field 'cADLog' = "11-18-2025 18:50:58|CALLER STATED RAIN HAS CAME THROUGH THE WALLS AND NOW IT SMELLS LIKE SOMETHING IS BURNING \nNO VISIBLE SMOKE OR FIRE\n 11-18-2025 19:01:51|SINGLE STORY COMMERCIAL STRUCTURE NOTHING SHOW"
[2025-11-19 01:31:53] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-19 01:31:53] [INFO]   -> Found value: 11-18-2025T18:56:19
[2025-11-19 01:31:53] [ERROR] Error formatting datetime '11-18-2025T18:56:19': Failed to parse time string (11-18-2025T18:56:19) at position 0 (1): Unexpected character
[2025-11-19 01:31:53] [INFO]   -> Set field 'alarm' = null
[2025-11-19 01:31:53] [ERROR] Error formatting datetime '11-18-2025T18:56:19': Failed to parse time string (11-18-2025T18:56:19) at position 0 (1): Unexpected character
[2025-11-19 01:31:53] [INFO]   -> Set field 'dispatched' = null
[2025-11-19 01:31:53] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-19 01:31:53] [INFO]   -> Found value: 11-18-2025T19:01:58
[2025-11-19 01:31:53] [ERROR] Error formatting datetime '11-18-2025T19:01:58': Failed to parse time string (11-18-2025T19:01:58) at position 0 (1): Unexpected character
[2025-11-19 01:31:53] [INFO]   -> Set field 'onScene' = null
[2025-11-19 01:31:53] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-19 01:31:53] [INFO]   -> Found value: 11-18-2025T19:31:18
[2025-11-19 01:31:53] [ERROR] Error formatting datetime '11-18-2025T19:31:18': Failed to parse time string (11-18-2025T19:31:18) at position 0 (1): Unexpected character
[2025-11-19 01:31:53] [INFO]   -> Set field 'cleared' = null
[2025-11-19 01:31:53] [ERROR] Error formatting datetime '11-18-2025T19:31:18': Failed to parse time string (11-18-2025T19:31:18) at position 0 (1): Unexpected character
[2025-11-19 01:31:53] [INFO]   -> Set field 'inService' = null
[2025-11-19 01:31:53] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-19 01:31:53] [INFO]   -> Found value: ENG2
[2025-11-19 01:31:53] [INFO]   -> Set field 'cADVehicleID' = "ENG2"
[2025-11-19 01:31:53] [INFO]   -> Set field 'name' = "ENG2"
[2025-11-19 01:31:53] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-19 01:31:53] [INFO]   -> Found value: 11-18-2025T18:58:11
[2025-11-19 01:31:53] [ERROR] Error formatting datetime '11-18-2025T18:58:11': Failed to parse time string (11-18-2025T18:58:11) at position 0 (1): Unexpected character
[2025-11-19 01:31:53] [INFO]   -> Set field 'timeenroutetoscene' = null
[2025-11-19 01:31:53] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-19 01:31:53] [INFO]   -> Found value: 11-18-2025T19:02:37
[2025-11-19 01:31:53] [ERROR] Error formatting datetime '11-18-2025T19:02:37': Failed to parse time string (11-18-2025T19:02:37) at position 0 (1): Unexpected character
[2025-11-19 01:31:53] [INFO]   -> Set field 'timeonscene' = null
[2025-11-19 01:31:53] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-19 01:31:53] [INFO]   -> Found value: 11-18-2025T19:31:18
[2025-11-19 01:31:53] [ERROR] Error formatting datetime '11-18-2025T19:31:18': Failed to parse time string (11-18-2025T19:31:18) at position 0 (1): Unexpected character
[2025-11-19 01:31:53] [INFO]   -> Set field 'timeunitclear' = null
[2025-11-19 01:31:53] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-19 01:31:53] [INFO]   -> Found value: 11-18-2025T18:58:09
[2025-11-19 01:31:53] [ERROR] Error formatting datetime '11-18-2025T18:58:09': Failed to parse time string (11-18-2025T18:58:09) at position 0 (1): Unexpected character
[2025-11-19 01:31:53] [INFO]   -> Set field 'timedispatch' = null
[2025-11-19 01:31:53] [INFO] Finished extracting fields. Total fields extracted: 24
[2025-11-19 01:31:53] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-27005","incidentLocationStreetNumber":1213,"streetName":"S MAIN ST","incidentLocationApt":"S 225","incidentLocationCity":"SIKESTON","businessName":"CATO'S","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-SMOKE INVESTIGATION","dispatchNotes":"11-18-2025 18:50:58|CALLER STATED RAIN HAS CAME THROUGH THE WALLS AND NOW IT SMELLS LIKE SOMETHING IS BURNING \nNO VISIBLE SMOKE OR FIRE\n 11-18-2025 19:01:51|SINGLE STORY COMMERCIAL STRUCTURE NOTHING SHOW","cADLog":"11-18-2025 18:50:58|CALLER STATED RAIN HAS CAME THROUGH THE WALLS AND NOW IT SMELLS LIKE SOMETHING IS BURNING \nNO VISIBLE SMOKE OR FIRE\n 11-18-2025 19:01:51|SINGLE STORY COMMERCIAL STRUCTURE NOTHING SHOW","alarm":null,"dispatched":null,"onScene":null,"cleared":null,"inService":null,"cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":null,"timeonscene":null,"timeunitclear":null,"timedispatch":null}
[2025-11-19 01:31:53] [INFO] Number of extracted fields: 24
[2025-11-19 01:31:54] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e8812ca0da
[2025-11-19 01:31:54] [INFO] Created Dispatches record with ID: 691d1e0a103c85739
[2025-11-19 01:31:54] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27005.xml
[2025-11-19 01:31:54] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27005.xml
[2025-11-19 04:56:46] [ERROR] No file path provided.
[2025-11-19 05:03:49] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27015.xml
[2025-11-19 05:03:49] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27015.xml for user: 68d56363ec1209189
[2025-11-19 05:03:49] [INFO] File size: 2390 bytes
[2025-11-19 05:03:49] [INFO] Created FTPFiles record with ID: 691d4fb585d587aaf
[2025-11-19 05:03:49] [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-11-19 05:03:49] [INFO] About to extract fields from XML. File size: 2390 bytes
[2025-11-19 05:03:49] [INFO] Number of mappings: 20
[2025-11-19 05:03:49] [INFO] Starting XML parsing. Content length: 2390
[2025-11-19 05:03:49] [INFO] XML parsed successfully. Root element: Incident
[2025-11-19 05:03:49] [INFO] Processing 20 field mappings
[2025-11-19 05:03:49] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-19 05:03:49] [INFO]   -> Found value: 25-27015
[2025-11-19 05:03:49] [INFO]   -> Set field 'dispatchRunNumber' = "25-27015"
[2025-11-19 05:03:49] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-19 05:03:49] [INFO]   -> No value found (null or empty)
[2025-11-19 05:03:49] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-19 05:03:49] [INFO]   -> Found value: STATE HIGHWAY AA
[2025-11-19 05:03:49] [INFO]   -> Set field 'streetName' = "STATE HIGHWAY AA"
[2025-11-19 05:03:49] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-19 05:03:49] [INFO]   -> No value found (null or empty)
[2025-11-19 05:03:49] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-19 05:03:49] [INFO]   -> No value found (null or empty)
[2025-11-19 05:03:49] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-19 05:03:49] [INFO]   -> No value found (null or empty)
[2025-11-19 05:03:49] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-19 05:03:49] [INFO]   -> No value found (null or empty)
[2025-11-19 05:03:49] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-19 05:03:49] [INFO]   -> No value found (null or empty)
[2025-11-19 05:03:49] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-19 05:03:49] [INFO]   -> Found value: 0
[2025-11-19 05:03:49] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-19 05:03:49] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-19 05:03:49] [INFO]   -> Found value: 0
[2025-11-19 05:03:49] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-19 05:03:49] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-19 05:03:49] [INFO]   -> Found value: RESCUE
[2025-11-19 05:03:49] [INFO]   -> Set field 'incidentTypeValue1' = "RESCUE"
[2025-11-19 05:03:49] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-19 05:03:49] [INFO]   -> Found value: 11-18-2025 21:22:51|Call Received on 11/18/2025 @ 21:22
2 VEHICLES 
ONE SUBJECT TRAPPED POSSIBLE BRO...
[2025-11-19 05:03:49] [INFO]   -> Set field 'dispatchNotes' = "11-18-2025 21:22:51|Call Received on 11\/18\/2025 @ 21:22\n2 VEHICLES \nONE SUBJECT TRAPPED POSSIBLE BROKEN LEG \n\n 11-18-2025 21:25:33|NMCO CONTACTED FOR EMS 11-18-2025 21:28:41|ROADWAY IS BLOCKED 11-18-2025 21:34:46|NMCO ADVISED ADDITIONAL EMS NEEDED 11-18-2025 21:36:40|MSHP CONTACTED  ON SCENE 11-18-2025 21:38:44|C88 3 PATIENTS WORKING EXTRICATION 11-18-2025 21:41:39|C88 SUBJECT TRAPPED HAS COMPOUND FRACTURE TO LEG 11-18-2025 21:42:26|2 MAY NEED TO BE FLOWN 11-18-2025 21:43:34|NMCO ADVISED TO NOTIFY AIR EVAC 11-18-2025 21:51:47|PATIENT EXTRICATED 11-18-2025 21:55:33|SECOND PAGE FOR EMS 11-18-2025 21:55:41|SSCAD NEEDED PER C87 11-18-2025 22:00:12|21 YR OLD FEMALE BACK AND ANKLE PAIN ALERT AND ORIENTED X3 SELF EXTRICATED  PACKAGING NOW 11-18-2025 22:26:35|555 STANDING BY TO ASSIST WITH TRAFFIC"
[2025-11-19 05:03:49] [INFO]   -> Set field 'cADLog' = "11-18-2025 21:22:51|Call Received on 11\/18\/2025 @ 21:22\n2 VEHICLES \nONE SUBJECT TRAPPED POSSIBLE BROKEN LEG \n\n 11-18-2025 21:25:33|NMCO CONTACTED FOR EMS 11-18-2025 21:28:41|ROADWAY IS BLOCKED 11-18-2025 21:34:46|NMCO ADVISED ADDITIONAL EMS NEEDED 11-18-2025 21:36:40|MSHP CONTACTED  ON SCENE 11-18-2025 21:38:44|C88 3 PATIENTS WORKING EXTRICATION 11-18-2025 21:41:39|C88 SUBJECT TRAPPED HAS COMPOUND FRACTURE TO LEG 11-18-2025 21:42:26|2 MAY NEED TO BE FLOWN 11-18-2025 21:43:34|NMCO ADVISED TO NOTIFY AIR EVAC 11-18-2025 21:51:47|PATIENT EXTRICATED 11-18-2025 21:55:33|SECOND PAGE FOR EMS 11-18-2025 21:55:41|SSCAD NEEDED PER C87 11-18-2025 22:00:12|21 YR OLD FEMALE BACK AND ANKLE PAIN ALERT AND ORIENTED X3 SELF EXTRICATED  PACKAGING NOW 11-18-2025 22:26:35|555 STANDING BY TO ASSIST WITH TRAFFIC"
[2025-11-19 05:03:49] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-19 05:03:49] [INFO]   -> Found value: 11-18-2025T21:27:06
[2025-11-19 05:03:49] [ERROR] Error formatting datetime '11-18-2025T21:27:06': Failed to parse time string (11-18-2025T21:27:06) at position 0 (1): Unexpected character
[2025-11-19 05:03:49] [INFO]   -> Set field 'alarm' = null
[2025-11-19 05:03:49] [ERROR] Error formatting datetime '11-18-2025T21:27:06': Failed to parse time string (11-18-2025T21:27:06) at position 0 (1): Unexpected character
[2025-11-19 05:03:49] [INFO]   -> Set field 'dispatched' = null
[2025-11-19 05:03:49] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-19 05:03:49] [INFO]   -> Found value: 11-18-2025T21:37:55
[2025-11-19 05:03:49] [ERROR] Error formatting datetime '11-18-2025T21:37:55': Failed to parse time string (11-18-2025T21:37:55) at position 0 (1): Unexpected character
[2025-11-19 05:03:49] [INFO]   -> Set field 'onScene' = null
[2025-11-19 05:03:49] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-19 05:03:49] [INFO]   -> No value found (null or empty)
[2025-11-19 05:03:49] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-19 05:03:49] [INFO]   -> Found value: ENG2
[2025-11-19 05:03:49] [INFO]   -> Set field 'cADVehicleID' = "ENG2"
[2025-11-19 05:03:49] [INFO]   -> Set field 'name' = "ENG2"
[2025-11-19 05:03:49] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-19 05:03:49] [INFO]   -> Found value: 11-18-2025T21:33:10
[2025-11-19 05:03:49] [ERROR] Error formatting datetime '11-18-2025T21:33:10': Failed to parse time string (11-18-2025T21:33:10) at position 0 (1): Unexpected character
[2025-11-19 05:03:49] [INFO]   -> Set field 'timeenroutetoscene' = null
[2025-11-19 05:03:49] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-19 05:03:49] [INFO]   -> Found value: 11-18-2025T21:41:52
[2025-11-19 05:03:49] [ERROR] Error formatting datetime '11-18-2025T21:41:52': Failed to parse time string (11-18-2025T21:41:52) at position 0 (1): Unexpected character
[2025-11-19 05:03:49] [INFO]   -> Set field 'timeonscene' = null
[2025-11-19 05:03:49] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-19 05:03:49] [INFO]   -> Found value: 11-18-2025T23:02:59
[2025-11-19 05:03:49] [ERROR] Error formatting datetime '11-18-2025T23:02:59': Failed to parse time string (11-18-2025T23:02:59) at position 0 (1): Unexpected character
[2025-11-19 05:03:49] [INFO]   -> Set field 'timeunitclear' = null
[2025-11-19 05:03:49] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-19 05:03:49] [INFO]   -> Found value: 11-18-2025T21:32:43
[2025-11-19 05:03:49] [ERROR] Error formatting datetime '11-18-2025T21:32:43': Failed to parse time string (11-18-2025T21:32:43) at position 0 (1): Unexpected character
[2025-11-19 05:03:49] [INFO]   -> Set field 'timedispatch' = null
[2025-11-19 05:03:49] [INFO] Finished extracting fields. Total fields extracted: 16
[2025-11-19 05:03:49] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-27015","streetName":"STATE HIGHWAY AA","nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"RESCUE","dispatchNotes":"11-18-2025 21:22:51|Call Received on 11\/18\/2025 @ 21:22\n2 VEHICLES \nONE SUBJECT TRAPPED POSSIBLE BROKEN LEG \n\n 11-18-2025 21:25:33|NMCO CONTACTED FOR EMS 11-18-2025 21:28:41|ROADWAY IS BLOCKED 11-18-2025 21:34:46|NMCO ADVISED ADDITIONAL EMS NEEDED 11-18-2025 21:36:40|MSHP CONTACTED  ON SCENE 11-18-2025 21:38:44|C88 3 PATIENTS WORKING EXTRICATION 11-18-2025 21:41:39|C88 SUBJECT TRAPPED HAS COMPOUND FRACTURE TO LEG 11-18-2025 21:42:26|2 MAY NEED TO BE FLOWN 11-18-2025 21:43:34|NMCO ADVISED TO NOTIFY AIR EVAC 11-18-2025 21:51:47|PATIENT EXTRICATED 11-18-2025 21:55:33|SECOND PAGE FOR EMS 11-18-2025 21:55:41|SSCAD NEEDED PER C87 11-18-2025 22:00:12|21 YR OLD FEMALE BACK AND ANKLE PAIN ALERT AND ORIENTED X3 SELF EXTRICATED  PACKAGING NOW 11-18-2025 22:26:35|555 STANDING BY TO ASSIST WITH TRAFFIC","cADLog":"11-18-2025 21:22:51|Call Received on 11\/18\/2025 @ 21:22\n2 VEHICLES \nONE SUBJECT TRAPPED POSSIBLE BROKEN LEG \n\n 11-18-2025 21:25:33|NMCO CONTACTED FOR EMS 11-18-2025 21:28:41|ROADWAY IS BLOCKED 11-18-2025 21:34:46|NMCO ADVISED ADDITIONAL EMS NEEDED 11-18-2025 21:36:40|MSHP CONTACTED  ON SCENE 11-18-2025 21:38:44|C88 3 PATIENTS WORKING EXTRICATION 11-18-2025 21:41:39|C88 SUBJECT TRAPPED HAS COMPOUND FRACTURE TO LEG 11-18-2025 21:42:26|2 MAY NEED TO BE FLOWN 11-18-2025 21:43:34|NMCO ADVISED TO NOTIFY AIR EVAC 11-18-2025 21:51:47|PATIENT EXTRICATED 11-18-2025 21:55:33|SECOND PAGE FOR EMS 11-18-2025 21:55:41|SSCAD NEEDED PER C87 11-18-2025 22:00:12|21 YR OLD FEMALE BACK AND ANKLE PAIN ALERT AND ORIENTED X3 SELF EXTRICATED  PACKAGING NOW 11-18-2025 22:26:35|555 STANDING BY TO ASSIST WITH TRAFFIC","alarm":null,"dispatched":null,"onScene":null,"cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":null,"timeonscene":null,"timeunitclear":null,"timedispatch":null}
[2025-11-19 05:03:49] [INFO] Number of extracted fields: 16
[2025-11-19 05:03:49] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e86df03b7f
[2025-11-19 05:03:50] [INFO] Created Dispatches record with ID: 691d4fb5a39b55cc5
[2025-11-19 05:03:50] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27015.xml
[2025-11-19 05:03:50] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27015.xml
[2025-11-19 11:40:22] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27032.xml
[2025-11-19 11:40:22] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27032.xml for user: 68d56363ec1209189
[2025-11-19 11:40:22] [INFO] File size: 2547 bytes
[2025-11-19 11:40:22] [INFO] Created FTPFiles record with ID: 691daca6516f1bd13
[2025-11-19 11:40:22] [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-11-19 11:40:22] [INFO] About to extract fields from XML. File size: 2547 bytes
[2025-11-19 11:40:22] [INFO] Number of mappings: 20
[2025-11-19 11:40:22] [INFO] Starting XML parsing. Content length: 2547
[2025-11-19 11:40:22] [INFO] XML parsed successfully. Root element: Incident
[2025-11-19 11:40:22] [INFO] Processing 20 field mappings
[2025-11-19 11:40:22] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-19 11:40:22] [INFO]   -> Found value: 25-27032
[2025-11-19 11:40:22] [INFO]   -> Set field 'dispatchRunNumber' = "25-27032"
[2025-11-19 11:40:22] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-19 11:40:22] [INFO]   -> Found value: 302
[2025-11-19 11:40:22] [INFO]   -> Set field 'incidentLocationStreetNumber' = 302
[2025-11-19 11:40:22] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-19 11:40:22] [INFO]   -> Found value: STALLCUP DR
[2025-11-19 11:40:22] [INFO]   -> Set field 'streetName' = "STALLCUP DR"
[2025-11-19 11:40:22] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-19 11:40:22] [INFO]   -> No value found (null or empty)
[2025-11-19 11:40:22] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-19 11:40:22] [INFO]   -> Found value: SIKESTON
[2025-11-19 11:40:22] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-19 11:40:22] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-19 11:40:22] [INFO]   -> Found value: ANNIE'S GARDEN SKILLED NURSING
[2025-11-19 11:40:22] [INFO]   -> Set field 'businessName' = "ANNIE'S GARDEN SKILLED NURSING"
[2025-11-19 11:40:22] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-19 11:40:22] [INFO]   -> Found value: MO
[2025-11-19 11:40:22] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-19 11:40:22] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-19 11:40:22] [INFO]   -> Found value: 63801
[2025-11-19 11:40:22] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-19 11:40:22] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-19 11:40:22] [INFO]   -> Found value: 0
[2025-11-19 11:40:22] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-19 11:40:22] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-19 11:40:22] [INFO]   -> Found value: 0
[2025-11-19 11:40:22] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-19 11:40:22] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-19 11:40:22] [INFO]   -> Found value: FIRE-ALARM MECH
[2025-11-19 11:40:22] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-ALARM MECH"
[2025-11-19 11:40:22] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-19 11:40:22] [INFO]   -> Found value: 11-19-2025 05:01:12|SMOKE DETECTOR GENERAL 


 11-19-2025 05:09:05|554 ON SCENE ADVISED ACTIVE ALARM...
[2025-11-19 11:40:22] [INFO]   -> Set field 'dispatchNotes' = "11-19-2025 05:01:12|SMOKE DETECTOR GENERAL \n\n\n 11-19-2025 05:09:05|554 ON SCENE ADVISED ACTIVE ALARM 500 HALL 11-19-2025 05:10:24|C92 ADVISED SINGLE STORY STRUCTURE NOTHING SHOWING 11-19-2025 05:28:52|FALSE ALARM 11-19-2025 05:28:58|ALARM HAS BEEN RESET 11-19-2025 05:29:14|Disposition - SDPS PD:  NRN"
[2025-11-19 11:40:22] [INFO]   -> Set field 'cADLog' = "11-19-2025 05:01:12|SMOKE DETECTOR GENERAL \n\n\n 11-19-2025 05:09:05|554 ON SCENE ADVISED ACTIVE ALARM 500 HALL 11-19-2025 05:10:24|C92 ADVISED SINGLE STORY STRUCTURE NOTHING SHOWING 11-19-2025 05:28:52|FALSE ALARM 11-19-2025 05:28:58|ALARM HAS BEEN RESET 11-19-2025 05:29:14|Disposition - SDPS PD:  NRN"
[2025-11-19 11:40:22] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-19 11:40:22] [INFO]   -> Found value: 11-19-2025T05:04:01
[2025-11-19 11:40:22] [ERROR] Error formatting datetime '11-19-2025T05:04:01': Failed to parse time string (11-19-2025T05:04:01) at position 0 (1): Unexpected character
[2025-11-19 11:40:22] [INFO]   -> Set field 'alarm' = null
[2025-11-19 11:40:22] [ERROR] Error formatting datetime '11-19-2025T05:04:01': Failed to parse time string (11-19-2025T05:04:01) at position 0 (1): Unexpected character
[2025-11-19 11:40:22] [INFO]   -> Set field 'dispatched' = null
[2025-11-19 11:40:22] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-19 11:40:22] [INFO]   -> Found value: 11-19-2025T05:07:09
[2025-11-19 11:40:22] [ERROR] Error formatting datetime '11-19-2025T05:07:09': Failed to parse time string (11-19-2025T05:07:09) at position 0 (1): Unexpected character
[2025-11-19 11:40:22] [INFO]   -> Set field 'onScene' = null
[2025-11-19 11:40:22] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-19 11:40:22] [INFO]   -> Found value: 11-19-2025T05:39:42
[2025-11-19 11:40:22] [ERROR] Error formatting datetime '11-19-2025T05:39:42': Failed to parse time string (11-19-2025T05:39:42) at position 0 (1): Unexpected character
[2025-11-19 11:40:22] [INFO]   -> Set field 'cleared' = null
[2025-11-19 11:40:22] [ERROR] Error formatting datetime '11-19-2025T05:39:42': Failed to parse time string (11-19-2025T05:39:42) at position 0 (1): Unexpected character
[2025-11-19 11:40:22] [INFO]   -> Set field 'inService' = null
[2025-11-19 11:40:22] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-19 11:40:22] [INFO]   -> Found value: ENG2
[2025-11-19 11:40:22] [INFO]   -> Set field 'cADVehicleID' = "ENG2"
[2025-11-19 11:40:22] [INFO]   -> Set field 'name' = "ENG2"
[2025-11-19 11:40:22] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-19 11:40:22] [INFO]   -> Found value: 11-19-2025T05:08:32
[2025-11-19 11:40:22] [ERROR] Error formatting datetime '11-19-2025T05:08:32': Failed to parse time string (11-19-2025T05:08:32) at position 0 (1): Unexpected character
[2025-11-19 11:40:22] [INFO]   -> Set field 'timeenroutetoscene' = null
[2025-11-19 11:40:22] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-19 11:40:22] [INFO]   -> Found value: 11-19-2025T05:11:19
[2025-11-19 11:40:22] [ERROR] Error formatting datetime '11-19-2025T05:11:19': Failed to parse time string (11-19-2025T05:11:19) at position 0 (1): Unexpected character
[2025-11-19 11:40:22] [INFO]   -> Set field 'timeonscene' = null
[2025-11-19 11:40:22] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-19 11:40:22] [INFO]   -> Found value: 11-19-2025T05:39:38
[2025-11-19 11:40:22] [ERROR] Error formatting datetime '11-19-2025T05:39:38': Failed to parse time string (11-19-2025T05:39:38) at position 0 (1): Unexpected character
[2025-11-19 11:40:22] [INFO]   -> Set field 'timeunitclear' = null
[2025-11-19 11:40:22] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-19 11:40:22] [INFO]   -> Found value: 11-19-2025T05:08:29
[2025-11-19 11:40:22] [ERROR] Error formatting datetime '11-19-2025T05:08:29': Failed to parse time string (11-19-2025T05:08:29) at position 0 (1): Unexpected character
[2025-11-19 11:40:22] [INFO]   -> Set field 'timedispatch' = null
[2025-11-19 11:40:22] [INFO] Finished extracting fields. Total fields extracted: 23
[2025-11-19 11:40:22] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-27032","incidentLocationStreetNumber":302,"streetName":"STALLCUP DR","incidentLocationCity":"SIKESTON","businessName":"ANNIE'S GARDEN SKILLED NURSING","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-ALARM MECH","dispatchNotes":"11-19-2025 05:01:12|SMOKE DETECTOR GENERAL \n\n\n 11-19-2025 05:09:05|554 ON SCENE ADVISED ACTIVE ALARM 500 HALL 11-19-2025 05:10:24|C92 ADVISED SINGLE STORY STRUCTURE NOTHING SHOWING 11-19-2025 05:28:52|FALSE ALARM 11-19-2025 05:28:58|ALARM HAS BEEN RESET 11-19-2025 05:29:14|Disposition - SDPS PD:  NRN","cADLog":"11-19-2025 05:01:12|SMOKE DETECTOR GENERAL \n\n\n 11-19-2025 05:09:05|554 ON SCENE ADVISED ACTIVE ALARM 500 HALL 11-19-2025 05:10:24|C92 ADVISED SINGLE STORY STRUCTURE NOTHING SHOWING 11-19-2025 05:28:52|FALSE ALARM 11-19-2025 05:28:58|ALARM HAS BEEN RESET 11-19-2025 05:29:14|Disposition - SDPS PD:  NRN","alarm":null,"dispatched":null,"onScene":null,"cleared":null,"inService":null,"cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":null,"timeonscene":null,"timeunitclear":null,"timedispatch":null}
[2025-11-19 11:40:22] [INFO] Number of extracted fields: 23
[2025-11-19 11:40:22] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e872e5ae13
[2025-11-19 11:40:23] [INFO] Created Dispatches record with ID: 691daca66abc7b51a
[2025-11-19 11:40:23] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27032.xml
[2025-11-19 11:40:23] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27032.xml