[2025-10-26 01:10:23] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24483.xml
[2025-10-26 01:10:23] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24483.xml for user: 68d56363ec1209189
[2025-10-26 01:10:23] [INFO] File size: 1950 bytes
[2025-10-26 01:10:23] [INFO] Created FTPFiles record with ID: 68fd74ffe905648d0
[2025-10-26 01:10:23] [INFO] WE ARE HERE {"mappings":{"IncidentNumber":"dispatchRunNumber","house_number":"incidentLocationStreetNumber","street":"streetName","apt":"incidentLocationApt","city":"incidentLocationCity","location_name":"businessName","STATE":"incidentLocationStateName","ZIPCODE":"nERISIncidentPostalCode","LATITUDE":"nERISIncidentLatitude","LONGITUDE":"nERISIncidentLongitude","incident_type":"incidentTypeValue1","commentlist.comment":["dispatchNotes","cADLog"],"time_first_unit_assigned":["alarm","dispatched"],"time_first_unit_arrived":"onScene","time_last_unit_cleared":["cleared","inService"],"Units.Unit[0].radio_name":["cADVehicleID","name"],"Units.Unit[0].time_enroute":"timeenroutetoscene","Units.Unit[0].time_arrivedatscene":"timeonscene","Units.Unit[0].time_depart_scene":"timeunitclear","Units.Unit[0].time_assigned":"timedispatch"},"selectedRecord":{"id":"68eeb2639352dd41d","name":null},"fieldExamples":{"IncidentNumber":{"name":"IncidentNumber","value":"25-23514","type":"text"},"house_number":{"name":"house_number","value":"515","type":"number"},"street":{"name":"street","value":"LINDENWOOD AVE","type":"address"},"apt":{"name":"apt","value":"Array","type":"text"},"city":{"name":"city","value":"Array","type":"address"},"location_name":{"name":"location_name","value":"Array","type":"text"},"STATE":{"name":"STATE","value":"Array","type":"address"},"ZIPCODE":{"name":"ZIPCODE","value":"Array","type":"address"},"LATITUDE":{"name":"LATITUDE","value":"0","type":"coordinate"},"LONGITUDE":{"name":"LONGITUDE","value":"0","type":"coordinate"},"incident_type":{"name":"incident_type","value":"FIRE-GAS LEAK","type":"text"},"commentlist.comment":{"name":"comment","value":"10-14-2025 15:05:06|B45 ADVISED HE WOULD NOTIFY GAS CO 10-14-2025 15:05:23|B46 NOTHING SHOWING 10-14-2025 15:08:22|B46 ADVISED NO SMELL OF GAS HOWEVER ALARMS GOING OFF 10-14-2025 15:13:38|B46 CLEARED ","type":"text"},"time_first_unit_assigned":{"name":"time_first_unit_assigned","value":"10-14-2025T15:04:42","type":"datetime"},"time_first_unit_arrived":{"name":"time_first_unit_arrived","value":"10-14-2025T15:07:19","type":"datetime"},"time_last_unit_cleared":{"name":"time_last_unit_cleared","value":"10-14-2025T15:27:23","type":"datetime"},"Units.Unit[0].radio_name":{"name":"radio_name","value":"ENG2","type":"text"},"Units.Unit[0].time_enroute":{"name":"time_enroute","value":"10-14-2025T15:04:46","type":"datetime"},"Units.Unit[0].time_arrivedatscene":{"name":"time_arrivedatscene","value":"10-14-2025T15:08:38","type":"datetime"},"Units.Unit[0].time_depart_scene":{"name":"time_depart_scene","value":"10-14-2025T15:27:23","type":"datetime"},"Units.Unit[0].time_assigned":{"name":"time_assigned","value":"10-14-2025T15:04:42","type":"datetime"}},"timestamp":"2025-10-16T18:16:37.381Z"}
[2025-10-26 01:10:23] [INFO] About to extract fields from XML. File size: 1950 bytes
[2025-10-26 01:10:23] [INFO] Number of mappings: 20
[2025-10-26 01:10:23] [INFO] Starting XML parsing. Content length: 1950
[2025-10-26 01:10:23] [INFO] XML parsed successfully. Root element: Incident
[2025-10-26 01:10:23] [INFO] Processing 20 field mappings
[2025-10-26 01:10:23] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-10-26 01:10:23] [INFO]   -> Found value: 25-24483
[2025-10-26 01:10:23] [INFO]   -> Set field 'dispatchRunNumber' = "25-24483"
[2025-10-26 01:10:23] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-10-26 01:10:23] [INFO]   -> Found value: 1019
[2025-10-26 01:10:23] [INFO]   -> Set field 'incidentLocationStreetNumber' = 1019
[2025-10-26 01:10:23] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-10-26 01:10:23] [INFO]   -> Found value: W MALONE AVE
[2025-10-26 01:10:23] [INFO]   -> Set field 'streetName' = "W MALONE AVE"
[2025-10-26 01:10:23] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-10-26 01:10:23] [INFO]   -> No value found (null or empty)
[2025-10-26 01:10:23] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-10-26 01:10:23] [INFO]   -> Found value: SIKESTON
[2025-10-26 01:10:23] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-10-26 01:10:23] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-10-26 01:10:23] [INFO]   -> Found value: DOLLAR GENERAL STORE
[2025-10-26 01:10:23] [INFO]   -> Set field 'businessName' = "DOLLAR GENERAL STORE"
[2025-10-26 01:10:23] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-10-26 01:10:23] [INFO]   -> No value found (null or empty)
[2025-10-26 01:10:23] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-10-26 01:10:23] [INFO]   -> No value found (null or empty)
[2025-10-26 01:10:23] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-10-26 01:10:23] [INFO]   -> Found value: 0
[2025-10-26 01:10:23] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-10-26 01:10:23] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-10-26 01:10:23] [INFO]   -> Found value: 0
[2025-10-26 01:10:23] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-10-26 01:10:23] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-10-26 01:10:23] [INFO]   -> Found value: FIRE-ALARM MECH
[2025-10-26 01:10:23] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-ALARM MECH"
[2025-10-26 01:10:23] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-10-26 01:10:23] [INFO]   -> Found value: 10-25-2025 20:00:31|Call Received on 10/25/2025 @ 20:00

