[2025-11-07 10:58:37] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25628.xml
[2025-11-07 10:58:37] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25628.xml for user: 68d56363ec1209189
[2025-11-07 10:58:37] [INFO] File size: 1687 bytes
[2025-11-07 10:58:37] [INFO] Created FTPFiles record with ID: 690dd0dd7c1942fc2
[2025-11-07 10:58:37] [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-07 10:58:37] [INFO] About to extract fields from XML. File size: 1687 bytes
[2025-11-07 10:58:37] [INFO] Number of mappings: 20
[2025-11-07 10:58:37] [INFO] Starting XML parsing. Content length: 1687
[2025-11-07 10:58:37] [INFO] XML parsed successfully. Root element: Incident
[2025-11-07 10:58:37] [INFO] Processing 20 field mappings
[2025-11-07 10:58:37] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-07 10:58:37] [INFO]   -> Found value: 25-25628
[2025-11-07 10:58:37] [INFO]   -> Set field 'dispatchRunNumber' = "25-25628"
[2025-11-07 10:58:37] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-07 10:58:37] [INFO]   -> Found value: 1551
[2025-11-07 10:58:37] [INFO]   -> Set field 'incidentLocationStreetNumber' = 1551
[2025-11-07 10:58:37] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-07 10:58:37] [INFO]   -> Found value: W WAKEFIELD AVE
[2025-11-07 10:58:37] [INFO]   -> Set field 'streetName' = "W WAKEFIELD AVE"
[2025-11-07 10:58:37] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-07 10:58:37] [INFO]   -> No value found (null or empty)
[2025-11-07 10:58:37] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-07 10:58:37] [INFO]   -> Found value: SIKESTON
[2025-11-07 10:58:37] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-07 10:58:37] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-07 10:58:37] [INFO]   -> Found value: SIKESTON POWER PLANT
[2025-11-07 10:58:37] [INFO]   -> Set field 'businessName' = "SIKESTON POWER PLANT"
[2025-11-07 10:58:37] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-07 10:58:37] [INFO]   -> Found value: MO
[2025-11-07 10:58:37] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-07 10:58:37] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-07 10:58:37] [INFO]   -> Found value: 63801
[2025-11-07 10:58:37] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-07 10:58:37] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-07 10:58:37] [INFO]   -> Found value: 0
[2025-11-07 10:58:37] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-07 10:58:37] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-07 10:58:37] [INFO]   -> Found value: 0
[2025-11-07 10:58:37] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-07 10:58:37] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-07 10:58:37] [INFO]   -> Found value: FIRE-COAL TRAIN STANDBY
[2025-11-07 10:58:37] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-COAL TRAIN STANDBY"
[2025-11-07 10:58:37] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-07 10:58:37] [INFO]   -> Found value: 11-07-2025 04:13:43|ARRIVING FROM THE NORTH 
 11-07-2025 04:14:46|PAGE
[2025-11-07 10:58:37] [INFO]   -> Set field 'dispatchNotes' = "11-07-2025 04:13:43|ARRIVING FROM THE NORTH \n 11-07-2025 04:14:46|PAGE"
[2025-11-07 10:58:37] [INFO]   -> Set field 'cADLog' = "11-07-2025 04:13:43|ARRIVING FROM THE NORTH \n 11-07-2025 04:14:46|PAGE"
[2025-11-07 10:58:37] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-07 10:58:37] [INFO]   -> Found value: 11-07-2025T04:15:33
[2025-11-07 10:58:37] [INFO]   -> Set field 'alarm' = "2025-07-11 04:15:33"
[2025-11-07 10:58:37] [INFO]   -> Set field 'dispatched' = "2025-07-11 04:15:33"
[2025-11-07 10:58:37] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-07 10:58:37] [INFO]   -> Found value: 11-07-2025T04:18:19
[2025-11-07 10:58:37] [INFO]   -> Set field 'onScene' = "2025-07-11 04:18:19"
[2025-11-07 10:58:37] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-07 10:58:37] [INFO]   -> Found value: 11-07-2025T04:57:44
[2025-11-07 10:58:37] [INFO]   -> Set field 'cleared' = "2025-07-11 04:57:44"
[2025-11-07 10:58:37] [INFO]   -> Set field 'inService' = "2025-07-11 04:57:44"
[2025-11-07 10:58:37] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-07 10:58:37] [INFO]   -> Found value: SIK STILL
[2025-11-07 10:58:37] [INFO]   -> Set field 'cADVehicleID' = "SIK STILL"
[2025-11-07 10:58:37] [INFO]   -> Set field 'name' = "SIK STILL"
[2025-11-07 10:58:37] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-07 10:58:37] [INFO]   -> No value found (null or empty)
[2025-11-07 10:58:37] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-07 10:58:37] [INFO]   -> No value found (null or empty)
[2025-11-07 10:58:37] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-07 10:58:37] [INFO]   -> Found value: 11-07-2025T04:57:44
[2025-11-07 10:58:37] [INFO]   -> Set field 'timeunitclear' = "2025-07-11 04:57:44"
[2025-11-07 10:58:37] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-07 10:58:37] [INFO]   -> Found value: 11-07-2025T04:15:33
[2025-11-07 10:58:37] [INFO]   -> Set field 'timedispatch' = "2025-07-11 04:15:33"
[2025-11-07 10:58:37] [INFO] Finished extracting fields. Total fields extracted: 21
[2025-11-07 10:58:37] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-25628","incidentLocationStreetNumber":1551,"streetName":"W WAKEFIELD AVE","incidentLocationCity":"SIKESTON","businessName":"SIKESTON POWER PLANT","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-COAL TRAIN STANDBY","dispatchNotes":"11-07-2025 04:13:43|ARRIVING FROM THE NORTH \n 11-07-2025 04:14:46|PAGE","cADLog":"11-07-2025 04:13:43|ARRIVING FROM THE NORTH \n 11-07-2025 04:14:46|PAGE","alarm":"2025-07-11 04:15:33","dispatched":"2025-07-11 04:15:33","onScene":"2025-07-11 04:18:19","cleared":"2025-07-11 04:57:44","inService":"2025-07-11 04:57:44","cADVehicleID":"SIK STILL","name":"SIK STILL","timeunitclear":"2025-07-11 04:57:44","timedispatch":"2025-07-11 04:15:33"}
[2025-11-07 10:58:37] [INFO] Number of extracted fields: 21
[2025-11-07 10:58:37] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e8608a02f9
[2025-11-07 10:58:38] [INFO] Created Dispatches record with ID: 690dd0dd946729160
[2025-11-07 10:58:38] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25628.xml
[2025-11-07 10:58:38] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25628.xml
[2025-11-07 11:25:12] [ERROR] No file path provided.
[2025-11-07 11:25:15] [ERROR] No file path provided.
[2025-11-07 16:47:25] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25655.xml
[2025-11-07 16:47:25] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25655.xml for user: 68d56363ec1209189
[2025-11-07 16:47:25] [INFO] File size: 2176 bytes
[2025-11-07 16:47:25] [INFO] Created FTPFiles record with ID: 690e229d4ab499b78
[2025-11-07 16:47:25] [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-07 16:47:25] [INFO] About to extract fields from XML. File size: 2176 bytes
[2025-11-07 16:47:25] [INFO] Number of mappings: 20
[2025-11-07 16:47:25] [INFO] Starting XML parsing. Content length: 2176
[2025-11-07 16:47:25] [INFO] XML parsed successfully. Root element: Incident
[2025-11-07 16:47:25] [INFO] Processing 20 field mappings
[2025-11-07 16:47:25] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-07 16:47:25] [INFO]   -> Found value: 25-25655
[2025-11-07 16:47:25] [INFO]   -> Set field 'dispatchRunNumber' = "25-25655"
[2025-11-07 16:47:25] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-07 16:47:25] [INFO]   -> Found value: 1010
[2025-11-07 16:47:25] [INFO]   -> Set field 'incidentLocationStreetNumber' = 1010
[2025-11-07 16:47:25] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-07 16:47:25] [INFO]   -> Found value: WILLOW LN
[2025-11-07 16:47:25] [INFO]   -> Set field 'streetName' = "WILLOW LN"
[2025-11-07 16:47:25] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-07 16:47:25] [INFO]   -> No value found (null or empty)
[2025-11-07 16:47:25] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-07 16:47:25] [INFO]   -> Found value: SIKESTON
[2025-11-07 16:47:25] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-07 16:47:25] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-07 16:47:25] [INFO]   -> No value found (null or empty)
[2025-11-07 16:47:25] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-07 16:47:25] [INFO]   -> Found value: MO
[2025-11-07 16:47:25] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-07 16:47:25] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-07 16:47:25] [INFO]   -> Found value: 63801
[2025-11-07 16:47:25] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-07 16:47:25] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-07 16:47:25] [INFO]   -> Found value: 0
[2025-11-07 16:47:25] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-07 16:47:25] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-07 16:47:25] [INFO]   -> Found value: 0
[2025-11-07 16:47:25] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-07 16:47:25] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-07 16:47:25] [INFO]   -> Found value: FIRE-ALARM MECH
[2025-11-07 16:47:25] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-ALARM MECH"
[2025-11-07 16:47:25] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-07 16:47:25] [INFO]   -> Found value: 11-07-2025 10:34:59|FIRE ALARM
SMOKE DETECTOR 
HOMEOWNER STATED EVERTHING WAS FINE UNABLE TO RESET I...
[2025-11-07 16:47:25] [INFO]   -> Set field 'dispatchNotes' = "11-07-2025 10:34:59|FIRE ALARM\nSMOKE DETECTOR \nHOMEOWNER STATED EVERTHING WAS FINE UNABLE TO RESET IN\nHOMEOWNER HUNG UP BEFORE SHE COULD GATHER MORE INFO\n\nGLENDA NORTON 573-471-5280  573-703-2155 11-07-2025 10:43:28|L3 ADVISED ON SCENE, NOTHING SHOWING AT THIS TIME 11-07-2025 10:46:56|LOOSE WIRE, ALARM HAS BEEN RESET"
[2025-11-07 16:47:25] [INFO]   -> Set field 'cADLog' = "11-07-2025 10:34:59|FIRE ALARM\nSMOKE DETECTOR \nHOMEOWNER STATED EVERTHING WAS FINE UNABLE TO RESET IN\nHOMEOWNER HUNG UP BEFORE SHE COULD GATHER MORE INFO\n\nGLENDA NORTON 573-471-5280  573-703-2155 11-07-2025 10:43:28|L3 ADVISED ON SCENE, NOTHING SHOWING AT THIS TIME 11-07-2025 10:46:56|LOOSE WIRE, ALARM HAS BEEN RESET"
[2025-11-07 16:47:25] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-07 16:47:25] [INFO]   -> Found value: 11-07-2025T10:38:39
[2025-11-07 16:47:25] [INFO]   -> Set field 'alarm' = "2025-07-11 10:38:39"
[2025-11-07 16:47:25] [INFO]   -> Set field 'dispatched' = "2025-07-11 10:38:39"
[2025-11-07 16:47:25] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-07 16:47:25] [INFO]   -> Found value: 11-07-2025T10:42:22
[2025-11-07 16:47:25] [INFO]   -> Set field 'onScene' = "2025-07-11 10:42:22"
[2025-11-07 16:47:25] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-07 16:47:25] [INFO]   -> Found value: 11-07-2025T10:47:07
[2025-11-07 16:47:25] [INFO]   -> Set field 'cleared' = "2025-07-11 10:47:07"
[2025-11-07 16:47:25] [INFO]   -> Set field 'inService' = "2025-07-11 10:47:07"
[2025-11-07 16:47:25] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-07 16:47:25] [INFO]   -> Found value: ENG2
[2025-11-07 16:47:25] [INFO]   -> Set field 'cADVehicleID' = "ENG2"
[2025-11-07 16:47:25] [INFO]   -> Set field 'name' = "ENG2"
[2025-11-07 16:47:25] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-07 16:47:25] [INFO]   -> Found value: 11-07-2025T10:40:31
[2025-11-07 16:47:25] [INFO]   -> Set field 'timeenroutetoscene' = "2025-07-11 10:40:31"
[2025-11-07 16:47:25] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-07 16:47:25] [INFO]   -> No value found (null or empty)
[2025-11-07 16:47:25] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-07 16:47:25] [INFO]   -> Found value: 11-07-2025T10:47:07
[2025-11-07 16:47:25] [INFO]   -> Set field 'timeunitclear' = "2025-07-11 10:47:07"
[2025-11-07 16:47:25] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-07 16:47:25] [INFO]   -> No value found (null or empty)
[2025-11-07 16:47:25] [INFO] Finished extracting fields. Total fields extracted: 20
[2025-11-07 16:47:25] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-25655","incidentLocationStreetNumber":1010,"streetName":"WILLOW LN","incidentLocationCity":"SIKESTON","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-ALARM MECH","dispatchNotes":"11-07-2025 10:34:59|FIRE ALARM\nSMOKE DETECTOR \nHOMEOWNER STATED EVERTHING WAS FINE UNABLE TO RESET IN\nHOMEOWNER HUNG UP BEFORE SHE COULD GATHER MORE INFO\n\nGLENDA NORTON 573-471-5280  573-703-2155 11-07-2025 10:43:28|L3 ADVISED ON SCENE, NOTHING SHOWING AT THIS TIME 11-07-2025 10:46:56|LOOSE WIRE, ALARM HAS BEEN RESET","cADLog":"11-07-2025 10:34:59|FIRE ALARM\nSMOKE DETECTOR \nHOMEOWNER STATED EVERTHING WAS FINE UNABLE TO RESET IN\nHOMEOWNER HUNG UP BEFORE SHE COULD GATHER MORE INFO\n\nGLENDA NORTON 573-471-5280  573-703-2155 11-07-2025 10:43:28|L3 ADVISED ON SCENE, NOTHING SHOWING AT THIS TIME 11-07-2025 10:46:56|LOOSE WIRE, ALARM HAS BEEN RESET","alarm":"2025-07-11 10:38:39","dispatched":"2025-07-11 10:38:39","onScene":"2025-07-11 10:42:22","cleared":"2025-07-11 10:47:07","inService":"2025-07-11 10:47:07","cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":"2025-07-11 10:40:31","timeunitclear":"2025-07-11 10:47:07"}
[2025-11-07 16:47:25] [INFO] Number of extracted fields: 20
[2025-11-07 16:47:25] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e872e5ae13
[2025-11-07 16:47:26] [INFO] Created Dispatches record with ID: 690e229d6dda57956
[2025-11-07 16:47:26] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25655.xml
[2025-11-07 16:47:26] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25655.xml
[2025-11-07 16:51:27] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25656.xml
[2025-11-07 16:51:27] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25656.xml for user: 68d56363ec1209189
[2025-11-07 16:51:27] [INFO] File size: 1907 bytes
[2025-11-07 16:51:27] [INFO] Created FTPFiles record with ID: 690e238fdde249042
[2025-11-07 16:51: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-07 16:51:27] [INFO] About to extract fields from XML. File size: 1907 bytes
[2025-11-07 16:51:27] [INFO] Number of mappings: 20
[2025-11-07 16:51:27] [INFO] Starting XML parsing. Content length: 1907
[2025-11-07 16:51:27] [INFO] XML parsed successfully. Root element: Incident
[2025-11-07 16:51:27] [INFO] Processing 20 field mappings
[2025-11-07 16:51:27] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-07 16:51:27] [INFO]   -> Found value: 25-25656
[2025-11-07 16:51:27] [INFO]   -> Set field 'dispatchRunNumber' = "25-25656"
[2025-11-07 16:51:27] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-07 16:51:27] [INFO]   -> Found value: 929
[2025-11-07 16:51:27] [INFO]   -> Set field 'incidentLocationStreetNumber' = 929
[2025-11-07 16:51:27] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-07 16:51:27] [INFO]   -> Found value: LAKE ST
[2025-11-07 16:51:27] [INFO]   -> Set field 'streetName' = "LAKE ST"
[2025-11-07 16:51:27] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-07 16:51:27] [INFO]   -> No value found (null or empty)
[2025-11-07 16:51:27] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-07 16:51:27] [INFO]   -> Found value: SIKESTON
[2025-11-07 16:51:27] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-07 16:51:27] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-07 16:51:27] [INFO]   -> No value found (null or empty)
[2025-11-07 16:51:27] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-07 16:51:27] [INFO]   -> Found value: MO
[2025-11-07 16:51:27] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-07 16:51:27] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-07 16:51:27] [INFO]   -> Found value: 63801
[2025-11-07 16:51:27] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-07 16:51:27] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-07 16:51:27] [INFO]   -> Found value: 0
[2025-11-07 16:51:27] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-07 16:51:27] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-07 16:51:27] [INFO]   -> Found value: 0
[2025-11-07 16:51:27] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-07 16:51:27] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-07 16:51:27] [INFO]   -> Found value: CITIZEN ASSISTS-MISC.
[2025-11-07 16:51:27] [INFO]   -> Set field 'incidentTypeValue1' = "CITIZEN ASSISTS-MISC."
[2025-11-07 16:51:27] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-07 16:51:27] [INFO]   -> Found value: 11-07-2025 10:32:32|HER BROTHER OWNS A HOME THAT HAS SQUATER IN IT THEY WERE SERVED AND GIVEN A DATE...
[2025-11-07 16:51:27] [INFO]   -> Set field 'dispatchNotes' = "11-07-2025 10:32:32|HER BROTHER OWNS A HOME THAT HAS SQUATER IN IT THEY WERE SERVED AND GIVEN A DATE OF 10\/16\/2025 \nRP HAS GONE TO THE HOME TO CHECK AN WAS TOLD THEY WERE NOT LEAVING\nHOME OWNER IS IN ICU ST FRANCIS AFTER A MOTORCYCLE ACCIDENT AND MAY NOT MAKE IT\nRP HAS EVICTION NOTICE IN HAND 11-07-2025 10:39:53|RP IN LOBBY"
[2025-11-07 16:51:27] [INFO]   -> Set field 'cADLog' = "11-07-2025 10:32:32|HER BROTHER OWNS A HOME THAT HAS SQUATER IN IT THEY WERE SERVED AND GIVEN A DATE OF 10\/16\/2025 \nRP HAS GONE TO THE HOME TO CHECK AN WAS TOLD THEY WERE NOT LEAVING\nHOME OWNER IS IN ICU ST FRANCIS AFTER A MOTORCYCLE ACCIDENT AND MAY NOT MAKE IT\nRP HAS EVICTION NOTICE IN HAND 11-07-2025 10:39:53|RP IN LOBBY"
[2025-11-07 16:51:27] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-07 16:51:27] [INFO]   -> Found value: 11-07-2025T10:39:28
[2025-11-07 16:51:27] [INFO]   -> Set field 'alarm' = "2025-07-11 10:39:28"
[2025-11-07 16:51:27] [INFO]   -> Set field 'dispatched' = "2025-07-11 10:39:28"
[2025-11-07 16:51:27] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-07 16:51:27] [INFO]   -> Found value: 11-07-2025T10:45:52
[2025-11-07 16:51:27] [INFO]   -> Set field 'onScene' = "2025-07-11 10:45:52"
[2025-11-07 16:51:27] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-07 16:51:27] [INFO]   -> Found value: 11-07-2025T10:50:40
[2025-11-07 16:51:27] [INFO]   -> Set field 'cleared' = "2025-07-11 10:50:40"
[2025-11-07 16:51:27] [INFO]   -> Set field 'inService' = "2025-07-11 10:50:40"
[2025-11-07 16:51:27] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-07 16:51:27] [INFO]   -> Found value: ENG2
[2025-11-07 16:51:27] [INFO]   -> Set field 'cADVehicleID' = "ENG2"
[2025-11-07 16:51:27] [INFO]   -> Set field 'name' = "ENG2"
[2025-11-07 16:51:27] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-07 16:51:27] [INFO]   -> Found value: 11-07-2025T10:40:13
[2025-11-07 16:51:27] [INFO]   -> Set field 'timeenroutetoscene' = "2025-07-11 10:40:13"
[2025-11-07 16:51:27] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-07 16:51:27] [INFO]   -> No value found (null or empty)
[2025-11-07 16:51:27] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-07 16:51:27] [INFO]   -> Found value: 11-07-2025T10:40:21
[2025-11-07 16:51:27] [INFO]   -> Set field 'timeunitclear' = "2025-07-11 10:40:21"
[2025-11-07 16:51:27] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-07 16:51:27] [INFO]   -> No value found (null or empty)
[2025-11-07 16:51:27] [INFO] Finished extracting fields. Total fields extracted: 20
[2025-11-07 16:51:27] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-25656","incidentLocationStreetNumber":929,"streetName":"LAKE ST","incidentLocationCity":"SIKESTON","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"CITIZEN ASSISTS-MISC.","dispatchNotes":"11-07-2025 10:32:32|HER BROTHER OWNS A HOME THAT HAS SQUATER IN IT THEY WERE SERVED AND GIVEN A DATE OF 10\/16\/2025 \nRP HAS GONE TO THE HOME TO CHECK AN WAS TOLD THEY WERE NOT LEAVING\nHOME OWNER IS IN ICU ST FRANCIS AFTER A MOTORCYCLE ACCIDENT AND MAY NOT MAKE IT\nRP HAS EVICTION NOTICE IN HAND 11-07-2025 10:39:53|RP IN LOBBY","cADLog":"11-07-2025 10:32:32|HER BROTHER OWNS A HOME THAT HAS SQUATER IN IT THEY WERE SERVED AND GIVEN A DATE OF 10\/16\/2025 \nRP HAS GONE TO THE HOME TO CHECK AN WAS TOLD THEY WERE NOT LEAVING\nHOME OWNER IS IN ICU ST FRANCIS AFTER A MOTORCYCLE ACCIDENT AND MAY NOT MAKE IT\nRP HAS EVICTION NOTICE IN HAND 11-07-2025 10:39:53|RP IN LOBBY","alarm":"2025-07-11 10:39:28","dispatched":"2025-07-11 10:39:28","onScene":"2025-07-11 10:45:52","cleared":"2025-07-11 10:50:40","inService":"2025-07-11 10:50:40","cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":"2025-07-11 10:40:13","timeunitclear":"2025-07-11 10:40:21"}
[2025-11-07 16:51:27] [INFO] Number of extracted fields: 20
[2025-11-07 16:51:27] [INFO] Created new IncidentTypeMapping Data: {"cADIncidentType":"CITIZEN ASSISTS-MISC.","saasclientId":"6772cab7157b2ebde","name":"CITIZEN ASSISTS-MISC."}
[2025-11-07 16:51:28] [INFO] Created new IncidentTypeMapping with ID: 690e2390060f812ee
[2025-11-07 16:51:28] [INFO] Created Dispatches record with ID: 690e239012af66f2a
[2025-11-07 16:51:28] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25656.xml
[2025-11-07 16:51:28] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25656.xml
[2025-11-07 20:41:33] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25681.xml
[2025-11-07 20:41:33] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25681.xml for user: 68d56363ec1209189
[2025-11-07 20:41:33] [INFO] File size: 1647 bytes
[2025-11-07 20:41:34] [INFO] Created FTPFiles record with ID: 690e597e0263852ce
[2025-11-07 20:41:34] [INFO] WE ARE HERE {"mappings":{"IncidentNumber":"dispatchRunNumber","house_number":"incidentLocationStreetNumber","street":"streetName","apt":"incidentLocationApt","city":"incidentLocationCity","location_name":"businessName","STATE":"incidentLocationStateName","ZIPCODE":"nERISIncidentPostalCode","LATITUDE":"nERISIncidentLatitude","LONGITUDE":"nERISIncidentLongitude","incident_type":"incidentTypeValue1","commentlist.comment":["dispatchNotes","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-07 20:41:34] [INFO] About to extract fields from XML. File size: 1647 bytes
[2025-11-07 20:41:34] [INFO] Number of mappings: 20
[2025-11-07 20:41:34] [INFO] Starting XML parsing. Content length: 1647
[2025-11-07 20:41:34] [INFO] XML parsed successfully. Root element: Incident
[2025-11-07 20:41:34] [INFO] Processing 20 field mappings
[2025-11-07 20:41:34] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-07 20:41:34] [INFO]   -> Found value: 25-25681
[2025-11-07 20:41:34] [INFO]   -> Set field 'dispatchRunNumber' = "25-25681"
[2025-11-07 20:41:34] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-07 20:41:34] [INFO]   -> Found value: 1008
[2025-11-07 20:41:34] [INFO]   -> Set field 'incidentLocationStreetNumber' = 1008
[2025-11-07 20:41:34] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-07 20:41:34] [INFO]   -> Found value: N MAIN ST
[2025-11-07 20:41:34] [INFO]   -> Set field 'streetName' = "N MAIN ST"
[2025-11-07 20:41:34] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-07 20:41:34] [INFO]   -> No value found (null or empty)
[2025-11-07 20:41:34] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-07 20:41:34] [INFO]   -> Found value: SIKESTON
[2025-11-07 20:41:34] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-07 20:41:34] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-07 20:41:34] [INFO]   -> Found value: MDMC
[2025-11-07 20:41:34] [INFO]   -> Set field 'businessName' = "MDMC"
[2025-11-07 20:41:34] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-07 20:41:34] [INFO]   -> Found value: MO
[2025-11-07 20:41:34] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-07 20:41:34] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-07 20:41:34] [INFO]   -> Found value: 63801
[2025-11-07 20:41:34] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-07 20:41:34] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-07 20:41:34] [INFO]   -> Found value: 0
[2025-11-07 20:41:34] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-07 20:41:34] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-07 20:41:34] [INFO]   -> Found value: 0
[2025-11-07 20:41:34] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-07 20:41:34] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-07 20:41:34] [INFO]   -> Found value: FIRE-AIRCRAFT STANDBY
[2025-11-07 20:41:34] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-AIRCRAFT STANDBY"
[2025-11-07 20:41:34] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-07 20:41:34] [INFO]   -> Found value: 11-07-2025 14:00:14|ETA 11 MINUTES 

