Bulk Upload: Time Format Error (still occurs)

1

Project Name (if applicable, otherwise just type n/a)

Goshawk Broadcast

Question

I am getting errors importing data that contains a time. This problem was reported in 2021 but no solution was actually posted (problem went away). I am trying to add and edit child records. The records contain a date and time field. When I import I always get “Date/time format incorrect” no matter what formats I try.

I have confirmed that the time format settings in the form builder for this field match the format in the imported data. To test this issue I have exported a single child record and imported it again without modification and I still get the error. The imported data is included below.

Imported data:
ec5_uuid,ec5_parent_uuid,created_at,uploaded_at,created_by,title,lat_15_Broadcast_GPS_Coo,long_15_Broadcast_GPS_Coo,accuracy_15_Broadcast_GPS_Coo,UTM_Northing_15_Broadcast_GPS_Coo,UTM_Easting_15_Broadcast_GPS_Coo,UTM_Zone_15_Broadcast_GPS_Coo,16_Route_Name,17_Broadcast_Date,18_Broadcast_Time,19_Calls_Played,20_Response,22_Initial_Response_,23_Departur_Response,24_Response_Notes
e4e34a1b-1cf9-4552-9b7d-d3f3899c2e23,99f64ae2-8500-446c-95cd-5d0e9d6b34d4,2023-06-07T21:14:21.635Z,2025-03-30T14:44:22.000Z,m*******e@gmail.com,“Dufferin/Peel/York 17:13 Goshawk”,43.976743,-79.891265,11,4869887,588926,17T,Dufferin/Peel/York,2023/06/07,17:13,“Alarm Call”,Goshawk,285,

Any help would be appreciated.

I confirm I have read the User Guide at docs.epicollect.net

on

I confirm I have searched for an answer in this community.

on

2

Here is a screen shot of the error

Screenshot 2025-03-30 at 12.06.23 PM
Screenshot 2025-03-30 at 12.06.23 PM1280×376 52.7 KB

4

We cannot reproduce the issue, we are afraid.

no-issue
no-issue2560×1142 159 KB

However, we noticed a few errors in the sample data you pasted. There is an extra comma , at the end, “Dufferin/Peel/York 17:13 Goshawk” and “Alarm Call” should not be wrapped in quotes. (Moreover, we masked the email value for privacy)

This is the sanitised CSV file we uploaded.

test-bulk-upload.csv (595 Bytes)

Also, keep in mind that Excel & Word (if you are using them) like to play with formats, so make sure they do not automatically convert or alter your values before you upload them.

5

Thank you for trying, however, similar to the 2021 post this problem went away by itself after many attempts at different things. I went so far as to create a test project with one form containing a single time field. It did not work either, BUT, after changing the time format from the default to something else, exporting/importing and then changing it back to the default and exporting/importing it suddenly worked! It then worked for all the “real” project as well.