CALLER STATED THAT THE FIRE ALARM IS GOING ...
[2025-10-26 01:10:23] [INFO]   -> Set field 'dispatchNotes' = "10-25-2025 20:00:31|Call Received on 10\/25\/2025 @ 20:00\n\nCALLER STATED THAT THE FIRE ALARM IS GOING OFF\nDOES NOT SEE FLAMES OR SMOKE \n 10-25-2025 20:05:35|509 ON SCENE ADVISED SINGLE STORY COMMERCIAL STRUCTURE NOTHING SHOWING 10-25-2025 20:06:19|TOWER 1 STAGING ON SUNSET"
[2025-10-26 01:10:23] [INFO]   -> Set field 'cADLog' = "10-25-2025 20:00:31|Call Received on 10\/25\/2025 @ 20:00\n\nCALLER STATED THAT THE FIRE ALARM IS GOING OFF\nDOES NOT SEE FLAMES OR SMOKE \n 10-25-2025 20:05:35|509 ON SCENE ADVISED SINGLE STORY COMMERCIAL STRUCTURE NOTHING SHOWING 10-25-2025 20:06:19|TOWER 1 STAGING ON SUNSET"
[2025-10-26 01:10:23] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-10-26 01:10:23] [INFO]   -> Found value: 10-25-2025T20:02:36
[2025-10-26 01:10:23] [ERROR] Error formatting datetime '10-25-2025T20:02:36': Failed to parse time string (10-25-2025T20:02:36) at position 0 (1): Unexpected character
[2025-10-26 01:10:23] [INFO]   -> Set field 'alarm' = null
[2025-10-26 01:10:23] [ERROR] Error formatting datetime '10-25-2025T20:02:36': Failed to parse time string (10-25-2025T20:02:36) at position 0 (1): Unexpected character
[2025-10-26 01:10:23] [INFO]   -> Set field 'dispatched' = null
[2025-10-26 01:10:23] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-10-26 01:10:23] [INFO]   -> Found value: 10-25-2025T20:05:04
[2025-10-26 01:10:23] [ERROR] Error formatting datetime '10-25-2025T20:05:04': Failed to parse time string (10-25-2025T20:05:04) at position 0 (1): Unexpected character
[2025-10-26 01:10:23] [INFO]   -> Set field 'onScene' = null
[2025-10-26 01:10:23] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-10-26 01:10:23] [INFO]   -> Found value: 10-25-2025T20:09:52
[2025-10-26 01:10:23] [ERROR] Error formatting datetime '10-25-2025T20:09:52': Failed to parse time string (10-25-2025T20:09:52) at position 0 (1): Unexpected character
[2025-10-26 01:10:23] [INFO]   -> Set field 'cleared' = null
[2025-10-26 01:10:23] [ERROR] Error formatting datetime '10-25-2025T20:09:52': Failed to parse time string (10-25-2025T20:09:52) at position 0 (1): Unexpected character
[2025-10-26 01:10:23] [INFO]   -> Set field 'inService' = null
[2025-10-26 01:10:23] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-10-26 01:10:23] [INFO]   -> Found value: ENG2
[2025-10-26 01:10:23] [INFO]   -> Set field 'cADVehicleID' = "ENG2"
[2025-10-26 01:10:23] [INFO]   -> Set field 'name' = "ENG2"
[2025-10-26 01:10:23] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-10-26 01:10:23] [INFO]   -> Found value: 10-25-2025T20:03:59
[2025-10-26 01:10:23] [ERROR] Error formatting datetime '10-25-2025T20:03:59': Failed to parse time string (10-25-2025T20:03:59) at position 0 (1): Unexpected character
[2025-10-26 01:10:23] [INFO]   -> Set field 'timeenroutetoscene' = null
[2025-10-26 01:10:23] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-10-26 01:10:23] [INFO]   -> Found value: 10-25-2025T20:05:51
[2025-10-26 01:10:23] [ERROR] Error formatting datetime '10-25-2025T20:05:51': Failed to parse time string (10-25-2025T20:05:51) at position 0 (1): Unexpected character
[2025-10-26 01:10:23] [INFO]   -> Set field 'timeonscene' = null
[2025-10-26 01:10:23] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-10-26 01:10:23] [INFO]   -> Found value: 10-25-2025T20:09:52
[2025-10-26 01:10:23] [ERROR] Error formatting datetime '10-25-2025T20:09:52': Failed to parse time string (10-25-2025T20:09:52) at position 0 (1): Unexpected character
[2025-10-26 01:10:23] [INFO]   -> Set field 'timeunitclear' = null
[2025-10-26 01:10:23] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-10-26 01:10:23] [INFO]   -> Found value: 10-25-2025T20:03:57
[2025-10-26 01:10:23] [ERROR] Error formatting datetime '10-25-2025T20:03:57': Failed to parse time string (10-25-2025T20:03:57) at position 0 (1): Unexpected character
[2025-10-26 01:10:23] [INFO]   -> Set field 'timedispatch' = null
[2025-10-26 01:10:23] [INFO] Finished extracting fields. Total fields extracted: 21
[2025-10-26 01:10:23] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-24483","incidentLocationStreetNumber":1019,"streetName":"W MALONE AVE","incidentLocationCity":"SIKESTON","businessName":"DOLLAR GENERAL STORE","nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-ALARM MECH","dispatchNotes":"10-25-2025 20:00:31|Call Received on 10\/25\/2025 @ 20:00\n\nCALLER STATED THAT THE FIRE ALARM IS GOING OFF\nDOES NOT SEE FLAMES OR SMOKE \n 10-25-2025 20:05:35|509 ON SCENE ADVISED SINGLE STORY COMMERCIAL STRUCTURE NOTHING SHOWING 10-25-2025 20:06:19|TOWER 1 STAGING ON SUNSET","cADLog":"10-25-2025 20:00:31|Call Received on 10\/25\/2025 @ 20:00\n\nCALLER STATED THAT THE FIRE ALARM IS GOING OFF\nDOES NOT SEE FLAMES OR SMOKE \n 10-25-2025 20:05:35|509 ON SCENE ADVISED SINGLE STORY COMMERCIAL STRUCTURE NOTHING SHOWING 10-25-2025 20:06:19|TOWER 1 STAGING ON SUNSET","alarm":null,"dispatched":null,"onScene":null,"cleared":null,"inService":null,"cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":null,"timeonscene":null,"timeunitclear":null,"timedispatch":null}
[2025-10-26 01:10:23] [INFO] Number of extracted fields: 21
[2025-10-26 01:10:24] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e872e5ae13
[2025-10-26 01:10:24] [INFO] Created Dispatches record with ID: 68fd7500174d3a484
[2025-10-26 01:10:24] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24483.xml
[2025-10-26 01:10:24] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24483.xml
[2025-10-26 03:46:33] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24494.xml
[2025-10-26 03:46:33] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24494.xml for user: 68d56363ec1209189
[2025-10-26 03:46:33] [INFO] File size: 1269 bytes
[2025-10-26 03:46:33] [INFO] Created FTPFiles record with ID: 68fd99996c111ae7c
[2025-10-26 03:46:33] [INFO] WE ARE HERE {"mappings":{"IncidentNumber":"dispatchRunNumber","house_number":"incidentLocationStreetNumber","street":"streetName","apt":"incidentLocationApt","city":"incidentLocationCity","location_name":"businessName","STATE":"incidentLocationStateName","ZIPCODE":"nERISIncidentPostalCode","LATITUDE":"nERISIncidentLatitude","LONGITUDE":"nERISIncidentLongitude","incident_type":"incidentTypeValue1","commentlist.comment":["dispatchNotes","cADLog"],"time_first_unit_assigned":["alarm","dispatched"],"time_first_unit_arrived":"onScene","time_last_unit_cleared":["cleared","inService"],"Units.Unit[0].radio_name":["cADVehicleID","name"],"Units.Unit[0].time_enroute":"timeenroutetoscene","Units.Unit[0].time_arrivedatscene":"timeonscene","Units.Unit[0].time_depart_scene":"timeunitclear","Units.Unit[0].time_assigned":"timedispatch"},"selectedRecord":{"id":"68eeb2639352dd41d","name":null},"fieldExamples":{"IncidentNumber":{"name":"IncidentNumber","value":"25-23514","type":"text"},"house_number":{"name":"house_number","value":"515","type":"number"},"street":{"name":"street","value":"LINDENWOOD AVE","type":"address"},"apt":{"name":"apt","value":"Array","type":"text"},"city":{"name":"city","value":"Array","type":"address"},"location_name":{"name":"location_name","value":"Array","type":"text"},"STATE":{"name":"STATE","value":"Array","type":"address"},"ZIPCODE":{"name":"ZIPCODE","value":"Array","type":"address"},"LATITUDE":{"name":"LATITUDE","value":"0","type":"coordinate"},"LONGITUDE":{"name":"LONGITUDE","value":"0","type":"coordinate"},"incident_type":{"name":"incident_type","value":"FIRE-GAS LEAK","type":"text"},"commentlist.comment":{"name":"comment","value":"10-14-2025 15:05:06|B45 ADVISED HE WOULD NOTIFY GAS CO 10-14-2025 15:05:23|B46 NOTHING SHOWING 10-14-2025 15:08:22|B46 ADVISED NO SMELL OF GAS HOWEVER ALARMS GOING OFF 10-14-2025 15:13:38|B46 CLEARED ","type":"text"},"time_first_unit_assigned":{"name":"time_first_unit_assigned","value":"10-14-2025T15:04:42","type":"datetime"},"time_first_unit_arrived":{"name":"time_first_unit_arrived","value":"10-14-2025T15:07:19","type":"datetime"},"time_last_unit_cleared":{"name":"time_last_unit_cleared","value":"10-14-2025T15:27:23","type":"datetime"},"Units.Unit[0].radio_name":{"name":"radio_name","value":"ENG2","type":"text"},"Units.Unit[0].time_enroute":{"name":"time_enroute","value":"10-14-2025T15:04:46","type":"datetime"},"Units.Unit[0].time_arrivedatscene":{"name":"time_arrivedatscene","value":"10-14-2025T15:08:38","type":"datetime"},"Units.Unit[0].time_depart_scene":{"name":"time_depart_scene","value":"10-14-2025T15:27:23","type":"datetime"},"Units.Unit[0].time_assigned":{"name":"time_assigned","value":"10-14-2025T15:04:42","type":"datetime"}},"timestamp":"2025-10-16T18:16:37.381Z"}
[2025-10-26 03:46:33] [INFO] About to extract fields from XML. File size: 1269 bytes
[2025-10-26 03:46:33] [INFO] Number of mappings: 20
[2025-10-26 03:46:33] [INFO] Starting XML parsing. Content length: 1269
[2025-10-26 03:46:33] [INFO] XML parsed successfully. Root element: Incident
[2025-10-26 03:46:33] [INFO] Processing 20 field mappings
[2025-10-26 03:46:33] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-10-26 03:46:33] [INFO]   -> Found value: 25-24494
[2025-10-26 03:46:33] [INFO]   -> Set field 'dispatchRunNumber' = "25-24494"
[2025-10-26 03:46:33] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-10-26 03:46:33] [INFO]   -> Found value: 1008
[2025-10-26 03:46:33] [INFO]   -> Set field 'incidentLocationStreetNumber' = 1008
[2025-10-26 03:46:33] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-10-26 03:46:33] [INFO]   -> Found value: N MAIN ST
[2025-10-26 03:46:33] [INFO]   -> Set field 'streetName' = "N MAIN ST"
[2025-10-26 03:46:33] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-10-26 03:46:33] [INFO]   -> No value found (null or empty)
[2025-10-26 03:46:33] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-10-26 03:46:33] [INFO]   -> Found value: SIKESTON
[2025-10-26 03:46:33] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-10-26 03:46:33] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-10-26 03:46:33] [INFO]   -> Found value: MDMC
[2025-10-26 03:46:33] [INFO]   -> Set field 'businessName' = "MDMC"
[2025-10-26 03:46:33] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-10-26 03:46:33] [INFO]   -> Found value: MO
[2025-10-26 03:46:33] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-10-26 03:46:33] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-10-26 03:46:33] [INFO]   -> Found value: 63801
[2025-10-26 03:46:33] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-10-26 03:46:33] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-10-26 03:46:33] [INFO]   -> Found value: 0
[2025-10-26 03:46:33] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-10-26 03:46:33] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-10-26 03:46:33] [INFO]   -> Found value: 0
[2025-10-26 03:46:33] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-10-26 03:46:33] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-10-26 03:46:33] [INFO]   -> Found value: FIRE-AIRCRAFT STANDBY
[2025-10-26 03:46:33] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-AIRCRAFT STANDBY"
[2025-10-26 03:46:33] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-10-26 03:46:33] [INFO]   -> No value found (null or empty)
[2025-10-26 03:46:33] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-10-26 03:46:33] [INFO]   -> Found value: 10-25-2025T22:45:07
[2025-10-26 03:46:33] [ERROR] Error formatting datetime '10-25-2025T22:45:07': Failed to parse time string (10-25-2025T22:45:07) at position 0 (1): Unexpected character
[2025-10-26 03:46:33] [INFO]   -> Set field 'alarm' = null
[2025-10-26 03:46:33] [ERROR] Error formatting datetime '10-25-2025T22:45:07': Failed to parse time string (10-25-2025T22:45:07) at position 0 (1): Unexpected character
[2025-10-26 03:46:33] [INFO]   -> Set field 'dispatched' = null
[2025-10-26 03:46:33] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-10-26 03:46:33] [INFO]   -> No value found (null or empty)
[2025-10-26 03:46:33] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-10-26 03:46:33] [INFO]   -> No value found (null or empty)
[2025-10-26 03:46:33] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-10-26 03:46:33] [INFO]   -> Found value: L3
[2025-10-26 03:46:33] [INFO]   -> Set field 'cADVehicleID' = "L3"
[2025-10-26 03:46:33] [INFO]   -> Set field 'name' = "L3"
[2025-10-26 03:46:33] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-10-26 03:46:33] [INFO]   -> No value found (null or empty)
[2025-10-26 03:46:33] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-10-26 03:46:33] [INFO]   -> No value found (null or empty)
[2025-10-26 03:46:33] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-10-26 03:46:33] [INFO]   -> Found value: 10-25-2025T22:45:35
[2025-10-26 03:46:33] [ERROR] Error formatting datetime '10-25-2025T22:45:35': Failed to parse time string (10-25-2025T22:45:35) at position 0 (1): Unexpected character
[2025-10-26 03:46:33] [INFO]   -> Set field 'timeunitclear' = null
[2025-10-26 03:46:33] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-10-26 03:46:33] [INFO]   -> Found value: 10-25-2025T22:45:22
[2025-10-26 03:46:33] [ERROR] Error formatting datetime '10-25-2025T22:45:22': Failed to parse time string (10-25-2025T22:45:22) at position 0 (1): Unexpected character
[2025-10-26 03:46:33] [INFO]   -> Set field 'timedispatch' = null
[2025-10-26 03:46:33] [INFO] Finished extracting fields. Total fields extracted: 16
[2025-10-26 03:46:33] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-24494","incidentLocationStreetNumber":1008,"streetName":"N MAIN ST","incidentLocationCity":"SIKESTON","businessName":"MDMC","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-AIRCRAFT STANDBY","alarm":null,"dispatched":null,"cADVehicleID":"L3","name":"L3","timeunitclear":null,"timedispatch":null}
[2025-10-26 03:46:33] [INFO] Number of extracted fields: 16
[2025-10-26 03:46:33] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e875662f9c
[2025-10-26 03:46:34] [INFO] Created Dispatches record with ID: 68fd999989092fe3b
[2025-10-26 03:46:34] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24494.xml
[2025-10-26 03:46:34] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24494.xml
[2025-10-26 17:30:53] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24527.xml
[2025-10-26 17:30:53] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24527.xml for user: 68d56363ec1209189
[2025-10-26 17:30:53] [INFO] File size: 1488 bytes
[2025-10-26 17:30:53] [INFO] Created FTPFiles record with ID: 68fe5acd33fac5fb8
[2025-10-26 17:30: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-10-26 17:30:53] [INFO] About to extract fields from XML. File size: 1488 bytes
[2025-10-26 17:30:53] [INFO] Number of mappings: 20
[2025-10-26 17:30:53] [INFO] Starting XML parsing. Content length: 1488
[2025-10-26 17:30:53] [INFO] XML parsed successfully. Root element: Incident
[2025-10-26 17:30:53] [INFO] Processing 20 field mappings
[2025-10-26 17:30:53] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-10-26 17:30:53] [INFO]   -> Found value: 25-24527
[2025-10-26 17:30:53] [INFO]   -> Set field 'dispatchRunNumber' = "25-24527"
[2025-10-26 17:30:53] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-10-26 17:30:53] [INFO]   -> Found value: 420
[2025-10-26 17:30:53] [INFO]   -> Set field 'incidentLocationStreetNumber' = 420
[2025-10-26 17:30:53] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-10-26 17:30:53] [INFO]   -> Found value: N MAIN ST
[2025-10-26 17:30:53] [INFO]   -> Set field 'streetName' = "N MAIN ST"
[2025-10-26 17:30:53] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-10-26 17:30:53] [INFO]   -> No value found (null or empty)
[2025-10-26 17:30:53] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-10-26 17:30:53] [INFO]   -> Found value: SIKESTON
[2025-10-26 17:30:53] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-10-26 17:30:53] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-10-26 17:30:53] [INFO]   -> Found value: BREAKTIME - N MAIN
[2025-10-26 17:30:53] [INFO]   -> Set field 'businessName' = "BREAKTIME - N MAIN"
[2025-10-26 17:30:53] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-10-26 17:30:53] [INFO]   -> Found value: MO
[2025-10-26 17:30:53] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-10-26 17:30:53] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-10-26 17:30:53] [INFO]   -> Found value: 63801
[2025-10-26 17:30:53] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-10-26 17:30:53] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-10-26 17:30:53] [INFO]   -> Found value: 0
[2025-10-26 17:30:53] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-10-26 17:30:53] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-10-26 17:30:53] [INFO]   -> Found value: 0
[2025-10-26 17:30:53] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-10-26 17:30:53] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-10-26 17:30:53] [INFO]   -> Found value: ACCIDENT-J2
[2025-10-26 17:30:53] [INFO]   -> Set field 'incidentTypeValue1' = "ACCIDENT-J2"
[2025-10-26 17:30:53] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-10-26 17:30:53] [INFO]   -> Found value: 10-26-2025 12:18:50|SILVER CHEVY MALIBU VS WHITE KIA OPTIMA 

