[2025-10-08 01:26:11] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23033.xml
[2025-10-08 01:26:11] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23033.xml for user: 68d56363ec1209189
[2025-10-08 01:26:11] [INFO] File size: 1941 bytes
[2025-10-08 01:26:11] [INFO] Created FTPFiles record with ID: 68e5bdb33a3e78a03
[2025-10-08 01:26:38] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23033.xml
[2025-10-08 01:26:38] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23033.xml for user: 68d56363ec1209189
[2025-10-08 01:26:38] [INFO] File size: 1941 bytes
[2025-10-08 01:26:38] [INFO] Created FTPFiles record with ID: 68e5bdcec38dbe74a
[2025-10-08 10:32:50] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23033.xml
[2025-10-08 10:32:50] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23033.xml for user: 68d56363ec1209189
[2025-10-08 10:32:50] [INFO] File size: 1941 bytes
[2025-10-08 10:32:51] [INFO] Created FTPFiles record with ID: 68e63dd331e5ad32e
[2025-10-08 10:32:51] [INFO] WE ARE HERE 
[2025-10-08 10:35:07] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23033.xml
[2025-10-08 10:35:07] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23033.xml for user: 68d56363ec1209189
[2025-10-08 10:35:07] [INFO] File size: 1941 bytes
[2025-10-08 10:35:07] [INFO] Created FTPFiles record with ID: 68e63e5b2bf1ced0c
[2025-10-08 10:35:07] [INFO] WE ARE HERE {"mappings":{"IncidentNumber":"dispatchRunNumber","house_number":"incidentLocationStreetNumber","street":"streetName","apt":"incidentLocationApt","city":"incidentLocationCity","location_name":"businessName","STATE":"incidentLocationStateName","ZIPCODE":"nERISIncidentPostalCode","LATITUDE":"nERISIncidentLatitude","LONGITUDE":"nERISIncidentLongitude","incident_type":"incidentTypeValue1","commentlist.comment":"dispatchNotes","time_first_unit_assigned":["alarm","dispatched"],"time_first_unit_enroute":"enroute","time_first_unit_arrived":"onScene","time_last_unit_cleared":["cleared","inService"]},"selectedRecord":{"id":"68e3d5db09560f860","name":null},"fieldExamples":{"IncidentNumber":{"name":"IncidentNumber","value":"25-23001","type":"text"},"house_number":{"name":"house_number","value":"110","type":"number"},"street":{"name":"street","value":"WILLIAM ST","type":"address"},"apt":{"name":"apt","value":"Array","type":"text"},"city":{"name":"city","value":"Array","type":"address"},"location_name":{"name":"location_name","value":"Array","type":"text"},"STATE":{"name":"STATE","value":"Array","type":"address"},"ZIPCODE":{"name":"ZIPCODE","value":"Array","type":"address"},"LATITUDE":{"name":"LATITUDE","value":"0","type":"coordinate"},"LONGITUDE":{"name":"LONGITUDE","value":"0","type":"coordinate"},"incident_type":{"name":"incident_type","value":"FIRE-GAS LEAK","type":"text"},"commentlist.comment":{"name":"comment","value":"10-06-2025 12:37:49|RP ADVISED WAS ATTEMPTING TO TURN ON STOVE, STRONG ODER OF GAS \n\n\nJOH MCOOLEY 573-620-1861 10-06-2025 12:40:34|PAGED 10-06-2025 12:42:51|LIBERTY HAS BEEN CONTACTED 10-06-2025 12:42:57|566 ADVISED ON SCENE, ADVISED ATTEMPTING TO LOCATE SORCE 10-06-2025 12:44:00|566 ADVISED STRONG ODER COMING FROM GAS LINE TO STOVE 10-06-2025 12:45:44|C86 ADVISED HAS COMMAND OF SCENE 10-06-2025 12:53:21|GAS IS SHUT OFF FROM STOVE, GAS COMPANY IS RESPONDING TO ADDRESS ","type":"text"},"time_first_unit_assigned":{"name":"time_first_unit_assigned","value":"10-06-2025T12:40:07","type":"datetime"},"time_first_unit_enroute":{"name":"time_first_unit_enroute","value":"10-06-2025T12:40:23","type":"datetime"},"time_first_unit_arrived":{"name":"time_first_unit_arrived","value":"10-06-2025T12:43:01","type":"datetime"},"time_last_unit_cleared":{"name":"time_last_unit_cleared","value":"10-06-2025T12:53:26","type":"datetime"}},"timestamp":"2025-10-06T18:05:45.194Z"}
[2025-10-08 12:24:34] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23033.xml
[2025-10-08 12:24:34] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23033.xml for user: 68d56363ec1209189
[2025-10-08 12:24:34] [INFO] File size: 1941 bytes
[2025-10-08 12:24:34] [INFO] Created FTPFiles record with ID: 68e658029ec527d28
[2025-10-08 12:24:34] [INFO] WE ARE HERE {"mappings":{"IncidentNumber":"dispatchRunNumber","house_number":"incidentLocationStreetNumber","street":"streetName","apt":"incidentLocationApt","city":"incidentLocationCity","location_name":"businessName","STATE":"incidentLocationStateName","ZIPCODE":"nERISIncidentPostalCode","LATITUDE":"nERISIncidentLatitude","LONGITUDE":"nERISIncidentLongitude","incident_type":"incidentTypeValue1","commentlist.comment":"dispatchNotes","time_first_unit_assigned":["alarm","dispatched"],"time_first_unit_enroute":"enroute","time_first_unit_arrived":"onScene","time_last_unit_cleared":["cleared","inService"]},"selectedRecord":{"id":"68e3d5db09560f860","name":null},"fieldExamples":{"IncidentNumber":{"name":"IncidentNumber","value":"25-23001","type":"text"},"house_number":{"name":"house_number","value":"110","type":"number"},"street":{"name":"street","value":"WILLIAM ST","type":"address"},"apt":{"name":"apt","value":"Array","type":"text"},"city":{"name":"city","value":"Array","type":"address"},"location_name":{"name":"location_name","value":"Array","type":"text"},"STATE":{"name":"STATE","value":"Array","type":"address"},"ZIPCODE":{"name":"ZIPCODE","value":"Array","type":"address"},"LATITUDE":{"name":"LATITUDE","value":"0","type":"coordinate"},"LONGITUDE":{"name":"LONGITUDE","value":"0","type":"coordinate"},"incident_type":{"name":"incident_type","value":"FIRE-GAS LEAK","type":"text"},"commentlist.comment":{"name":"comment","value":"10-06-2025 12:37:49|RP ADVISED WAS ATTEMPTING TO TURN ON STOVE, STRONG ODER OF GAS \n\n\nJOH MCOOLEY 573-620-1861 10-06-2025 12:40:34|PAGED 10-06-2025 12:42:51|LIBERTY HAS BEEN CONTACTED 10-06-2025 12:42:57|566 ADVISED ON SCENE, ADVISED ATTEMPTING TO LOCATE SORCE 10-06-2025 12:44:00|566 ADVISED STRONG ODER COMING FROM GAS LINE TO STOVE 10-06-2025 12:45:44|C86 ADVISED HAS COMMAND OF SCENE 10-06-2025 12:53:21|GAS IS SHUT OFF FROM STOVE, GAS COMPANY IS RESPONDING TO ADDRESS ","type":"text"},"time_first_unit_assigned":{"name":"time_first_unit_assigned","value":"10-06-2025T12:40:07","type":"datetime"},"time_first_unit_enroute":{"name":"time_first_unit_enroute","value":"10-06-2025T12:40:23","type":"datetime"},"time_first_unit_arrived":{"name":"time_first_unit_arrived","value":"10-06-2025T12:43:01","type":"datetime"},"time_last_unit_cleared":{"name":"time_last_unit_cleared","value":"10-06-2025T12:53:26","type":"datetime"}},"timestamp":"2025-10-06T18:05:45.194Z"}
[2025-10-08 12:24:34] [INFO] About to extract fields from XML. File size: 1941 bytes
[2025-10-08 12:24:34] [INFO] Number of mappings: 16
[2025-10-08 12:24:34] [INFO] Starting XML parsing. Content length: 1941
[2025-10-08 12:24:34] [INFO] XML parsed successfully. Root element: Incident
[2025-10-08 12:24:34] [INFO] Processing 16 field mappings
[2025-10-08 12:24:34] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-10-08 12:24:34] [INFO]   -> Found value: 25-23033
[2025-10-08 12:24:34] [INFO]   -> Set field 'dispatchRunNumber' = "25-23033"
[2025-10-08 12:24:34] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-10-08 12:24:34] [INFO]   -> No value found (null or empty)
[2025-10-08 12:24:34] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-10-08 12:24:34] [INFO]   -> Found value: HWY 60
[2025-10-08 12:24:34] [INFO]   -> Set field 'streetName' = "HWY 60"
[2025-10-08 12:24:34] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-10-08 12:24:34] [INFO]   -> No value found (null or empty)
[2025-10-08 12:24:34] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-10-08 12:24:34] [INFO]   -> Found value: SIKESTON
[2025-10-08 12:24:34] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-10-08 12:24:34] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-10-08 12:24:34] [INFO]   -> No value found (null or empty)
[2025-10-08 12:24:34] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-10-08 12:24:34] [INFO]   -> Found value: MO
[2025-10-08 12:24:34] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-10-08 12:24:34] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-10-08 12:24:34] [INFO]   -> Found value: 63801
[2025-10-08 12:24:34] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-10-08 12:24:34] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-10-08 12:24:34] [INFO]   -> Found value: 0
[2025-10-08 12:24:34] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-10-08 12:24:34] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-10-08 12:24:34] [INFO]   -> Found value: 0
[2025-10-08 12:24:34] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-10-08 12:24:34] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-10-08 12:24:34] [INFO]   -> Found value: RESCUE
[2025-10-08 12:24:34] [INFO]   -> Set field 'incidentTypeValue1' = "RESCUE"
[2025-10-08 12:24:34] [INFO] Mapping #12: Extracting 'commentlist.comment' => 'dispatchNotes'
[2025-10-08 12:24:34] [INFO]   -> Found value: 10-06-2025 18:27:21|10-50 - 2 VEHICLES INVOLVED
POSSIBLY 2 FEMALES ENTRAPPED
UNKNOWN INJURY
NMCO EMS...
[2025-10-08 12:24:34] [INFO]   -> Set field 'dispatchNotes' = "10-06-2025 18:27:21|10-50 - 2 VEHICLES INVOLVED\nPOSSIBLY 2 FEMALES ENTRAPPED\nUNKNOWN INJURY\nNMCO EMS EN ROUTE 10-06-2025 18:29:32|PAGED 10-06-2025 18:32:09|553 ON SCENE 10-06-2025 18:33:36|PER 553 CANCEL ALL UNITS EXCEPT RESCUE TRUCK  NO ENTRAPMENT 10-06-2025 18:33:38|C90 EN ROUTE 10-06-2025 18:34:57|NMCO CONTACTED AND ADVISED TO CANCEL RESCURE"
[2025-10-08 12:24:34] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-10-08 12:24:34] [INFO]   -> Found value: 10-06-2025T18:30:38
[2025-10-08 12:24:34] [INFO]   -> Set field 'alarm' = "2025-06-10 18:30:38"
[2025-10-08 12:24:34] [INFO]   -> Set field 'dispatched' = "2025-06-10 18:30:38"
[2025-10-08 12:24:34] [INFO] Mapping #14: Extracting 'time_first_unit_enroute' => 'enroute'
[2025-10-08 12:24:34] [INFO]   -> Found value: 10-06-2025T18:30:38
[2025-10-08 12:24:34] [INFO]   -> Set field 'enroute' = "2025-06-10 18:30:38"
[2025-10-08 12:24:34] [INFO] Mapping #15: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-10-08 12:24:34] [INFO]   -> Found value: 10-06-2025T18:36:08
[2025-10-08 12:24:34] [INFO]   -> Set field 'onScene' = "2025-06-10 18:36:08"
[2025-10-08 12:24:34] [INFO] Mapping #16: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-10-08 12:24:34] [INFO]   -> Found value: 10-06-2025T19:33:02
[2025-10-08 12:24:34] [INFO]   -> Set field 'cleared' = "2025-06-10 19:33:02"
[2025-10-08 12:24:34] [INFO]   -> Set field 'inService' = "2025-06-10 19:33:02"
[2025-10-08 12:24:34] [INFO] Finished extracting fields. Total fields extracted: 15
[2025-10-08 12:24:34] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-23033","streetName":"HWY 60","incidentLocationCity":"SIKESTON","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"RESCUE","dispatchNotes":"10-06-2025 18:27:21|10-50 - 2 VEHICLES INVOLVED\nPOSSIBLY 2 FEMALES ENTRAPPED\nUNKNOWN INJURY\nNMCO EMS EN ROUTE 10-06-2025 18:29:32|PAGED 10-06-2025 18:32:09|553 ON SCENE 10-06-2025 18:33:36|PER 553 CANCEL ALL UNITS EXCEPT RESCUE TRUCK  NO ENTRAPMENT 10-06-2025 18:33:38|C90 EN ROUTE 10-06-2025 18:34:57|NMCO CONTACTED AND ADVISED TO CANCEL RESCURE","alarm":"2025-06-10 18:30:38","dispatched":"2025-06-10 18:30:38","enroute":"2025-06-10 18:30:38","onScene":"2025-06-10 18:36:08","cleared":"2025-06-10 19:33:02","inService":"2025-06-10 19:33:02"}
[2025-10-08 12:24:34] [INFO] Number of extracted fields: 15
[2025-10-08 12:24:34] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e86df03b7f
[2025-10-08 12:24:35] [INFO] Created Dispatches record with ID: 68e65802c3fe20dd3
[2025-10-08 12:24:35] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23033.xml
[2025-10-08 12:24:35] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23033.xml
[2025-10-08 13:50:35] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23112.xml
[2025-10-08 13:50:35] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23112.xml for user: 68d56363ec1209189
[2025-10-08 13:50:35] [INFO] File size: 1909 bytes
[2025-10-08 13:50:35] [INFO] Created FTPFiles record with ID: 68e66c2b44caa3078
[2025-10-08 13:50:35] [INFO] WE ARE HERE {"mappings":{"IncidentNumber":"dispatchRunNumber","house_number":"incidentLocationStreetNumber","street":"streetName","apt":"incidentLocationApt","city":"incidentLocationCity","location_name":"businessName","STATE":"incidentLocationStateName","ZIPCODE":"nERISIncidentPostalCode","LATITUDE":"nERISIncidentLatitude","LONGITUDE":"nERISIncidentLongitude","incident_type":"incidentTypeValue1","commentlist.comment":"dispatchNotes","time_first_unit_assigned":["alarm","dispatched"],"time_first_unit_enroute":"enroute","time_first_unit_arrived":"onScene","time_last_unit_cleared":["cleared","inService"]},"selectedRecord":{"id":"68e3d5db09560f860","name":null},"fieldExamples":{"IncidentNumber":{"name":"IncidentNumber","value":"25-23001","type":"text"},"house_number":{"name":"house_number","value":"110","type":"number"},"street":{"name":"street","value":"WILLIAM ST","type":"address"},"apt":{"name":"apt","value":"Array","type":"text"},"city":{"name":"city","value":"Array","type":"address"},"location_name":{"name":"location_name","value":"Array","type":"text"},"STATE":{"name":"STATE","value":"Array","type":"address"},"ZIPCODE":{"name":"ZIPCODE","value":"Array","type":"address"},"LATITUDE":{"name":"LATITUDE","value":"0","type":"coordinate"},"LONGITUDE":{"name":"LONGITUDE","value":"0","type":"coordinate"},"incident_type":{"name":"incident_type","value":"FIRE-GAS LEAK","type":"text"},"commentlist.comment":{"name":"comment","value":"10-06-2025 12:37:49|RP ADVISED WAS ATTEMPTING TO TURN ON STOVE, STRONG ODER OF GAS \n\n\nJOH MCOOLEY 573-620-1861 10-06-2025 12:40:34|PAGED 10-06-2025 12:42:51|LIBERTY HAS BEEN CONTACTED 10-06-2025 12:42:57|566 ADVISED ON SCENE, ADVISED ATTEMPTING TO LOCATE SORCE 10-06-2025 12:44:00|566 ADVISED STRONG ODER COMING FROM GAS LINE TO STOVE 10-06-2025 12:45:44|C86 ADVISED HAS COMMAND OF SCENE 10-06-2025 12:53:21|GAS IS SHUT OFF FROM STOVE, GAS COMPANY IS RESPONDING TO ADDRESS ","type":"text"},"time_first_unit_assigned":{"name":"time_first_unit_assigned","value":"10-06-2025T12:40:07","type":"datetime"},"time_first_unit_enroute":{"name":"time_first_unit_enroute","value":"10-06-2025T12:40:23","type":"datetime"},"time_first_unit_arrived":{"name":"time_first_unit_arrived","value":"10-06-2025T12:43:01","type":"datetime"},"time_last_unit_cleared":{"name":"time_last_unit_cleared","value":"10-06-2025T12:53:26","type":"datetime"}},"timestamp":"2025-10-06T18:05:45.194Z"}
[2025-10-08 13:50:35] [INFO] About to extract fields from XML. File size: 1909 bytes
[2025-10-08 13:50:35] [INFO] Number of mappings: 16
[2025-10-08 13:50:35] [INFO] Starting XML parsing. Content length: 1909
[2025-10-08 13:50:35] [INFO] XML parsed successfully. Root element: Incident
[2025-10-08 13:50:35] [INFO] Processing 16 field mappings
[2025-10-08 13:50:35] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-10-08 13:50:35] [INFO]   -> Found value: 25-23112
[2025-10-08 13:50:35] [INFO]   -> Set field 'dispatchRunNumber' = "25-23112"
[2025-10-08 13:50:35] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-10-08 13:50:35] [INFO]   -> Found value: 75
[2025-10-08 13:50:35] [INFO]   -> Set field 'incidentLocationStreetNumber' = 75
[2025-10-08 13:50:35] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-10-08 13:50:35] [INFO]   -> Found value: HALIE LN
[2025-10-08 13:50:35] [INFO]   -> Set field 'streetName' = "HALIE LN"
[2025-10-08 13:50:35] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-10-08 13:50:35] [INFO]   -> No value found (null or empty)
[2025-10-08 13:50:35] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-10-08 13:50:35] [INFO]   -> Found value: SIKESTON
[2025-10-08 13:50:35] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-10-08 13:50:35] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-10-08 13:50:35] [INFO]   -> No value found (null or empty)
[2025-10-08 13:50:35] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-10-08 13:50:35] [INFO]   -> No value found (null or empty)
[2025-10-08 13:50:35] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-10-08 13:50:35] [INFO]   -> No value found (null or empty)
[2025-10-08 13:50:35] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-10-08 13:50:35] [INFO]   -> Found value: 0
[2025-10-08 13:50:35] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-10-08 13:50:35] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-10-08 13:50:35] [INFO]   -> Found value: 0
[2025-10-08 13:50:35] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-10-08 13:50:35] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-10-08 13:50:35] [INFO]   -> Found value: FIRE-OUT OF TOWN
[2025-10-08 13:50:35] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-OUT OF TOWN"
[2025-10-08 13:50:35] [INFO] Mapping #12: Extracting 'commentlist.comment' => 'dispatchNotes'
[2025-10-08 13:50:35] [INFO]   -> Found value: 10-08-2025 07:12:39|Call Received on 10/08/2025 @ 07:12

