[2025-11-11 15:42:09] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25856.xml
[2025-11-11 15:42:09] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25856.xml for user: 68d56363ec1209189
[2025-11-11 15:42:09] [INFO] File size: 1485 bytes
[2025-11-11 15:42:10] [INFO] Created FTPFiles record with ID: 691359520813c6d8c
[2025-11-11 15:42:10] [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-11 15:42:10] [INFO] About to extract fields from XML. File size: 1485 bytes
[2025-11-11 15:42:10] [INFO] Number of mappings: 20
[2025-11-11 15:42:10] [INFO] Starting XML parsing. Content length: 1485
[2025-11-11 15:42:10] [INFO] XML parsed successfully. Root element: Incident
[2025-11-11 15:42:10] [INFO] Processing 20 field mappings
[2025-11-11 15:42:10] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-11 15:42:10] [INFO]   -> Found value: 25-25856
[2025-11-11 15:42:10] [INFO]   -> Set field 'dispatchRunNumber' = "25-25856"
[2025-11-11 15:42:10] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-11 15:42:10] [INFO]   -> Found value: 1008
[2025-11-11 15:42:10] [INFO]   -> Set field 'incidentLocationStreetNumber' = 1008
[2025-11-11 15:42:10] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-11 15:42:10] [INFO]   -> Found value: N MAIN ST
[2025-11-11 15:42:10] [INFO]   -> Set field 'streetName' = "N MAIN ST"
[2025-11-11 15:42:10] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-11 15:42:10] [INFO]   -> No value found (null or empty)
[2025-11-11 15:42:10] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-11 15:42:10] [INFO]   -> Found value: SIKESTON
[2025-11-11 15:42:10] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-11 15:42:10] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-11 15:42:10] [INFO]   -> Found value: MDMC
[2025-11-11 15:42:10] [INFO]   -> Set field 'businessName' = "MDMC"
[2025-11-11 15:42:10] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-11 15:42:10] [INFO]   -> Found value: MO
[2025-11-11 15:42:10] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-11 15:42:10] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-11 15:42:10] [INFO]   -> Found value: 63801
[2025-11-11 15:42:10] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-11 15:42:10] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-11 15:42:10] [INFO]   -> Found value: 0
[2025-11-11 15:42:10] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-11 15:42:10] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-11 15:42:10] [INFO]   -> Found value: 0
[2025-11-11 15:42:10] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-11 15:42:10] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-11 15:42:10] [INFO]   -> Found value: FIRE-AIRCRAFT STANDBY
[2025-11-11 15:42:10] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-AIRCRAFT STANDBY"
[2025-11-11 15:42:10] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-11 15:42:10] [INFO]   -> Found value: 11-08-2025 19:42:13|39 MINS ETA  11-08-2025 19:46:06|STATION 3 COPY PAGE 11-08-2025 20:49:36|FLIGHT ...
[2025-11-11 15:42:10] [INFO]   -> Set field 'dispatchNotes' = "11-08-2025 19:42:13|39 MINS ETA  11-08-2025 19:46:06|STATION 3 COPY PAGE 11-08-2025 20:49:36|FLIGHT CREW ON BOARD ENROUTE TO ER 11-08-2025 20:49:59|AT ER 1.2"
[2025-11-11 15:42:10] [INFO]   -> Set field 'cADLog' = "11-08-2025 19:42:13|39 MINS ETA  11-08-2025 19:46:06|STATION 3 COPY PAGE 11-08-2025 20:49:36|FLIGHT CREW ON BOARD ENROUTE TO ER 11-08-2025 20:49:59|AT ER 1.2"
[2025-11-11 15:42:10] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-11 15:42:10] [INFO]   -> Found value: 11-08-2025T19:43:08
[2025-11-11 15:42:10] [INFO]   -> Set field 'alarm' = "2025-08-11 19:43:08"
[2025-11-11 15:42:10] [INFO]   -> Set field 'dispatched' = "2025-08-11 19:43:08"
[2025-11-11 15:42:10] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-11 15:42:10] [INFO]   -> Found value: 11-08-2025T21:16:21
[2025-11-11 15:42:10] [INFO]   -> Set field 'onScene' = "2025-08-11 21:16:21"
[2025-11-11 15:42:10] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-11 15:42:10] [INFO]   -> Found value: 11-08-2025T21:23:51
[2025-11-11 15:42:10] [INFO]   -> Set field 'cleared' = "2025-08-11 21:23:51"
[2025-11-11 15:42:10] [INFO]   -> Set field 'inService' = "2025-08-11 21:23:51"
[2025-11-11 15:42:10] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-11 15:42:10] [INFO]   -> Found value: SIK STILL
[2025-11-11 15:42:10] [INFO]   -> Set field 'cADVehicleID' = "SIK STILL"
[2025-11-11 15:42:10] [INFO]   -> Set field 'name' = "SIK STILL"
[2025-11-11 15:42:10] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-11 15:42:10] [INFO]   -> No value found (null or empty)
[2025-11-11 15:42:10] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-11 15:42:10] [INFO]   -> No value found (null or empty)
[2025-11-11 15:42:10] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-11 15:42:10] [INFO]   -> Found value: 11-08-2025T21:23:51
[2025-11-11 15:42:10] [INFO]   -> Set field 'timeunitclear' = "2025-08-11 21:23:51"
[2025-11-11 15:42:10] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-11 15:42:10] [INFO]   -> Found value: 11-08-2025T19:43:08
[2025-11-11 15:42:10] [INFO]   -> Set field 'timedispatch' = "2025-08-11 19:43:08"
[2025-11-11 15:42:10] [INFO] Finished extracting fields. Total fields extracted: 21
[2025-11-11 15:42:10] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-25856","incidentLocationStreetNumber":1008,"streetName":"N MAIN ST","incidentLocationCity":"SIKESTON","businessName":"MDMC","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-AIRCRAFT STANDBY","dispatchNotes":"11-08-2025 19:42:13|39 MINS ETA  11-08-2025 19:46:06|STATION 3 COPY PAGE 11-08-2025 20:49:36|FLIGHT CREW ON BOARD ENROUTE TO ER 11-08-2025 20:49:59|AT ER 1.2","cADLog":"11-08-2025 19:42:13|39 MINS ETA  11-08-2025 19:46:06|STATION 3 COPY PAGE 11-08-2025 20:49:36|FLIGHT CREW ON BOARD ENROUTE TO ER 11-08-2025 20:49:59|AT ER 1.2","alarm":"2025-08-11 19:43:08","dispatched":"2025-08-11 19:43:08","onScene":"2025-08-11 21:16:21","cleared":"2025-08-11 21:23:51","inService":"2025-08-11 21:23:51","cADVehicleID":"SIK STILL","name":"SIK STILL","timeunitclear":"2025-08-11 21:23:51","timedispatch":"2025-08-11 19:43:08"}
[2025-11-11 15:42:10] [INFO] Number of extracted fields: 21
[2025-11-11 15:42:10] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e875662f9c
[2025-11-11 15:42:11] [INFO] Created Dispatches record with ID: 69135952263d82d13
[2025-11-11 15:42:11] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25856.xml
[2025-11-11 15:42:11] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25856.xml
[2025-11-11 15:42:11] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25883.xml
[2025-11-11 15:42:11] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25883.xml for user: 68d56363ec1209189
[2025-11-11 15:42:11] [INFO] File size: 2100 bytes
[2025-11-11 15:42:11] [INFO] Created FTPFiles record with ID: 69135953418ea16d0
[2025-11-11 15:42:11] [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-11 15:42:11] [INFO] About to extract fields from XML. File size: 2100 bytes
[2025-11-11 15:42:11] [INFO] Number of mappings: 20
[2025-11-11 15:42:11] [INFO] Starting XML parsing. Content length: 2100
[2025-11-11 15:42:11] [INFO] XML parsed successfully. Root element: Incident
[2025-11-11 15:42:11] [INFO] Processing 20 field mappings
[2025-11-11 15:42:11] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-11 15:42:11] [INFO]   -> Found value: 25-25883
[2025-11-11 15:42:11] [INFO]   -> Set field 'dispatchRunNumber' = "25-25883"
[2025-11-11 15:42:11] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-11 15:42:11] [INFO]   -> Found value: 104
[2025-11-11 15:42:11] [INFO]   -> Set field 'incidentLocationStreetNumber' = 104
[2025-11-11 15:42:11] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-11 15:42:11] [INFO]   -> Found value: E FRONT ST
[2025-11-11 15:42:11] [INFO]   -> Set field 'streetName' = "E FRONT ST"
[2025-11-11 15:42:11] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-11 15:42:11] [INFO]   -> No value found (null or empty)
[2025-11-11 15:42:11] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-11 15:42:11] [INFO]   -> Found value: SIKESTON
[2025-11-11 15:42:11] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-11 15:42:11] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-11 15:42:11] [INFO]   -> Found value: CARSON'S
[2025-11-11 15:42:11] [INFO]   -> Set field 'businessName' = "CARSON'S"
[2025-11-11 15:42:11] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-11 15:42:11] [INFO]   -> No value found (null or empty)
[2025-11-11 15:42:11] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-11 15:42:11] [INFO]   -> No value found (null or empty)
[2025-11-11 15:42:11] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-11 15:42:11] [INFO]   -> Found value: 0
[2025-11-11 15:42:11] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-11 15:42:11] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-11 15:42:11] [INFO]   -> Found value: 0
[2025-11-11 15:42:11] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-11 15:42:11] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-11 15:42:11] [INFO]   -> Found value: FIRE-ALARM MECH
[2025-11-11 15:42:11] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-ALARM MECH"
[2025-11-11 15:42:11] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-11 15:42:11] [INFO]   -> Found value: 11-08-2025 21:40:10|FIRE ALARM 
 11-08-2025 21:45:42|TWO STORY COMMERCIAL STRUCTURE NOTHIING SHOWING...
