[2025-12-11 00:03:48] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SCRFD_25-29311.xml
[2025-12-11 00:03:48] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SCRFD_25-29311.xml for user: 68d56363ec1209189
[2025-12-11 00:03:48] [INFO] File size: 1324 bytes
[2025-12-11 00:03:48] [INFO] Created FTPFiles record with ID: 693a0a645788ebc6c
[2025-12-11 00:03:48] [INFO] About to extract fields from XML. File size: 1324 bytes
[2025-12-11 00:03:48] [INFO] Number of mappings: 21
[2025-12-11 00:03:48] [INFO] Starting XML parsing. Content length: 1324
[2025-12-11 00:03:48] [INFO] XML parsed successfully. Root element: Incident
[2025-12-11 00:03:48] [INFO] Processing 21 field mappings
[2025-12-11 00:03:48] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-12-11 00:03:48] [INFO]   -> Found value: 25-29311
[2025-12-11 00:03:48] [INFO]   -> Set field 'dispatchRunNumber' = "25-29311"
[2025-12-11 00:03:48] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-12-11 00:03:48] [INFO]   -> Found value: 201
[2025-12-11 00:03:48] [INFO]   -> Set field 'incidentLocationStreetNumber' = 201
[2025-12-11 00:03:48] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-12-11 00:03:48] [INFO]   -> Found value: S KINGSHIGHWAY
[2025-12-11 00:03:48] [INFO]   -> Set field 'streetName' = "S KINGSHIGHWAY"
[2025-12-11 00:03:48] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-12-11 00:03:48] [INFO]   -> No value found (null or empty)
[2025-12-11 00:03:48] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-12-11 00:03:48] [INFO]   -> Found value: SIKESTON
[2025-12-11 00:03:48] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-12-11 00:03:48] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-12-11 00:03:48] [INFO]   -> Found value: SIKESTON DPS
[2025-12-11 00:03:48] [INFO]   -> Set field 'businessName' = "SIKESTON DPS"
[2025-12-11 00:03:48] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-12-11 00:03:48] [INFO]   -> Found value: MO
[2025-12-11 00:03:48] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-12-11 00:03:48] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-12-11 00:03:48] [INFO]   -> Found value: 63801
[2025-12-11 00:03:48] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-12-11 00:03:48] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-12-11 00:03:48] [INFO]   -> No value found (null or empty)
[2025-12-11 00:03:48] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-12-11 00:03:48] [INFO]   -> No value found (null or empty)
[2025-12-11 00:03:48] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-12-11 00:03:48] [INFO]   -> Found value: WED 1800 HR PAGER TEST
[2025-12-11 00:03:48] [INFO]   -> Set field 'incidentTypeValue1' = "WED 1800 HR PAGER TEST"
[2025-12-11 00:03:48] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-12-11 00:03:48] [INFO]   -> Found value: 12-10-2025 18:00:00|WED EVENING PAGER TEST
[2025-12-11 00:03:48] [INFO]   -> Set field 'dispatchNotes' = "12-10-2025 18:00:00|WED EVENING PAGER TEST"
[2025-12-11 00:03:48] [INFO]   -> Set field 'cADLog' = "12-10-2025 18:00:00|WED EVENING PAGER TEST"
[2025-12-11 00:03:48] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-12-11 00:03:48] [INFO]   -> Found value: 12-10-2025T18:02:08
[2025-12-11 00:03:48] [INFO] Reformatted DD-MM-YYYY date '12-10-2025' (day=12, month=10) to ISO: 2025-10-12T18:02:08
[2025-12-11 00:03:48] [INFO]   -> Set field 'alarm' = "2025-10-12 18:02:08"
[2025-12-11 00:03:48] [INFO] Reformatted DD-MM-YYYY date '12-10-2025' (day=12, month=10) to ISO: 2025-10-12T18:02:08
[2025-12-11 00:03:48] [INFO]   -> Set field 'dispatched' = "2025-10-12 18:02:08"
[2025-12-11 00:03:48] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-12-11 00:03:48] [INFO]   -> No value found (null or empty)
[2025-12-11 00:03:48] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-12-11 00:03:48] [INFO]   -> No value found (null or empty)
[2025-12-11 00:03:48] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-12-11 00:03:48] [INFO]   -> Found value: RURAL PAGE
[2025-12-11 00:03:48] [INFO]   -> Set field 'cADVehicleID' = "RURAL PAGE"
[2025-12-11 00:03:48] [INFO]   -> Set field 'name' = "RURAL PAGE"
[2025-12-11 00:03:48] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-12-11 00:03:48] [INFO]   -> No value found (null or empty)
[2025-12-11 00:03:48] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-12-11 00:03:48] [INFO]   -> No value found (null or empty)
[2025-12-11 00:03:48] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-12-11 00:03:48] [INFO]   -> Found value: 12-10-2025T18:02:38
[2025-12-11 00:03:48] [INFO] Reformatted DD-MM-YYYY date '12-10-2025' (day=12, month=10) to ISO: 2025-10-12T18:02:38
[2025-12-11 00:03:48] [INFO]   -> Set field 'timeunitclear' = "2025-10-12 18:02:38"
[2025-12-11 00:03:48] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-12-11 00:03:48] [INFO]   -> Found value: 12-10-2025T18:02:20
[2025-12-11 00:03:48] [INFO] Reformatted DD-MM-YYYY date '12-10-2025' (day=12, month=10) to ISO: 2025-10-12T18:02:20
[2025-12-11 00:03:48] [INFO]   -> Set field 'timedispatch' = "2025-10-12 18:02:20"
[2025-12-11 00:03:48] [INFO] Mapping #21: Extracting 'Agency' => 'cADAgencyIdentifier'
[2025-12-11 00:03:48] [INFO]   -> Found value: SCRFD
[2025-12-11 00:03:48] [INFO]   -> Set field 'cADAgencyIdentifier' = "SCRFD"
[2025-12-11 00:03:48] [INFO] Finished extracting fields. Total fields extracted: 17
[2025-12-11 00:03:48] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-29311","incidentLocationStreetNumber":201,"streetName":"S KINGSHIGHWAY","incidentLocationCity":"SIKESTON","businessName":"SIKESTON DPS","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"incidentTypeValue1":"WED 1800 HR PAGER TEST","dispatchNotes":"12-10-2025 18:00:00|WED EVENING PAGER TEST","cADLog":"12-10-2025 18:00:00|WED EVENING PAGER TEST","alarm":"2025-10-12 18:02:08","dispatched":"2025-10-12 18:02:08","cADVehicleID":"RURAL PAGE","name":"RURAL PAGE","timeunitclear":"2025-10-12 18:02:38","timedispatch":"2025-10-12 18:02:20","cADAgencyIdentifier":"SCRFD"}
[2025-12-11 00:03:48] [INFO] Number of extracted fields: 17
[2025-12-11 00:03:48] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'SCRFD'
[2025-12-11 00:03:48] [INFO] Multi-agency routing check: CAD Agency ID = SCRFD, Assigned Agencies count = 2
[2025-12-11 00:03:48] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'SCRFD'
[2025-12-11 00:03:48] [INFO] Found SAASClient match: ID = 6643bdb30659f00d8, Name = Scott County Rural Fire Protection District
[2025-12-11 00:03:48] [INFO] SUCCESS: Routed to agency 'Scott County Rural Fire Protection District' (ID: 6643bdb30659f00d8) based on CAD ID: 'SCRFD'
[2025-12-11 00:03:48] [INFO] Fetched 6 stations from Stations module for agency 'Scott County Rural Fire Protection District': ["690279491710f7b8e","6644dbe7e17f1c3de","6644dbb3886c9768f","6644d0c9be0e4ec53","6644e2fe1572c01ae","69027d47e7c4fc65b"]
[2025-12-11 00:03:48] [INFO] Final routing: saasclientId = 6643bdb30659f00d8, dispatchStationsIds = ["690279491710f7b8e","6644dbe7e17f1c3de","6644dbb3886c9768f","6644d0c9be0e4ec53","6644e2fe1572c01ae","69027d47e7c4fc65b"]
[2025-12-11 00:03:48] [INFO] Updated FTPFiles record saasclientId to routed agency: 6643bdb30659f00d8
[2025-12-11 00:03:48] [INFO] Created new IncidentTypeMapping Data: {"cADIncidentType":"WED 1800 HR PAGER TEST","saasclientId":"6643bdb30659f00d8","name":"WED 1800 HR PAGER TEST"}
[2025-12-11 00:03:48] [INFO] Created new IncidentTypeMapping with ID: 693a0a64a7bfdcdfa
[2025-12-11 00:03:48] [INFO] Found existing Dispatch with cADNumber '25-29311', ID: 693a0a0f9693b8fbf - will update instead of create
[2025-12-11 00:03:48] [INFO] Updated existing Dispatches record with ID: 693a0a0f9693b8fbf
[2025-12-11 00:03:48] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SCRFD_25-29311.xml
[2025-12-11 00:03:48] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SCRFD_25-29311.xml
[2025-12-11 00:03:48] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-29311.xml
[2025-12-11 00:03:48] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-29311.xml for user: 68d56363ec1209189
[2025-12-11 00:03:48] [INFO] File size: 1327 bytes
[2025-12-11 00:03:49] [INFO] Created FTPFiles record with ID: 693a0a64f3cf5c8e6
[2025-12-11 00:03:49] [INFO] About to extract fields from XML. File size: 1327 bytes
[2025-12-11 00:03:49] [INFO] Number of mappings: 21
[2025-12-11 00:03:49] [INFO] Starting XML parsing. Content length: 1327
[2025-12-11 00:03:49] [INFO] XML parsed successfully. Root element: Incident
[2025-12-11 00:03:49] [INFO] Processing 21 field mappings
[2025-12-11 00:03:49] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-12-11 00:03:49] [INFO]   -> Found value: 25-29311
[2025-12-11 00:03:49] [INFO]   -> Set field 'dispatchRunNumber' = "25-29311"
[2025-12-11 00:03:49] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-12-11 00:03:49] [INFO]   -> Found value: 201
[2025-12-11 00:03:49] [INFO]   -> Set field 'incidentLocationStreetNumber' = 201
[2025-12-11 00:03:49] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-12-11 00:03:49] [INFO]   -> Found value: S KINGSHIGHWAY
[2025-12-11 00:03:49] [INFO]   -> Set field 'streetName' = "S KINGSHIGHWAY"
[2025-12-11 00:03:49] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-12-11 00:03:49] [INFO]   -> No value found (null or empty)
[2025-12-11 00:03:49] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-12-11 00:03:49] [INFO]   -> Found value: SIKESTON
[2025-12-11 00:03:49] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-12-11 00:03:49] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-12-11 00:03:49] [INFO]   -> Found value: SIKESTON DPS
[2025-12-11 00:03:49] [INFO]   -> Set field 'businessName' = "SIKESTON DPS"
[2025-12-11 00:03:49] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-12-11 00:03:49] [INFO]   -> Found value: MO
[2025-12-11 00:03:49] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-12-11 00:03:49] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-12-11 00:03:49] [INFO]   -> Found value: 63801
[2025-12-11 00:03:49] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-12-11 00:03:49] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-12-11 00:03:49] [INFO]   -> No value found (null or empty)
[2025-12-11 00:03:49] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-12-11 00:03:49] [INFO]   -> No value found (null or empty)
[2025-12-11 00:03:49] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-12-11 00:03:49] [INFO]   -> Found value: WED 1800 HR PAGER TEST
[2025-12-11 00:03:49] [INFO]   -> Set field 'incidentTypeValue1' = "WED 1800 HR PAGER TEST"
[2025-12-11 00:03:49] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-12-11 00:03:49] [INFO]   -> Found value: 12-10-2025 18:00:00|WED EVENING PAGER TEST
[2025-12-11 00:03:49] [INFO]   -> Set field 'dispatchNotes' = "12-10-2025 18:00:00|WED EVENING PAGER TEST"
[2025-12-11 00:03:49] [INFO]   -> Set field 'cADLog' = "12-10-2025 18:00:00|WED EVENING PAGER TEST"
[2025-12-11 00:03:49] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-12-11 00:03:49] [INFO]   -> Found value: 12-10-2025T18:02:08
[2025-12-11 00:03:49] [INFO] Reformatted DD-MM-YYYY date '12-10-2025' (day=12, month=10) to ISO: 2025-10-12T18:02:08
[2025-12-11 00:03:49] [INFO]   -> Set field 'alarm' = "2025-10-12 18:02:08"
[2025-12-11 00:03:49] [INFO] Reformatted DD-MM-YYYY date '12-10-2025' (day=12, month=10) to ISO: 2025-10-12T18:02:08
[2025-12-11 00:03:49] [INFO]   -> Set field 'dispatched' = "2025-10-12 18:02:08"
[2025-12-11 00:03:49] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-12-11 00:03:49] [INFO]   -> No value found (null or empty)
[2025-12-11 00:03:49] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-12-11 00:03:49] [INFO]   -> No value found (null or empty)
[2025-12-11 00:03:49] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-12-11 00:03:49] [INFO]   -> Found value: SIK ALL PAGE
[2025-12-11 00:03:49] [INFO]   -> Set field 'cADVehicleID' = "SIK ALL PAGE"
[2025-12-11 00:03:49] [INFO]   -> Set field 'name' = "SIK ALL PAGE"
[2025-12-11 00:03:49] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-12-11 00:03:49] [INFO]   -> No value found (null or empty)
[2025-12-11 00:03:49] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-12-11 00:03:49] [INFO]   -> No value found (null or empty)
[2025-12-11 00:03:49] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-12-11 00:03:49] [INFO]   -> Found value: 12-10-2025T18:02:38
[2025-12-11 00:03:49] [INFO] Reformatted DD-MM-YYYY date '12-10-2025' (day=12, month=10) to ISO: 2025-10-12T18:02:38
[2025-12-11 00:03:49] [INFO]   -> Set field 'timeunitclear' = "2025-10-12 18:02:38"
[2025-12-11 00:03:49] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-12-11 00:03:49] [INFO]   -> Found value: 12-10-2025T18:02:08
[2025-12-11 00:03:49] [INFO] Reformatted DD-MM-YYYY date '12-10-2025' (day=12, month=10) to ISO: 2025-10-12T18:02:08
[2025-12-11 00:03:49] [INFO]   -> Set field 'timedispatch' = "2025-10-12 18:02:08"
[2025-12-11 00:03:49] [INFO] Mapping #21: Extracting 'Agency' => 'cADAgencyIdentifier'
[2025-12-11 00:03:49] [INFO]   -> Found value: SDPSFD
[2025-12-11 00:03:49] [INFO]   -> Set field 'cADAgencyIdentifier' = "SDPSFD"
[2025-12-11 00:03:49] [INFO] Finished extracting fields. Total fields extracted: 17
[2025-12-11 00:03:49] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-29311","incidentLocationStreetNumber":201,"streetName":"S KINGSHIGHWAY","incidentLocationCity":"SIKESTON","businessName":"SIKESTON DPS","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"incidentTypeValue1":"WED 1800 HR PAGER TEST","dispatchNotes":"12-10-2025 18:00:00|WED EVENING PAGER TEST","cADLog":"12-10-2025 18:00:00|WED EVENING PAGER TEST","alarm":"2025-10-12 18:02:08","dispatched":"2025-10-12 18:02:08","cADVehicleID":"SIK ALL PAGE","name":"SIK ALL PAGE","timeunitclear":"2025-10-12 18:02:38","timedispatch":"2025-10-12 18:02:08","cADAgencyIdentifier":"SDPSFD"}
[2025-12-11 00:03:49] [INFO] Number of extracted fields: 17
[2025-12-11 00:03:49] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'SDPSFD'
[2025-12-11 00:03:49] [INFO] Multi-agency routing check: CAD Agency ID = SDPSFD, Assigned Agencies count = 2
[2025-12-11 00:03:49] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'SDPSFD'
[2025-12-11 00:03:49] [INFO] Found SAASClient match: ID = 6772cab7157b2ebde, Name = Sikeston DPS
[2025-12-11 00:03:49] [INFO] SUCCESS: Routed to agency 'Sikeston DPS' (ID: 6772cab7157b2ebde) based on CAD ID: 'SDPSFD'
[2025-12-11 00:03:49] [INFO] Fetched 4 stations from Stations module for agency 'Sikeston DPS': ["67d843b7d3670caf0","67d843823ed523b5c","67d8434fe3dc432c7","68d5ab6eaa6dc3961"]
[2025-12-11 00:03:49] [INFO] Final routing: saasclientId = 6772cab7157b2ebde, dispatchStationsIds = ["67d843b7d3670caf0","67d843823ed523b5c","67d8434fe3dc432c7","68d5ab6eaa6dc3961"]
[2025-12-11 00:03:49] [INFO] Updated FTPFiles record saasclientId to routed agency: 6772cab7157b2ebde
[2025-12-11 00:03:49] [INFO] Found existing IncidentTypeMapping with ID: 691e5c32443e1aa70
[2025-12-11 00:03:50] [INFO] Created new Dispatches record with ID: 693a0a6553bdf83d3
[2025-12-11 00:03:50] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-29311.xml
[2025-12-11 00:03:50] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-29311.xml
[2025-12-11 02:48:11] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135811_20251211_024811.XML
[2025-12-11 02:48:11] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135811_20251211_024811.XML for user: 68f1466aed072ad4a
[2025-12-11 02:48:11] [INFO] File size: 5456 bytes
[2025-12-11 02:48:12] [INFO] Created FTPFiles record with ID: 693a30ec0506ed1e7
[2025-12-11 02:48:12] [INFO] About to extract fields from XML. File size: 5456 bytes
[2025-12-11 02:48:12] [INFO] Number of mappings: 25
[2025-12-11 02:48:12] [INFO] Starting XML parsing. Content length: 5456
[2025-12-11 02:48:12] [INFO] XML parsed successfully. Root element: CADExport
[2025-12-11 02:48:12] [INFO] Processing 25 field mappings
[2025-12-11 02:48:12] [INFO] Mapping #1: Extracting 'EventDetails.AgencyCode' => 'cADAgencyIdentifier'
[2025-12-11 02:48:12] [INFO] Found 4 elements for 'AgencyCode', concatenating 4 non-empty values
[2025-12-11 02:48:12] [INFO]   -> Found value: PCFD
PCSO
EMS
BFD
[2025-12-11 02:48:12] [INFO]   -> Set field 'cADAgencyIdentifier' = "PCFD\nPCSO\nEMS\nBFD"
[2025-12-11 02:48:12] [INFO] Mapping #2: Extracting 'EventDetails.ReportNumber' => ["incidentInternalId","dispatchRunNumber"]
[2025-12-11 02:48:12] [INFO] Found 4 elements for 'ReportNumber', concatenating 1 non-empty values
[2025-12-11 02:48:12] [INFO]   -> Found value: 2025003027
[2025-12-11 02:48:12] [INFO]   -> Set field 'incidentInternalId' = "2025003027"
[2025-12-11 02:48:12] [INFO]   -> Set field 'dispatchRunNumber' = "2025003027"
[2025-12-11 02:48:12] [INFO] Mapping #3: Extracting 'EventDetails.NatureDescription' => 'incidentTypeValue1'
[2025-12-11 02:48:12] [INFO]   -> Found value: RESIDENTIAL FIRE
[2025-12-11 02:48:12] [INFO]   -> Set field 'incidentTypeValue1' = "RESIDENTIAL FIRE"
[2025-12-11 02:48:12] [INFO] Mapping #4: Extracting 'EventDetails.StreetNumber' => 'incidentLocationStreetNumber'
[2025-12-11 02:48:12] [INFO]   -> Found value: 6100
[2025-12-11 02:48:12] [INFO]   -> Set field 'incidentLocationStreetNumber' = 6100
[2025-12-11 02:48:12] [INFO] Mapping #5: Extracting 'RelatedNames.Name.StreetName' => 'streetName'
[2025-12-11 02:48:12] [INFO]   -> Found value: NASHVILLE HWY
[2025-12-11 02:48:12] [INFO]   -> Set field 'streetName' = "NASHVILLE HWY"
[2025-12-11 02:48:12] [INFO] Mapping #6: Extracting 'RelatedNames.Name.City' => 'incidentLocationCity'
[2025-12-11 02:48:12] [INFO]   -> Found value: BAXTER
[2025-12-11 02:48:12] [INFO]   -> Set field 'incidentLocationCity' = "BAXTER"
[2025-12-11 02:48:12] [INFO] Mapping #7: Extracting 'EventDetails.State' => 'incidentLocationStateName'
[2025-12-11 02:48:12] [INFO]   -> Found value: TN
[2025-12-11 02:48:12] [INFO]   -> Set field 'incidentLocationStateName' = "TN"
[2025-12-11 02:48:12] [INFO] Mapping #8: Extracting 'EventDetails.ZipCode' => 'nERISIncidentPostalCode'
[2025-12-11 02:48:12] [INFO]   -> Found value: 38544
[2025-12-11 02:48:12] [INFO]   -> Set field 'nERISIncidentPostalCode' = 38544
[2025-12-11 02:48:12] [INFO] Mapping #9: Extracting 'EventDetails.SiteName' => 'businessName'
[2025-12-11 02:48:12] [INFO]   -> Found value: ROBERTS,GREG
[2025-12-11 02:48:12] [INFO]   -> Set field 'businessName' = "ROBERTS,GREG"
[2025-12-11 02:48:12] [INFO] Mapping #10: Extracting 'EventDetails.ApartmentSuite' => 'incidentLocationApt'
[2025-12-11 02:48:12] [INFO]   -> No value found (null or empty)
[2025-12-11 02:48:12] [INFO] Mapping #11: Extracting 'EventDetails.EventLatitude' => 'nERISIncidentLatitude'
[2025-12-11 02:48:12] [INFO]   -> Found value: 36.17076
[2025-12-11 02:48:12] [INFO]   -> Set field 'nERISIncidentLatitude' = 36.17076
[2025-12-11 02:48:12] [INFO] Mapping #12: Extracting 'EventDetails.EventLongitude' => 'nERISIncidentLongitude'
[2025-12-11 02:48:12] [INFO]   -> Found value: -85.62171
[2025-12-11 02:48:12] [INFO]   -> Set field 'nERISIncidentLongitude' = -85.62171
[2025-12-11 02:48:12] [INFO] Mapping #13: Extracting 'EventDetails.EventStartTime' => 'alarm'
[2025-12-11 02:48:12] [INFO]   -> Found value: 2025-12-10 20:46:36
[2025-12-11 02:48:12] [INFO]   -> Set field 'alarm' = "2025-12-10 20:46:36"
[2025-12-11 02:48:12] [INFO] Mapping #14: Extracting 'EventDetails.FirstDispatchTime' => 'dispatched'
[2025-12-11 02:48:12] [INFO]   -> Found value: 2025-12-10 20:48:01
[2025-12-11 02:48:12] [INFO]   -> Set field 'dispatched' = "2025-12-10 20:48:01"
[2025-12-11 02:48:12] [INFO] Mapping #15: Extracting 'EventDetails.FirstEnrouteTime' => 'enroute'
[2025-12-11 02:48:12] [INFO]   -> No value found (null or empty)
[2025-12-11 02:48:12] [INFO] Mapping #16: Extracting 'EventDetails.FirstOnSceneTime' => 'onScene'
[2025-12-11 02:48:12] [INFO]   -> No value found (null or empty)
[2025-12-11 02:48:12] [INFO] Mapping #17: Extracting 'EventDetails.LastUnitClearTime' => ["cleared","inService"]
[2025-12-11 02:48:12] [INFO]   -> No value found (null or empty)
[2025-12-11 02:48:12] [INFO] Mapping #18: Extracting 'EventDetails.CrossStreets' => 'incidentLocationCross'
[2025-12-11 02:48:12] [INFO]   -> Found value: CLARENCE NASH RD/WARD MILL RD
[2025-12-11 02:48:12] [INFO]   -> Set field 'incidentLocationCross' = "CLARENCE NASH RD\/WARD MILL RD"
[2025-12-11 02:48:12] [INFO] Mapping #19: Extracting 'EventUnits.Unit[0].UnitCode' => 'cADVehicleID'
[2025-12-11 02:48:12] [INFO]   -> Found value: TK31
[2025-12-11 02:48:12] [INFO]   -> Set field 'cADVehicleID' = "TK31"
[2025-12-11 02:48:12] [INFO] Mapping #20: Extracting 'EventUnits.Unit[0].DispatchTime' => 'timedispatch'
[2025-12-11 02:48:12] [INFO]   -> Found value: 2025-12-10 20:48:01
[2025-12-11 02:48:12] [INFO]   -> Set field 'timedispatch' = "2025-12-10 20:48:01"
[2025-12-11 02:48:12] [INFO] Mapping #21: Extracting 'EventUnits.Unit[0].EnRouteTime' => 'timeenroutetoscene'
[2025-12-11 02:48:12] [INFO]   -> No value found (null or empty)
[2025-12-11 02:48:12] [INFO] Mapping #22: Extracting 'EventUnits.Unit[0].ArriveTime' => 'timeonscene'
[2025-12-11 02:48:12] [INFO]   -> No value found (null or empty)
[2025-12-11 02:48:12] [INFO] Mapping #23: Extracting 'EventUnits.Unit[0].ReturnToServiceTime' => 'timeunitclear'
[2025-12-11 02:48:12] [INFO]   -> No value found (null or empty)
[2025-12-11 02:48:12] [INFO] Mapping #24: Extracting 'EventUnits.Unit[0].CancelTime' => 'timecanceledenroute'
[2025-12-11 02:48:12] [INFO]   -> No value found (null or empty)
[2025-12-11 02:48:12] [INFO] Mapping #25: Extracting 'EventDetails.CadInciNumber' => 'policeReportNumber'
[2025-12-11 02:48:12] [INFO] Found 4 elements for 'CadInciNumber', concatenating 4 non-empty values
[2025-12-11 02:48:12] [INFO]   -> Found value: 20250135811
20250135812
20250135813
20250135814
[2025-12-11 02:48:12] [INFO]   -> Set field 'policeReportNumber' = "20250135811\n20250135812\n20250135813\n20250135814"
[2025-12-11 02:48:12] [INFO] Finished extracting fields. Total fields extracted: 18
[2025-12-11 02:48:12] [INFO] Built locationCoordinates from lat/lng: 36.17076,-85.62171
[2025-12-11 02:48:12] [INFO] Extracted parsing rules data: {"cADAgencyIdentifier":"PCFD\nPCSO\nEMS\nBFD","incidentInternalId":"2025003027","dispatchRunNumber":"2025003027","incidentTypeValue1":"RESIDENTIAL FIRE","incidentLocationStreetNumber":6100,"streetName":"NASHVILLE HWY","incidentLocationCity":"BAXTER","incidentLocationStateName":"TN","nERISIncidentPostalCode":38544,"businessName":"ROBERTS,GREG","nERISIncidentLatitude":36.17076,"nERISIncidentLongitude":-85.62171,"alarm":"2025-12-10 20:46:36","dispatched":"2025-12-10 20:48:01","incidentLocationCross":"CLARENCE NASH RD\/WARD MILL RD","cADVehicleID":"TK31","timedispatch":"2025-12-10 20:48:01","policeReportNumber":"20250135811\n20250135812\n20250135813\n20250135814","locationCoordinates":"36.17076,-85.62171"}
[2025-12-11 02:48:12] [INFO] Number of extracted fields: 19
[2025-12-11 02:48:12] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'PCFD
PCSO
EMS
BFD'
[2025-12-11 02:48:12] [INFO] Multi-agency routing check: CAD Agency ID = PCFD
PCSO
EMS
BFD, Assigned Agencies count = 1
[2025-12-11 02:48:12] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'PCFD
PCSO
EMS
BFD'
[2025-12-11 02:48:12] [WARNING] WARNING: No SAASClient found with cADAgencyIdentifier = 'PCFD
PCSO
EMS
BFD'
[2025-12-11 02:48:12] [INFO] FALLBACK: Using mailbox default saasclientId: 68eeb686225c40db4 (multi-agency routing attempted but failed)
[2025-12-11 02:48:12] [INFO] Final routing: saasclientId = 68eeb686225c40db4, dispatchStationsIds = ["68ffbebde83509b7c","68ffd433577d1ee1e","68ffbe83793eb4521","68eef9302d19f85fc","68ffbe45d3567d442","68ffbe0e8c5fa650f","68eef77e6a5b1e9d6","68ffbde067a9b162c","68ffbda5d8ebd5468","68ffbd6b1db8d8daa","68ffbd4220b20a872","68ffbcfb8b8911e4e","68eef6ffc8105af4e","68eeca5d553dc8756"]
[2025-12-11 02:48:12] [INFO] Created new IncidentTypeMapping Data: {"cADIncidentType":"RESIDENTIAL FIRE","saasclientId":"68eeb686225c40db4","name":"RESIDENTIAL FIRE"}
[2025-12-11 02:48:12] [INFO] Created new IncidentTypeMapping with ID: 693a30ec30d9fce11
[2025-12-11 02:48:14] [INFO] Created new Dispatches record with ID: 693a30ec4bdfe5c0c
[2025-12-11 02:48:14] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135811_20251211_024811.XML
[2025-12-11 02:48:14] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135811_20251211_024811.XML
[2025-12-11 02:48:14] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135811_20251211_024812.XML
[2025-12-11 02:48:14] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135811_20251211_024812.XML for user: 68f1466aed072ad4a
[2025-12-11 02:48:14] [INFO] File size: 5456 bytes
[2025-12-11 02:48:14] [INFO] Created FTPFiles record with ID: 693a30ee5a4276e81
[2025-12-11 02:48:14] [INFO] About to extract fields from XML. File size: 5456 bytes
[2025-12-11 02:48:14] [INFO] Number of mappings: 25
[2025-12-11 02:48:14] [INFO] Starting XML parsing. Content length: 5456
[2025-12-11 02:48:14] [INFO] XML parsed successfully. Root element: CADExport
[2025-12-11 02:48:14] [INFO] Processing 25 field mappings
[2025-12-11 02:48:14] [INFO] Mapping #1: Extracting 'EventDetails.AgencyCode' => 'cADAgencyIdentifier'
[2025-12-11 02:48:14] [INFO] Found 4 elements for 'AgencyCode', concatenating 4 non-empty values
[2025-12-11 02:48:14] [INFO]   -> Found value: PCFD
PCSO
EMS
BFD
[2025-12-11 02:48:14] [INFO]   -> Set field 'cADAgencyIdentifier' = "PCFD\nPCSO\nEMS\nBFD"
[2025-12-11 02:48:14] [INFO] Mapping #2: Extracting 'EventDetails.ReportNumber' => ["incidentInternalId","dispatchRunNumber"]
[2025-12-11 02:48:14] [INFO] Found 4 elements for 'ReportNumber', concatenating 1 non-empty values
[2025-12-11 02:48:14] [INFO]   -> Found value: 2025003027
[2025-12-11 02:48:14] [INFO]   -> Set field 'incidentInternalId' = "2025003027"
[2025-12-11 02:48:14] [INFO]   -> Set field 'dispatchRunNumber' = "2025003027"
[2025-12-11 02:48:14] [INFO] Mapping #3: Extracting 'EventDetails.NatureDescription' => 'incidentTypeValue1'
[2025-12-11 02:48:14] [INFO]   -> Found value: RESIDENTIAL FIRE
[2025-12-11 02:48:14] [INFO]   -> Set field 'incidentTypeValue1' = "RESIDENTIAL FIRE"
[2025-12-11 02:48:14] [INFO] Mapping #4: Extracting 'EventDetails.StreetNumber' => 'incidentLocationStreetNumber'
[2025-12-11 02:48:14] [INFO]   -> Found value: 6100
[2025-12-11 02:48:14] [INFO]   -> Set field 'incidentLocationStreetNumber' = 6100
[2025-12-11 02:48:14] [INFO] Mapping #5: Extracting 'RelatedNames.Name.StreetName' => 'streetName'
[2025-12-11 02:48:14] [INFO]   -> Found value: NASHVILLE HWY
[2025-12-11 02:48:14] [INFO]   -> Set field 'streetName' = "NASHVILLE HWY"
[2025-12-11 02:48:14] [INFO] Mapping #6: Extracting 'RelatedNames.Name.City' => 'incidentLocationCity'
[2025-12-11 02:48:14] [INFO]   -> Found value: BAXTER
[2025-12-11 02:48:14] [INFO]   -> Set field 'incidentLocationCity' = "BAXTER"
[2025-12-11 02:48:14] [INFO] Mapping #7: Extracting 'EventDetails.State' => 'incidentLocationStateName'
[2025-12-11 02:48:14] [INFO]   -> Found value: TN
[2025-12-11 02:48:14] [INFO]   -> Set field 'incidentLocationStateName' = "TN"
[2025-12-11 02:48:14] [INFO] Mapping #8: Extracting 'EventDetails.ZipCode' => 'nERISIncidentPostalCode'
[2025-12-11 02:48:14] [INFO]   -> Found value: 38544
[2025-12-11 02:48:14] [INFO]   -> Set field 'nERISIncidentPostalCode' = 38544
[2025-12-11 02:48:14] [INFO] Mapping #9: Extracting 'EventDetails.SiteName' => 'businessName'
[2025-12-11 02:48:14] [INFO]   -> Found value: ROBERTS,GREG
[2025-12-11 02:48:14] [INFO]   -> Set field 'businessName' = "ROBERTS,GREG"
[2025-12-11 02:48:14] [INFO] Mapping #10: Extracting 'EventDetails.ApartmentSuite' => 'incidentLocationApt'
[2025-12-11 02:48:14] [INFO]   -> No value found (null or empty)
[2025-12-11 02:48:14] [INFO] Mapping #11: Extracting 'EventDetails.EventLatitude' => 'nERISIncidentLatitude'
[2025-12-11 02:48:14] [INFO]   -> Found value: 36.17076
[2025-12-11 02:48:14] [INFO]   -> Set field 'nERISIncidentLatitude' = 36.17076
[2025-12-11 02:48:14] [INFO] Mapping #12: Extracting 'EventDetails.EventLongitude' => 'nERISIncidentLongitude'
[2025-12-11 02:48:14] [INFO]   -> Found value: -85.62171
[2025-12-11 02:48:14] [INFO]   -> Set field 'nERISIncidentLongitude' = -85.62171
[2025-12-11 02:48:14] [INFO] Mapping #13: Extracting 'EventDetails.EventStartTime' => 'alarm'
[2025-12-11 02:48:14] [INFO]   -> Found value: 2025-12-10 20:46:36
[2025-12-11 02:48:14] [INFO]   -> Set field 'alarm' = "2025-12-10 20:46:36"
[2025-12-11 02:48:14] [INFO] Mapping #14: Extracting 'EventDetails.FirstDispatchTime' => 'dispatched'
[2025-12-11 02:48:14] [INFO]   -> Found value: 2025-12-10 20:48:01
[2025-12-11 02:48:14] [INFO]   -> Set field 'dispatched' = "2025-12-10 20:48:01"
[2025-12-11 02:48:14] [INFO] Mapping #15: Extracting 'EventDetails.FirstEnrouteTime' => 'enroute'
[2025-12-11 02:48:14] [INFO]   -> No value found (null or empty)
[2025-12-11 02:48:14] [INFO] Mapping #16: Extracting 'EventDetails.FirstOnSceneTime' => 'onScene'
[2025-12-11 02:48:14] [INFO]   -> No value found (null or empty)
[2025-12-11 02:48:14] [INFO] Mapping #17: Extracting 'EventDetails.LastUnitClearTime' => ["cleared","inService"]
[2025-12-11 02:48:14] [INFO]   -> No value found (null or empty)
[2025-12-11 02:48:14] [INFO] Mapping #18: Extracting 'EventDetails.CrossStreets' => 'incidentLocationCross'
[2025-12-11 02:48:14] [INFO]   -> Found value: CLARENCE NASH RD/WARD MILL RD
[2025-12-11 02:48:14] [INFO]   -> Set field 'incidentLocationCross' = "CLARENCE NASH RD\/WARD MILL RD"
[2025-12-11 02:48:14] [INFO] Mapping #19: Extracting 'EventUnits.Unit[0].UnitCode' => 'cADVehicleID'
[2025-12-11 02:48:14] [INFO]   -> Found value: TK31
[2025-12-11 02:48:14] [INFO]   -> Set field 'cADVehicleID' = "TK31"
[2025-12-11 02:48:14] [INFO] Mapping #20: Extracting 'EventUnits.Unit[0].DispatchTime' => 'timedispatch'
[2025-12-11 02:48:14] [INFO]   -> Found value: 2025-12-10 20:48:01
[2025-12-11 02:48:14] [INFO]   -> Set field 'timedispatch' = "2025-12-10 20:48:01"
[2025-12-11 02:48:14] [INFO] Mapping #21: Extracting 'EventUnits.Unit[0].EnRouteTime' => 'timeenroutetoscene'
[2025-12-11 02:48:14] [INFO]   -> No value found (null or empty)
[2025-12-11 02:48:14] [INFO] Mapping #22: Extracting 'EventUnits.Unit[0].ArriveTime' => 'timeonscene'
[2025-12-11 02:48:14] [INFO]   -> No value found (null or empty)
[2025-12-11 02:48:14] [INFO] Mapping #23: Extracting 'EventUnits.Unit[0].ReturnToServiceTime' => 'timeunitclear'
[2025-12-11 02:48:14] [INFO]   -> No value found (null or empty)
[2025-12-11 02:48:14] [INFO] Mapping #24: Extracting 'EventUnits.Unit[0].CancelTime' => 'timecanceledenroute'
[2025-12-11 02:48:14] [INFO]   -> No value found (null or empty)
[2025-12-11 02:48:14] [INFO] Mapping #25: Extracting 'EventDetails.CadInciNumber' => 'policeReportNumber'
[2025-12-11 02:48:14] [INFO] Found 4 elements for 'CadInciNumber', concatenating 4 non-empty values
[2025-12-11 02:48:14] [INFO]   -> Found value: 20250135811
20250135812
20250135813
20250135814
[2025-12-11 02:48:14] [INFO]   -> Set field 'policeReportNumber' = "20250135811\n20250135812\n20250135813\n20250135814"
[2025-12-11 02:48:14] [INFO] Finished extracting fields. Total fields extracted: 18
[2025-12-11 02:48:14] [INFO] Built locationCoordinates from lat/lng: 36.17076,-85.62171
[2025-12-11 02:48:14] [INFO] Extracted parsing rules data: {"cADAgencyIdentifier":"PCFD\nPCSO\nEMS\nBFD","incidentInternalId":"2025003027","dispatchRunNumber":"2025003027","incidentTypeValue1":"RESIDENTIAL FIRE","incidentLocationStreetNumber":6100,"streetName":"NASHVILLE HWY","incidentLocationCity":"BAXTER","incidentLocationStateName":"TN","nERISIncidentPostalCode":38544,"businessName":"ROBERTS,GREG","nERISIncidentLatitude":36.17076,"nERISIncidentLongitude":-85.62171,"alarm":"2025-12-10 20:46:36","dispatched":"2025-12-10 20:48:01","incidentLocationCross":"CLARENCE NASH RD\/WARD MILL RD","cADVehicleID":"TK31","timedispatch":"2025-12-10 20:48:01","policeReportNumber":"20250135811\n20250135812\n20250135813\n20250135814","locationCoordinates":"36.17076,-85.62171"}
[2025-12-11 02:48:14] [INFO] Number of extracted fields: 19
[2025-12-11 02:48:14] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'PCFD
PCSO
EMS
BFD'
[2025-12-11 02:48:14] [INFO] Multi-agency routing check: CAD Agency ID = PCFD
PCSO
EMS
BFD, Assigned Agencies count = 1
[2025-12-11 02:48:14] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'PCFD
PCSO
EMS
BFD'
[2025-12-11 02:48:14] [WARNING] WARNING: No SAASClient found with cADAgencyIdentifier = 'PCFD
PCSO
EMS
BFD'
[2025-12-11 02:48:14] [INFO] FALLBACK: Using mailbox default saasclientId: 68eeb686225c40db4 (multi-agency routing attempted but failed)
[2025-12-11 02:48:14] [INFO] Final routing: saasclientId = 68eeb686225c40db4, dispatchStationsIds = ["68ffbebde83509b7c","68ffd433577d1ee1e","68ffbe83793eb4521","68eef9302d19f85fc","68ffbe45d3567d442","68ffbe0e8c5fa650f","68eef77e6a5b1e9d6","68ffbde067a9b162c","68ffbda5d8ebd5468","68ffbd6b1db8d8daa","68ffbd4220b20a872","68ffbcfb8b8911e4e","68eef6ffc8105af4e","68eeca5d553dc8756"]
[2025-12-11 02:48:14] [INFO] Found existing IncidentTypeMapping with ID: 693a30ec30d9fce11
[2025-12-11 02:48:14] [INFO] Found existing Dispatch with cADNumber '2025003027', ID: 693a30ec4bdfe5c0c - will update instead of create
[2025-12-11 02:48:14] [INFO] Updated existing Dispatches record with ID: 693a30ec4bdfe5c0c
[2025-12-11 02:48:14] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135811_20251211_024812.XML
[2025-12-11 02:48:14] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135811_20251211_024812.XML
[2025-12-11 05:34:17] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-29326.xml
[2025-12-11 05:34:17] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-29326.xml for user: 68d56363ec1209189
[2025-12-11 05:34:17] [INFO] File size: 2286 bytes
[2025-12-11 05:34:17] [INFO] Created FTPFiles record with ID: 693a57d963272f6d6
[2025-12-11 05:34:17] [INFO] About to extract fields from XML. File size: 2286 bytes
[2025-12-11 05:34:17] [INFO] Number of mappings: 21
[2025-12-11 05:34:17] [INFO] Starting XML parsing. Content length: 2286
[2025-12-11 05:34:17] [INFO] XML parsed successfully. Root element: Incident
[2025-12-11 05:34:17] [INFO] Processing 21 field mappings
[2025-12-11 05:34:17] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-12-11 05:34:17] [INFO]   -> Found value: 25-29326
[2025-12-11 05:34:17] [INFO]   -> Set field 'dispatchRunNumber' = "25-29326"
[2025-12-11 05:34:17] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-12-11 05:34:17] [INFO]   -> Found value: 302
[2025-12-11 05:34:17] [INFO]   -> Set field 'incidentLocationStreetNumber' = 302
[2025-12-11 05:34:17] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-12-11 05:34:17] [INFO]   -> Found value: STALLCUP DR
[2025-12-11 05:34:17] [INFO]   -> Set field 'streetName' = "STALLCUP DR"
[2025-12-11 05:34:17] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-12-11 05:34:17] [INFO]   -> No value found (null or empty)
[2025-12-11 05:34:17] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-12-11 05:34:17] [INFO]   -> Found value: SIKESTON
[2025-12-11 05:34:17] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-12-11 05:34:17] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-12-11 05:34:17] [INFO]   -> Found value: ANNIE'S GARDEN SKILLED NURSING
[2025-12-11 05:34:17] [INFO]   -> Set field 'businessName' = "ANNIE'S GARDEN SKILLED NURSING"
[2025-12-11 05:34:17] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-12-11 05:34:17] [INFO]   -> Found value: MO
[2025-12-11 05:34:17] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-12-11 05:34:17] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-12-11 05:34:17] [INFO]   -> Found value: 63801
[2025-12-11 05:34:17] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-12-11 05:34:17] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-12-11 05:34:17] [INFO]   -> Found value: 0
[2025-12-11 05:34:17] [INFO]   -> Set field 'nERISIncidentLatitude' = 0
[2025-12-11 05:34:17] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-12-11 05:34:17] [INFO]   -> Found value: 0
[2025-12-11 05:34:17] [INFO]   -> Set field 'nERISIncidentLongitude' = 0
[2025-12-11 05:34:17] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-12-11 05:34:17] [INFO]   -> Found value: FIRE-GAS LEAK
[2025-12-11 05:34:17] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-GAS LEAK"
[2025-12-11 05:34:17] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-12-11 05:34:17] [INFO]   -> Found value: 12-10-2025 22:28:13|STRONG GAS SMELL IN KITCHEN  12-10-2025 22:36:30|TWR1 STAGING STALLCUP AND SCHOO...
[2025-12-11 05:34:17] [INFO]   -> Set field 'dispatchNotes' = "12-10-2025 22:28:13|STRONG GAS SMELL IN KITCHEN  12-10-2025 22:36:30|TWR1 STAGING STALLCUP AND SCHOOL AT HYDRANT 12-10-2025 22:38:29|W 3 MPH 12-10-2025 23:02:57|Disposition - SDPS PD:  NRN 12-10-2025 23:10:18|LEAK WAS LOCATED ON THE STOVE 12-10-2025 23:11:06|GAS HAS BEEN SHUT OFF FOR THE NIGHT THEY WILL HAVE THE CHECKED OUT IN THE MORNING"
[2025-12-11 05:34:17] [INFO]   -> Set field 'cADLog' = "12-10-2025 22:28:13|STRONG GAS SMELL IN KITCHEN  12-10-2025 22:36:30|TWR1 STAGING STALLCUP AND SCHOOL AT HYDRANT 12-10-2025 22:38:29|W 3 MPH 12-10-2025 23:02:57|Disposition - SDPS PD:  NRN 12-10-2025 23:10:18|LEAK WAS LOCATED ON THE STOVE 12-10-2025 23:11:06|GAS HAS BEEN SHUT OFF FOR THE NIGHT THEY WILL HAVE THE CHECKED OUT IN THE MORNING"
[2025-12-11 05:34:17] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-12-11 05:34:17] [INFO]   -> Found value: 12-10-2025T22:30:13
[2025-12-11 05:34:17] [INFO] Reformatted DD-MM-YYYY date '12-10-2025' (day=12, month=10) to ISO: 2025-10-12T22:30:13
[2025-12-11 05:34:17] [INFO]   -> Set field 'alarm' = "2025-10-12 22:30:13"
[2025-12-11 05:34:17] [INFO] Reformatted DD-MM-YYYY date '12-10-2025' (day=12, month=10) to ISO: 2025-10-12T22:30:13
[2025-12-11 05:34:17] [INFO]   -> Set field 'dispatched' = "2025-10-12 22:30:13"
[2025-12-11 05:34:17] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-12-11 05:34:17] [INFO]   -> Found value: 12-10-2025T22:33:16
[2025-12-11 05:34:17] [INFO] Reformatted DD-MM-YYYY date '12-10-2025' (day=12, month=10) to ISO: 2025-10-12T22:33:16
[2025-12-11 05:34:17] [INFO]   -> Set field 'onScene' = "2025-10-12 22:33:16"
[2025-12-11 05:34:17] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-12-11 05:34:17] [INFO]   -> Found value: 12-10-2025T23:33:23
[2025-12-11 05:34:17] [INFO] Reformatted DD-MM-YYYY date '12-10-2025' (day=12, month=10) to ISO: 2025-10-12T23:33:23
[2025-12-11 05:34:17] [INFO]   -> Set field 'cleared' = "2025-10-12 23:33:23"
[2025-12-11 05:34:17] [INFO] Reformatted DD-MM-YYYY date '12-10-2025' (day=12, month=10) to ISO: 2025-10-12T23:33:23
[2025-12-11 05:34:17] [INFO]   -> Set field 'inService' = "2025-10-12 23:33:23"
[2025-12-11 05:34:17] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-12-11 05:34:17] [INFO]   -> Found value: ENG2
[2025-12-11 05:34:17] [INFO]   -> Set field 'cADVehicleID' = "ENG2"
[2025-12-11 05:34:17] [INFO]   -> Set field 'name' = "ENG2"
[2025-12-11 05:34:17] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-12-11 05:34:17] [INFO]   -> Found value: 12-10-2025T22:32:09
[2025-12-11 05:34:17] [INFO] Reformatted DD-MM-YYYY date '12-10-2025' (day=12, month=10) to ISO: 2025-10-12T22:32:09
[2025-12-11 05:34:17] [INFO]   -> Set field 'timeenroutetoscene' = "2025-10-12 22:32:09"
[2025-12-11 05:34:17] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-12-11 05:34:17] [INFO]   -> Found value: 12-10-2025T22:35:34
[2025-12-11 05:34:17] [INFO] Reformatted DD-MM-YYYY date '12-10-2025' (day=12, month=10) to ISO: 2025-10-12T22:35:34
[2025-12-11 05:34:17] [INFO]   -> Set field 'timeonscene' = "2025-10-12 22:35:34"
[2025-12-11 05:34:17] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-12-11 05:34:17] [INFO]   -> Found value: 12-10-2025T23:33:23
[2025-12-11 05:34:17] [INFO] Reformatted DD-MM-YYYY date '12-10-2025' (day=12, month=10) to ISO: 2025-10-12T23:33:23
[2025-12-11 05:34:17] [INFO]   -> Set field 'timeunitclear' = "2025-10-12 23:33:23"
[2025-12-11 05:34:17] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-12-11 05:34:17] [INFO]   -> Found value: 12-10-2025T22:31:50
[2025-12-11 05:34:17] [INFO] Reformatted DD-MM-YYYY date '12-10-2025' (day=12, month=10) to ISO: 2025-10-12T22:31:50
[2025-12-11 05:34:17] [INFO]   -> Set field 'timedispatch' = "2025-10-12 22:31:50"
[2025-12-11 05:34:17] [INFO] Mapping #21: Extracting 'Agency' => 'cADAgencyIdentifier'
[2025-12-11 05:34:17] [INFO]   -> Found value: SDPSFD
[2025-12-11 05:34:17] [INFO]   -> Set field 'cADAgencyIdentifier' = "SDPSFD"
[2025-12-11 05:34:17] [INFO] Finished extracting fields. Total fields extracted: 24
[2025-12-11 05:34:17] [INFO] Built locationCoordinates from lat/lng: 0,0
[2025-12-11 05:34:17] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-29326","incidentLocationStreetNumber":302,"streetName":"STALLCUP DR","incidentLocationCity":"SIKESTON","businessName":"ANNIE'S GARDEN SKILLED NURSING","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":0,"nERISIncidentLongitude":0,"incidentTypeValue1":"FIRE-GAS LEAK","dispatchNotes":"12-10-2025 22:28:13|STRONG GAS SMELL IN KITCHEN  12-10-2025 22:36:30|TWR1 STAGING STALLCUP AND SCHOOL AT HYDRANT 12-10-2025 22:38:29|W 3 MPH 12-10-2025 23:02:57|Disposition - SDPS PD:  NRN 12-10-2025 23:10:18|LEAK WAS LOCATED ON THE STOVE 12-10-2025 23:11:06|GAS HAS BEEN SHUT OFF FOR THE NIGHT THEY WILL HAVE THE CHECKED OUT IN THE MORNING","cADLog":"12-10-2025 22:28:13|STRONG GAS SMELL IN KITCHEN  12-10-2025 22:36:30|TWR1 STAGING STALLCUP AND SCHOOL AT HYDRANT 12-10-2025 22:38:29|W 3 MPH 12-10-2025 23:02:57|Disposition - SDPS PD:  NRN 12-10-2025 23:10:18|LEAK WAS LOCATED ON THE STOVE 12-10-2025 23:11:06|GAS HAS BEEN SHUT OFF FOR THE NIGHT THEY WILL HAVE THE CHECKED OUT IN THE MORNING","alarm":"2025-10-12 22:30:13","dispatched":"2025-10-12 22:30:13","onScene":"2025-10-12 22:33:16","cleared":"2025-10-12 23:33:23","inService":"2025-10-12 23:33:23","cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":"2025-10-12 22:32:09","timeonscene":"2025-10-12 22:35:34","timeunitclear":"2025-10-12 23:33:23","timedispatch":"2025-10-12 22:31:50","cADAgencyIdentifier":"SDPSFD","locationCoordinates":"0,0"}
[2025-12-11 05:34:17] [INFO] Number of extracted fields: 25
[2025-12-11 05:34:17] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'SDPSFD'
[2025-12-11 05:34:17] [INFO] Multi-agency routing check: CAD Agency ID = SDPSFD, Assigned Agencies count = 2
[2025-12-11 05:34:17] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'SDPSFD'
[2025-12-11 05:34:17] [INFO] Found SAASClient match: ID = 6772cab7157b2ebde, Name = Sikeston DPS
[2025-12-11 05:34:17] [INFO] SUCCESS: Routed to agency 'Sikeston DPS' (ID: 6772cab7157b2ebde) based on CAD ID: 'SDPSFD'
[2025-12-11 05:34:17] [INFO] Fetched 4 stations from Stations module for agency 'Sikeston DPS': ["67d843b7d3670caf0","67d843823ed523b5c","67d8434fe3dc432c7","68d5ab6eaa6dc3961"]
[2025-12-11 05:34:17] [INFO] Final routing: saasclientId = 6772cab7157b2ebde, dispatchStationsIds = ["67d843b7d3670caf0","67d843823ed523b5c","67d8434fe3dc432c7","68d5ab6eaa6dc3961"]
[2025-12-11 05:34:17] [INFO] Updated FTPFiles record saasclientId to routed agency: 6772cab7157b2ebde
[2025-12-11 05:34:17] [INFO] Found existing IncidentTypeMapping with ID: 68e4025e2ad978594
[2025-12-11 05:34:18] [INFO] Created new Dispatches record with ID: 693a57d9b4947b269
[2025-12-11 05:34:18] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-29326.xml
[2025-12-11 05:34:18] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-29326.xml
[2025-12-11 08:47:41] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135859_20251211_084741.XML
[2025-12-11 08:47:41] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135859_20251211_084741.XML for user: 68f1466aed072ad4a
[2025-12-11 08:47:41] [INFO] File size: 5251 bytes
[2025-12-11 08:47:41] [INFO] Created FTPFiles record with ID: 693a852ddd680d1be
[2025-12-11 08:47:41] [INFO] About to extract fields from XML. File size: 5251 bytes
[2025-12-11 08:47:41] [INFO] Number of mappings: 25
[2025-12-11 08:47:41] [INFO] Starting XML parsing. Content length: 5251
[2025-12-11 08:47:41] [INFO] XML parsed successfully. Root element: CADExport
[2025-12-11 08:47:41] [INFO] Processing 25 field mappings
[2025-12-11 08:47:41] [INFO] Mapping #1: Extracting 'EventDetails.AgencyCode' => 'cADAgencyIdentifier'
[2025-12-11 08:47:41] [INFO] Found 3 elements for 'AgencyCode', concatenating 3 non-empty values
[2025-12-11 08:47:41] [INFO]   -> Found value: PCFD
EMS
RESC
[2025-12-11 08:47:41] [INFO]   -> Set field 'cADAgencyIdentifier' = "PCFD\nEMS\nRESC"
[2025-12-11 08:47:41] [INFO] Mapping #2: Extracting 'EventDetails.ReportNumber' => ["incidentInternalId","dispatchRunNumber"]
[2025-12-11 08:47:41] [INFO] Found 3 elements for 'ReportNumber', concatenating 1 non-empty values
[2025-12-11 08:47:41] [INFO]   -> Found value: 2025003028
[2025-12-11 08:47:41] [INFO]   -> Set field 'incidentInternalId' = "2025003028"
[2025-12-11 08:47:41] [INFO]   -> Set field 'dispatchRunNumber' = "2025003028"
[2025-12-11 08:47:41] [INFO] Mapping #3: Extracting 'EventDetails.NatureDescription' => 'incidentTypeValue1'
[2025-12-11 08:47:41] [INFO]   -> Found value: FAINTING / SYNCOPE
[2025-12-11 08:47:41] [INFO]   -> Set field 'incidentTypeValue1' = "FAINTING \/ SYNCOPE"
[2025-12-11 08:47:41] [INFO] Mapping #4: Extracting 'EventDetails.StreetNumber' => 'incidentLocationStreetNumber'
[2025-12-11 08:47:41] [INFO]   -> Found value: 2222
[2025-12-11 08:47:41] [INFO]   -> Set field 'incidentLocationStreetNumber' = 2222
[2025-12-11 08:47:41] [INFO] Mapping #5: Extracting 'RelatedNames.Name.StreetName' => 'streetName'
[2025-12-11 08:47:41] [INFO]   -> Found value: MEDLEY AMONETTE RD
[2025-12-11 08:47:41] [INFO]   -> Set field 'streetName' = "MEDLEY AMONETTE RD"
[2025-12-11 08:47:41] [INFO] Mapping #6: Extracting 'RelatedNames.Name.City' => 'incidentLocationCity'
[2025-12-11 08:47:41] [INFO]   -> Found value: BUFFALO VALLEY
[2025-12-11 08:47:41] [INFO]   -> Set field 'incidentLocationCity' = "BUFFALO VALLEY"
[2025-12-11 08:47:41] [INFO] Mapping #7: Extracting 'EventDetails.State' => 'incidentLocationStateName'
[2025-12-11 08:47:41] [INFO]   -> Found value: TN
[2025-12-11 08:47:41] [INFO]   -> Set field 'incidentLocationStateName' = "TN"
[2025-12-11 08:47:41] [INFO] Mapping #8: Extracting 'EventDetails.ZipCode' => 'nERISIncidentPostalCode'
[2025-12-11 08:47:41] [INFO]   -> Found value: 38548
[2025-12-11 08:47:41] [INFO]   -> Set field 'nERISIncidentPostalCode' = 38548
[2025-12-11 08:47:41] [INFO] Mapping #9: Extracting 'EventDetails.SiteName' => 'businessName'
[2025-12-11 08:47:41] [INFO]   -> No value found (null or empty)
[2025-12-11 08:47:41] [INFO] Mapping #10: Extracting 'EventDetails.ApartmentSuite' => 'incidentLocationApt'
[2025-12-11 08:47:41] [INFO]   -> No value found (null or empty)
[2025-12-11 08:47:41] [INFO] Mapping #11: Extracting 'EventDetails.EventLatitude' => 'nERISIncidentLatitude'
[2025-12-11 08:47:41] [INFO]   -> Found value: 36.16074
[2025-12-11 08:47:41] [INFO]   -> Set field 'nERISIncidentLatitude' = 36.16074
[2025-12-11 08:47:41] [INFO] Mapping #12: Extracting 'EventDetails.EventLongitude' => 'nERISIncidentLongitude'
[2025-12-11 08:47:41] [INFO]   -> Found value: -85.77895
[2025-12-11 08:47:41] [INFO]   -> Set field 'nERISIncidentLongitude' = -85.77895
[2025-12-11 08:47:41] [INFO] Mapping #13: Extracting 'EventDetails.EventStartTime' => 'alarm'
[2025-12-11 08:47:41] [INFO]   -> Found value: 2025-12-11 02:47:04
[2025-12-11 08:47:41] [INFO]   -> Set field 'alarm' = "2025-12-11 02:47:04"
[2025-12-11 08:47:41] [INFO] Mapping #14: Extracting 'EventDetails.FirstDispatchTime' => 'dispatched'
[2025-12-11 08:47:41] [INFO]   -> Found value: 2025-12-11 02:47:31
[2025-12-11 08:47:41] [INFO]   -> Set field 'dispatched' = "2025-12-11 02:47:31"
[2025-12-11 08:47:41] [INFO] Mapping #15: Extracting 'EventDetails.FirstEnrouteTime' => 'enroute'
[2025-12-11 08:47:41] [INFO]   -> No value found (null or empty)
[2025-12-11 08:47:41] [INFO] Mapping #16: Extracting 'EventDetails.FirstOnSceneTime' => 'onScene'
[2025-12-11 08:47:41] [INFO]   -> No value found (null or empty)
[2025-12-11 08:47:41] [INFO] Mapping #17: Extracting 'EventDetails.LastUnitClearTime' => ["cleared","inService"]
[2025-12-11 08:47:41] [INFO]   -> No value found (null or empty)
[2025-12-11 08:47:41] [INFO] Mapping #18: Extracting 'EventDetails.CrossStreets' => 'incidentLocationCross'
[2025-12-11 08:47:41] [INFO]   -> Found value: NASHVILLE HWY/MEDLEY AMONETTE RD
[2025-12-11 08:47:41] [INFO]   -> Set field 'incidentLocationCross' = "NASHVILLE HWY\/MEDLEY AMONETTE RD"
[2025-12-11 08:47:41] [INFO] Mapping #19: Extracting 'EventUnits.Unit[0].UnitCode' => 'cADVehicleID'
[2025-12-11 08:47:41] [INFO]   -> Found value: PCFR
[2025-12-11 08:47:41] [INFO]   -> Set field 'cADVehicleID' = "PCFR"
[2025-12-11 08:47:41] [INFO] Mapping #20: Extracting 'EventUnits.Unit[0].DispatchTime' => 'timedispatch'
[2025-12-11 08:47:41] [INFO]   -> Found value: 2025-12-11 02:47:31
[2025-12-11 08:47:41] [INFO]   -> Set field 'timedispatch' = "2025-12-11 02:47:31"
[2025-12-11 08:47:41] [INFO] Mapping #21: Extracting 'EventUnits.Unit[0].EnRouteTime' => 'timeenroutetoscene'
[2025-12-11 08:47:41] [INFO]   -> No value found (null or empty)
[2025-12-11 08:47:41] [INFO] Mapping #22: Extracting 'EventUnits.Unit[0].ArriveTime' => 'timeonscene'
[2025-12-11 08:47:41] [INFO]   -> No value found (null or empty)
[2025-12-11 08:47:41] [INFO] Mapping #23: Extracting 'EventUnits.Unit[0].ReturnToServiceTime' => 'timeunitclear'
[2025-12-11 08:47:41] [INFO]   -> No value found (null or empty)
[2025-12-11 08:47:41] [INFO] Mapping #24: Extracting 'EventUnits.Unit[0].CancelTime' => 'timecanceledenroute'
[2025-12-11 08:47:41] [INFO]   -> No value found (null or empty)
[2025-12-11 08:47:41] [INFO] Mapping #25: Extracting 'EventDetails.CadInciNumber' => 'policeReportNumber'
[2025-12-11 08:47:41] [INFO] Found 3 elements for 'CadInciNumber', concatenating 3 non-empty values
[2025-12-11 08:47:41] [INFO]   -> Found value: 20250135859
20250135858
20250135860
[2025-12-11 08:47:41] [INFO]   -> Set field 'policeReportNumber' = "20250135859\n20250135858\n20250135860"
[2025-12-11 08:47:41] [INFO] Finished extracting fields. Total fields extracted: 17
[2025-12-11 08:47:41] [INFO] Built locationCoordinates from lat/lng: 36.16074,-85.77895
[2025-12-11 08:47:41] [INFO] Extracted parsing rules data: {"cADAgencyIdentifier":"PCFD\nEMS\nRESC","incidentInternalId":"2025003028","dispatchRunNumber":"2025003028","incidentTypeValue1":"FAINTING \/ SYNCOPE","incidentLocationStreetNumber":2222,"streetName":"MEDLEY AMONETTE RD","incidentLocationCity":"BUFFALO VALLEY","incidentLocationStateName":"TN","nERISIncidentPostalCode":38548,"nERISIncidentLatitude":36.16074,"nERISIncidentLongitude":-85.77895,"alarm":"2025-12-11 02:47:04","dispatched":"2025-12-11 02:47:31","incidentLocationCross":"NASHVILLE HWY\/MEDLEY AMONETTE RD","cADVehicleID":"PCFR","timedispatch":"2025-12-11 02:47:31","policeReportNumber":"20250135859\n20250135858\n20250135860","locationCoordinates":"36.16074,-85.77895"}
[2025-12-11 08:47:41] [INFO] Number of extracted fields: 18
[2025-12-11 08:47:41] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'PCFD
EMS
RESC'
[2025-12-11 08:47:41] [INFO] Multi-agency routing check: CAD Agency ID = PCFD
EMS
RESC, Assigned Agencies count = 1
[2025-12-11 08:47:41] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'PCFD
EMS
RESC'
[2025-12-11 08:47:41] [WARNING] WARNING: No SAASClient found with cADAgencyIdentifier = 'PCFD
EMS
RESC'
[2025-12-11 08:47:41] [INFO] FALLBACK: Using mailbox default saasclientId: 68eeb686225c40db4 (multi-agency routing attempted but failed)
[2025-12-11 08:47:41] [INFO] Final routing: saasclientId = 68eeb686225c40db4, dispatchStationsIds = ["68ffbebde83509b7c","68ffd433577d1ee1e","68ffbe83793eb4521","68eef9302d19f85fc","68ffbe45d3567d442","68ffbe0e8c5fa650f","68eef77e6a5b1e9d6","68ffbde067a9b162c","68ffbda5d8ebd5468","68ffbd6b1db8d8daa","68ffbd4220b20a872","68ffbcfb8b8911e4e","68eef6ffc8105af4e","68eeca5d553dc8756"]
[2025-12-11 08:47:42] [INFO] Found existing IncidentTypeMapping with ID: 693861a57fd64f0b2
[2025-12-11 08:47:44] [INFO] Created new Dispatches record with ID: 693a852e20fc6a207
[2025-12-11 08:47:44] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135859_20251211_084741.XML
[2025-12-11 08:47:44] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135859_20251211_084741.XML
[2025-12-11 08:47:44] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135859_20251211_084742.XML
[2025-12-11 08:47:44] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135859_20251211_084742.XML for user: 68f1466aed072ad4a
[2025-12-11 08:47:44] [INFO] File size: 5251 bytes
[2025-12-11 08:47:44] [INFO] Created FTPFiles record with ID: 693a85304b74ae2db
[2025-12-11 08:47:44] [INFO] About to extract fields from XML. File size: 5251 bytes
[2025-12-11 08:47:44] [INFO] Number of mappings: 25
[2025-12-11 08:47:44] [INFO] Starting XML parsing. Content length: 5251
[2025-12-11 08:47:44] [INFO] XML parsed successfully. Root element: CADExport
[2025-12-11 08:47:44] [INFO] Processing 25 field mappings
[2025-12-11 08:47:44] [INFO] Mapping #1: Extracting 'EventDetails.AgencyCode' => 'cADAgencyIdentifier'
[2025-12-11 08:47:44] [INFO] Found 3 elements for 'AgencyCode', concatenating 3 non-empty values
[2025-12-11 08:47:44] [INFO]   -> Found value: PCFD
EMS
RESC
[2025-12-11 08:47:44] [INFO]   -> Set field 'cADAgencyIdentifier' = "PCFD\nEMS\nRESC"
[2025-12-11 08:47:44] [INFO] Mapping #2: Extracting 'EventDetails.ReportNumber' => ["incidentInternalId","dispatchRunNumber"]
[2025-12-11 08:47:44] [INFO] Found 3 elements for 'ReportNumber', concatenating 1 non-empty values
[2025-12-11 08:47:44] [INFO]   -> Found value: 2025003028
[2025-12-11 08:47:44] [INFO]   -> Set field 'incidentInternalId' = "2025003028"
[2025-12-11 08:47:44] [INFO]   -> Set field 'dispatchRunNumber' = "2025003028"
[2025-12-11 08:47:44] [INFO] Mapping #3: Extracting 'EventDetails.NatureDescription' => 'incidentTypeValue1'
[2025-12-11 08:47:44] [INFO]   -> Found value: FAINTING / SYNCOPE
[2025-12-11 08:47:44] [INFO]   -> Set field 'incidentTypeValue1' = "FAINTING \/ SYNCOPE"
[2025-12-11 08:47:44] [INFO] Mapping #4: Extracting 'EventDetails.StreetNumber' => 'incidentLocationStreetNumber'
[2025-12-11 08:47:44] [INFO]   -> Found value: 2222
[2025-12-11 08:47:44] [INFO]   -> Set field 'incidentLocationStreetNumber' = 2222
[2025-12-11 08:47:44] [INFO] Mapping #5: Extracting 'RelatedNames.Name.StreetName' => 'streetName'
[2025-12-11 08:47:44] [INFO]   -> Found value: MEDLEY AMONETTE RD
[2025-12-11 08:47:44] [INFO]   -> Set field 'streetName' = "MEDLEY AMONETTE RD"
[2025-12-11 08:47:44] [INFO] Mapping #6: Extracting 'RelatedNames.Name.City' => 'incidentLocationCity'
[2025-12-11 08:47:44] [INFO]   -> Found value: BUFFALO VALLEY
[2025-12-11 08:47:44] [INFO]   -> Set field 'incidentLocationCity' = "BUFFALO VALLEY"
[2025-12-11 08:47:44] [INFO] Mapping #7: Extracting 'EventDetails.State' => 'incidentLocationStateName'
[2025-12-11 08:47:44] [INFO]   -> Found value: TN
[2025-12-11 08:47:44] [INFO]   -> Set field 'incidentLocationStateName' = "TN"
[2025-12-11 08:47:44] [INFO] Mapping #8: Extracting 'EventDetails.ZipCode' => 'nERISIncidentPostalCode'
[2025-12-11 08:47:44] [INFO]   -> Found value: 38548
[2025-12-11 08:47:44] [INFO]   -> Set field 'nERISIncidentPostalCode' = 38548
[2025-12-11 08:47:44] [INFO] Mapping #9: Extracting 'EventDetails.SiteName' => 'businessName'
[2025-12-11 08:47:44] [INFO]   -> No value found (null or empty)
[2025-12-11 08:47:44] [INFO] Mapping #10: Extracting 'EventDetails.ApartmentSuite' => 'incidentLocationApt'
[2025-12-11 08:47:44] [INFO]   -> No value found (null or empty)
[2025-12-11 08:47:44] [INFO] Mapping #11: Extracting 'EventDetails.EventLatitude' => 'nERISIncidentLatitude'
[2025-12-11 08:47:44] [INFO]   -> Found value: 36.16074
[2025-12-11 08:47:44] [INFO]   -> Set field 'nERISIncidentLatitude' = 36.16074
[2025-12-11 08:47:44] [INFO] Mapping #12: Extracting 'EventDetails.EventLongitude' => 'nERISIncidentLongitude'
[2025-12-11 08:47:44] [INFO]   -> Found value: -85.77895
[2025-12-11 08:47:44] [INFO]   -> Set field 'nERISIncidentLongitude' = -85.77895
[2025-12-11 08:47:44] [INFO] Mapping #13: Extracting 'EventDetails.EventStartTime' => 'alarm'
[2025-12-11 08:47:44] [INFO]   -> Found value: 2025-12-11 02:47:04
[2025-12-11 08:47:44] [INFO]   -> Set field 'alarm' = "2025-12-11 02:47:04"
[2025-12-11 08:47:44] [INFO] Mapping #14: Extracting 'EventDetails.FirstDispatchTime' => 'dispatched'
[2025-12-11 08:47:44] [INFO]   -> Found value: 2025-12-11 02:47:31
[2025-12-11 08:47:44] [INFO]   -> Set field 'dispatched' = "2025-12-11 02:47:31"
[2025-12-11 08:47:44] [INFO] Mapping #15: Extracting 'EventDetails.FirstEnrouteTime' => 'enroute'
[2025-12-11 08:47:44] [INFO]   -> No value found (null or empty)
[2025-12-11 08:47:44] [INFO] Mapping #16: Extracting 'EventDetails.FirstOnSceneTime' => 'onScene'
[2025-12-11 08:47:44] [INFO]   -> No value found (null or empty)
[2025-12-11 08:47:44] [INFO] Mapping #17: Extracting 'EventDetails.LastUnitClearTime' => ["cleared","inService"]
[2025-12-11 08:47:44] [INFO]   -> No value found (null or empty)
[2025-12-11 08:47:44] [INFO] Mapping #18: Extracting 'EventDetails.CrossStreets' => 'incidentLocationCross'
[2025-12-11 08:47:44] [INFO]   -> Found value: NASHVILLE HWY/MEDLEY AMONETTE RD
[2025-12-11 08:47:44] [INFO]   -> Set field 'incidentLocationCross' = "NASHVILLE HWY\/MEDLEY AMONETTE RD"
[2025-12-11 08:47:44] [INFO] Mapping #19: Extracting 'EventUnits.Unit[0].UnitCode' => 'cADVehicleID'
[2025-12-11 08:47:44] [INFO]   -> Found value: PCFR
[2025-12-11 08:47:44] [INFO]   -> Set field 'cADVehicleID' = "PCFR"
[2025-12-11 08:47:44] [INFO] Mapping #20: Extracting 'EventUnits.Unit[0].DispatchTime' => 'timedispatch'
[2025-12-11 08:47:44] [INFO]   -> Found value: 2025-12-11 02:47:31
[2025-12-11 08:47:44] [INFO]   -> Set field 'timedispatch' = "2025-12-11 02:47:31"
[2025-12-11 08:47:44] [INFO] Mapping #21: Extracting 'EventUnits.Unit[0].EnRouteTime' => 'timeenroutetoscene'
[2025-12-11 08:47:44] [INFO]   -> No value found (null or empty)
[2025-12-11 08:47:44] [INFO] Mapping #22: Extracting 'EventUnits.Unit[0].ArriveTime' => 'timeonscene'
[2025-12-11 08:47:44] [INFO]   -> No value found (null or empty)
[2025-12-11 08:47:44] [INFO] Mapping #23: Extracting 'EventUnits.Unit[0].ReturnToServiceTime' => 'timeunitclear'
[2025-12-11 08:47:44] [INFO]   -> No value found (null or empty)
[2025-12-11 08:47:44] [INFO] Mapping #24: Extracting 'EventUnits.Unit[0].CancelTime' => 'timecanceledenroute'
[2025-12-11 08:47:44] [INFO]   -> No value found (null or empty)
[2025-12-11 08:47:44] [INFO] Mapping #25: Extracting 'EventDetails.CadInciNumber' => 'policeReportNumber'
[2025-12-11 08:47:44] [INFO] Found 3 elements for 'CadInciNumber', concatenating 3 non-empty values
[2025-12-11 08:47:44] [INFO]   -> Found value: 20250135859
20250135858
20250135860
[2025-12-11 08:47:44] [INFO]   -> Set field 'policeReportNumber' = "20250135859\n20250135858\n20250135860"
[2025-12-11 08:47:44] [INFO] Finished extracting fields. Total fields extracted: 17
[2025-12-11 08:47:44] [INFO] Built locationCoordinates from lat/lng: 36.16074,-85.77895
[2025-12-11 08:47:44] [INFO] Extracted parsing rules data: {"cADAgencyIdentifier":"PCFD\nEMS\nRESC","incidentInternalId":"2025003028","dispatchRunNumber":"2025003028","incidentTypeValue1":"FAINTING \/ SYNCOPE","incidentLocationStreetNumber":2222,"streetName":"MEDLEY AMONETTE RD","incidentLocationCity":"BUFFALO VALLEY","incidentLocationStateName":"TN","nERISIncidentPostalCode":38548,"nERISIncidentLatitude":36.16074,"nERISIncidentLongitude":-85.77895,"alarm":"2025-12-11 02:47:04","dispatched":"2025-12-11 02:47:31","incidentLocationCross":"NASHVILLE HWY\/MEDLEY AMONETTE RD","cADVehicleID":"PCFR","timedispatch":"2025-12-11 02:47:31","policeReportNumber":"20250135859\n20250135858\n20250135860","locationCoordinates":"36.16074,-85.77895"}
[2025-12-11 08:47:44] [INFO] Number of extracted fields: 18
[2025-12-11 08:47:44] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'PCFD
EMS
RESC'
[2025-12-11 08:47:44] [INFO] Multi-agency routing check: CAD Agency ID = PCFD
EMS
RESC, Assigned Agencies count = 1
[2025-12-11 08:47:44] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'PCFD
EMS
RESC'
[2025-12-11 08:47:44] [WARNING] WARNING: No SAASClient found with cADAgencyIdentifier = 'PCFD
EMS
RESC'
[2025-12-11 08:47:44] [INFO] FALLBACK: Using mailbox default saasclientId: 68eeb686225c40db4 (multi-agency routing attempted but failed)
[2025-12-11 08:47:44] [INFO] Final routing: saasclientId = 68eeb686225c40db4, dispatchStationsIds = ["68ffbebde83509b7c","68ffd433577d1ee1e","68ffbe83793eb4521","68eef9302d19f85fc","68ffbe45d3567d442","68ffbe0e8c5fa650f","68eef77e6a5b1e9d6","68ffbde067a9b162c","68ffbda5d8ebd5468","68ffbd6b1db8d8daa","68ffbd4220b20a872","68ffbcfb8b8911e4e","68eef6ffc8105af4e","68eeca5d553dc8756"]
[2025-12-11 08:47:44] [INFO] Found existing IncidentTypeMapping with ID: 693861a57fd64f0b2
[2025-12-11 08:47:44] [INFO] Found existing Dispatch with cADNumber '2025003028', ID: 693a852e20fc6a207 - will update instead of create
[2025-12-11 08:47:44] [INFO] Updated existing Dispatches record with ID: 693a852e20fc6a207
[2025-12-11 08:47:44] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135859_20251211_084742.XML
[2025-12-11 08:47:44] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135859_20251211_084742.XML
[2025-12-11 12:04:31] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135879_20251211_120431.XML
[2025-12-11 12:04:31] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135879_20251211_120431.XML for user: 68f1466aed072ad4a
[2025-12-11 12:04:31] [INFO] File size: 5001 bytes
[2025-12-11 12:04:31] [INFO] Created FTPFiles record with ID: 693ab34fcef2cc904
[2025-12-11 12:04:31] [INFO] About to extract fields from XML. File size: 5001 bytes
[2025-12-11 12:04:31] [INFO] Number of mappings: 25
[2025-12-11 12:04:31] [INFO] Starting XML parsing. Content length: 5001
[2025-12-11 12:04:31] [INFO] XML parsed successfully. Root element: CADExport
[2025-12-11 12:04:31] [INFO] Processing 25 field mappings
[2025-12-11 12:04:31] [INFO] Mapping #1: Extracting 'EventDetails.AgencyCode' => 'cADAgencyIdentifier'
[2025-12-11 12:04:31] [INFO] Found 2 elements for 'AgencyCode', concatenating 2 non-empty values
[2025-12-11 12:04:31] [INFO]   -> Found value: PCFD
EMS
[2025-12-11 12:04:31] [INFO]   -> Set field 'cADAgencyIdentifier' = "PCFD\nEMS"
[2025-12-11 12:04:31] [INFO] Mapping #2: Extracting 'EventDetails.ReportNumber' => ["incidentInternalId","dispatchRunNumber"]
[2025-12-11 12:04:31] [INFO] Found 2 elements for 'ReportNumber', concatenating 2 non-empty values
[2025-12-11 12:04:31] [INFO]   -> Found value: 2025003029
2025019210
[2025-12-11 12:04:31] [INFO]   -> Set field 'incidentInternalId' = "2025003029\n2025019210"
[2025-12-11 12:04:31] [INFO]   -> Set field 'dispatchRunNumber' = "2025003029\n2025019210"
[2025-12-11 12:04:31] [INFO] Mapping #3: Extracting 'EventDetails.NatureDescription' => 'incidentTypeValue1'
[2025-12-11 12:04:31] [INFO]   -> Found value: MANPOWER - EMS ASSIST
[2025-12-11 12:04:31] [INFO]   -> Set field 'incidentTypeValue1' = "MANPOWER - EMS ASSIST"
[2025-12-11 12:04:31] [INFO] Mapping #4: Extracting 'EventDetails.StreetNumber' => 'incidentLocationStreetNumber'
[2025-12-11 12:04:31] [INFO]   -> Found value: 2415
[2025-12-11 12:04:31] [INFO]   -> Set field 'incidentLocationStreetNumber' = 2415
[2025-12-11 12:04:31] [INFO] Mapping #5: Extracting 'RelatedNames.Name.StreetName' => 'streetName'
[2025-12-11 12:04:31] [INFO]   -> Found value: DIXON LN
[2025-12-11 12:04:31] [INFO]   -> Set field 'streetName' = "DIXON LN"
[2025-12-11 12:04:31] [INFO] Mapping #6: Extracting 'RelatedNames.Name.City' => 'incidentLocationCity'
[2025-12-11 12:04:31] [INFO]   -> Found value: COOKEVILLE
[2025-12-11 12:04:31] [INFO]   -> Set field 'incidentLocationCity' = "COOKEVILLE"
[2025-12-11 12:04:31] [INFO] Mapping #7: Extracting 'EventDetails.State' => 'incidentLocationStateName'
[2025-12-11 12:04:31] [INFO]   -> Found value: TN
[2025-12-11 12:04:31] [INFO]   -> Set field 'incidentLocationStateName' = "TN"
[2025-12-11 12:04:31] [INFO] Mapping #8: Extracting 'EventDetails.ZipCode' => 'nERISIncidentPostalCode'
[2025-12-11 12:04:31] [INFO]   -> Found value: 38501
[2025-12-11 12:04:31] [INFO]   -> Set field 'nERISIncidentPostalCode' = 38501
[2025-12-11 12:04:31] [INFO] Mapping #9: Extracting 'EventDetails.SiteName' => 'businessName'
[2025-12-11 12:04:31] [INFO]   -> No value found (null or empty)
[2025-12-11 12:04:31] [INFO] Mapping #10: Extracting 'EventDetails.ApartmentSuite' => 'incidentLocationApt'
[2025-12-11 12:04:31] [INFO]   -> No value found (null or empty)
[2025-12-11 12:04:31] [INFO] Mapping #11: Extracting 'EventDetails.EventLatitude' => 'nERISIncidentLatitude'
[2025-12-11 12:04:31] [INFO]   -> Found value: 36.19928
[2025-12-11 12:04:31] [INFO]   -> Set field 'nERISIncidentLatitude' = 36.19928
[2025-12-11 12:04:31] [INFO] Mapping #12: Extracting 'EventDetails.EventLongitude' => 'nERISIncidentLongitude'
[2025-12-11 12:04:31] [INFO]   -> Found value: -85.49360
[2025-12-11 12:04:31] [INFO]   -> Set field 'nERISIncidentLongitude' = -85.4936
[2025-12-11 12:04:31] [INFO] Mapping #13: Extracting 'EventDetails.EventStartTime' => 'alarm'
[2025-12-11 12:04:31] [INFO]   -> Found value: 2025-12-11 06:03:42
[2025-12-11 12:04:31] [INFO]   -> Set field 'alarm' = "2025-12-11 06:03:42"
[2025-12-11 12:04:31] [INFO] Mapping #14: Extracting 'EventDetails.FirstDispatchTime' => 'dispatched'
[2025-12-11 12:04:31] [INFO]   -> Found value: 2025-12-11 06:04:23
[2025-12-11 12:04:31] [INFO]   -> Set field 'dispatched' = "2025-12-11 06:04:23"
[2025-12-11 12:04:31] [INFO] Mapping #15: Extracting 'EventDetails.FirstEnrouteTime' => 'enroute'
[2025-12-11 12:04:31] [INFO]   -> No value found (null or empty)
[2025-12-11 12:04:31] [INFO] Mapping #16: Extracting 'EventDetails.FirstOnSceneTime' => 'onScene'
[2025-12-11 12:04:31] [INFO]   -> No value found (null or empty)
[2025-12-11 12:04:31] [INFO] Mapping #17: Extracting 'EventDetails.LastUnitClearTime' => ["cleared","inService"]
[2025-12-11 12:04:31] [INFO]   -> No value found (null or empty)
[2025-12-11 12:04:31] [INFO] Mapping #18: Extracting 'EventDetails.CrossStreets' => 'incidentLocationCross'
[2025-12-11 12:04:31] [INFO]   -> Found value: /DALE LN
[2025-12-11 12:04:31] [INFO]   -> Set field 'incidentLocationCross' = "\/DALE LN"
[2025-12-11 12:04:31] [INFO] Mapping #19: Extracting 'EventUnits.Unit[0].UnitCode' => 'cADVehicleID'
[2025-12-11 12:04:31] [INFO]   -> Found value: SQ11
[2025-12-11 12:04:31] [INFO]   -> Set field 'cADVehicleID' = "SQ11"
[2025-12-11 12:04:31] [INFO] Mapping #20: Extracting 'EventUnits.Unit[0].DispatchTime' => 'timedispatch'
[2025-12-11 12:04:31] [INFO]   -> Found value: 2025-12-11 06:04:23
[2025-12-11 12:04:31] [INFO]   -> Set field 'timedispatch' = "2025-12-11 06:04:23"
[2025-12-11 12:04:31] [INFO] Mapping #21: Extracting 'EventUnits.Unit[0].EnRouteTime' => 'timeenroutetoscene'
[2025-12-11 12:04:31] [INFO]   -> No value found (null or empty)
[2025-12-11 12:04:31] [INFO] Mapping #22: Extracting 'EventUnits.Unit[0].ArriveTime' => 'timeonscene'
[2025-12-11 12:04:31] [INFO]   -> No value found (null or empty)
[2025-12-11 12:04:31] [INFO] Mapping #23: Extracting 'EventUnits.Unit[0].ReturnToServiceTime' => 'timeunitclear'
[2025-12-11 12:04:31] [INFO]   -> No value found (null or empty)
[2025-12-11 12:04:31] [INFO] Mapping #24: Extracting 'EventUnits.Unit[0].CancelTime' => 'timecanceledenroute'
[2025-12-11 12:04:31] [INFO]   -> No value found (null or empty)
[2025-12-11 12:04:31] [INFO] Mapping #25: Extracting 'EventDetails.CadInciNumber' => 'policeReportNumber'
[2025-12-11 12:04:31] [INFO] Found 2 elements for 'CadInciNumber', concatenating 2 non-empty values
[2025-12-11 12:04:31] [INFO]   -> Found value: 20250135879
20250135877
[2025-12-11 12:04:31] [INFO]   -> Set field 'policeReportNumber' = "20250135879\n20250135877"
[2025-12-11 12:04:31] [INFO] Finished extracting fields. Total fields extracted: 17
[2025-12-11 12:04:31] [INFO] Built locationCoordinates from lat/lng: 36.19928,-85.4936
[2025-12-11 12:04:31] [INFO] Extracted parsing rules data: {"cADAgencyIdentifier":"PCFD\nEMS","incidentInternalId":"2025003029\n2025019210","dispatchRunNumber":"2025003029\n2025019210","incidentTypeValue1":"MANPOWER - EMS ASSIST","incidentLocationStreetNumber":2415,"streetName":"DIXON LN","incidentLocationCity":"COOKEVILLE","incidentLocationStateName":"TN","nERISIncidentPostalCode":38501,"nERISIncidentLatitude":36.19928,"nERISIncidentLongitude":-85.4936,"alarm":"2025-12-11 06:03:42","dispatched":"2025-12-11 06:04:23","incidentLocationCross":"\/DALE LN","cADVehicleID":"SQ11","timedispatch":"2025-12-11 06:04:23","policeReportNumber":"20250135879\n20250135877","locationCoordinates":"36.19928,-85.4936"}
[2025-12-11 12:04:31] [INFO] Number of extracted fields: 18
[2025-12-11 12:04:31] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'PCFD
EMS'
[2025-12-11 12:04:31] [INFO] Multi-agency routing check: CAD Agency ID = PCFD
EMS, Assigned Agencies count = 1
[2025-12-11 12:04:31] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'PCFD
EMS'
[2025-12-11 12:04:31] [WARNING] WARNING: No SAASClient found with cADAgencyIdentifier = 'PCFD
EMS'
[2025-12-11 12:04:31] [INFO] FALLBACK: Using mailbox default saasclientId: 68eeb686225c40db4 (multi-agency routing attempted but failed)
[2025-12-11 12:04:31] [INFO] Final routing: saasclientId = 68eeb686225c40db4, dispatchStationsIds = ["68ffbebde83509b7c","68ffd433577d1ee1e","68ffbe83793eb4521","68eef9302d19f85fc","68ffbe45d3567d442","68ffbe0e8c5fa650f","68eef77e6a5b1e9d6","68ffbde067a9b162c","68ffbda5d8ebd5468","68ffbd6b1db8d8daa","68ffbd4220b20a872","68ffbcfb8b8911e4e","68eef6ffc8105af4e","68eeca5d553dc8756"]
[2025-12-11 12:04:31] [INFO] Found existing IncidentTypeMapping with ID: 6938bcc5e565c9852
[2025-12-11 12:04:34] [INFO] Created new Dispatches record with ID: 693ab350178581811
[2025-12-11 12:04:34] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135879_20251211_120431.XML
[2025-12-11 12:04:34] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135879_20251211_120431.XML
[2025-12-11 12:04:34] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135879_20251211_120432.XML
[2025-12-11 12:04:34] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135879_20251211_120432.XML for user: 68f1466aed072ad4a
[2025-12-11 12:04:34] [INFO] File size: 5001 bytes
[2025-12-11 12:04:34] [INFO] Created FTPFiles record with ID: 693ab352588b123d7
[2025-12-11 12:04:34] [INFO] About to extract fields from XML. File size: 5001 bytes
[2025-12-11 12:04:34] [INFO] Number of mappings: 25
[2025-12-11 12:04:34] [INFO] Starting XML parsing. Content length: 5001
[2025-12-11 12:04:34] [INFO] XML parsed successfully. Root element: CADExport
[2025-12-11 12:04:34] [INFO] Processing 25 field mappings
[2025-12-11 12:04:34] [INFO] Mapping #1: Extracting 'EventDetails.AgencyCode' => 'cADAgencyIdentifier'
[2025-12-11 12:04:34] [INFO] Found 2 elements for 'AgencyCode', concatenating 2 non-empty values
[2025-12-11 12:04:34] [INFO]   -> Found value: PCFD
EMS
[2025-12-11 12:04:34] [INFO]   -> Set field 'cADAgencyIdentifier' = "PCFD\nEMS"
[2025-12-11 12:04:34] [INFO] Mapping #2: Extracting 'EventDetails.ReportNumber' => ["incidentInternalId","dispatchRunNumber"]
[2025-12-11 12:04:34] [INFO] Found 2 elements for 'ReportNumber', concatenating 2 non-empty values
[2025-12-11 12:04:34] [INFO]   -> Found value: 2025003029
2025019210
[2025-12-11 12:04:34] [INFO]   -> Set field 'incidentInternalId' = "2025003029\n2025019210"
[2025-12-11 12:04:34] [INFO]   -> Set field 'dispatchRunNumber' = "2025003029\n2025019210"
[2025-12-11 12:04:34] [INFO] Mapping #3: Extracting 'EventDetails.NatureDescription' => 'incidentTypeValue1'
[2025-12-11 12:04:34] [INFO]   -> Found value: MANPOWER - EMS ASSIST
[2025-12-11 12:04:34] [INFO]   -> Set field 'incidentTypeValue1' = "MANPOWER - EMS ASSIST"
[2025-12-11 12:04:34] [INFO] Mapping #4: Extracting 'EventDetails.StreetNumber' => 'incidentLocationStreetNumber'
[2025-12-11 12:04:34] [INFO]   -> Found value: 2415
[2025-12-11 12:04:34] [INFO]   -> Set field 'incidentLocationStreetNumber' = 2415
[2025-12-11 12:04:34] [INFO] Mapping #5: Extracting 'RelatedNames.Name.StreetName' => 'streetName'
[2025-12-11 12:04:34] [INFO]   -> Found value: DIXON LN
[2025-12-11 12:04:34] [INFO]   -> Set field 'streetName' = "DIXON LN"
[2025-12-11 12:04:34] [INFO] Mapping #6: Extracting 'RelatedNames.Name.City' => 'incidentLocationCity'
[2025-12-11 12:04:34] [INFO]   -> Found value: COOKEVILLE
[2025-12-11 12:04:34] [INFO]   -> Set field 'incidentLocationCity' = "COOKEVILLE"
[2025-12-11 12:04:34] [INFO] Mapping #7: Extracting 'EventDetails.State' => 'incidentLocationStateName'
[2025-12-11 12:04:34] [INFO]   -> Found value: TN
[2025-12-11 12:04:34] [INFO]   -> Set field 'incidentLocationStateName' = "TN"
[2025-12-11 12:04:34] [INFO] Mapping #8: Extracting 'EventDetails.ZipCode' => 'nERISIncidentPostalCode'
[2025-12-11 12:04:34] [INFO]   -> Found value: 38501
[2025-12-11 12:04:34] [INFO]   -> Set field 'nERISIncidentPostalCode' = 38501
[2025-12-11 12:04:34] [INFO] Mapping #9: Extracting 'EventDetails.SiteName' => 'businessName'
[2025-12-11 12:04:34] [INFO]   -> No value found (null or empty)
[2025-12-11 12:04:34] [INFO] Mapping #10: Extracting 'EventDetails.ApartmentSuite' => 'incidentLocationApt'
[2025-12-11 12:04:34] [INFO]   -> No value found (null or empty)
[2025-12-11 12:04:34] [INFO] Mapping #11: Extracting 'EventDetails.EventLatitude' => 'nERISIncidentLatitude'
[2025-12-11 12:04:34] [INFO]   -> Found value: 36.19928
[2025-12-11 12:04:34] [INFO]   -> Set field 'nERISIncidentLatitude' = 36.19928
[2025-12-11 12:04:34] [INFO] Mapping #12: Extracting 'EventDetails.EventLongitude' => 'nERISIncidentLongitude'
[2025-12-11 12:04:34] [INFO]   -> Found value: -85.49360
[2025-12-11 12:04:34] [INFO]   -> Set field 'nERISIncidentLongitude' = -85.4936
[2025-12-11 12:04:34] [INFO] Mapping #13: Extracting 'EventDetails.EventStartTime' => 'alarm'
[2025-12-11 12:04:34] [INFO]   -> Found value: 2025-12-11 06:03:42
[2025-12-11 12:04:34] [INFO]   -> Set field 'alarm' = "2025-12-11 06:03:42"
[2025-12-11 12:04:34] [INFO] Mapping #14: Extracting 'EventDetails.FirstDispatchTime' => 'dispatched'
[2025-12-11 12:04:34] [INFO]   -> Found value: 2025-12-11 06:04:23
[2025-12-11 12:04:34] [INFO]   -> Set field 'dispatched' = "2025-12-11 06:04:23"
[2025-12-11 12:04:34] [INFO] Mapping #15: Extracting 'EventDetails.FirstEnrouteTime' => 'enroute'
[2025-12-11 12:04:34] [INFO]   -> No value found (null or empty)
[2025-12-11 12:04:34] [INFO] Mapping #16: Extracting 'EventDetails.FirstOnSceneTime' => 'onScene'
[2025-12-11 12:04:34] [INFO]   -> No value found (null or empty)
[2025-12-11 12:04:34] [INFO] Mapping #17: Extracting 'EventDetails.LastUnitClearTime' => ["cleared","inService"]
[2025-12-11 12:04:34] [INFO]   -> No value found (null or empty)
[2025-12-11 12:04:34] [INFO] Mapping #18: Extracting 'EventDetails.CrossStreets' => 'incidentLocationCross'
[2025-12-11 12:04:34] [INFO]   -> Found value: /DALE LN
[2025-12-11 12:04:34] [INFO]   -> Set field 'incidentLocationCross' = "\/DALE LN"
[2025-12-11 12:04:34] [INFO] Mapping #19: Extracting 'EventUnits.Unit[0].UnitCode' => 'cADVehicleID'
[2025-12-11 12:04:34] [INFO]   -> Found value: SQ11
[2025-12-11 12:04:34] [INFO]   -> Set field 'cADVehicleID' = "SQ11"
[2025-12-11 12:04:34] [INFO] Mapping #20: Extracting 'EventUnits.Unit[0].DispatchTime' => 'timedispatch'
[2025-12-11 12:04:34] [INFO]   -> Found value: 2025-12-11 06:04:23
[2025-12-11 12:04:34] [INFO]   -> Set field 'timedispatch' = "2025-12-11 06:04:23"
[2025-12-11 12:04:34] [INFO] Mapping #21: Extracting 'EventUnits.Unit[0].EnRouteTime' => 'timeenroutetoscene'
[2025-12-11 12:04:34] [INFO]   -> No value found (null or empty)
[2025-12-11 12:04:34] [INFO] Mapping #22: Extracting 'EventUnits.Unit[0].ArriveTime' => 'timeonscene'
[2025-12-11 12:04:34] [INFO]   -> No value found (null or empty)
[2025-12-11 12:04:34] [INFO] Mapping #23: Extracting 'EventUnits.Unit[0].ReturnToServiceTime' => 'timeunitclear'
[2025-12-11 12:04:34] [INFO]   -> No value found (null or empty)
[2025-12-11 12:04:34] [INFO] Mapping #24: Extracting 'EventUnits.Unit[0].CancelTime' => 'timecanceledenroute'
[2025-12-11 12:04:34] [INFO]   -> No value found (null or empty)
[2025-12-11 12:04:34] [INFO] Mapping #25: Extracting 'EventDetails.CadInciNumber' => 'policeReportNumber'
[2025-12-11 12:04:34] [INFO] Found 2 elements for 'CadInciNumber', concatenating 2 non-empty values
[2025-12-11 12:04:34] [INFO]   -> Found value: 20250135879
20250135877
[2025-12-11 12:04:34] [INFO]   -> Set field 'policeReportNumber' = "20250135879\n20250135877"
[2025-12-11 12:04:34] [INFO] Finished extracting fields. Total fields extracted: 17
[2025-12-11 12:04:34] [INFO] Built locationCoordinates from lat/lng: 36.19928,-85.4936
[2025-12-11 12:04:34] [INFO] Extracted parsing rules data: {"cADAgencyIdentifier":"PCFD\nEMS","incidentInternalId":"2025003029\n2025019210","dispatchRunNumber":"2025003029\n2025019210","incidentTypeValue1":"MANPOWER - EMS ASSIST","incidentLocationStreetNumber":2415,"streetName":"DIXON LN","incidentLocationCity":"COOKEVILLE","incidentLocationStateName":"TN","nERISIncidentPostalCode":38501,"nERISIncidentLatitude":36.19928,"nERISIncidentLongitude":-85.4936,"alarm":"2025-12-11 06:03:42","dispatched":"2025-12-11 06:04:23","incidentLocationCross":"\/DALE LN","cADVehicleID":"SQ11","timedispatch":"2025-12-11 06:04:23","policeReportNumber":"20250135879\n20250135877","locationCoordinates":"36.19928,-85.4936"}
[2025-12-11 12:04:34] [INFO] Number of extracted fields: 18
[2025-12-11 12:04:34] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'PCFD
EMS'
[2025-12-11 12:04:34] [INFO] Multi-agency routing check: CAD Agency ID = PCFD
EMS, Assigned Agencies count = 1
[2025-12-11 12:04:34] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'PCFD
EMS'
[2025-12-11 12:04:34] [WARNING] WARNING: No SAASClient found with cADAgencyIdentifier = 'PCFD
EMS'
[2025-12-11 12:04:34] [INFO] FALLBACK: Using mailbox default saasclientId: 68eeb686225c40db4 (multi-agency routing attempted but failed)
[2025-12-11 12:04:34] [INFO] Final routing: saasclientId = 68eeb686225c40db4, dispatchStationsIds = ["68ffbebde83509b7c","68ffd433577d1ee1e","68ffbe83793eb4521","68eef9302d19f85fc","68ffbe45d3567d442","68ffbe0e8c5fa650f","68eef77e6a5b1e9d6","68ffbde067a9b162c","68ffbda5d8ebd5468","68ffbd6b1db8d8daa","68ffbd4220b20a872","68ffbcfb8b8911e4e","68eef6ffc8105af4e","68eeca5d553dc8756"]
[2025-12-11 12:04:34] [INFO] Found existing IncidentTypeMapping with ID: 6938bcc5e565c9852
[2025-12-11 12:04:34] [INFO] Found existing Dispatch with cADNumber '2025003029
2025019210', ID: 693ab350178581811 - will update instead of create
[2025-12-11 12:04:34] [INFO] Updated existing Dispatches record with ID: 693ab350178581811
[2025-12-11 12:04:34] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135879_20251211_120432.XML
[2025-12-11 12:04:34] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250135879_20251211_120432.XML
[2025-12-11 14:05:18] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-29345.xml
[2025-12-11 14:05:18] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-29345.xml for user: 68d56363ec1209189
[2025-12-11 14:05:18] [INFO] File size: 1742 bytes
[2025-12-11 14:05:18] [INFO] Created FTPFiles record with ID: 693acf9e8bdd14d31
[2025-12-11 14:05:18] [INFO] About to extract fields from XML. File size: 1742 bytes
[2025-12-11 14:05:18] [INFO] Number of mappings: 21
[2025-12-11 14:05:18] [INFO] Starting XML parsing. Content length: 1742
[2025-12-11 14:05:18] [INFO] XML parsed successfully. Root element: Incident
[2025-12-11 14:05:18] [INFO] Processing 21 field mappings
[2025-12-11 14:05:18] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-12-11 14:05:18] [INFO]   -> Found value: 25-29345
[2025-12-11 14:05:18] [INFO]   -> Set field 'dispatchRunNumber' = "25-29345"
[2025-12-11 14:05:18] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-12-11 14:05:18] [INFO]   -> Found value: 1551
[2025-12-11 14:05:18] [INFO]   -> Set field 'incidentLocationStreetNumber' = 1551
[2025-12-11 14:05:18] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-12-11 14:05:18] [INFO]   -> Found value: W WAKEFIELD AVE
[2025-12-11 14:05:18] [INFO]   -> Set field 'streetName' = "W WAKEFIELD AVE"
[2025-12-11 14:05:18] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-12-11 14:05:18] [INFO]   -> No value found (null or empty)
[2025-12-11 14:05:18] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-12-11 14:05:18] [INFO]   -> Found value: SIKESTON
[2025-12-11 14:05:18] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-12-11 14:05:18] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-12-11 14:05:18] [INFO]   -> Found value: SIKESTON POWER PLANT
[2025-12-11 14:05:18] [INFO]   -> Set field 'businessName' = "SIKESTON POWER PLANT"
[2025-12-11 14:05:18] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-12-11 14:05:18] [INFO]   -> Found value: MO
[2025-12-11 14:05:18] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-12-11 14:05:18] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-12-11 14:05:18] [INFO]   -> Found value: 63801
[2025-12-11 14:05:18] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-12-11 14:05:18] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-12-11 14:05:18] [INFO]   -> Found value: 0
[2025-12-11 14:05:18] [INFO]   -> Set field 'nERISIncidentLatitude' = 0
[2025-12-11 14:05:18] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-12-11 14:05:18] [INFO]   -> Found value: 0
[2025-12-11 14:05:18] [INFO]   -> Set field 'nERISIncidentLongitude' = 0
[2025-12-11 14:05:18] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-12-11 14:05:18] [INFO]   -> Found value: FIRE-COAL TRAIN STANDBY
[2025-12-11 14:05:18] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-COAL TRAIN STANDBY"
[2025-12-11 14:05:18] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-12-11 14:05:18] [INFO]   -> Found value: 12-11-2025 07:35:22|ARRIVING FROM THE NORTH 12-11-2025 08:04:04|PAUL AT POWER STATION STATES COAL TR...
[2025-12-11 14:05:18] [INFO]   -> Set field 'dispatchNotes' = "12-11-2025 07:35:22|ARRIVING FROM THE NORTH 12-11-2025 08:04:04|PAUL AT POWER STATION STATES COAL TRAIN AT PLANT SITE AND ALL CROSSINGS ARE CLEAR"
[2025-12-11 14:05:18] [INFO]   -> Set field 'cADLog' = "12-11-2025 07:35:22|ARRIVING FROM THE NORTH 12-11-2025 08:04:04|PAUL AT POWER STATION STATES COAL TRAIN AT PLANT SITE AND ALL CROSSINGS ARE CLEAR"
[2025-12-11 14:05:18] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-12-11 14:05:18] [INFO]   -> Found value: 12-11-2025T07:36:39
[2025-12-11 14:05:18] [INFO] Reformatted DD-MM-YYYY date '12-11-2025' (day=12, month=11) to ISO: 2025-11-12T07:36:39
[2025-12-11 14:05:18] [INFO]   -> Set field 'alarm' = "2025-11-12 07:36:39"
[2025-12-11 14:05:18] [INFO] Reformatted DD-MM-YYYY date '12-11-2025' (day=12, month=11) to ISO: 2025-11-12T07:36:39
[2025-12-11 14:05:18] [INFO]   -> Set field 'dispatched' = "2025-11-12 07:36:39"
[2025-12-11 14:05:18] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-12-11 14:05:18] [INFO]   -> Found value: 12-11-2025T07:40:36
[2025-12-11 14:05:18] [INFO] Reformatted DD-MM-YYYY date '12-11-2025' (day=12, month=11) to ISO: 2025-11-12T07:40:36
[2025-12-11 14:05:18] [INFO]   -> Set field 'onScene' = "2025-11-12 07:40:36"
[2025-12-11 14:05:18] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-12-11 14:05:18] [INFO]   -> Found value: 12-11-2025T08:05:01
[2025-12-11 14:05:18] [INFO] Reformatted DD-MM-YYYY date '12-11-2025' (day=12, month=11) to ISO: 2025-11-12T08:05:01
[2025-12-11 14:05:18] [INFO]   -> Set field 'cleared' = "2025-11-12 08:05:01"
[2025-12-11 14:05:18] [INFO] Reformatted DD-MM-YYYY date '12-11-2025' (day=12, month=11) to ISO: 2025-11-12T08:05:01
[2025-12-11 14:05:18] [INFO]   -> Set field 'inService' = "2025-11-12 08:05:01"
[2025-12-11 14:05:18] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-12-11 14:05:18] [INFO]   -> Found value: SIK STILL
[2025-12-11 14:05:18] [INFO]   -> Set field 'cADVehicleID' = "SIK STILL"
[2025-12-11 14:05:18] [INFO]   -> Set field 'name' = "SIK STILL"
[2025-12-11 14:05:18] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-12-11 14:05:18] [INFO]   -> No value found (null or empty)
[2025-12-11 14:05:18] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-12-11 14:05:18] [INFO]   -> No value found (null or empty)
[2025-12-11 14:05:18] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-12-11 14:05:18] [INFO]   -> Found value: 12-11-2025T08:05:01
[2025-12-11 14:05:18] [INFO] Reformatted DD-MM-YYYY date '12-11-2025' (day=12, month=11) to ISO: 2025-11-12T08:05:01
[2025-12-11 14:05:18] [INFO]   -> Set field 'timeunitclear' = "2025-11-12 08:05:01"
[2025-12-11 14:05:18] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-12-11 14:05:18] [INFO]   -> Found value: 12-11-2025T07:36:39
[2025-12-11 14:05:18] [INFO] Reformatted DD-MM-YYYY date '12-11-2025' (day=12, month=11) to ISO: 2025-11-12T07:36:39
[2025-12-11 14:05:18] [INFO]   -> Set field 'timedispatch' = "2025-11-12 07:36:39"
[2025-12-11 14:05:18] [INFO] Mapping #21: Extracting 'Agency' => 'cADAgencyIdentifier'
[2025-12-11 14:05:18] [INFO]   -> Found value: SDPSFD
[2025-12-11 14:05:18] [INFO]   -> Set field 'cADAgencyIdentifier' = "SDPSFD"
[2025-12-11 14:05:18] [INFO] Finished extracting fields. Total fields extracted: 22
[2025-12-11 14:05:18] [INFO] Built locationCoordinates from lat/lng: 0,0
[2025-12-11 14:05:18] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-29345","incidentLocationStreetNumber":1551,"streetName":"W WAKEFIELD AVE","incidentLocationCity":"SIKESTON","businessName":"SIKESTON POWER PLANT","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":0,"nERISIncidentLongitude":0,"incidentTypeValue1":"FIRE-COAL TRAIN STANDBY","dispatchNotes":"12-11-2025 07:35:22|ARRIVING FROM THE NORTH 12-11-2025 08:04:04|PAUL AT POWER STATION STATES COAL TRAIN AT PLANT SITE AND ALL CROSSINGS ARE CLEAR","cADLog":"12-11-2025 07:35:22|ARRIVING FROM THE NORTH 12-11-2025 08:04:04|PAUL AT POWER STATION STATES COAL TRAIN AT PLANT SITE AND ALL CROSSINGS ARE CLEAR","alarm":"2025-11-12 07:36:39","dispatched":"2025-11-12 07:36:39","onScene":"2025-11-12 07:40:36","cleared":"2025-11-12 08:05:01","inService":"2025-11-12 08:05:01","cADVehicleID":"SIK STILL","name":"SIK STILL","timeunitclear":"2025-11-12 08:05:01","timedispatch":"2025-11-12 07:36:39","cADAgencyIdentifier":"SDPSFD","locationCoordinates":"0,0"}
[2025-12-11 14:05:18] [INFO] Number of extracted fields: 23
[2025-12-11 14:05:18] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'SDPSFD'
[2025-12-11 14:05:18] [INFO] Multi-agency routing check: CAD Agency ID = SDPSFD, Assigned Agencies count = 2
[2025-12-11 14:05:18] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'SDPSFD'
[2025-12-11 14:05:18] [INFO] Found SAASClient match: ID = 6772cab7157b2ebde, Name = Sikeston DPS
[2025-12-11 14:05:18] [INFO] SUCCESS: Routed to agency 'Sikeston DPS' (ID: 6772cab7157b2ebde) based on CAD ID: 'SDPSFD'
[2025-12-11 14:05:18] [INFO] Fetched 4 stations from Stations module for agency 'Sikeston DPS': ["67d843b7d3670caf0","67d843823ed523b5c","67d8434fe3dc432c7","68d5ab6eaa6dc3961"]
[2025-12-11 14:05:18] [INFO] Final routing: saasclientId = 6772cab7157b2ebde, dispatchStationsIds = ["67d843b7d3670caf0","67d843823ed523b5c","67d8434fe3dc432c7","68d5ab6eaa6dc3961"]
[2025-12-11 14:05:18] [INFO] Updated FTPFiles record saasclientId to routed agency: 6772cab7157b2ebde
[2025-12-11 14:05:18] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e8608a02f9
[2025-12-11 14:05:19] [INFO] Created new Dispatches record with ID: 693acf9eebcee0fdd
[2025-12-11 14:05:19] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-29345.xml
[2025-12-11 14:05:19] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-29345.xml
[2025-12-11 16:55:16] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-29373.xml
[2025-12-11 16:55:16] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-29373.xml for user: 68d56363ec1209189
[2025-12-11 16:55:16] [INFO] File size: 1269 bytes
[2025-12-11 16:55:16] [INFO] Created FTPFiles record with ID: 693af7748b431567b
[2025-12-11 16:55:16] [INFO] About to extract fields from XML. File size: 1269 bytes
[2025-12-11 16:55:16] [INFO] Number of mappings: 21
[2025-12-11 16:55:16] [INFO] Starting XML parsing. Content length: 1269
[2025-12-11 16:55:16] [INFO] XML parsed successfully. Root element: Incident
[2025-12-11 16:55:16] [INFO] Processing 21 field mappings
[2025-12-11 16:55:16] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-12-11 16:55:16] [INFO]   -> Found value: 25-29373
[2025-12-11 16:55:16] [INFO]   -> Set field 'dispatchRunNumber' = "25-29373"
[2025-12-11 16:55:16] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-12-11 16:55:16] [INFO]   -> Found value: 115
[2025-12-11 16:55:16] [INFO]   -> Set field 'incidentLocationStreetNumber' = 115
[2025-12-11 16:55:16] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-12-11 16:55:16] [INFO]   -> Found value: S WEST ST
[2025-12-11 16:55:16] [INFO]   -> Set field 'streetName' = "S WEST ST"
[2025-12-11 16:55:16] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-12-11 16:55:16] [INFO]   -> No value found (null or empty)
[2025-12-11 16:55:16] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-12-11 16:55:16] [INFO]   -> Found value: SIKESTON
[2025-12-11 16:55:16] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-12-11 16:55:16] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-12-11 16:55:16] [INFO]   -> Found value: DAEOC HEAD START
[2025-12-11 16:55:16] [INFO]   -> Set field 'businessName' = "DAEOC HEAD START"
[2025-12-11 16:55:16] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-12-11 16:55:16] [INFO]   -> Found value: MO
[2025-12-11 16:55:16] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-12-11 16:55:16] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-12-11 16:55:16] [INFO]   -> Found value: 63801
[2025-12-11 16:55:16] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-12-11 16:55:16] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-12-11 16:55:16] [INFO]   -> Found value: 0
[2025-12-11 16:55:16] [INFO]   -> Set field 'nERISIncidentLatitude' = 0
[2025-12-11 16:55:16] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-12-11 16:55:16] [INFO]   -> Found value: 0
[2025-12-11 16:55:16] [INFO]   -> Set field 'nERISIncidentLongitude' = 0
[2025-12-11 16:55:16] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-12-11 16:55:16] [INFO]   -> Found value: PR EVENT
[2025-12-11 16:55:16] [INFO]   -> Set field 'incidentTypeValue1' = "PR EVENT"
[2025-12-11 16:55:16] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-12-11 16:55:16] [INFO]   -> No value found (null or empty)
[2025-12-11 16:55:16] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-12-11 16:55:16] [INFO]   -> No value found (null or empty)
[2025-12-11 16:55:16] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-12-11 16:55:16] [INFO]   -> Found value: 12-11-2025T09:58:56
[2025-12-11 16:55:16] [INFO] Reformatted DD-MM-YYYY date '12-11-2025' (day=12, month=11) to ISO: 2025-11-12T09:58:56
[2025-12-11 16:55:16] [INFO]   -> Set field 'onScene' = "2025-11-12 09:58:56"
[2025-12-11 16:55:16] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-12-11 16:55:16] [INFO]   -> Found value: 12-11-2025T10:54:06
[2025-12-11 16:55:16] [INFO] Reformatted DD-MM-YYYY date '12-11-2025' (day=12, month=11) to ISO: 2025-11-12T10:54:06
[2025-12-11 16:55:16] [INFO]   -> Set field 'cleared' = "2025-11-12 10:54:06"
[2025-12-11 16:55:16] [INFO] Reformatted DD-MM-YYYY date '12-11-2025' (day=12, month=11) to ISO: 2025-11-12T10:54:06
[2025-12-11 16:55:16] [INFO]   -> Set field 'inService' = "2025-11-12 10:54:06"
[2025-12-11 16:55:16] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-12-11 16:55:16] [INFO]   -> Found value: ENG2
[2025-12-11 16:55:16] [INFO]   -> Set field 'cADVehicleID' = "ENG2"
[2025-12-11 16:55:16] [INFO]   -> Set field 'name' = "ENG2"
[2025-12-11 16:55:16] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-12-11 16:55:16] [INFO]   -> No value found (null or empty)
[2025-12-11 16:55:16] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-12-11 16:55:16] [INFO]   -> No value found (null or empty)
[2025-12-11 16:55:16] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-12-11 16:55:16] [INFO]   -> Found value: 12-11-2025T10:54:06
[2025-12-11 16:55:16] [INFO] Reformatted DD-MM-YYYY date '12-11-2025' (day=12, month=11) to ISO: 2025-11-12T10:54:06
[2025-12-11 16:55:16] [INFO]   -> Set field 'timeunitclear' = "2025-11-12 10:54:06"
[2025-12-11 16:55:16] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-12-11 16:55:16] [INFO]   -> No value found (null or empty)
[2025-12-11 16:55:16] [INFO] Mapping #21: Extracting 'Agency' => 'cADAgencyIdentifier'
[2025-12-11 16:55:16] [INFO]   -> Found value: SDPSFD
[2025-12-11 16:55:16] [INFO]   -> Set field 'cADAgencyIdentifier' = "SDPSFD"
[2025-12-11 16:55:16] [INFO] Finished extracting fields. Total fields extracted: 17
[2025-12-11 16:55:16] [INFO] Built locationCoordinates from lat/lng: 0,0
[2025-12-11 16:55:16] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-29373","incidentLocationStreetNumber":115,"streetName":"S WEST ST","incidentLocationCity":"SIKESTON","businessName":"DAEOC HEAD START","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":0,"nERISIncidentLongitude":0,"incidentTypeValue1":"PR EVENT","onScene":"2025-11-12 09:58:56","cleared":"2025-11-12 10:54:06","inService":"2025-11-12 10:54:06","cADVehicleID":"ENG2","name":"ENG2","timeunitclear":"2025-11-12 10:54:06","cADAgencyIdentifier":"SDPSFD","locationCoordinates":"0,0"}
[2025-12-11 16:55:16] [INFO] Number of extracted fields: 18
[2025-12-11 16:55:16] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'SDPSFD'
[2025-12-11 16:55:16] [INFO] Multi-agency routing check: CAD Agency ID = SDPSFD, Assigned Agencies count = 2
[2025-12-11 16:55:16] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'SDPSFD'
[2025-12-11 16:55:16] [INFO] Found SAASClient match: ID = 6772cab7157b2ebde, Name = Sikeston DPS
[2025-12-11 16:55:16] [INFO] SUCCESS: Routed to agency 'Sikeston DPS' (ID: 6772cab7157b2ebde) based on CAD ID: 'SDPSFD'
[2025-12-11 16:55:16] [INFO] Fetched 4 stations from Stations module for agency 'Sikeston DPS': ["67d843b7d3670caf0","67d843823ed523b5c","67d8434fe3dc432c7","68d5ab6eaa6dc3961"]
[2025-12-11 16:55:16] [INFO] Final routing: saasclientId = 6772cab7157b2ebde, dispatchStationsIds = ["67d843b7d3670caf0","67d843823ed523b5c","67d8434fe3dc432c7","68d5ab6eaa6dc3961"]
[2025-12-11 16:55:16] [INFO] Updated FTPFiles record saasclientId to routed agency: 6772cab7157b2ebde
[2025-12-11 16:55:16] [INFO] Found existing IncidentTypeMapping with ID: 68eea49c2e55f1cc1
[2025-12-11 16:55:18] [INFO] Created new Dispatches record with ID: 693af7750312482ef
[2025-12-11 16:55:18] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-29373.xml
[2025-12-11 16:55:18] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-29373.xml
[2025-12-11 17:40:27] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/669818124da81f9ac/ne_tfile.xml
[2025-12-11 17:40:27] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/669818124da81f9ac/ne_tfile.xml for user: 669818124da81f9ac
[2025-12-11 17:40:27] [INFO] File size: 26725 bytes
[2025-12-11 17:40:28] [INFO] Created FTPFiles record with ID: 693b020c1a5984475
[2025-12-11 17:40:28] [INFO] About to extract fields from XML. File size: 26725 bytes
[2025-12-11 17:40:28] [INFO] Number of mappings: 9
[2025-12-11 17:40:28] [INFO] Starting XML parsing. Content length: 26725
[2025-12-11 17:40:28] [INFO] XML parsed successfully. Root element: CFSRecord
[2025-12-11 17:40:28] [INFO] Processing 9 field mappings
[2025-12-11 17:40:28] [INFO] Mapping #1: Extracting 'Units.Unit[0].radio_name' => 'cADVehicleID'
[2025-12-11 17:40:28] [INFO]   -> No value found (null or empty)
[2025-12-11 17:40:28] [INFO] Mapping #2: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-12-11 17:40:28] [INFO]   -> No value found (null or empty)
[2025-12-11 17:40:28] [INFO] Mapping #3: Extracting 'time_last_unit_cleared' => 'cleared'
[2025-12-11 17:40:28] [INFO]   -> No value found (null or empty)
[2025-12-11 17:40:28] [INFO] Mapping #4: Extracting 'time_first_unit_enroute' => 'enroute'
[2025-12-11 17:40:28] [INFO]   -> No value found (null or empty)
[2025-12-11 17:40:28] [INFO] Mapping #5: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-12-11 17:40:28] [INFO]   -> No value found (null or empty)
[2025-12-11 17:40:28] [INFO] Mapping #6: Extracting 'time_first_unit_arrived' => 'timeonscene'
[2025-12-11 17:40:28] [INFO]   -> No value found (null or empty)
[2025-12-11 17:40:28] [INFO] Mapping #7: Extracting 'commentlist.comment' => 'cADLog'
[2025-12-11 17:40:28] [INFO]   -> No value found (null or empty)
[2025-12-11 17:40:28] [INFO] Mapping #8: Extracting 'Agency' => 'cADAgencyIdentifier'
[2025-12-11 17:40:28] [INFO] Found 7 elements for 'Agency', concatenating 7 non-empty values
[2025-12-11 17:40:28] [INFO]   -> Found value: 5
          TFD
          Tullahoma Fire Department
          
          
          CCECD
          ...