62 YO MALE NECK HURTING 

BLOCKING TRA...
[2025-10-26 17:30:53] [INFO]   -> Set field 'dispatchNotes' = "10-26-2025 12:18:50|SILVER CHEVY MALIBU VS WHITE KIA OPTIMA \n\n62 YO MALE NECK HURTING \n\nBLOCKING TRAFFIC \n 10-26-2025 12:25:13|566 ON SCENE ADVISED INSIDE LANE IS BLOCKED"
[2025-10-26 17:30:53] [INFO]   -> Set field 'cADLog' = "10-26-2025 12:18:50|SILVER CHEVY MALIBU VS WHITE KIA OPTIMA \n\n62 YO MALE NECK HURTING \n\nBLOCKING TRAFFIC \n 10-26-2025 12:25:13|566 ON SCENE ADVISED INSIDE LANE IS BLOCKED"
[2025-10-26 17:30:53] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-10-26 17:30:53] [INFO]   -> No value found (null or empty)
[2025-10-26 17:30:53] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-10-26 17:30:53] [INFO]   -> Found value: 10-26-2025T12:24:57
[2025-10-26 17:30:53] [ERROR] Error formatting datetime '10-26-2025T12:24:57': Failed to parse time string (10-26-2025T12:24:57) at position 0 (1): Unexpected character
[2025-10-26 17:30:53] [INFO]   -> Set field 'onScene' = null
[2025-10-26 17:30:53] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-10-26 17:30:53] [INFO]   -> No value found (null or empty)
[2025-10-26 17:30:53] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-10-26 17:30:53] [INFO]   -> Found value: ENG2
[2025-10-26 17:30:53] [INFO]   -> Set field 'cADVehicleID' = "ENG2"
[2025-10-26 17:30:53] [INFO]   -> Set field 'name' = "ENG2"
[2025-10-26 17:30:53] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-10-26 17:30:53] [INFO]   -> Found value: 10-26-2025T12:22:17
[2025-10-26 17:30:53] [ERROR] Error formatting datetime '10-26-2025T12:22:17': Failed to parse time string (10-26-2025T12:22:17) at position 0 (1): Unexpected character
[2025-10-26 17:30:53] [INFO]   -> Set field 'timeenroutetoscene' = null
[2025-10-26 17:30:53] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-10-26 17:30:53] [INFO]   -> Found value: 10-26-2025T12:26:02
[2025-10-26 17:30:53] [ERROR] Error formatting datetime '10-26-2025T12:26:02': Failed to parse time string (10-26-2025T12:26:02) at position 0 (1): Unexpected character
[2025-10-26 17:30:53] [INFO]   -> Set field 'timeonscene' = null
[2025-10-26 17:30:53] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-10-26 17:30:53] [INFO]   -> Found value: 10-26-2025T12:30:27
[2025-10-26 17:30:53] [ERROR] Error formatting datetime '10-26-2025T12:30:27': Failed to parse time string (10-26-2025T12:30:27) at position 0 (1): Unexpected character
[2025-10-26 17:30:53] [INFO]   -> Set field 'timeunitclear' = null
[2025-10-26 17:30:53] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-10-26 17:30:53] [INFO]   -> No value found (null or empty)
[2025-10-26 17:30:53] [INFO] Finished extracting fields. Total fields extracted: 18
[2025-10-26 17:30:53] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-24527","incidentLocationStreetNumber":420,"streetName":"N MAIN ST","incidentLocationCity":"SIKESTON","businessName":"BREAKTIME - N MAIN","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"ACCIDENT-J2","dispatchNotes":"10-26-2025 12:18:50|SILVER CHEVY MALIBU VS WHITE KIA OPTIMA \n\n62 YO MALE NECK HURTING \n\nBLOCKING TRAFFIC \n 10-26-2025 12:25:13|566 ON SCENE ADVISED INSIDE LANE IS BLOCKED","cADLog":"10-26-2025 12:18:50|SILVER CHEVY MALIBU VS WHITE KIA OPTIMA \n\n62 YO MALE NECK HURTING \n\nBLOCKING TRAFFIC \n 10-26-2025 12:25:13|566 ON SCENE ADVISED INSIDE LANE IS BLOCKED","onScene":null,"cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":null,"timeonscene":null,"timeunitclear":null}
[2025-10-26 17:30:53] [INFO] Number of extracted fields: 18
[2025-10-26 17:30:53] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e87be42b7c
[2025-10-26 17:30:54] [INFO] Created Dispatches record with ID: 68fe5acd51e1a2b4f
[2025-10-26 17:30:54] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24527.xml
[2025-10-26 17:30:54] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24527.xml
[2025-10-26 23:03:28] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24542.xml
[2025-10-26 23:03:28] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24542.xml for user: 68d56363ec1209189
[2025-10-26 23:03:28] [INFO] File size: 2680 bytes
[2025-10-26 23:03:28] [INFO] Created FTPFiles record with ID: 68fea8c08f399f198
[2025-10-26 23:03:28] [INFO] WE ARE HERE {"mappings":{"IncidentNumber":"dispatchRunNumber","house_number":"incidentLocationStreetNumber","street":"streetName","apt":"incidentLocationApt","city":"incidentLocationCity","location_name":"businessName","STATE":"incidentLocationStateName","ZIPCODE":"nERISIncidentPostalCode","LATITUDE":"nERISIncidentLatitude","LONGITUDE":"nERISIncidentLongitude","incident_type":"incidentTypeValue1","commentlist.comment":["dispatchNotes","cADLog"],"time_first_unit_assigned":["alarm","dispatched"],"time_first_unit_arrived":"onScene","time_last_unit_cleared":["cleared","inService"],"Units.Unit[0].radio_name":["cADVehicleID","name"],"Units.Unit[0].time_enroute":"timeenroutetoscene","Units.Unit[0].time_arrivedatscene":"timeonscene","Units.Unit[0].time_depart_scene":"timeunitclear","Units.Unit[0].time_assigned":"timedispatch"},"selectedRecord":{"id":"68eeb2639352dd41d","name":null},"fieldExamples":{"IncidentNumber":{"name":"IncidentNumber","value":"25-23514","type":"text"},"house_number":{"name":"house_number","value":"515","type":"number"},"street":{"name":"street","value":"LINDENWOOD AVE","type":"address"},"apt":{"name":"apt","value":"Array","type":"text"},"city":{"name":"city","value":"Array","type":"address"},"location_name":{"name":"location_name","value":"Array","type":"text"},"STATE":{"name":"STATE","value":"Array","type":"address"},"ZIPCODE":{"name":"ZIPCODE","value":"Array","type":"address"},"LATITUDE":{"name":"LATITUDE","value":"0","type":"coordinate"},"LONGITUDE":{"name":"LONGITUDE","value":"0","type":"coordinate"},"incident_type":{"name":"incident_type","value":"FIRE-GAS LEAK","type":"text"},"commentlist.comment":{"name":"comment","value":"10-14-2025 15:05:06|B45 ADVISED HE WOULD NOTIFY GAS CO 10-14-2025 15:05:23|B46 NOTHING SHOWING 10-14-2025 15:08:22|B46 ADVISED NO SMELL OF GAS HOWEVER ALARMS GOING OFF 10-14-2025 15:13:38|B46 CLEARED ","type":"text"},"time_first_unit_assigned":{"name":"time_first_unit_assigned","value":"10-14-2025T15:04:42","type":"datetime"},"time_first_unit_arrived":{"name":"time_first_unit_arrived","value":"10-14-2025T15:07:19","type":"datetime"},"time_last_unit_cleared":{"name":"time_last_unit_cleared","value":"10-14-2025T15:27:23","type":"datetime"},"Units.Unit[0].radio_name":{"name":"radio_name","value":"ENG2","type":"text"},"Units.Unit[0].time_enroute":{"name":"time_enroute","value":"10-14-2025T15:04:46","type":"datetime"},"Units.Unit[0].time_arrivedatscene":{"name":"time_arrivedatscene","value":"10-14-2025T15:08:38","type":"datetime"},"Units.Unit[0].time_depart_scene":{"name":"time_depart_scene","value":"10-14-2025T15:27:23","type":"datetime"},"Units.Unit[0].time_assigned":{"name":"time_assigned","value":"10-14-2025T15:04:42","type":"datetime"}},"timestamp":"2025-10-16T18:16:37.381Z"}
[2025-10-26 23:03:28] [INFO] About to extract fields from XML. File size: 2680 bytes
[2025-10-26 23:03:28] [INFO] Number of mappings: 20
[2025-10-26 23:03:28] [INFO] Starting XML parsing. Content length: 2680
[2025-10-26 23:03:28] [INFO] XML parsed successfully. Root element: Incident
[2025-10-26 23:03:28] [INFO] Processing 20 field mappings
[2025-10-26 23:03:28] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-10-26 23:03:28] [INFO]   -> Found value: 25-24542
[2025-10-26 23:03:28] [INFO]   -> Set field 'dispatchRunNumber' = "25-24542"
[2025-10-26 23:03:28] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-10-26 23:03:28] [INFO]   -> Found value: 803
[2025-10-26 23:03:28] [INFO]   -> Set field 'incidentLocationStreetNumber' = 803
[2025-10-26 23:03:28] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-10-26 23:03:28] [INFO]   -> Found value: GREER AVE
[2025-10-26 23:03:28] [INFO]   -> Set field 'streetName' = "GREER AVE"
[2025-10-26 23:03:28] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-10-26 23:03:28] [INFO]   -> No value found (null or empty)
[2025-10-26 23:03:28] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-10-26 23:03:28] [INFO]   -> No value found (null or empty)
[2025-10-26 23:03:28] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-10-26 23:03:28] [INFO]   -> No value found (null or empty)
[2025-10-26 23:03:28] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-10-26 23:03:28] [INFO]   -> No value found (null or empty)
[2025-10-26 23:03:28] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-10-26 23:03:28] [INFO]   -> No value found (null or empty)
[2025-10-26 23:03:28] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-10-26 23:03:28] [INFO]   -> Found value: 0
[2025-10-26 23:03:28] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-10-26 23:03:28] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-10-26 23:03:28] [INFO]   -> Found value: 0
[2025-10-26 23:03:28] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-10-26 23:03:28] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-10-26 23:03:28] [INFO]   -> Found value: FIRE-STRUCTURE
[2025-10-26 23:03:28] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-STRUCTURE"
[2025-10-26 23:03:28] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-10-26 23:03:28] [INFO]   -> Found value: 10-26-2025 17:33:57|SPARKS FROM OUTLET 
SEE SMOKE BEHIND TV IN LIVING ROOM
MALE TURNED OFF FUSE BOX
...
[2025-10-26 23:03:28] [INFO]   -> Set field 'dispatchNotes' = "10-26-2025 17:33:57|SPARKS FROM OUTLET \nSEE SMOKE BEHIND TV IN LIVING ROOM\nMALE TURNED OFF FUSE BOX\nUNSURE IF THERE ARE ANY FLAMES\nSUBJECTS ARE OUT OF THE RESIDENCE 10-26-2025 17:41:09|BMU NOTIFIED 10-26-2025 17:41:34|LIBERY GAS CO CONTACTED 10-26-2025 17:41:59|B49 ON SCENE ADVISING NOTHING SHOWING 10-26-2025 17:42:26|537 ADVISED HYDRANT AT MATTHEWS AND ELM 10-26-2025 17:43:11|B49 ADVISED LIGHT SMOKE COMING FROM THE RESIDENCE  FLAMES WERE COMING FROM AN OUTLET 10-26-2025 17:45:03|B49 ADVISED CANCEL ALL UNITS NOT ON SCENE 10-26-2025 17:49:06|1514 CLEARED BY FIRE 10-26-2025 17:49:42|Disposition - SSCA:  RPT 10-26-2025 17:50:03|B49 TURNING OVER TO C90 10-26-2025 17:56:07|PER COMMAND L3 AND TWR1 RELEASED 10-26-2025 18:02:39|STRUCTURE VENTILATED AND TURNED OVER TO OCCUPANTS  ALL UNITS CLEAR"
[2025-10-26 23:03:28] [INFO]   -> Set field 'cADLog' = "10-26-2025 17:33:57|SPARKS FROM OUTLET \nSEE SMOKE BEHIND TV IN LIVING ROOM\nMALE TURNED OFF FUSE BOX\nUNSURE IF THERE ARE ANY FLAMES\nSUBJECTS ARE OUT OF THE RESIDENCE 10-26-2025 17:41:09|BMU NOTIFIED 10-26-2025 17:41:34|LIBERY GAS CO CONTACTED 10-26-2025 17:41:59|B49 ON SCENE ADVISING NOTHING SHOWING 10-26-2025 17:42:26|537 ADVISED HYDRANT AT MATTHEWS AND ELM 10-26-2025 17:43:11|B49 ADVISED LIGHT SMOKE COMING FROM THE RESIDENCE  FLAMES WERE COMING FROM AN OUTLET 10-26-2025 17:45:03|B49 ADVISED CANCEL ALL UNITS NOT ON SCENE 10-26-2025 17:49:06|1514 CLEARED BY FIRE 10-26-2025 17:49:42|Disposition - SSCA:  RPT 10-26-2025 17:50:03|B49 TURNING OVER TO C90 10-26-2025 17:56:07|PER COMMAND L3 AND TWR1 RELEASED 10-26-2025 18:02:39|STRUCTURE VENTILATED AND TURNED OVER TO OCCUPANTS  ALL UNITS CLEAR"
[2025-10-26 23:03:28] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-10-26 23:03:28] [INFO]   -> Found value: 10-26-2025T17:38:50
[2025-10-26 23:03:28] [ERROR] Error formatting datetime '10-26-2025T17:38:50': Failed to parse time string (10-26-2025T17:38:50) at position 0 (1): Unexpected character
[2025-10-26 23:03:28] [INFO]   -> Set field 'alarm' = null
[2025-10-26 23:03:28] [ERROR] Error formatting datetime '10-26-2025T17:38:50': Failed to parse time string (10-26-2025T17:38:50) at position 0 (1): Unexpected character
[2025-10-26 23:03:28] [INFO]   -> Set field 'dispatched' = null
[2025-10-26 23:03:28] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-10-26 23:03:28] [INFO]   -> Found value: 10-26-2025T17:42:04
[2025-10-26 23:03:28] [ERROR] Error formatting datetime '10-26-2025T17:42:04': Failed to parse time string (10-26-2025T17:42:04) at position 0 (1): Unexpected character
[2025-10-26 23:03:28] [INFO]   -> Set field 'onScene' = null
[2025-10-26 23:03:28] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-10-26 23:03:28] [INFO]   -> Found value: 10-26-2025T18:02:44
[2025-10-26 23:03:28] [ERROR] Error formatting datetime '10-26-2025T18:02:44': Failed to parse time string (10-26-2025T18:02:44) at position 0 (1): Unexpected character
[2025-10-26 23:03:28] [INFO]   -> Set field 'cleared' = null
[2025-10-26 23:03:28] [ERROR] Error formatting datetime '10-26-2025T18:02:44': Failed to parse time string (10-26-2025T18:02:44) at position 0 (1): Unexpected character
[2025-10-26 23:03:28] [INFO]   -> Set field 'inService' = null
[2025-10-26 23:03:28] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-10-26 23:03:28] [INFO]   -> Found value: ENG2
[2025-10-26 23:03:28] [INFO]   -> Set field 'cADVehicleID' = "ENG2"
[2025-10-26 23:03:28] [INFO]   -> Set field 'name' = "ENG2"
[2025-10-26 23:03:28] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-10-26 23:03:28] [INFO]   -> Found value: 10-26-2025T17:39:21
[2025-10-26 23:03:28] [ERROR] Error formatting datetime '10-26-2025T17:39:21': Failed to parse time string (10-26-2025T17:39:21) at position 0 (1): Unexpected character
[2025-10-26 23:03:28] [INFO]   -> Set field 'timeenroutetoscene' = null
[2025-10-26 23:03:28] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-10-26 23:03:28] [INFO]   -> Found value: 10-26-2025T17:42:30
[2025-10-26 23:03:28] [ERROR] Error formatting datetime '10-26-2025T17:42:30': Failed to parse time string (10-26-2025T17:42:30) at position 0 (1): Unexpected character
[2025-10-26 23:03:28] [INFO]   -> Set field 'timeonscene' = null
[2025-10-26 23:03:28] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-10-26 23:03:28] [INFO]   -> Found value: 10-26-2025T18:02:44
[2025-10-26 23:03:28] [ERROR] Error formatting datetime '10-26-2025T18:02:44': Failed to parse time string (10-26-2025T18:02:44) at position 0 (1): Unexpected character
[2025-10-26 23:03:28] [INFO]   -> Set field 'timeunitclear' = null
[2025-10-26 23:03:28] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-10-26 23:03:28] [INFO]   -> No value found (null or empty)
[2025-10-26 23:03:28] [INFO] Finished extracting fields. Total fields extracted: 18
[2025-10-26 23:03:28] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-24542","incidentLocationStreetNumber":803,"streetName":"GREER AVE","nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-STRUCTURE","dispatchNotes":"10-26-2025 17:33:57|SPARKS FROM OUTLET \nSEE SMOKE BEHIND TV IN LIVING ROOM\nMALE TURNED OFF FUSE BOX\nUNSURE IF THERE ARE ANY FLAMES\nSUBJECTS ARE OUT OF THE RESIDENCE 10-26-2025 17:41:09|BMU NOTIFIED 10-26-2025 17:41:34|LIBERY GAS CO CONTACTED 10-26-2025 17:41:59|B49 ON SCENE ADVISING NOTHING SHOWING 10-26-2025 17:42:26|537 ADVISED HYDRANT AT MATTHEWS AND ELM 10-26-2025 17:43:11|B49 ADVISED LIGHT SMOKE COMING FROM THE RESIDENCE  FLAMES WERE COMING FROM AN OUTLET 10-26-2025 17:45:03|B49 ADVISED CANCEL ALL UNITS NOT ON SCENE 10-26-2025 17:49:06|1514 CLEARED BY FIRE 10-26-2025 17:49:42|Disposition - SSCA:  RPT 10-26-2025 17:50:03|B49 TURNING OVER TO C90 10-26-2025 17:56:07|PER COMMAND L3 AND TWR1 RELEASED 10-26-2025 18:02:39|STRUCTURE VENTILATED AND TURNED OVER TO OCCUPANTS  ALL UNITS CLEAR","cADLog":"10-26-2025 17:33:57|SPARKS FROM OUTLET \nSEE SMOKE BEHIND TV IN LIVING ROOM\nMALE TURNED OFF FUSE BOX\nUNSURE IF THERE ARE ANY FLAMES\nSUBJECTS ARE OUT OF THE RESIDENCE 10-26-2025 17:41:09|BMU NOTIFIED 10-26-2025 17:41:34|LIBERY GAS CO CONTACTED 10-26-2025 17:41:59|B49 ON SCENE ADVISING NOTHING SHOWING 10-26-2025 17:42:26|537 ADVISED HYDRANT AT MATTHEWS AND ELM 10-26-2025 17:43:11|B49 ADVISED LIGHT SMOKE COMING FROM THE RESIDENCE  FLAMES WERE COMING FROM AN OUTLET 10-26-2025 17:45:03|B49 ADVISED CANCEL ALL UNITS NOT ON SCENE 10-26-2025 17:49:06|1514 CLEARED BY FIRE 10-26-2025 17:49:42|Disposition - SSCA:  RPT 10-26-2025 17:50:03|B49 TURNING OVER TO C90 10-26-2025 17:56:07|PER COMMAND L3 AND TWR1 RELEASED 10-26-2025 18:02:39|STRUCTURE VENTILATED AND TURNED OVER TO OCCUPANTS  ALL UNITS CLEAR","alarm":null,"dispatched":null,"onScene":null,"cleared":null,"inService":null,"cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":null,"timeonscene":null,"timeunitclear":null}
[2025-10-26 23:03:28] [INFO] Number of extracted fields: 18
[2025-10-26 23:03:28] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e868e55c0c
[2025-10-26 23:03:29] [INFO] Created Dispatches record with ID: 68fea8c0acd2fbb8b
[2025-10-26 23:03:29] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24542.xml
[2025-10-26 23:03:29] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-24542.xml