STRUCTURE FIRE 10-08-2025 07:15:57|SCOTT CO...
[2025-10-08 13:50:35] [INFO]   -> Set field 'dispatchNotes' = "10-08-2025 07:12:39|Call Received on 10\/08\/2025 @ 07:12\n\nSTRUCTURE FIRE 10-08-2025 07:15:57|SCOTT CO NOTIFIED 10-08-2025 07:23:08|MINER PD CONTACTED 10-08-2025 07:25:34|B45 STRUCTURE ON HAILY 10-08-2025 07:25:56|FULLY INVOLVED 10-08-2025 07:52:12|AMEREN NOTIFIED"
[2025-10-08 13:50:35] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-10-08 13:50:35] [INFO]   -> Found value: 10-08-2025T07:15:44
[2025-10-08 13:50:35] [INFO]   -> Set field 'alarm' = "2025-08-10 07:15:44"
[2025-10-08 13:50:35] [INFO]   -> Set field 'dispatched' = "2025-08-10 07:15:44"
[2025-10-08 13:50:35] [INFO] Mapping #14: Extracting 'time_first_unit_enroute' => 'enroute'
[2025-10-08 13:50:35] [INFO]   -> Found value: 10-08-2025T07:17:31
[2025-10-08 13:50:35] [INFO]   -> Set field 'enroute' = "2025-08-10 07:17:31"
[2025-10-08 13:50:35] [INFO] Mapping #15: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-10-08 13:50:35] [INFO]   -> Found value: 10-08-2025T07:26:34
[2025-10-08 13:50:35] [INFO]   -> Set field 'onScene' = "2025-08-10 07:26:34"
[2025-10-08 13:50:35] [INFO] Mapping #16: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-10-08 13:50:35] [INFO]   -> Found value: 10-08-2025T08:49:18
[2025-10-08 13:50:35] [INFO]   -> Set field 'cleared' = "2025-08-10 08:49:18"
[2025-10-08 13:50:35] [INFO]   -> Set field 'inService' = "2025-08-10 08:49:18"
[2025-10-08 13:50:35] [INFO] Finished extracting fields. Total fields extracted: 14
[2025-10-08 13:50:35] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-23112","incidentLocationStreetNumber":75,"streetName":"HALIE LN","incidentLocationCity":"SIKESTON","nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-OUT OF TOWN","dispatchNotes":"10-08-2025 07:12:39|Call Received on 10\/08\/2025 @ 07:12\n\nSTRUCTURE FIRE 10-08-2025 07:15:57|SCOTT CO NOTIFIED 10-08-2025 07:23:08|MINER PD CONTACTED 10-08-2025 07:25:34|B45 STRUCTURE ON HAILY 10-08-2025 07:25:56|FULLY INVOLVED 10-08-2025 07:52:12|AMEREN NOTIFIED","alarm":"2025-08-10 07:15:44","dispatched":"2025-08-10 07:15:44","enroute":"2025-08-10 07:17:31","onScene":"2025-08-10 07:26:34","cleared":"2025-08-10 08:49:18","inService":"2025-08-10 08:49:18"}
[2025-10-08 13:50:35] [INFO] Number of extracted fields: 14
[2025-10-08 13:50:35] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e878336f04
[2025-10-08 13:50:36] [INFO] Created Dispatches record with ID: 68e66c2b77eae2902
[2025-10-08 13:50:36] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23112.xml
[2025-10-08 13:50:36] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23112.xml
[2025-10-08 14:13:53] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23116.xml
[2025-10-08 14:13:53] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23116.xml for user: 68d56363ec1209189
[2025-10-08 14:13:53] [INFO] File size: 1543 bytes
[2025-10-08 14:13:54] [INFO] Created FTPFiles record with ID: 68e671a226697b8ea
[2025-10-08 14:13:54] [INFO] WE ARE HERE {"mappings":{"IncidentNumber":"dispatchRunNumber","house_number":"incidentLocationStreetNumber","street":"streetName","apt":"incidentLocationApt","city":"incidentLocationCity","location_name":"businessName","STATE":"incidentLocationStateName","ZIPCODE":"nERISIncidentPostalCode","LATITUDE":"nERISIncidentLatitude","LONGITUDE":"nERISIncidentLongitude","incident_type":"incidentTypeValue1","commentlist.comment":"dispatchNotes","time_first_unit_assigned":["alarm","dispatched"],"time_first_unit_enroute":"enroute","time_first_unit_arrived":"onScene","time_last_unit_cleared":["cleared","inService"]},"selectedRecord":{"id":"68e3d5db09560f860","name":null},"fieldExamples":{"IncidentNumber":{"name":"IncidentNumber","value":"25-23001","type":"text"},"house_number":{"name":"house_number","value":"110","type":"number"},"street":{"name":"street","value":"WILLIAM ST","type":"address"},"apt":{"name":"apt","value":"Array","type":"text"},"city":{"name":"city","value":"Array","type":"address"},"location_name":{"name":"location_name","value":"Array","type":"text"},"STATE":{"name":"STATE","value":"Array","type":"address"},"ZIPCODE":{"name":"ZIPCODE","value":"Array","type":"address"},"LATITUDE":{"name":"LATITUDE","value":"0","type":"coordinate"},"LONGITUDE":{"name":"LONGITUDE","value":"0","type":"coordinate"},"incident_type":{"name":"incident_type","value":"FIRE-GAS LEAK","type":"text"},"commentlist.comment":{"name":"comment","value":"10-06-2025 12:37:49|RP ADVISED WAS ATTEMPTING TO TURN ON STOVE, STRONG ODER OF GAS \n\n\nJOH MCOOLEY 573-620-1861 10-06-2025 12:40:34|PAGED 10-06-2025 12:42:51|LIBERTY HAS BEEN CONTACTED 10-06-2025 12:42:57|566 ADVISED ON SCENE, ADVISED ATTEMPTING TO LOCATE SORCE 10-06-2025 12:44:00|566 ADVISED STRONG ODER COMING FROM GAS LINE TO STOVE 10-06-2025 12:45:44|C86 ADVISED HAS COMMAND OF SCENE 10-06-2025 12:53:21|GAS IS SHUT OFF FROM STOVE, GAS COMPANY IS RESPONDING TO ADDRESS ","type":"text"},"time_first_unit_assigned":{"name":"time_first_unit_assigned","value":"10-06-2025T12:40:07","type":"datetime"},"time_first_unit_enroute":{"name":"time_first_unit_enroute","value":"10-06-2025T12:40:23","type":"datetime"},"time_first_unit_arrived":{"name":"time_first_unit_arrived","value":"10-06-2025T12:43:01","type":"datetime"},"time_last_unit_cleared":{"name":"time_last_unit_cleared","value":"10-06-2025T12:53:26","type":"datetime"}},"timestamp":"2025-10-06T18:05:45.194Z"}
[2025-10-08 14:13:54] [INFO] About to extract fields from XML. File size: 1543 bytes
[2025-10-08 14:13:54] [INFO] Number of mappings: 16
[2025-10-08 14:13:54] [INFO] Starting XML parsing. Content length: 1543
[2025-10-08 14:13:54] [INFO] XML parsed successfully. Root element: Incident
[2025-10-08 14:13:54] [INFO] Processing 16 field mappings
[2025-10-08 14:13:54] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-10-08 14:13:54] [INFO]   -> Found value: 25-23116
[2025-10-08 14:13:54] [INFO]   -> Set field 'dispatchRunNumber' = "25-23116"
[2025-10-08 14:13:54] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-10-08 14:13:54] [INFO]   -> No value found (null or empty)
[2025-10-08 14:13:54] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-10-08 14:13:54] [INFO]   -> Found value: S MAIN ST
[2025-10-08 14:13:54] [INFO]   -> Set field 'streetName' = "S MAIN ST"
[2025-10-08 14:13:54] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-10-08 14:13:54] [INFO]   -> No value found (null or empty)
[2025-10-08 14:13:54] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-10-08 14:13:54] [INFO]   -> Found value: SIKESTON
[2025-10-08 14:13:54] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-10-08 14:13:54] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-10-08 14:13:54] [INFO]   -> Found value: ALDI'S
[2025-10-08 14:13:54] [INFO]   -> Set field 'businessName' = "ALDI'S"
[2025-10-08 14:13:54] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-10-08 14:13:54] [INFO]   -> No value found (null or empty)
[2025-10-08 14:13:54] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-10-08 14:13:54] [INFO]   -> No value found (null or empty)
[2025-10-08 14:13:54] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-10-08 14:13:54] [INFO]   -> Found value: 0
[2025-10-08 14:13:54] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-10-08 14:13:54] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-10-08 14:13:54] [INFO]   -> Found value: 0
[2025-10-08 14:13:54] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-10-08 14:13:54] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-10-08 14:13:54] [INFO]   -> Found value: ACCIDENT-J2
[2025-10-08 14:13:54] [INFO]   -> Set field 'incidentTypeValue1' = "ACCIDENT-J2"
[2025-10-08 14:13:54] [INFO] Mapping #12: Extracting 'commentlist.comment' => 'dispatchNotes'
[2025-10-08 14:13:54] [INFO]   -> Found value: 10-08-2025 08:58:38|Call Received on 10/08/2025 @ 08:58