[2025-12-11 17:40:28] [INFO]   -> Set field 'cADAgencyIdentifier' = "5\n          TFD\n          Tullahoma Fire Department\n          \n          \n          CCECD\n          FIRE\n11\n          MAS\n          Manchester Ambulance Service \n          \n          \n          CCECD\n          EMS\n15\n          TAN\n          Tullahoma Ambulance Service North\n          \n          \n          CCECD\n          EMS\n5\n          TFD\n          Tullahoma Fire Department\n          \n          \n          CCECD\n          FIRE\n3\n          TPD\n          Tullahoma Police Department\n          \n          \n          CCECD\n          LAW\n3\n          TPD\n          Tullahoma Police Department\n          \n          \n          CCECD\n          LAW\n3\n          TPD\n          Tullahoma Police Department\n          \n          \n          CCECD\n          LAW"
[2025-12-11 17:40:28] [INFO] Mapping #9: Extracting 'CFSData.DispatchAgency.ORI' => 'cADNumber'
[2025-12-11 17:40:28] [INFO]   -> Found value: TN0160000
[2025-12-11 17:40:28] [INFO]   -> Set field 'cADNumber' = "TN0160000"
[2025-12-11 17:40:28] [INFO] Finished extracting fields. Total fields extracted: 2
[2025-12-11 17:40:28] [INFO] Extracted parsing rules data: {"cADAgencyIdentifier":"5\n          TFD\n          Tullahoma Fire Department\n          \n          \n          CCECD\n          FIRE\n11\n          MAS\n          Manchester Ambulance Service \n          \n          \n          CCECD\n          EMS\n15\n          TAN\n          Tullahoma Ambulance Service North\n          \n          \n          CCECD\n          EMS\n5\n          TFD\n          Tullahoma Fire Department\n          \n          \n          CCECD\n          FIRE\n3\n          TPD\n          Tullahoma Police Department\n          \n          \n          CCECD\n          LAW\n3\n          TPD\n          Tullahoma Police Department\n          \n          \n          CCECD\n          LAW\n3\n          TPD\n          Tullahoma Police Department\n          \n          \n          CCECD\n          LAW","cADNumber":"TN0160000"}
[2025-12-11 17:40:28] [INFO] Number of extracted fields: 2
[2025-12-11 17:40:28] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = '5
          TFD
          Tullahoma Fire Department
          
          
          CCECD
          FIRE
