Skip to content

Instantly share code, notes, and snippets.

@arelenglish

arelenglish/bad_file.csv

Created January 5, 2023 00:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save arelenglish/8cc3cd3a2fd25e3687d5561f5fc0c4a2 to your computer and use it in GitHub Desktop.
Save arelenglish/8cc3cd3a2fd25e3687d5561f5fc0c4a2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
bad_file.csv
ForeFlight Logbook Import
Aircraft Table
AircraftID EquipmentType TypeCode Year Make Model Category Class GearType EngineType Complex TAA HighPerformance Pressurized
N1234 aircraft C172 false false false false
Flights Table
Date AircraftID From To Route TimeOut TimeOff TimeOn TimeIn OnDuty OffDuty TotalTime PIC SIC Night Solo CrossCountry NVG NVG Ops Distance DayTakeoffs DayLandingsFullStop NightTakeoffs NightLandingsFullStop AllLandings ActualInstrument SimulatedInstrument HobbsStart HobbsEnd TachStart TachEnd Holds Approach1 Approach2 Approach3 Approach4 Approach5 Approach6 DualGiven DualReceived SimulatedFlight GroundTraining InstructorName InstructorComments Person1 Person2 Person3 Person4 Person5 Person6 FlightReview Checkride IPC NVG Proficiency FAA6158 PilotComments
2021-11-12 N1234 KHPN KPOU 14:25 14:28 14:58 14:59 0.8 0.8 0.0 0.0 0.0 0.0 0.0 0 0.00 1 1 0 0 1 0.0 0.0 0.00 0.00 0.00 0.00 0 0.0 0.0 0.0 0.0 false false false false false
Raw
good_file.csv
ForeFlight Logbook Import
Aircraft Table
AircraftID EquipmentType TypeCode Year Make Model Category Class GearType EngineType Complex TAA HighPerformance Pressurized
N5416B C152 1979 Cessna 152 airplane airplane_single_engine_land fixed_tricycle Piston false false false false
Flights Table
Date AircraftID From To Route TimeOut TimeOff TimeOn TimeIn OnDuty OffDuty TotalTime PIC SIC Night Solo CrossCountry NVG NVG Ops Distance DayTakeoffs DayLandingsFullStop NightTakeoffs NightLandingsFullStop AllLandings ActualInstrument SimulatedInstrument HobbsStart HobbsEnd TachStart TachEnd Holds Approach1 Approach2 Approach3 Approach4 Approach5 Approach6 DualGiven DualReceived SimulatedFlight GroundTraining InstructorName InstructorComments Person1 Person2 Person3 Person4 Person5 Person6 FlightReview Checkride IPC NVG Proficiency FAA6158 PilotComments [Numeric]PF
2022-11-29 N812RR 21N 21N KHWV 2.0 2.0 0.0 0.0 0.0 0.0 0.0 0 0.00 0 0 0 0 0 0.0 0.0 0.00 0.00 0.00 0.00 0 2.0 0.0 0.0 0.0 Jeff Truelove;Student; false false false false false "Practiced eights on pylons, chandelles, and steep spirals. " 0.000000
@tilo
Copy link

tilo commented Dec 24, 2023

@arelenglish There was an issue was with BOM markers in CSV files, see: issue 219.

This issue has been fixed since SmarterCSV version 1.8.0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment