[2025-11-18 02:49:34] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26881.xml
[2025-11-18 02:49:34] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26881.xml for user: 68d56363ec1209189
[2025-11-18 02:49:34] [INFO] File size: 1908 bytes
[2025-11-18 02:49:34] [INFO] Created FTPFiles record with ID: 691bdebe7ad9ee83e
[2025-11-18 02:49: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-18 02:49:34] [INFO] About to extract fields from XML. File size: 1908 bytes
[2025-11-18 02:49:34] [INFO] Number of mappings: 20
[2025-11-18 02:49:34] [INFO] Starting XML parsing. Content length: 1908
[2025-11-18 02:49:34] [INFO] XML parsed successfully. Root element: Incident
[2025-11-18 02:49:34] [INFO] Processing 20 field mappings
[2025-11-18 02:49:34] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-18 02:49:34] [INFO]   -> Found value: 25-26881
[2025-11-18 02:49:34] [INFO]   -> Set field 'dispatchRunNumber' = "25-26881"
[2025-11-18 02:49:34] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-18 02:49:34] [INFO]   -> No value found (null or empty)
[2025-11-18 02:49:34] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-18 02:49:34] [INFO]   -> Found value: I-57 NB MM 0.0
[2025-11-18 02:49:34] [INFO]   -> Set field 'streetName' = "I-57 NB MM 0.0"
[2025-11-18 02:49:34] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-18 02:49:34] [INFO]   -> No value found (null or empty)
[2025-11-18 02:49:34] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-18 02:49:34] [INFO]   -> No value found (null or empty)
[2025-11-18 02:49:34] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-18 02:49:34] [INFO]   -> No value found (null or empty)
[2025-11-18 02:49:34] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-18 02:49:34] [INFO]   -> No value found (null or empty)
[2025-11-18 02:49:34] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-18 02:49:34] [INFO]   -> No value found (null or empty)
[2025-11-18 02:49:34] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-18 02:49:34] [INFO]   -> Found value: 0
[2025-11-18 02:49:34] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-18 02:49:34] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-18 02:49:34] [INFO]   -> Found value: 0
[2025-11-18 02:49:34] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-18 02:49:34] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-18 02:49:34] [INFO]   -> Found value: ACCIDENT-J2
[2025-11-18 02:49:34] [INFO]   -> Set field 'incidentTypeValue1' = "ACCIDENT-J2"
[2025-11-18 02:49:34] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-18 02:49:34] [INFO]   -> Found value: 11-17-2025 19:28:49|SEMI TURNED OVER
UNK IF ANY INJURIES 
  11-17-2025 19:38:26|TERESA WITH SSCA ADV...
