[2025-11-04 16:49:37] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25291.xml [2025-11-04 16:49:37] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25291.xml for user: 68d56363ec1209189 [2025-11-04 16:49:37] [INFO] File size: 2548 bytes [2025-11-04 16:49:38] [INFO] Created FTPFiles record with ID: 690a2ea214aa8bf25 [2025-11-04 16:49:38] [INFO] WE ARE HERE {"mappings":{"IncidentNumber":"dispatchRunNumber","house_number":"incidentLocationStreetNumber","street":"streetName","apt":"incidentLocationApt","city":"incidentLocationCity","location_name":"businessName","STATE":"incidentLocationStateName","ZIPCODE":"nERISIncidentPostalCode","LATITUDE":"nERISIncidentLatitude","LONGITUDE":"nERISIncidentLongitude","incident_type":"incidentTypeValue1","commentlist.comment":["dispatchNotes","cADLog"],"time_first_unit_assigned":["alarm","dispatched"],"time_first_unit_arrived":"onScene","time_last_unit_cleared":["cleared","inService"],"Units.Unit[0].radio_name":["cADVehicleID","name"],"Units.Unit[0].time_enroute":"timeenroutetoscene","Units.Unit[0].time_arrivedatscene":"timeonscene","Units.Unit[0].time_depart_scene":"timeunitclear","Units.Unit[0].time_assigned":"timedispatch"},"selectedRecord":{"id":"68eeb2639352dd41d","name":null},"fieldExamples":{"IncidentNumber":{"name":"IncidentNumber","value":"25-23514","type":"text"},"house_number":{"name":"house_number","value":"515","type":"number"},"street":{"name":"street","value":"LINDENWOOD AVE","type":"address"},"apt":{"name":"apt","value":"Array","type":"text"},"city":{"name":"city","value":"Array","type":"address"},"location_name":{"name":"location_name","value":"Array","type":"text"},"STATE":{"name":"STATE","value":"Array","type":"address"},"ZIPCODE":{"name":"ZIPCODE","value":"Array","type":"address"},"LATITUDE":{"name":"LATITUDE","value":"0","type":"coordinate"},"LONGITUDE":{"name":"LONGITUDE","value":"0","type":"coordinate"},"incident_type":{"name":"incident_type","value":"FIRE-GAS LEAK","type":"text"},"commentlist.comment":{"name":"comment","value":"10-14-2025 15:05:06|B45 ADVISED HE WOULD NOTIFY GAS CO 10-14-2025 15:05:23|B46 NOTHING SHOWING 10-14-2025 15:08:22|B46 ADVISED NO SMELL OF GAS HOWEVER ALARMS GOING OFF 10-14-2025 15:13:38|B46 CLEARED ","type":"text"},"time_first_unit_assigned":{"name":"time_first_unit_assigned","value":"10-14-2025T15:04:42","type":"datetime"},"time_first_unit_arrived":{"name":"time_first_unit_arrived","value":"10-14-2025T15:07:19","type":"datetime"},"time_last_unit_cleared":{"name":"time_last_unit_cleared","value":"10-14-2025T15:27:23","type":"datetime"},"Units.Unit[0].radio_name":{"name":"radio_name","value":"ENG2","type":"text"},"Units.Unit[0].time_enroute":{"name":"time_enroute","value":"10-14-2025T15:04:46","type":"datetime"},"Units.Unit[0].time_arrivedatscene":{"name":"time_arrivedatscene","value":"10-14-2025T15:08:38","type":"datetime"},"Units.Unit[0].time_depart_scene":{"name":"time_depart_scene","value":"10-14-2025T15:27:23","type":"datetime"},"Units.Unit[0].time_assigned":{"name":"time_assigned","value":"10-14-2025T15:04:42","type":"datetime"}},"timestamp":"2025-10-16T18:16:37.381Z"} [2025-11-04 16:49:38] [INFO] About to extract fields from XML. File size: 2548 bytes [2025-11-04 16:49:38] [INFO] Number of mappings: 20 [2025-11-04 16:49:38] [INFO] Starting XML parsing. Content length: 2548 [2025-11-04 16:49:38] [INFO] XML parsed successfully. Root element: Incident [2025-11-04 16:49:38] [INFO] Processing 20 field mappings [2025-11-04 16:49:38] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber' [2025-11-04 16:49:38] [INFO] -> Found value: 25-25291 [2025-11-04 16:49:38] [INFO] -> Set field 'dispatchRunNumber' = "25-25291" [2025-11-04 16:49:38] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber' [2025-11-04 16:49:38] [INFO] -> Found value: 407 [2025-11-04 16:49:38] [INFO] -> Set field 'incidentLocationStreetNumber' = 407 [2025-11-04 16:49:38] [INFO] Mapping #3: Extracting 'street' => 'streetName' [2025-11-04 16:49:38] [INFO] -> Found value: GREER AVE [2025-11-04 16:49:38] [INFO] -> Set field 'streetName' = "GREER AVE" [2025-11-04 16:49:38] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt' [2025-11-04 16:49:38] [INFO] -> No value found (null or empty) [2025-11-04 16:49:38] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity' [2025-11-04 16:49:38] [INFO] -> Found value: SIKESTON [2025-11-04 16:49:38] [INFO] -> Set field 'incidentLocationCity' = "SIKESTON" [2025-11-04 16:49:38] [INFO] Mapping #6: Extracting 'location_name' => 'businessName' [2025-11-04 16:49:38] [INFO] -> No value found (null or empty) [2025-11-04 16:49:38] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName' [2025-11-04 16:49:38] [INFO] -> Found value: MO [2025-11-04 16:49:38] [INFO] -> Set field 'incidentLocationStateName' = "MO" [2025-11-04 16:49:38] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode' [2025-11-04 16:49:38] [INFO] -> Found value: 63801 [2025-11-04 16:49:38] [INFO] -> Set field 'nERISIncidentPostalCode' = 63801 [2025-11-04 16:49:38] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude' [2025-11-04 16:49:38] [INFO] -> Found value: 0 [2025-11-04 16:49:38] [INFO] -> Set field 'nERISIncidentLatitude' = null [2025-11-04 16:49:38] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude' [2025-11-04 16:49:38] [INFO] -> Found value: 0 [2025-11-04 16:49:38] [INFO] -> Set field 'nERISIncidentLongitude' = null [2025-11-04 16:49:38] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1' [2025-11-04 16:49:38] [INFO] -> Found value: FIRE-STRUCTURE [2025-11-04 16:49:38] [INFO] -> Set field 'incidentTypeValue1' = "FIRE-STRUCTURE" [2025-11-04 16:49:38] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"] [2025-11-04 16:49:38] [INFO] -> Found value: 11-04-2025 09:55:04|CAR ON FIRE NEAR HOUSE ACTIVE FLAMES 11-04-2025 09:57:27|BMU NOTIFIED 11-04-... [2025-11-04 16:49:38] [INFO] -> Set field 'dispatchNotes' = "11-04-2025 09:55:04|CAR ON FIRE NEAR HOUSE\n\nACTIVE FLAMES \n\n 11-04-2025 09:57:27|BMU NOTIFIED 11-04-2025 09:59:59|LIBERTY NOTIFIED 11-04-2025 10:00:12|HYDRANT AT EAST AND GREER 11-04-2025 10:00:20|C92 ON SCEWNE, ADVISED WILL HAVE COMMAND 11-04-2025 10:01:42|TWER1 ON SCENE, STAGED AT HYDRANT 11-04-2025 10:19:48|C92 ADVISED UNDER CONTROL 11-04-2025 10:22:57|1513 CLEARED BY COMMAND 11-04-2025 10:23:46|Disposition - SSCA: RPT" [2025-11-04 16:49:38] [INFO] -> Set field 'cADLog' = "11-04-2025 09:55:04|CAR ON FIRE NEAR HOUSE\n\nACTIVE FLAMES \n\n 11-04-2025 09:57:27|BMU NOTIFIED 11-04-2025 09:59:59|LIBERTY NOTIFIED 11-04-2025 10:00:12|HYDRANT AT EAST AND GREER 11-04-2025 10:00:20|C92 ON SCEWNE, ADVISED WILL HAVE COMMAND 11-04-2025 10:01:42|TWER1 ON SCENE, STAGED AT HYDRANT 11-04-2025 10:19:48|C92 ADVISED UNDER CONTROL 11-04-2025 10:22:57|1513 CLEARED BY COMMAND 11-04-2025 10:23:46|Disposition - SSCA: RPT" [2025-11-04 16:49:38] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"] [2025-11-04 16:49:38] [INFO] -> Found value: 11-04-2025T09:58:22 [2025-11-04 16:49:38] [INFO] -> Set field 'alarm' = "2025-04-11 09:58:22" [2025-11-04 16:49:38] [INFO] -> Set field 'dispatched' = "2025-04-11 09:58:22" [2025-11-04 16:49:38] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene' [2025-11-04 16:49:38] [INFO] -> Found value: 11-04-2025T09:59:45 [2025-11-04 16:49:38] [INFO] -> Set field 'onScene' = "2025-04-11 09:59:45" [2025-11-04 16:49:38] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"] [2025-11-04 16:49:38] [INFO] -> Found value: 11-04-2025T10:48:57 [2025-11-04 16:49:38] [INFO] -> Set field 'cleared' = "2025-04-11 10:48:57" [2025-11-04 16:49:38] [INFO] -> Set field 'inService' = "2025-04-11 10:48:57" [2025-11-04 16:49:38] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"] [2025-11-04 16:49:38] [INFO] -> Found value: ENG2 [2025-11-04 16:49:38] [INFO] -> Set field 'cADVehicleID' = "ENG2" [2025-11-04 16:49:38] [INFO] -> Set field 'name' = "ENG2" [2025-11-04 16:49:38] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene' [2025-11-04 16:49:38] [INFO] -> Found value: 11-04-2025T09:59:13 [2025-11-04 16:49:38] [INFO] -> Set field 'timeenroutetoscene' = "2025-04-11 09:59:13" [2025-11-04 16:49:38] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene' [2025-11-04 16:49:38] [INFO] -> Found value: 11-04-2025T10:01:08 [2025-11-04 16:49:38] [INFO] -> Set field 'timeonscene' = "2025-04-11 10:01:08" [2025-11-04 16:49:38] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear' [2025-11-04 16:49:38] [INFO] -> Found value: 11-04-2025T10:48:57 [2025-11-04 16:49:38] [INFO] -> Set field 'timeunitclear' = "2025-04-11 10:48:57" [2025-11-04 16:49:38] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch' [2025-11-04 16:49:38] [INFO] -> No value found (null or empty) [2025-11-04 16:49:38] [INFO] Finished extracting fields. Total fields extracted: 21 [2025-11-04 16:49:38] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-25291","incidentLocationStreetNumber":407,"streetName":"GREER AVE","incidentLocationCity":"SIKESTON","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-STRUCTURE","dispatchNotes":"11-04-2025 09:55:04|CAR ON FIRE NEAR HOUSE\n\nACTIVE FLAMES \n\n 11-04-2025 09:57:27|BMU NOTIFIED 11-04-2025 09:59:59|LIBERTY NOTIFIED 11-04-2025 10:00:12|HYDRANT AT EAST AND GREER 11-04-2025 10:00:20|C92 ON SCEWNE, ADVISED WILL HAVE COMMAND 11-04-2025 10:01:42|TWER1 ON SCENE, STAGED AT HYDRANT 11-04-2025 10:19:48|C92 ADVISED UNDER CONTROL 11-04-2025 10:22:57|1513 CLEARED BY COMMAND 11-04-2025 10:23:46|Disposition - SSCA: RPT","cADLog":"11-04-2025 09:55:04|CAR ON FIRE NEAR HOUSE\n\nACTIVE FLAMES \n\n 11-04-2025 09:57:27|BMU NOTIFIED 11-04-2025 09:59:59|LIBERTY NOTIFIED 11-04-2025 10:00:12|HYDRANT AT EAST AND GREER 11-04-2025 10:00:20|C92 ON SCEWNE, ADVISED WILL HAVE COMMAND 11-04-2025 10:01:42|TWER1 ON SCENE, STAGED AT HYDRANT 11-04-2025 10:19:48|C92 ADVISED UNDER CONTROL 11-04-2025 10:22:57|1513 CLEARED BY COMMAND 11-04-2025 10:23:46|Disposition - SSCA: RPT","alarm":"2025-04-11 09:58:22","dispatched":"2025-04-11 09:58:22","onScene":"2025-04-11 09:59:45","cleared":"2025-04-11 10:48:57","inService":"2025-04-11 10:48:57","cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":"2025-04-11 09:59:13","timeonscene":"2025-04-11 10:01:08","timeunitclear":"2025-04-11 10:48:57"} [2025-11-04 16:49:38] [INFO] Number of extracted fields: 21 [2025-11-04 16:49:38] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e868e55c0c [2025-11-04 16:49:39] [INFO] Created Dispatches record with ID: 690a2ea26c75054fa [2025-11-04 16:49:39] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25291.xml [2025-11-04 16:49:39] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25291.xml [2025-11-04 16:59:45] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25301.xml [2025-11-04 16:59:45] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25301.xml for user: 68d56363ec1209189 [2025-11-04 16:59:45] [INFO] File size: 1595 bytes [2025-11-04 16:59:45] [INFO] Created FTPFiles record with ID: 690a3101ea5bf52dc [2025-11-04 16:59:45] [INFO] WE ARE HERE {"mappings":{"IncidentNumber":"dispatchRunNumber","house_number":"incidentLocationStreetNumber","street":"streetName","apt":"incidentLocationApt","city":"incidentLocationCity","location_name":"businessName","STATE":"incidentLocationStateName","ZIPCODE":"nERISIncidentPostalCode","LATITUDE":"nERISIncidentLatitude","LONGITUDE":"nERISIncidentLongitude","incident_type":"incidentTypeValue1","commentlist.comment":["dispatchNotes","cADLog"],"time_first_unit_assigned":["alarm","dispatched"],"time_first_unit_arrived":"onScene","time_last_unit_cleared":["cleared","inService"],"Units.Unit[0].radio_name":["cADVehicleID","name"],"Units.Unit[0].time_enroute":"timeenroutetoscene","Units.Unit[0].time_arrivedatscene":"timeonscene","Units.Unit[0].time_depart_scene":"timeunitclear","Units.Unit[0].time_assigned":"timedispatch"},"selectedRecord":{"id":"68eeb2639352dd41d","name":null},"fieldExamples":{"IncidentNumber":{"name":"IncidentNumber","value":"25-23514","type":"text"},"house_number":{"name":"house_number","value":"515","type":"number"},"street":{"name":"street","value":"LINDENWOOD AVE","type":"address"},"apt":{"name":"apt","value":"Array","type":"text"},"city":{"name":"city","value":"Array","type":"address"},"location_name":{"name":"location_name","value":"Array","type":"text"},"STATE":{"name":"STATE","value":"Array","type":"address"},"ZIPCODE":{"name":"ZIPCODE","value":"Array","type":"address"},"LATITUDE":{"name":"LATITUDE","value":"0","type":"coordinate"},"LONGITUDE":{"name":"LONGITUDE","value":"0","type":"coordinate"},"incident_type":{"name":"incident_type","value":"FIRE-GAS LEAK","type":"text"},"commentlist.comment":{"name":"comment","value":"10-14-2025 15:05:06|B45 ADVISED HE WOULD NOTIFY GAS CO 10-14-2025 15:05:23|B46 NOTHING SHOWING 10-14-2025 15:08:22|B46 ADVISED NO SMELL OF GAS HOWEVER ALARMS GOING OFF 10-14-2025 15:13:38|B46 CLEARED ","type":"text"},"time_first_unit_assigned":{"name":"time_first_unit_assigned","value":"10-14-2025T15:04:42","type":"datetime"},"time_first_unit_arrived":{"name":"time_first_unit_arrived","value":"10-14-2025T15:07:19","type":"datetime"},"time_last_unit_cleared":{"name":"time_last_unit_cleared","value":"10-14-2025T15:27:23","type":"datetime"},"Units.Unit[0].radio_name":{"name":"radio_name","value":"ENG2","type":"text"},"Units.Unit[0].time_enroute":{"name":"time_enroute","value":"10-14-2025T15:04:46","type":"datetime"},"Units.Unit[0].time_arrivedatscene":{"name":"time_arrivedatscene","value":"10-14-2025T15:08:38","type":"datetime"},"Units.Unit[0].time_depart_scene":{"name":"time_depart_scene","value":"10-14-2025T15:27:23","type":"datetime"},"Units.Unit[0].time_assigned":{"name":"time_assigned","value":"10-14-2025T15:04:42","type":"datetime"}},"timestamp":"2025-10-16T18:16:37.381Z"} [2025-11-04 16:59:45] [INFO] About to extract fields from XML. File size: 1595 bytes [2025-11-04 16:59:45] [INFO] Number of mappings: 20 [2025-11-04 16:59:45] [INFO] Starting XML parsing. Content length: 1595 [2025-11-04 16:59:45] [INFO] XML parsed successfully. Root element: Incident [2025-11-04 16:59:45] [INFO] Processing 20 field mappings [2025-11-04 16:59:45] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber' [2025-11-04 16:59:45] [INFO] -> Found value: 25-25301 [2025-11-04 16:59:45] [INFO] -> Set field 'dispatchRunNumber' = "25-25301" [2025-11-04 16:59:45] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber' [2025-11-04 16:59:45] [INFO] -> Found value: 1008 [2025-11-04 16:59:45] [INFO] -> Set field 'incidentLocationStreetNumber' = 1008 [2025-11-04 16:59:45] [INFO] Mapping #3: Extracting 'street' => 'streetName' [2025-11-04 16:59:45] [INFO] -> Found value: N MAIN ST [2025-11-04 16:59:45] [INFO] -> Set field 'streetName' = "N MAIN ST" [2025-11-04 16:59:45] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt' [2025-11-04 16:59:45] [INFO] -> No value found (null or empty) [2025-11-04 16:59:45] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity' [2025-11-04 16:59:45] [INFO] -> Found value: SIKESTON [2025-11-04 16:59:45] [INFO] -> Set field 'incidentLocationCity' = "SIKESTON" [2025-11-04 16:59:45] [INFO] Mapping #6: Extracting 'location_name' => 'businessName' [2025-11-04 16:59:45] [INFO] -> Found value: MDMC [2025-11-04 16:59:45] [INFO] -> Set field 'businessName' = "MDMC" [2025-11-04 16:59:45] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName' [2025-11-04 16:59:45] [INFO] -> Found value: MO [2025-11-04 16:59:45] [INFO] -> Set field 'incidentLocationStateName' = "MO" [2025-11-04 16:59:45] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode' [2025-11-04 16:59:45] [INFO] -> Found value: 63801 [2025-11-04 16:59:45] [INFO] -> Set field 'nERISIncidentPostalCode' = 63801 [2025-11-04 16:59:45] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude' [2025-11-04 16:59:45] [INFO] -> Found value: 0 [2025-11-04 16:59:45] [INFO] -> Set field 'nERISIncidentLatitude' = null [2025-11-04 16:59:45] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude' [2025-11-04 16:59:45] [INFO] -> Found value: 0 [2025-11-04 16:59:45] [INFO] -> Set field 'nERISIncidentLongitude' = null [2025-11-04 16:59:45] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1' [2025-11-04 16:59:45] [INFO] -> Found value: FIRE-AIRCRAFT STANDBY [2025-11-04 16:59:45] [INFO] -> Set field 'incidentTypeValue1' = "FIRE-AIRCRAFT STANDBY" [2025-11-04 16:59:45] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"] [2025-11-04 16:59:45] [INFO] -> Found value: 11-04-2025 10:55:31|GROUND TRANSPORT ETA 12 MIN [2025-11-04 16:59:45] [INFO] -> Set field 'dispatchNotes' = "11-04-2025 10:55:31|GROUND TRANSPORT\nETA 12 MIN" [2025-11-04 16:59:45] [INFO] -> Set field 'cADLog' = "11-04-2025 10:55:31|GROUND TRANSPORT\nETA 12 MIN" [2025-11-04 16:59:45] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"] [2025-11-04 16:59:45] [INFO] -> Found value: 11-04-2025T10:57:54 [2025-11-04 16:59:45] [INFO] -> Set field 'alarm' = "2025-04-11 10:57:54" [2025-11-04 16:59:45] [INFO] -> Set field 'dispatched' = "2025-04-11 10:57:54" [2025-11-04 16:59:45] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene' [2025-11-04 16:59:45] [INFO] -> No value found (null or empty) [2025-11-04 16:59:45] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"] [2025-11-04 16:59:45] [INFO] -> No value found (null or empty) [2025-11-04 16:59:45] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"] [2025-11-04 16:59:45] [INFO] -> Found value: L3 [2025-11-04 16:59:45] [INFO] -> Set field 'cADVehicleID' = "L3" [2025-11-04 16:59:45] [INFO] -> Set field 'name' = "L3" [2025-11-04 16:59:45] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene' [2025-11-04 16:59:45] [INFO] -> No value found (null or empty) [2025-11-04 16:59:45] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene' [2025-11-04 16:59:45] [INFO] -> No value found (null or empty) [2025-11-04 16:59:45] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear' [2025-11-04 16:59:45] [INFO] -> Found value: 11-04-2025T10:58:24 [2025-11-04 16:59:45] [INFO] -> Set field 'timeunitclear' = "2025-04-11 10:58:24" [2025-11-04 16:59:45] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch' [2025-11-04 16:59:45] [INFO] -> Found value: 11-04-2025T10:58:21 [2025-11-04 16:59:45] [INFO] -> Set field 'timedispatch' = "2025-04-11 10:58:21" [2025-11-04 16:59:45] [INFO] Finished extracting fields. Total fields extracted: 18 [2025-11-04 16:59:45] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-25301","incidentLocationStreetNumber":1008,"streetName":"N MAIN ST","incidentLocationCity":"SIKESTON","businessName":"MDMC","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-AIRCRAFT STANDBY","dispatchNotes":"11-04-2025 10:55:31|GROUND TRANSPORT\nETA 12 MIN","cADLog":"11-04-2025 10:55:31|GROUND TRANSPORT\nETA 12 MIN","alarm":"2025-04-11 10:57:54","dispatched":"2025-04-11 10:57:54","cADVehicleID":"L3","name":"L3","timeunitclear":"2025-04-11 10:58:24","timedispatch":"2025-04-11 10:58:21"} [2025-11-04 16:59:45] [INFO] Number of extracted fields: 18 [2025-11-04 16:59:46] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e875662f9c [2025-11-04 16:59:46] [INFO] Created Dispatches record with ID: 690a31021c31b8a28 [2025-11-04 16:59:46] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25301.xml [2025-11-04 16:59:46] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25301.xml [2025-11-04 17:14:57] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25298.xml [2025-11-04 17:14:57] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25298.xml for user: 68d56363ec1209189 [2025-11-04 17:14:57] [INFO] File size: 1764 bytes [2025-11-04 17:14:57] [INFO] Created FTPFiles record with ID: 690a3491ea9963e5e [2025-11-04 17:14:57] [INFO] WE ARE HERE {"mappings":{"IncidentNumber":"dispatchRunNumber","house_number":"incidentLocationStreetNumber","street":"streetName","apt":"incidentLocationApt","city":"incidentLocationCity","location_name":"businessName","STATE":"incidentLocationStateName","ZIPCODE":"nERISIncidentPostalCode","LATITUDE":"nERISIncidentLatitude","LONGITUDE":"nERISIncidentLongitude","incident_type":"incidentTypeValue1","commentlist.comment":["dispatchNotes","cADLog"],"time_first_unit_assigned":["alarm","dispatched"],"time_first_unit_arrived":"onScene","time_last_unit_cleared":["cleared","inService"],"Units.Unit[0].radio_name":["cADVehicleID","name"],"Units.Unit[0].time_enroute":"timeenroutetoscene","Units.Unit[0].time_arrivedatscene":"timeonscene","Units.Unit[0].time_depart_scene":"timeunitclear","Units.Unit[0].time_assigned":"timedispatch"},"selectedRecord":{"id":"68eeb2639352dd41d","name":null},"fieldExamples":{"IncidentNumber":{"name":"IncidentNumber","value":"25-23514","type":"text"},"house_number":{"name":"house_number","value":"515","type":"number"},"street":{"name":"street","value":"LINDENWOOD AVE","type":"address"},"apt":{"name":"apt","value":"Array","type":"text"},"city":{"name":"city","value":"Array","type":"address"},"location_name":{"name":"location_name","value":"Array","type":"text"},"STATE":{"name":"STATE","value":"Array","type":"address"},"ZIPCODE":{"name":"ZIPCODE","value":"Array","type":"address"},"LATITUDE":{"name":"LATITUDE","value":"0","type":"coordinate"},"LONGITUDE":{"name":"LONGITUDE","value":"0","type":"coordinate"},"incident_type":{"name":"incident_type","value":"FIRE-GAS LEAK","type":"text"},"commentlist.comment":{"name":"comment","value":"10-14-2025 15:05:06|B45 ADVISED HE WOULD NOTIFY GAS CO 10-14-2025 15:05:23|B46 NOTHING SHOWING 10-14-2025 15:08:22|B46 ADVISED NO SMELL OF GAS HOWEVER ALARMS GOING OFF 10-14-2025 15:13:38|B46 CLEARED ","type":"text"},"time_first_unit_assigned":{"name":"time_first_unit_assigned","value":"10-14-2025T15:04:42","type":"datetime"},"time_first_unit_arrived":{"name":"time_first_unit_arrived","value":"10-14-2025T15:07:19","type":"datetime"},"time_last_unit_cleared":{"name":"time_last_unit_cleared","value":"10-14-2025T15:27:23","type":"datetime"},"Units.Unit[0].radio_name":{"name":"radio_name","value":"ENG2","type":"text"},"Units.Unit[0].time_enroute":{"name":"time_enroute","value":"10-14-2025T15:04:46","type":"datetime"},"Units.Unit[0].time_arrivedatscene":{"name":"time_arrivedatscene","value":"10-14-2025T15:08:38","type":"datetime"},"Units.Unit[0].time_depart_scene":{"name":"time_depart_scene","value":"10-14-2025T15:27:23","type":"datetime"},"Units.Unit[0].time_assigned":{"name":"time_assigned","value":"10-14-2025T15:04:42","type":"datetime"}},"timestamp":"2025-10-16T18:16:37.381Z"} [2025-11-04 17:14:57] [INFO] About to extract fields from XML. File size: 1764 bytes [2025-11-04 17:14:57] [INFO] Number of mappings: 20 [2025-11-04 17:14:57] [INFO] Starting XML parsing. Content length: 1764 [2025-11-04 17:14:57] [INFO] XML parsed successfully. Root element: Incident [2025-11-04 17:14:57] [INFO] Processing 20 field mappings [2025-11-04 17:14:57] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber' [2025-11-04 17:14:57] [INFO] -> Found value: 25-25298 [2025-11-04 17:14:57] [INFO] -> Set field 'dispatchRunNumber' = "25-25298" [2025-11-04 17:14:57] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber' [2025-11-04 17:14:57] [INFO] -> Found value: 1551 [2025-11-04 17:14:57] [INFO] -> Set field 'incidentLocationStreetNumber' = 1551 [2025-11-04 17:14:57] [INFO] Mapping #3: Extracting 'street' => 'streetName' [2025-11-04 17:14:57] [INFO] -> Found value: W WAKEFIELD AVE [2025-11-04 17:14:57] [INFO] -> Set field 'streetName' = "W WAKEFIELD AVE" [2025-11-04 17:14:57] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt' [2025-11-04 17:14:57] [INFO] -> No value found (null or empty) [2025-11-04 17:14:57] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity' [2025-11-04 17:14:57] [INFO] -> Found value: SIKESTON [2025-11-04 17:14:57] [INFO] -> Set field 'incidentLocationCity' = "SIKESTON" [2025-11-04 17:14:57] [INFO] Mapping #6: Extracting 'location_name' => 'businessName' [2025-11-04 17:14:57] [INFO] -> Found value: SIKESTON POWER PLANT [2025-11-04 17:14:57] [INFO] -> Set field 'businessName' = "SIKESTON POWER PLANT" [2025-11-04 17:14:57] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName' [2025-11-04 17:14:57] [INFO] -> No value found (null or empty) [2025-11-04 17:14:57] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode' [2025-11-04 17:14:57] [INFO] -> No value found (null or empty) [2025-11-04 17:14:57] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude' [2025-11-04 17:14:57] [INFO] -> Found value: 0 [2025-11-04 17:14:57] [INFO] -> Set field 'nERISIncidentLatitude' = null [2025-11-04 17:14:57] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude' [2025-11-04 17:14:57] [INFO] -> Found value: 0 [2025-11-04 17:14:57] [INFO] -> Set field 'nERISIncidentLongitude' = null [2025-11-04 17:14:57] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1' [2025-11-04 17:14:57] [INFO] -> Found value: FIRE-COAL TRAIN STANDBY [2025-11-04 17:14:57] [INFO] -> Set field 'incidentTypeValue1' = "FIRE-COAL TRAIN STANDBY" [2025-11-04 17:14:57] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"] [2025-11-04 17:14:57] [INFO] -> Found value: 11-04-2025 10:39:27|ARRIVING FROM NB 11-04-2025 10:46:02|TWER 1 ON SCENE 11-04-2025 10:47:09|POWER P... [2025-11-04 17:14:57] [INFO] -> Set field 'dispatchNotes' = "11-04-2025 10:39:27|ARRIVING FROM NB 11-04-2025 10:46:02|TWER 1 ON SCENE 11-04-2025 10:47:09|POWER PLANT ADVISED TWER 1 ON SCENE 11-04-2025 11:14:07|TRAIN CLEAR OF THE TRACKS" [2025-11-04 17:14:57] [INFO] -> Set field 'cADLog' = "11-04-2025 10:39:27|ARRIVING FROM NB 11-04-2025 10:46:02|TWER 1 ON SCENE 11-04-2025 10:47:09|POWER PLANT ADVISED TWER 1 ON SCENE 11-04-2025 11:14:07|TRAIN CLEAR OF THE TRACKS" [2025-11-04 17:14:57] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"] [2025-11-04 17:14:57] [INFO] -> Found value: 11-04-2025T10:43:17 [2025-11-04 17:14:57] [INFO] -> Set field 'alarm' = "2025-04-11 10:43:17" [2025-11-04 17:14:57] [INFO] -> Set field 'dispatched' = "2025-04-11 10:43:17" [2025-11-04 17:14:57] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene' [2025-11-04 17:14:57] [INFO] -> Found value: 11-04-2025T10:46:46 [2025-11-04 17:14:57] [INFO] -> Set field 'onScene' = "2025-04-11 10:46:46" [2025-11-04 17:14:57] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"] [2025-11-04 17:14:57] [INFO] -> Found value: 11-04-2025T11:13:59 [2025-11-04 17:14:57] [INFO] -> Set field 'cleared' = "2025-04-11 11:13:59" [2025-11-04 17:14:57] [INFO] -> Set field 'inService' = "2025-04-11 11:13:59" [2025-11-04 17:14:57] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"] [2025-11-04 17:14:57] [INFO] -> Found value: SIK STILL [2025-11-04 17:14:57] [INFO] -> Set field 'cADVehicleID' = "SIK STILL" [2025-11-04 17:14:57] [INFO] -> Set field 'name' = "SIK STILL" [2025-11-04 17:14:57] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene' [2025-11-04 17:14:57] [INFO] -> No value found (null or empty) [2025-11-04 17:14:57] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene' [2025-11-04 17:14:57] [INFO] -> No value found (null or empty) [2025-11-04 17:14:57] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear' [2025-11-04 17:14:57] [INFO] -> Found value: 11-04-2025T11:13:59 [2025-11-04 17:14:57] [INFO] -> Set field 'timeunitclear' = "2025-04-11 11:13:59" [2025-11-04 17:14:57] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch' [2025-11-04 17:14:57] [INFO] -> Found value: 11-04-2025T10:43:17 [2025-11-04 17:14:57] [INFO] -> Set field 'timedispatch' = "2025-04-11 10:43:17" [2025-11-04 17:14:57] [INFO] Finished extracting fields. Total fields extracted: 19 [2025-11-04 17:14:57] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-25298","incidentLocationStreetNumber":1551,"streetName":"W WAKEFIELD AVE","incidentLocationCity":"SIKESTON","businessName":"SIKESTON POWER PLANT","nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-COAL TRAIN STANDBY","dispatchNotes":"11-04-2025 10:39:27|ARRIVING FROM NB 11-04-2025 10:46:02|TWER 1 ON SCENE 11-04-2025 10:47:09|POWER PLANT ADVISED TWER 1 ON SCENE 11-04-2025 11:14:07|TRAIN CLEAR OF THE TRACKS","cADLog":"11-04-2025 10:39:27|ARRIVING FROM NB 11-04-2025 10:46:02|TWER 1 ON SCENE 11-04-2025 10:47:09|POWER PLANT ADVISED TWER 1 ON SCENE 11-04-2025 11:14:07|TRAIN CLEAR OF THE TRACKS","alarm":"2025-04-11 10:43:17","dispatched":"2025-04-11 10:43:17","onScene":"2025-04-11 10:46:46","cleared":"2025-04-11 11:13:59","inService":"2025-04-11 11:13:59","cADVehicleID":"SIK STILL","name":"SIK STILL","timeunitclear":"2025-04-11 11:13:59","timedispatch":"2025-04-11 10:43:17"} [2025-11-04 17:14:57] [INFO] Number of extracted fields: 19 [2025-11-04 17:14:58] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e8608a02f9 [2025-11-04 17:14:58] [INFO] Created Dispatches record with ID: 690a3492187371861 [2025-11-04 17:14:58] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25298.xml [2025-11-04 17:14:58] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25298.xml