[2025-11-11 15:42:11] [INFO]   -> Set field 'dispatchNotes' = "11-08-2025 21:40:10|FIRE ALARM \n 11-08-2025 21:45:42|TWO STORY COMMERCIAL STRUCTURE NOTHIING SHOWING 11-08-2025 21:46:17|VERIFIED BY KEYHOLDER FALSE ALARM 11-08-2025 21:46:20|C90 ON SCENE ADVISED 2 STORY NOTHING SHOWING"
[2025-11-11 15:42:11] [INFO]   -> Set field 'cADLog' = "11-08-2025 21:40:10|FIRE ALARM \n 11-08-2025 21:45:42|TWO STORY COMMERCIAL STRUCTURE NOTHIING SHOWING 11-08-2025 21:46:17|VERIFIED BY KEYHOLDER FALSE ALARM 11-08-2025 21:46:20|C90 ON SCENE ADVISED 2 STORY NOTHING SHOWING"
[2025-11-11 15:42:11] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-11 15:42:11] [INFO]   -> Found value: 11-08-2025T21:43:49
[2025-11-11 15:42:11] [INFO]   -> Set field 'alarm' = "2025-08-11 21:43:49"
[2025-11-11 15:42:11] [INFO]   -> Set field 'dispatched' = "2025-08-11 21:43:49"
[2025-11-11 15:42:11] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-11 15:42:11] [INFO]   -> Found value: 11-08-2025T21:45:09
[2025-11-11 15:42:11] [INFO]   -> Set field 'onScene' = "2025-08-11 21:45:09"
[2025-11-11 15:42:11] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-11 15:42:11] [INFO]   -> Found value: 11-08-2025T21:47:22
[2025-11-11 15:42:11] [INFO]   -> Set field 'cleared' = "2025-08-11 21:47:22"
[2025-11-11 15:42:11] [INFO]   -> Set field 'inService' = "2025-08-11 21:47:22"
[2025-11-11 15:42:11] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-11 15:42:11] [INFO]   -> Found value: ENG2
[2025-11-11 15:42:11] [INFO]   -> Set field 'cADVehicleID' = "ENG2"
[2025-11-11 15:42:11] [INFO]   -> Set field 'name' = "ENG2"
[2025-11-11 15:42:11] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-11 15:42:11] [INFO]   -> Found value: 11-08-2025T21:45:29
[2025-11-11 15:42:11] [INFO]   -> Set field 'timeenroutetoscene' = "2025-08-11 21:45:29"
[2025-11-11 15:42:11] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-11 15:42:11] [INFO]   -> No value found (null or empty)
[2025-11-11 15:42:11] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-11 15:42:11] [INFO]   -> Found value: 11-08-2025T21:47:22
[2025-11-11 15:42:11] [INFO]   -> Set field 'timeunitclear' = "2025-08-11 21:47:22"
[2025-11-11 15:42:11] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-11 15:42:11] [INFO]   -> Found value: 11-08-2025T21:45:18
[2025-11-11 15:42:11] [INFO]   -> Set field 'timedispatch' = "2025-08-11 21:45:18"
[2025-11-11 15:42:11] [INFO] Finished extracting fields. Total fields extracted: 20
[2025-11-11 15:42:11] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-25883","incidentLocationStreetNumber":104,"streetName":"E FRONT ST","incidentLocationCity":"SIKESTON","businessName":"CARSON'S","nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-ALARM MECH","dispatchNotes":"11-08-2025 21:40:10|FIRE ALARM \n 11-08-2025 21:45:42|TWO STORY COMMERCIAL STRUCTURE NOTHIING SHOWING 11-08-2025 21:46:17|VERIFIED BY KEYHOLDER FALSE ALARM 11-08-2025 21:46:20|C90 ON SCENE ADVISED 2 STORY NOTHING SHOWING","cADLog":"11-08-2025 21:40:10|FIRE ALARM \n 11-08-2025 21:45:42|TWO STORY COMMERCIAL STRUCTURE NOTHIING SHOWING 11-08-2025 21:46:17|VERIFIED BY KEYHOLDER FALSE ALARM 11-08-2025 21:46:20|C90 ON SCENE ADVISED 2 STORY NOTHING SHOWING","alarm":"2025-08-11 21:43:49","dispatched":"2025-08-11 21:43:49","onScene":"2025-08-11 21:45:09","cleared":"2025-08-11 21:47:22","inService":"2025-08-11 21:47:22","cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":"2025-08-11 21:45:29","timeunitclear":"2025-08-11 21:47:22","timedispatch":"2025-08-11 21:45:18"}
[2025-11-11 15:42:11] [INFO] Number of extracted fields: 20
[2025-11-11 15:42:11] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e872e5ae13
[2025-11-11 15:42:12] [INFO] Created Dispatches record with ID: 691359536139e9e56
[2025-11-11 15:42:12] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25883.xml
[2025-11-11 15:42:12] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25883.xml
[2025-11-11 15:42:12] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26013.xml
[2025-11-11 15:42:12] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26013.xml for user: 68d56363ec1209189
[2025-11-11 15:42:12] [INFO] File size: 2776 bytes
[2025-11-11 15:42:12] [INFO] Created FTPFiles record with ID: 691359548c874e856
[2025-11-11 15:42:12] [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-11 15:42:12] [INFO] About to extract fields from XML. File size: 2776 bytes
[2025-11-11 15:42:12] [INFO] Number of mappings: 20
[2025-11-11 15:42:12] [INFO] Starting XML parsing. Content length: 2776
[2025-11-11 15:42:12] [INFO] XML parsed successfully. Root element: Incident
[2025-11-11 15:42:12] [INFO] Processing 20 field mappings
[2025-11-11 15:42:12] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-11 15:42:12] [INFO]   -> Found value: 25-26013
[2025-11-11 15:42:12] [INFO]   -> Set field 'dispatchRunNumber' = "25-26013"
[2025-11-11 15:42:12] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-11 15:42:12] [INFO]   -> Found value: 1810
[2025-11-11 15:42:12] [INFO]   -> Set field 'incidentLocationStreetNumber' = 1810
[2025-11-11 15:42:12] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-11 15:42:12] [INFO]   -> Found value: E MALONE AVE
[2025-11-11 15:42:12] [INFO]   -> Set field 'streetName' = "E MALONE AVE"
[2025-11-11 15:42:12] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-11 15:42:12] [INFO]   -> No value found (null or empty)
[2025-11-11 15:42:12] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-11 15:42:12] [INFO]   -> Found value: SIKESTON
[2025-11-11 15:42:12] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-11 15:42:12] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-11 15:42:12] [INFO]   -> Found value: VFW MEMORIAL STADIUM- SIKESTON
[2025-11-11 15:42:12] [INFO]   -> Set field 'businessName' = "VFW MEMORIAL STADIUM- SIKESTON"
[2025-11-11 15:42:12] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-11 15:42:12] [INFO]   -> Found value: MO
[2025-11-11 15:42:12] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-11 15:42:12] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-11 15:42:12] [INFO]   -> Found value: 63801
[2025-11-11 15:42:12] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-11 15:42:12] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-11 15:42:12] [INFO]   -> Found value: 0
[2025-11-11 15:42:12] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-11 15:42:12] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-11 15:42:12] [INFO]   -> Found value: 0
[2025-11-11 15:42:12] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-11 15:42:12] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-11 15:42:12] [INFO]   -> Found value: FIRE-ALARM MECH
[2025-11-11 15:42:12] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-ALARM MECH"
[2025-11-11 15:42:12] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-11 15:42:12] [INFO]   -> Found value: 11-10-2025 00:44:07|FIRE ALARM
PUMP LINE WATER FLOW
NO KEYHOLDER 
TETRA PARK CLUB HOUSE 
 11-10-2025...