11
          MAS
          Manchester Ambulance Service 
          
          
          CCECD
          EMS
15
          TAN
          Tullahoma Ambulance Service North
          
          
          CCECD
          EMS
5
          TFD
          Tullahoma Fire Department
          
          
          CCECD
          FIRE
3
          TPD
          Tullahoma Police Department
          
          
          CCECD
          LAW
3
          TPD
          Tullahoma Police Department
          
          
          CCECD
          LAW
3
          TPD
          Tullahoma Police Department
          
          
          CCECD
          LAW'
[2025-12-11 17:40:28] [INFO] Multi-agency routing check: CAD Agency ID = 5
          TFD
          Tullahoma Fire Department
          
          
          CCECD
          FIRE
11
          MAS
          Manchester Ambulance Service 
          
          
          CCECD
          EMS
15
          TAN
          Tullahoma Ambulance Service North
          
          
          CCECD
          EMS
5
          TFD
          Tullahoma Fire Department
          
          
          CCECD
          FIRE
3
          TPD
          Tullahoma Police Department
          
          
          CCECD
          LAW
3
          TPD
          Tullahoma Police Department
          
          
          CCECD
          LAW
3
          TPD
          Tullahoma Police Department
          
          
          CCECD
          LAW, Assigned Agencies count = 1