MALE COMPLAINING OF NECK AND BACK PAIN 10-0...
[2025-10-08 14:13:54] [INFO]   -> Set field 'dispatchNotes' = "10-08-2025 08:58:38|Call Received on 10\/08\/2025 @ 08:58\n\nMALE COMPLAINING OF NECK AND BACK PAIN 10-08-2025 09:00:33|NEW MADRID CO NOTIFIED 10-08-2025 09:02:57|ON PLANTATION ROADWAY BLOCKED TO NORTH"
[2025-10-08 14:13:54] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-10-08 14:13:54] [INFO]   -> Found value: 10-08-2025T08:59:55
[2025-10-08 14:13:54] [INFO]   -> Set field 'alarm' = "2025-08-10 08:59:55"
[2025-10-08 14:13:54] [INFO]   -> Set field 'dispatched' = "2025-08-10 08:59:55"
[2025-10-08 14:13:54] [INFO] Mapping #14: Extracting 'time_first_unit_enroute' => 'enroute'
[2025-10-08 14:13:54] [INFO]   -> Found value: 10-08-2025T09:01:14
[2025-10-08 14:13:54] [INFO]   -> Set field 'enroute' = "2025-08-10 09:01:14"
[2025-10-08 14:13:54] [INFO] Mapping #15: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-10-08 14:13:54] [INFO]   -> Found value: 10-08-2025T09:03:55
[2025-10-08 14:13:54] [INFO]   -> Set field 'onScene' = "2025-08-10 09:03:55"
[2025-10-08 14:13:54] [INFO] Mapping #16: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-10-08 14:13:54] [INFO]   -> No value found (null or empty)
[2025-10-08 14:13:54] [INFO] Finished extracting fields. Total fields extracted: 12
[2025-10-08 14:13:54] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-23116","streetName":"S MAIN ST","incidentLocationCity":"SIKESTON","businessName":"ALDI'S","nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"ACCIDENT-J2","dispatchNotes":"10-08-2025 08:58:38|Call Received on 10\/08\/2025 @ 08:58\n\nMALE COMPLAINING OF NECK AND BACK PAIN 10-08-2025 09:00:33|NEW MADRID CO NOTIFIED 10-08-2025 09:02:57|ON PLANTATION ROADWAY BLOCKED TO NORTH","alarm":"2025-08-10 08:59:55","dispatched":"2025-08-10 08:59:55","enroute":"2025-08-10 09:01:14","onScene":"2025-08-10 09:03:55"}
[2025-10-08 14:13:54] [INFO] Number of extracted fields: 12
[2025-10-08 14:13:54] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e87be42b7c
[2025-10-08 14:13:55] [INFO] Created Dispatches record with ID: 68e671a256eb4a841
[2025-10-08 14:13:55] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23116.xml
[2025-10-08 14:13:55] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23116.xml
[2025-10-08 20:52:18] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23141.xml
[2025-10-08 20:52:18] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23141.xml for user: 68d56363ec1209189
[2025-10-08 20:52:18] [INFO] File size: 1299 bytes
[2025-10-08 20:52:18] [INFO] Created FTPFiles record with ID: 68e6cf02ddd897c32
[2025-10-08 20:52:18] [INFO] WE ARE HERE {"mappings":{"IncidentNumber":"dispatchRunNumber","house_number":"incidentLocationStreetNumber","street":"streetName","apt":"incidentLocationApt","city":"incidentLocationCity","location_name":"businessName","STATE":"incidentLocationStateName","ZIPCODE":"nERISIncidentPostalCode","LATITUDE":"nERISIncidentLatitude","LONGITUDE":"nERISIncidentLongitude","incident_type":"incidentTypeValue1","commentlist.comment":"dispatchNotes","time_first_unit_assigned":["alarm","dispatched"],"time_first_unit_enroute":"enroute","time_first_unit_arrived":"onScene","time_last_unit_cleared":["cleared","inService"]},"selectedRecord":{"id":"68e3d5db09560f860","name":null},"fieldExamples":{"IncidentNumber":{"name":"IncidentNumber","value":"25-23001","type":"text"},"house_number":{"name":"house_number","value":"110","type":"number"},"street":{"name":"street","value":"WILLIAM ST","type":"address"},"apt":{"name":"apt","value":"Array","type":"text"},"city":{"name":"city","value":"Array","type":"address"},"location_name":{"name":"location_name","value":"Array","type":"text"},"STATE":{"name":"STATE","value":"Array","type":"address"},"ZIPCODE":{"name":"ZIPCODE","value":"Array","type":"address"},"LATITUDE":{"name":"LATITUDE","value":"0","type":"coordinate"},"LONGITUDE":{"name":"LONGITUDE","value":"0","type":"coordinate"},"incident_type":{"name":"incident_type","value":"FIRE-GAS LEAK","type":"text"},"commentlist.comment":{"name":"comment","value":"10-06-2025 12:37:49|RP ADVISED WAS ATTEMPTING TO TURN ON STOVE, STRONG ODER OF GAS \n\n\nJOH MCOOLEY 573-620-1861 10-06-2025 12:40:34|PAGED 10-06-2025 12:42:51|LIBERTY HAS BEEN CONTACTED 10-06-2025 12:42:57|566 ADVISED ON SCENE, ADVISED ATTEMPTING TO LOCATE SORCE 10-06-2025 12:44:00|566 ADVISED STRONG ODER COMING FROM GAS LINE TO STOVE 10-06-2025 12:45:44|C86 ADVISED HAS COMMAND OF SCENE 10-06-2025 12:53:21|GAS IS SHUT OFF FROM STOVE, GAS COMPANY IS RESPONDING TO ADDRESS ","type":"text"},"time_first_unit_assigned":{"name":"time_first_unit_assigned","value":"10-06-2025T12:40:07","type":"datetime"},"time_first_unit_enroute":{"name":"time_first_unit_enroute","value":"10-06-2025T12:40:23","type":"datetime"},"time_first_unit_arrived":{"name":"time_first_unit_arrived","value":"10-06-2025T12:43:01","type":"datetime"},"time_last_unit_cleared":{"name":"time_last_unit_cleared","value":"10-06-2025T12:53:26","type":"datetime"}},"timestamp":"2025-10-06T18:05:45.194Z"}
[2025-10-08 20:52:18] [INFO] About to extract fields from XML. File size: 1299 bytes
[2025-10-08 20:52:18] [INFO] Number of mappings: 16
[2025-10-08 20:52:18] [INFO] Starting XML parsing. Content length: 1299
[2025-10-08 20:52:18] [INFO] XML parsed successfully. Root element: Incident
[2025-10-08 20:52:18] [INFO] Processing 16 field mappings
[2025-10-08 20:52:18] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-10-08 20:52:18] [INFO]   -> Found value: 25-23141
[2025-10-08 20:52:18] [INFO]   -> Set field 'dispatchRunNumber' = "25-23141"
[2025-10-08 20:52:18] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-10-08 20:52:18] [INFO]   -> Found value: 1008
[2025-10-08 20:52:18] [INFO]   -> Set field 'incidentLocationStreetNumber' = 1008
[2025-10-08 20:52:18] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-10-08 20:52:18] [INFO]   -> Found value: N MAIN ST
[2025-10-08 20:52:18] [INFO]   -> Set field 'streetName' = "N MAIN ST"
[2025-10-08 20:52:18] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-10-08 20:52:18] [INFO]   -> No value found (null or empty)
[2025-10-08 20:52:18] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-10-08 20:52:18] [INFO]   -> No value found (null or empty)
[2025-10-08 20:52:18] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-10-08 20:52:18] [INFO]   -> Found value: AIR EVAC LIFETEAM
[2025-10-08 20:52:18] [INFO]   -> Set field 'businessName' = "AIR EVAC LIFETEAM"
[2025-10-08 20:52:18] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-10-08 20:52:18] [INFO]   -> No value found (null or empty)
[2025-10-08 20:52:18] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-10-08 20:52:18] [INFO]   -> No value found (null or empty)
[2025-10-08 20:52:18] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-10-08 20:52:18] [INFO]   -> Found value: 0
[2025-10-08 20:52:18] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-10-08 20:52:18] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-10-08 20:52:18] [INFO]   -> Found value: 0
[2025-10-08 20:52:18] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-10-08 20:52:18] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-10-08 20:52:18] [INFO]   -> Found value: FIRE-AIRCRAFT STANDBY
[2025-10-08 20:52:18] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-AIRCRAFT STANDBY"
[2025-10-08 20:52:18] [INFO] Mapping #12: Extracting 'commentlist.comment' => 'dispatchNotes'
[2025-10-08 20:52:18] [INFO]   -> Found value: 10-08-2025 15:50:46|ETA 15 MINS
[2025-10-08 20:52:18] [INFO]   -> Set field 'dispatchNotes' = "10-08-2025 15:50:46|ETA 15 MINS"
[2025-10-08 20:52:18] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-10-08 20:52:18] [INFO]   -> Found value: 10-08-2025T15:51:07
[2025-10-08 20:52:18] [INFO]   -> Set field 'alarm' = "2025-08-10 15:51:07"
[2025-10-08 20:52:18] [INFO]   -> Set field 'dispatched' = "2025-08-10 15:51:07"
[2025-10-08 20:52:18] [INFO] Mapping #14: Extracting 'time_first_unit_enroute' => 'enroute'
[2025-10-08 20:52:18] [INFO]   -> No value found (null or empty)
[2025-10-08 20:52:18] [INFO] Mapping #15: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-10-08 20:52:18] [INFO]   -> No value found (null or empty)
[2025-10-08 20:52:18] [INFO] Mapping #16: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-10-08 20:52:18] [INFO]   -> No value found (null or empty)
[2025-10-08 20:52:18] [INFO] Finished extracting fields. Total fields extracted: 10
[2025-10-08 20:52:18] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-23141","incidentLocationStreetNumber":1008,"streetName":"N MAIN ST","businessName":"AIR EVAC LIFETEAM","nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-AIRCRAFT STANDBY","dispatchNotes":"10-08-2025 15:50:46|ETA 15 MINS","alarm":"2025-08-10 15:51:07","dispatched":"2025-08-10 15:51:07"}
[2025-10-08 20:52:18] [INFO] Number of extracted fields: 10
[2025-10-08 20:52:19] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e875662f9c
[2025-10-08 20:52:19] [INFO] Created Dispatches record with ID: 68e6cf031af10de5c
[2025-10-08 20:52:19] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23141.xml
[2025-10-08 20:52:19] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23141.xml
[2025-10-08 23:28:23] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23148.xml
[2025-10-08 23:28:23] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23148.xml for user: 68d56363ec1209189
[2025-10-08 23:28:23] [INFO] File size: 2248 bytes
[2025-10-08 23:28:23] [INFO] Created FTPFiles record with ID: 68e6f397e639d29c0
[2025-10-08 23:28:23] [INFO] WE ARE HERE {"mappings":{"IncidentNumber":"dispatchRunNumber","house_number":"incidentLocationStreetNumber","street":"streetName","apt":"incidentLocationApt","city":"incidentLocationCity","location_name":"businessName","STATE":"incidentLocationStateName","ZIPCODE":"nERISIncidentPostalCode","LATITUDE":"nERISIncidentLatitude","LONGITUDE":"nERISIncidentLongitude","incident_type":"incidentTypeValue1","commentlist.comment":"dispatchNotes","time_first_unit_assigned":["alarm","dispatched"],"time_first_unit_enroute":"enroute","time_first_unit_arrived":"onScene","time_last_unit_cleared":["cleared","inService"]},"selectedRecord":{"id":"68e3d5db09560f860","name":null},"fieldExamples":{"IncidentNumber":{"name":"IncidentNumber","value":"25-23001","type":"text"},"house_number":{"name":"house_number","value":"110","type":"number"},"street":{"name":"street","value":"WILLIAM ST","type":"address"},"apt":{"name":"apt","value":"Array","type":"text"},"city":{"name":"city","value":"Array","type":"address"},"location_name":{"name":"location_name","value":"Array","type":"text"},"STATE":{"name":"STATE","value":"Array","type":"address"},"ZIPCODE":{"name":"ZIPCODE","value":"Array","type":"address"},"LATITUDE":{"name":"LATITUDE","value":"0","type":"coordinate"},"LONGITUDE":{"name":"LONGITUDE","value":"0","type":"coordinate"},"incident_type":{"name":"incident_type","value":"FIRE-GAS LEAK","type":"text"},"commentlist.comment":{"name":"comment","value":"10-06-2025 12:37:49|RP ADVISED WAS ATTEMPTING TO TURN ON STOVE, STRONG ODER OF GAS \n\n\nJOH MCOOLEY 573-620-1861 10-06-2025 12:40:34|PAGED 10-06-2025 12:42:51|LIBERTY HAS BEEN CONTACTED 10-06-2025 12:42:57|566 ADVISED ON SCENE, ADVISED ATTEMPTING TO LOCATE SORCE 10-06-2025 12:44:00|566 ADVISED STRONG ODER COMING FROM GAS LINE TO STOVE 10-06-2025 12:45:44|C86 ADVISED HAS COMMAND OF SCENE 10-06-2025 12:53:21|GAS IS SHUT OFF FROM STOVE, GAS COMPANY IS RESPONDING TO ADDRESS ","type":"text"},"time_first_unit_assigned":{"name":"time_first_unit_assigned","value":"10-06-2025T12:40:07","type":"datetime"},"time_first_unit_enroute":{"name":"time_first_unit_enroute","value":"10-06-2025T12:40:23","type":"datetime"},"time_first_unit_arrived":{"name":"time_first_unit_arrived","value":"10-06-2025T12:43:01","type":"datetime"},"time_last_unit_cleared":{"name":"time_last_unit_cleared","value":"10-06-2025T12:53:26","type":"datetime"}},"timestamp":"2025-10-06T18:05:45.194Z"}
[2025-10-08 23:28:23] [INFO] About to extract fields from XML. File size: 2248 bytes
[2025-10-08 23:28:23] [INFO] Number of mappings: 16
[2025-10-08 23:28:23] [INFO] Starting XML parsing. Content length: 2248
[2025-10-08 23:28:23] [INFO] XML parsed successfully. Root element: Incident
[2025-10-08 23:28:23] [INFO] Processing 16 field mappings
[2025-10-08 23:28:23] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-10-08 23:28:23] [INFO]   -> Found value: 25-23148
[2025-10-08 23:28:23] [INFO]   -> Set field 'dispatchRunNumber' = "25-23148"
[2025-10-08 23:28:23] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-10-08 23:28:23] [INFO]   -> Found value: 108
[2025-10-08 23:28:23] [INFO]   -> Set field 'incidentLocationStreetNumber' = 108
[2025-10-08 23:28:23] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-10-08 23:28:23] [INFO]   -> Found value: STALLCUP DR
[2025-10-08 23:28:23] [INFO]   -> Set field 'streetName' = "STALLCUP DR"
[2025-10-08 23:28:23] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-10-08 23:28:23] [INFO]   -> No value found (null or empty)
[2025-10-08 23:28:23] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-10-08 23:28:23] [INFO]   -> Found value: SIKESTON
[2025-10-08 23:28:23] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-10-08 23:28:23] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-10-08 23:28:23] [INFO]   -> Found value: FRESH AND READY FOOD GROUP
[2025-10-08 23:28:23] [INFO]   -> Set field 'businessName' = "FRESH AND READY FOOD GROUP"
[2025-10-08 23:28:23] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-10-08 23:28:23] [INFO]   -> Found value: MO
[2025-10-08 23:28:23] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-10-08 23:28:23] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-10-08 23:28:23] [INFO]   -> Found value: 63801
[2025-10-08 23:28:23] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-10-08 23:28:23] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-10-08 23:28:23] [INFO]   -> Found value: 0
[2025-10-08 23:28:23] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-10-08 23:28:23] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-10-08 23:28:23] [INFO]   -> Found value: 0
[2025-10-08 23:28:23] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-10-08 23:28:23] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-10-08 23:28:23] [INFO]   -> Found value: FIRE-ALARM MECH
[2025-10-08 23:28:23] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-ALARM MECH"
[2025-10-08 23:28:23] [INFO] Mapping #12: Extracting 'commentlist.comment' => 'dispatchNotes'
[2025-10-08 23:28:23] [INFO]   -> Found value: 10-08-2025 17:57:45|GENERAL
[2025-10-08 23:28:23] [INFO]   -> Set field 'dispatchNotes' = "10-08-2025 17:57:45|GENERAL"
[2025-10-08 23:28:23] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-10-08 23:28:23] [INFO]   -> Found value: 10-08-2025T17:59:17
[2025-10-08 23:28:23] [INFO]   -> Set field 'alarm' = "2025-08-10 17:59:17"
[2025-10-08 23:28:23] [INFO]   -> Set field 'dispatched' = "2025-08-10 17:59:17"
[2025-10-08 23:28:23] [INFO] Mapping #14: Extracting 'time_first_unit_enroute' => 'enroute'
[2025-10-08 23:28:23] [INFO]   -> Found value: 10-08-2025T17:59:25
[2025-10-08 23:28:23] [INFO]   -> Set field 'enroute' = "2025-08-10 17:59:25"
[2025-10-08 23:28:23] [INFO] Mapping #15: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-10-08 23:28:23] [INFO]   -> Found value: 10-08-2025T18:02:08
[2025-10-08 23:28:23] [INFO]   -> Set field 'onScene' = "2025-08-10 18:02:08"
[2025-10-08 23:28:23] [INFO] Mapping #16: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-10-08 23:28:23] [INFO]   -> Found value: 10-08-2025T18:27:22
[2025-10-08 23:28:23] [INFO]   -> Set field 'cleared' = "2025-08-10 18:27:22"
[2025-10-08 23:28:23] [INFO]   -> Set field 'inService' = "2025-08-10 18:27:22"
[2025-10-08 23:28:23] [INFO] Finished extracting fields. Total fields extracted: 17
[2025-10-08 23:28:23] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-23148","incidentLocationStreetNumber":108,"streetName":"STALLCUP DR","incidentLocationCity":"SIKESTON","businessName":"FRESH AND READY FOOD GROUP","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-ALARM MECH","dispatchNotes":"10-08-2025 17:57:45|GENERAL","alarm":"2025-08-10 17:59:17","dispatched":"2025-08-10 17:59:17","enroute":"2025-08-10 17:59:25","onScene":"2025-08-10 18:02:08","cleared":"2025-08-10 18:27:22","inService":"2025-08-10 18:27:22"}
[2025-10-08 23:28:23] [INFO] Number of extracted fields: 17
[2025-10-08 23:28:24] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e872e5ae13
[2025-10-08 23:28:24] [INFO] Created Dispatches record with ID: 68e6f3981a688e0cd
[2025-10-08 23:28:24] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23148.xml
[2025-10-08 23:28:24] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-23148.xml