[2025-11-27 00:04:55] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27802.xml
[2025-11-27 00:04:55] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27802.xml for user: 68d56363ec1209189
[2025-11-27 00:04:55] [INFO] File size: 1324 bytes
[2025-11-27 00:04:55] [INFO] Created FTPFiles record with ID: 692795a783418635f
[2025-11-27 00:04: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-27 00:04:55] [INFO] About to extract fields from XML. File size: 1324 bytes
[2025-11-27 00:04:55] [INFO] Number of mappings: 20
[2025-11-27 00:04:55] [INFO] Starting XML parsing. Content length: 1324
[2025-11-27 00:04:55] [INFO] XML parsed successfully. Root element: Incident
[2025-11-27 00:04:55] [INFO] Processing 20 field mappings
[2025-11-27 00:04:55] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-27 00:04:55] [INFO]   -> Found value: 25-27802
[2025-11-27 00:04:55] [INFO]   -> Set field 'dispatchRunNumber' = "25-27802"
[2025-11-27 00:04:55] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-27 00:04:55] [INFO]   -> Found value: 201
[2025-11-27 00:04:55] [INFO]   -> Set field 'incidentLocationStreetNumber' = 201
[2025-11-27 00:04:55] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-27 00:04:55] [INFO]   -> Found value: S KINGSHIGHWAY
[2025-11-27 00:04:55] [INFO]   -> Set field 'streetName' = "S KINGSHIGHWAY"
[2025-11-27 00:04:55] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-27 00:04:55] [INFO]   -> No value found (null or empty)
[2025-11-27 00:04:55] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-27 00:04:55] [INFO]   -> Found value: SIKESTON
[2025-11-27 00:04:55] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-27 00:04:55] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-27 00:04:55] [INFO]   -> Found value: SIKESTON DPS
[2025-11-27 00:04:55] [INFO]   -> Set field 'businessName' = "SIKESTON DPS"
[2025-11-27 00:04:55] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-27 00:04:55] [INFO]   -> Found value: MO
[2025-11-27 00:04:55] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-27 00:04:55] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-27 00:04:55] [INFO]   -> Found value: 63801
[2025-11-27 00:04:55] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-27 00:04:55] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-27 00:04:55] [INFO]   -> No value found (null or empty)
[2025-11-27 00:04:55] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-27 00:04:55] [INFO]   -> No value found (null or empty)
[2025-11-27 00:04:55] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-27 00:04:55] [INFO]   -> Found value: WED 1800 HR PAGER TEST
[2025-11-27 00:04:55] [INFO]   -> Set field 'incidentTypeValue1' = "WED 1800 HR PAGER TEST"
[2025-11-27 00:04:55] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-27 00:04:55] [INFO]   -> Found value: 11-26-2025 18:00:00|WED EVENING PAGER TEST
[2025-11-27 00:04:55] [INFO]   -> Set field 'dispatchNotes' = "11-26-2025 18:00:00|WED EVENING PAGER TEST"
[2025-11-27 00:04:55] [INFO]   -> Set field 'cADLog' = "11-26-2025 18:00:00|WED EVENING PAGER TEST"
[2025-11-27 00:04:55] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-27 00:04:55] [INFO]   -> Found value: 11-26-2025T18:01:15
[2025-11-27 00:04:55] [ERROR] Error formatting datetime '11-26-2025T18:01:15': Failed to parse time string (11-26-2025T18:01:15) at position 0 (1): Unexpected character
[2025-11-27 00:04:55] [INFO]   -> Set field 'alarm' = null
[2025-11-27 00:04:55] [ERROR] Error formatting datetime '11-26-2025T18:01:15': Failed to parse time string (11-26-2025T18:01:15) at position 0 (1): Unexpected character
[2025-11-27 00:04:55] [INFO]   -> Set field 'dispatched' = null
[2025-11-27 00:04:55] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-27 00:04:55] [INFO]   -> No value found (null or empty)
[2025-11-27 00:04:55] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-27 00:04:55] [INFO]   -> No value found (null or empty)
[2025-11-27 00:04:55] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-27 00:04:55] [INFO]   -> Found value: SIK STILL
[2025-11-27 00:04:55] [INFO]   -> Set field 'cADVehicleID' = "SIK STILL"
[2025-11-27 00:04:55] [INFO]   -> Set field 'name' = "SIK STILL"
[2025-11-27 00:04:55] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-27 00:04:55] [INFO]   -> No value found (null or empty)
[2025-11-27 00:04:55] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-27 00:04:55] [INFO]   -> No value found (null or empty)
[2025-11-27 00:04:55] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-27 00:04:55] [INFO]   -> Found value: 11-26-2025T18:04:18
[2025-11-27 00:04:55] [ERROR] Error formatting datetime '11-26-2025T18:04:18': Failed to parse time string (11-26-2025T18:04:18) at position 0 (1): Unexpected character
[2025-11-27 00:04:55] [INFO]   -> Set field 'timeunitclear' = null
[2025-11-27 00:04:55] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-27 00:04:55] [INFO]   -> Found value: 11-26-2025T18:01:15
[2025-11-27 00:04:55] [ERROR] Error formatting datetime '11-26-2025T18:01:15': Failed to parse time string (11-26-2025T18:01:15) at position 0 (1): Unexpected character
[2025-11-27 00:04:55] [INFO]   -> Set field 'timedispatch' = null
[2025-11-27 00:04:55] [INFO] Finished extracting fields. Total fields extracted: 16
[2025-11-27 00:04:55] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-27802","incidentLocationStreetNumber":201,"streetName":"S KINGSHIGHWAY","incidentLocationCity":"SIKESTON","businessName":"SIKESTON DPS","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"incidentTypeValue1":"WED 1800 HR PAGER TEST","dispatchNotes":"11-26-2025 18:00:00|WED EVENING PAGER TEST","cADLog":"11-26-2025 18:00:00|WED EVENING PAGER TEST","alarm":null,"dispatched":null,"cADVehicleID":"SIK STILL","name":"SIK STILL","timeunitclear":null,"timedispatch":null}
[2025-11-27 00:04:55] [INFO] Number of extracted fields: 16
[2025-11-27 00:04:55] [INFO] Found existing IncidentTypeMapping with ID: 691e5c32443e1aa70
[2025-11-27 00:04:55] [INFO] Found existing Dispatch with cADNumber '25-27802', ID: 692794ea47230f808 - will update instead of create
[2025-11-27 00:04:55] [INFO] Updated existing Dispatches record with ID: 692794ea47230f808
[2025-11-27 00:04:55] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27802.xml
[2025-11-27 00:04:55] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27802.xml
[2025-11-27 01:07:45] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27803.xml
[2025-11-27 01:07:45] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27803.xml for user: 68d56363ec1209189
[2025-11-27 01:07:45] [INFO] File size: 2515 bytes
[2025-11-27 01:07:45] [INFO] Created FTPFiles record with ID: 6927a46189642fddf
[2025-11-27 01:07:45] [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-27 01:07:45] [INFO] About to extract fields from XML. File size: 2515 bytes
[2025-11-27 01:07:45] [INFO] Number of mappings: 20
[2025-11-27 01:07:45] [INFO] Starting XML parsing. Content length: 2515
[2025-11-27 01:07:45] [INFO] XML parsed successfully. Root element: Incident
[2025-11-27 01:07:45] [INFO] Processing 20 field mappings
[2025-11-27 01:07:45] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-27 01:07:45] [INFO]   -> Found value: 25-27803
[2025-11-27 01:07:45] [INFO]   -> Set field 'dispatchRunNumber' = "25-27803"
[2025-11-27 01:07:45] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-27 01:07:45] [INFO]   -> Found value: 240
[2025-11-27 01:07:45] [INFO]   -> Set field 'incidentLocationStreetNumber' = 240
[2025-11-27 01:07:45] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-27 01:07:45] [INFO]   -> Found value: W GLADYS ST
[2025-11-27 01:07:45] [INFO]   -> Set field 'streetName' = "W GLADYS ST"
[2025-11-27 01:07:45] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-27 01:07:45] [INFO]   -> No value found (null or empty)
[2025-11-27 01:07:45] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-27 01:07:45] [INFO]   -> Found value: SIKESTON
[2025-11-27 01:07:45] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-27 01:07:45] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-27 01:07:45] [INFO]   -> No value found (null or empty)
[2025-11-27 01:07:45] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-27 01:07:45] [INFO]   -> Found value: MO
[2025-11-27 01:07:45] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-27 01:07:45] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-27 01:07:45] [INFO]   -> Found value: 63801
[2025-11-27 01:07:45] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-27 01:07:45] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-27 01:07:45] [INFO]   -> Found value: 0
[2025-11-27 01:07:45] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-27 01:07:45] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-27 01:07:45] [INFO]   -> Found value: 0
[2025-11-27 01:07:45] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-27 01:07:45] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-27 01:07:45] [INFO]   -> Found value: FIRE-VEHICLE
[2025-11-27 01:07:45] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-VEHICLE"
[2025-11-27 01:07:45] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-27 01:07:45] [INFO]   -> Found value: 11-26-2025 17:59:54|MOBILE HOME ON FIRE 

