---
# System prepended metadata

title: 'New test:CAA'

---


# New test:CAA

Airprox:
->  time_utc is 0.53611; -> logged error and no ingest 
-> delecte entire colum as value -> logged error and no ingest -> logged error 2022-04-28T10:22:06.482+01:00


airprox_no,hyperlink,date,day_night,time_utc,latitude,longitude,altitude_ft,risk_category,aircraft_1_flight_classification,aircraft_1_category,aircraft_1_type,aircraft_1_airspace,aircraft_1_airspace_name,aircraft_1_ats,aircraft_1_flight_rules,aircraft_2_flight_classification,aircraft_2_category,aircraft_2_type,aircraft_2_airspace,aircraft_2_airspace_name,aircraft_2_ats,aircraft_2_flight_rules,sector_mix
7777776,https://www.airproxboard.org.uk/uploadedFiles/Content/Standard_content/Airprox_report_files/2020/Airprox Report 2020001.pdf,03-Jan-20,Daylight,52.55000,-2.51667,4100,B,General Aviation,Fixed Wing - Aeroplane,SOCommercial Air TransportA - TB20,G,London FIR,No ATS (ESTABLISHING/MONITORING FREQUENCY),VFR,Unknown ac,Unknown,UNKNOWN,G,London FIR,UNKNOWN,Unknown,GA-Unk ac
7777777,https://www.airproxboard.org.uk/uploadedFiles/Content/Standard_content/Airprox_report_files/2020/Airprox Report 2020001.pdf,03-Jan-20,Daylight,52.55000,-2.51667,4100,B,General Aviation,Fixed Wing - Aeroplane,SOCommercial Air TransportA - TB20,G,London FIR,No ATS (ESTABLISHING/MONITORING FREQUENCY),VFR,Unknown ac,Unknown,UNKNOWN,G,London FIR,UNKNOWN,Unknown,GA-Unk ac


-> Invalid long -> error log 2022-04-28T10:26:06.523+01:00 -> no ingest 
airprox_no,hyperlink,date,day_night,time_utc,latitude,longitude,altitude_ft,risk_category,aircraft_1_flight_classification,aircraft_1_category,aircraft_1_type,aircraft_1_airspace,aircraft_1_airspace_name,aircraft_1_ats,aircraft_1_flight_rules,aircraft_2_flight_classification,aircraft_2_category,aircraft_2_type,aircraft_2_airspace,aircraft_2_airspace_name,aircraft_2_ats,aircraft_2_flight_rules,sector_mix
7777776,https://www.airproxboard.org.uk/uploadedFiles/Content/Standard_content/Airprox_report_files/2020/Airprox Report 2020001.pdf,03-Jan-20,Daylight,0.53611,52.55000,12:52:00,4100,B,General Aviation,Fixed Wing - Aeroplane,SOCommercial Air TransportA - TB20,G,London FIR,No ATS (ESTABLISHING/MONITORING FREQUENCY),VFR,Unknown ac,Unknown,UNKNOWN,G,London FIR,UNKNOWN,Unknown,GA-Unk ac
7777777,https://www.airproxboard.org.uk/uploadedFiles/Content/Standard_content/Airprox_report_files/2020/Airprox Report 2020001.pdf,03-Jan-20,Daylight,0.53611,52.55000,12:52:00,4100,B,General Aviation,Fixed Wing - Aeroplane,SOCommercial Air TransportA - TB20,G,London FIR,No ATS (ESTABLISHING/MONITORING FREQUENCY),VFR,Unknown ac,Unknown,UNKNOWN,G,London FIR,UNKNOWN,Unknown,GA-Unk ac


-> empty columns  -> logged -> not updated 
-> use a string instead of a numer as id -> it works and update the table 
-> time equal to string -> log error 2022-04-28T11:44:59.756+01:00
-> same airprox_id -> error 2022-04-28T11:48:39.800+01:00
-> update two different files with same id -> will overwrite the row with the same id 
-> duplicated row with same id -> error log 2022-04-28T11:59:37.846+01:00

-> wrong latitude -> letter with numbers 2022-04-28 11:59:37
-> word in altitude_ft -> log error 2022-04-28T12:04:17.913+01:00
-> two day_night column but the first one with any string and second one with correct values -> error 2022-04-28T12:07:17.990+01:00

-> column order mixed -> log error -> 2022-04-28T12:25:28.083+01:00 -> it does not get updated 

->add an extra colum(not at the end) -> error log 2022-04-28T12:30:28.163+01:00 -> file is not parsed 

-> extra_colum at the end -> 2022-04-28T12:32:18.171+01:00 -> File could not be parsed

-> insert number instaed of hyperlink -> erro llog 2022-04-28T12:25:28.083+01:00

-> hyperlink = number -> works 
-> empty hyperlink 2022-04-28T12:40:58.243+01:00 -> no valid data 

-> breakline on the file -> error 2022-04-28T12:44:28.249+01:00 -> cpuld not be parsed 

-> drop two files (identical) at the same time it does update 

-> if two file with airprox_id is loaded , and with a different date, only the one with latest date will be recorded;

-> if two file with airprox_id is loaded , and with a different date, only the one with latest date will be recorded-> if only one is duplicate, then for the ones that are not duplicate will upload it 

