Skip to main content

Date and time

Use the Movebank Timestamp attribute to specify the date and time fields and their format in your file. To open the import options, choose the Timestamp option from Map Column or from the list of required mappings. Add all fields that include date and time information in your file by selecting the  icon and selecting the columns from the dropdown list. In the Format string field/s, define the format used for your date (e.g., dd/MM/yyyy) and time (e.g., HH:mm:ss) fields. Movebank tries to guess the formats, but does not succeed in all cases, so always check carefully that the format is correct. For a comprehensive overview of possible patterns see here.

In addition to the data format, Movebank will need to know what time zone was used to record the data. Movebank converts all timestamps to UTC (Coordinated Universal Time, approximately equal to Greenwich Mean Time) and needs to know the offset from UTC or local time zone used in the original file. The offset from UTC is positive for areas east of UTC and negative for areas for areas west of UTC. Local time zones can be selected from the IANA Time Zone Database (there is a list of these time zones on Wikipedia).

When you have entered all the information correctly, hit Save. The Timestamp column will be added to the table under How Movebank will save the data, showing the date and time in the format yyyy-MM-dd HH:mm:ss. Compare these timestamps to your original file to confirm the attribute was mapped correctly. Be very careful with verifying the timestamp import, as mistakes may be difficult to notice later.  For example, if you do not have a separator between hours and minutes (e.g. HHmm instead of HH:mm), Movebank cannot know whether the value "923" means "09:23" or "92:30", and thus values under 1000 are likely to be imported incorrectly.

If you need to edit the mapping, select the Timestamp column header to re-open the import options.