This month I’m back to it not uploading due to time format issues once more. A time like 10:30:00 is not accepted. Error: “Date/time format incorrect”. I’ve tried forcing removal of any fancy spreadsheet formatting by saving it from notepad, but no joy. (My spreadsheet program on this machine is Libre Calc).
Example not uploading:
file_start/
,
ec5_uuid,created_at,uploaded_at,title,1_Initials,2_Sample_site_ID,lat_3_Sample_site_locati,long_3_Sample_site_locati,accuracy_3_Sample_site_locati,UTM_Northing_3_Sample_site_locati,UTM_Easting_3_Sample_site_locati,UTM_Zone_3_Sample_site_locati,5_Date_sample_taken,6_Time_sample_taken,7_Turbidity_NTU,8_Electrical_conduct,9_Temperature_c,10_Nitrate_test_stri,11_Nitrite_test_stri,12_How_are_you_measu,13_Phosphate_test_st,14_Phosphate_Hanna_C,15_Fixed_point_photo,16_Any_other_comment,18_Rainfall_in_the_l,19_Flow_conditions,20_Relative_water_le,21_Fixed_point_water,23_Can_you_see_an_al,24_If_YES_how_big_is,25_Can_you_see_any_o,26_If_YES_please_des,27_Please_take_a_pho
,
,2021-11-10T10:30:00.000Z,JH,63 Wye at Redbrook (Steps by green),51.782478,-2.674231,4,10/11/2021,10:30:00,256,11.7,2,0.3,0.1,No rain,Steady (walking pace),Low,No,No,
,
,2021-11-10T10:30:00.000Z,JH,“17 Bigwell Fishery, Redbrook”,51.782417,-2.666057,4,10/11/2021,10:30:00,517,12,0,3.0,0,No rain,Steady (walking pace),Low,No,No,
,
,2021-11-17T10:30:00.000Z,JH,63 Wye at Redbrook (Steps by green),51.782478,-2.674231,4,17/11/2021,10:30:00,281,10.5,1,1.0,0.07,No rain,Steady (walking pace),Low,1.78,No,No,
,
,
end,
/file_end
OK, with more messing around, I found that there seems to be a right way to force the time cells to adopt an acceptable date format… select cell(s), format>cell>time>hh/mm/ss etc. -if right click to start the process doesn’t do it, use the menu from the ribbon… Job done.