AIRVAC 3, MDMC 11-07-2025 14:14:46|2.0 ON SCENE AT HELI PAD
[2025-11-07 20:41:34] [INFO]   -> Set field 'dispatchNotes' = "11-07-2025 14:00:14|ETA 11 MINUTES \n\nAIRVAC 3, MDMC 11-07-2025 14:14:46|2.0 ON SCENE AT HELI PAD"
[2025-11-07 20:41:34] [INFO]   -> Set field 'cADLog' = "11-07-2025 14:00:14|ETA 11 MINUTES \n\nAIRVAC 3, MDMC 11-07-2025 14:14:46|2.0 ON SCENE AT HELI PAD"
[2025-11-07 20:41:34] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-07 20:41:34] [INFO]   -> Found value: 11-07-2025T14:05:32
[2025-11-07 20:41:34] [INFO]   -> Set field 'alarm' = "2025-07-11 14:05:32"
[2025-11-07 20:41:34] [INFO]   -> Set field 'dispatched' = "2025-07-11 14:05:32"
[2025-11-07 20:41:34] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-07 20:41:34] [INFO]   -> No value found (null or empty)
[2025-11-07 20:41:34] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-07 20:41:34] [INFO]   -> No value found (null or empty)
[2025-11-07 20:41:34] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-07 20:41:34] [INFO]   -> Found value: ENG4
[2025-11-07 20:41:34] [INFO]   -> Set field 'cADVehicleID' = "ENG4"
[2025-11-07 20:41:34] [INFO]   -> Set field 'name' = "ENG4"
[2025-11-07 20:41:34] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-07 20:41:34] [INFO]   -> No value found (null or empty)
[2025-11-07 20:41:34] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-07 20:41:34] [INFO]   -> No value found (null or empty)
[2025-11-07 20:41:34] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-07 20:41:34] [INFO]   -> Found value: 11-07-2025T14:07:39
[2025-11-07 20:41:34] [INFO]   -> Set field 'timeunitclear' = "2025-07-11 14:07:39"
[2025-11-07 20:41:34] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-07 20:41:34] [INFO]   -> Found value: 11-07-2025T14:05:52
[2025-11-07 20:41:34] [INFO]   -> Set field 'timedispatch' = "2025-07-11 14:05:52"
[2025-11-07 20:41:34] [INFO] Finished extracting fields. Total fields extracted: 18
[2025-11-07 20:41:34] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-25681","incidentLocationStreetNumber":1008,"streetName":"N MAIN ST","incidentLocationCity":"SIKESTON","businessName":"MDMC","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-AIRCRAFT STANDBY","dispatchNotes":"11-07-2025 14:00:14|ETA 11 MINUTES \n\nAIRVAC 3, MDMC 11-07-2025 14:14:46|2.0 ON SCENE AT HELI PAD","cADLog":"11-07-2025 14:00:14|ETA 11 MINUTES \n\nAIRVAC 3, MDMC 11-07-2025 14:14:46|2.0 ON SCENE AT HELI PAD","alarm":"2025-07-11 14:05:32","dispatched":"2025-07-11 14:05:32","cADVehicleID":"ENG4","name":"ENG4","timeunitclear":"2025-07-11 14:07:39","timedispatch":"2025-07-11 14:05:52"}
[2025-11-07 20:41:34] [INFO] Number of extracted fields: 18
[2025-11-07 20:41:34] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e875662f9c
[2025-11-07 20:41:34] [INFO] Created Dispatches record with ID: 690e597e1db5e5c17
[2025-11-07 20:41:34] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25681.xml
[2025-11-07 20:41:34] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25681.xml
[2025-11-07 21:54:32] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25697.xml
[2025-11-07 21:54:32] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25697.xml for user: 68d56363ec1209189
[2025-11-07 21:54:32] [INFO] File size: 1713 bytes
[2025-11-07 21:54:32] [INFO] Created FTPFiles record with ID: 690e6a98cc6b4a305
[2025-11-07 21:54:32] [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-07 21:54:32] [INFO] About to extract fields from XML. File size: 1713 bytes
[2025-11-07 21:54:32] [INFO] Number of mappings: 20
[2025-11-07 21:54:32] [INFO] Starting XML parsing. Content length: 1713
[2025-11-07 21:54:32] [INFO] XML parsed successfully. Root element: Incident
[2025-11-07 21:54:32] [INFO] Processing 20 field mappings
[2025-11-07 21:54:32] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-07 21:54:32] [INFO]   -> Found value: 25-25697
[2025-11-07 21:54:32] [INFO]   -> Set field 'dispatchRunNumber' = "25-25697"
[2025-11-07 21:54:32] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-07 21:54:32] [INFO]   -> Found value: 1551
[2025-11-07 21:54:32] [INFO]   -> Set field 'incidentLocationStreetNumber' = 1551
[2025-11-07 21:54:32] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-07 21:54:32] [INFO]   -> Found value: W WAKEFIELD AVE
[2025-11-07 21:54:32] [INFO]   -> Set field 'streetName' = "W WAKEFIELD AVE"
[2025-11-07 21:54:32] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-07 21:54:32] [INFO]   -> No value found (null or empty)
[2025-11-07 21:54:32] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-07 21:54:32] [INFO]   -> Found value: SIKESTON
[2025-11-07 21:54:32] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-07 21:54:32] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-07 21:54:32] [INFO]   -> Found value: SIKESTON POWER PLANT
[2025-11-07 21:54:32] [INFO]   -> Set field 'businessName' = "SIKESTON POWER PLANT"
[2025-11-07 21:54:32] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-07 21:54:32] [INFO]   -> Found value: MO
[2025-11-07 21:54:32] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-07 21:54:32] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-07 21:54:32] [INFO]   -> Found value: 63801
[2025-11-07 21:54:32] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-07 21:54:32] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-07 21:54:32] [INFO]   -> Found value: 0
[2025-11-07 21:54:32] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-07 21:54:32] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-07 21:54:32] [INFO]   -> Found value: 0
[2025-11-07 21:54:32] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-07 21:54:32] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-07 21:54:32] [INFO]   -> Found value: FIRE-COAL TRAIN STANDBY
[2025-11-07 21:54:32] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-COAL TRAIN STANDBY"
[2025-11-07 21:54:32] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-07 21:54:32] [INFO]   -> Found value: 11-07-2025 15:48:04|DEPARTING SOUTH 

 11-07-2025 15:51:01|STATION1 ADVISED IN DESIGNIATED AREA