HEAVY BLACK SMOKE AND ACTIVE FLAMES 

IN THE BACK YARD 

 ...
[2025-11-27 01:07:45] [INFO]   -> Set field 'dispatchNotes' = "11-26-2025 17:59:54|MOBILE HOME ON FIRE \n\nHEAVY BLACK SMOKE AND ACTIVE FLAMES \n\nIN THE BACK YARD \n\n 11-26-2025 18:03:52|****** Appended notes from Work Area begin ******\nAddress: KENDALL ST, SIKESTON Intersection: SCHOOL ST\nSector: 1 Source: E911 \nLaw Enf: SDPS PD Fire: SDPS FD EMS: SSCA \nOpened DateTime: 11\/26\/2025 18:02:19\nNotes: CAMPER ON FIRE\nRP DOES NOT KNOW FURTHER - RP IS A PASSER BY\n****** Appended notes from Work Area end   ******\n 11-26-2025 18:07:17|ENG 2 ON SCENE FULLY ENGULFED  HYDRANT AT SCHOOL AND STODDARD 11-26-2025 18:15:46|C92 ADVISED UNDER CONTROL 11-26-2025 18:48:12|Disposition - SDPS PD:  NRN"
[2025-11-27 01:07:45] [INFO]   -> Set field 'cADLog' = "11-26-2025 17:59:54|MOBILE HOME ON FIRE \n\nHEAVY BLACK SMOKE AND ACTIVE FLAMES \n\nIN THE BACK YARD \n\n 11-26-2025 18:03:52|****** Appended notes from Work Area begin ******\nAddress: KENDALL ST, SIKESTON Intersection: SCHOOL ST\nSector: 1 Source: E911 \nLaw Enf: SDPS PD Fire: SDPS FD EMS: SSCA \nOpened DateTime: 11\/26\/2025 18:02:19\nNotes: CAMPER ON FIRE\nRP DOES NOT KNOW FURTHER - RP IS A PASSER BY\n****** Appended notes from Work Area end   ******\n 11-26-2025 18:07:17|ENG 2 ON SCENE FULLY ENGULFED  HYDRANT AT SCHOOL AND STODDARD 11-26-2025 18:15:46|C92 ADVISED UNDER CONTROL 11-26-2025 18:48:12|Disposition - SDPS PD:  NRN"
[2025-11-27 01:07:45] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-27 01:07:45] [INFO]   -> Found value: 11-26-2025T18:04:12
[2025-11-27 01:07:45] [ERROR] Error formatting datetime '11-26-2025T18:04:12': Failed to parse time string (11-26-2025T18:04:12) at position 0 (1): Unexpected character
[2025-11-27 01:07:45] [INFO]   -> Set field 'alarm' = null
[2025-11-27 01:07:45] [ERROR] Error formatting datetime '11-26-2025T18:04:12': Failed to parse time string (11-26-2025T18:04:12) at position 0 (1): Unexpected character
[2025-11-27 01:07:45] [INFO]   -> Set field 'dispatched' = null
[2025-11-27 01:07:45] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-27 01:07:45] [INFO]   -> Found value: 11-26-2025T18:06:42
[2025-11-27 01:07:45] [ERROR] Error formatting datetime '11-26-2025T18:06:42': Failed to parse time string (11-26-2025T18:06:42) at position 0 (1): Unexpected character
[2025-11-27 01:07:45] [INFO]   -> Set field 'onScene' = null
[2025-11-27 01:07:45] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-27 01:07:45] [INFO]   -> Found value: 11-26-2025T19:06:45
[2025-11-27 01:07:45] [ERROR] Error formatting datetime '11-26-2025T19:06:45': Failed to parse time string (11-26-2025T19:06:45) at position 0 (1): Unexpected character
[2025-11-27 01:07:45] [INFO]   -> Set field 'cleared' = null
[2025-11-27 01:07:45] [ERROR] Error formatting datetime '11-26-2025T19:06:45': Failed to parse time string (11-26-2025T19:06:45) at position 0 (1): Unexpected character
[2025-11-27 01:07:45] [INFO]   -> Set field 'inService' = null
[2025-11-27 01:07:45] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-27 01:07:45] [INFO]   -> Found value: ENG1
[2025-11-27 01:07:45] [INFO]   -> Set field 'cADVehicleID' = "ENG1"
[2025-11-27 01:07:45] [INFO]   -> Set field 'name' = "ENG1"
[2025-11-27 01:07:45] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-27 01:07:45] [INFO]   -> Found value: 11-26-2025T18:05:20
[2025-11-27 01:07:45] [ERROR] Error formatting datetime '11-26-2025T18:05:20': Failed to parse time string (11-26-2025T18:05:20) at position 0 (1): Unexpected character
[2025-11-27 01:07:45] [INFO]   -> Set field 'timeenroutetoscene' = null
[2025-11-27 01:07:45] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-27 01:07:45] [INFO]   -> Found value: 11-26-2025T18:15:34
[2025-11-27 01:07:45] [ERROR] Error formatting datetime '11-26-2025T18:15:34': Failed to parse time string (11-26-2025T18:15:34) at position 0 (1): Unexpected character
[2025-11-27 01:07:45] [INFO]   -> Set field 'timeonscene' = null
[2025-11-27 01:07:45] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-27 01:07:45] [INFO]   -> Found value: 11-26-2025T19:06:45
[2025-11-27 01:07:45] [ERROR] Error formatting datetime '11-26-2025T19:06:45': Failed to parse time string (11-26-2025T19:06:45) at position 0 (1): Unexpected character
[2025-11-27 01:07:45] [INFO]   -> Set field 'timeunitclear' = null
[2025-11-27 01:07:45] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-27 01:07:45] [INFO]   -> No value found (null or empty)
[2025-11-27 01:07:45] [INFO] Finished extracting fields. Total fields extracted: 21
[2025-11-27 01:07:45] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-27803","incidentLocationStreetNumber":240,"streetName":"W GLADYS ST","incidentLocationCity":"SIKESTON","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-VEHICLE","dispatchNotes":"11-26-2025 17:59:54|MOBILE HOME ON FIRE \n\nHEAVY BLACK SMOKE AND ACTIVE FLAMES \n\nIN THE BACK YARD \n\n 11-26-2025 18:03:52|****** Appended notes from Work Area begin ******\nAddress: KENDALL ST, SIKESTON Intersection: SCHOOL ST\nSector: 1 Source: E911 \nLaw Enf: SDPS PD Fire: SDPS FD EMS: SSCA \nOpened DateTime: 11\/26\/2025 18:02:19\nNotes: CAMPER ON FIRE\nRP DOES NOT KNOW FURTHER - RP IS A PASSER BY\n****** Appended notes from Work Area end   ******\n 11-26-2025 18:07:17|ENG 2 ON SCENE FULLY ENGULFED  HYDRANT AT SCHOOL AND STODDARD 11-26-2025 18:15:46|C92 ADVISED UNDER CONTROL 11-26-2025 18:48:12|Disposition - SDPS PD:  NRN","cADLog":"11-26-2025 17:59:54|MOBILE HOME ON FIRE \n\nHEAVY BLACK SMOKE AND ACTIVE FLAMES \n\nIN THE BACK YARD \n\n 11-26-2025 18:03:52|****** Appended notes from Work Area begin ******\nAddress: KENDALL ST, SIKESTON Intersection: SCHOOL ST\nSector: 1 Source: E911 \nLaw Enf: SDPS PD Fire: SDPS FD EMS: SSCA \nOpened DateTime: 11\/26\/2025 18:02:19\nNotes: CAMPER ON FIRE\nRP DOES NOT KNOW FURTHER - RP IS A PASSER BY\n****** Appended notes from Work Area end   ******\n 11-26-2025 18:07:17|ENG 2 ON SCENE FULLY ENGULFED  HYDRANT AT SCHOOL AND STODDARD 11-26-2025 18:15:46|C92 ADVISED UNDER CONTROL 11-26-2025 18:48:12|Disposition - SDPS PD:  NRN","alarm":null,"dispatched":null,"onScene":null,"cleared":null,"inService":null,"cADVehicleID":"ENG1","name":"ENG1","timeenroutetoscene":null,"timeonscene":null,"timeunitclear":null}
[2025-11-27 01:07:45] [INFO] Number of extracted fields: 21
[2025-11-27 01:07:45] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e883a748d2
[2025-11-27 01:07:46] [INFO] Created new Dispatches record with ID: 6927a461bedbb2429
[2025-11-27 01:07:46] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27803.xml
[2025-11-27 01:07:46] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27803.xml
[2025-11-27 21:41:38] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27884.xml
[2025-11-27 21:41:38] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27884.xml for user: 68d56363ec1209189
[2025-11-27 21:41:38] [INFO] File size: 2111 bytes
[2025-11-27 21:41:38] [INFO] Created FTPFiles record with ID: 6928c592429eadb49
[2025-11-27 21:41:38] [INFO] About to extract fields from XML. File size: 2111 bytes
[2025-11-27 21:41:38] [INFO] Number of mappings: 20
[2025-11-27 21:41:38] [INFO] Starting XML parsing. Content length: 2111
[2025-11-27 21:41:38] [INFO] XML parsed successfully. Root element: Incident
[2025-11-27 21:41:38] [INFO] Processing 20 field mappings
[2025-11-27 21:41:38] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-27 21:41:38] [INFO]   -> Found value: 25-27884
[2025-11-27 21:41:38] [INFO]   -> Set field 'dispatchRunNumber' = "25-27884"
[2025-11-27 21:41:38] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-27 21:41:38] [INFO]   -> Found value: 313
[2025-11-27 21:41:38] [INFO]   -> Set field 'incidentLocationStreetNumber' = 313
[2025-11-27 21:41:38] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-27 21:41:38] [INFO]   -> Found value: BROADWAY ST
[2025-11-27 21:41:38] [INFO]   -> Set field 'streetName' = "BROADWAY ST"
[2025-11-27 21:41:38] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-27 21:41:38] [INFO]   -> No value found (null or empty)
[2025-11-27 21:41:38] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-27 21:41:38] [INFO]   -> Found value: SIKESTON
[2025-11-27 21:41:38] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-27 21:41:38] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-27 21:41:38] [INFO]   -> No value found (null or empty)
[2025-11-27 21:41:38] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-27 21:41:38] [INFO]   -> Found value: MO
[2025-11-27 21:41:38] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-27 21:41:38] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-27 21:41:38] [INFO]   -> Found value: 63801
[2025-11-27 21:41:38] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-27 21:41:38] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-27 21:41:38] [INFO]   -> Found value: 0
[2025-11-27 21:41:38] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-27 21:41:38] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-27 21:41:38] [INFO]   -> Found value: 0
[2025-11-27 21:41:38] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-27 21:41:38] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-27 21:41:38] [INFO]   -> Found value: FIRE-ALARM MECH
[2025-11-27 21:41:38] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-ALARM MECH"
[2025-11-27 21:41:38] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-27 21:41:38] [INFO]   -> Found value: 11-27-2025 15:32:13|NON-LABELED SMOKE DETECTOR - NO ROOM LABEL
ALARM COMPANY TRIED KEYHOLDER BUT NO ...
[2025-11-27 21:41:38] [INFO]   -> Set field 'dispatchNotes' = "11-27-2025 15:32:13|NON-LABELED SMOKE DETECTOR - NO ROOM LABEL\nALARM COMPANY TRIED KEYHOLDER BUT NO CONTACT\nPAMELA WALLS 573-902-8223 11-27-2025 15:38:09|SINGLE STORY NOTHING SHOWING PER ENG 1 11-27-2025 15:40:10|C92 NO FIRE DRY COOKING"
[2025-11-27 21:41:38] [INFO]   -> Set field 'cADLog' = "11-27-2025 15:32:13|NON-LABELED SMOKE DETECTOR - NO ROOM LABEL\nALARM COMPANY TRIED KEYHOLDER BUT NO CONTACT\nPAMELA WALLS 573-902-8223 11-27-2025 15:38:09|SINGLE STORY NOTHING SHOWING PER ENG 1 11-27-2025 15:40:10|C92 NO FIRE DRY COOKING"
[2025-11-27 21:41:38] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-27 21:41:38] [INFO]   -> Found value: 11-27-2025T15:33:32
[2025-11-27 21:41:38] [ERROR] Error formatting datetime '11-27-2025T15:33:32': Failed to parse time string (11-27-2025T15:33:32) at position 0 (1): Unexpected character
[2025-11-27 21:41:38] [INFO]   -> Set field 'alarm' = null
[2025-11-27 21:41:38] [ERROR] Error formatting datetime '11-27-2025T15:33:32': Failed to parse time string (11-27-2025T15:33:32) at position 0 (1): Unexpected character
[2025-11-27 21:41:38] [INFO]   -> Set field 'dispatched' = null
[2025-11-27 21:41:38] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-27 21:41:38] [INFO]   -> Found value: 11-27-2025T15:34:03
[2025-11-27 21:41:38] [ERROR] Error formatting datetime '11-27-2025T15:34:03': Failed to parse time string (11-27-2025T15:34:03) at position 0 (1): Unexpected character
[2025-11-27 21:41:38] [INFO]   -> Set field 'onScene' = null
[2025-11-27 21:41:38] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-27 21:41:38] [INFO]   -> Found value: 11-27-2025T15:40:17
[2025-11-27 21:41:38] [ERROR] Error formatting datetime '11-27-2025T15:40:17': Failed to parse time string (11-27-2025T15:40:17) at position 0 (1): Unexpected character
[2025-11-27 21:41:38] [INFO]   -> Set field 'cleared' = null
[2025-11-27 21:41:38] [ERROR] Error formatting datetime '11-27-2025T15:40:17': Failed to parse time string (11-27-2025T15:40:17) at position 0 (1): Unexpected character
[2025-11-27 21:41:38] [INFO]   -> Set field 'inService' = null
[2025-11-27 21:41:38] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-27 21:41:38] [INFO]   -> Found value: ENG1
[2025-11-27 21:41:38] [INFO]   -> Set field 'cADVehicleID' = "ENG1"
[2025-11-27 21:41:38] [INFO]   -> Set field 'name' = "ENG1"
[2025-11-27 21:41:38] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-27 21:41:38] [INFO]   -> Found value: 11-27-2025T15:34:11
[2025-11-27 21:41:38] [ERROR] Error formatting datetime '11-27-2025T15:34:11': Failed to parse time string (11-27-2025T15:34:11) at position 0 (1): Unexpected character
[2025-11-27 21:41:38] [INFO]   -> Set field 'timeenroutetoscene' = null
[2025-11-27 21:41:38] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-27 21:41:38] [INFO]   -> Found value: 11-27-2025T15:34:08
[2025-11-27 21:41:38] [ERROR] Error formatting datetime '11-27-2025T15:34:08': Failed to parse time string (11-27-2025T15:34:08) at position 0 (1): Unexpected character
[2025-11-27 21:41:38] [INFO]   -> Set field 'timeonscene' = null
[2025-11-27 21:41:38] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-27 21:41:38] [INFO]   -> Found value: 11-27-2025T15:40:17
[2025-11-27 21:41:38] [ERROR] Error formatting datetime '11-27-2025T15:40:17': Failed to parse time string (11-27-2025T15:40:17) at position 0 (1): Unexpected character
[2025-11-27 21:41:38] [INFO]   -> Set field 'timeunitclear' = null
[2025-11-27 21:41:38] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-27 21:41:38] [INFO]   -> No value found (null or empty)
[2025-11-27 21:41:38] [INFO] Finished extracting fields. Total fields extracted: 21
[2025-11-27 21:41:38] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-27884","incidentLocationStreetNumber":313,"streetName":"BROADWAY ST","incidentLocationCity":"SIKESTON","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-ALARM MECH","dispatchNotes":"11-27-2025 15:32:13|NON-LABELED SMOKE DETECTOR - NO ROOM LABEL\nALARM COMPANY TRIED KEYHOLDER BUT NO CONTACT\nPAMELA WALLS 573-902-8223 11-27-2025 15:38:09|SINGLE STORY NOTHING SHOWING PER ENG 1 11-27-2025 15:40:10|C92 NO FIRE DRY COOKING","cADLog":"11-27-2025 15:32:13|NON-LABELED SMOKE DETECTOR - NO ROOM LABEL\nALARM COMPANY TRIED KEYHOLDER BUT NO CONTACT\nPAMELA WALLS 573-902-8223 11-27-2025 15:38:09|SINGLE STORY NOTHING SHOWING PER ENG 1 11-27-2025 15:40:10|C92 NO FIRE DRY COOKING","alarm":null,"dispatched":null,"onScene":null,"cleared":null,"inService":null,"cADVehicleID":"ENG1","name":"ENG1","timeenroutetoscene":null,"timeonscene":null,"timeunitclear":null}
[2025-11-27 21:41:38] [INFO] Number of extracted fields: 21
[2025-11-27 21:41:38] [INFO] Multi-agency routing check: CAD Agency ID = NULL, Assigned Agencies count = 2
[2025-11-27 21:41:38] [INFO] Single-agency mode: Using mailbox saasclientId: 6772cab7157b2ebde
[2025-11-27 21:41:38] [INFO] Final routing: saasclientId = 6772cab7157b2ebde, dispatchStationsIds = ["67d843b7d3670caf0","67d843823ed523b5c","67d8434fe3dc432c7","68d5ab6eaa6dc3961"]
[2025-11-27 21:41:38] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e872e5ae13
[2025-11-27 21:41:39] [INFO] Created new Dispatches record with ID: 6928c59273e86d990
[2025-11-27 21:41:39] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27884.xml
[2025-11-27 21:41:39] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27884.xml
[2025-11-27 21:46:41] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27883.xml
[2025-11-27 21:46:41] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27883.xml for user: 68d56363ec1209189
[2025-11-27 21:46:41] [INFO] File size: 2704 bytes
[2025-11-27 21:46:41] [INFO] Created FTPFiles record with ID: 6928c6c1e931cc866
[2025-11-27 21:46:41] [INFO] About to extract fields from XML. File size: 2704 bytes
[2025-11-27 21:46:41] [INFO] Number of mappings: 20
[2025-11-27 21:46:41] [INFO] Starting XML parsing. Content length: 2704
[2025-11-27 21:46:41] [INFO] XML parsed successfully. Root element: Incident
[2025-11-27 21:46:41] [INFO] Processing 20 field mappings
[2025-11-27 21:46:41] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-27 21:46:41] [INFO]   -> Found value: 25-27883
[2025-11-27 21:46:41] [INFO]   -> Set field 'dispatchRunNumber' = "25-27883"
[2025-11-27 21:46:41] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-27 21:46:41] [INFO]   -> Found value: 104
[2025-11-27 21:46:41] [INFO]   -> Set field 'incidentLocationStreetNumber' = 104
[2025-11-27 21:46:41] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-27 21:46:41] [INFO]   -> Found value: E FRONT ST
[2025-11-27 21:46:41] [INFO]   -> Set field 'streetName' = "E FRONT ST"
[2025-11-27 21:46:41] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-27 21:46:41] [INFO]   -> No value found (null or empty)
[2025-11-27 21:46:41] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-27 21:46:41] [INFO]   -> Found value: SIKESTON
[2025-11-27 21:46:41] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-27 21:46:41] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-27 21:46:41] [INFO]   -> Found value: CARSON'S
[2025-11-27 21:46:41] [INFO]   -> Set field 'businessName' = "CARSON'S"
[2025-11-27 21:46:41] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-27 21:46:41] [INFO]   -> Found value: MO
[2025-11-27 21:46:41] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-27 21:46:41] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-27 21:46:41] [INFO]   -> Found value: 63801
[2025-11-27 21:46:41] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-27 21:46:41] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-27 21:46:41] [INFO]   -> Found value: 0
[2025-11-27 21:46:41] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-27 21:46:41] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-27 21:46:41] [INFO]   -> Found value: 0
[2025-11-27 21:46:41] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-27 21:46:41] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-27 21:46:41] [INFO]   -> Found value: FIRE-ALARM MECH
[2025-11-27 21:46:41] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-ALARM MECH"
[2025-11-27 21:46:41] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-27 21:46:41] [INFO]   -> Found value: 11-27-2025 15:16:07|UPPER DINING SMOKE
ADAM GLENN 573-427-0090
 11-27-2025 15:20:54|B49 ADVISED MULT...
