[2025-11-25 02:33:55] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27591.xml [2025-11-25 02:33:55] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27591.xml for user: 68d56363ec1209189 [2025-11-25 02:33:55] [INFO] File size: 2261 bytes [2025-11-25 02:33:55] [INFO] Created FTPFiles record with ID: 6925159332e9f506c [2025-11-25 02:33:55] [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-25 02:33:55] [INFO] About to extract fields from XML. File size: 2261 bytes [2025-11-25 02:33:55] [INFO] Number of mappings: 20 [2025-11-25 02:33:55] [INFO] Starting XML parsing. Content length: 2261 [2025-11-25 02:33:55] [INFO] XML parsed successfully. Root element: Incident [2025-11-25 02:33:55] [INFO] Processing 20 field mappings [2025-11-25 02:33:55] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber' [2025-11-25 02:33:55] [INFO] -> Found value: 25-27591 [2025-11-25 02:33:55] [INFO] -> Set field 'dispatchRunNumber' = "25-27591" [2025-11-25 02:33:55] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber' [2025-11-25 02:33:55] [INFO] -> Found value: 301 [2025-11-25 02:33:55] [INFO] -> Set field 'incidentLocationStreetNumber' = 301 [2025-11-25 02:33:55] [INFO] Mapping #3: Extracting 'street' => 'streetName' [2025-11-25 02:33:55] [INFO] -> Found value: BROADWAY ST [2025-11-25 02:33:55] [INFO] -> Set field 'streetName' = "BROADWAY ST" [2025-11-25 02:33:55] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt' [2025-11-25 02:33:55] [INFO] -> No value found (null or empty) [2025-11-25 02:33:55] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity' [2025-11-25 02:33:55] [INFO] -> Found value: SIKESTON [2025-11-25 02:33:55] [INFO] -> Set field 'incidentLocationCity' = "SIKESTON" [2025-11-25 02:33:55] [INFO] Mapping #6: Extracting 'location_name' => 'businessName' [2025-11-25 02:33:55] [INFO] -> No value found (null or empty) [2025-11-25 02:33:55] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName' [2025-11-25 02:33:55] [INFO] -> Found value: MO [2025-11-25 02:33:55] [INFO] -> Set field 'incidentLocationStateName' = "MO" [2025-11-25 02:33:55] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode' [2025-11-25 02:33:55] [INFO] -> Found value: 63801 [2025-11-25 02:33:55] [INFO] -> Set field 'nERISIncidentPostalCode' = 63801 [2025-11-25 02:33:55] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude' [2025-11-25 02:33:55] [INFO] -> Found value: 0 [2025-11-25 02:33:55] [INFO] -> Set field 'nERISIncidentLatitude' = null [2025-11-25 02:33:55] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude' [2025-11-25 02:33:55] [INFO] -> Found value: 0 [2025-11-25 02:33:55] [INFO] -> Set field 'nERISIncidentLongitude' = null [2025-11-25 02:33:55] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1' [2025-11-25 02:33:55] [INFO] -> Found value: FIRE-ALARM MECH [2025-11-25 02:33:55] [INFO] -> Set field 'incidentTypeValue1' = "FIRE-ALARM MECH" [2025-11-25 02:33:55] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"] [2025-11-25 02:33:55] [INFO] -> Found value: 11-24-2025 20:20:33|FIRE ALARM HALL WAY SMOKE AND HEAT DETECTOR NO KEYHOLDER 11-24-2025 20:25:20|... [2025-11-25 02:33:55] [INFO] -> Set field 'dispatchNotes' = "11-24-2025 20:20:33|FIRE ALARM \nHALL WAY SMOKE AND HEAT DETECTOR\nNO KEYHOLDER 11-24-2025 20:25:20|SINGLE STORY NOTHING SHOWING 11-24-2025 20:25:26|C88 ON SCENE WITH COMMAND 11-24-2025 20:25:39|538 ADVISED CONSTRUCTION WORK INSIDE 11-24-2025 20:25:42|DUST SET OFF ALARM 11-24-2025 20:26:02|C88 ADVISED ALL UNITS CAN RETURN TO SERVICE 11-24-2025 20:26:40|CANCELLATION" [2025-11-25 02:33:55] [INFO] -> Set field 'cADLog' = "11-24-2025 20:20:33|FIRE ALARM \nHALL WAY SMOKE AND HEAT DETECTOR\nNO KEYHOLDER 11-24-2025 20:25:20|SINGLE STORY NOTHING SHOWING 11-24-2025 20:25:26|C88 ON SCENE WITH COMMAND 11-24-2025 20:25:39|538 ADVISED CONSTRUCTION WORK INSIDE 11-24-2025 20:25:42|DUST SET OFF ALARM 11-24-2025 20:26:02|C88 ADVISED ALL UNITS CAN RETURN TO SERVICE 11-24-2025 20:26:40|CANCELLATION" [2025-11-25 02:33:55] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"] [2025-11-25 02:33:55] [INFO] -> Found value: 11-24-2025T20:22:41 [2025-11-25 02:33:55] [ERROR] Error formatting datetime '11-24-2025T20:22:41': Failed to parse time string (11-24-2025T20:22:41) at position 0 (1): Unexpected character [2025-11-25 02:33:55] [INFO] -> Set field 'alarm' = null [2025-11-25 02:33:55] [ERROR] Error formatting datetime '11-24-2025T20:22:41': Failed to parse time string (11-24-2025T20:22:41) at position 0 (1): Unexpected character [2025-11-25 02:33:55] [INFO] -> Set field 'dispatched' = null [2025-11-25 02:33:55] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene' [2025-11-25 02:33:55] [INFO] -> Found value: 11-24-2025T20:24:23 [2025-11-25 02:33:55] [ERROR] Error formatting datetime '11-24-2025T20:24:23': Failed to parse time string (11-24-2025T20:24:23) at position 0 (1): Unexpected character [2025-11-25 02:33:55] [INFO] -> Set field 'onScene' = null [2025-11-25 02:33:55] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"] [2025-11-25 02:33:55] [INFO] -> Found value: 11-24-2025T20:32:56 [2025-11-25 02:33:55] [ERROR] Error formatting datetime '11-24-2025T20:32:56': Failed to parse time string (11-24-2025T20:32:56) at position 0 (1): Unexpected character [2025-11-25 02:33:55] [INFO] -> Set field 'cleared' = null [2025-11-25 02:33:55] [ERROR] Error formatting datetime '11-24-2025T20:32:56': Failed to parse time string (11-24-2025T20:32:56) at position 0 (1): Unexpected character [2025-11-25 02:33:55] [INFO] -> Set field 'inService' = null [2025-11-25 02:33:55] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"] [2025-11-25 02:33:55] [INFO] -> Found value: ENG2 [2025-11-25 02:33:55] [INFO] -> Set field 'cADVehicleID' = "ENG2" [2025-11-25 02:33:55] [INFO] -> Set field 'name' = "ENG2" [2025-11-25 02:33:55] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene' [2025-11-25 02:33:55] [INFO] -> Found value: 11-24-2025T20:23:16 [2025-11-25 02:33:55] [ERROR] Error formatting datetime '11-24-2025T20:23:16': Failed to parse time string (11-24-2025T20:23:16) at position 0 (1): Unexpected character [2025-11-25 02:33:55] [INFO] -> Set field 'timeenroutetoscene' = null [2025-11-25 02:33:55] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene' [2025-11-25 02:33:55] [INFO] -> No value found (null or empty) [2025-11-25 02:33:55] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear' [2025-11-25 02:33:55] [INFO] -> Found value: 11-24-2025T20:32:56 [2025-11-25 02:33:55] [ERROR] Error formatting datetime '11-24-2025T20:32:56': Failed to parse time string (11-24-2025T20:32:56) at position 0 (1): Unexpected character [2025-11-25 02:33:55] [INFO] -> Set field 'timeunitclear' = null [2025-11-25 02:33:55] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch' [2025-11-25 02:33:55] [INFO] -> Found value: 11-24-2025T20:23:13 [2025-11-25 02:33:55] [ERROR] Error formatting datetime '11-24-2025T20:23:13': Failed to parse time string (11-24-2025T20:23:13) at position 0 (1): Unexpected character [2025-11-25 02:33:55] [INFO] -> Set field 'timedispatch' = null [2025-11-25 02:33:55] [INFO] Finished extracting fields. Total fields extracted: 21 [2025-11-25 02:33:55] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-27591","incidentLocationStreetNumber":301,"streetName":"BROADWAY ST","incidentLocationCity":"SIKESTON","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-ALARM MECH","dispatchNotes":"11-24-2025 20:20:33|FIRE ALARM \nHALL WAY SMOKE AND HEAT DETECTOR\nNO KEYHOLDER 11-24-2025 20:25:20|SINGLE STORY NOTHING SHOWING 11-24-2025 20:25:26|C88 ON SCENE WITH COMMAND 11-24-2025 20:25:39|538 ADVISED CONSTRUCTION WORK INSIDE 11-24-2025 20:25:42|DUST SET OFF ALARM 11-24-2025 20:26:02|C88 ADVISED ALL UNITS CAN RETURN TO SERVICE 11-24-2025 20:26:40|CANCELLATION","cADLog":"11-24-2025 20:20:33|FIRE ALARM \nHALL WAY SMOKE AND HEAT DETECTOR\nNO KEYHOLDER 11-24-2025 20:25:20|SINGLE STORY NOTHING SHOWING 11-24-2025 20:25:26|C88 ON SCENE WITH COMMAND 11-24-2025 20:25:39|538 ADVISED CONSTRUCTION WORK INSIDE 11-24-2025 20:25:42|DUST SET OFF ALARM 11-24-2025 20:26:02|C88 ADVISED ALL UNITS CAN RETURN TO SERVICE 11-24-2025 20:26:40|CANCELLATION","alarm":null,"dispatched":null,"onScene":null,"cleared":null,"inService":null,"cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":null,"timeunitclear":null,"timedispatch":null} [2025-11-25 02:33:55] [INFO] Number of extracted fields: 21 [2025-11-25 02:33:55] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e872e5ae13 [2025-11-25 02:33:56] [INFO] Created new Dispatches record with ID: 6925159367388e52b [2025-11-25 02:33:56] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27591.xml [2025-11-25 02:33:56] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27591.xml [2025-11-25 07:44:15] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27602.xml [2025-11-25 07:44:15] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27602.xml for user: 68d56363ec1209189 [2025-11-25 07:44:15] [INFO] File size: 1640 bytes [2025-11-25 07:44:15] [INFO] Created FTPFiles record with ID: 69255e4f42caab8c0 [2025-11-25 07:44:15] [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-25 07:44:15] [INFO] About to extract fields from XML. File size: 1640 bytes [2025-11-25 07:44:15] [INFO] Number of mappings: 20 [2025-11-25 07:44:15] [INFO] Starting XML parsing. Content length: 1640 [2025-11-25 07:44:15] [INFO] XML parsed successfully. Root element: Incident [2025-11-25 07:44:15] [INFO] Processing 20 field mappings [2025-11-25 07:44:15] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber' [2025-11-25 07:44:15] [INFO] -> Found value: 25-27602 [2025-11-25 07:44:15] [INFO] -> Set field 'dispatchRunNumber' = "25-27602" [2025-11-25 07:44:15] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber' [2025-11-25 07:44:15] [INFO] -> Found value: 1551 [2025-11-25 07:44:15] [INFO] -> Set field 'incidentLocationStreetNumber' = 1551 [2025-11-25 07:44:15] [INFO] Mapping #3: Extracting 'street' => 'streetName' [2025-11-25 07:44:15] [INFO] -> Found value: W WAKEFIELD AVE [2025-11-25 07:44:15] [INFO] -> Set field 'streetName' = "W WAKEFIELD AVE" [2025-11-25 07:44:15] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt' [2025-11-25 07:44:15] [INFO] -> No value found (null or empty) [2025-11-25 07:44:15] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity' [2025-11-25 07:44:15] [INFO] -> Found value: SIKESTON [2025-11-25 07:44:15] [INFO] -> Set field 'incidentLocationCity' = "SIKESTON" [2025-11-25 07:44:15] [INFO] Mapping #6: Extracting 'location_name' => 'businessName' [2025-11-25 07:44:15] [INFO] -> Found value: SIKESTON POWER PLANT [2025-11-25 07:44:15] [INFO] -> Set field 'businessName' = "SIKESTON POWER PLANT" [2025-11-25 07:44:15] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName' [2025-11-25 07:44:15] [INFO] -> Found value: MO [2025-11-25 07:44:15] [INFO] -> Set field 'incidentLocationStateName' = "MO" [2025-11-25 07:44:15] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode' [2025-11-25 07:44:15] [INFO] -> Found value: 63801 [2025-11-25 07:44:15] [INFO] -> Set field 'nERISIncidentPostalCode' = 63801 [2025-11-25 07:44:15] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude' [2025-11-25 07:44:15] [INFO] -> Found value: 0 [2025-11-25 07:44:15] [INFO] -> Set field 'nERISIncidentLatitude' = null [2025-11-25 07:44:15] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude' [2025-11-25 07:44:15] [INFO] -> Found value: 0 [2025-11-25 07:44:15] [INFO] -> Set field 'nERISIncidentLongitude' = null [2025-11-25 07:44:15] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1' [2025-11-25 07:44:15] [INFO] -> Found value: FIRE-COAL TRAIN STANDBY [2025-11-25 07:44:15] [INFO] -> Set field 'incidentTypeValue1' = "FIRE-COAL TRAIN STANDBY" [2025-11-25 07:44:15] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"] [2025-11-25 07:44:15] [INFO] -> Found value: 11-25-2025 01:02:26|ARRIVING FROM THE NORTH 11-25-2025 01:43:20|TRAIN HAS CLEARED [2025-11-25 07:44:15] [INFO] -> Set field 'dispatchNotes' = "11-25-2025 01:02:26|ARRIVING FROM THE NORTH 11-25-2025 01:43:20|TRAIN HAS CLEARED" [2025-11-25 07:44:15] [INFO] -> Set field 'cADLog' = "11-25-2025 01:02:26|ARRIVING FROM THE NORTH 11-25-2025 01:43:20|TRAIN HAS CLEARED" [2025-11-25 07:44:15] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"] [2025-11-25 07:44:15] [INFO] -> Found value: 11-25-2025T01:04:25 [2025-11-25 07:44:15] [ERROR] Error formatting datetime '11-25-2025T01:04:25': Failed to parse time string (11-25-2025T01:04:25) at position 0 (1): Unexpected character [2025-11-25 07:44:15] [INFO] -> Set field 'alarm' = null [2025-11-25 07:44:15] [ERROR] Error formatting datetime '11-25-2025T01:04:25': Failed to parse time string (11-25-2025T01:04:25) at position 0 (1): Unexpected character [2025-11-25 07:44:15] [INFO] -> Set field 'dispatched' = null [2025-11-25 07:44:15] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene' [2025-11-25 07:44:15] [INFO] -> No value found (null or empty) [2025-11-25 07:44:15] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"] [2025-11-25 07:44:15] [INFO] -> No value found (null or empty) [2025-11-25 07:44:15] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"] [2025-11-25 07:44:15] [INFO] -> Found value: SIK STILL [2025-11-25 07:44:15] [INFO] -> Set field 'cADVehicleID' = "SIK STILL" [2025-11-25 07:44:15] [INFO] -> Set field 'name' = "SIK STILL" [2025-11-25 07:44:15] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene' [2025-11-25 07:44:15] [INFO] -> No value found (null or empty) [2025-11-25 07:44:15] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene' [2025-11-25 07:44:15] [INFO] -> No value found (null or empty) [2025-11-25 07:44:15] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear' [2025-11-25 07:44:15] [INFO] -> Found value: 11-25-2025T01:43:26 [2025-11-25 07:44:15] [ERROR] Error formatting datetime '11-25-2025T01:43:26': Failed to parse time string (11-25-2025T01:43:26) at position 0 (1): Unexpected character [2025-11-25 07:44:15] [INFO] -> Set field 'timeunitclear' = null [2025-11-25 07:44:15] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch' [2025-11-25 07:44:15] [INFO] -> Found value: 11-25-2025T01:04:25 [2025-11-25 07:44:15] [ERROR] Error formatting datetime '11-25-2025T01:04:25': Failed to parse time string (11-25-2025T01:04:25) at position 0 (1): Unexpected character [2025-11-25 07:44:15] [INFO] -> Set field 'timedispatch' = null [2025-11-25 07:44:15] [INFO] Finished extracting fields. Total fields extracted: 18 [2025-11-25 07:44:15] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-27602","incidentLocationStreetNumber":1551,"streetName":"W WAKEFIELD AVE","incidentLocationCity":"SIKESTON","businessName":"SIKESTON POWER PLANT","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-COAL TRAIN STANDBY","dispatchNotes":"11-25-2025 01:02:26|ARRIVING FROM THE NORTH 11-25-2025 01:43:20|TRAIN HAS CLEARED","cADLog":"11-25-2025 01:02:26|ARRIVING FROM THE NORTH 11-25-2025 01:43:20|TRAIN HAS CLEARED","alarm":null,"dispatched":null,"cADVehicleID":"SIK STILL","name":"SIK STILL","timeunitclear":null,"timedispatch":null} [2025-11-25 07:44:15] [INFO] Number of extracted fields: 18 [2025-11-25 07:44:15] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e8608a02f9 [2025-11-25 07:44:16] [INFO] Created new Dispatches record with ID: 69255e4f7385f9859 [2025-11-25 07:44:16] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27602.xml [2025-11-25 07:44:16] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27602.xml [2025-11-25 11:03:38] [ERROR] No file path provided. [2025-11-25 14:03:09] [ERROR] No file path provided. [2025-11-25 20:18:29] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27657.xml [2025-11-25 20:18:29] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27657.xml for user: 68d56363ec1209189 [2025-11-25 20:18:29] [INFO] File size: 1330 bytes [2025-11-25 20:18:29] [INFO] Created FTPFiles record with ID: 69260f15e794a4dd6 [2025-11-25 20:18:29] [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-25 20:18:29] [INFO] About to extract fields from XML. File size: 1330 bytes [2025-11-25 20:18:29] [INFO] Number of mappings: 20 [2025-11-25 20:18:29] [INFO] Starting XML parsing. Content length: 1330 [2025-11-25 20:18:29] [INFO] XML parsed successfully. Root element: Incident [2025-11-25 20:18:29] [INFO] Processing 20 field mappings [2025-11-25 20:18:29] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber' [2025-11-25 20:18:29] [INFO] -> Found value: 25-27657 [2025-11-25 20:18:29] [INFO] -> Set field 'dispatchRunNumber' = "25-27657" [2025-11-25 20:18:29] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber' [2025-11-25 20:18:29] [INFO] -> Found value: 1551 [2025-11-25 20:18:29] [INFO] -> Set field 'incidentLocationStreetNumber' = 1551 [2025-11-25 20:18:29] [INFO] Mapping #3: Extracting 'street' => 'streetName' [2025-11-25 20:18:29] [INFO] -> Found value: W WAKEFIELD AVE [2025-11-25 20:18:29] [INFO] -> Set field 'streetName' = "W WAKEFIELD AVE" [2025-11-25 20:18:29] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt' [2025-11-25 20:18:29] [INFO] -> No value found (null or empty) [2025-11-25 20:18:29] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity' [2025-11-25 20:18:29] [INFO] -> Found value: SIKESTON [2025-11-25 20:18:29] [INFO] -> Set field 'incidentLocationCity' = "SIKESTON" [2025-11-25 20:18:29] [INFO] Mapping #6: Extracting 'location_name' => 'businessName' [2025-11-25 20:18:29] [INFO] -> Found value: SIKESTON POWER PLANT [2025-11-25 20:18:29] [INFO] -> Set field 'businessName' = "SIKESTON POWER PLANT" [2025-11-25 20:18:29] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName' [2025-11-25 20:18:29] [INFO] -> Found value: MO [2025-11-25 20:18:29] [INFO] -> Set field 'incidentLocationStateName' = "MO" [2025-11-25 20:18:29] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode' [2025-11-25 20:18:29] [INFO] -> Found value: 63801 [2025-11-25 20:18:29] [INFO] -> Set field 'nERISIncidentPostalCode' = 63801 [2025-11-25 20:18:29] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude' [2025-11-25 20:18:29] [INFO] -> Found value: 0 [2025-11-25 20:18:29] [INFO] -> Set field 'nERISIncidentLatitude' = null [2025-11-25 20:18:29] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude' [2025-11-25 20:18:29] [INFO] -> Found value: 0 [2025-11-25 20:18:29] [INFO] -> Set field 'nERISIncidentLongitude' = null [2025-11-25 20:18:29] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1' [2025-11-25 20:18:29] [INFO] -> Found value: FIRE-COAL TRAIN STANDBY [2025-11-25 20:18:29] [INFO] -> Set field 'incidentTypeValue1' = "FIRE-COAL TRAIN STANDBY" [2025-11-25 20:18:29] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"] [2025-11-25 20:18:29] [INFO] -> Found value: 11-25-2025 13:45:06|DEPARTING SOUTH [2025-11-25 20:18:29] [INFO] -> Set field 'dispatchNotes' = "11-25-2025 13:45:06|DEPARTING SOUTH" [2025-11-25 20:18:29] [INFO] -> Set field 'cADLog' = "11-25-2025 13:45:06|DEPARTING SOUTH" [2025-11-25 20:18:29] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"] [2025-11-25 20:18:29] [INFO] -> Found value: 11-25-2025T13:45:27 [2025-11-25 20:18:29] [ERROR] Error formatting datetime '11-25-2025T13:45:27': Failed to parse time string (11-25-2025T13:45:27) at position 0 (1): Unexpected character [2025-11-25 20:18:29] [INFO] -> Set field 'alarm' = null [2025-11-25 20:18:29] [ERROR] Error formatting datetime '11-25-2025T13:45:27': Failed to parse time string (11-25-2025T13:45:27) at position 0 (1): Unexpected character [2025-11-25 20:18:29] [INFO] -> Set field 'dispatched' = null [2025-11-25 20:18:29] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene' [2025-11-25 20:18:29] [INFO] -> No value found (null or empty) [2025-11-25 20:18:29] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"] [2025-11-25 20:18:29] [INFO] -> No value found (null or empty) [2025-11-25 20:18:29] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"] [2025-11-25 20:18:29] [INFO] -> Found value: SIK STILL [2025-11-25 20:18:29] [INFO] -> Set field 'cADVehicleID' = "SIK STILL" [2025-11-25 20:18:29] [INFO] -> Set field 'name' = "SIK STILL" [2025-11-25 20:18:29] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene' [2025-11-25 20:18:29] [INFO] -> No value found (null or empty) [2025-11-25 20:18:29] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene' [2025-11-25 20:18:29] [INFO] -> No value found (null or empty) [2025-11-25 20:18:29] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear' [2025-11-25 20:18:29] [INFO] -> Found value: 11-25-2025T14:17:59 [2025-11-25 20:18:29] [ERROR] Error formatting datetime '11-25-2025T14:17:59': Failed to parse time string (11-25-2025T14:17:59) at position 0 (1): Unexpected character [2025-11-25 20:18:29] [INFO] -> Set field 'timeunitclear' = null [2025-11-25 20:18:29] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch' [2025-11-25 20:18:29] [INFO] -> Found value: 11-25-2025T13:45:27 [2025-11-25 20:18:29] [ERROR] Error formatting datetime '11-25-2025T13:45:27': Failed to parse time string (11-25-2025T13:45:27) at position 0 (1): Unexpected character [2025-11-25 20:18:29] [INFO] -> Set field 'timedispatch' = null [2025-11-25 20:18:29] [INFO] Finished extracting fields. Total fields extracted: 18 [2025-11-25 20:18:29] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-27657","incidentLocationStreetNumber":1551,"streetName":"W WAKEFIELD AVE","incidentLocationCity":"SIKESTON","businessName":"SIKESTON POWER PLANT","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-COAL TRAIN STANDBY","dispatchNotes":"11-25-2025 13:45:06|DEPARTING SOUTH","cADLog":"11-25-2025 13:45:06|DEPARTING SOUTH","alarm":null,"dispatched":null,"cADVehicleID":"SIK STILL","name":"SIK STILL","timeunitclear":null,"timedispatch":null} [2025-11-25 20:18:29] [INFO] Number of extracted fields: 18 [2025-11-25 20:18:30] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e8608a02f9 [2025-11-25 20:18:31] [INFO] Created new Dispatches record with ID: 69260f1628f37eeaa [2025-11-25 20:18:31] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27657.xml [2025-11-25 20:18:31] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27657.xml [2025-11-25 22:03:54] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27655.xml [2025-11-25 22:03:54] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27655.xml for user: 68d56363ec1209189 [2025-11-25 22:03:54] [INFO] File size: 1342 bytes [2025-11-25 22:03:54] [INFO] Created FTPFiles record with ID: 692627cace6ef204e [2025-11-25 22:03:54] [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-25 22:03:54] [INFO] About to extract fields from XML. File size: 1342 bytes [2025-11-25 22:03:54] [INFO] Number of mappings: 20 [2025-11-25 22:03:54] [INFO] Starting XML parsing. Content length: 1342 [2025-11-25 22:03:54] [INFO] XML parsed successfully. Root element: Incident [2025-11-25 22:03:54] [INFO] Processing 20 field mappings [2025-11-25 22:03:54] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber' [2025-11-25 22:03:54] [INFO] -> Found value: 25-27655 [2025-11-25 22:03:54] [INFO] -> Set field 'dispatchRunNumber' = "25-27655" [2025-11-25 22:03:54] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber' [2025-11-25 22:03:54] [INFO] -> Found value: 2 [2025-11-25 22:03:54] [INFO] -> Set field 'incidentLocationStreetNumber' = 2 [2025-11-25 22:03:54] [INFO] Mapping #3: Extracting 'street' => 'streetName' [2025-11-25 22:03:54] [INFO] -> Found value: COURTHOUSE SQ [2025-11-25 22:03:54] [INFO] -> Set field 'streetName' = "COURTHOUSE SQ" [2025-11-25 22:03:54] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt' [2025-11-25 22:03:54] [INFO] -> No value found (null or empty) [2025-11-25 22:03:54] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity' [2025-11-25 22:03:54] [INFO] -> Found value: NEW MADRID [2025-11-25 22:03:54] [INFO] -> Set field 'incidentLocationCity' = "NEW MADRID" [2025-11-25 22:03:54] [INFO] Mapping #6: Extracting 'location_name' => 'businessName' [2025-11-25 22:03:54] [INFO] -> Found value: NEW MADRID CO SHERIFF DEPARTMENT [2025-11-25 22:03:54] [INFO] -> Set field 'businessName' = "NEW MADRID CO SHERIFF DEPARTMENT" [2025-11-25 22:03:54] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName' [2025-11-25 22:03:54] [INFO] -> Found value: MO [2025-11-25 22:03:54] [INFO] -> Set field 'incidentLocationStateName' = "MO" [2025-11-25 22:03:54] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode' [2025-11-25 22:03:54] [INFO] -> Found value: 63869 [2025-11-25 22:03:54] [INFO] -> Set field 'nERISIncidentPostalCode' = 63869 [2025-11-25 22:03:54] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude' [2025-11-25 22:03:54] [INFO] -> Found value: 0 [2025-11-25 22:03:54] [INFO] -> Set field 'nERISIncidentLatitude' = null [2025-11-25 22:03:54] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude' [2025-11-25 22:03:54] [INFO] -> Found value: 0 [2025-11-25 22:03:54] [INFO] -> Set field 'nERISIncidentLongitude' = null [2025-11-25 22:03:54] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1' [2025-11-25 22:03:54] [INFO] -> Found value: HSRT DEPLOYMENT [2025-11-25 22:03:54] [INFO] -> Set field 'incidentTypeValue1' = "HSRT DEPLOYMENT" [2025-11-25 22:03:54] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"] [2025-11-25 22:03:54] [INFO] -> Found value: 11-25-2025 13:22:04|TWO DIVERS EN ROUTE TO ASSIST [2025-11-25 22:03:54] [INFO] -> Set field 'dispatchNotes' = "11-25-2025 13:22:04|TWO DIVERS EN ROUTE TO ASSIST" [2025-11-25 22:03:54] [INFO] -> Set field 'cADLog' = "11-25-2025 13:22:04|TWO DIVERS EN ROUTE TO ASSIST" [2025-11-25 22:03:54] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"] [2025-11-25 22:03:54] [INFO] -> Found value: 11-25-2025T13:22:18 [2025-11-25 22:03:54] [ERROR] Error formatting datetime '11-25-2025T13:22:18': Failed to parse time string (11-25-2025T13:22:18) at position 0 (1): Unexpected character [2025-11-25 22:03:54] [INFO] -> Set field 'alarm' = null [2025-11-25 22:03:54] [ERROR] Error formatting datetime '11-25-2025T13:22:18': Failed to parse time string (11-25-2025T13:22:18) at position 0 (1): Unexpected character [2025-11-25 22:03:54] [INFO] -> Set field 'dispatched' = null [2025-11-25 22:03:54] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene' [2025-11-25 22:03:54] [INFO] -> No value found (null or empty) [2025-11-25 22:03:54] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"] [2025-11-25 22:03:54] [INFO] -> No value found (null or empty) [2025-11-25 22:03:54] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"] [2025-11-25 22:03:54] [INFO] -> Found value: HSRT [2025-11-25 22:03:54] [INFO] -> Set field 'cADVehicleID' = "HSRT" [2025-11-25 22:03:54] [INFO] -> Set field 'name' = "HSRT" [2025-11-25 22:03:54] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene' [2025-11-25 22:03:54] [INFO] -> No value found (null or empty) [2025-11-25 22:03:54] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene' [2025-11-25 22:03:54] [INFO] -> No value found (null or empty) [2025-11-25 22:03:54] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear' [2025-11-25 22:03:54] [INFO] -> Found value: 11-25-2025T16:03:27 [2025-11-25 22:03:54] [ERROR] Error formatting datetime '11-25-2025T16:03:27': Failed to parse time string (11-25-2025T16:03:27) at position 0 (1): Unexpected character [2025-11-25 22:03:54] [INFO] -> Set field 'timeunitclear' = null [2025-11-25 22:03:54] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch' [2025-11-25 22:03:54] [INFO] -> Found value: 11-25-2025T13:22:18 [2025-11-25 22:03:54] [ERROR] Error formatting datetime '11-25-2025T13:22:18': Failed to parse time string (11-25-2025T13:22:18) at position 0 (1): Unexpected character [2025-11-25 22:03:54] [INFO] -> Set field 'timedispatch' = null [2025-11-25 22:03:54] [INFO] Finished extracting fields. Total fields extracted: 18 [2025-11-25 22:03:54] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-27655","incidentLocationStreetNumber":2,"streetName":"COURTHOUSE SQ","incidentLocationCity":"NEW MADRID","businessName":"NEW MADRID CO SHERIFF DEPARTMENT","incidentLocationStateName":"MO","nERISIncidentPostalCode":63869,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"HSRT DEPLOYMENT","dispatchNotes":"11-25-2025 13:22:04|TWO DIVERS EN ROUTE TO ASSIST","cADLog":"11-25-2025 13:22:04|TWO DIVERS EN ROUTE TO ASSIST","alarm":null,"dispatched":null,"cADVehicleID":"HSRT","name":"HSRT","timeunitclear":null,"timedispatch":null} [2025-11-25 22:03:54] [INFO] Number of extracted fields: 18 [2025-11-25 22:03:54] [INFO] Found existing IncidentTypeMapping with ID: 68f8f9275843af7ab [2025-11-25 22:03:55] [INFO] Created new Dispatches record with ID: 692627cb0ca67c14f [2025-11-25 22:03:55] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27655.xml [2025-11-25 22:03:55] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27655.xml