[2025-12-11 17:40:28] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: '5
          TFD
          Tullahoma Fire Department
          
          
          CCECD
          FIRE
11
          MAS
          Manchester Ambulance Service 
          
          
          CCECD
          EMS
15
          TAN
          Tullahoma Ambulance Service North
          
          
          CCECD
          EMS
5
          TFD
          Tullahoma Fire Department
          
          
          CCECD
          FIRE
3
          TPD
          Tullahoma Police Department
          
          
          CCECD
          LAW
3
          TPD
          Tullahoma Police Department
          
          
          CCECD
          LAW
3
          TPD
          Tullahoma Police Department
          
          
          CCECD
          LAW'
[2025-12-11 17:40:28] [WARNING] WARNING: No SAASClient found with cADAgencyIdentifier = '5
          TFD
          Tullahoma Fire Department
          
          
          CCECD
          FIRE
11
          MAS
          Manchester Ambulance Service 
          
          
          CCECD
          EMS
15
          TAN
          Tullahoma Ambulance Service North
          
          
          CCECD
          EMS
5
          TFD
          Tullahoma Fire Department
          
          
          CCECD
          FIRE
3
          TPD
          Tullahoma Police Department
          
          
          CCECD
          LAW
3
          TPD
          Tullahoma Police Department
          
          
          CCECD
          LAW