[2025-11-07 21:54:32] [INFO]   -> Set field 'dispatchNotes' = "11-07-2025 15:48:04|DEPARTING SOUTH \n\n 11-07-2025 15:51:01|STATION1 ADVISED IN DESIGNIATED AREA"
[2025-11-07 21:54:32] [INFO]   -> Set field 'cADLog' = "11-07-2025 15:48:04|DEPARTING SOUTH \n\n 11-07-2025 15:51:01|STATION1 ADVISED IN DESIGNIATED AREA"
[2025-11-07 21:54:32] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-07 21:54:32] [INFO]   -> Found value: 11-07-2025T15:49:43
[2025-11-07 21:54:32] [INFO]   -> Set field 'alarm' = "2025-07-11 15:49:43"
[2025-11-07 21:54:32] [INFO]   -> Set field 'dispatched' = "2025-07-11 15:49:43"
[2025-11-07 21:54:32] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-07 21:54:32] [INFO]   -> Found value: 11-07-2025T15:53:42
[2025-11-07 21:54:32] [INFO]   -> Set field 'onScene' = "2025-07-11 15:53:42"
[2025-11-07 21:54:32] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-07 21:54:32] [INFO]   -> Found value: 11-07-2025T15:53:47
[2025-11-07 21:54:32] [INFO]   -> Set field 'cleared' = "2025-07-11 15:53:47"
[2025-11-07 21:54:32] [INFO]   -> Set field 'inService' = "2025-07-11 15:53:47"
[2025-11-07 21:54:32] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-07 21:54:32] [INFO]   -> Found value: SIK STILL
[2025-11-07 21:54:32] [INFO]   -> Set field 'cADVehicleID' = "SIK STILL"
[2025-11-07 21:54:32] [INFO]   -> Set field 'name' = "SIK STILL"
[2025-11-07 21:54:32] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-07 21:54:32] [INFO]   -> No value found (null or empty)
[2025-11-07 21:54:32] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-07 21:54:32] [INFO]   -> No value found (null or empty)
[2025-11-07 21:54:32] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-07 21:54:32] [INFO]   -> Found value: 11-07-2025T15:53:47
[2025-11-07 21:54:32] [INFO]   -> Set field 'timeunitclear' = "2025-07-11 15:53:47"
[2025-11-07 21:54:32] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-07 21:54:32] [INFO]   -> Found value: 11-07-2025T15:49:43
[2025-11-07 21:54:32] [INFO]   -> Set field 'timedispatch' = "2025-07-11 15:49:43"
[2025-11-07 21:54:32] [INFO] Finished extracting fields. Total fields extracted: 21
[2025-11-07 21:54:32] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-25697","incidentLocationStreetNumber":1551,"streetName":"W WAKEFIELD AVE","incidentLocationCity":"SIKESTON","businessName":"SIKESTON POWER PLANT","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-COAL TRAIN STANDBY","dispatchNotes":"11-07-2025 15:48:04|DEPARTING SOUTH \n\n 11-07-2025 15:51:01|STATION1 ADVISED IN DESIGNIATED AREA","cADLog":"11-07-2025 15:48:04|DEPARTING SOUTH \n\n 11-07-2025 15:51:01|STATION1 ADVISED IN DESIGNIATED AREA","alarm":"2025-07-11 15:49:43","dispatched":"2025-07-11 15:49:43","onScene":"2025-07-11 15:53:42","cleared":"2025-07-11 15:53:47","inService":"2025-07-11 15:53:47","cADVehicleID":"SIK STILL","name":"SIK STILL","timeunitclear":"2025-07-11 15:53:47","timedispatch":"2025-07-11 15:49:43"}
[2025-11-07 21:54:32] [INFO] Number of extracted fields: 21
[2025-11-07 21:54:32] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e8608a02f9
[2025-11-07 21:54:33] [INFO] Created Dispatches record with ID: 690e6a98e992e9cf4
[2025-11-07 21:54:33] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25697.xml
[2025-11-07 21:54:33] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-25697.xml