[2025-11-11 15:42:12] [INFO]   -> Set field 'dispatchNotes' = "11-10-2025 00:44:07|FIRE ALARM\nPUMP LINE WATER FLOW\nNO KEYHOLDER \nTETRA PARK CLUB HOUSE \n 11-10-2025 00:51:51|565 ON SCENE SMALL BRICK INDUSTRIAL STRUCTURE NOTHING SHOWING 11-10-2025 00:53:40|C90 ON SCENE WILL HAVE COMMAND 11-10-2025 00:57:11|GATE IS LOCKED 11-10-2025 01:00:26|ATTEMPED KEYHOLDER JUSTIN KELLER NO ANSWER 11-10-2025 01:03:35|ATTEPTED BUSINESS LINE FOR TETRA PAK NO ANSWER 11-10-2025 01:07:18|MINER PD CONTACTED  KEYHOLDER ADDRESS OF KEYHOLDER 222 HARRISON  TO SEE IF HE HAS KEY TO GATE FOR CLUB HOUSE 11-10-2025 01:07:21|NO FIRE 11-10-2025 01:13:02|JUSTIN KELLER RECONTACTED DOES NOT HAVE  KEY  SAYS HE WILL CONTACT CHRIS HARPER AND KURT EVANS AND HAVE THEM CALL US 11-10-2025 01:30:13|C90 ADVISED THERE IS NO SMOKE NO FIRE THERE WILL BE AN AUIDIBLE  ALARM SOUNDING 11-10-2025 01:30:25|Disposition - SDPS PD:  NRN"
[2025-11-11 15:42:12] [INFO]   -> Set field 'cADLog' = "11-10-2025 00:44:07|FIRE ALARM\nPUMP LINE WATER FLOW\nNO KEYHOLDER \nTETRA PARK CLUB HOUSE \n 11-10-2025 00:51:51|565 ON SCENE SMALL BRICK INDUSTRIAL STRUCTURE NOTHING SHOWING 11-10-2025 00:53:40|C90 ON SCENE WILL HAVE COMMAND 11-10-2025 00:57:11|GATE IS LOCKED 11-10-2025 01:00:26|ATTEMPED KEYHOLDER JUSTIN KELLER NO ANSWER 11-10-2025 01:03:35|ATTEPTED BUSINESS LINE FOR TETRA PAK NO ANSWER 11-10-2025 01:07:18|MINER PD CONTACTED  KEYHOLDER ADDRESS OF KEYHOLDER 222 HARRISON  TO SEE IF HE HAS KEY TO GATE FOR CLUB HOUSE 11-10-2025 01:07:21|NO FIRE 11-10-2025 01:13:02|JUSTIN KELLER RECONTACTED DOES NOT HAVE  KEY  SAYS HE WILL CONTACT CHRIS HARPER AND KURT EVANS AND HAVE THEM CALL US 11-10-2025 01:30:13|C90 ADVISED THERE IS NO SMOKE NO FIRE THERE WILL BE AN AUIDIBLE  ALARM SOUNDING 11-10-2025 01:30:25|Disposition - SDPS PD:  NRN"
[2025-11-11 15:42:12] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-11 15:42:12] [INFO]   -> Found value: 11-10-2025T00:48:08
[2025-11-11 15:42:12] [INFO]   -> Set field 'alarm' = "2025-10-11 00:48:08"
[2025-11-11 15:42:12] [INFO]   -> Set field 'dispatched' = "2025-10-11 00:48:08"
[2025-11-11 15:42:12] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-11 15:42:12] [INFO]   -> Found value: 11-10-2025T00:52:33
[2025-11-11 15:42:12] [INFO]   -> Set field 'onScene' = "2025-10-11 00:52:33"
[2025-11-11 15:42:12] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-11 15:42:12] [INFO]   -> Found value: 11-10-2025T01:41:19
[2025-11-11 15:42:12] [INFO]   -> Set field 'cleared' = "2025-10-11 01:41:19"
[2025-11-11 15:42:12] [INFO]   -> Set field 'inService' = "2025-10-11 01:41:19"
[2025-11-11 15:42:12] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-11 15:42:12] [INFO]   -> Found value: ENG2
[2025-11-11 15:42:12] [INFO]   -> Set field 'cADVehicleID' = "ENG2"
[2025-11-11 15:42:12] [INFO]   -> Set field 'name' = "ENG2"
[2025-11-11 15:42:12] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-11 15:42:12] [INFO]   -> Found value: 11-10-2025T00:51:21
[2025-11-11 15:42:12] [INFO]   -> Set field 'timeenroutetoscene' = "2025-10-11 00:51:21"
[2025-11-11 15:42:12] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-11 15:42:12] [INFO]   -> Found value: 11-10-2025T00:57:50
[2025-11-11 15:42:12] [INFO]   -> Set field 'timeonscene' = "2025-10-11 00:57:50"
[2025-11-11 15:42:12] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-11 15:42:12] [INFO]   -> Found value: 11-10-2025T01:41:19
[2025-11-11 15:42:12] [INFO]   -> Set field 'timeunitclear' = "2025-10-11 01:41:19"
[2025-11-11 15:42:12] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-11 15:42:12] [INFO]   -> Found value: 11-10-2025T00:51:15
[2025-11-11 15:42:12] [INFO]   -> Set field 'timedispatch' = "2025-10-11 00:51:15"
[2025-11-11 15:42:12] [INFO] Finished extracting fields. Total fields extracted: 23
[2025-11-11 15:42:12] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-26013","incidentLocationStreetNumber":1810,"streetName":"E MALONE AVE","incidentLocationCity":"SIKESTON","businessName":"VFW MEMORIAL STADIUM- SIKESTON","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-ALARM MECH","dispatchNotes":"11-10-2025 00:44:07|FIRE ALARM\nPUMP LINE WATER FLOW\nNO KEYHOLDER \nTETRA PARK CLUB HOUSE \n 11-10-2025 00:51:51|565 ON SCENE SMALL BRICK INDUSTRIAL STRUCTURE NOTHING SHOWING 11-10-2025 00:53:40|C90 ON SCENE WILL HAVE COMMAND 11-10-2025 00:57:11|GATE IS LOCKED 11-10-2025 01:00:26|ATTEMPED KEYHOLDER JUSTIN KELLER NO ANSWER 11-10-2025 01:03:35|ATTEPTED BUSINESS LINE FOR TETRA PAK NO ANSWER 11-10-2025 01:07:18|MINER PD CONTACTED  KEYHOLDER ADDRESS OF KEYHOLDER 222 HARRISON  TO SEE IF HE HAS KEY TO GATE FOR CLUB HOUSE 11-10-2025 01:07:21|NO FIRE 11-10-2025 01:13:02|JUSTIN KELLER RECONTACTED DOES NOT HAVE  KEY  SAYS HE WILL CONTACT CHRIS HARPER AND KURT EVANS AND HAVE THEM CALL US 11-10-2025 01:30:13|C90 ADVISED THERE IS NO SMOKE NO FIRE THERE WILL BE AN AUIDIBLE  ALARM SOUNDING 11-10-2025 01:30:25|Disposition - SDPS PD:  NRN","cADLog":"11-10-2025 00:44:07|FIRE ALARM\nPUMP LINE WATER FLOW\nNO KEYHOLDER \nTETRA PARK CLUB HOUSE \n 11-10-2025 00:51:51|565 ON SCENE SMALL BRICK INDUSTRIAL STRUCTURE NOTHING SHOWING 11-10-2025 00:53:40|C90 ON SCENE WILL HAVE COMMAND 11-10-2025 00:57:11|GATE IS LOCKED 11-10-2025 01:00:26|ATTEMPED KEYHOLDER JUSTIN KELLER NO ANSWER 11-10-2025 01:03:35|ATTEPTED BUSINESS LINE FOR TETRA PAK NO ANSWER 11-10-2025 01:07:18|MINER PD CONTACTED  KEYHOLDER ADDRESS OF KEYHOLDER 222 HARRISON  TO SEE IF HE HAS KEY TO GATE FOR CLUB HOUSE 11-10-2025 01:07:21|NO FIRE 11-10-2025 01:13:02|JUSTIN KELLER RECONTACTED DOES NOT HAVE  KEY  SAYS HE WILL CONTACT CHRIS HARPER AND KURT EVANS AND HAVE THEM CALL US 11-10-2025 01:30:13|C90 ADVISED THERE IS NO SMOKE NO FIRE THERE WILL BE AN AUIDIBLE  ALARM SOUNDING 11-10-2025 01:30:25|Disposition - SDPS PD:  NRN","alarm":"2025-10-11 00:48:08","dispatched":"2025-10-11 00:48:08","onScene":"2025-10-11 00:52:33","cleared":"2025-10-11 01:41:19","inService":"2025-10-11 01:41:19","cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":"2025-10-11 00:51:21","timeonscene":"2025-10-11 00:57:50","timeunitclear":"2025-10-11 01:41:19","timedispatch":"2025-10-11 00:51:15"}
[2025-11-11 15:42:12] [INFO] Number of extracted fields: 23
[2025-11-11 15:42:12] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e872e5ae13
[2025-11-11 15:42:13] [INFO] Created Dispatches record with ID: 69135954acc9d17b8
[2025-11-11 15:42:13] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26013.xml
[2025-11-11 15:42:13] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26013.xml
[2025-11-11 15:42:13] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26035.xml
[2025-11-11 15:42:13] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26035.xml for user: 68d56363ec1209189
[2025-11-11 15:42:13] [INFO] File size: 1949 bytes
[2025-11-11 15:42:17] [INFO] Created FTPFiles record with ID: 69135959ac17460dd
[2025-11-11 15:42:17] [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-11 15:42:17] [INFO] About to extract fields from XML. File size: 1949 bytes
[2025-11-11 15:42:17] [INFO] Number of mappings: 20
[2025-11-11 15:42:17] [INFO] Starting XML parsing. Content length: 1949
[2025-11-11 15:42:17] [INFO] XML parsed successfully. Root element: Incident
[2025-11-11 15:42:17] [INFO] Processing 20 field mappings
[2025-11-11 15:42:17] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-11 15:42:17] [INFO]   -> Found value: 25-26035
[2025-11-11 15:42:17] [INFO]   -> Set field 'dispatchRunNumber' = "25-26035"
[2025-11-11 15:42:17] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-11 15:42:17] [INFO]   -> Found value: 605
[2025-11-11 15:42:17] [INFO]   -> Set field 'incidentLocationStreetNumber' = 605
[2025-11-11 15:42:17] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-11 15:42:17] [INFO]   -> Found value: BRUNT BLVD
[2025-11-11 15:42:17] [INFO]   -> Set field 'streetName' = "BRUNT BLVD"
[2025-11-11 15:42:17] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-11 15:42:17] [INFO]   -> No value found (null or empty)
[2025-11-11 15:42:17] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-11 15:42:17] [INFO]   -> Found value: SIKESTON
[2025-11-11 15:42:17] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-11 15:42:17] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-11 15:42:17] [INFO]   -> Found value: FLORA FARMS
[2025-11-11 15:42:17] [INFO]   -> Set field 'businessName' = "FLORA FARMS"
[2025-11-11 15:42:17] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-11 15:42:17] [INFO]   -> Found value: MO
[2025-11-11 15:42:17] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-11 15:42:17] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-11 15:42:17] [INFO]   -> Found value: 63801
[2025-11-11 15:42:17] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-11 15:42:17] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-11 15:42:17] [INFO]   -> Found value: 0
[2025-11-11 15:42:17] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-11 15:42:17] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-11 15:42:17] [INFO]   -> Found value: 0
[2025-11-11 15:42:17] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-11 15:42:17] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-11 15:42:17] [INFO]   -> Found value: FIRE-ALARM MECH
[2025-11-11 15:42:17] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-ALARM MECH"
[2025-11-11 15:42:17] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-11 15:42:17] [INFO]   -> Found value: 11-10-2025 06:52:30|GENERAL 11-10-2025 06:56:39|CANCEL PER ALARM COMP,SPOKE TO KEYHOLDER AND FALSE A...
[2025-11-11 15:42:17] [INFO]   -> Set field 'dispatchNotes' = "11-10-2025 06:52:30|GENERAL 11-10-2025 06:56:39|CANCEL PER ALARM COMP,SPOKE TO KEYHOLDER AND FALSE ALARM"
[2025-11-11 15:42:17] [INFO]   -> Set field 'cADLog' = "11-10-2025 06:52:30|GENERAL 11-10-2025 06:56:39|CANCEL PER ALARM COMP,SPOKE TO KEYHOLDER AND FALSE ALARM"
[2025-11-11 15:42:17] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-11 15:42:17] [INFO]   -> Found value: 11-10-2025T06:52:38
[2025-11-11 15:42:17] [INFO]   -> Set field 'alarm' = "2025-10-11 06:52:38"
[2025-11-11 15:42:17] [INFO]   -> Set field 'dispatched' = "2025-10-11 06:52:38"
[2025-11-11 15:42:17] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-11 15:42:17] [INFO]   -> No value found (null or empty)
[2025-11-11 15:42:17] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-11 15:42:17] [INFO]   -> No value found (null or empty)
[2025-11-11 15:42:17] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-11 15:42:17] [INFO]   -> Found value: ENG2
[2025-11-11 15:42:17] [INFO]   -> Set field 'cADVehicleID' = "ENG2"
[2025-11-11 15:42:17] [INFO]   -> Set field 'name' = "ENG2"
[2025-11-11 15:42:17] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-11 15:42:17] [INFO]   -> Found value: 11-10-2025T06:54:36
[2025-11-11 15:42:17] [INFO]   -> Set field 'timeenroutetoscene' = "2025-10-11 06:54:36"
[2025-11-11 15:42:17] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-11 15:42:17] [INFO]   -> No value found (null or empty)
[2025-11-11 15:42:17] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-11 15:42:17] [INFO]   -> Found value: 11-10-2025T06:57:11
[2025-11-11 15:42:17] [INFO]   -> Set field 'timeunitclear' = "2025-10-11 06:57:11"
[2025-11-11 15:42:17] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-11 15:42:17] [INFO]   -> Found value: 11-10-2025T06:54:34
[2025-11-11 15:42:17] [INFO]   -> Set field 'timedispatch' = "2025-10-11 06:54:34"
[2025-11-11 15:42:17] [INFO] Finished extracting fields. Total fields extracted: 19
[2025-11-11 15:42:17] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-26035","incidentLocationStreetNumber":605,"streetName":"BRUNT BLVD","incidentLocationCity":"SIKESTON","businessName":"FLORA FARMS","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-ALARM MECH","dispatchNotes":"11-10-2025 06:52:30|GENERAL 11-10-2025 06:56:39|CANCEL PER ALARM COMP,SPOKE TO KEYHOLDER AND FALSE ALARM","cADLog":"11-10-2025 06:52:30|GENERAL 11-10-2025 06:56:39|CANCEL PER ALARM COMP,SPOKE TO KEYHOLDER AND FALSE ALARM","alarm":"2025-10-11 06:52:38","dispatched":"2025-10-11 06:52:38","cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":"2025-10-11 06:54:36","timeunitclear":"2025-10-11 06:57:11","timedispatch":"2025-10-11 06:54:34"}
[2025-11-11 15:42:17] [INFO] Number of extracted fields: 19
[2025-11-11 15:42:22] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e872e5ae13
[2025-11-11 15:42:27] [INFO] Created Dispatches record with ID: 6913596260ccec328
[2025-11-11 15:42:27] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26035.xml
[2025-11-11 15:42:27] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26035.xml
[2025-11-11 15:42:27] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26090.xml
[2025-11-11 15:42:27] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26090.xml for user: 68d56363ec1209189
[2025-11-11 15:42:27] [INFO] File size: 1800 bytes
[2025-11-11 15:42:27] [INFO] Created FTPFiles record with ID: 691359636a80b386b
[2025-11-11 15:42:27] [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-11 15:42:27] [INFO] About to extract fields from XML. File size: 1800 bytes
[2025-11-11 15:42:27] [INFO] Number of mappings: 20
[2025-11-11 15:42:27] [INFO] Starting XML parsing. Content length: 1800
[2025-11-11 15:42:27] [INFO] XML parsed successfully. Root element: Incident
[2025-11-11 15:42:27] [INFO] Processing 20 field mappings
[2025-11-11 15:42:27] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-11 15:42:27] [INFO]   -> Found value: 25-26090
[2025-11-11 15:42:27] [INFO]   -> Set field 'dispatchRunNumber' = "25-26090"
[2025-11-11 15:42:27] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-11 15:42:27] [INFO]   -> Found value: 606
[2025-11-11 15:42:27] [INFO]   -> Set field 'incidentLocationStreetNumber' = 606
[2025-11-11 15:42:27] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-11 15:42:27] [INFO]   -> Found value: TANGLEWOOD
[2025-11-11 15:42:27] [INFO]   -> Set field 'streetName' = "TANGLEWOOD"
[2025-11-11 15:42:27] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-11 15:42:27] [INFO]   -> No value found (null or empty)
[2025-11-11 15:42:27] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-11 15:42:27] [INFO]   -> Found value: SIKESTON
[2025-11-11 15:42:27] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-11 15:42:27] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-11 15:42:27] [INFO]   -> No value found (null or empty)
[2025-11-11 15:42:27] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-11 15:42:27] [INFO]   -> Found value: MO
[2025-11-11 15:42:27] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-11 15:42:27] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-11 15:42:27] [INFO]   -> Found value: 63801
[2025-11-11 15:42:27] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-11 15:42:27] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-11 15:42:27] [INFO]   -> Found value: 0
[2025-11-11 15:42:27] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-11 15:42:27] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-11 15:42:27] [INFO]   -> Found value: 0
[2025-11-11 15:42:27] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-11 15:42:27] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-11 15:42:27] [INFO]   -> Found value: FIRE-ALARM MECH
[2025-11-11 15:42:27] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-ALARM MECH"
[2025-11-11 15:42:27] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-11 15:42:27] [INFO]   -> Found value: 11-10-2025 16:59:06|FIRE ALARM
NO KEYHOLDER
MIKE CONWAY RESIDENCE
NO AREA 11-10-2025 17:03:30|CANCEL...
[2025-11-11 15:42:27] [INFO]   -> Set field 'dispatchNotes' = "11-10-2025 16:59:06|FIRE ALARM\nNO KEYHOLDER\nMIKE CONWAY RESIDENCE\nNO AREA 11-10-2025 17:03:30|CANCEL PER ALARM COMP,PW CORRECT 11-10-2025 17:03:59|542 TWO STORY NOTHING SHOWING"
[2025-11-11 15:42:27] [INFO]   -> Set field 'cADLog' = "11-10-2025 16:59:06|FIRE ALARM\nNO KEYHOLDER\nMIKE CONWAY RESIDENCE\nNO AREA 11-10-2025 17:03:30|CANCEL PER ALARM COMP,PW CORRECT 11-10-2025 17:03:59|542 TWO STORY NOTHING SHOWING"
[2025-11-11 15:42:27] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-11 15:42:27] [INFO]   -> Found value: 11-10-2025T17:00:35
[2025-11-11 15:42:27] [INFO]   -> Set field 'alarm' = "2025-10-11 17:00:35"
[2025-11-11 15:42:27] [INFO]   -> Set field 'dispatched' = "2025-10-11 17:00:35"
[2025-11-11 15:42:27] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-11 15:42:27] [INFO]   -> Found value: 11-10-2025T17:03:41
[2025-11-11 15:42:27] [INFO]   -> Set field 'onScene' = "2025-10-11 17:03:41"
[2025-11-11 15:42:27] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-11 15:42:27] [INFO]   -> Found value: 11-10-2025T17:04:14
[2025-11-11 15:42:27] [INFO]   -> Set field 'cleared' = "2025-10-11 17:04:14"
[2025-11-11 15:42:27] [INFO]   -> Set field 'inService' = "2025-10-11 17:04:14"
[2025-11-11 15:42:27] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-11 15:42:27] [INFO]   -> Found value: ENG2
[2025-11-11 15:42:27] [INFO]   -> Set field 'cADVehicleID' = "ENG2"
[2025-11-11 15:42:27] [INFO]   -> Set field 'name' = "ENG2"
[2025-11-11 15:42:27] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-11 15:42:27] [INFO]   -> Found value: 11-10-2025T17:02:01
[2025-11-11 15:42:27] [INFO]   -> Set field 'timeenroutetoscene' = "2025-10-11 17:02:01"
[2025-11-11 15:42:27] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-11 15:42:27] [INFO]   -> No value found (null or empty)
[2025-11-11 15:42:27] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-11 15:42:27] [INFO]   -> Found value: 11-10-2025T17:04:14
[2025-11-11 15:42:27] [INFO]   -> Set field 'timeunitclear' = "2025-10-11 17:04:14"
[2025-11-11 15:42:27] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-11 15:42:27] [INFO]   -> Found value: 11-10-2025T17:01:59
[2025-11-11 15:42:27] [INFO]   -> Set field 'timedispatch' = "2025-10-11 17:01:59"
[2025-11-11 15:42:27] [INFO] Finished extracting fields. Total fields extracted: 21
[2025-11-11 15:42:27] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-26090","incidentLocationStreetNumber":606,"streetName":"TANGLEWOOD","incidentLocationCity":"SIKESTON","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-ALARM MECH","dispatchNotes":"11-10-2025 16:59:06|FIRE ALARM\nNO KEYHOLDER\nMIKE CONWAY RESIDENCE\nNO AREA 11-10-2025 17:03:30|CANCEL PER ALARM COMP,PW CORRECT 11-10-2025 17:03:59|542 TWO STORY NOTHING SHOWING","cADLog":"11-10-2025 16:59:06|FIRE ALARM\nNO KEYHOLDER\nMIKE CONWAY RESIDENCE\nNO AREA 11-10-2025 17:03:30|CANCEL PER ALARM COMP,PW CORRECT 11-10-2025 17:03:59|542 TWO STORY NOTHING SHOWING","alarm":"2025-10-11 17:00:35","dispatched":"2025-10-11 17:00:35","onScene":"2025-10-11 17:03:41","cleared":"2025-10-11 17:04:14","inService":"2025-10-11 17:04:14","cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":"2025-10-11 17:02:01","timeunitclear":"2025-10-11 17:04:14","timedispatch":"2025-10-11 17:01:59"}
[2025-11-11 15:42:27] [INFO] Number of extracted fields: 21
[2025-11-11 15:42:27] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e872e5ae13
[2025-11-11 15:42:28] [INFO] Created Dispatches record with ID: 691359638bb4fb4dc
[2025-11-11 15:42:28] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26090.xml
[2025-11-11 15:42:28] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26090.xml
[2025-11-11 18:39:44] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26152.xml
[2025-11-11 18:39:44] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26152.xml for user: 68d56363ec1209189
[2025-11-11 18:39:44] [INFO] File size: 2155 bytes
[2025-11-11 18:39:44] [INFO] Created FTPFiles record with ID: 691382f09ae9e0796
[2025-11-11 18:39:44] [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-11 18:39:44] [INFO] About to extract fields from XML. File size: 2155 bytes
[2025-11-11 18:39:44] [INFO] Number of mappings: 20
[2025-11-11 18:39:44] [INFO] Starting XML parsing. Content length: 2155
[2025-11-11 18:39:44] [INFO] XML parsed successfully. Root element: Incident
[2025-11-11 18:39:44] [INFO] Processing 20 field mappings
[2025-11-11 18:39:44] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-11 18:39:44] [INFO]   -> Found value: 25-26152
[2025-11-11 18:39:44] [INFO]   -> Set field 'dispatchRunNumber' = "25-26152"
[2025-11-11 18:39:44] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-11 18:39:44] [INFO]   -> No value found (null or empty)
[2025-11-11 18:39:44] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-11 18:39:44] [INFO]   -> Found value: STATE HWY Z
[2025-11-11 18:39:44] [INFO]   -> Set field 'streetName' = "STATE HWY Z"
[2025-11-11 18:39:44] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-11 18:39:44] [INFO]   -> No value found (null or empty)
[2025-11-11 18:39:44] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-11 18:39:44] [INFO]   -> Found value: CROWDER
[2025-11-11 18:39:44] [INFO]   -> Set field 'incidentLocationCity' = "CROWDER"
[2025-11-11 18:39:44] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-11 18:39:44] [INFO]   -> No value found (null or empty)
[2025-11-11 18:39:44] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-11 18:39:44] [INFO]   -> No value found (null or empty)
[2025-11-11 18:39:44] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-11 18:39:44] [INFO]   -> No value found (null or empty)
[2025-11-11 18:39:44] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-11 18:39:44] [INFO]   -> Found value: 0
[2025-11-11 18:39:44] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-11 18:39:44] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-11 18:39:44] [INFO]   -> Found value: 0
[2025-11-11 18:39:44] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-11 18:39:44] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-11 18:39:44] [INFO]   -> Found value: FIRE-OUT OF TOWN
[2025-11-11 18:39:44] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-OUT OF TOWN"
[2025-11-11 18:39:44] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-11 18:39:44] [INFO]   -> Found value: 11-11-2025 12:18:52|Call Received on 11/11/2025 @ 12:18

