G3X csv file example

[MechaSteve]

I have some flight data I am trying to reformat into a file that fly.garmin will ingest.

Does anyone have an example of a flight log csv file exported from a G3X?

I don't need much, even just the first 4-5 lines should be enough.

 

[Ed_Wischmeyer]

Here you go. I de-identified the first line...
If this isn't readable after mail and everything did their thing, send me your email address.

Ed

#airframe_info log_version="1.00" log_content_version="1.02" product="GDU 460" aircraft_ident="xxx" unit_software_part_number="xxx" software_version="9.21" system_id="xxx" unit="PFD1" airframe_hours="1174.2" engine_hours="1052.4" engine_cycles="12"
Date (yyyy-mm-dd) Time (hh:mm:ss) UTC Time (hh:mm:ss) UTC Offset (hh:mm) Latitude (deg) Longitude (deg) GPS Altitude (ft) GPS Fix Status GPS Time of Week (sec) GPS Ground Speed (kt) GPS Ground Track (deg) GPS Velocity E (m/sec) GPS Velocity N (m/sec) GPS Velocity U (m/sec) Magnetic Heading (deg) GPS PDOP GPS Sats Pressure Altitude (ft) Baro Altitude (ft) Vertical Speed (ft/min) Indicated Airspeed (kt) True Airspeed (kt) Pitch (deg) Roll (deg) Lateral Acceleration (G) Normal Acceleration (G) AOA Cp AOA Selected Heading (deg) Selected Altitude (ft) Selected Vertical Speed (ft/min) Selected Airspeed (kt) Baro Setting (inch Hg) COM Frequency (MHz) NAV Frequency (MHz) Active Nav Source Nav Annunciation Nav Identifier Nav Distance (nm) Nav Bearing (deg) Nav Course (deg) Nav Cross Track Distance (nm) Horizontal CDI Deflection Horizontal CDI Full Scale (ft) Horizontal CDI Scale Vertical CDI Deflection Vertical CDI Full Scale (ft) VNAV CDI Deflection VNAV Altitude (ft) Autopilot State FD Lateral Mode FD Vertical Mode FD Roll Command (deg) FD Pitch Command (deg) FD Altitude (ft) AP Roll Command (deg) AP Pitch Command (deg) AP VS Command (ft/min) AP Altitude Command (ft) AP Roll Torque (%) AP Pitch Torque (%) AP Pitch Trim Motor Magnetic Variation (deg) Outside Air Temp (deg C) Density Altitude (ft) Height Above Ground (ft) Wind Speed (kt) Wind Direction (deg) AHRS Status AHRS Dev (%) Magnetometer Status Network Status Transponder Code Transponder Mode Oil Temp (deg F) Fuel L Qty (gal) Fuel R Qty (gal) Fuel Press (PSI) Oil Press (PSI) RPM Manifold Press (inch Hg) Volts Amps Fuel Flow (gal/hour) CHT1 (deg F) CHT2 (deg F) CHT3 (deg F) CHT4 (deg F) EGT1 (deg F) EGT2 (deg F) EGT3 (deg F) EGT4 (deg F) EVENT (discrete) Engine Power (%) CAS Alert Terrain Alert
Lcl Date Lcl Time UTC Time UTCOfst Latitude Longitude AltGPS GPSfix GndSpd TRK GPSVelE GPSVelN GPSVelU HDG PDOP AltP AltInd VSpd IAS TAS Pitch Roll LatAc NormAc AOA SelHDG SelALT SelVSpd SelIAS Baro COM1 NAV1 NavSrc NavIdent NavDist NavBrg NavCRS NavXTK HCDI VCDI VNAV CDI VNAVAlt MagVar OAT AltD AGL WndSpd WndDr E1 OilT FQty1 FQty2 E1 FPres E1 OilP E1 RPM E1 MAP Volts1 Amps1 E1 FFlow E1 CHT1 E1 CHT2 E1 CHT3 E1 CHT4 E1 EGT1 E1 EGT2 E1 EGT3 E1 EGT4 E1 %Pwr
5/19/23 9:05:02 13:05:02 -04:00 32.1171832 -81.1971601 81 3D 479119.9 0 0 0 -0.02 1.3 8 -93 110 -41 0 0 0.023 1.035 3.044 135 30.14 111.9 GPS1 ENR PFT 7.3 19.6 422 040001F8 A37 A37 53 76 17 14 3.4 77 1030 14.8 14.3 16 4.4 93 90 92 87 945 845 915 895 0 19
5/19/23 9:05:03 13:05:03 -04:00 32.1171809 -81.1971571 79 3D 479120.9 0 0 0 -0.01 1.8 8 -92 109 -23 0 1 0.002 1.042 3.435 135 30.14 111.9 GPS1 ENR PFT 7.3 19.5 421 040001F8 A40 A40 57 76 17 15 3.4 77 1030 14.8 14.3 16 4.4 94 90 93 88 955 850 920 900 0 19

 

[MechaSteve]

This is great!

Thanks, this gave me exactly what I needed. I will post my corrected header row for any poor soul that finds this thread in the future.

 

[MechaSteve]

I finally had more time and data to try this with. I think I have it 95% but something is still not quite right.

Can you send me that data file?

I will DM you my email.

 

[KeithB]

I finally had more time and data to try this with. I think I have it 95% but something is still not quite right.

Can you send me that data file?

I will DM you my email.

Note that Garmin periodically adds data fields, so that a template from last year (or data file) might not match a current one.

 

[MechaSteve]

Based on the file format, I suspect that adding new fields will be relatively flexible. There is a header row with one row for Labels/units and a row for datafield names.
It has to be flexible because different installations will have different fields. For example CHT 1-4 vs 1-6.

I suspect there is simply something wrong in the header rows that is causing the issue.

The solution I have now will will upload to fly.garmin and looks great on the web interface, but there is something wrong with the data.

When I try to open the log on the iPad or iPhone app, the app crashes closed.

I suspect there must be some minor bit of formatting that is missing or incorrect from the file.
When the app tires to load the data, it encounters an error, something is missing or doesn't match the format it expects, throws an exception, that is not handled and the app crashes.