[2025-11-18 02:49:34] [INFO]   -> Set field 'dispatchNotes' = "11-17-2025 19:28:49|SEMI TURNED OVER\nUNK IF ANY INJURIES \n  11-17-2025 19:38:26|TERESA WITH SSCA ADVISED SHE WAS CONTACTED BY MISS COUNTY AMBLAUNCE ON SCENE NO INJURYS AND CAN CANCEL 11-17-2025 19:40:05|537 ADVISED SEMI TURNED OVER NO INJURY 11-17-2025 19:54:22|C92 ADVISED JSH ON SCENE 11-17-2025 20:34:10|C92 IS CLEAR 537 STANDBY FOR TRAFFIC"
[2025-11-18 02:49:34] [INFO]   -> Set field 'cADLog' = "11-17-2025 19:28:49|SEMI TURNED OVER\nUNK IF ANY INJURIES \n  11-17-2025 19:38:26|TERESA WITH SSCA ADVISED SHE WAS CONTACTED BY MISS COUNTY AMBLAUNCE ON SCENE NO INJURYS AND CAN CANCEL 11-17-2025 19:40:05|537 ADVISED SEMI TURNED OVER NO INJURY 11-17-2025 19:54:22|C92 ADVISED JSH ON SCENE 11-17-2025 20:34:10|C92 IS CLEAR 537 STANDBY FOR TRAFFIC"
[2025-11-18 02:49:34] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-18 02:49:34] [INFO]   -> Found value: 11-17-2025T19:34:13
[2025-11-18 02:49:34] [ERROR] Error formatting datetime '11-17-2025T19:34:13': Failed to parse time string (11-17-2025T19:34:13) at position 0 (1): Unexpected character
[2025-11-18 02:49:34] [INFO]   -> Set field 'alarm' = null
[2025-11-18 02:49:34] [ERROR] Error formatting datetime '11-17-2025T19:34:13': Failed to parse time string (11-17-2025T19:34:13) at position 0 (1): Unexpected character
[2025-11-18 02:49:34] [INFO]   -> Set field 'dispatched' = null
[2025-11-18 02:49:34] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-18 02:49:34] [INFO]   -> Found value: 11-17-2025T19:39:17
[2025-11-18 02:49:34] [ERROR] Error formatting datetime '11-17-2025T19:39:17': Failed to parse time string (11-17-2025T19:39:17) at position 0 (1): Unexpected character
[2025-11-18 02:49:34] [INFO]   -> Set field 'onScene' = null
[2025-11-18 02:49:34] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-18 02:49:34] [INFO]   -> No value found (null or empty)
[2025-11-18 02:49:34] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-18 02:49:34] [INFO]   -> Found value: ENG2
[2025-11-18 02:49:34] [INFO]   -> Set field 'cADVehicleID' = "ENG2"
[2025-11-18 02:49:34] [INFO]   -> Set field 'name' = "ENG2"
[2025-11-18 02:49:34] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-18 02:49:34] [INFO]   -> Found value: 11-17-2025T19:36:05
[2025-11-18 02:49:34] [ERROR] Error formatting datetime '11-17-2025T19:36:05': Failed to parse time string (11-17-2025T19:36:05) at position 0 (1): Unexpected character
[2025-11-18 02:49:34] [INFO]   -> Set field 'timeenroutetoscene' = null
[2025-11-18 02:49:34] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-18 02:49:34] [INFO]   -> No value found (null or empty)
[2025-11-18 02:49:34] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-18 02:49:34] [INFO]   -> Found value: 11-17-2025T19:50:04
[2025-11-18 02:49:34] [ERROR] Error formatting datetime '11-17-2025T19:50:04': Failed to parse time string (11-17-2025T19:50:04) at position 0 (1): Unexpected character
[2025-11-18 02:49:34] [INFO]   -> Set field 'timeunitclear' = null
[2025-11-18 02:49:34] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-18 02:49:34] [INFO]   -> Found value: 11-17-2025T19:36:02
[2025-11-18 02:49:34] [ERROR] Error formatting datetime '11-17-2025T19:36:02': Failed to parse time string (11-17-2025T19:36:02) at position 0 (1): Unexpected character
[2025-11-18 02:49:34] [INFO]   -> Set field 'timedispatch' = null
[2025-11-18 02:49:34] [INFO] Finished extracting fields. Total fields extracted: 15
[2025-11-18 02:49:34] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-26881","streetName":"I-57 NB MM 0.0","nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"ACCIDENT-J2","dispatchNotes":"11-17-2025 19:28:49|SEMI TURNED OVER\nUNK IF ANY INJURIES \n  11-17-2025 19:38:26|TERESA WITH SSCA ADVISED SHE WAS CONTACTED BY MISS COUNTY AMBLAUNCE ON SCENE NO INJURYS AND CAN CANCEL 11-17-2025 19:40:05|537 ADVISED SEMI TURNED OVER NO INJURY 11-17-2025 19:54:22|C92 ADVISED JSH ON SCENE 11-17-2025 20:34:10|C92 IS CLEAR 537 STANDBY FOR TRAFFIC","cADLog":"11-17-2025 19:28:49|SEMI TURNED OVER\nUNK IF ANY INJURIES \n  11-17-2025 19:38:26|TERESA WITH SSCA ADVISED SHE WAS CONTACTED BY MISS COUNTY AMBLAUNCE ON SCENE NO INJURYS AND CAN CANCEL 11-17-2025 19:40:05|537 ADVISED SEMI TURNED OVER NO INJURY 11-17-2025 19:54:22|C92 ADVISED JSH ON SCENE 11-17-2025 20:34:10|C92 IS CLEAR 537 STANDBY FOR TRAFFIC","alarm":null,"dispatched":null,"onScene":null,"cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":null,"timeunitclear":null,"timedispatch":null}
[2025-11-18 02:49:34] [INFO] Number of extracted fields: 15
[2025-11-18 02:49:34] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e87be42b7c
[2025-11-18 02:49:35] [INFO] Created Dispatches record with ID: 691bdebe99547de9a
[2025-11-18 02:49:35] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26881.xml
[2025-11-18 02:49:35] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26881.xml
[2025-11-18 18:44:26] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26961.xml
[2025-11-18 18:44:26] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26961.xml for user: 68d56363ec1209189
[2025-11-18 18:44:26] [INFO] File size: 1432 bytes
[2025-11-18 18:44:26] [INFO] Created FTPFiles record with ID: 691cbe8a55d6eec4d
[2025-11-18 18:44:26] [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-18 18:44:26] [INFO] About to extract fields from XML. File size: 1432 bytes
[2025-11-18 18:44:26] [INFO] Number of mappings: 20
[2025-11-18 18:44:26] [INFO] Starting XML parsing. Content length: 1432
[2025-11-18 18:44:26] [INFO] XML parsed successfully. Root element: Incident
[2025-11-18 18:44:26] [INFO] Processing 20 field mappings
[2025-11-18 18:44:26] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-18 18:44:26] [INFO]   -> Found value: 25-26961
[2025-11-18 18:44:26] [INFO]   -> Set field 'dispatchRunNumber' = "25-26961"
[2025-11-18 18:44:26] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-18 18:44:26] [INFO]   -> No value found (null or empty)
[2025-11-18 18:44:26] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-18 18:44:26] [INFO]   -> Found value: CAMPANELLA DR
[2025-11-18 18:44:26] [INFO]   -> Set field 'streetName' = "CAMPANELLA DR"
[2025-11-18 18:44:26] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-18 18:44:26] [INFO]   -> No value found (null or empty)
[2025-11-18 18:44:26] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-18 18:44:26] [INFO]   -> Found value: SIKESTON
[2025-11-18 18:44:26] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-18 18:44:26] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-18 18:44:26] [INFO]   -> No value found (null or empty)
[2025-11-18 18:44:26] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-18 18:44:26] [INFO]   -> Found value: MO
[2025-11-18 18:44:26] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-18 18:44:26] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-18 18:44:26] [INFO]   -> Found value: 63801
[2025-11-18 18:44:26] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-18 18:44:26] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-18 18:44:26] [INFO]   -> Found value: 0
[2025-11-18 18:44:26] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-18 18:44:26] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-18 18:44:26] [INFO]   -> Found value: 0
[2025-11-18 18:44:26] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-18 18:44:26] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-18 18:44:26] [INFO]   -> Found value: SEXUAL ASSAULT-MISC.
[2025-11-18 18:44:26] [INFO]   -> Set field 'incidentTypeValue1' = "SEXUAL ASSAULT-MISC."
[2025-11-18 18:44:26] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-18 18:44:26] [INFO]   -> Found value: 11-18-2025 12:39:10|STOLE $500  MADE HER DO SOMETHING SEXUAL ON NOV 8
IN A CAR AT THE COMPLEX
ARMANI...
[2025-11-18 18:44:26] [INFO]   -> Set field 'dispatchNotes' = "11-18-2025 12:39:10|STOLE $500  MADE HER DO SOMETHING SEXUAL ON NOV 8\nIN A CAR AT THE COMPLEX\nARMANI WHITE 11-18-2025 12:43:31|RP IN LOBBY"
[2025-11-18 18:44:26] [INFO]   -> Set field 'cADLog' = "11-18-2025 12:39:10|STOLE $500  MADE HER DO SOMETHING SEXUAL ON NOV 8\nIN A CAR AT THE COMPLEX\nARMANI WHITE 11-18-2025 12:43:31|RP IN LOBBY"
[2025-11-18 18:44:26] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-18 18:44:26] [INFO]   -> Found value: 11-18-2025T12:43:11
[2025-11-18 18:44:26] [ERROR] Error formatting datetime '11-18-2025T12:43:11': Failed to parse time string (11-18-2025T12:43:11) at position 0 (1): Unexpected character
[2025-11-18 18:44:26] [INFO]   -> Set field 'alarm' = null
[2025-11-18 18:44:26] [ERROR] Error formatting datetime '11-18-2025T12:43:11': Failed to parse time string (11-18-2025T12:43:11) at position 0 (1): Unexpected character
[2025-11-18 18:44:26] [INFO]   -> Set field 'dispatched' = null
[2025-11-18 18:44:26] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-18 18:44:26] [INFO]   -> No value found (null or empty)
[2025-11-18 18:44:26] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-18 18:44:26] [INFO]   -> No value found (null or empty)
[2025-11-18 18:44:26] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-18 18:44:26] [INFO]   -> Found value: L3
[2025-11-18 18:44:26] [INFO]   -> Set field 'cADVehicleID' = "L3"
[2025-11-18 18:44:26] [INFO]   -> Set field 'name' = "L3"
[2025-11-18 18:44:26] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-18 18:44:26] [INFO]   -> Found value: 11-18-2025T12:44:04
[2025-11-18 18:44:26] [ERROR] Error formatting datetime '11-18-2025T12:44:04': Failed to parse time string (11-18-2025T12:44:04) at position 0 (1): Unexpected character
[2025-11-18 18:44:26] [INFO]   -> Set field 'timeenroutetoscene' = null
[2025-11-18 18:44:26] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-18 18:44:26] [INFO]   -> No value found (null or empty)
[2025-11-18 18:44:26] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-18 18:44:26] [INFO]   -> Found value: 11-18-2025T12:44:08
[2025-11-18 18:44:26] [ERROR] Error formatting datetime '11-18-2025T12:44:08': Failed to parse time string (11-18-2025T12:44:08) at position 0 (1): Unexpected character
[2025-11-18 18:44:26] [INFO]   -> Set field 'timeunitclear' = null
[2025-11-18 18:44:26] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-18 18:44:26] [INFO]   -> No value found (null or empty)
[2025-11-18 18:44:26] [INFO] Finished extracting fields. Total fields extracted: 16
[2025-11-18 18:44:26] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-26961","streetName":"CAMPANELLA DR","incidentLocationCity":"SIKESTON","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"SEXUAL ASSAULT-MISC.","dispatchNotes":"11-18-2025 12:39:10|STOLE $500  MADE HER DO SOMETHING SEXUAL ON NOV 8\nIN A CAR AT THE COMPLEX\nARMANI WHITE 11-18-2025 12:43:31|RP IN LOBBY","cADLog":"11-18-2025 12:39:10|STOLE $500  MADE HER DO SOMETHING SEXUAL ON NOV 8\nIN A CAR AT THE COMPLEX\nARMANI WHITE 11-18-2025 12:43:31|RP IN LOBBY","alarm":null,"dispatched":null,"cADVehicleID":"L3","name":"L3","timeenroutetoscene":null,"timeunitclear":null}
[2025-11-18 18:44:26] [INFO] Number of extracted fields: 16
[2025-11-18 18:44:26] [INFO] Created new IncidentTypeMapping Data: {"cADIncidentType":"SEXUAL ASSAULT-MISC.","saasclientId":"6772cab7157b2ebde","name":"SEXUAL ASSAULT-MISC."}
[2025-11-18 18:44:26] [INFO] Created new IncidentTypeMapping with ID: 691cbe8a7740e0c0a
[2025-11-18 18:44:27] [INFO] Created Dispatches record with ID: 691cbe8a8bb852669
[2025-11-18 18:44:27] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26961.xml
[2025-11-18 18:44:27] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26961.xml
[2025-11-18 18:49:29] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26960.xml
[2025-11-18 18:49:29] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26960.xml for user: 68d56363ec1209189
[2025-11-18 18:49:29] [INFO] File size: 1781 bytes
[2025-11-18 18:49:29] [INFO] Created FTPFiles record with ID: 691cbfb9e4795de2e
[2025-11-18 18:49:29] [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-18 18:49:29] [INFO] About to extract fields from XML. File size: 1781 bytes
[2025-11-18 18:49:29] [INFO] Number of mappings: 20
[2025-11-18 18:49:29] [INFO] Starting XML parsing. Content length: 1781
[2025-11-18 18:49:29] [INFO] XML parsed successfully. Root element: Incident
[2025-11-18 18:49:29] [INFO] Processing 20 field mappings
[2025-11-18 18:49:29] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-18 18:49:29] [INFO]   -> Found value: 25-26960
[2025-11-18 18:49:29] [INFO]   -> Set field 'dispatchRunNumber' = "25-26960"
[2025-11-18 18:49:29] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-18 18:49:29] [INFO]   -> Found value: 313
[2025-11-18 18:49:29] [INFO]   -> Set field 'incidentLocationStreetNumber' = 313
[2025-11-18 18:49:29] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-18 18:49:29] [INFO]   -> Found value: BROADWAY ST
[2025-11-18 18:49:29] [INFO]   -> Set field 'streetName' = "BROADWAY ST"
[2025-11-18 18:49:29] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-18 18:49:29] [INFO]   -> No value found (null or empty)
[2025-11-18 18:49:29] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-18 18:49:29] [INFO]   -> Found value: SIKESTON
[2025-11-18 18:49:29] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-18 18:49:29] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-18 18:49:29] [INFO]   -> No value found (null or empty)
[2025-11-18 18:49:29] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-18 18:49:29] [INFO]   -> Found value: MO
[2025-11-18 18:49:29] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-18 18:49:29] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-18 18:49:29] [INFO]   -> Found value: 63801
[2025-11-18 18:49:29] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-18 18:49:29] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-18 18:49:29] [INFO]   -> Found value: 0
[2025-11-18 18:49:29] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-18 18:49:29] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-18 18:49:29] [INFO]   -> Found value: 0
[2025-11-18 18:49:29] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-18 18:49:29] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-18 18:49:29] [INFO]   -> Found value: FIRE-ALARM MECH
[2025-11-18 18:49:29] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-ALARM MECH"
[2025-11-18 18:49:29] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-18 18:49:29] [INFO]   -> Found value: 11-18-2025 12:40:00|FIRE ALARM 
ZONE 9, SMOKE DECT

