I have data in an excel spreadsheet that I need to import into Geotab.  I am having trouble with the date/time format.  The error message I get requires the format to be in the following:yyyy-mm-ddTHH:mm:sszI add this format in my excel file, but I still get the error.  Any suggestions?

MyGeotab Data import format issue

I want to create reports that automatically daily, weekly, bi-weekly, and monthly.  Is this possible?

MyGeotab Report automation

Can MyGeotab reports be automated?

page-user page-user-daniel-garcia-10752 template-account-profile page-status-200 theme-harmony user-guest

Company

Title

I updated the date and it worked. Thank you.I have roughly 1600 records to import.

I attached a copy of the file I attempted to import.<a href="/forum/plugins/gcs-uploads/files/069Pd000018tk5EIAQ.xlsx" target="_blank"> 069Pd000018tk5EIAQ.xlsx</a>

I have a much large file to import, but I was trying to practice with the first part of it.Danny Garcia

Scheduled5K Oil change - F150(b433)(b437)Mon May 20 2024 19:00:00 GMT-0500 (Central Daylight Time)Mon May 20 2024 19:00:00 GMT-0500 (Central Daylight Time)56196.683136000010USDCompletednananananaLownanananana156431naLownanaPreventative maintenanceSchedulednanana The date must follow the ISO 8601 format (YYYY-MM-DDTHH:mm:ssZ). For example: 2024-11-30T13:35:00Z The date must follow the ISO 8601 format (YYYY-MM-DDTHH:mm:ssZ). For example: 2024-11-30T13:35:00Z The user with the following identifier does not exist: na. The zone with the following name does not exist: na. The date must follow the ISO 8601 format (YYYY-MM-DDTHH:mm:ssZ). For example: 2024-11-30T13:35:00Z The date must follow the ISO 8601 format (YYYY-MM-DDTHH:mm:ssZ). For example: 2024-11-30T13:35:00Z The date must follow the ISO 8601 format (YYYY-MM-DDTHH:mm:ssZ). For example: 2024-11-30T13:35:00Z The VMRS System Code does not exist.Danny Garcia

The date must follow the ISO 8601 format (YYYY-MM-DDTHH:mm:ssZ). For example: 2024-11-30T13:35:00Z The date must follow the ISO 8601 format (YYYY-MM-DDTHH:mm:ssZ). For example: 2024-11-30T13:35:00Z The user with the following identifier does not exist: na. The zone with the following name does not exist: na. The date must follow the ISO 8601 format (YYYY-MM-DDTHH:mm:ssZ). For example: 2024-11-30T13:35:00Z The date must follow the ISO 8601 format (YYYY-MM-DDTHH:mm:ssZ). For example: 2024-11-30T13:35:00Z The date must follow the ISO 8601 format (YYYY-MM-DDTHH:mm:ssZ). For example: 2024-11-30T13:35:00Z The VMRS System Code does not exist.Danny Garcia

I have tried it where I added the "t" before hh and the "z" after the ss. I am gonna submit it with the date and time and see what it does.Danny Garcia

I have data in an excel spreadsheet that I need to import into Geotab. I am having trouble with the date/time format. The error message I get requires the format to be in the following:yyyy-mm-ddTHH:mm:sszI add this format in my excel file, but I still get the error. Any suggestions?

I want to create reports that automatically daily, weekly, bi-weekly, and monthly. Is this possible?

Nesenās aktivitātes

MyGeotab Data import format issue

MyGeotab Report automation

Can MyGeotab reports be automated?