已编辑 作者：EishiFUN
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:ssz
I add this format in my excel file, but I still get the error. Any suggestions?
You need to be logged in to reply to this post and participate in the Geotab Community discussions.
Hello @DGarc-10752 ,
Thank you for asking your question in our community. can you send me a screenshot of what your date time format looks like in your file?
Thank you,
Eishi FUN
已编辑 作者：EishiFUN
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
已编辑 作者：EishiFUN
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
已编辑 作者：EishiFUN
Scheduled
5K 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.68313600001
0
USD
Completed
na
na
na
na
na
Low
na
na
na
na
na
156431
na
Low
na
na
Preventative maintenance
Scheduled
na
na
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 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
Hey @DGarc-10752 I am a bit confused by your messages if you are still having an issue with the date will you send me a screenshot of your template so I can take a look at it?
已编辑 作者：EishiFUN
I have a much large file to import, but I was trying to practice with the first part of it.
Danny Garcia
I attached a copy of the file I attempted to import.
I updated the date and it worked.
Thank you.
I have roughly 1600 records to import.