3
          TPD
          Tullahoma Police Department
          
          
          CCECD
          LAW'
[2025-12-11 17:40:28] [INFO] FALLBACK: Using mailbox default saasclientId: 65399b81e3f752061 (multi-agency routing attempted but failed)
[2025-12-11 17:40:28] [INFO] Final routing: saasclientId = 65399b81e3f752061, dispatchStationsIds = ["653a9637b6207362b","653a963385b05ea6b","64cbfa522ae918d99","653a70b6b581557d4","68af6151e2bb9ee0f","68b0a2100a67da7fd","68b0c4c62f5f15f04"]
[2025-12-11 17:40:28] [ERROR] PHP Error [WARNING]: Undefined array key "incidentTypeValue1" in /home/dodom2/public_html/ftp.stationboss.net/ftp_process_upload.php on line 609
[2025-12-11 17:40:29] [INFO] Created new Dispatches record with ID: 693b020c5082a5b46
[2025-12-11 17:40:29] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/669818124da81f9ac/ne_tfile.xml
[2025-12-11 17:40:29] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/669818124da81f9ac/ne_tfile.xml
[2025-12-11 17:45:58] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/669818124da81f9ac/ne_tfile.xml
[2025-12-11 17:45:58] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/669818124da81f9ac/ne_tfile.xml for user: 669818124da81f9ac
[2025-12-11 17:45:58] [INFO] File size: 26725 bytes
[2025-12-11 17:45:58] [INFO] Created FTPFiles record with ID: 693b0356e835d71a2
[2025-12-11 17:45:58] [INFO] About to extract fields from XML. File size: 26725 bytes
[2025-12-11 17:45:58] [INFO] Number of mappings: 8
[2025-12-11 17:45:58] [INFO] Starting XML parsing. Content length: 26725
[2025-12-11 17:45:58] [INFO] XML parsed successfully. Root element: CFSRecord
[2025-12-11 17:45:58] [INFO] Processing 8 field mappings
[2025-12-11 17:45:58] [INFO] Mapping #1: Extracting 'Units.Unit[0].radio_name' => 'cADVehicleID'
[2025-12-11 17:45:58] [INFO]   -> No value found (null or empty)
[2025-12-11 17:45:58] [INFO] Mapping #2: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-12-11 17:45:58] [INFO]   -> No value found (null or empty)
[2025-12-11 17:45:58] [INFO] Mapping #3: Extracting 'time_last_unit_cleared' => 'cleared'
[2025-12-11 17:45:58] [INFO]   -> No value found (null or empty)
[2025-12-11 17:45:58] [INFO] Mapping #4: Extracting 'time_first_unit_enroute' => 'enroute'
[2025-12-11 17:45:58] [INFO]   -> No value found (null or empty)
[2025-12-11 17:45:58] [INFO] Mapping #5: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-12-11 17:45:58] [INFO]   -> No value found (null or empty)
[2025-12-11 17:45:58] [INFO] Mapping #6: Extracting 'time_first_unit_arrived' => 'timeonscene'
[2025-12-11 17:45:58] [INFO]   -> No value found (null or empty)
[2025-12-11 17:45:58] [INFO] Mapping #7: Extracting 'commentlist.comment' => 'cADLog'
[2025-12-11 17:45:58] [INFO]   -> No value found (null or empty)
[2025-12-11 17:45:58] [INFO] Mapping #8: Extracting 'CFSData.DispatchAgency.ORI' => 'cADNumber'
[2025-12-11 17:45:58] [INFO]   -> Found value: TN0160000
[2025-12-11 17:45:58] [INFO]   -> Set field 'cADNumber' = "TN0160000"
[2025-12-11 17:45:58] [INFO] Finished extracting fields. Total fields extracted: 1
[2025-12-11 17:45:58] [INFO] Extracted parsing rules data: {"cADNumber":"TN0160000"}
[2025-12-11 17:45:58] [INFO] Number of extracted fields: 1
[2025-12-11 17:45:58] [INFO] MULTI-AGENCY: No cADAgencyIdentifier found in extracted data
[2025-12-11 17:45:58] [INFO] Multi-agency routing check: CAD Agency ID = NULL, Assigned Agencies count = 1
[2025-12-11 17:45:58] [WARNING] WARNING: Multi-agency mailbox (1 agencies) received dispatch WITHOUT cADAgencyIdentifier. This dispatch will use mailbox default agency. Check XML field mapping for cADAgencyIdentifier.
[2025-12-11 17:45:58] [INFO] Single-agency mode: Using mailbox saasclientId: 65399b81e3f752061
[2025-12-11 17:45:58] [INFO] Final routing: saasclientId = 65399b81e3f752061, dispatchStationsIds = ["653a9637b6207362b","653a963385b05ea6b","64cbfa522ae918d99","653a70b6b581557d4","68af6151e2bb9ee0f","68b0a2100a67da7fd","68b0c4c62f5f15f04"]
[2025-12-11 17:45:58] [ERROR] PHP Error [WARNING]: Undefined array key "incidentTypeValue1" in /home/dodom2/public_html/ftp.stationboss.net/ftp_process_upload.php on line 609
[2025-12-11 17:45:59] [INFO] Found existing Dispatch with cADNumber 'TN0160000', ID: 693b020c5082a5b46 - will update instead of create
[2025-12-11 17:45:59] [INFO] Updated existing Dispatches record with ID: 693b020c5082a5b46
[2025-12-11 17:45:59] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/669818124da81f9ac/ne_tfile.xml
[2025-12-11 17:45:59] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/669818124da81f9ac/ne_tfile.xml
[2025-12-11 20:21:40] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086016.xml
[2025-12-11 20:21:40] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086016.xml for user: 69320e6a9e3e5ef71
[2025-12-11 20:21:40] [INFO] File size: 9047 bytes
[2025-12-11 20:21:40] [INFO] Created FTPFiles record with ID: 693b27d4562975af8
[2025-12-11 20:21:40] [WARNING] Warning: Failed to decode parsing rules JSON for mailbox ID: 69320e6a9e3e5ef71
[2025-12-11 20:21:40] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086016.xml
[2025-12-11 20:21:40] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086016.xml
[2025-12-11 20:21:41] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086017.xml
[2025-12-11 20:21:41] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086017.xml for user: 69320e6a9e3e5ef71
[2025-12-11 20:21:41] [INFO] File size: 10833 bytes
[2025-12-11 20:21:41] [INFO] Created FTPFiles record with ID: 693b27d5da920b595
[2025-12-11 20:21:41] [WARNING] Warning: Failed to decode parsing rules JSON for mailbox ID: 69320e6a9e3e5ef71
[2025-12-11 20:21:41] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086017.xml
[2025-12-11 20:21:41] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086017.xml
[2025-12-11 20:23:15] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086016.xml
[2025-12-11 20:23:15] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086016.xml for user: 69320e6a9e3e5ef71
[2025-12-11 20:23:15] [INFO] File size: 10003 bytes
[2025-12-11 20:23:15] [INFO] Created FTPFiles record with ID: 693b28334e397d64e
[2025-12-11 20:23:15] [WARNING] Warning: Failed to decode parsing rules JSON for mailbox ID: 69320e6a9e3e5ef71
[2025-12-11 20:23:15] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086016.xml
[2025-12-11 20:23:15] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086016.xml
[2025-12-11 20:23:21] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086016.xml
[2025-12-11 20:23:21] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086016.xml for user: 69320e6a9e3e5ef71
[2025-12-11 20:23:21] [INFO] File size: 11839 bytes
[2025-12-11 20:23:21] [INFO] Created FTPFiles record with ID: 693b2839644bc1111
[2025-12-11 20:23:21] [WARNING] Warning: Failed to decode parsing rules JSON for mailbox ID: 69320e6a9e3e5ef71
[2025-12-11 20:23:21] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086016.xml
[2025-12-11 20:23:21] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086016.xml
[2025-12-11 20:25:34] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086001.xml
[2025-12-11 20:25:34] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086001.xml for user: 69320e6a9e3e5ef71
[2025-12-11 20:25:34] [INFO] File size: 33127 bytes
[2025-12-11 20:25:34] [INFO] Created FTPFiles record with ID: 693b28beb438c007f
[2025-12-11 20:25:34] [WARNING] Warning: Failed to decode parsing rules JSON for mailbox ID: 69320e6a9e3e5ef71
[2025-12-11 20:25:34] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086001.xml
[2025-12-11 20:25:34] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086001.xml
[2025-12-11 20:26:29] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:26:29] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml for user: 69320e6a9e3e5ef71
[2025-12-11 20:26:29] [INFO] File size: 3640 bytes
[2025-12-11 20:26:29] [INFO] Created FTPFiles record with ID: 693b28f5d91229643
[2025-12-11 20:26:29] [WARNING] Warning: Failed to decode parsing rules JSON for mailbox ID: 69320e6a9e3e5ef71
[2025-12-11 20:26:29] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:26:29] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:26:49] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:26:49] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml for user: 69320e6a9e3e5ef71
[2025-12-11 20:26:49] [INFO] File size: 4870 bytes
[2025-12-11 20:26:50] [INFO] Created FTPFiles record with ID: 693b290a1ef8fc04e
[2025-12-11 20:26:50] [WARNING] Warning: Failed to decode parsing rules JSON for mailbox ID: 69320e6a9e3e5ef71
[2025-12-11 20:26:50] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:26:50] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:26:58] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:26:58] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml for user: 69320e6a9e3e5ef71
[2025-12-11 20:26:58] [INFO] File size: 5819 bytes
[2025-12-11 20:26:58] [INFO] Created FTPFiles record with ID: 693b2912e7268c9d8
[2025-12-11 20:26:58] [WARNING] Warning: Failed to decode parsing rules JSON for mailbox ID: 69320e6a9e3e5ef71
[2025-12-11 20:26:58] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:26:58] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:27:18] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:27:18] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml for user: 69320e6a9e3e5ef71
[2025-12-11 20:27:18] [INFO] File size: 6369 bytes
[2025-12-11 20:27:18] [INFO] Created FTPFiles record with ID: 693b2926ee5bf8ea4
[2025-12-11 20:27:18] [WARNING] Warning: Failed to decode parsing rules JSON for mailbox ID: 69320e6a9e3e5ef71
[2025-12-11 20:27:18] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:27:18] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:27:57] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086015.xml
[2025-12-11 20:27:57] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086015.xml for user: 69320e6a9e3e5ef71
[2025-12-11 20:27:57] [INFO] File size: 15171 bytes
[2025-12-11 20:27:57] [INFO] Created FTPFiles record with ID: 693b294d546148301
[2025-12-11 20:27:57] [WARNING] Warning: Failed to decode parsing rules JSON for mailbox ID: 69320e6a9e3e5ef71
[2025-12-11 20:27:57] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086015.xml
[2025-12-11 20:27:57] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086015.xml
[2025-12-11 20:28:44] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:28:44] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml for user: 69320e6a9e3e5ef71
[2025-12-11 20:28:44] [INFO] File size: 7331 bytes
[2025-12-11 20:28:44] [INFO] Created FTPFiles record with ID: 693b297ced970158d
[2025-12-11 20:28:44] [WARNING] Warning: Failed to decode parsing rules JSON for mailbox ID: 69320e6a9e3e5ef71
[2025-12-11 20:28:44] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:28:44] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:29:06] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:29:06] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml for user: 69320e6a9e3e5ef71
[2025-12-11 20:29:06] [INFO] File size: 8368 bytes
[2025-12-11 20:29:06] [INFO] Created FTPFiles record with ID: 693b29924d1008041
[2025-12-11 20:29:06] [WARNING] Warning: Failed to decode parsing rules JSON for mailbox ID: 69320e6a9e3e5ef71
[2025-12-11 20:29:06] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:29:06] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:29:19] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086012.xml
[2025-12-11 20:29:19] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086012.xml for user: 69320e6a9e3e5ef71
[2025-12-11 20:29:19] [INFO] File size: 13074 bytes
[2025-12-11 20:29:19] [INFO] Created FTPFiles record with ID: 693b299f30b1884ea
[2025-12-11 20:29:19] [WARNING] Warning: Failed to decode parsing rules JSON for mailbox ID: 69320e6a9e3e5ef71
[2025-12-11 20:29:19] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086012.xml
[2025-12-11 20:29:19] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086012.xml
[2025-12-11 20:29:21] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086012.xml
[2025-12-11 20:29:21] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086012.xml for user: 69320e6a9e3e5ef71
[2025-12-11 20:29:21] [INFO] File size: 14028 bytes
[2025-12-11 20:29:21] [INFO] Created FTPFiles record with ID: 693b29a15827fa7bc
[2025-12-11 20:29:21] [WARNING] Warning: Failed to decode parsing rules JSON for mailbox ID: 69320e6a9e3e5ef71
[2025-12-11 20:29:21] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086012.xml
[2025-12-11 20:29:21] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086012.xml
[2025-12-11 20:29:25] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:29:25] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml for user: 69320e6a9e3e5ef71
[2025-12-11 20:29:25] [INFO] File size: 9611 bytes
[2025-12-11 20:29:25] [INFO] Created FTPFiles record with ID: 693b29a5702cca588
[2025-12-11 20:29:25] [WARNING] Warning: Failed to decode parsing rules JSON for mailbox ID: 69320e6a9e3e5ef71
[2025-12-11 20:29:25] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:29:25] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:29:25] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:29:25] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml for user: 69320e6a9e3e5ef71
[2025-12-11 20:29:25] [INFO] File size: 9611 bytes
[2025-12-11 20:29:25] [INFO] Created FTPFiles record with ID: 693b29a5981b63f72
[2025-12-11 20:29:25] [WARNING] Warning: Failed to decode parsing rules JSON for mailbox ID: 69320e6a9e3e5ef71
[2025-12-11 20:29:25] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 20:29:25] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/69320e6a9e3e5ef71/cfs_2025-086018.xml
[2025-12-11 21:19:11] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136101_20251211_211911.XML
[2025-12-11 21:19:11] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136101_20251211_211911.XML for user: 68f1466aed072ad4a
[2025-12-11 21:19:11] [INFO] File size: 5449 bytes
[2025-12-11 21:19:11] [INFO] Created FTPFiles record with ID: 693b354f3e5d55099
[2025-12-11 21:19:11] [INFO] About to extract fields from XML. File size: 5449 bytes
[2025-12-11 21:19:11] [INFO] Number of mappings: 25
[2025-12-11 21:19:11] [INFO] Starting XML parsing. Content length: 5449
[2025-12-11 21:19:11] [INFO] XML parsed successfully. Root element: CADExport
[2025-12-11 21:19:11] [INFO] Processing 25 field mappings
[2025-12-11 21:19:11] [INFO] Mapping #1: Extracting 'EventDetails.AgencyCode' => 'cADAgencyIdentifier'
[2025-12-11 21:19:11] [INFO] Found 3 elements for 'AgencyCode', concatenating 3 non-empty values
[2025-12-11 21:19:11] [INFO]   -> Found value: PCFD
EMS
RESC
[2025-12-11 21:19:11] [INFO]   -> Set field 'cADAgencyIdentifier' = "PCFD\nEMS\nRESC"
[2025-12-11 21:19:11] [INFO] Mapping #2: Extracting 'EventDetails.ReportNumber' => ["incidentInternalId","dispatchRunNumber"]
[2025-12-11 21:19:11] [INFO] Found 3 elements for 'ReportNumber', concatenating 2 non-empty values
[2025-12-11 21:19:11] [INFO]   -> Found value: 2025003030
2025019246
[2025-12-11 21:19:11] [INFO]   -> Set field 'incidentInternalId' = "2025003030\n2025019246"
[2025-12-11 21:19:11] [INFO]   -> Set field 'dispatchRunNumber' = "2025003030\n2025019246"
[2025-12-11 21:19:11] [INFO] Mapping #3: Extracting 'EventDetails.NatureDescription' => 'incidentTypeValue1'
[2025-12-11 21:19:11] [INFO]   -> Found value: MEDICAL CALL
[2025-12-11 21:19:11] [INFO]   -> Set field 'incidentTypeValue1' = "MEDICAL CALL"
[2025-12-11 21:19:11] [INFO] Mapping #4: Extracting 'EventDetails.StreetNumber' => 'incidentLocationStreetNumber'
[2025-12-11 21:19:11] [INFO]   -> Found value: 2101
[2025-12-11 21:19:11] [INFO]   -> Set field 'incidentLocationStreetNumber' = 2101
[2025-12-11 21:19:11] [INFO] Mapping #5: Extracting 'RelatedNames.Name.StreetName' => 'streetName'
[2025-12-11 21:19:11] [INFO]   -> Found value: BENTON YOUNG RD
[2025-12-11 21:19:11] [INFO]   -> Set field 'streetName' = "BENTON YOUNG RD"
[2025-12-11 21:19:11] [INFO] Mapping #6: Extracting 'RelatedNames.Name.City' => 'incidentLocationCity'
[2025-12-11 21:19:11] [INFO]   -> Found value: COOKEVILLE
[2025-12-11 21:19:11] [INFO]   -> Set field 'incidentLocationCity' = "COOKEVILLE"
[2025-12-11 21:19:11] [INFO] Mapping #7: Extracting 'EventDetails.State' => 'incidentLocationStateName'
[2025-12-11 21:19:11] [INFO]   -> Found value: TN
[2025-12-11 21:19:11] [INFO]   -> Set field 'incidentLocationStateName' = "TN"
[2025-12-11 21:19:11] [INFO] Mapping #8: Extracting 'EventDetails.ZipCode' => 'nERISIncidentPostalCode'
[2025-12-11 21:19:11] [INFO]   -> Found value: 38501
[2025-12-11 21:19:11] [INFO]   -> Set field 'nERISIncidentPostalCode' = 38501
[2025-12-11 21:19:11] [INFO] Mapping #9: Extracting 'EventDetails.SiteName' => 'businessName'
[2025-12-11 21:19:11] [INFO]   -> No value found (null or empty)
[2025-12-11 21:19:11] [INFO] Mapping #10: Extracting 'EventDetails.ApartmentSuite' => 'incidentLocationApt'
[2025-12-11 21:19:11] [INFO]   -> No value found (null or empty)
[2025-12-11 21:19:11] [INFO] Mapping #11: Extracting 'EventDetails.EventLatitude' => 'nERISIncidentLatitude'
[2025-12-11 21:19:11] [INFO]   -> Found value: 36.18767
[2025-12-11 21:19:11] [INFO]   -> Set field 'nERISIncidentLatitude' = 36.18767
[2025-12-11 21:19:11] [INFO] Mapping #12: Extracting 'EventDetails.EventLongitude' => 'nERISIncidentLongitude'
[2025-12-11 21:19:11] [INFO]   -> Found value: -85.54159
[2025-12-11 21:19:11] [INFO]   -> Set field 'nERISIncidentLongitude' = -85.54159
[2025-12-11 21:19:11] [INFO] Mapping #13: Extracting 'EventDetails.EventStartTime' => 'alarm'
[2025-12-11 21:19:11] [INFO]   -> Found value: 2025-12-11 15:18:12
[2025-12-11 21:19:11] [INFO]   -> Set field 'alarm' = "2025-12-11 15:18:12"
[2025-12-11 21:19:11] [INFO] Mapping #14: Extracting 'EventDetails.FirstDispatchTime' => 'dispatched'
[2025-12-11 21:19:11] [INFO]   -> Found value: 2025-12-11 15:19:05
[2025-12-11 21:19:11] [INFO]   -> Set field 'dispatched' = "2025-12-11 15:19:05"
[2025-12-11 21:19:11] [INFO] Mapping #15: Extracting 'EventDetails.FirstEnrouteTime' => 'enroute'
[2025-12-11 21:19:11] [INFO]   -> No value found (null or empty)
[2025-12-11 21:19:11] [INFO] Mapping #16: Extracting 'EventDetails.FirstOnSceneTime' => 'onScene'
[2025-12-11 21:19:11] [INFO]   -> No value found (null or empty)
[2025-12-11 21:19:11] [INFO] Mapping #17: Extracting 'EventDetails.LastUnitClearTime' => ["cleared","inService"]
[2025-12-11 21:19:11] [INFO]   -> No value found (null or empty)
[2025-12-11 21:19:11] [INFO] Mapping #18: Extracting 'EventDetails.CrossStreets' => 'incidentLocationCross'
[2025-12-11 21:19:11] [INFO]   -> Found value: HILL CIR/CORA RD
[2025-12-11 21:19:11] [INFO]   -> Set field 'incidentLocationCross' = "HILL CIR\/CORA RD"
[2025-12-11 21:19:11] [INFO] Mapping #19: Extracting 'EventUnits.Unit[0].UnitCode' => 'cADVehicleID'
[2025-12-11 21:19:11] [INFO]   -> Found value: PCFR
[2025-12-11 21:19:11] [INFO]   -> Set field 'cADVehicleID' = "PCFR"
[2025-12-11 21:19:11] [INFO] Mapping #20: Extracting 'EventUnits.Unit[0].DispatchTime' => 'timedispatch'
[2025-12-11 21:19:11] [INFO]   -> Found value: 2025-12-11 15:19:05
[2025-12-11 21:19:11] [INFO]   -> Set field 'timedispatch' = "2025-12-11 15:19:05"
[2025-12-11 21:19:11] [INFO] Mapping #21: Extracting 'EventUnits.Unit[0].EnRouteTime' => 'timeenroutetoscene'
[2025-12-11 21:19:11] [INFO]   -> No value found (null or empty)
[2025-12-11 21:19:11] [INFO] Mapping #22: Extracting 'EventUnits.Unit[0].ArriveTime' => 'timeonscene'
[2025-12-11 21:19:11] [INFO]   -> No value found (null or empty)
[2025-12-11 21:19:11] [INFO] Mapping #23: Extracting 'EventUnits.Unit[0].ReturnToServiceTime' => 'timeunitclear'
[2025-12-11 21:19:11] [INFO]   -> No value found (null or empty)
[2025-12-11 21:19:11] [INFO] Mapping #24: Extracting 'EventUnits.Unit[0].CancelTime' => 'timecanceledenroute'
[2025-12-11 21:19:11] [INFO]   -> No value found (null or empty)
[2025-12-11 21:19:11] [INFO] Mapping #25: Extracting 'EventDetails.CadInciNumber' => 'policeReportNumber'
[2025-12-11 21:19:11] [INFO] Found 3 elements for 'CadInciNumber', concatenating 3 non-empty values
[2025-12-11 21:19:11] [INFO]   -> Found value: 20250136101
20250136097
20250136103
[2025-12-11 21:19:11] [INFO]   -> Set field 'policeReportNumber' = "20250136101\n20250136097\n20250136103"
[2025-12-11 21:19:11] [INFO] Finished extracting fields. Total fields extracted: 17
[2025-12-11 21:19:11] [INFO] Built locationCoordinates from lat/lng: 36.18767,-85.54159
[2025-12-11 21:19:11] [INFO] Extracted parsing rules data: {"cADAgencyIdentifier":"PCFD\nEMS\nRESC","incidentInternalId":"2025003030\n2025019246","dispatchRunNumber":"2025003030\n2025019246","incidentTypeValue1":"MEDICAL CALL","incidentLocationStreetNumber":2101,"streetName":"BENTON YOUNG RD","incidentLocationCity":"COOKEVILLE","incidentLocationStateName":"TN","nERISIncidentPostalCode":38501,"nERISIncidentLatitude":36.18767,"nERISIncidentLongitude":-85.54159,"alarm":"2025-12-11 15:18:12","dispatched":"2025-12-11 15:19:05","incidentLocationCross":"HILL CIR\/CORA RD","cADVehicleID":"PCFR","timedispatch":"2025-12-11 15:19:05","policeReportNumber":"20250136101\n20250136097\n20250136103","locationCoordinates":"36.18767,-85.54159"}
[2025-12-11 21:19:11] [INFO] Number of extracted fields: 18
[2025-12-11 21:19:11] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'PCFD
EMS
RESC'
[2025-12-11 21:19:11] [INFO] Multi-agency routing check: CAD Agency ID = PCFD
EMS
RESC, Assigned Agencies count = 1
[2025-12-11 21:19:11] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'PCFD
EMS
RESC'
[2025-12-11 21:19:11] [WARNING] WARNING: No SAASClient found with cADAgencyIdentifier = 'PCFD
EMS
RESC'
[2025-12-11 21:19:11] [INFO] FALLBACK: Using mailbox default saasclientId: 68eeb686225c40db4 (multi-agency routing attempted but failed)
[2025-12-11 21:19:11] [INFO] Final routing: saasclientId = 68eeb686225c40db4, dispatchStationsIds = ["68ffbebde83509b7c","68ffd433577d1ee1e","68ffbe83793eb4521","68eef9302d19f85fc","68ffbe45d3567d442","68ffbe0e8c5fa650f","68eef77e6a5b1e9d6","68ffbde067a9b162c","68ffbda5d8ebd5468","68ffbd6b1db8d8daa","68ffbd4220b20a872","68ffbcfb8b8911e4e","68eef6ffc8105af4e","68eeca5d553dc8756"]
[2025-12-11 21:19:11] [INFO] Found existing IncidentTypeMapping with ID: 6939328c99c5522d2
[2025-12-11 21:19:13] [INFO] Created new Dispatches record with ID: 693b354f784407c8e
[2025-12-11 21:19:13] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136101_20251211_211911.XML
[2025-12-11 21:19:13] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136101_20251211_211911.XML
[2025-12-11 21:19:13] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136101_20251211_211912.XML
[2025-12-11 21:19:13] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136101_20251211_211912.XML for user: 68f1466aed072ad4a
[2025-12-11 21:19:13] [INFO] File size: 5449 bytes
[2025-12-11 21:19:13] [INFO] Created FTPFiles record with ID: 693b3551490dada5c
[2025-12-11 21:19:13] [INFO] About to extract fields from XML. File size: 5449 bytes
[2025-12-11 21:19:13] [INFO] Number of mappings: 25
[2025-12-11 21:19:13] [INFO] Starting XML parsing. Content length: 5449
[2025-12-11 21:19:13] [INFO] XML parsed successfully. Root element: CADExport
[2025-12-11 21:19:13] [INFO] Processing 25 field mappings
[2025-12-11 21:19:13] [INFO] Mapping #1: Extracting 'EventDetails.AgencyCode' => 'cADAgencyIdentifier'
[2025-12-11 21:19:13] [INFO] Found 3 elements for 'AgencyCode', concatenating 3 non-empty values
[2025-12-11 21:19:13] [INFO]   -> Found value: PCFD
EMS
RESC
[2025-12-11 21:19:13] [INFO]   -> Set field 'cADAgencyIdentifier' = "PCFD\nEMS\nRESC"
[2025-12-11 21:19:13] [INFO] Mapping #2: Extracting 'EventDetails.ReportNumber' => ["incidentInternalId","dispatchRunNumber"]
[2025-12-11 21:19:13] [INFO] Found 3 elements for 'ReportNumber', concatenating 2 non-empty values
[2025-12-11 21:19:13] [INFO]   -> Found value: 2025003030
2025019246
[2025-12-11 21:19:13] [INFO]   -> Set field 'incidentInternalId' = "2025003030\n2025019246"
[2025-12-11 21:19:13] [INFO]   -> Set field 'dispatchRunNumber' = "2025003030\n2025019246"
[2025-12-11 21:19:13] [INFO] Mapping #3: Extracting 'EventDetails.NatureDescription' => 'incidentTypeValue1'
[2025-12-11 21:19:13] [INFO]   -> Found value: MEDICAL CALL
[2025-12-11 21:19:13] [INFO]   -> Set field 'incidentTypeValue1' = "MEDICAL CALL"
[2025-12-11 21:19:13] [INFO] Mapping #4: Extracting 'EventDetails.StreetNumber' => 'incidentLocationStreetNumber'
[2025-12-11 21:19:13] [INFO]   -> Found value: 2101
[2025-12-11 21:19:13] [INFO]   -> Set field 'incidentLocationStreetNumber' = 2101
[2025-12-11 21:19:13] [INFO] Mapping #5: Extracting 'RelatedNames.Name.StreetName' => 'streetName'
[2025-12-11 21:19:13] [INFO]   -> Found value: BENTON YOUNG RD
[2025-12-11 21:19:13] [INFO]   -> Set field 'streetName' = "BENTON YOUNG RD"
[2025-12-11 21:19:13] [INFO] Mapping #6: Extracting 'RelatedNames.Name.City' => 'incidentLocationCity'
[2025-12-11 21:19:13] [INFO]   -> Found value: COOKEVILLE
[2025-12-11 21:19:13] [INFO]   -> Set field 'incidentLocationCity' = "COOKEVILLE"
[2025-12-11 21:19:13] [INFO] Mapping #7: Extracting 'EventDetails.State' => 'incidentLocationStateName'
[2025-12-11 21:19:13] [INFO]   -> Found value: TN
[2025-12-11 21:19:13] [INFO]   -> Set field 'incidentLocationStateName' = "TN"
[2025-12-11 21:19:13] [INFO] Mapping #8: Extracting 'EventDetails.ZipCode' => 'nERISIncidentPostalCode'
[2025-12-11 21:19:13] [INFO]   -> Found value: 38501
[2025-12-11 21:19:13] [INFO]   -> Set field 'nERISIncidentPostalCode' = 38501
[2025-12-11 21:19:13] [INFO] Mapping #9: Extracting 'EventDetails.SiteName' => 'businessName'
[2025-12-11 21:19:13] [INFO]   -> No value found (null or empty)
[2025-12-11 21:19:13] [INFO] Mapping #10: Extracting 'EventDetails.ApartmentSuite' => 'incidentLocationApt'
[2025-12-11 21:19:13] [INFO]   -> No value found (null or empty)
[2025-12-11 21:19:13] [INFO] Mapping #11: Extracting 'EventDetails.EventLatitude' => 'nERISIncidentLatitude'
[2025-12-11 21:19:13] [INFO]   -> Found value: 36.18767
[2025-12-11 21:19:13] [INFO]   -> Set field 'nERISIncidentLatitude' = 36.18767
[2025-12-11 21:19:13] [INFO] Mapping #12: Extracting 'EventDetails.EventLongitude' => 'nERISIncidentLongitude'
[2025-12-11 21:19:13] [INFO]   -> Found value: -85.54159
[2025-12-11 21:19:13] [INFO]   -> Set field 'nERISIncidentLongitude' = -85.54159
[2025-12-11 21:19:13] [INFO] Mapping #13: Extracting 'EventDetails.EventStartTime' => 'alarm'
[2025-12-11 21:19:13] [INFO]   -> Found value: 2025-12-11 15:18:12
[2025-12-11 21:19:13] [INFO]   -> Set field 'alarm' = "2025-12-11 15:18:12"
[2025-12-11 21:19:13] [INFO] Mapping #14: Extracting 'EventDetails.FirstDispatchTime' => 'dispatched'
[2025-12-11 21:19:13] [INFO]   -> Found value: 2025-12-11 15:19:05
[2025-12-11 21:19:13] [INFO]   -> Set field 'dispatched' = "2025-12-11 15:19:05"
[2025-12-11 21:19:13] [INFO] Mapping #15: Extracting 'EventDetails.FirstEnrouteTime' => 'enroute'
[2025-12-11 21:19:13] [INFO]   -> No value found (null or empty)
[2025-12-11 21:19:13] [INFO] Mapping #16: Extracting 'EventDetails.FirstOnSceneTime' => 'onScene'
[2025-12-11 21:19:13] [INFO]   -> No value found (null or empty)
[2025-12-11 21:19:13] [INFO] Mapping #17: Extracting 'EventDetails.LastUnitClearTime' => ["cleared","inService"]
[2025-12-11 21:19:13] [INFO]   -> No value found (null or empty)
[2025-12-11 21:19:13] [INFO] Mapping #18: Extracting 'EventDetails.CrossStreets' => 'incidentLocationCross'
[2025-12-11 21:19:13] [INFO]   -> Found value: HILL CIR/CORA RD
[2025-12-11 21:19:13] [INFO]   -> Set field 'incidentLocationCross' = "HILL CIR\/CORA RD"
[2025-12-11 21:19:13] [INFO] Mapping #19: Extracting 'EventUnits.Unit[0].UnitCode' => 'cADVehicleID'
[2025-12-11 21:19:13] [INFO]   -> Found value: PCFR
[2025-12-11 21:19:13] [INFO]   -> Set field 'cADVehicleID' = "PCFR"
[2025-12-11 21:19:13] [INFO] Mapping #20: Extracting 'EventUnits.Unit[0].DispatchTime' => 'timedispatch'
[2025-12-11 21:19:13] [INFO]   -> Found value: 2025-12-11 15:19:05
[2025-12-11 21:19:13] [INFO]   -> Set field 'timedispatch' = "2025-12-11 15:19:05"
[2025-12-11 21:19:13] [INFO] Mapping #21: Extracting 'EventUnits.Unit[0].EnRouteTime' => 'timeenroutetoscene'
[2025-12-11 21:19:13] [INFO]   -> No value found (null or empty)
[2025-12-11 21:19:13] [INFO] Mapping #22: Extracting 'EventUnits.Unit[0].ArriveTime' => 'timeonscene'
[2025-12-11 21:19:13] [INFO]   -> No value found (null or empty)
[2025-12-11 21:19:13] [INFO] Mapping #23: Extracting 'EventUnits.Unit[0].ReturnToServiceTime' => 'timeunitclear'
[2025-12-11 21:19:13] [INFO]   -> No value found (null or empty)
[2025-12-11 21:19:13] [INFO] Mapping #24: Extracting 'EventUnits.Unit[0].CancelTime' => 'timecanceledenroute'
[2025-12-11 21:19:13] [INFO]   -> No value found (null or empty)
[2025-12-11 21:19:13] [INFO] Mapping #25: Extracting 'EventDetails.CadInciNumber' => 'policeReportNumber'
[2025-12-11 21:19:13] [INFO] Found 3 elements for 'CadInciNumber', concatenating 3 non-empty values
[2025-12-11 21:19:13] [INFO]   -> Found value: 20250136101
20250136097
20250136103
[2025-12-11 21:19:13] [INFO]   -> Set field 'policeReportNumber' = "20250136101\n20250136097\n20250136103"
[2025-12-11 21:19:13] [INFO] Finished extracting fields. Total fields extracted: 17
[2025-12-11 21:19:13] [INFO] Built locationCoordinates from lat/lng: 36.18767,-85.54159
[2025-12-11 21:19:13] [INFO] Extracted parsing rules data: {"cADAgencyIdentifier":"PCFD\nEMS\nRESC","incidentInternalId":"2025003030\n2025019246","dispatchRunNumber":"2025003030\n2025019246","incidentTypeValue1":"MEDICAL CALL","incidentLocationStreetNumber":2101,"streetName":"BENTON YOUNG RD","incidentLocationCity":"COOKEVILLE","incidentLocationStateName":"TN","nERISIncidentPostalCode":38501,"nERISIncidentLatitude":36.18767,"nERISIncidentLongitude":-85.54159,"alarm":"2025-12-11 15:18:12","dispatched":"2025-12-11 15:19:05","incidentLocationCross":"HILL CIR\/CORA RD","cADVehicleID":"PCFR","timedispatch":"2025-12-11 15:19:05","policeReportNumber":"20250136101\n20250136097\n20250136103","locationCoordinates":"36.18767,-85.54159"}
[2025-12-11 21:19:13] [INFO] Number of extracted fields: 18
[2025-12-11 21:19:13] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'PCFD
EMS
RESC'
[2025-12-11 21:19:13] [INFO] Multi-agency routing check: CAD Agency ID = PCFD
EMS
RESC, Assigned Agencies count = 1
[2025-12-11 21:19:13] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'PCFD
EMS
RESC'
[2025-12-11 21:19:13] [WARNING] WARNING: No SAASClient found with cADAgencyIdentifier = 'PCFD
EMS
RESC'
[2025-12-11 21:19:13] [INFO] FALLBACK: Using mailbox default saasclientId: 68eeb686225c40db4 (multi-agency routing attempted but failed)
[2025-12-11 21:19:13] [INFO] Final routing: saasclientId = 68eeb686225c40db4, dispatchStationsIds = ["68ffbebde83509b7c","68ffd433577d1ee1e","68ffbe83793eb4521","68eef9302d19f85fc","68ffbe45d3567d442","68ffbe0e8c5fa650f","68eef77e6a5b1e9d6","68ffbde067a9b162c","68ffbda5d8ebd5468","68ffbd6b1db8d8daa","68ffbd4220b20a872","68ffbcfb8b8911e4e","68eef6ffc8105af4e","68eeca5d553dc8756"]
[2025-12-11 21:19:13] [INFO] Found existing IncidentTypeMapping with ID: 6939328c99c5522d2
[2025-12-11 21:19:13] [INFO] Found existing Dispatch with cADNumber '2025003030
2025019246', ID: 693b354f784407c8e - will update instead of create
[2025-12-11 21:19:13] [INFO] Updated existing Dispatches record with ID: 693b354f784407c8e
[2025-12-11 21:19:13] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136101_20251211_211912.XML
[2025-12-11 21:19:13] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136101_20251211_211912.XML
[2025-12-11 21:22:33] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SCRFD_25-29400.xml
[2025-12-11 21:22:33] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SCRFD_25-29400.xml for user: 68d56363ec1209189
[2025-12-11 21:22:33] [INFO] File size: 1470 bytes
[2025-12-11 21:22:33] [INFO] Created FTPFiles record with ID: 693b361980b11d88b
[2025-12-11 21:22:33] [INFO] About to extract fields from XML. File size: 1470 bytes
[2025-12-11 21:22:33] [INFO] Number of mappings: 21
[2025-12-11 21:22:33] [INFO] Starting XML parsing. Content length: 1470
[2025-12-11 21:22:33] [INFO] XML parsed successfully. Root element: Incident
[2025-12-11 21:22:33] [INFO] Processing 21 field mappings
[2025-12-11 21:22:33] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-12-11 21:22:33] [INFO]   -> Found value: 25-29400
[2025-12-11 21:22:33] [INFO]   -> Set field 'dispatchRunNumber' = "25-29400"
[2025-12-11 21:22:33] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-12-11 21:22:33] [INFO]   -> Found value: 93
[2025-12-11 21:22:33] [INFO]   -> Set field 'incidentLocationStreetNumber' = 93
[2025-12-11 21:22:33] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-12-11 21:22:33] [INFO]   -> Found value: MAUNA KEA DR
[2025-12-11 21:22:33] [INFO]   -> Set field 'streetName' = "MAUNA KEA DR"
[2025-12-11 21:22:33] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-12-11 21:22:33] [INFO]   -> No value found (null or empty)
[2025-12-11 21:22:33] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-12-11 21:22:33] [INFO]   -> Found value: BENTON
[2025-12-11 21:22:33] [INFO]   -> Set field 'incidentLocationCity' = "BENTON"
[2025-12-11 21:22:33] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-12-11 21:22:33] [INFO]   -> No value found (null or empty)
[2025-12-11 21:22:33] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-12-11 21:22:33] [INFO]   -> No value found (null or empty)
[2025-12-11 21:22:33] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-12-11 21:22:33] [INFO]   -> No value found (null or empty)
[2025-12-11 21:22:33] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-12-11 21:22:33] [INFO]   -> No value found (null or empty)
[2025-12-11 21:22:33] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-12-11 21:22:33] [INFO]   -> No value found (null or empty)
[2025-12-11 21:22:33] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-12-11 21:22:33] [INFO]   -> Found value: OTHER
[2025-12-11 21:22:33] [INFO]   -> Set field 'incidentTypeValue1' = "OTHER"
[2025-12-11 21:22:33] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-12-11 21:22:33] [INFO]   -> Found value: 12-11-2025 14:25:13|RHONDA POPP HAVING HALLUCINATIONS
HAS MS 

 12-11-2025 14:30:01|X2 FROM COMMERCE...
