CSV UI import error: Missing expected annotation datatype

What’s missing here? Influx serverless “Upload a CSV” complains with error : “… Missing expected annotation datatype…”

#datatype measurement,tag,tag,tag,double,double,double,double,double,dateTime:number
measurement,floatTag,cycleTag,startTag,lat,lon,p,t,psal,timestamp
profile,0062,001,2023-06-27 12:36:07,19.615,-156.3066,4.3,26.216,34.757,1687875668000005376
profile,0062,001,2023-06-27 12:36:07,19.615,-156.3066,6,26.218,34.757,1687875644999999488

Hello @erehm,
Welcome!
Ooof I hate these errors. They’re always so hard to spot.
Did you create this annotated CSV by hand?

What I like to do is space everything into columns so I can visualize better

measurement,tag,     tag,     tag,       double,      double,     double,       double, double,           dateTime:number
measurement,floatTag,cycleTag,startTag,  lat,         lon,        p,            t,      psal,             timestamp
profile,    0062,    001,     2023-06-27 12:36:07,    19.615,     -156.3066,    4.3,    26.216, 34.757,   1687875668000005376

We can see that you’re missing a column for the other double value and the datatype header

The CSV copy/pasted below uploads fine to the local InfluxDB OSS V2.71 system on my Mac. There are a few errors logged for NaN values in field NCEP_PRES, but all data is otherwise present in my local InfluxDB instance/bucket. I can see the data via the local InfluxDB dashboard (http://localhost:8086) and can query/use it via Flex queries in Grafana. The correct data appear as correct datatypes for measurement, tags, and fields. So, I know the data format and annotation header is correct.

ericrehm$ influx write --bucket FloatTest2 --format csv -f Navis0062_Data_profile_tiny.csv

This same files fails to load via CSV drag and drop on my free Serverless Cloud instance/bucket with the error message below:

Failed to upload the selected CSV: error in csv.from(): failed to read metadata: missing expected annotation datatype. consider using the mode: “raw” for csv that is not expected to have annotations.

Eric Rehm
Sr. Oceanographer
Sea-Bird Scientific

#datatype measurement,tag,unsignedLong,tag,double,double,double,double,double,unsignedLong,double,double,double,unsignedLong,double,double,unsignedLong,double,double,double,double,double,unsignedLong,unsignedLong:dn,unsignedLong,double,double,double,double,double,double,double,double,double,double,dateTime:number
profile,floatTag,cycle,startTag,lon,lat,NCEP_PRES,NCEP_AIRT,NCEP_RH,pindex,p,t,psal,NsamplesCTD,O2ph,O2tV,NsamplesO2,Fl,Bb,Cdm,NsamplesMCOMS,phVrs,NsamplespH,gps_datenum,n_gps_sat,sgth,O2solmLL,O2t,O2mLL,O2uM,O2umolkg,O2sat,pO2,O2uM_gc,pO2_gc,timestamp
profile,0062,1,2023-06-27 12:36:07,-156.3066,19.615,1009.37890625,24.3570495605469,81.9695358276367,1,4.3,26.216,34.757,23,16.6135,0.530939,4,78,462,155,1,-0.77896,4,1687870209999998208,6,1022.78285555129,4.64816415175476,26.2155071396056,4.55248428375846,203.31212711894,0.198783276445665,97.9415557438913,200.995981962045,208.938136809823,206.557899779597,1687875668000005376
profile,0062,1,2023-06-27 12:36:07,-156.3066,19.615,1009.37890625,24.3570495605469,81.9695358276367,2,6,26.218,34.757,33,16.60986,0.530891,7,81,467,155,3,-0.779001,7,1687870209999998208,6,1022.78234864721,4.6480084901746,26.2183375762493,4.55481393978638,203.416168625284,0.198885098960042,97.9949573976636,201.148294080864,209.045057330476,206.714426646787,1687875644999999488
profile,0062,1,2023-06-27 12:36:07,-156.3066,19.615,1009.37890625,24.3570495605469,81.9695358276367,3,8,26.221,34.757,31,16.61233,0.530854,6,78,457,153,2,-0.778972,6,1687870209999998208,6,1022.78154968671,4.6477750152717,26.2205195437928,4.55310609553079,203.339896983967,0.198810681563676,97.9631346304448,201.132960304943,208.966675116616,206.698668557898,1687875612000007680
profile,0062,1,2023-06-27 12:36:07,-156.3066,19.615,1009.37890625,24.3570495605469,81.9695358276367,4,10,26.218,34.757,29,16.61416,0.530913,6,81,463,154,2,-0.778987,6,1687870209999998208,6,1022.78262932726,4.6480084901746,26.2170402613928,4.55261344460318,203.3178953906,0.198788960196101,97.9476146445715,201.153568615141,208.944064699864,206.719847136848,1687875581000004864
profile,0062,1,2023-06-27 12:36:07,-156.3066,19.615,1009.37890625,24.3570495605469,81.9695358276367,5,12,26.219,34.757,32,16.61183,0.53088,6,79,459,152,2,-0.778986,6,1687870209999998208,6,1022.78245659651,4.64793066287811,26.2189862536028,4.5542095115981,203.389175104167,0.198858685727735,97.9835940318874,201.278309206371,209.017316850416,206.848039523035,1687875552000001024
profile,0062,1,2023-06-27 12:36:07,-156.3066,19.615,1009.37890625,24.3570495605469,81.9695358276367,6,14,26.219,34.757,33,16.61486,0.530896,7,79,464,153,2,-0.778995,7,1687870209999998208,6,1022.78259695441,4.64793066287811,26.2180427272981,4.55255015631515,203.315068960972,0.198786203017527,97.9478930844485,201.256230734469,208.94116005788,206.825350100381,1687875520000003584
profile,0062,1,2023-06-27 12:36:07,-156.3066,19.615,1009.37890625,24.3570495605469,81.9695358276367,7,16,26.22,34.757,33,16.615,0.530881,6,81,454,153,3,-0.779019,6,1687870209999998208,6,1022.78242424654,4.64785283791052,26.2189272823854,4.55260996193543,203.317739856052,0.198788847985759,97.9508198883099,201.31310302847,208.943904861396,206.883796152336,1687875487000001792
profile,0062,1,2023-06-27 12:36:07,-156.3066,19.615,1009.37890625,24.3570495605469,81.9695358276367,8,18,26.22,34.757,32,16.61514,0.530864,7,79,455,156,2,-0.778986,7,1687870209999998208,6,1022.7825646202,4.64785283791052,26.2199298080131,4.55264671578463,203.319381268255,0.198790425552234,97.9516106588114,201.366014610699,208.945591694407,206.93817189255,1687875453999999488
profile,0062,1,2023-06-27 12:36:07,-156.3066,19.615,1009.37890625,24.3570495605469,81.9695358276367,9,20,26.224,34.757,34,16.61514,0.530825,7,78,460,153,3,-0.778995,7,1687870209999998208,6,1022.78145270082,4.64754156132665,26.2222298396471,4.55261699390366,203.31805390094,0.198789343866224,97.9575316074011,201.427828119314,208.944227596467,207.001695891353,1687875422000002048
profile,0062,1,2023-06-27 12:36:07,-156.3066,19.615,1009.37890625,24.3570495605469,81.9695358276367,10,22,26.223,34.757,30,16.6175,0.530839,6,80,458,154,2,-0.778986,6,1687870209999998208,6,1022.78190619078,4.64761937697989,26.2214041680498,4.55139328000512,203.263403327717,0.198735822463604,97.9295615847678,201.422029302591,208.888064744272,206.995736611014,1687875388000005376
profile,0062,1,2023-06-27 12:36:07,-156.3066,19.615,1009.37890625,24.3570495605469,81.9695358276367,11,24,26.223,34.757,28,16.6174,0.530871,5,81,483,154,2,-0.778982,5,1687870209999998208,6,1022.78204659914,4.64761937697989,26.2195169995001,4.55200902558915,203.290902279201,0.198762681604712,97.9428102080755,201.500599256786,208.91632464086,207.076480736174,1687875358000007168

Bump, Bump, Bump, Bump.