[2025-11-27 21:46:41] [INFO]   -> Set field 'dispatchNotes' = "11-27-2025 15:16:07|UPPER DINING SMOKE\nADAM GLENN 573-427-0090\n 11-27-2025 15:20:54|B49 ADVISED MULTI STRUCTURE NOTHING SHOWING 11-27-2025 15:25:57|COMMAND REQUSTED CONTACT WITH KEYHOLDER 11-27-2025 15:26:34|NEG CONTACT WITH KEYHOLDER 11-27-2025 15:29:17|SECONDARY KEYHOLDER CAROL GLENN 573-683-1312 11-27-2025 15:31:18|ALLEN KEENAN 573-258-0070 IS EN ROUTE 11-27-2025 15:34:03|ENG 1 AND L3 RESPONDING TO ADDITIONAL MECH FIRE ALARM PER B49 11-27-2025 15:45:27|B49 ADVISED NOTHING LOCATED"
[2025-11-27 21:46:41] [INFO]   -> Set field 'cADLog' = "11-27-2025 15:16:07|UPPER DINING SMOKE\nADAM GLENN 573-427-0090\n 11-27-2025 15:20:54|B49 ADVISED MULTI STRUCTURE NOTHING SHOWING 11-27-2025 15:25:57|COMMAND REQUSTED CONTACT WITH KEYHOLDER 11-27-2025 15:26:34|NEG CONTACT WITH KEYHOLDER 11-27-2025 15:29:17|SECONDARY KEYHOLDER CAROL GLENN 573-683-1312 11-27-2025 15:31:18|ALLEN KEENAN 573-258-0070 IS EN ROUTE 11-27-2025 15:34:03|ENG 1 AND L3 RESPONDING TO ADDITIONAL MECH FIRE ALARM PER B49 11-27-2025 15:45:27|B49 ADVISED NOTHING LOCATED"
[2025-11-27 21:46:41] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-27 21:46:41] [INFO]   -> Found value: 11-27-2025T15:17:23
[2025-11-27 21:46:41] [ERROR] Error formatting datetime '11-27-2025T15:17:23': Failed to parse time string (11-27-2025T15:17:23) at position 0 (1): Unexpected character
[2025-11-27 21:46:41] [INFO]   -> Set field 'alarm' = null
[2025-11-27 21:46:41] [ERROR] Error formatting datetime '11-27-2025T15:17:23': Failed to parse time string (11-27-2025T15:17:23) at position 0 (1): Unexpected character
[2025-11-27 21:46:41] [INFO]   -> Set field 'dispatched' = null
[2025-11-27 21:46:41] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-27 21:46:41] [INFO]   -> Found value: 11-27-2025T15:20:51
[2025-11-27 21:46:41] [ERROR] Error formatting datetime '11-27-2025T15:20:51': Failed to parse time string (11-27-2025T15:20:51) at position 0 (1): Unexpected character
[2025-11-27 21:46:41] [INFO]   -> Set field 'onScene' = null
[2025-11-27 21:46:41] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-27 21:46:41] [INFO]   -> Found value: 11-27-2025T15:45:33
[2025-11-27 21:46:41] [ERROR] Error formatting datetime '11-27-2025T15:45:33': Failed to parse time string (11-27-2025T15:45:33) at position 0 (1): Unexpected character
[2025-11-27 21:46:41] [INFO]   -> Set field 'cleared' = null
[2025-11-27 21:46:41] [ERROR] Error formatting datetime '11-27-2025T15:45:33': Failed to parse time string (11-27-2025T15:45:33) at position 0 (1): Unexpected character
[2025-11-27 21:46:41] [INFO]   -> Set field 'inService' = null
[2025-11-27 21:46:41] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-27 21:46:41] [INFO]   -> Found value: ENG1
[2025-11-27 21:46:41] [INFO]   -> Set field 'cADVehicleID' = "ENG1"
[2025-11-27 21:46:41] [INFO]   -> Set field 'name' = "ENG1"
[2025-11-27 21:46:41] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-27 21:46:41] [INFO]   -> Found value: 11-27-2025T15:20:27
[2025-11-27 21:46:41] [ERROR] Error formatting datetime '11-27-2025T15:20:27': Failed to parse time string (11-27-2025T15:20:27) at position 0 (1): Unexpected character
[2025-11-27 21:46:41] [INFO]   -> Set field 'timeenroutetoscene' = null
[2025-11-27 21:46:41] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-27 21:46:41] [INFO]   -> Found value: 11-27-2025T15:22:24
[2025-11-27 21:46:41] [ERROR] Error formatting datetime '11-27-2025T15:22:24': Failed to parse time string (11-27-2025T15:22:24) at position 0 (1): Unexpected character
[2025-11-27 21:46:41] [INFO]   -> Set field 'timeonscene' = null
[2025-11-27 21:46:41] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-27 21:46:41] [INFO]   -> Found value: 11-27-2025T15:33:52
[2025-11-27 21:46:41] [ERROR] Error formatting datetime '11-27-2025T15:33:52': Failed to parse time string (11-27-2025T15:33:52) at position 0 (1): Unexpected character
[2025-11-27 21:46:41] [INFO]   -> Set field 'timeunitclear' = null
[2025-11-27 21:46:41] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-27 21:46:41] [INFO]   -> Found value: 11-27-2025T15:20:21
[2025-11-27 21:46:41] [ERROR] Error formatting datetime '11-27-2025T15:20:21': Failed to parse time string (11-27-2025T15:20:21) at position 0 (1): Unexpected character
[2025-11-27 21:46:41] [INFO]   -> Set field 'timedispatch' = null
[2025-11-27 21:46:41] [INFO] Finished extracting fields. Total fields extracted: 23
[2025-11-27 21:46:41] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-27883","incidentLocationStreetNumber":104,"streetName":"E FRONT ST","incidentLocationCity":"SIKESTON","businessName":"CARSON'S","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-ALARM MECH","dispatchNotes":"11-27-2025 15:16:07|UPPER DINING SMOKE\nADAM GLENN 573-427-0090\n 11-27-2025 15:20:54|B49 ADVISED MULTI STRUCTURE NOTHING SHOWING 11-27-2025 15:25:57|COMMAND REQUSTED CONTACT WITH KEYHOLDER 11-27-2025 15:26:34|NEG CONTACT WITH KEYHOLDER 11-27-2025 15:29:17|SECONDARY KEYHOLDER CAROL GLENN 573-683-1312 11-27-2025 15:31:18|ALLEN KEENAN 573-258-0070 IS EN ROUTE 11-27-2025 15:34:03|ENG 1 AND L3 RESPONDING TO ADDITIONAL MECH FIRE ALARM PER B49 11-27-2025 15:45:27|B49 ADVISED NOTHING LOCATED","cADLog":"11-27-2025 15:16:07|UPPER DINING SMOKE\nADAM GLENN 573-427-0090\n 11-27-2025 15:20:54|B49 ADVISED MULTI STRUCTURE NOTHING SHOWING 11-27-2025 15:25:57|COMMAND REQUSTED CONTACT WITH KEYHOLDER 11-27-2025 15:26:34|NEG CONTACT WITH KEYHOLDER 11-27-2025 15:29:17|SECONDARY KEYHOLDER CAROL GLENN 573-683-1312 11-27-2025 15:31:18|ALLEN KEENAN 573-258-0070 IS EN ROUTE 11-27-2025 15:34:03|ENG 1 AND L3 RESPONDING TO ADDITIONAL MECH FIRE ALARM PER B49 11-27-2025 15:45:27|B49 ADVISED NOTHING LOCATED","alarm":null,"dispatched":null,"onScene":null,"cleared":null,"inService":null,"cADVehicleID":"ENG1","name":"ENG1","timeenroutetoscene":null,"timeonscene":null,"timeunitclear":null,"timedispatch":null}
[2025-11-27 21:46:41] [INFO] Number of extracted fields: 23
[2025-11-27 21:46:41] [INFO] Multi-agency routing check: CAD Agency ID = NULL, Assigned Agencies count = 2
[2025-11-27 21:46:41] [INFO] Single-agency mode: Using mailbox saasclientId: 6772cab7157b2ebde
[2025-11-27 21:46:41] [INFO] Final routing: saasclientId = 6772cab7157b2ebde, dispatchStationsIds = ["67d843b7d3670caf0","67d843823ed523b5c","67d8434fe3dc432c7","68d5ab6eaa6dc3961"]
[2025-11-27 21:46:42] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e872e5ae13
[2025-11-27 21:46:43] [INFO] Created new Dispatches record with ID: 6928c6c2260613a08
[2025-11-27 21:46:43] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27883.xml
[2025-11-27 21:46:43] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-27883.xml