KEYHOLDER PAMELA WALLS 573-902-8223

NOT RESPOND...
[2025-11-18 18:49:29] [INFO]   -> Set field 'dispatchNotes' = "11-18-2025 12:40:00|FIRE ALARM \nZONE 9, SMOKE DECT\n\nKEYHOLDER PAMELA WALLS 573-902-8223\n\nNOT RESPONDING  11-18-2025 12:44:31|B45 ON SCENE, SINGLE STORY BUILDING, NOTHING SHOWING AT THIS TIME 11-18-2025 12:45:00|Disposition - SDPS PD:  NRN"
[2025-11-18 18:49:29] [INFO]   -> Set field 'cADLog' = "11-18-2025 12:40:00|FIRE ALARM \nZONE 9, SMOKE DECT\n\nKEYHOLDER PAMELA WALLS 573-902-8223\n\nNOT RESPONDING  11-18-2025 12:44:31|B45 ON SCENE, SINGLE STORY BUILDING, NOTHING SHOWING AT THIS TIME 11-18-2025 12:45:00|Disposition - SDPS PD:  NRN"
[2025-11-18 18:49:29] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-18 18:49:29] [INFO]   -> Found value: 11-18-2025T12:42:18
[2025-11-18 18:49:29] [ERROR] Error formatting datetime '11-18-2025T12:42:18': Failed to parse time string (11-18-2025T12:42:18) at position 0 (1): Unexpected character
[2025-11-18 18:49:29] [INFO]   -> Set field 'alarm' = null
[2025-11-18 18:49:29] [ERROR] Error formatting datetime '11-18-2025T12:42:18': Failed to parse time string (11-18-2025T12:42:18) at position 0 (1): Unexpected character
[2025-11-18 18:49:29] [INFO]   -> Set field 'dispatched' = null
[2025-11-18 18:49:29] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-18 18:49:29] [INFO]   -> No value found (null or empty)
[2025-11-18 18:49:29] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-18 18:49:29] [INFO]   -> No value found (null or empty)
[2025-11-18 18:49:29] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-18 18:49:29] [INFO]   -> Found value: L3
[2025-11-18 18:49:29] [INFO]   -> Set field 'cADVehicleID' = "L3"
[2025-11-18 18:49:29] [INFO]   -> Set field 'name' = "L3"
[2025-11-18 18:49:29] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-18 18:49:29] [INFO]   -> Found value: 11-18-2025T12:44:36
[2025-11-18 18:49:29] [ERROR] Error formatting datetime '11-18-2025T12:44:36': Failed to parse time string (11-18-2025T12:44:36) at position 0 (1): Unexpected character
[2025-11-18 18:49:29] [INFO]   -> Set field 'timeenroutetoscene' = null
[2025-11-18 18:49:29] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-18 18:49:29] [INFO]   -> No value found (null or empty)
[2025-11-18 18:49:29] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-18 18:49:29] [INFO]   -> Found value: 11-18-2025T12:48:53
[2025-11-18 18:49:29] [ERROR] Error formatting datetime '11-18-2025T12:48:53': Failed to parse time string (11-18-2025T12:48:53) at position 0 (1): Unexpected character
[2025-11-18 18:49:29] [INFO]   -> Set field 'timeunitclear' = null
[2025-11-18 18:49:29] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-18 18:49:29] [INFO]   -> No value found (null or empty)
[2025-11-18 18:49:29] [INFO] Finished extracting fields. Total fields extracted: 17
[2025-11-18 18:49:29] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-26960","incidentLocationStreetNumber":313,"streetName":"BROADWAY ST","incidentLocationCity":"SIKESTON","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-ALARM MECH","dispatchNotes":"11-18-2025 12:40:00|FIRE ALARM \nZONE 9, SMOKE DECT\n\nKEYHOLDER PAMELA WALLS 573-902-8223\n\nNOT RESPONDING  11-18-2025 12:44:31|B45 ON SCENE, SINGLE STORY BUILDING, NOTHING SHOWING AT THIS TIME 11-18-2025 12:45:00|Disposition - SDPS PD:  NRN","cADLog":"11-18-2025 12:40:00|FIRE ALARM \nZONE 9, SMOKE DECT\n\nKEYHOLDER PAMELA WALLS 573-902-8223\n\nNOT RESPONDING  11-18-2025 12:44:31|B45 ON SCENE, SINGLE STORY BUILDING, NOTHING SHOWING AT THIS TIME 11-18-2025 12:45:00|Disposition - SDPS PD:  NRN","alarm":null,"dispatched":null,"cADVehicleID":"L3","name":"L3","timeenroutetoscene":null,"timeunitclear":null}
[2025-11-18 18:49:29] [INFO] Number of extracted fields: 17
[2025-11-18 18:49:30] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e872e5ae13
[2025-11-18 18:49:30] [INFO] Created Dispatches record with ID: 691cbfba0eab409ee
[2025-11-18 18:49:30] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26960.xml
[2025-11-18 18:49:30] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26960.xml
[2025-11-18 21:50:55] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26963.xml
[2025-11-18 21:50:55] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26963.xml for user: 68d56363ec1209189
[2025-11-18 21:50:55] [INFO] File size: 2040 bytes
[2025-11-18 21:50:55] [INFO] Created FTPFiles record with ID: 691cea3ff0ad5bd3b
[2025-11-18 21:50:56] [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-18 21:50:56] [INFO] About to extract fields from XML. File size: 2040 bytes
[2025-11-18 21:50:56] [INFO] Number of mappings: 20
[2025-11-18 21:50:56] [INFO] Starting XML parsing. Content length: 2040
[2025-11-18 21:50:56] [INFO] XML parsed successfully. Root element: Incident
[2025-11-18 21:50:56] [INFO] Processing 20 field mappings
[2025-11-18 21:50:56] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-18 21:50:56] [INFO]   -> Found value: 25-26963
[2025-11-18 21:50:56] [INFO]   -> Set field 'dispatchRunNumber' = "25-26963"
[2025-11-18 21:50:56] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-18 21:50:56] [INFO]   -> Found value: 121
[2025-11-18 21:50:56] [INFO]   -> Set field 'incidentLocationStreetNumber' = 121
[2025-11-18 21:50:56] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-18 21:50:56] [INFO]   -> Found value: CRAWFORD ST
[2025-11-18 21:50:56] [INFO]   -> Set field 'streetName' = "CRAWFORD ST"
[2025-11-18 21:50:56] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-18 21:50:56] [INFO]   -> No value found (null or empty)
[2025-11-18 21:50:56] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-18 21:50:56] [INFO]   -> Found value: SIKESTON
[2025-11-18 21:50:56] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-18 21:50:56] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-18 21:50:56] [INFO]   -> No value found (null or empty)
[2025-11-18 21:50:56] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-18 21:50:56] [INFO]   -> No value found (null or empty)
[2025-11-18 21:50:56] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-18 21:50:56] [INFO]   -> No value found (null or empty)
[2025-11-18 21:50:56] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-18 21:50:56] [INFO]   -> Found value: 0
[2025-11-18 21:50:56] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-18 21:50:56] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-18 21:50:56] [INFO]   -> Found value: 0
[2025-11-18 21:50:56] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-18 21:50:56] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-18 21:50:56] [INFO]   -> Found value: FIRE-OUT OF TOWN
[2025-11-18 21:50:56] [INFO]   -> Set field 'incidentTypeValue1' = "FIRE-OUT OF TOWN"
[2025-11-18 21:50:56] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-18 21:50:56] [INFO]   -> Found value: 11-18-2025 13:09:37|GRASS ON FIRE SPREADING TOWARDS RP'S RESIDENCE 
APPROX 70 YARDS FROM RP
SPREADIN...
[2025-11-18 21:50:56] [INFO]   -> Set field 'dispatchNotes' = "11-18-2025 13:09:37|GRASS ON FIRE SPREADING TOWARDS RP'S RESIDENCE \nAPPROX 70 YARDS FROM RP\nSPREADING QUICKLY\nWHITE SMOKE ONLY AT THIS TIME 11-18-2025 13:35:36|Disposition - SSCA:  RPT"
[2025-11-18 21:50:56] [INFO]   -> Set field 'cADLog' = "11-18-2025 13:09:37|GRASS ON FIRE SPREADING TOWARDS RP'S RESIDENCE \nAPPROX 70 YARDS FROM RP\nSPREADING QUICKLY\nWHITE SMOKE ONLY AT THIS TIME 11-18-2025 13:35:36|Disposition - SSCA:  RPT"
[2025-11-18 21:50:56] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-18 21:50:56] [INFO]   -> Found value: 11-18-2025T13:11:52
[2025-11-18 21:50:56] [ERROR] Error formatting datetime '11-18-2025T13:11:52': Failed to parse time string (11-18-2025T13:11:52) at position 0 (1): Unexpected character
[2025-11-18 21:50:56] [INFO]   -> Set field 'alarm' = null
[2025-11-18 21:50:56] [ERROR] Error formatting datetime '11-18-2025T13:11:52': Failed to parse time string (11-18-2025T13:11:52) at position 0 (1): Unexpected character
[2025-11-18 21:50:56] [INFO]   -> Set field 'dispatched' = null
[2025-11-18 21:50:56] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-18 21:50:56] [INFO]   -> Found value: 11-18-2025T13:19:31
[2025-11-18 21:50:56] [ERROR] Error formatting datetime '11-18-2025T13:19:31': Failed to parse time string (11-18-2025T13:19:31) at position 0 (1): Unexpected character
[2025-11-18 21:50:56] [INFO]   -> Set field 'onScene' = null
[2025-11-18 21:50:56] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-18 21:50:56] [INFO]   -> Found value: 11-18-2025T15:49:52
[2025-11-18 21:50:56] [ERROR] Error formatting datetime '11-18-2025T15:49:52': Failed to parse time string (11-18-2025T15:49:52) at position 0 (1): Unexpected character
[2025-11-18 21:50:56] [INFO]   -> Set field 'cleared' = null
[2025-11-18 21:50:56] [ERROR] Error formatting datetime '11-18-2025T15:49:52': Failed to parse time string (11-18-2025T15:49:52) at position 0 (1): Unexpected character
[2025-11-18 21:50:56] [INFO]   -> Set field 'inService' = null
[2025-11-18 21:50:56] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-18 21:50:56] [INFO]   -> Found value: ENG3
[2025-11-18 21:50:56] [INFO]   -> Set field 'cADVehicleID' = "ENG3"
[2025-11-18 21:50:56] [INFO]   -> Set field 'name' = "ENG3"
[2025-11-18 21:50:56] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-18 21:50:56] [INFO]   -> Found value: 11-18-2025T13:13:26
[2025-11-18 21:50:56] [ERROR] Error formatting datetime '11-18-2025T13:13:26': Failed to parse time string (11-18-2025T13:13:26) at position 0 (1): Unexpected character
[2025-11-18 21:50:56] [INFO]   -> Set field 'timeenroutetoscene' = null
[2025-11-18 21:50:56] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-18 21:50:56] [INFO]   -> Found value: 11-18-2025T13:22:40
[2025-11-18 21:50:56] [ERROR] Error formatting datetime '11-18-2025T13:22:40': Failed to parse time string (11-18-2025T13:22:40) at position 0 (1): Unexpected character
[2025-11-18 21:50:56] [INFO]   -> Set field 'timeonscene' = null
[2025-11-18 21:50:56] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-18 21:50:56] [INFO]   -> Found value: 11-18-2025T13:40:00
[2025-11-18 21:50:56] [ERROR] Error formatting datetime '11-18-2025T13:40:00': Failed to parse time string (11-18-2025T13:40:00) at position 0 (1): Unexpected character
[2025-11-18 21:50:56] [INFO]   -> Set field 'timeunitclear' = null
[2025-11-18 21:50:56] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-18 21:50:56] [INFO]   -> No value found (null or empty)
[2025-11-18 21:50:56] [INFO] Finished extracting fields. Total fields extracted: 19
[2025-11-18 21:50:56] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-26963","incidentLocationStreetNumber":121,"streetName":"CRAWFORD ST","incidentLocationCity":"SIKESTON","nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"FIRE-OUT OF TOWN","dispatchNotes":"11-18-2025 13:09:37|GRASS ON FIRE SPREADING TOWARDS RP'S RESIDENCE \nAPPROX 70 YARDS FROM RP\nSPREADING QUICKLY\nWHITE SMOKE ONLY AT THIS TIME 11-18-2025 13:35:36|Disposition - SSCA:  RPT","cADLog":"11-18-2025 13:09:37|GRASS ON FIRE SPREADING TOWARDS RP'S RESIDENCE \nAPPROX 70 YARDS FROM RP\nSPREADING QUICKLY\nWHITE SMOKE ONLY AT THIS TIME 11-18-2025 13:35:36|Disposition - SSCA:  RPT","alarm":null,"dispatched":null,"onScene":null,"cleared":null,"inService":null,"cADVehicleID":"ENG3","name":"ENG3","timeenroutetoscene":null,"timeonscene":null,"timeunitclear":null}
[2025-11-18 21:50:56] [INFO] Number of extracted fields: 19
[2025-11-18 21:50:56] [INFO] Found existing IncidentTypeMapping with ID: 68e4158e878336f04
[2025-11-18 21:50:57] [INFO] Created Dispatches record with ID: 691cea402310ec8b8
[2025-11-18 21:50:57] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26963.xml
[2025-11-18 21:50:57] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26963.xml
[2025-11-18 22:27:24] [INFO] Received file path: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26989.xml
[2025-11-18 22:27:24] [INFO] Processing file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26989.xml for user: 68d56363ec1209189
[2025-11-18 22:27:24] [INFO] File size: 1758 bytes
[2025-11-18 22:27:24] [INFO] Created FTPFiles record with ID: 691cf2cc3f7b8b69f
[2025-11-18 22:27:24] [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-18 22:27:24] [INFO] About to extract fields from XML. File size: 1758 bytes
[2025-11-18 22:27:24] [INFO] Number of mappings: 20
[2025-11-18 22:27:24] [INFO] Starting XML parsing. Content length: 1758
[2025-11-18 22:27:24] [INFO] XML parsed successfully. Root element: Incident
[2025-11-18 22:27:24] [INFO] Processing 20 field mappings
[2025-11-18 22:27:24] [INFO] Mapping #1: Extracting 'IncidentNumber' => 'dispatchRunNumber'
[2025-11-18 22:27:24] [INFO]   -> Found value: 25-26989
[2025-11-18 22:27:24] [INFO]   -> Set field 'dispatchRunNumber' = "25-26989"
[2025-11-18 22:27:24] [INFO] Mapping #2: Extracting 'house_number' => 'incidentLocationStreetNumber'
[2025-11-18 22:27:24] [INFO]   -> No value found (null or empty)
[2025-11-18 22:27:24] [INFO] Mapping #3: Extracting 'street' => 'streetName'
[2025-11-18 22:27:24] [INFO]   -> Found value: STEPHENS
[2025-11-18 22:27:24] [INFO]   -> Set field 'streetName' = "STEPHENS"
[2025-11-18 22:27:24] [INFO] Mapping #4: Extracting 'apt' => 'incidentLocationApt'
[2025-11-18 22:27:24] [INFO]   -> No value found (null or empty)
[2025-11-18 22:27:24] [INFO] Mapping #5: Extracting 'city' => 'incidentLocationCity'
[2025-11-18 22:27:24] [INFO]   -> Found value: SIKESTON
[2025-11-18 22:27:24] [INFO]   -> Set field 'incidentLocationCity' = "SIKESTON"
[2025-11-18 22:27:24] [INFO] Mapping #6: Extracting 'location_name' => 'businessName'
[2025-11-18 22:27:24] [INFO]   -> No value found (null or empty)
[2025-11-18 22:27:24] [INFO] Mapping #7: Extracting 'STATE' => 'incidentLocationStateName'
[2025-11-18 22:27:24] [INFO]   -> Found value: MO
[2025-11-18 22:27:24] [INFO]   -> Set field 'incidentLocationStateName' = "MO"
[2025-11-18 22:27:24] [INFO] Mapping #8: Extracting 'ZIPCODE' => 'nERISIncidentPostalCode'
[2025-11-18 22:27:24] [INFO]   -> Found value: 63801
[2025-11-18 22:27:24] [INFO]   -> Set field 'nERISIncidentPostalCode' = 63801
[2025-11-18 22:27:24] [INFO] Mapping #9: Extracting 'LATITUDE' => 'nERISIncidentLatitude'
[2025-11-18 22:27:24] [INFO]   -> Found value: 0
[2025-11-18 22:27:24] [INFO]   -> Set field 'nERISIncidentLatitude' = null
[2025-11-18 22:27:24] [INFO] Mapping #10: Extracting 'LONGITUDE' => 'nERISIncidentLongitude'
[2025-11-18 22:27:24] [INFO]   -> Found value: 0
[2025-11-18 22:27:24] [INFO]   -> Set field 'nERISIncidentLongitude' = null
[2025-11-18 22:27:24] [INFO] Mapping #11: Extracting 'incident_type' => 'incidentTypeValue1'
[2025-11-18 22:27:24] [INFO]   -> Found value: ENTRAPMENT
[2025-11-18 22:27:24] [INFO]   -> Set field 'incidentTypeValue1' = "ENTRAPMENT"
[2025-11-18 22:27:24] [INFO] Mapping #12: Extracting 'commentlist.comment' => ["dispatchNotes","cADLog"]
[2025-11-18 22:27:24] [INFO]   -> Found value: 11-18-2025 16:20:21|3YOA MALE STUCK IN BABY SWING 11-18-2025 16:25:37|570 ADVISED THEY WERE ABLE TO ...
[2025-11-18 22:27:24] [INFO]   -> Set field 'dispatchNotes' = "11-18-2025 16:20:21|3YOA MALE STUCK IN BABY SWING 11-18-2025 16:25:37|570 ADVISED THEY WERE ABLE TO REMOVE CHILD 11-18-2025 16:25:57|CACNELLED CALL PER 570, CHILD WAS REMOVED FROM SWING"
[2025-11-18 22:27:24] [INFO]   -> Set field 'cADLog' = "11-18-2025 16:20:21|3YOA MALE STUCK IN BABY SWING 11-18-2025 16:25:37|570 ADVISED THEY WERE ABLE TO REMOVE CHILD 11-18-2025 16:25:57|CACNELLED CALL PER 570, CHILD WAS REMOVED FROM SWING"
[2025-11-18 22:27:24] [INFO] Mapping #13: Extracting 'time_first_unit_assigned' => ["alarm","dispatched"]
[2025-11-18 22:27:24] [INFO]   -> Found value: 11-18-2025T16:22:41
[2025-11-18 22:27:24] [ERROR] Error formatting datetime '11-18-2025T16:22:41': Failed to parse time string (11-18-2025T16:22:41) at position 0 (1): Unexpected character
[2025-11-18 22:27:24] [INFO]   -> Set field 'alarm' = null
[2025-11-18 22:27:24] [ERROR] Error formatting datetime '11-18-2025T16:22:41': Failed to parse time string (11-18-2025T16:22:41) at position 0 (1): Unexpected character
[2025-11-18 22:27:24] [INFO]   -> Set field 'dispatched' = null
[2025-11-18 22:27:24] [INFO] Mapping #14: Extracting 'time_first_unit_arrived' => 'onScene'
[2025-11-18 22:27:24] [INFO]   -> Found value: 11-18-2025T16:23:40
[2025-11-18 22:27:24] [ERROR] Error formatting datetime '11-18-2025T16:23:40': Failed to parse time string (11-18-2025T16:23:40) at position 0 (1): Unexpected character
[2025-11-18 22:27:24] [INFO]   -> Set field 'onScene' = null
[2025-11-18 22:27:24] [INFO] Mapping #15: Extracting 'time_last_unit_cleared' => ["cleared","inService"]
[2025-11-18 22:27:24] [INFO]   -> Found value: 11-18-2025T16:26:13
[2025-11-18 22:27:24] [ERROR] Error formatting datetime '11-18-2025T16:26:13': Failed to parse time string (11-18-2025T16:26:13) at position 0 (1): Unexpected character
[2025-11-18 22:27:24] [INFO]   -> Set field 'cleared' = null
[2025-11-18 22:27:24] [ERROR] Error formatting datetime '11-18-2025T16:26:13': Failed to parse time string (11-18-2025T16:26:13) at position 0 (1): Unexpected character
[2025-11-18 22:27:24] [INFO]   -> Set field 'inService' = null
[2025-11-18 22:27:24] [INFO] Mapping #16: Extracting 'Units.Unit[0].radio_name' => ["cADVehicleID","name"]
[2025-11-18 22:27:24] [INFO]   -> Found value: ENG2
[2025-11-18 22:27:24] [INFO]   -> Set field 'cADVehicleID' = "ENG2"
[2025-11-18 22:27:24] [INFO]   -> Set field 'name' = "ENG2"
[2025-11-18 22:27:24] [INFO] Mapping #17: Extracting 'Units.Unit[0].time_enroute' => 'timeenroutetoscene'
[2025-11-18 22:27:24] [INFO]   -> Found value: 11-18-2025T16:24:55
[2025-11-18 22:27:24] [ERROR] Error formatting datetime '11-18-2025T16:24:55': Failed to parse time string (11-18-2025T16:24:55) at position 0 (1): Unexpected character
[2025-11-18 22:27:24] [INFO]   -> Set field 'timeenroutetoscene' = null
[2025-11-18 22:27:24] [INFO] Mapping #18: Extracting 'Units.Unit[0].time_arrivedatscene' => 'timeonscene'
[2025-11-18 22:27:24] [INFO]   -> No value found (null or empty)
[2025-11-18 22:27:24] [INFO] Mapping #19: Extracting 'Units.Unit[0].time_depart_scene' => 'timeunitclear'
[2025-11-18 22:27:24] [INFO]   -> Found value: 11-18-2025T16:26:13
[2025-11-18 22:27:24] [ERROR] Error formatting datetime '11-18-2025T16:26:13': Failed to parse time string (11-18-2025T16:26:13) at position 0 (1): Unexpected character
[2025-11-18 22:27:24] [INFO]   -> Set field 'timeunitclear' = null
[2025-11-18 22:27:24] [INFO] Mapping #20: Extracting 'Units.Unit[0].time_assigned' => 'timedispatch'
[2025-11-18 22:27:24] [INFO]   -> No value found (null or empty)
[2025-11-18 22:27:24] [INFO] Finished extracting fields. Total fields extracted: 19
[2025-11-18 22:27:24] [INFO] Extracted parsing rules data: {"dispatchRunNumber":"25-26989","streetName":"STEPHENS","incidentLocationCity":"SIKESTON","incidentLocationStateName":"MO","nERISIncidentPostalCode":63801,"nERISIncidentLatitude":null,"nERISIncidentLongitude":null,"incidentTypeValue1":"ENTRAPMENT","dispatchNotes":"11-18-2025 16:20:21|3YOA MALE STUCK IN BABY SWING 11-18-2025 16:25:37|570 ADVISED THEY WERE ABLE TO REMOVE CHILD 11-18-2025 16:25:57|CACNELLED CALL PER 570, CHILD WAS REMOVED FROM SWING","cADLog":"11-18-2025 16:20:21|3YOA MALE STUCK IN BABY SWING 11-18-2025 16:25:37|570 ADVISED THEY WERE ABLE TO REMOVE CHILD 11-18-2025 16:25:57|CACNELLED CALL PER 570, CHILD WAS REMOVED FROM SWING","alarm":null,"dispatched":null,"onScene":null,"cleared":null,"inService":null,"cADVehicleID":"ENG2","name":"ENG2","timeenroutetoscene":null,"timeunitclear":null}
[2025-11-18 22:27:24] [INFO] Number of extracted fields: 19
[2025-11-18 22:27:24] [INFO] Created new IncidentTypeMapping Data: {"cADIncidentType":"ENTRAPMENT","saasclientId":"6772cab7157b2ebde","name":"ENTRAPMENT"}
[2025-11-18 22:27:24] [INFO] Created new IncidentTypeMapping with ID: 691cf2cc6733d30ec
[2025-11-18 22:27:25] [INFO] Created Dispatches record with ID: 691cf2cc7bbd7b64b
[2025-11-18 22:27:25] [INFO] Successfully deleted file: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26989.xml
[2025-11-18 22:27:25] [INFO] File processed successfully: /home/dodom2/public_html/ftp.stationboss.net/dispatch/68d56363ec1209189/SDPSFD_25-26989.xml