FIELD ON FIRE CLOSE TO HOUSE
 11-11-2025 12...
[2025-11-11 18:39:44] [INFO]   -> Set field 'dispatchNotes' = "11-11-2025 12:18:52|Call Received on 11\/11\/2025 @ 12:18\n\nFIELD ON FIRE CLOSE TO HOUSE\n 11-11-2025 12:23:06|BB CLOSED FOR ROAD CONSTRUCTION 11-11-2025 12:25:39|B45 WANTS BRUSH TRUCK FROM MOREHOUSE 11-11-2025 12:26:26|MOREHOUSE PAGED 11-11-2025 12:32:11|20 FT OF GRASS 11-11-2025 12:35:55|FIRE OUT CANCEL ALL UNITS"
[2025-11-11 18:39:44] [INFO]   -> Set field 'cADLog' = "11-11-2025 12:18:52|Call Received on 11\/11\/2025 @ 12:18\n\nFIELD ON FIRE CLOSE TO HOUSE\n 11-11-2025 12:23:06|BB CLOSED FOR ROAD CONSTRUCTION 11-11-2025 12:25:39|B45 WANTS BRUSH TRUCK FROM MOREHOUSE 11-11-2025 12:26:26|MOREHOUSE PAGED 11-11-2025 12:32:11|20 FT OF GRASS 11-11-2025 12:35:55|FIRE OUT CANCEL ALL UNITS"
[2025-11-11 18:39:44] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-11 18:39:44] [INFO]   -> Found value: 11-11-2025T12:22:11
[2025-11-11 18:39:44] [INFO]   -> Set field 'alarm' = "2025-11-11 12:22:11"
[2025-11-11 18:39:44] [INFO]   -> Set field 'dispatched' = "2025-11-11 12:22:11"
[2025-11-11 18:39:44] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-11 18:39:44] [INFO]   -> No value found (null or empty)
[2025-11-11 18:39:44] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-11 18:39:44] [INFO]   -> No value found (null or empty)
[2025-11-11 18:39:44] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-11 18:39:44] [INFO]   -> Found value: ENG3
[2025-11-11 18:39:44] [INFO]   -> Set field 'cADVehicleID' = "ENG3"
[2025-11-11 18:39:44] [INFO]   -> Set field 'name' = "ENG3"
[2025-11-11 18:39:44] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-11 18:39:44] [INFO]   -> Found value: 11-11-2025T12:25:17
[2025-11-11 18:39:44] [INFO]   -> Set field 'timeenroutetoscene' = "2025-11-11 12:25:17"
[2025-11-11 18:39:44] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-11 18:39:44] [INFO]   -> No value found (null or empty)
[2025-11-11 18:39:44] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-11 18:39:44] [INFO]   -> Found value: 11-11-2025T12:39:20
[2025-11-11 18:39:44] [INFO]   -> Set field 'timeunitclear' = "2025-11-11 12:39:20"
[2025-11-11 18:39:44] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-11 18:39:44] [INFO]   -> Found value: 11-11-2025T12:25:15
[2025-11-11 18:39:44] [INFO]   -> Set field 'timedispatch' = "2025-11-11 12:25:15"
[2025-11-11 18:39:44] [INFO] Finished extracting fields. Total fields extracted: 15
[2025-11-11 18:39:44] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-26152","streetName":"STATE HWY Z","incidentLocationCity":"CROWDER","nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-OUT OF TOWN","dispatchNotes":"11-11-2025 12:18:52|Call Received on 11\/11\/2025 @ 12:18\n\nFIELD ON FIRE CLOSE TO HOUSE\n 11-11-2025 12:23:06|BB CLOSED FOR ROAD CONSTRUCTION 11-11-2025 12:25:39|B45 WANTS BRUSH TRUCK FROM MOREHOUSE 11-11-2025 12:26:26|MOREHOUSE PAGED 11-11-2025 12:32:11|20 FT OF GRASS 11-11-2025 12:35:55|FIRE OUT CANCEL ALL UNITS","cADLog":"11-11-2025 12:18:52|Call Received on 11\/11\/2025 @ 12:18\n\nFIELD ON FIRE CLOSE TO HOUSE\n 11-11-2025 12:23:06|BB CLOSED FOR ROAD CONSTRUCTION 11-11-2025 12:25:39|B45 WANTS BRUSH TRUCK FROM MOREHOUSE 11-11-2025 12:26:26|MOREHOUSE PAGED 11-11-2025 12:32:11|20 FT OF GRASS 11-11-2025 12:35:55|FIRE OUT CANCEL ALL UNITS","alarm":"2025-11-11 12:22:11","dispatched":"2025-11-11 12:22:11","cADVehicleID":"ENG3","name":"ENG3","timeenroutetoscene":"2025-11-11 12:25:17","timeunitclear":"2025-11-11 12:39:20","timedispatch":"2025-11-11 12:25:15"}
[2025-11-11 18:39:44] [INFO] Number of extracted fields: 15
[2025-11-11 18:39:44] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e878336f04
[2025-11-11 18:39:45] [INFO] Created Dispatches record with ID: 691382f0c98b65759
[2025-11-11 18:39:45] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26152.xml
[2025-11-11 18:39:45] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26152.xml
