Menu ▾ ▴

#2789 Always create column names in ASCII tables

nextrelease
open
nobody
None
5
2026-03-02
2026-02-10
Jeremy Faden
No

Here we collect strings which are not converted to column names.

string in file column name units example
1-m AE (nT) (nT) 1_m_AE nT Sadie's file ~/project/rbsp/u/sadie/2026/20260203
SYM/H index (nT) (nT) SYM_H_index nT Sadie's file ~/project/rbsp/u/sadie/2026/20260203
RADON_SHORT_TERM_AVG pCi/L RADON_SHORT_TERM_AVG pCi/L
HUMIDITY % HUMIDITY % file:///home/jbf/data/airthings/misc/3250050508-c0004ae2-9598-4d86-a086-275fb610bc01-iaq.csv?column=field3
TEMP °F TEMP °F file:///home/jbf/data/airthings/misc/3250050508-c0004ae2-9598-4d86-a086-275fb610bc01-iaq.csv?column=field3

Discussion

  • Jeremy Faden

    Jeremy Faden - 2026-02-25

    The first five strings are now supported. Now running Jenkins tests to see what breaks.

     

    Last edit: Jeremy Faden 2026-02-25

  • Jeremy Faden

    Jeremy Faden - 2026-03-02

    Ecobee thermostat report files have column names with spaces, which should be handled:

    #,Thermostat,identifier,263415613960
#,Start,date,2024-03-01
#,End,date,2024-04-01

Date,Time,System Setting,System Mode,Calendar Event,Program Mode,Cool Set Temp (F),Heat Set Temp (F),Current Temp (F),Current Humidity (%RH),Outdoor Temp (F),Wind Speed (km/h),Cool Stage 1 (sec),Cool Stage 2 (sec),Heat Stage 1 (sec),Heat Stage 2 (sec),Aux Heat 1 (sec),Fan (sec),DM Offset
2024-03-01,00:00:00,auto,compressorHeatOff,,Sleep,72,68,68.3,24,34.3,0,0,0,0,0,0,225,,
2024-03-01,00:05:00,auto,compressorHeatOff,,Sleep,72,68,68.3,24,34.3,0,0,0,0,0,0,255,,
2024-03-01,00:10:00,auto,compressorHeatOff,,Sleep,72,68,68.3,24,34.3,0,0,0,0,0,0,270,,
2024-03-01,00:15:00,auto,compressorHeatOff,,Sleep,72,68,68,24,34.3,0,0,0,0,0,0,300,,
     

  • Jeremy Faden

    Jeremy Faden - 2026-03-02

    Spaces are handled. The problem with ecobee files is they have 19 fields in the header and 20 fields in the data. See https://sourceforge.net/p/autoplot/bugs/2806/

     
MongoDB Logo MongoDB