[2025-12-11 21:22:33] [INFO]   -> Set field 'dispatchNotes' = "12-11-2025 14:25:13|RHONDA POPP HAVING HALLUCINATIONS\nHAS MS \n\n 12-11-2025 14:30:01|X2 FROM COMMERCE 12-11-2025 14:33:27|1771 DID NOT RESPOND TO THIS INCIDENT DRAGGED IN ERROR"
[2025-12-11 21:22:33] [INFO]   -> Set field 'cADLog' = "12-11-2025 14:25:13|RHONDA POPP HAVING HALLUCINATIONS\nHAS MS \n\n 12-11-2025 14:30:01|X2 FROM COMMERCE 12-11-2025 14:33:27|1771 DID NOT RESPOND TO THIS INCIDENT DRAGGED IN ERROR"
[2025-12-11 21:22:33] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-12-11 21:22:33] [INFO]   -> Found value: 12-11-2025T14:28:44
[2025-12-11 21:22:33] [INFO] Reformatted DD-MM-YYYY date '12-11-2025' (day=12, month=11) to ISO: 2025-11-12T14:28:44
[2025-12-11 21:22:33] [INFO]   -> Set field 'alarm' = "2025-11-12 14:28:44"
[2025-12-11 21:22:33] [INFO] Reformatted DD-MM-YYYY date '12-11-2025' (day=12, month=11) to ISO: 2025-11-12T14:28:44
[2025-12-11 21:22:33] [INFO]   -> Set field 'dispatched' = "2025-11-12 14:28:44"
[2025-12-11 21:22:33] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-12-11 21:22:33] [INFO]   -> Found value: 12-11-2025T14:43:46
[2025-12-11 21:22:33] [INFO] Reformatted DD-MM-YYYY date '12-11-2025' (day=12, month=11) to ISO: 2025-11-12T14:43:46
[2025-12-11 21:22:33] [INFO]   -> Set field 'onScene' = "2025-11-12 14:43:46"
[2025-12-11 21:22:33] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-12-11 21:22:33] [INFO]   -> No value found (null or empty)
[2025-12-11 21:22:33] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-12-11 21:22:33] [INFO]   -> Found value: 1771
[2025-12-11 21:22:33] [INFO]   -> Set field 'cADVehicleID' = 1771
[2025-12-11 21:22:33] [INFO]   -> Set field 'name' = "1771"
[2025-12-11 21:22:33] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-12-11 21:22:33] [INFO]   -> Found value: 12-11-2025T14:29:52
[2025-12-11 21:22:33] [INFO] Reformatted DD-MM-YYYY date '12-11-2025' (day=12, month=11) to ISO: 2025-11-12T14:29:52
[2025-12-11 21:22:33] [INFO]   -> Set field 'timeenroutetoscene' = "2025-11-12 14:29:52"
[2025-12-11 21:22:33] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-12-11 21:22:33] [INFO]   -> No value found (null or empty)
[2025-12-11 21:22:33] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-12-11 21:22:33] [INFO]   -> Found value: 12-11-2025T14:32:55
[2025-12-11 21:22:33] [INFO] Reformatted DD-MM-YYYY date '12-11-2025' (day=12, month=11) to ISO: 2025-11-12T14:32:55
[2025-12-11 21:22:33] [INFO]   -> Set field 'timeunitclear' = "2025-11-12 14:32:55"
[2025-12-11 21:22:33] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-12-11 21:22:33] [INFO]   -> Found value: 12-11-2025T14:29:49
[2025-12-11 21:22:33] [INFO] Reformatted DD-MM-YYYY date '12-11-2025' (day=12, month=11) to ISO: 2025-11-12T14:29:49
[2025-12-11 21:22:33] [INFO]   -> Set field 'timedispatch' = "2025-11-12 14:29:49"
[2025-12-11 21:22:33] [INFO] Mapping #21: Extracting 'Agency' => 'cADAgencyIdentifier'
[2025-12-11 21:22:33] [INFO]   -> Found value: SCRFD
[2025-12-11 21:22:33] [INFO]   -> Set field 'cADAgencyIdentifier' = "SCRFD"
[2025-12-11 21:22:33] [INFO] Finished extracting fields. Total fields extracted: 16
[2025-12-11 21:22:33] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-29400","incidentLocationStreetNumber":93,"streetName":"MAUNA KEA DR","incidentLocationCity":"BENTON","incidentTypeValue1":"OTHER","dispatchNotes":"12-11-2025 14:25:13|RHONDA POPP HAVING HALLUCINATIONS\nHAS MS \n\n 12-11-2025 14:30:01|X2 FROM COMMERCE 12-11-2025 14:33:27|1771 DID NOT RESPOND TO THIS INCIDENT DRAGGED IN ERROR","cADLog":"12-11-2025 14:25:13|RHONDA POPP HAVING HALLUCINATIONS\nHAS MS \n\n 12-11-2025 14:30:01|X2 FROM COMMERCE 12-11-2025 14:33:27|1771 DID NOT RESPOND TO THIS INCIDENT DRAGGED IN ERROR","alarm":"2025-11-12 14:28:44","dispatched":"2025-11-12 14:28:44","onScene":"2025-11-12 14:43:46","cADVehicleID":1771,"name":"1771","timeenroutetoscene":"2025-11-12 14:29:52","timeunitclear":"2025-11-12 14:32:55","timedispatch":"2025-11-12 14:29:49","cADAgencyIdentifier":"SCRFD"}
[2025-12-11 21:22:33] [INFO] Number of extracted fields: 16
[2025-12-11 21:22:33] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'SCRFD'
[2025-12-11 21:22:33] [INFO] Multi-agency routing check: CAD Agency ID = SCRFD, Assigned Agencies count = 2
[2025-12-11 21:22:33] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'SCRFD'
[2025-12-11 21:22:33] [INFO] Found SAASClient match: ID = 6643bdb30659f00d8, Name = Scott County Rural Fire Protection District
[2025-12-11 21:22:33] [INFO] SUCCESS: Routed to agency 'Scott County Rural Fire Protection District' (ID: 6643bdb30659f00d8) based on CAD ID: 'SCRFD'
[2025-12-11 21:22:33] [INFO] Fetched 6 stations from Stations module for agency 'Scott County Rural Fire Protection District': ["690279491710f7b8e","6644dbe7e17f1c3de","6644dbb3886c9768f","6644d0c9be0e4ec53","6644e2fe1572c01ae","69027d47e7c4fc65b"]
[2025-12-11 21:22:33] [INFO] Final routing: saasclientId = 6643bdb30659f00d8, dispatchStationsIds = ["690279491710f7b8e","6644dbe7e17f1c3de","6644dbb3886c9768f","6644d0c9be0e4ec53","6644e2fe1572c01ae","69027d47e7c4fc65b"]
[2025-12-11 21:22:33] [INFO] Updated FTPFiles record saasclientId to routed agency: 6643bdb30659f00d8
[2025-12-11 21:22:33] [INFO] Found existing IncidentTypeMapping with ID: 6939e59116190ddfb
[2025-12-11 21:22:33] [INFO] Found existing Dispatch with cADNumber '25-29400', ID: 693b29c13c3cf9a79 - will update instead of create
[2025-12-11 21:22:33] [INFO] Updated existing Dispatches record with ID: 693b29c13c3cf9a79
[2025-12-11 21:22:33] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SCRFD_25-29400.xml
[2025-12-11 21:22:33] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SCRFD_25-29400.xml
[2025-12-11 21:45:21] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136116_20251211_214521.XML
[2025-12-11 21:45:21] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136116_20251211_214521.XML for user: 68f1466aed072ad4a
[2025-12-11 21:45:21] [INFO] File size: 6078 bytes
[2025-12-11 21:45:21] [INFO] Created FTPFiles record with ID: 693b3b714f5f680a5
[2025-12-11 21:45:21] [INFO] About to extract fields from XML. File size: 6078 bytes
[2025-12-11 21:45:21] [INFO] Number of mappings: 25
[2025-12-11 21:45:21] [INFO] Starting XML parsing. Content length: 6078
[2025-12-11 21:45:21] [INFO] XML parsed successfully. Root element: CADExport
[2025-12-11 21:45:21] [INFO] Processing 25 field mappings
[2025-12-11 21:45:21] [INFO] Mapping #1: Extracting 'EventDetails.AgencyCode' => 'cADAgencyIdentifier'
[2025-12-11 21:45:21] [INFO] Found 4 elements for 'AgencyCode', concatenating 4 non-empty values
[2025-12-11 21:45:21] [INFO]   -> Found value: PCFD
EMS
PCSO
RESC
[2025-12-11 21:45:21] [INFO]   -> Set field 'cADAgencyIdentifier' = "PCFD\nEMS\nPCSO\nRESC"
[2025-12-11 21:45:21] [INFO] Mapping #2: Extracting 'EventDetails.ReportNumber' => ["incidentInternalId","dispatchRunNumber"]
[2025-12-11 21:45:21] [INFO] Found 4 elements for 'ReportNumber', concatenating 2 non-empty values
[2025-12-11 21:45:21] [INFO]   -> Found value: 2025003031
2025019248
[2025-12-11 21:45:21] [INFO]   -> Set field 'incidentInternalId' = "2025003031\n2025019248"
[2025-12-11 21:45:21] [INFO]   -> Set field 'dispatchRunNumber' = "2025003031\n2025019248"
[2025-12-11 21:45:21] [INFO] Mapping #3: Extracting 'EventDetails.NatureDescription' => 'incidentTypeValue1'
[2025-12-11 21:45:21] [INFO]   -> Found value: MVC WITH INJURY
[2025-12-11 21:45:21] [INFO]   -> Set field 'incidentTypeValue1' = "MVC WITH INJURY"
[2025-12-11 21:45:21] [INFO] Mapping #4: Extracting 'EventDetails.StreetNumber' => 'incidentLocationStreetNumber'
[2025-12-11 21:45:21] [INFO]   -> Found value: 4682
[2025-12-11 21:45:21] [INFO]   -> Set field 'incidentLocationStreetNumber' = 4682
[2025-12-11 21:45:21] [INFO] Mapping #5: Extracting 'RelatedNames.Name.StreetName' => 'streetName'
[2025-12-11 21:45:21] [INFO]   -> Found value: W BROAD ST
[2025-12-11 21:45:21] [INFO]   -> Set field 'streetName' = "W BROAD ST"
[2025-12-11 21:45:21] [INFO] Mapping #6: Extracting 'RelatedNames.Name.City' => 'incidentLocationCity'
[2025-12-11 21:45:21] [INFO]   -> Found value: COOKEVILLE
[2025-12-11 21:45:21] [INFO]   -> Set field 'incidentLocationCity' = "COOKEVILLE"
[2025-12-11 21:45:21] [INFO] Mapping #7: Extracting 'EventDetails.State' => 'incidentLocationStateName'
[2025-12-11 21:45:21] [INFO]   -> Found value: TN
[2025-12-11 21:45:21] [INFO]   -> Set field 'incidentLocationStateName' = "TN"
[2025-12-11 21:45:21] [INFO] Mapping #8: Extracting 'EventDetails.ZipCode' => 'nERISIncidentPostalCode'
[2025-12-11 21:45:21] [INFO]   -> Found value: 38501
[2025-12-11 21:45:21] [INFO]   -> Set field 'nERISIncidentPostalCode' = 38501
[2025-12-11 21:45:21] [INFO] Mapping #9: Extracting 'EventDetails.SiteName' => 'businessName'
[2025-12-11 21:45:21] [INFO]   -> No value found (null or empty)
[2025-12-11 21:45:21] [INFO] Mapping #10: Extracting 'EventDetails.ApartmentSuite' => 'incidentLocationApt'
[2025-12-11 21:45:21] [INFO]   -> No value found (null or empty)
[2025-12-11 21:45:21] [INFO] Mapping #11: Extracting 'EventDetails.EventLatitude' => 'nERISIncidentLatitude'
[2025-12-11 21:45:21] [INFO]   -> Found value: 36.17114
[2025-12-11 21:45:21] [INFO]   -> Set field 'nERISIncidentLatitude' = 36.17114
[2025-12-11 21:45:21] [INFO] Mapping #12: Extracting 'EventDetails.EventLongitude' => 'nERISIncidentLongitude'
[2025-12-11 21:45:21] [INFO]   -> Found value: -85.59721
[2025-12-11 21:45:21] [INFO]   -> Set field 'nERISIncidentLongitude' = -85.59721
[2025-12-11 21:45:21] [INFO] Mapping #13: Extracting 'EventDetails.EventStartTime' => 'alarm'
[2025-12-11 21:45:21] [INFO]   -> Found value: 2025-12-11 15:43:39
[2025-12-11 21:45:21] [INFO]   -> Set field 'alarm' = "2025-12-11 15:43:39"
[2025-12-11 21:45:21] [INFO] Mapping #14: Extracting 'EventDetails.FirstDispatchTime' => 'dispatched'
[2025-12-11 21:45:21] [INFO]   -> Found value: 2025-12-11 15:45:16
[2025-12-11 21:45:21] [INFO]   -> Set field 'dispatched' = "2025-12-11 15:45:16"
[2025-12-11 21:45:21] [INFO] Mapping #15: Extracting 'EventDetails.FirstEnrouteTime' => 'enroute'
[2025-12-11 21:45:21] [INFO]   -> No value found (null or empty)
[2025-12-11 21:45:21] [INFO] Mapping #16: Extracting 'EventDetails.FirstOnSceneTime' => 'onScene'
[2025-12-11 21:45:21] [INFO]   -> No value found (null or empty)
[2025-12-11 21:45:21] [INFO] Mapping #17: Extracting 'EventDetails.LastUnitClearTime' => ["cleared","inService"]
[2025-12-11 21:45:21] [INFO]   -> No value found (null or empty)
[2025-12-11 21:45:21] [INFO] Mapping #18: Extracting 'EventDetails.CrossStreets' => 'incidentLocationCross'
[2025-12-11 21:45:21] [INFO]   -> Found value: CLEMMONS RD/DOUBLE SPRINGS RD
[2025-12-11 21:45:21] [INFO]   -> Set field 'incidentLocationCross' = "CLEMMONS RD\/DOUBLE SPRINGS RD"
[2025-12-11 21:45:21] [INFO] Mapping #19: Extracting 'EventUnits.Unit[0].UnitCode' => 'cADVehicleID'
[2025-12-11 21:45:21] [INFO]   -> Found value: TK31
[2025-12-11 21:45:21] [INFO]   -> Set field 'cADVehicleID' = "TK31"
[2025-12-11 21:45:21] [INFO] Mapping #20: Extracting 'EventUnits.Unit[0].DispatchTime' => 'timedispatch'
[2025-12-11 21:45:21] [INFO]   -> Found value: 2025-12-11 15:45:16
[2025-12-11 21:45:21] [INFO]   -> Set field 'timedispatch' = "2025-12-11 15:45:16"
[2025-12-11 21:45:21] [INFO] Mapping #21: Extracting 'EventUnits.Unit[0].EnRouteTime' => 'timeenroutetoscene'
[2025-12-11 21:45:21] [INFO]   -> No value found (null or empty)
[2025-12-11 21:45:21] [INFO] Mapping #22: Extracting 'EventUnits.Unit[0].ArriveTime' => 'timeonscene'
[2025-12-11 21:45:21] [INFO]   -> No value found (null or empty)
[2025-12-11 21:45:21] [INFO] Mapping #23: Extracting 'EventUnits.Unit[0].ReturnToServiceTime' => 'timeunitclear'
[2025-12-11 21:45:21] [INFO]   -> No value found (null or empty)
[2025-12-11 21:45:21] [INFO] Mapping #24: Extracting 'EventUnits.Unit[0].CancelTime' => 'timecanceledenroute'
[2025-12-11 21:45:21] [INFO]   -> No value found (null or empty)
[2025-12-11 21:45:21] [INFO] Mapping #25: Extracting 'EventDetails.CadInciNumber' => 'policeReportNumber'
[2025-12-11 21:45:21] [INFO] Found 4 elements for 'CadInciNumber', concatenating 4 non-empty values
[2025-12-11 21:45:21] [INFO]   -> Found value: 20250136116
20250136114
20250136115
20250136117
[2025-12-11 21:45:21] [INFO]   -> Set field 'policeReportNumber' = "20250136116\n20250136114\n20250136115\n20250136117"
[2025-12-11 21:45:21] [INFO] Finished extracting fields. Total fields extracted: 17
[2025-12-11 21:45:21] [INFO] Built locationCoordinates from lat/lng: 36.17114,-85.59721
[2025-12-11 21:45:21] [INFO] Extracted parsing rules data: {"cADAgencyIdentifier":"PCFD\nEMS\nPCSO\nRESC","incidentInternalId":"2025003031\n2025019248","dispatchRunNumber":"2025003031\n2025019248","incidentTypeValue1":"MVC WITH INJURY","incidentLocationStreetNumber":4682,"streetName":"W BROAD ST","incidentLocationCity":"COOKEVILLE","incidentLocationStateName":"TN","nERISIncidentPostalCode":38501,"nERISIncidentLatitude":36.17114,"nERISIncidentLongitude":-85.59721,"alarm":"2025-12-11 15:43:39","dispatched":"2025-12-11 15:45:16","incidentLocationCross":"CLEMMONS RD\/DOUBLE SPRINGS RD","cADVehicleID":"TK31","timedispatch":"2025-12-11 15:45:16","policeReportNumber":"20250136116\n20250136114\n20250136115\n20250136117","locationCoordinates":"36.17114,-85.59721"}
[2025-12-11 21:45:21] [INFO] Number of extracted fields: 18
[2025-12-11 21:45:21] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'PCFD
EMS
PCSO
RESC'
[2025-12-11 21:45:21] [INFO] Multi-agency routing check: CAD Agency ID = PCFD
EMS
PCSO
RESC, Assigned Agencies count = 1
[2025-12-11 21:45:21] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'PCFD
EMS
PCSO
RESC'
[2025-12-11 21:45:21] [WARNING] WARNING: No SAASClient found with cADAgencyIdentifier = 'PCFD
EMS
PCSO
RESC'
[2025-12-11 21:45:21] [INFO] FALLBACK: Using mailbox default saasclientId: 68eeb686225c40db4 (multi-agency routing attempted but failed)
[2025-12-11 21:45:21] [INFO] Final routing: saasclientId = 68eeb686225c40db4, dispatchStationsIds = ["68ffbebde83509b7c","68ffd433577d1ee1e","68ffbe83793eb4521","68eef9302d19f85fc","68ffbe45d3567d442","68ffbe0e8c5fa650f","68eef77e6a5b1e9d6","68ffbde067a9b162c","68ffbda5d8ebd5468","68ffbd6b1db8d8daa","68ffbd4220b20a872","68ffbcfb8b8911e4e","68eef6ffc8105af4e","68eeca5d553dc8756"]
[2025-12-11 21:45:21] [INFO] Found existing IncidentTypeMapping with ID: 69380b1bd578b1eb3
[2025-12-11 21:45:23] [INFO] Created new Dispatches record with ID: 693b3b718cbfc8424
[2025-12-11 21:45:23] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136116_20251211_214521.XML
[2025-12-11 21:45:23] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136116_20251211_214521.XML
[2025-12-11 21:45:23] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136116_20251211_214522.XML
[2025-12-11 21:45:23] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136116_20251211_214522.XML for user: 68f1466aed072ad4a
[2025-12-11 21:45:23] [INFO] File size: 6078 bytes
[2025-12-11 21:45:23] [INFO] Created FTPFiles record with ID: 693b3b73470e375e1
[2025-12-11 21:45:23] [INFO] About to extract fields from XML. File size: 6078 bytes
[2025-12-11 21:45:23] [INFO] Number of mappings: 25
[2025-12-11 21:45:23] [INFO] Starting XML parsing. Content length: 6078
[2025-12-11 21:45:23] [INFO] XML parsed successfully. Root element: CADExport
[2025-12-11 21:45:23] [INFO] Processing 25 field mappings
[2025-12-11 21:45:23] [INFO] Mapping #1: Extracting 'EventDetails.AgencyCode' => 'cADAgencyIdentifier'
[2025-12-11 21:45:23] [INFO] Found 4 elements for 'AgencyCode', concatenating 4 non-empty values
[2025-12-11 21:45:23] [INFO]   -> Found value: PCFD
EMS
PCSO
RESC
[2025-12-11 21:45:23] [INFO]   -> Set field 'cADAgencyIdentifier' = "PCFD\nEMS\nPCSO\nRESC"
[2025-12-11 21:45:23] [INFO] Mapping #2: Extracting 'EventDetails.ReportNumber' => ["incidentInternalId","dispatchRunNumber"]
[2025-12-11 21:45:23] [INFO] Found 4 elements for 'ReportNumber', concatenating 2 non-empty values
[2025-12-11 21:45:23] [INFO]   -> Found value: 2025003031
2025019248
[2025-12-11 21:45:23] [INFO]   -> Set field 'incidentInternalId' = "2025003031\n2025019248"
[2025-12-11 21:45:23] [INFO]   -> Set field 'dispatchRunNumber' = "2025003031\n2025019248"
[2025-12-11 21:45:23] [INFO] Mapping #3: Extracting 'EventDetails.NatureDescription' => 'incidentTypeValue1'
[2025-12-11 21:45:23] [INFO]   -> Found value: MVC WITH INJURY
[2025-12-11 21:45:23] [INFO]   -> Set field 'incidentTypeValue1' = "MVC WITH INJURY"
[2025-12-11 21:45:23] [INFO] Mapping #4: Extracting 'EventDetails.StreetNumber' => 'incidentLocationStreetNumber'
[2025-12-11 21:45:23] [INFO]   -> Found value: 4682
[2025-12-11 21:45:23] [INFO]   -> Set field 'incidentLocationStreetNumber' = 4682
[2025-12-11 21:45:23] [INFO] Mapping #5: Extracting 'RelatedNames.Name.StreetName' => 'streetName'
[2025-12-11 21:45:23] [INFO]   -> Found value: W BROAD ST
[2025-12-11 21:45:23] [INFO]   -> Set field 'streetName' = "W BROAD ST"
[2025-12-11 21:45:23] [INFO] Mapping #6: Extracting 'RelatedNames.Name.City' => 'incidentLocationCity'
[2025-12-11 21:45:23] [INFO]   -> Found value: COOKEVILLE
[2025-12-11 21:45:23] [INFO]   -> Set field 'incidentLocationCity' = "COOKEVILLE"
[2025-12-11 21:45:23] [INFO] Mapping #7: Extracting 'EventDetails.State' => 'incidentLocationStateName'
[2025-12-11 21:45:23] [INFO]   -> Found value: TN
[2025-12-11 21:45:23] [INFO]   -> Set field 'incidentLocationStateName' = "TN"
[2025-12-11 21:45:23] [INFO] Mapping #8: Extracting 'EventDetails.ZipCode' => 'nERISIncidentPostalCode'
[2025-12-11 21:45:23] [INFO]   -> Found value: 38501
[2025-12-11 21:45:23] [INFO]   -> Set field 'nERISIncidentPostalCode' = 38501
[2025-12-11 21:45:23] [INFO] Mapping #9: Extracting 'EventDetails.SiteName' => 'businessName'
[2025-12-11 21:45:23] [INFO]   -> No value found (null or empty)
[2025-12-11 21:45:23] [INFO] Mapping #10: Extracting 'EventDetails.ApartmentSuite' => 'incidentLocationApt'
[2025-12-11 21:45:23] [INFO]   -> No value found (null or empty)
[2025-12-11 21:45:23] [INFO] Mapping #11: Extracting 'EventDetails.EventLatitude' => 'nERISIncidentLatitude'
[2025-12-11 21:45:23] [INFO]   -> Found value: 36.17114
[2025-12-11 21:45:23] [INFO]   -> Set field 'nERISIncidentLatitude' = 36.17114
[2025-12-11 21:45:23] [INFO] Mapping #12: Extracting 'EventDetails.EventLongitude' => 'nERISIncidentLongitude'
[2025-12-11 21:45:23] [INFO]   -> Found value: -85.59721
[2025-12-11 21:45:23] [INFO]   -> Set field 'nERISIncidentLongitude' = -85.59721
[2025-12-11 21:45:23] [INFO] Mapping #13: Extracting 'EventDetails.EventStartTime' => 'alarm'
[2025-12-11 21:45:23] [INFO]   -> Found value: 2025-12-11 15:43:39
[2025-12-11 21:45:23] [INFO]   -> Set field 'alarm' = "2025-12-11 15:43:39"
[2025-12-11 21:45:23] [INFO] Mapping #14: Extracting 'EventDetails.FirstDispatchTime' => 'dispatched'
[2025-12-11 21:45:23] [INFO]   -> Found value: 2025-12-11 15:45:16
[2025-12-11 21:45:23] [INFO]   -> Set field 'dispatched' = "2025-12-11 15:45:16"
[2025-12-11 21:45:23] [INFO] Mapping #15: Extracting 'EventDetails.FirstEnrouteTime' => 'enroute'
[2025-12-11 21:45:23] [INFO]   -> No value found (null or empty)
[2025-12-11 21:45:23] [INFO] Mapping #16: Extracting 'EventDetails.FirstOnSceneTime' => 'onScene'
[2025-12-11 21:45:23] [INFO]   -> No value found (null or empty)
[2025-12-11 21:45:23] [INFO] Mapping #17: Extracting 'EventDetails.LastUnitClearTime' => ["cleared","inService"]
[2025-12-11 21:45:23] [INFO]   -> No value found (null or empty)
[2025-12-11 21:45:23] [INFO] Mapping #18: Extracting 'EventDetails.CrossStreets' => 'incidentLocationCross'
[2025-12-11 21:45:23] [INFO]   -> Found value: CLEMMONS RD/DOUBLE SPRINGS RD
[2025-12-11 21:45:23] [INFO]   -> Set field 'incidentLocationCross' = "CLEMMONS RD\/DOUBLE SPRINGS RD"
[2025-12-11 21:45:23] [INFO] Mapping #19: Extracting 'EventUnits.Unit[0].UnitCode' => 'cADVehicleID'
[2025-12-11 21:45:23] [INFO]   -> Found value: TK31
[2025-12-11 21:45:23] [INFO]   -> Set field 'cADVehicleID' = "TK31"
[2025-12-11 21:45:23] [INFO] Mapping #20: Extracting 'EventUnits.Unit[0].DispatchTime' => 'timedispatch'
[2025-12-11 21:45:23] [INFO]   -> Found value: 2025-12-11 15:45:16
[2025-12-11 21:45:23] [INFO]   -> Set field 'timedispatch' = "2025-12-11 15:45:16"
[2025-12-11 21:45:23] [INFO] Mapping #21: Extracting 'EventUnits.Unit[0].EnRouteTime' => 'timeenroutetoscene'
[2025-12-11 21:45:23] [INFO]   -> No value found (null or empty)
[2025-12-11 21:45:23] [INFO] Mapping #22: Extracting 'EventUnits.Unit[0].ArriveTime' => 'timeonscene'
[2025-12-11 21:45:23] [INFO]   -> No value found (null or empty)
[2025-12-11 21:45:23] [INFO] Mapping #23: Extracting 'EventUnits.Unit[0].ReturnToServiceTime' => 'timeunitclear'
[2025-12-11 21:45:23] [INFO]   -> No value found (null or empty)
[2025-12-11 21:45:23] [INFO] Mapping #24: Extracting 'EventUnits.Unit[0].CancelTime' => 'timecanceledenroute'
[2025-12-11 21:45:23] [INFO]   -> No value found (null or empty)
[2025-12-11 21:45:23] [INFO] Mapping #25: Extracting 'EventDetails.CadInciNumber' => 'policeReportNumber'
[2025-12-11 21:45:23] [INFO] Found 4 elements for 'CadInciNumber', concatenating 4 non-empty values
[2025-12-11 21:45:23] [INFO]   -> Found value: 20250136116
20250136114
20250136115
20250136117
[2025-12-11 21:45:23] [INFO]   -> Set field 'policeReportNumber' = "20250136116\n20250136114\n20250136115\n20250136117"
[2025-12-11 21:45:23] [INFO] Finished extracting fields. Total fields extracted: 17
[2025-12-11 21:45:23] [INFO] Built locationCoordinates from lat/lng: 36.17114,-85.59721
[2025-12-11 21:45:23] [INFO] Extracted parsing rules data: {"cADAgencyIdentifier":"PCFD\nEMS\nPCSO\nRESC","incidentInternalId":"2025003031\n2025019248","dispatchRunNumber":"2025003031\n2025019248","incidentTypeValue1":"MVC WITH INJURY","incidentLocationStreetNumber":4682,"streetName":"W BROAD ST","incidentLocationCity":"COOKEVILLE","incidentLocationStateName":"TN","nERISIncidentPostalCode":38501,"nERISIncidentLatitude":36.17114,"nERISIncidentLongitude":-85.59721,"alarm":"2025-12-11 15:43:39","dispatched":"2025-12-11 15:45:16","incidentLocationCross":"CLEMMONS RD\/DOUBLE SPRINGS RD","cADVehicleID":"TK31","timedispatch":"2025-12-11 15:45:16","policeReportNumber":"20250136116\n20250136114\n20250136115\n20250136117","locationCoordinates":"36.17114,-85.59721"}
[2025-12-11 21:45:23] [INFO] Number of extracted fields: 18
[2025-12-11 21:45:23] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'PCFD
EMS
PCSO
RESC'
[2025-12-11 21:45:23] [INFO] Multi-agency routing check: CAD Agency ID = PCFD
EMS
PCSO
RESC, Assigned Agencies count = 1
[2025-12-11 21:45:23] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'PCFD
EMS
PCSO
RESC'
[2025-12-11 21:45:23] [WARNING] WARNING: No SAASClient found with cADAgencyIdentifier = 'PCFD
EMS
PCSO
RESC'
[2025-12-11 21:45:23] [INFO] FALLBACK: Using mailbox default saasclientId: 68eeb686225c40db4 (multi-agency routing attempted but failed)
[2025-12-11 21:45:23] [INFO] Final routing: saasclientId = 68eeb686225c40db4, dispatchStationsIds = ["68ffbebde83509b7c","68ffd433577d1ee1e","68ffbe83793eb4521","68eef9302d19f85fc","68ffbe45d3567d442","68ffbe0e8c5fa650f","68eef77e6a5b1e9d6","68ffbde067a9b162c","68ffbda5d8ebd5468","68ffbd6b1db8d8daa","68ffbd4220b20a872","68ffbcfb8b8911e4e","68eef6ffc8105af4e","68eeca5d553dc8756"]
[2025-12-11 21:45:23] [INFO] Found existing IncidentTypeMapping with ID: 69380b1bd578b1eb3
[2025-12-11 21:45:23] [INFO] Found existing Dispatch with cADNumber '2025003031
2025019248', ID: 693b3b718cbfc8424 - will update instead of create
[2025-12-11 21:45:23] [INFO] Updated existing Dispatches record with ID: 693b3b718cbfc8424
[2025-12-11 21:45:23] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136116_20251211_214522.XML
[2025-12-11 21:45:23] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136116_20251211_214522.XML
[2025-12-11 22:17:21] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136128_20251211_221721.XML
[2025-12-11 22:17:21] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136128_20251211_221721.XML for user: 68f1466aed072ad4a
[2025-12-11 22:17:21] [INFO] File size: 5815 bytes
[2025-12-11 22:17:21] [INFO] Created FTPFiles record with ID: 693b42f139946dec7
[2025-12-11 22:17:21] [INFO] About to extract fields from XML. File size: 5815 bytes
[2025-12-11 22:17:21] [INFO] Number of mappings: 25
[2025-12-11 22:17:21] [INFO] Starting XML parsing. Content length: 5815
[2025-12-11 22:17:21] [INFO] XML parsed successfully. Root element: CADExport
[2025-12-11 22:17:21] [INFO] Processing 25 field mappings
[2025-12-11 22:17:21] [INFO] Mapping #1: Extracting 'EventDetails.AgencyCode' => 'cADAgencyIdentifier'
[2025-12-11 22:17:21] [INFO] Found 4 elements for 'AgencyCode', concatenating 4 non-empty values
[2025-12-11 22:17:21] [INFO]   -> Found value: PCFD
EMS
PCSO
RESC
[2025-12-11 22:17:21] [INFO]   -> Set field 'cADAgencyIdentifier' = "PCFD\nEMS\nPCSO\nRESC"
[2025-12-11 22:17:21] [INFO] Mapping #2: Extracting 'EventDetails.ReportNumber' => ["incidentInternalId","dispatchRunNumber"]
[2025-12-11 22:17:21] [INFO] Found 4 elements for 'ReportNumber', concatenating 2 non-empty values
[2025-12-11 22:17:21] [INFO]   -> Found value: 2025003032
2025019254
[2025-12-11 22:17:21] [INFO]   -> Set field 'incidentInternalId' = "2025003032\n2025019254"
[2025-12-11 22:17:21] [INFO]   -> Set field 'dispatchRunNumber' = "2025003032\n2025019254"
[2025-12-11 22:17:21] [INFO] Mapping #3: Extracting 'EventDetails.NatureDescription' => 'incidentTypeValue1'
[2025-12-11 22:17:21] [INFO]   -> Found value: UNCONSCIOUS
[2025-12-11 22:17:21] [INFO]   -> Set field 'incidentTypeValue1' = "UNCONSCIOUS"
[2025-12-11 22:17:21] [INFO] Mapping #4: Extracting 'EventDetails.StreetNumber' => 'incidentLocationStreetNumber'
[2025-12-11 22:17:21] [INFO]   -> Found value: 2831
[2025-12-11 22:17:21] [INFO]   -> Set field 'incidentLocationStreetNumber' = 2831
[2025-12-11 22:17:21] [INFO] Mapping #5: Extracting 'RelatedNames.Name.StreetName' => 'streetName'
[2025-12-11 22:17:21] [INFO]   -> Found value: TIGHTFIT RD
[2025-12-11 22:17:21] [INFO]   -> Set field 'streetName' = "TIGHTFIT RD"
[2025-12-11 22:17:21] [INFO] Mapping #6: Extracting 'RelatedNames.Name.City' => 'incidentLocationCity'
[2025-12-11 22:17:21] [INFO]   -> Found value: BAXTER
[2025-12-11 22:17:21] [INFO]   -> Set field 'incidentLocationCity' = "BAXTER"
[2025-12-11 22:17:21] [INFO] Mapping #7: Extracting 'EventDetails.State' => 'incidentLocationStateName'
[2025-12-11 22:17:21] [INFO]   -> Found value: TN
[2025-12-11 22:17:21] [INFO]   -> Set field 'incidentLocationStateName' = "TN"
[2025-12-11 22:17:21] [INFO] Mapping #8: Extracting 'EventDetails.ZipCode' => 'nERISIncidentPostalCode'
[2025-12-11 22:17:21] [INFO]   -> Found value: 38544
[2025-12-11 22:17:21] [INFO]   -> Set field 'nERISIncidentPostalCode' = 38544
[2025-12-11 22:17:21] [INFO] Mapping #9: Extracting 'EventDetails.SiteName' => 'businessName'
[2025-12-11 22:17:21] [INFO]   -> No value found (null or empty)
[2025-12-11 22:17:21] [INFO] Mapping #10: Extracting 'EventDetails.ApartmentSuite' => 'incidentLocationApt'
[2025-12-11 22:17:21] [INFO]   -> No value found (null or empty)
[2025-12-11 22:17:21] [INFO] Mapping #11: Extracting 'EventDetails.EventLatitude' => 'nERISIncidentLatitude'
[2025-12-11 22:17:21] [INFO]   -> Found value: 36.13401
[2025-12-11 22:17:21] [INFO]   -> Set field 'nERISIncidentLatitude' = 36.13401
[2025-12-11 22:17:21] [INFO] Mapping #12: Extracting 'EventDetails.EventLongitude' => 'nERISIncidentLongitude'
[2025-12-11 22:17:21] [INFO]   -> Found value: -85.69302
[2025-12-11 22:17:21] [INFO]   -> Set field 'nERISIncidentLongitude' = -85.69302
[2025-12-11 22:17:21] [INFO] Mapping #13: Extracting 'EventDetails.EventStartTime' => 'alarm'
[2025-12-11 22:17:21] [INFO]   -> Found value: 2025-12-11 16:16:53
[2025-12-11 22:17:21] [INFO]   -> Set field 'alarm' = "2025-12-11 16:16:53"
[2025-12-11 22:17:21] [INFO] Mapping #14: Extracting 'EventDetails.FirstDispatchTime' => 'dispatched'
[2025-12-11 22:17:21] [INFO]   -> Found value: 2025-12-11 16:17:16
[2025-12-11 22:17:21] [INFO]   -> Set field 'dispatched' = "2025-12-11 16:17:16"
[2025-12-11 22:17:21] [INFO] Mapping #15: Extracting 'EventDetails.FirstEnrouteTime' => 'enroute'
[2025-12-11 22:17:21] [INFO]   -> No value found (null or empty)
[2025-12-11 22:17:21] [INFO] Mapping #16: Extracting 'EventDetails.FirstOnSceneTime' => 'onScene'
[2025-12-11 22:17:21] [INFO]   -> No value found (null or empty)
[2025-12-11 22:17:21] [INFO] Mapping #17: Extracting 'EventDetails.LastUnitClearTime' => ["cleared","inService"]
[2025-12-11 22:17:21] [INFO]   -> No value found (null or empty)
[2025-12-11 22:17:21] [INFO] Mapping #18: Extracting 'EventDetails.CrossStreets' => 'incidentLocationCross'
[2025-12-11 22:17:21] [INFO]   -> Found value: JARED RIDGE RD/LOWETOWN RD
[2025-12-11 22:17:21] [INFO]   -> Set field 'incidentLocationCross' = "JARED RIDGE RD\/LOWETOWN RD"
[2025-12-11 22:17:21] [INFO] Mapping #19: Extracting 'EventUnits.Unit[0].UnitCode' => 'cADVehicleID'
[2025-12-11 22:17:21] [INFO]   -> Found value: PCFR
[2025-12-11 22:17:21] [INFO]   -> Set field 'cADVehicleID' = "PCFR"
[2025-12-11 22:17:21] [INFO] Mapping #20: Extracting 'EventUnits.Unit[0].DispatchTime' => 'timedispatch'
[2025-12-11 22:17:21] [INFO]   -> Found value: 2025-12-11 16:17:16
[2025-12-11 22:17:21] [INFO]   -> Set field 'timedispatch' = "2025-12-11 16:17:16"
[2025-12-11 22:17:21] [INFO] Mapping #21: Extracting 'EventUnits.Unit[0].EnRouteTime' => 'timeenroutetoscene'
[2025-12-11 22:17:21] [INFO]   -> No value found (null or empty)
[2025-12-11 22:17:21] [INFO] Mapping #22: Extracting 'EventUnits.Unit[0].ArriveTime' => 'timeonscene'
[2025-12-11 22:17:21] [INFO]   -> No value found (null or empty)
[2025-12-11 22:17:21] [INFO] Mapping #23: Extracting 'EventUnits.Unit[0].ReturnToServiceTime' => 'timeunitclear'
[2025-12-11 22:17:21] [INFO]   -> No value found (null or empty)
[2025-12-11 22:17:21] [INFO] Mapping #24: Extracting 'EventUnits.Unit[0].CancelTime' => 'timecanceledenroute'
[2025-12-11 22:17:21] [INFO]   -> No value found (null or empty)
[2025-12-11 22:17:21] [INFO] Mapping #25: Extracting 'EventDetails.CadInciNumber' => 'policeReportNumber'
[2025-12-11 22:17:21] [INFO] Found 4 elements for 'CadInciNumber', concatenating 4 non-empty values
[2025-12-11 22:17:21] [INFO]   -> Found value: 20250136128
20250136126
20250136127
20250136129
[2025-12-11 22:17:21] [INFO]   -> Set field 'policeReportNumber' = "20250136128\n20250136126\n20250136127\n20250136129"
[2025-12-11 22:17:21] [INFO] Finished extracting fields. Total fields extracted: 17
[2025-12-11 22:17:21] [INFO] Built locationCoordinates from lat/lng: 36.13401,-85.69302
[2025-12-11 22:17:21] [INFO] Extracted parsing rules data: {"cADAgencyIdentifier":"PCFD\nEMS\nPCSO\nRESC","incidentInternalId":"2025003032\n2025019254","dispatchRunNumber":"2025003032\n2025019254","incidentTypeValue1":"UNCONSCIOUS","incidentLocationStreetNumber":2831,"streetName":"TIGHTFIT RD","incidentLocationCity":"BAXTER","incidentLocationStateName":"TN","nERISIncidentPostalCode":38544,"nERISIncidentLatitude":36.13401,"nERISIncidentLongitude":-85.69302,"alarm":"2025-12-11 16:16:53","dispatched":"2025-12-11 16:17:16","incidentLocationCross":"JARED RIDGE RD\/LOWETOWN RD","cADVehicleID":"PCFR","timedispatch":"2025-12-11 16:17:16","policeReportNumber":"20250136128\n20250136126\n20250136127\n20250136129","locationCoordinates":"36.13401,-85.69302"}
[2025-12-11 22:17:21] [INFO] Number of extracted fields: 18
[2025-12-11 22:17:21] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'PCFD
EMS
PCSO
RESC'
[2025-12-11 22:17:21] [INFO] Multi-agency routing check: CAD Agency ID = PCFD
EMS
PCSO
RESC, Assigned Agencies count = 1
[2025-12-11 22:17:21] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'PCFD
EMS
PCSO
RESC'
[2025-12-11 22:17:21] [WARNING] WARNING: No SAASClient found with cADAgencyIdentifier = 'PCFD
EMS
PCSO
RESC'
[2025-12-11 22:17:21] [INFO] FALLBACK: Using mailbox default saasclientId: 68eeb686225c40db4 (multi-agency routing attempted but failed)
[2025-12-11 22:17:21] [INFO] Final routing: saasclientId = 68eeb686225c40db4, dispatchStationsIds = ["68ffbebde83509b7c","68ffd433577d1ee1e","68ffbe83793eb4521","68eef9302d19f85fc","68ffbe45d3567d442","68ffbe0e8c5fa650f","68eef77e6a5b1e9d6","68ffbde067a9b162c","68ffbda5d8ebd5468","68ffbd6b1db8d8daa","68ffbd4220b20a872","68ffbcfb8b8911e4e","68eef6ffc8105af4e","68eeca5d553dc8756"]
[2025-12-11 22:17:21] [INFO] Found existing IncidentTypeMapping with ID: 693976706d4f7fb2e
[2025-12-11 22:17:23] [INFO] Created new Dispatches record with ID: 693b42f17d0727fbf
[2025-12-11 22:17:23] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136128_20251211_221721.XML
[2025-12-11 22:17:23] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136128_20251211_221721.XML
[2025-12-11 22:17:23] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136128_20251211_221722.XML
[2025-12-11 22:17:23] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136128_20251211_221722.XML for user: 68f1466aed072ad4a
[2025-12-11 22:17:23] [INFO] File size: 5815 bytes
[2025-12-11 22:17:23] [INFO] Created FTPFiles record with ID: 693b42f34cc9c7059
[2025-12-11 22:17:23] [INFO] About to extract fields from XML. File size: 5815 bytes
[2025-12-11 22:17:23] [INFO] Number of mappings: 25
[2025-12-11 22:17:23] [INFO] Starting XML parsing. Content length: 5815
[2025-12-11 22:17:23] [INFO] XML parsed successfully. Root element: CADExport
[2025-12-11 22:17:23] [INFO] Processing 25 field mappings
[2025-12-11 22:17:23] [INFO] Mapping #1: Extracting 'EventDetails.AgencyCode' => 'cADAgencyIdentifier'
[2025-12-11 22:17:23] [INFO] Found 4 elements for 'AgencyCode', concatenating 4 non-empty values
[2025-12-11 22:17:23] [INFO]   -> Found value: PCFD
EMS
PCSO
RESC
[2025-12-11 22:17:23] [INFO]   -> Set field 'cADAgencyIdentifier' = "PCFD\nEMS\nPCSO\nRESC"
[2025-12-11 22:17:23] [INFO] Mapping #2: Extracting 'EventDetails.ReportNumber' => ["incidentInternalId","dispatchRunNumber"]
[2025-12-11 22:17:23] [INFO] Found 4 elements for 'ReportNumber', concatenating 2 non-empty values
[2025-12-11 22:17:23] [INFO]   -> Found value: 2025003032
2025019254
[2025-12-11 22:17:23] [INFO]   -> Set field 'incidentInternalId' = "2025003032\n2025019254"
[2025-12-11 22:17:23] [INFO]   -> Set field 'dispatchRunNumber' = "2025003032\n2025019254"
[2025-12-11 22:17:23] [INFO] Mapping #3: Extracting 'EventDetails.NatureDescription' => 'incidentTypeValue1'
[2025-12-11 22:17:23] [INFO]   -> Found value: UNCONSCIOUS
[2025-12-11 22:17:23] [INFO]   -> Set field 'incidentTypeValue1' = "UNCONSCIOUS"
[2025-12-11 22:17:23] [INFO] Mapping #4: Extracting 'EventDetails.StreetNumber' => 'incidentLocationStreetNumber'
[2025-12-11 22:17:23] [INFO]   -> Found value: 2831
[2025-12-11 22:17:23] [INFO]   -> Set field 'incidentLocationStreetNumber' = 2831
[2025-12-11 22:17:23] [INFO] Mapping #5: Extracting 'RelatedNames.Name.StreetName' => 'streetName'
[2025-12-11 22:17:23] [INFO]   -> Found value: TIGHTFIT RD
[2025-12-11 22:17:23] [INFO]   -> Set field 'streetName' = "TIGHTFIT RD"
[2025-12-11 22:17:23] [INFO] Mapping #6: Extracting 'RelatedNames.Name.City' => 'incidentLocationCity'
[2025-12-11 22:17:23] [INFO]   -> Found value: BAXTER
[2025-12-11 22:17:23] [INFO]   -> Set field 'incidentLocationCity' = "BAXTER"
[2025-12-11 22:17:23] [INFO] Mapping #7: Extracting 'EventDetails.State' => 'incidentLocationStateName'
[2025-12-11 22:17:23] [INFO]   -> Found value: TN
[2025-12-11 22:17:23] [INFO]   -> Set field 'incidentLocationStateName' = "TN"
[2025-12-11 22:17:23] [INFO] Mapping #8: Extracting 'EventDetails.ZipCode' => 'nERISIncidentPostalCode'
[2025-12-11 22:17:23] [INFO]   -> Found value: 38544
[2025-12-11 22:17:23] [INFO]   -> Set field 'nERISIncidentPostalCode' = 38544
[2025-12-11 22:17:23] [INFO] Mapping #9: Extracting 'EventDetails.SiteName' => 'businessName'
[2025-12-11 22:17:23] [INFO]   -> No value found (null or empty)
[2025-12-11 22:17:23] [INFO] Mapping #10: Extracting 'EventDetails.ApartmentSuite' => 'incidentLocationApt'
[2025-12-11 22:17:23] [INFO]   -> No value found (null or empty)
[2025-12-11 22:17:23] [INFO] Mapping #11: Extracting 'EventDetails.EventLatitude' => 'nERISIncidentLatitude'
[2025-12-11 22:17:23] [INFO]   -> Found value: 36.13401
[2025-12-11 22:17:23] [INFO]   -> Set field 'nERISIncidentLatitude' = 36.13401
[2025-12-11 22:17:23] [INFO] Mapping #12: Extracting 'EventDetails.EventLongitude' => 'nERISIncidentLongitude'
[2025-12-11 22:17:23] [INFO]   -> Found value: -85.69302
[2025-12-11 22:17:23] [INFO]   -> Set field 'nERISIncidentLongitude' = -85.69302
[2025-12-11 22:17:23] [INFO] Mapping #13: Extracting 'EventDetails.EventStartTime' => 'alarm'
[2025-12-11 22:17:23] [INFO]   -> Found value: 2025-12-11 16:16:53
[2025-12-11 22:17:23] [INFO]   -> Set field 'alarm' = "2025-12-11 16:16:53"
[2025-12-11 22:17:23] [INFO] Mapping #14: Extracting 'EventDetails.FirstDispatchTime' => 'dispatched'
[2025-12-11 22:17:23] [INFO]   -> Found value: 2025-12-11 16:17:16
[2025-12-11 22:17:23] [INFO]   -> Set field 'dispatched' = "2025-12-11 16:17:16"
[2025-12-11 22:17:23] [INFO] Mapping #15: Extracting 'EventDetails.FirstEnrouteTime' => 'enroute'
[2025-12-11 22:17:23] [INFO]   -> No value found (null or empty)
[2025-12-11 22:17:23] [INFO] Mapping #16: Extracting 'EventDetails.FirstOnSceneTime' => 'onScene'
[2025-12-11 22:17:23] [INFO]   -> No value found (null or empty)
[2025-12-11 22:17:23] [INFO] Mapping #17: Extracting 'EventDetails.LastUnitClearTime' => ["cleared","inService"]
[2025-12-11 22:17:23] [INFO]   -> No value found (null or empty)
[2025-12-11 22:17:23] [INFO] Mapping #18: Extracting 'EventDetails.CrossStreets' => 'incidentLocationCross'
[2025-12-11 22:17:23] [INFO]   -> Found value: JARED RIDGE RD/LOWETOWN RD
[2025-12-11 22:17:23] [INFO]   -> Set field 'incidentLocationCross' = "JARED RIDGE RD\/LOWETOWN RD"
[2025-12-11 22:17:23] [INFO] Mapping #19: Extracting 'EventUnits.Unit[0].UnitCode' => 'cADVehicleID'
[2025-12-11 22:17:23] [INFO]   -> Found value: PCFR
[2025-12-11 22:17:23] [INFO]   -> Set field 'cADVehicleID' = "PCFR"
[2025-12-11 22:17:23] [INFO] Mapping #20: Extracting 'EventUnits.Unit[0].DispatchTime' => 'timedispatch'
[2025-12-11 22:17:23] [INFO]   -> Found value: 2025-12-11 16:17:16
[2025-12-11 22:17:23] [INFO]   -> Set field 'timedispatch' = "2025-12-11 16:17:16"
[2025-12-11 22:17:23] [INFO] Mapping #21: Extracting 'EventUnits.Unit[0].EnRouteTime' => 'timeenroutetoscene'
[2025-12-11 22:17:23] [INFO]   -> No value found (null or empty)
[2025-12-11 22:17:23] [INFO] Mapping #22: Extracting 'EventUnits.Unit[0].ArriveTime' => 'timeonscene'
[2025-12-11 22:17:23] [INFO]   -> No value found (null or empty)
[2025-12-11 22:17:23] [INFO] Mapping #23: Extracting 'EventUnits.Unit[0].ReturnToServiceTime' => 'timeunitclear'
[2025-12-11 22:17:23] [INFO]   -> No value found (null or empty)
[2025-12-11 22:17:23] [INFO] Mapping #24: Extracting 'EventUnits.Unit[0].CancelTime' => 'timecanceledenroute'
[2025-12-11 22:17:23] [INFO]   -> No value found (null or empty)
[2025-12-11 22:17:23] [INFO] Mapping #25: Extracting 'EventDetails.CadInciNumber' => 'policeReportNumber'
[2025-12-11 22:17:23] [INFO] Found 4 elements for 'CadInciNumber', concatenating 4 non-empty values
[2025-12-11 22:17:23] [INFO]   -> Found value: 20250136128
20250136126
20250136127
20250136129
[2025-12-11 22:17:23] [INFO]   -> Set field 'policeReportNumber' = "20250136128\n20250136126\n20250136127\n20250136129"
[2025-12-11 22:17:23] [INFO] Finished extracting fields. Total fields extracted: 17
[2025-12-11 22:17:23] [INFO] Built locationCoordinates from lat/lng: 36.13401,-85.69302
[2025-12-11 22:17:23] [INFO] Extracted parsing rules data: {"cADAgencyIdentifier":"PCFD\nEMS\nPCSO\nRESC","incidentInternalId":"2025003032\n2025019254","dispatchRunNumber":"2025003032\n2025019254","incidentTypeValue1":"UNCONSCIOUS","incidentLocationStreetNumber":2831,"streetName":"TIGHTFIT RD","incidentLocationCity":"BAXTER","incidentLocationStateName":"TN","nERISIncidentPostalCode":38544,"nERISIncidentLatitude":36.13401,"nERISIncidentLongitude":-85.69302,"alarm":"2025-12-11 16:16:53","dispatched":"2025-12-11 16:17:16","incidentLocationCross":"JARED RIDGE RD\/LOWETOWN RD","cADVehicleID":"PCFR","timedispatch":"2025-12-11 16:17:16","policeReportNumber":"20250136128\n20250136126\n20250136127\n20250136129","locationCoordinates":"36.13401,-85.69302"}
[2025-12-11 22:17:23] [INFO] Number of extracted fields: 18
[2025-12-11 22:17:23] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'PCFD
EMS
PCSO
RESC'
[2025-12-11 22:17:23] [INFO] Multi-agency routing check: CAD Agency ID = PCFD
EMS
PCSO
RESC, Assigned Agencies count = 1
[2025-12-11 22:17:23] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'PCFD
EMS
PCSO
RESC'
[2025-12-11 22:17:23] [WARNING] WARNING: No SAASClient found with cADAgencyIdentifier = 'PCFD
EMS
PCSO
RESC'
[2025-12-11 22:17:23] [INFO] FALLBACK: Using mailbox default saasclientId: 68eeb686225c40db4 (multi-agency routing attempted but failed)
[2025-12-11 22:17:23] [INFO] Final routing: saasclientId = 68eeb686225c40db4, dispatchStationsIds = ["68ffbebde83509b7c","68ffd433577d1ee1e","68ffbe83793eb4521","68eef9302d19f85fc","68ffbe45d3567d442","68ffbe0e8c5fa650f","68eef77e6a5b1e9d6","68ffbde067a9b162c","68ffbda5d8ebd5468","68ffbd6b1db8d8daa","68ffbd4220b20a872","68ffbcfb8b8911e4e","68eef6ffc8105af4e","68eeca5d553dc8756"]
[2025-12-11 22:17:23] [INFO] Found existing IncidentTypeMapping with ID: 693976706d4f7fb2e
[2025-12-11 22:17:23] [INFO] Found existing Dispatch with cADNumber '2025003032
2025019254', ID: 693b42f17d0727fbf - will update instead of create
[2025-12-11 22:17:23] [INFO] Updated existing Dispatches record with ID: 693b42f17d0727fbf
[2025-12-11 22:17:23] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136128_20251211_221722.XML
[2025-12-11 22:17:23] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136128_20251211_221722.XML
[2025-12-11 23:04:10] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136152_20251211_230410.XML
[2025-12-11 23:04:10] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136152_20251211_230410.XML for user: 68f1466aed072ad4a
[2025-12-11 23:04:10] [INFO] File size: 5764 bytes
[2025-12-11 23:04:11] [INFO] Created FTPFiles record with ID: 693b4deb173a7cc06
[2025-12-11 23:04:11] [INFO] About to extract fields from XML. File size: 5764 bytes
[2025-12-11 23:04:11] [INFO] Number of mappings: 25
[2025-12-11 23:04:11] [INFO] Starting XML parsing. Content length: 5764
[2025-12-11 23:04:11] [INFO] XML parsed successfully. Root element: CADExport
[2025-12-11 23:04:11] [INFO] Processing 25 field mappings
[2025-12-11 23:04:11] [INFO] Mapping #1: Extracting 'EventDetails.AgencyCode' => 'cADAgencyIdentifier'
[2025-12-11 23:04:11] [INFO] Found 3 elements for 'AgencyCode', concatenating 3 non-empty values
[2025-12-11 23:04:11] [INFO]   -> Found value: PCFD
EMS
RESC
[2025-12-11 23:04:11] [INFO]   -> Set field 'cADAgencyIdentifier' = "PCFD\nEMS\nRESC"
[2025-12-11 23:04:11] [INFO] Mapping #2: Extracting 'EventDetails.ReportNumber' => ["incidentInternalId","dispatchRunNumber"]
[2025-12-11 23:04:11] [INFO] Found 3 elements for 'ReportNumber', concatenating 1 non-empty values
[2025-12-11 23:04:11] [INFO]   -> Found value: 2025003033
[2025-12-11 23:04:11] [INFO]   -> Set field 'incidentInternalId' = "2025003033"
[2025-12-11 23:04:11] [INFO]   -> Set field 'dispatchRunNumber' = "2025003033"
[2025-12-11 23:04:11] [INFO] Mapping #3: Extracting 'EventDetails.NatureDescription' => 'incidentTypeValue1'
[2025-12-11 23:04:11] [INFO]   -> Found value: OB / PREGNANCY / CHILDBIRTH
[2025-12-11 23:04:11] [INFO]   -> Set field 'incidentTypeValue1' = "OB \/ PREGNANCY \/ CHILDBIRTH"
[2025-12-11 23:04:11] [INFO] Mapping #4: Extracting 'EventDetails.StreetNumber' => 'incidentLocationStreetNumber'
[2025-12-11 23:04:11] [INFO]   -> Found value: 1901
[2025-12-11 23:04:11] [INFO]   -> Set field 'incidentLocationStreetNumber' = 1901
[2025-12-11 23:04:11] [INFO] Mapping #5: Extracting 'RelatedNames.Name.StreetName' => 'streetName'
[2025-12-11 23:04:11] [INFO]   -> Found value: CANE CREEK RD
[2025-12-11 23:04:11] [INFO]   -> Set field 'streetName' = "CANE CREEK RD"
[2025-12-11 23:04:11] [INFO] Mapping #6: Extracting 'RelatedNames.Name.City' => 'incidentLocationCity'
[2025-12-11 23:04:11] [INFO]   -> Found value: COOKEVILLE
[2025-12-11 23:04:11] [INFO]   -> Set field 'incidentLocationCity' = "COOKEVILLE"
[2025-12-11 23:04:11] [INFO] Mapping #7: Extracting 'EventDetails.State' => 'incidentLocationStateName'
[2025-12-11 23:04:11] [INFO]   -> Found value: TN
[2025-12-11 23:04:11] [INFO]   -> Set field 'incidentLocationStateName' = "TN"
[2025-12-11 23:04:11] [INFO] Mapping #8: Extracting 'EventDetails.ZipCode' => 'nERISIncidentPostalCode'
[2025-12-11 23:04:11] [INFO]   -> Found value: 38506
[2025-12-11 23:04:11] [INFO]   -> Set field 'nERISIncidentPostalCode' = 38506
[2025-12-11 23:04:11] [INFO] Mapping #9: Extracting 'EventDetails.SiteName' => 'businessName'
[2025-12-11 23:04:11] [INFO]   -> No value found (null or empty)
[2025-12-11 23:04:11] [INFO] Mapping #10: Extracting 'EventDetails.ApartmentSuite' => 'incidentLocationApt'
[2025-12-11 23:04:11] [INFO]   -> Found value: 27
[2025-12-11 23:04:11] [INFO]   -> Set field 'incidentLocationApt' = 27
[2025-12-11 23:04:11] [INFO] Mapping #11: Extracting 'EventDetails.EventLatitude' => 'nERISIncidentLatitude'
[2025-12-11 23:04:11] [INFO]   -> Found value: 36.12644
[2025-12-11 23:04:11] [INFO]   -> Set field 'nERISIncidentLatitude' = 36.12644
[2025-12-11 23:04:11] [INFO] Mapping #12: Extracting 'EventDetails.EventLongitude' => 'nERISIncidentLongitude'
[2025-12-11 23:04:11] [INFO]   -> Found value: -85.56842
[2025-12-11 23:04:11] [INFO]   -> Set field 'nERISIncidentLongitude' = -85.56842
[2025-12-11 23:04:11] [INFO] Mapping #13: Extracting 'EventDetails.EventStartTime' => 'alarm'
[2025-12-11 23:04:11] [INFO]   -> Found value: 2025-12-11 17:03:19
[2025-12-11 23:04:11] [INFO]   -> Set field 'alarm' = "2025-12-11 17:03:19"
[2025-12-11 23:04:11] [INFO] Mapping #14: Extracting 'EventDetails.FirstDispatchTime' => 'dispatched'
[2025-12-11 23:04:11] [INFO]   -> Found value: 2025-12-11 17:04:02
[2025-12-11 23:04:11] [INFO]   -> Set field 'dispatched' = "2025-12-11 17:04:02"
[2025-12-11 23:04:11] [INFO] Mapping #15: Extracting 'EventDetails.FirstEnrouteTime' => 'enroute'
[2025-12-11 23:04:11] [INFO]   -> No value found (null or empty)
[2025-12-11 23:04:11] [INFO] Mapping #16: Extracting 'EventDetails.FirstOnSceneTime' => 'onScene'
[2025-12-11 23:04:11] [INFO]   -> No value found (null or empty)
[2025-12-11 23:04:11] [INFO] Mapping #17: Extracting 'EventDetails.LastUnitClearTime' => ["cleared","inService"]
[2025-12-11 23:04:11] [INFO]   -> No value found (null or empty)
[2025-12-11 23:04:11] [INFO] Mapping #18: Extracting 'EventDetails.CrossStreets' => 'incidentLocationCross'
[2025-12-11 23:04:11] [INFO]   -> Found value: LEE SEMINARY RD/HERBERT GARRETT RD
[2025-12-11 23:04:11] [INFO]   -> Set field 'incidentLocationCross' = "LEE SEMINARY RD\/HERBERT GARRETT RD"
[2025-12-11 23:04:11] [INFO] Mapping #19: Extracting 'EventUnits.Unit[0].UnitCode' => 'cADVehicleID'
[2025-12-11 23:04:11] [INFO]   -> Found value: PCFR
[2025-12-11 23:04:11] [INFO]   -> Set field 'cADVehicleID' = "PCFR"
[2025-12-11 23:04:11] [INFO] Mapping #20: Extracting 'EventUnits.Unit[0].DispatchTime' => 'timedispatch'
[2025-12-11 23:04:11] [INFO]   -> Found value: 2025-12-11 17:04:02
[2025-12-11 23:04:11] [INFO]   -> Set field 'timedispatch' = "2025-12-11 17:04:02"
[2025-12-11 23:04:11] [INFO] Mapping #21: Extracting 'EventUnits.Unit[0].EnRouteTime' => 'timeenroutetoscene'
[2025-12-11 23:04:11] [INFO]   -> No value found (null or empty)
[2025-12-11 23:04:11] [INFO] Mapping #22: Extracting 'EventUnits.Unit[0].ArriveTime' => 'timeonscene'
[2025-12-11 23:04:11] [INFO]   -> No value found (null or empty)
[2025-12-11 23:04:11] [INFO] Mapping #23: Extracting 'EventUnits.Unit[0].ReturnToServiceTime' => 'timeunitclear'
[2025-12-11 23:04:11] [INFO]   -> No value found (null or empty)
[2025-12-11 23:04:11] [INFO] Mapping #24: Extracting 'EventUnits.Unit[0].CancelTime' => 'timecanceledenroute'
[2025-12-11 23:04:11] [INFO]   -> No value found (null or empty)
[2025-12-11 23:04:11] [INFO] Mapping #25: Extracting 'EventDetails.CadInciNumber' => 'policeReportNumber'
[2025-12-11 23:04:11] [INFO] Found 3 elements for 'CadInciNumber', concatenating 3 non-empty values
[2025-12-11 23:04:11] [INFO]   -> Found value: 20250136152
20250136151
20250136153
[2025-12-11 23:04:11] [INFO]   -> Set field 'policeReportNumber' = "20250136152\n20250136151\n20250136153"
[2025-12-11 23:04:11] [INFO] Finished extracting fields. Total fields extracted: 18
[2025-12-11 23:04:11] [INFO] Built locationCoordinates from lat/lng: 36.12644,-85.56842
[2025-12-11 23:04:11] [INFO] Extracted parsing rules data: {"cADAgencyIdentifier":"PCFD\nEMS\nRESC","incidentInternalId":"2025003033","dispatchRunNumber":"2025003033","incidentTypeValue1":"OB \/ PREGNANCY \/ CHILDBIRTH","incidentLocationStreetNumber":1901,"streetName":"CANE CREEK RD","incidentLocationCity":"COOKEVILLE","incidentLocationStateName":"TN","nERISIncidentPostalCode":38506,"incidentLocationApt":27,"nERISIncidentLatitude":36.12644,"nERISIncidentLongitude":-85.56842,"alarm":"2025-12-11 17:03:19","dispatched":"2025-12-11 17:04:02","incidentLocationCross":"LEE SEMINARY RD\/HERBERT GARRETT RD","cADVehicleID":"PCFR","timedispatch":"2025-12-11 17:04:02","policeReportNumber":"20250136152\n20250136151\n20250136153","locationCoordinates":"36.12644,-85.56842"}
[2025-12-11 23:04:11] [INFO] Number of extracted fields: 19
[2025-12-11 23:04:11] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'PCFD
EMS
RESC'
[2025-12-11 23:04:11] [INFO] Multi-agency routing check: CAD Agency ID = PCFD
EMS
RESC, Assigned Agencies count = 1
[2025-12-11 23:04:11] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'PCFD
EMS
RESC'
[2025-12-11 23:04:11] [WARNING] WARNING: No SAASClient found with cADAgencyIdentifier = 'PCFD
EMS
RESC'
[2025-12-11 23:04:11] [INFO] FALLBACK: Using mailbox default saasclientId: 68eeb686225c40db4 (multi-agency routing attempted but failed)
[2025-12-11 23:04:11] [INFO] Final routing: saasclientId = 68eeb686225c40db4, dispatchStationsIds = ["68ffbebde83509b7c","68ffd433577d1ee1e","68ffbe83793eb4521","68eef9302d19f85fc","68ffbe45d3567d442","68ffbe0e8c5fa650f","68eef77e6a5b1e9d6","68ffbde067a9b162c","68ffbda5d8ebd5468","68ffbd6b1db8d8daa","68ffbd4220b20a872","68ffbcfb8b8911e4e","68eef6ffc8105af4e","68eeca5d553dc8756"]
[2025-12-11 23:04:11] [INFO] Created new IncidentTypeMapping Data: {"cADIncidentType":"OB \/ PREGNANCY \/ CHILDBIRTH","saasclientId":"68eeb686225c40db4","name":"OB \/ PREGNANCY \/ CHILDBIRTH"}
[2025-12-11 23:04:11] [INFO] Created new IncidentTypeMapping with ID: 693b4deb460a12ff3
[2025-12-11 23:04:12] [INFO] Created new Dispatches record with ID: 693b4deb6098b9a6f
[2025-12-11 23:04:12] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136152_20251211_230410.XML
[2025-12-11 23:04:12] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136152_20251211_230410.XML
[2025-12-11 23:04:12] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136152_20251211_230412.XML
[2025-12-11 23:04:12] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136152_20251211_230412.XML for user: 68f1466aed072ad4a
[2025-12-11 23:04:12] [INFO] File size: 5764 bytes
[2025-12-11 23:04:13] [INFO] Created FTPFiles record with ID: 693b4ded1596e4232
[2025-12-11 23:04:13] [INFO] About to extract fields from XML. File size: 5764 bytes
[2025-12-11 23:04:13] [INFO] Number of mappings: 25
[2025-12-11 23:04:13] [INFO] Starting XML parsing. Content length: 5764
[2025-12-11 23:04:13] [INFO] XML parsed successfully. Root element: CADExport
[2025-12-11 23:04:13] [INFO] Processing 25 field mappings
[2025-12-11 23:04:13] [INFO] Mapping #1: Extracting 'EventDetails.AgencyCode' => 'cADAgencyIdentifier'
[2025-12-11 23:04:13] [INFO] Found 3 elements for 'AgencyCode', concatenating 3 non-empty values
[2025-12-11 23:04:13] [INFO]   -> Found value: PCFD
EMS
RESC
[2025-12-11 23:04:13] [INFO]   -> Set field 'cADAgencyIdentifier' = "PCFD\nEMS\nRESC"
[2025-12-11 23:04:13] [INFO] Mapping #2: Extracting 'EventDetails.ReportNumber' => ["incidentInternalId","dispatchRunNumber"]
[2025-12-11 23:04:13] [INFO] Found 3 elements for 'ReportNumber', concatenating 1 non-empty values
[2025-12-11 23:04:13] [INFO]   -> Found value: 2025003033
[2025-12-11 23:04:13] [INFO]   -> Set field 'incidentInternalId' = "2025003033"
[2025-12-11 23:04:13] [INFO]   -> Set field 'dispatchRunNumber' = "2025003033"
[2025-12-11 23:04:13] [INFO] Mapping #3: Extracting 'EventDetails.NatureDescription' => 'incidentTypeValue1'
[2025-12-11 23:04:13] [INFO]   -> Found value: OB / PREGNANCY / CHILDBIRTH
[2025-12-11 23:04:13] [INFO]   -> Set field 'incidentTypeValue1' = "OB \/ PREGNANCY \/ CHILDBIRTH"
[2025-12-11 23:04:13] [INFO] Mapping #4: Extracting 'EventDetails.StreetNumber' => 'incidentLocationStreetNumber'
[2025-12-11 23:04:13] [INFO]   -> Found value: 1901
[2025-12-11 23:04:13] [INFO]   -> Set field 'incidentLocationStreetNumber' = 1901
[2025-12-11 23:04:13] [INFO] Mapping #5: Extracting 'RelatedNames.Name.StreetName' => 'streetName'
[2025-12-11 23:04:13] [INFO]   -> Found value: CANE CREEK RD
[2025-12-11 23:04:13] [INFO]   -> Set field 'streetName' = "CANE CREEK RD"
[2025-12-11 23:04:13] [INFO] Mapping #6: Extracting 'RelatedNames.Name.City' => 'incidentLocationCity'
[2025-12-11 23:04:13] [INFO]   -> Found value: COOKEVILLE
[2025-12-11 23:04:13] [INFO]   -> Set field 'incidentLocationCity' = "COOKEVILLE"
[2025-12-11 23:04:13] [INFO] Mapping #7: Extracting 'EventDetails.State' => 'incidentLocationStateName'
[2025-12-11 23:04:13] [INFO]   -> Found value: TN
[2025-12-11 23:04:13] [INFO]   -> Set field 'incidentLocationStateName' = "TN"
[2025-12-11 23:04:13] [INFO] Mapping #8: Extracting 'EventDetails.ZipCode' => 'nERISIncidentPostalCode'
[2025-12-11 23:04:13] [INFO]   -> Found value: 38506
[2025-12-11 23:04:13] [INFO]   -> Set field 'nERISIncidentPostalCode' = 38506
[2025-12-11 23:04:13] [INFO] Mapping #9: Extracting 'EventDetails.SiteName' => 'businessName'
[2025-12-11 23:04:13] [INFO]   -> No value found (null or empty)
[2025-12-11 23:04:13] [INFO] Mapping #10: Extracting 'EventDetails.ApartmentSuite' => 'incidentLocationApt'
[2025-12-11 23:04:13] [INFO]   -> Found value: 27
[2025-12-11 23:04:13] [INFO]   -> Set field 'incidentLocationApt' = 27
[2025-12-11 23:04:13] [INFO] Mapping #11: Extracting 'EventDetails.EventLatitude' => 'nERISIncidentLatitude'
[2025-12-11 23:04:13] [INFO]   -> Found value: 36.12644
[2025-12-11 23:04:13] [INFO]   -> Set field 'nERISIncidentLatitude' = 36.12644
[2025-12-11 23:04:13] [INFO] Mapping #12: Extracting 'EventDetails.EventLongitude' => 'nERISIncidentLongitude'
[2025-12-11 23:04:13] [INFO]   -> Found value: -85.56842
[2025-12-11 23:04:13] [INFO]   -> Set field 'nERISIncidentLongitude' = -85.56842
[2025-12-11 23:04:13] [INFO] Mapping #13: Extracting 'EventDetails.EventStartTime' => 'alarm'
[2025-12-11 23:04:13] [INFO]   -> Found value: 2025-12-11 17:03:19
[2025-12-11 23:04:13] [INFO]   -> Set field 'alarm' = "2025-12-11 17:03:19"
[2025-12-11 23:04:13] [INFO] Mapping #14: Extracting 'EventDetails.FirstDispatchTime' => 'dispatched'
[2025-12-11 23:04:13] [INFO]   -> Found value: 2025-12-11 17:04:02
[2025-12-11 23:04:13] [INFO]   -> Set field 'dispatched' = "2025-12-11 17:04:02"
[2025-12-11 23:04:13] [INFO] Mapping #15: Extracting 'EventDetails.FirstEnrouteTime' => 'enroute'
[2025-12-11 23:04:13] [INFO]   -> No value found (null or empty)
[2025-12-11 23:04:13] [INFO] Mapping #16: Extracting 'EventDetails.FirstOnSceneTime' => 'onScene'
[2025-12-11 23:04:13] [INFO]   -> No value found (null or empty)
[2025-12-11 23:04:13] [INFO] Mapping #17: Extracting 'EventDetails.LastUnitClearTime' => ["cleared","inService"]
[2025-12-11 23:04:13] [INFO]   -> No value found (null or empty)
[2025-12-11 23:04:13] [INFO] Mapping #18: Extracting 'EventDetails.CrossStreets' => 'incidentLocationCross'
[2025-12-11 23:04:13] [INFO]   -> Found value: LEE SEMINARY RD/HERBERT GARRETT RD
[2025-12-11 23:04:13] [INFO]   -> Set field 'incidentLocationCross' = "LEE SEMINARY RD\/HERBERT GARRETT RD"
[2025-12-11 23:04:13] [INFO] Mapping #19: Extracting 'EventUnits.Unit[0].UnitCode' => 'cADVehicleID'
[2025-12-11 23:04:13] [INFO]   -> Found value: PCFR
[2025-12-11 23:04:13] [INFO]   -> Set field 'cADVehicleID' = "PCFR"
[2025-12-11 23:04:13] [INFO] Mapping #20: Extracting 'EventUnits.Unit[0].DispatchTime' => 'timedispatch'
[2025-12-11 23:04:13] [INFO]   -> Found value: 2025-12-11 17:04:02
[2025-12-11 23:04:13] [INFO]   -> Set field 'timedispatch' = "2025-12-11 17:04:02"
[2025-12-11 23:04:13] [INFO] Mapping #21: Extracting 'EventUnits.Unit[0].EnRouteTime' => 'timeenroutetoscene'
[2025-12-11 23:04:13] [INFO]   -> No value found (null or empty)
[2025-12-11 23:04:13] [INFO] Mapping #22: Extracting 'EventUnits.Unit[0].ArriveTime' => 'timeonscene'
[2025-12-11 23:04:13] [INFO]   -> No value found (null or empty)
[2025-12-11 23:04:13] [INFO] Mapping #23: Extracting 'EventUnits.Unit[0].ReturnToServiceTime' => 'timeunitclear'
[2025-12-11 23:04:13] [INFO]   -> No value found (null or empty)
[2025-12-11 23:04:13] [INFO] Mapping #24: Extracting 'EventUnits.Unit[0].CancelTime' => 'timecanceledenroute'
[2025-12-11 23:04:13] [INFO]   -> No value found (null or empty)
[2025-12-11 23:04:13] [INFO] Mapping #25: Extracting 'EventDetails.CadInciNumber' => 'policeReportNumber'
[2025-12-11 23:04:13] [INFO] Found 3 elements for 'CadInciNumber', concatenating 3 non-empty values
[2025-12-11 23:04:13] [INFO]   -> Found value: 20250136152
20250136151
20250136153
[2025-12-11 23:04:13] [INFO]   -> Set field 'policeReportNumber' = "20250136152\n20250136151\n20250136153"
[2025-12-11 23:04:13] [INFO] Finished extracting fields. Total fields extracted: 18
[2025-12-11 23:04:13] [INFO] Built locationCoordinates from lat/lng: 36.12644,-85.56842
[2025-12-11 23:04:13] [INFO] Extracted parsing rules data: {"cADAgencyIdentifier":"PCFD\nEMS\nRESC","incidentInternalId":"2025003033","dispatchRunNumber":"2025003033","incidentTypeValue1":"OB \/ PREGNANCY \/ CHILDBIRTH","incidentLocationStreetNumber":1901,"streetName":"CANE CREEK RD","incidentLocationCity":"COOKEVILLE","incidentLocationStateName":"TN","nERISIncidentPostalCode":38506,"incidentLocationApt":27,"nERISIncidentLatitude":36.12644,"nERISIncidentLongitude":-85.56842,"alarm":"2025-12-11 17:03:19","dispatched":"2025-12-11 17:04:02","incidentLocationCross":"LEE SEMINARY RD\/HERBERT GARRETT RD","cADVehicleID":"PCFR","timedispatch":"2025-12-11 17:04:02","policeReportNumber":"20250136152\n20250136151\n20250136153","locationCoordinates":"36.12644,-85.56842"}
[2025-12-11 23:04:13] [INFO] Number of extracted fields: 19
[2025-12-11 23:04:13] [INFO] MULTI-AGENCY: Extracted cADAgencyIdentifier = 'PCFD
EMS
RESC'
[2025-12-11 23:04:13] [INFO] Multi-agency routing check: CAD Agency ID = PCFD
EMS
RESC, Assigned Agencies count = 1
[2025-12-11 23:04:13] [INFO] Multi-agency mode detected. Looking up SAASClient by cADAgencyIdentifier: 'PCFD
EMS
RESC'
[2025-12-11 23:04:13] [WARNING] WARNING: No SAASClient found with cADAgencyIdentifier = 'PCFD
EMS
RESC'
[2025-12-11 23:04:13] [INFO] FALLBACK: Using mailbox default saasclientId: 68eeb686225c40db4 (multi-agency routing attempted but failed)
[2025-12-11 23:04:13] [INFO] Final routing: saasclientId = 68eeb686225c40db4, dispatchStationsIds = ["68ffbebde83509b7c","68ffd433577d1ee1e","68ffbe83793eb4521","68eef9302d19f85fc","68ffbe45d3567d442","68ffbe0e8c5fa650f","68eef77e6a5b1e9d6","68ffbde067a9b162c","68ffbda5d8ebd5468","68ffbd6b1db8d8daa","68ffbd4220b20a872","68ffbcfb8b8911e4e","68eef6ffc8105af4e","68eeca5d553dc8756"]
[2025-12-11 23:04:13] [INFO] Found existing IncidentTypeMapping with ID: 693b4deb460a12ff3
[2025-12-11 23:04:13] [INFO] Found existing Dispatch with cADNumber '2025003033', ID: 693b4deb6098b9a6f - will update instead of create
[2025-12-11 23:04:13] [INFO] Updated existing Dispatches record with ID: 693b4deb6098b9a6f
[2025-12-11 23:04:13] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136152_20251211_230412.XML
[2025-12-11 23:04:13] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68f1466aed072ad4a/PCFD_20250136152_20251211_230412.XML